Re: SQL CREATE TABLE: Adding comments text (7.2, 7.3)

Hwy Patrik

Generate_SQL procedure will create what you tell it to - there is a *standards* parameter described as -

The standards option specifies whether the generated SQL statements should contain Db2® for i extensions or whether the statements should conform to the Db2 family SQL or to the ANSI and ISO SQL standards.

The default is 0, which means *Db2 for i extensions may be generated in SQL statements.

*So it can definitely give you the LABEL ON for the table text description, as well as column text descriptions and headings, some of which are extensions, no ANSI or ISO necessarily.

*Regards*

*Vern Hamberg*

<cid:part1.MYLmD177.lyielsNm@centurylink.net>

On 2/4/2025 12:07 PM, Patrik Schindler wrote:

Hello Rob,

Am 04.02.2025 um 18:31 schrieb Rob Berendt<robertowenberendt@xxxxxxxxx>:

Don't forget about decompiling.
Search the documentation at
https://www.ibm.com/docs/en/i/7.5?topic=ssw_ibm_i_75/rzahg/welcome.html
for generate sql

Thanks for the hint. I have a dim memory that has been a topic here before.

Not sure if generate SQL would generate the additional LABEL ON statement, though.

:wq! PoC