Re: Maximum number of columns in a sql statement

Hi!

I tried with a file containing more than 720 fields. The first call of
Describe Table fails to return the right number of fields. So the second
call fails too.

Charles

"Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx> a
écrit dans le message de
news:D351C107947DD042B6C5DF1A02179E39188DD0@xxxxxxxxxxxxxxxxxxxxxxxxxx
> Not trying to avoid the question, but why not just try it. Write a
> program to generate the SQL statement, something along the lines of
>
> Select 1 as Fld_1, 2 as Fld_2, ..., 2500 as Fld_2500, ... 8000 as
> Fld_8000 from qdummy
>
> And try compiling the program.
>
> -Walden
>
> ------------
> Walden H Leverich III
> Tech Software
> (516) 627-3800 x11
> WaldenL@xxxxxxxxxxxxxxx
> http://www.TechSoftInc.com
>
> Quiquid latine dictum sit altum viditur.
> (Whatever is said in Latin seems profound.)
>
>
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>