Practical SQL: Defining Your Data: TEXT and LABEL

[Jan]

** This thread discusses the article: Practical SQL: Defining Your Data: TEXT and LABEL **
"With my revised understanding of the relationship between column heading and field text, I will put my default text on the column heading, and specify field text only when it's different."

This works only in DDS, not with DDL (at least on our V6R1M0).

[RingerSoftware]

** This thread discusses the article: Practical SQL: Defining Your Data: TEXT and LABEL **
Hi Joe,

Can you tell us the equivalent of EDTCDE for DDL? I much prefer to control the displayed format of numeric fields in my STRSQL result sets, especially when I have to copy/paste those values into a green screen. Commas are a pain. For example, do we really want customer numbers to display with commas? No. As far as I know, the only way to do this in SQL is to create a view, not with the CREATE TABLE statement. This seems to be a feature DDS has and DDL does not. Thanks much.

Chris Ringer