-
Call DB2 procedure from MSSQL2000
I'm trying to call a procedure from linked server (AS/400 DB2) and retrieve a resultset from it.
I have tried to do this using both OLEDB (latest IBMDA400 provider for v5r2) and ODBC (through MSDASQL).
"SELECT * FROM OPENQUERY (
LINKEDDB2 , 'CALL DB2PROCEDURE')"
causes error "The OLE DB provider 'IBMDA400' indicates that the object has no columns"
"EXEC LINKEDDB2.LINKEDDB2.LIB.DB2PROCEDURE"
or
"{CALL LINKEDDB2.LINKEDDB2.LIB.DB2PROCEDURE}"
cause error "Could not execute procedure DB2PROCEDURE on remote server LINKEDDB2"
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|