Home » Developer & Programmer » Precompilers, OCI & OCCI » Pro C Dynamic SQL Statemnt Problem
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;
Previous Topic: why does default makefile trying to remove libclntsh.sl.9.0? Is it ok, if I set permission to remove
Next Topic: pro*c++ compiler
Goto Forum:
  


Current Time: Thu Mar 28 03:20:48 CDT 2024