|
Rob, I took a look at the description of the SQL0818 via DSPMSGD. It looks like an SQL package issue. Perhaps DLTSQPPKG followed by CRTSQLPKG? Message ID . . . . . . . . . : SQL0818 Message file . . . . . . . . : QSQLMSG Library . . . . . . . . . : QSYS Message . . . . : Consistency tokens do not match. Cause . . . . . : Package &3 in &4 on application server &5 cannot be run with the current application program because either the application program has been recompiled without rebuilding the package or the package has been restored from a back level version. Recovery . . . : Rebuild the package by using the CRTSQLPKG command or by using a CRTSQLxxx command specifying the correct relational database. Otherwise, restore the package from a version which matches the application program being run. -----Original Message----- Subject: SQL: Remote call I have a program named GDSSYS001 on system GDISYS. It calls program GDSSYS002 on system GDI using the following: C/EXEC SQL C+ CONNECT TO :Systemname C/END-EXEC ... C/EXEC SQL C+ CALL ROUTINES/GDSSYS002 (:SysAsp, :PctSysAsp, :PctPerm, :PctTemp) C/END-EXEC When it does so, I get: sqlcod= -818, sqlstt= 51003 http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/rzala/rzal afinder.htm What is the best way to resolve this? Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
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.