Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
Feeling frustrated again with free form DS. I need to convert the following stmt to free from and having quite a time. No IBM examples or other user-based examples.
D ProgramStsDs esds extname(pgmstsds)
Can anyone help again? I would appreciate it.
Thanks
GF
The PSDS is a keyword now, rather than just the S before the "DS". I believe when you also have an external file, you can use the EXTNAME keyword, but you have to quote the file name (always). In addition, you can include everything on one line. The following may work for your example:
DCL-DS PgmSts EXTNAME('PGMSTSDS') PSDS END-DS;
The syntax works great. I had this before but I had the PGMSTSDS extname in camel case which caused a compiler error message that it cant find the definition for PgmStsDS...
"SQL1001 External file definition for PgmStsDS not found."
Duh! It needs to be upper case. I guess frustration had set in.
Sorry for the dumb post but reaching out to the wise ones often sets one straight.
GF