Re: Select statement output format.

From: "Ira Rosen" <irosen1@email.mot.com> > >Recently I upgraded from 7.2.4 to 9.2.1 on Solaris 2.6. Upon testing some >of >my Database access scripts, I noticed that some of the scripts were failing >because the output format had changed for a select statement from column >major to row major format as follows: > >7.2.4 OUTPUT: > >COL1 COL2 >data1.1 data1.2 >data2.1 data2.2 > >Where data1.1 is the data for (row1, column 1) in the desired table, and so >on. > >9.2.1 OUTPUT: > >COL1 data1.1 >COL2 data1.2 > >COL1 data2.1 >COL2 data2.2 > >A specific query that generates these two different output formats for >7.2.4 >versus 9.2.1 using isql is: > select tabname, nrows from systables Try: select tabname[1,18], nrows from systables IDS.2000 allows 128-character table names, hence the change. >After my script executes this query, the script proceeds to parse data >returned by the Informix engine. Therefore the script that was working with >7.2.4 is returning different data when run against 9.2.1 due to the format >change. Is there something I can do (ideally by setting an environment >variable) that would force the 9.2.1 server to revert to the 7.2.4 format >for this output? > >Ira Rosen >Motorola, Inc. > > _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.