DSNUGSQL

Steve Grimes

DSNUGSQL
Hello, DB2 7.1, Z/os 1.4 here. (I'm probably wearing out my welcome this
month -- sorry!)

I've looked through the manuals and reviewed the DB2-L archives as well as
the redbook for using the V7 utilities suite. My attempt to LOAD with a
cross-system incursor is rendering:

OUTPUT START FOR UTILITY, UTILID = UQ#CDATT.S40LOAD
EXEC SQL DECLARE C1 CURSOR FOR SELECT * FROM
DBP1DDF.DBAPROD.FIT_CONTROL_DATES
ENDEXEC
LOAD DATA REPLACE INCURSOR(C1) LOG NO NOCOPYPEND
SQLCODE = -551, ERROR: DOES NOT HAVE THE PRIVILEGE TO PERFORM OPERATION
EXECUTE PACKAGE ON
OBJECT DSNUTIL.DSNUGSQL
SQLSTATE = 42501 SQLSTATE RETURN CODE
SQLERRP = DSNXEAAL SQL PROCEDURE DETECTING ERROR
SQLERRD = -210 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
SQLERRD = X'FFFFFF2E' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL
DIAGNOSTIC INFORMATION
UTILITY EXECUTION TERMINATED, HIGHEST RETURN CODE=8

And this is with the SYSADM userid! In our Q1 system we've bound the
DSNUTIL.DSNUGSQL successfully for the P1 system. This rendered:

DSNT232I -DBQ1 SUCCESSFUL BIND FOR
PACKAGE = DBP1DDF.DSNUTIL.DSNUGSQL.(V7R1)

Any thoughts? I've tried a few grants but to no avail yet.

Thanks in advance.

Stg

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm