Re: SQL Display differences with 9.21
Posted in 2000
Topics: Stored Procedures & SPL
Hi. tabname size changed to 128 and it does not fit on one line, so probabily you have to substr it. HTH Bogdan Doug McAllister wrote: > 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?