AW: CRTSQLRPGI - Is there a way to identify/retrieve the SQL RPG pgmcompiled options?

Hi,

All compile options for SQLRPG-programs, service programs or packages are
listed in the output of the CL-command PRTSQLINF (Print SQL Information);

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them?  Not training them
and keeping them!"


-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von jmoreno@xxxxxxxxxxxxxxxx
Gesendet: Monday, February 12, 2007 18:37
An: RPG400-L@xxxxxxxxxxxx
Betreff: CRTSQLRPGI - Is there a way to identify/retrieve the SQL RPG
pgmcompiled options? 



Hello everyone -

I am sure this question has been posted before and it has to do with the
SQL-RPG compile options

We had a consulting company that has left behind ( ... already done .. and
we cannot change what has been done ...) a number of programs compiled.

We cannot identify the compile options and it is very important to us to
verify the compilation options.

For example -  If the SQL RPG program was compiled and the Date/Time format
options were used in a command string like this one


CRTSQLRPGI OBJ(&UserLibraryName/&ProgramName)
           SRCFILE(&SourceLibraryName/&SourceFileName)
           SRCMBR(&SourceMemberName)
           OBJTYPE(*PGM)
           DATFMT(*ISO)
           DATSEP('-')
           REPLACE(*YES)

How/where can I find the compile options for this object program?

I have dumped the object program, but I do not have an easy way to interpret
the hunbreds of pages worth of information and identify the object program
compile options



Jorge