| Pro C Dynamic SQL Statemnt Problem [message #93974] |
Thu, 19 June 2003 16:03 |
Ruben
Messages: 7
Registered: July 1999
|
Junior Member |
|
|
I have a Pro*C Program that uses the Dyanamic SQL Method 3, but 1 of the columns i need to select has a CASE Statement and when i try to compile it i obtain the following error: PCC-S-02201, Encountered the symbol "WHEN" when expecting one of the following.
How can i use this kind of statement? Thanks in advance.
EXEC SQL PREPARE S FROM SELECT CASE WHEN odursm>0 THEN SP.SPLITOPRULES_OEVTYPE ELSE 0 END FROM MYTABLE;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
