RE: CRTSQLPKG error

Vanja,

Thanks for your help. I tried using *LOCAL as the value for the parameter
RDB and that appears to
fix the problem.

Erick
-----Original Message-----
From: owner-midrange-l@midrange.com
[mailto:owner-midrange-l@midrange.com]On Behalf Of Vanja Jovic
Sent: Friday, June 30, 2000 10:16 PM
To: MIDRANGE-L@midrange.com
Subject: Re: CRTSQLPKG error


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
+---

+---
| 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
+---