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

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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