Why below command work fine in Interactive SQL (STRSQL) or ACS Run SQL Script, but fails in SQL RPG ?

The issuing system is at v7.3, remote systems are at v5.4, 6.1, 7.1 and 7.2. When both systems are at v7.3, no issue, only when remote is at lower release
Looks like the CRTSQLPKG is looking for the OWNER user profile but program is compiled with USER
All latest PTFs are installed on all systems including similar problem from APAR SE70306

Any help would be much appreciated

Thanks in advance

[cid:image001.png@01D59871.8347E0F0]

Runtime error message in joblog
Additional Message Information

Message ID . . . . . . : SQL0805
Date sent . . . . . . : 11/11/19 Time sent . . . . . . : 08:48:00

Message . . . . : SQL package RSDFM1000A in QGPL not found at DRDA Server.

Cause . . . . . : A remote request was attempted to ISPEED for SQL package
RSDFM1000A in QGPL. The SQL package was not found. If you are using
Interactive SQL or Query Manager, an attempt to create a package on the
remote system failed and the package requested does not exist.
Recovery . . . : The most common cause of this problem in an Interactive
SQL session to a server that is not DB2 for IBM i is that the connection is
not updateable. In that case the package cannot be automatically created.
To ensure the connection is updateable, do a RELEASE ALL command followed by
a COMMIT before connecting to the relational database.
In other cases, the SQL package can be created by using the CRTSQLPKG
command. Also, precompiling an SQL program with the RDB parameter specified
will create an SQL package on the system. Create or restore the SQL package.
Run the application again.
If you are using Interactive SQL or Query Manager or SQL Call Level
Interface, exit the product or application and enter a CL COMMIT or ROLLBACK
command. This will enable you to continue processing at the local system.
Determine why the package creation failed by examining the job log. Correct
the problem and attempt the Interactive SQL or Query Manager session again.


Runtime SQL generated Spool file
5770SS1 V7R3M0 160422 Create SQL package 11/11/19 08:48:01 Page 1
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR Last change
Program name..............FDEV/RSDFM100
Relational database.......ISPEED
User .....................QSECOFR
Replace...................*YES
Default collection........*PGM
Generation level..........31
Printer file..............*LIBL/QSYSPRT
Object type...............*PGM
Module list...............*ALL
Text......................*PGMTXT
Source file...............FDEV/QRS
Member....................RSDFM1000A
5770SS1 V7R3M0 160422 Create SQL package 11/11/19 08:48:01 Page 2
Record *...+... 1 ...+... 2 ...+... 3 ...+... 4 ...+... 5 ...+... 6 ...+... 7 ...+... 8 SEQNBR Last change
700 DELETE FROM UPDFF01 WHERE UPSYST = : H
DIAGNOSTIC MESSAGES
MSG ID SEV RECORD TEXT
SQL0204 10 700 Position 13 UPDFF01 in *LIBL type *FILE not found.
SQL0204 30 FPGMR in QSYS type *USRPRF not found.
SQL5056 SQL package creation for module RSDFM1000A failed.
Package name was to be RSDFM1000A in QGPL at ISPEED.
Message Summary
Total Info Warning Error Severe Terminal
2 0 1 0 1 0
30 level severity errors found in source
* * * * * E N D O F L I S T I N G * * * * *


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.