Re: Maximum number of columns in a sql statement

Paul,

I must be more specific in my question. What is the maximum value the
SQL_NUM can accept in a DESCRIBE TABLE in an embedded SQL statement? I saw
an example 2 months ago with a maximum value of 720 fields but I cannot find
any reference to this limitation and I cannot remember where I found this
example...

Charles

"Paul Morgan" <pmorgan@xxxxxxxxxxxxxx> a écrit dans
le message de news:d9pitt$4du$1@xxxxxxxxxxxxxxxx
> Charles,
>
> Appendix A of the SQL Reference manual.  Version 5.2 has:
>
> Most columns in a table/view - 8000
> Most elements in a select list - approximately 8000
>
> Paul
>
> -- 
> Paul Morgan
> Senior Programmer Analyst - Retail
> J. Jill Group
> 100 Birch Pond Drive, PO Box 2009
> Tilton, NH 03276-2009
> Phone: (603) 266-2117
> Fax:   (603) 266-2333
>
> Charles wrote
>
> My question is not directly related to my program... I read somewhere that
> the maximum of columns that a sql statement can use is 720. I don't
remember
> where I found the text about this limitation. Can you please give me more
> information about that?
>
> Charles St-Laurent
> RPG/400 & RPGLE developer
>
>
>
> -- 
> 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.
>
>