Error related to Routine of excute.sql
Posted: Thu Dec 07, 2006 5:55 am
Hi,
While excuteing routine excute.sql of to excute sql query's in routine I am facing below problem.
TEST #1
*******
Arg1 = SELECT * FROM PROCS_LOG
Arg2 = gmodc
Arg3 = gwmoraods
Arg4 = gwmoraods
Test completed.
DSLogInfo called from : ExecuteSQL
Message to be logged is...
> SQL State = 08S01, DBMS error code = 0
> [DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver]7505
DSLogInfo called from : ExecuteSQL
Message to be logged is...
> SQL State = 21, DBMS error code = -1
> [DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver][20101]11603
Program "DSU.ExecuteSQL": Line 77, Variable previously undefined. Zero length string used.
Result =
Any one has idea ple let me know
Thanks In Advance
While excuteing routine excute.sql of to excute sql query's in routine I am facing below problem.
TEST #1
*******
Arg1 = SELECT * FROM PROCS_LOG
Arg2 = gmodc
Arg3 = gwmoraods
Arg4 = gwmoraods
Test completed.
DSLogInfo called from : ExecuteSQL
Message to be logged is...
> SQL State = 08S01, DBMS error code = 0
> [DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver]7505
DSLogInfo called from : ExecuteSQL
Message to be logged is...
> SQL State = 21, DBMS error code = -1
> [DataStage][SQL Client][ODBC][DataDirect][ODBC 20101 driver][20101]11603
Program "DSU.ExecuteSQL": Line 77, Variable previously undefined. Zero length string used.
Result =
Any one has idea ple let me know
Thanks In Advance