Re: CRTSQLPKG error

[Vanja Jovic <vanja@xxxxxxxxx>]

Erick,

most likely, you don't use appropriate parameter on CRTSQLRPGLI.  I
don't have command line handy to tell you exactly, but parameter refers
to remote/local database. 

Vanja Jovic,
Canada

Erick Garske wrote:
> 
> I have an rpg program with embedded dynamic SQL statements. When
> distributing the program, the program does not perform.
> 
> Am told that I need to use CRTSQLPKG to recreate the SQL Package. When this
> command is issued the
> diagnostic report reads below:
> 
>                                               DIAGNOSTIC MESSAGES
>  MSG ID  SEV  RECORD  TEXT
>  SQL5030  50          Program PPR0600 in FMG does not contain SQL
> distributed
>                       modules.
>  SQL5056              SQL package creation for module PPR0600 failed.
> Package
> 
> Am I not using the proper values for creating the package?
> 
> Thank for any insight into this problem.
> 
> Erick Garske
> Programmer/Analyst
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---