You have to use *SYS naming to use *LIBL however you simply do *not* qualify the stored procedure:
CALL GENERATE_SQL is all you would need
Thanks,
Tommy Holden
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Thursday, August 17, 2017 10:37 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: GENERATE_SQL doesn't like object_library = *LIBL
I am using the SQL procedure GENERATE_SQL in an RPG program to generate the DDL source for existing DDS-defined tables. It works fine if I qualify the object with a library name, but fails if I try to use *LIBL. So:
Works: call QSYS2.GENERATE_SQL( 'CUSTMAST', 'ARPROD', 'TABLE') Doesn't work: call QSYS2.GENERATE_SQL( 'CUSTMAST', '*LIBL', 'TABLE') Doesn't work: call QSYS2.GENERATE_SQL( 'CUSTMAST', *LIBL, 'TABLE')
Using '*LIBL' (with quotes) returns SQL0462 "NO OBJECTS FOUND". However, "Select * from CUSTMAST" works fine in the same job.
We're on v7r1, recent PTFs and TRs. When I search for GENERATE_SQL in KnowledgeCenter, there are results for this procedure in v7r2, but not v7r1. The v7r2 GENERATE_SQL documentation shows that *LIBL is valid for object_library.
https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_72/rzajq/rzajqprocgensql.htm
Am I missing something for this parameter? Is it a bug in v7r1, or a new feature added in v7r2?
- Dan
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
