Re: Do column label and column text have any tie back to the greenscreen?

On 10/22/15 6:24 AM, Luis Rodriguez wrote:

The column labels and text are used by tools like SDA (Screen Design Aid -
a 5250 (green screen) programmin tool), WRKQRY, QM (Query Manager), etc in
order to add a descriptive name to a column.If you have the proper label
you could easily have, say, <Customer Name> versus CUSTOMER_NAME (the
column name)

Also used by such database access utilities as our own QuestView, and the open source WRKDBF, to generate labels. Without them, such tools generally display only the (10-character) field names (and if you're using long field names in an SQL file, they can be quite cryptic).

When I added SQL views to our Wintouch product (collectively called the "New Data Access Layer"), I made sure that I applied them whenever the ones from the PF didn't just get carried through, in order to avoid that.

Simply put, if you're coding for DB2/400, you HAVE to assume that, regardless of how you generated the files, SOMEBODY is bound to want to access them via SQL, SOMEBODY is bound to want to access them via native RLA, and SOMEBODY is going to want to do both, and they're ALL going to want to be able to figure out what it is they're looking at.

--
JHHL