si_ddharths1

Hi Prasoon,
below is an example of the script which is for oracle server -

$TEST = 'BBB'
SQL
INSERT INTO SIDTEST
SELECT SID_TERM,SID_1,
CASE WHEN SID_2 = '111' THEN :$TEST
ELSE 'TTT' END SID_2
FROM SIDTEST1
ENDSQL

Thanx for your replies.

-----------------------------------------------------------------------------------------------
For clarification: Is it a self-contained C program you want to call (ie. a separate executable) or do you want to call C functions (ie. individual subroutines, for example in a library). There's a big difference
------------------------------------------------------------------------------------------------

Hi Richard,
I want input on both i.e. separate executable C program as well as individual subrutines.