RE: SQL Display differences with 9.21

Posted in 2000

John Carlson — Mon, 27 Nov 2000 09:43:31 -0500 — source: Informix-list mailing list archive (1991-1998)

My understanding is that various columns like tabname have been lengthened to char(128). -----Original Message----- From: Doug McAllister [mailto:doug.mcallister@nospam.fmr.com] Sent: Monday, November 20, 2000 2:18 PM To: informix-list@iiug.org Subject: SQL Display differences with 9.21 Hi all.. I have gotten some differences with the way SQL works between 7.3x and 9.21 and I wondered if any of you had seen this? I execute the following query: select tabname,nrows from systables where tabname not like 'sys%' and tabname not like ' GL%' and tabname not like ' VERSION' and tabtype not like "V" order by tabname ; And get the following output from 9.21: tabname account_cash nrows 0 tabname account_group nrows 0 tabname alphas nrows 0 tabname amort_yield nrows 0 But when I run the exact same query in 7.31 I get: tabname nrows account_cash 0 account_group 0 alphas 0 amort_yield 0 asal_rest 0 asof_apr_lt 22326 asof_apr_lt_cl 12726 asof_apr_st 26228 asof_apr_st_cl 16189 asof_aug_lt 1186 asof_aug_lt_cl 911 asof_aug_st 643 asof_aug_st_cl 498 asof_feb_lt 16775 As you can see, the resulting rows are identical but I now get a header row for each detail row in 9.21. This really screws up some scripts that I run. Anyone else seen this behavior?

↪ replying to John Carlson

Doug McAllister — Tue, 28 Nov 2000 10:45:02 -0500 — source: Informix-list mailing list archive (1991-1998)

Thanks.... I eventually found that out after I got past first level support who wanted me to: a - re-install all of the software and b - rebuild sysmaster. The answer was select tabname[1,18],nrows............ John Carlson wrote: > > My understanding is that various columns like tabname have been lengthened > to char(128). > > -----Original Message----- > From: Doug McAllister [mailto:doug.mcallister@nospam.fmr.com] > Sent: Monday, November 20, 2000 2:18 PM > To: informix-list@iiug.org > Subject: SQL Display differences with 9.21 > > Hi all.. > > I have gotten some differences with the way SQL works between 7.3x and > 9.21 and I wondered if any of you had seen this? > > I execute the following query: > > select > tabname,nrows > from > systables > where > tabname not like 'sys%' > and tabname not like ' GL%' > and tabname not like ' VERSION' > and tabtype not like "V" > order by tabname > ; > > And get the following output from 9.21: > > tabname account_cash > nrows 0 > > tabname account_group > nrows 0 > > tabname alphas > nrows 0 > > tabname amort_yield > nrows 0 > > But when I run the exact same query in 7.31 I get: > > tabname nrows > > account_cash 0 > account_group 0 > alphas 0 > amort_yield 0 > asal_rest 0 > asof_apr_lt 22326 > asof_apr_lt_cl 12726 > asof_apr_st 26228 > asof_apr_st_cl 16189 > asof_aug_lt 1186 > asof_aug_lt_cl 911 > asof_aug_st 643 > asof_aug_st_cl 498 > asof_feb_lt 16775 > > As you can see, the resulting rows are identical but I now get a header > row for each detail row in 9.21. This really screws up some scripts that > I run. > > Anyone else seen this behavior?