Revolving around the core of technology
2015-08-05
apologies if i have reposted this
Having issues getting connected.
I am trying to connect to an IBM mainframe thru this tool and the ODBC.
In testing the connection to the mainframe from the ODBC setup the connection is successful.
When starting the winsql and the window indicating what database i want to connect to appears.
Clickin OK brings up the message below this screen print.
SQL Error STATE 51015 etc etc
error at bind time etc etc
package "34" et etc
In the ODBC it leaves the messages
LINE MESSAGES FOR db2clpcs.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
343 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.GET_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
565 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
568 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
2101 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_DTD" having compatible arguments was found.
SQLSTATE=0168I
2109 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_EXTENTITY" having compatible arguments was
found. SQLSTATE=0168I
2836 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML" having compatible arguments was found.
SQLSTATE=0168I
2861 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML10MB" having compatible arguments was
found. SQLSTATE=0168I
2871 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML25MB" having compatible arguments was
found. SQLSTATE=0168I
2881 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML50MB" having compatible arguments was
found. SQLSTATE=0168I
2891 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML75MB" having compatible arguments was
found. SQLSTATE=0168I
2901 SQL0408N A value is not compatible with the data type of its
assignment target. Target name is "XMLVAL". SQLSTATE=42821
2925 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML500MB" having compatible arguments was
found. SQLSTATE=0168I
2935 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1GB" having compatible arguments was
found. SQLSTATE=0168I
2945 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1_5GB" having compatible arguments was
found. SQLSTATE=0168I
2955 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML2GB" having compatible arguments was
found. SQLSTATE=0168I
3360 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" having compatible
arguments was found. SQLSTATE=0168I
3632 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
3642 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
4050 SQL0199N The use of the reserved word "UNION" following ""
is not valid. Expected tokens may include: ", )".
SQLSTATE=42601
8371 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_UPDATE" having compatible arguments was found.
SQLSTATE=0168I
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "6" errors and "16"
warnings.
LINE MESSAGES FOR db2clprr.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
343 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.GET_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
565 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
568 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
2101 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_DTD" having compatible arguments was found.
SQLSTATE=0168I
2109 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_EXTENTITY" having compatible arguments was
found. SQLSTATE=0168I
2836 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML" having compatible arguments was found.
SQLSTATE=0168I
2861 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML10MB" having compatible arguments was
found. SQLSTATE=0168I
2871 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML25MB" having compatible arguments was
found. SQLSTATE=0168I
2881 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML50MB" having compatible arguments was
found. SQLSTATE=0168I
2891 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML75MB" having compatible arguments was
found. SQLSTATE=0168I
2901 SQL0408N A value is not compatible with the data type of its
assignment target. Target name is "XMLVAL". SQLSTATE=42821
2925 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML500MB" having compatible arguments was
found. SQLSTATE=0168I
2935 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1GB" having compatible arguments was
found. SQLSTATE=0168I
2945 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1_5GB" having compatible arguments was
found. SQLSTATE=0168I
2955 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML2GB" having compatible arguments was
found. SQLSTATE=0168I
3360 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" having compatible
arguments was found. SQLSTATE=0168I
3632 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
3642 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
4050 SQL0199N The use of the reserved word "UNION" following ""
is not valid. Expected tokens may include: ", )".
SQLSTATE=42601
8371 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_UPDATE" having compatible arguments was found.
SQLSTATE=0168I
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "6" errors and "16"
warnings.
LINE MESSAGES FOR db2clpur.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
343 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.GET_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
565 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
568 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
2101 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_DTD" having compatible arguments was found.
SQLSTATE=0168I
2109 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_EXTENTITY" having compatible arguments was
found. SQLSTATE=0168I
2836 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML" having compatible arguments was found.
SQLSTATE=0168I
2861 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML10MB" having compatible arguments was
found. SQLSTATE=0168I
2871 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML25MB" having compatible arguments was
found. SQLSTATE=0168I
2881 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML50MB" having compatible arguments was
found. SQLSTATE=0168I
2891 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML75MB" having compatible arguments was
found. SQLSTATE=0168I
2901 SQL0408N A value is not compatible with the data type of its
assignment target. Target name is "XMLVAL". SQLSTATE=42821
2925 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML500MB" having compatible arguments was
found. SQLSTATE=0168I
2935 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1GB" having compatible arguments was
found. SQLSTATE=0168I
2945 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1_5GB" having compatible arguments was
found. SQLSTATE=0168I
2955 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML2GB" having compatible arguments was
found. SQLSTATE=0168I
3360 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" having compatible
arguments was found. SQLSTATE=0168I
3632 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
3642 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
4050 SQL0199N The use of the reserved word "UNION" following ""
is not valid. Expected tokens may include: ", )".
SQLSTATE=42601
8371 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_UPDATE" having compatible arguments was found.
SQLSTATE=0168I
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "6" errors and "16"
warnings.
LINE MESSAGES FOR db2clprs.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
343 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.GET_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
565 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
568 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
2101 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_DTD" having compatible arguments was found.
SQLSTATE=0168I
2109 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_EXTENTITY" having compatible arguments was
found. SQLSTATE=0168I
2836 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML" having compatible arguments was found.
SQLSTATE=0168I
2861 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML10MB" having compatible arguments was
found. SQLSTATE=0168I
2871 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML25MB" having compatible arguments was
found. SQLSTATE=0168I
2881 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML50MB" having compatible arguments was
found. SQLSTATE=0168I
2891 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML75MB" having compatible arguments was
found. SQLSTATE=0168I
2901 SQL0408N A value is not compatible with the data type of its
assignment target. Target name is "XMLVAL". SQLSTATE=42821
2925 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML500MB" having compatible arguments was
found. SQLSTATE=0168I
2935 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1GB" having compatible arguments was
found. SQLSTATE=0168I
2945 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1_5GB" having compatible arguments was
found. SQLSTATE=0168I
2955 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML2GB" having compatible arguments was
found. SQLSTATE=0168I
3360 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" having compatible
arguments was found. SQLSTATE=0168I
3632 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
3642 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
4050 SQL0199N The use of the reserved word "UNION" following ""
is not valid. Expected tokens may include: ", )".
SQLSTATE=42601
8371 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_UPDATE" having compatible arguments was found.
SQLSTATE=0168I
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "6" errors and "16"
warnings.
LINE MESSAGES FOR db2clipk.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0" warnings.
LINE MESSAGES FOR db2clist.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0" warnings.
Thanks for your support.
I am using WINSQL LITE
The WinSQL is contained in ---
"C:\Program Files (x86)\Synametrics Technologies\WinSQL\"
The FOR db2clpcs.bnd is contained in.
C:\Program Files\IBM\SQLLIB\bnd
LINE MESSAGES FOR db2clpcs.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
343 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.GET_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
565 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
568 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
2101 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_DTD" having compatible arguments was found.
SQLSTATE=0168I
2109 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_EXTENTITY" having compatible arguments was
found. SQLSTATE=0168I
2836 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML" having compatible arguments was found.
SQLSTATE=0168I
2861 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML10MB" having compatible arguments was
found. SQLSTATE=0168I
2871 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML25MB" having compatible arguments was
found. SQLSTATE=0168I
2881 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML50MB" having compatible arguments was
found. SQLSTATE=0168I
2891 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML75MB" having compatible arguments was
found. SQLSTATE=0168I
2901 SQL0408N A value is not compatible with the data type of its
assignment target. Target name is "XMLVAL". SQLSTATE=42821
2925 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML500MB" having compatible arguments was
found. SQLSTATE=0168I
2935 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1GB" having compatible arguments was
found. SQLSTATE=0168I
2945 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1_5GB" having compatible arguments was
found. SQLSTATE=0168I
2955 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML2GB" having compatible arguments was
found. SQLSTATE=0168I
3360 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" having compatible
arguments was found. SQLSTATE=0168I
3632 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
3642 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
4050 SQL0199N The use of the reserved word "UNION" following ""
is not valid. Expected tokens may include: ", )".
SQLSTATE=42601
8371 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_UPDATE" having compatible arguments was found.
SQLSTATE=0168I
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "6" errors and "16"
warnings.
LINE MESSAGES FOR db2clprr.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
343 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.GET_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
565 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
568 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
2101 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_DTD" having compatible arguments was found.
SQLSTATE=0168I
2109 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_EXTENTITY" having compatible arguments was
found. SQLSTATE=0168I
2836 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML" having compatible arguments was found.
SQLSTATE=0168I
2861 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML10MB" having compatible arguments was
found. SQLSTATE=0168I
2871 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML25MB" having compatible arguments was
found. SQLSTATE=0168I
2881 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML50MB" having compatible arguments was
found. SQLSTATE=0168I
2891 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML75MB" having compatible arguments was
found. SQLSTATE=0168I
2901 SQL0408N A value is not compatible with the data type of its
assignment target. Target name is "XMLVAL". SQLSTATE=42821
2925 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML500MB" having compatible arguments was
found. SQLSTATE=0168I
2935 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1GB" having compatible arguments was
found. SQLSTATE=0168I
2945 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1_5GB" having compatible arguments was
found. SQLSTATE=0168I
2955 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML2GB" having compatible arguments was
found. SQLSTATE=0168I
3360 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" having compatible
arguments was found. SQLSTATE=0168I
3632 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
3642 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
4050 SQL0199N The use of the reserved word "UNION" following ""
is not valid. Expected tokens may include: ", )".
SQLSTATE=42601
8371 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_UPDATE" having compatible arguments was found.
SQLSTATE=0168I
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "6" errors and "16"
warnings.
LINE MESSAGES FOR db2clpur.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
343 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.GET_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
565 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
568 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
2101 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_DTD" having compatible arguments was found.
SQLSTATE=0168I
2109 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_EXTENTITY" having compatible arguments was
found. SQLSTATE=0168I
2836 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML" having compatible arguments was found.
SQLSTATE=0168I
2861 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML10MB" having compatible arguments was
found. SQLSTATE=0168I
2871 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML25MB" having compatible arguments was
found. SQLSTATE=0168I
2881 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML50MB" having compatible arguments was
found. SQLSTATE=0168I
2891 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML75MB" having compatible arguments was
found. SQLSTATE=0168I
2901 SQL0408N A value is not compatible with the data type of its
assignment target. Target name is "XMLVAL". SQLSTATE=42821
2925 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML500MB" having compatible arguments was
found. SQLSTATE=0168I
2935 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1GB" having compatible arguments was
found. SQLSTATE=0168I
2945 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1_5GB" having compatible arguments was
found. SQLSTATE=0168I
2955 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML2GB" having compatible arguments was
found. SQLSTATE=0168I
3360 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" having compatible
arguments was found. SQLSTATE=0168I
3632 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
3642 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
4050 SQL0199N The use of the reserved word "UNION" following ""
is not valid. Expected tokens may include: ", )".
SQLSTATE=42601
8371 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_UPDATE" having compatible arguments was found.
SQLSTATE=0168I
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "6" errors and "16"
warnings.
LINE MESSAGES FOR db2clprs.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
343 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.GET_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
565 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
568 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSFUN.PUT_ROUTINE_SAR" having compatible arguments was
found. SQLSTATE=0168I
2101 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_DTD" having compatible arguments was found.
SQLSTATE=0168I
2109 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_EXTENTITY" having compatible arguments was
found. SQLSTATE=0168I
2836 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML" having compatible arguments was found.
SQLSTATE=0168I
2861 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML10MB" having compatible arguments was
found. SQLSTATE=0168I
2871 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML25MB" having compatible arguments was
found. SQLSTATE=0168I
2881 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML50MB" having compatible arguments was
found. SQLSTATE=0168I
2891 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML75MB" having compatible arguments was
found. SQLSTATE=0168I
2901 SQL0408N A value is not compatible with the data type of its
assignment target. Target name is "XMLVAL". SQLSTATE=42821
2925 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML500MB" having compatible arguments was
found. SQLSTATE=0168I
2935 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1GB" having compatible arguments was
found. SQLSTATE=0168I
2945 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML1_5GB" having compatible arguments was
found. SQLSTATE=0168I
2955 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDBDECOMPXML2GB" having compatible arguments was
found. SQLSTATE=0168I
3360 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XDB_DECOMP_XML_FROM_QUERY" having compatible
arguments was found. SQLSTATE=0168I
3632 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
3642 SQL0104N An unexpected token "TEMPORAL" was found following
"". Expected tokens may include: "TIME TIMEZONE SERVER
CLIENT_ACCTNG CLIENT_USERID". SQLSTATE=42601
4050 SQL0199N The use of the reserved word "UNION" following ""
is not valid. Expected tokens may include: ", )".
SQLSTATE=42601
8371 SQL0440N No authorized routine named "PROCEDURE" of type
"SYSPROC.XSR_UPDATE" having compatible arguments was found.
SQLSTATE=0168I
SQL0082C An error has occurred which has terminated
processing.
SQL0092N No package was created because of previous errors.
SQL0091N Binding was ended with "6" errors and "16"
warnings.
LINE MESSAGES FOR db2clipk.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0" warnings.
LINE MESSAGES FOR db2clist.bnd
------ --------------------------------------------------------------------
SQL0061W The binder is in progress.
SQL0091N Binding was ended with "0" errors and "0" warnings.
Thanks for your support.
I am using WINSQL LITE
When you connect to a DB2 back-end from an ODBC driver, it expects certain packages to be created on the back-end. The driver will try to create these packages if they are missing. However, in order for this to happen the Login ID you are using must have enough privileges.
I would recommend asking the DBA in your organization to connect with his/her credentials at least once from your machine. This will create the packages and you won't run into this problem.
The messgaes point to two schema's SYSFUN and SYSPROC. Will the user need CREATIN in those schema?
May I ask if you know what these packages might be or where I can find their names.
DBA attempted to signon from the SQLWIN window. The error received was the same as when QCFWS did.
So was just double checking that we were doing that correctly.