× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Have you considered using the column headings INSTEAD of the alias?

Then you can change column headings without rebuilding files, and without recompiling pgms.

RUNSQL 'label on test_file1 (custid text is 'testtext')'

Also look at

http://search400.techtarget.com
search for "Add column headings to a CSV file"
author: Herb Bujak January 2003

It automagically builds the excel column headings (for csv file) from a PF or LF column headings and places them in the 1st record (comma delimited).

btw Alias changes or adds do NOT alter the format-id of the file.



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of dale janus
Sent: Tuesday, May 15, 2012 2:13 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: will dds alias keyword cause level checks?

I want to start adding alias names with nice, long, clearly
understandable names. We are dabbling in DDL, but most of our stuff is
DDS. But we are moving to SQL and exporting files as spreadsheets, so
nice clear column names is a good thing.

I must add the alias in DDS because system I navigator only allows me to
change the short name, which I do NOT want to change since that is what
RPG uses.

I am afraid I will get level checks on my rpg programs if I use chgpf
pointing to the new DDS with aliases.

Can anyone confirm or deny level checks before I jump in?

Thanks.

---Dale

IMPORTANT: This email is intended for the use of the individual
addressee(s) named above and may contain information that is
confidential, privileged or unsuitable for overly sensitive persons with
low self-esteem, no sense of humor or irrational religious beliefs. If
you are not the intended recipient, any dissemination, distribution or
copying of this email is not authorized (either explicitly or implicitly)
and constitutes an irritating social faux pas. Unless the word
absquatulation has been used in its correct context somewhere other than
in this warning, it does not have any legal or no grammatical use and may
be ignored. No animals were harmed in the transmission of this email,
although the terrier next door is living on borrowed time, let me tell
you. Those of you with an overwhelming fear of the unknown will be
gratified to learn that there is no hidden message revealed by reading
this warning backwards, so just ignore that Alert Notice from Microsoft.
However, by pouring a complete circle of salt around yourself and your
computer you can ensure that no harm befalls you and your pets. If you
have received this email in error, please add some nutmeg and egg whites,
whisk and place in a warm oven for 40 minutes.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.