Please forward this error screen to 108. ODBC in CMS to still have access putty commands tutorial pdf historical and administrative data. Here’s how to do it.
It is the second mode that is of most interest to us. In order to use dbaccess, we need to set up the environment first. CMS uses UTF-8 since time immemorial. INFORMIXDIR should contain path to Informix root directory.
ONCONFIG points to Informix IDS configuration file. To avoid setting all these variables manually every time, Avaya has provided a helper script that is available with CMS R9 and above. Note that there should be one or more spaces between the dot and file name, otherwise the command won’t work. Its main advantage is that you can actually work on the query, fixing errors and perfecting it in several takes without having to save it somewhere else and mess with copy-paste, or type it all over every time which can get really annoying after several attempts at some long query. The other side of dbaccess is more useful if you want to do scripting with it. This command line interface accepts any SQL statement that is supported by Informix database, and more. Yes and file names are so self-explaining, too.
This of course is shell script that can be used in Unix, Linux or Mac OS X. I don’t have Microsoft Office installed in Windows VM but I’m pretty sure this file should have opened in Excel without problems. Of course there can be a lot of settings to tune, but basically it’s there. And it can be very powerful tool indeed: while getting access to CMS data via ODBC is more official and supported by Avaya, setting it up can be a real chore and many people will decide to do without CMS data just to avoid messing with ODBC.
That’s right folks, any ordinary system user can use this approach to offload the data he or she needs in a robust and secure way without even asking anybody! I am not totally sure but applications like Word or Excel may or may not support UTF-8. I don’t have Windows Excel so I have no way of checking it. If you have any trouble with non-Latin characters in data, drop me a line and we’ll try to think up something. All right, that’s it for today. Hope you’ll find this article worth your time.
Using the Unload, how do I also get the field names as part of the resulting file? Great site and great info. There’s probably a way to write an SQL query that will do that but it’ll be messy, with schema retrieval and all. The first part of the command will print the header to a file and the second part will query the actual data and append it to the file. Is there an open source alternative that I could use? Thanks a lot for this great article!
Note the dot is followed by a space, that’s important. Thanks again for the help and the quick reply. I’ll comment again to let you know. Thank you very much again, extremely appreciated! The log files don’t show us any problem and the file is created without problem. Click here to cancel reply.