SQL - EXECUTE IMMEDITE

[Chanh_Le@xxxxxxxxxxxxxxx]

I have a big file, and many columns have value.  I would like to list the
column names which have values.  I create a stored procedure.  This
procedure executes a dynamic SQL statement string.


set SQLSTR01 = 'select count(*) from  XXXXXXXXX   where  YYYYYYY  <> 0'


The file name will replaces XXXXXXXX, and field name replaces YYYYYYYY

I try several options but it does not work.

1/ if (execute immediate SQLSTR01);
2/ set count01 = execute immediate SQLSTR01;
3/ set SQLSTR01 =  'select count(*)      INTO :CNT01            from
XXXXXXXXX   where  YYYYYYY  <> 0'

How could we get the counter from the execution of an SQL string?


Thanks.
CL

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---