Originally posted by: Greenspan
Hi,
We are useg WTX on zOS with 2 input cards and 2 output cards. Both thye input cards' input are database. output of one card is database and the other is sink. The map is facing issues with sql code -501. The log is as below
Validating the adapter command...
Database type is DB2
Connection from pool is being reused.
Interface library version 8.2(183)
Map: MAPLIB(TESTGREF), Timestamp: .
Data being retrieved for input card 2.
Database adapter: DB2 SQL adapter for MVS Version 8.2(183)
Starting a database unload...
Query : SELECT Col1 ,Col2 ,Col3,Col4,Col5,Col6 FROM XXXXXXX.Tablename
Col0 = 'XYY14289' AND Col11 = '3' AND Stat = ' ' FETCH FIRST ROW ONLY WITH UR
Query size : 359
Context: Input Card, Transaction scope: Card
On Failure: Rollback, On Success: Keep
TRACE command specified, file: DD:MERCLOG
DBS_ExecuteStmtDirect: EXEC SQL PREPARE Q(0-7) FROM :sqlst
SELECT Col1 ,Col2 ,Col3,Col4,Col5,Col6 FROM XXXXXXX.Tablename
Col0 = 'ABC14289' AND Col11 = '3' AND Stat = ' ' FETCH FIRST ROW ONLY WITH UR
DBS_ExecuteStmtDirect: EXEC SQL EXECUTE Q(0-7)
DBS_ExecuteStmtDirect: execute failed
0 DSNT408I SQLCODE = -501, ERROR: THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN
LCODE = -501, ERROR: THE CURSOR IDENTIFIED IN A FETCH OR CLOSE STATEMENT IS NOT OPEN
0 DSNT418I SQLSTATE = 24501 SQLSTATE RETURN CODE
LSTATE = 24501 SQLSTATE RETURN CODE
0 DSNT415I SQLERRP = DSNXERT SQL PROCEDURE DETECTING ERROR
LERRP = DSNXERT SQL PROCEDURE DETECTING ERROR
0 DSNT416I SQLERRD = -240 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
LERRD = -240 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
0 DSNT416I SQLERRD = X'FFFFFF10' X'00000000' X'00000000' X'FFFFFFFF' X'00
LERRD = X'FFFFFF10' X'00000000' X'00000000' X'FFFFFFFF' X'00000000' X'0
0 INFORMATION
FORMATION
0
0
Rolling back the transaction since -CCARD, -CSTMT or Card scope was specified
Anyone has seen this kind of issue ?
#DataExchange#IBMSterlingTransformationExtender#IBM-Websphere-Transformation-Extender