RE: SQL Display differences with 9.21
tabnames are longer in 9.2. Your dbaccess is performing normally, the
output is wrapping.
cheers
j.
> -----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?
>