IBM Mainframe Forum

Hello everyone,

I use the command: Table XXXX YYYY WS-IND-TP-PREMIO pic x(01);


EXEC SQL
SELECT CASE
WHEN COUNT(XXXX.NUM_CPF_CNPJ) = 0
THEN '1'
ELSE '4'
END AS : WS-IND-TP-PREMIO
FROM YYYY
WHERE YYYY.COD_PARAM_EXC_COBER = :YYYY-COD-PARAM-EXC-COBER
AND YYYY.NUM_COBERTURA = :YYYY.NUM-COBERTURA
END-EXEC

When I execute the program :

DSNHPARS LINE 911 COL 28 "<IDENTIFIER>" REQUIRED
DSNHPARS LINE 911 COL 28 ILLEGAL SYMBOL ":". SOME SYMBOLS THAT MIGHT BE LEGAL A

Anybody knows whats is this?

Thanks

"DSNHPARS LINE 911 COL 28 "<IDENTIFIER>" REQUIRED
DSNHPARS LINE 911 COL 28 ILLEGAL SYMBOL ":". SOME SYMBOLS THAT MIGHT BE LEGAL A"

Where is line 911? Where is the rest of the error message?

Line 911

END AS :WS-IND-TP-PREMIO

...and the rest of the error message?

DSNHPARS LINE 908 COL 28 ILLEGAL SYMBOL ":". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: <IDENTIFIER>

Your error message was on line 911 -- now it's on 908. Please post ALL relevant information (including field definitions) instead of piecemealing it and please use Code tags to preserve character spacing.

Hello,
My query is:

SELECT CASE
WHEN COUNT(SX008.NUM_CPF_CNPJ) = 0
THEN 1
ELSE 4
END AS :WS-IND-TP-PREMIO
FROM SX_EXC_COBER SX112
WHERE SX112.COD_PARAM_EXC_COBER = :SX112-COD-PARAM-EXC-COBER
AND SX112.NUM_COBERTURA = :SX112.NUM-COBERTURA
END-EXEC

My error is:

Error: DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=:;<IDENTIFIER>, DRIVER=3.57.82
SQLState: 42601
ErrorCode: -104
Error: DB2 SQL Error: SQLCODE=-514, SQLSTATE=26501, SQLERRMC=SQL_CURLH200C1, DRIVER=3.57.82
SQLState: 26501
ErrorCode: -514

Thanks for the help

Anybody know whats is this error?

Check the DB2 for z/OS Codes manual for your version of DB2, look up the SQLCODEs, and apply the recommended remedies.

... and please use Code tags: