Midrange News for the IBM i Community

Posted by: Bob Cozzi
Rogue Programmer
Cozzi Productions, Inc.
has no ratings.
Published: 01 Feb 2012
Revised: 23 Jan 2013 - 2185 days ago
Last viewed on: 15 Jan 2019 (6399 views) 

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.

SQL PKG and CRTSQLRPGI Published by: Bob Cozzi on 01 Feb 2012 view comments(4)

Is it true the specifying the SQLPKG parameter on CRTSQLRPGI does nothing?

And that in fact, you have to issue a CRTSQLPKG command after creating your RPG IV program that contains embedded SQL with remote access (CONNECT TO) statements?

I assumed that when you do a CRTRPGSQLI that the SQLPKG parameter, which defaults to SQLPKG(*OBJLIB/*OBJ) would create an SQL package with the same name as the program in the target library. But so far I've always had to do CRTSQLPKG with the program name of the program I previously created.

Is this normal?

Return to midrangenews.com home page.
Sort Ascend | Descend