Page 1 of 2

Select case

PostPosted: Mon Mar 10, 2014 11:48 pm
by itamar rocha
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

Re: Select case

PostPosted: Tue Mar 11, 2014 12:16 am
by Terry Heinze
"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?

Re: Select case

PostPosted: Tue Mar 11, 2014 12:20 am
by itamar rocha
Line 911

END AS :WS-IND-TP-PREMIO

Re: Select case

PostPosted: Tue Mar 11, 2014 12:21 am
by Terry Heinze
...and the rest of the error message?

Re: Select case

PostPosted: Tue Mar 11, 2014 12:23 am
by itamar rocha
DSNHPARS LINE 908 COL 28 ILLEGAL SYMBOL ":". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: <IDENTIFIER>

Re: Select case

PostPosted: Tue Mar 11, 2014 2:31 am
by Terry Heinze
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.

Re: Select case

PostPosted: Tue Mar 11, 2014 6:01 pm
by itamar rocha
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

Re: Select case

PostPosted: Tue Mar 11, 2014 6:13 pm
by itamar rocha
Anybody know whats is this error?

Re: Select case

PostPosted: Tue Mar 11, 2014 6:47 pm
by Akatsukami
Check the DB2 for z/OS Codes manual for your version of DB2, look up the SQLCODEs, and apply the recommended remedies.

Re: Select case

PostPosted: Tue Mar 11, 2014 6:52 pm
by Terry Heinze
... and please use Code tags:
This line has been coded. You need the full editor to have access to the Code tags.