Re: SQL - EXECUTE IMMEDIATE

[Chanh_Le@xxxxxxxxxxxxxxx]

Probably, there is no answer.  Because it does not allow SELECT statement
string, host variables, and parameter markers?

Tough luck.

CL





Chanh_Le@Countrywide.com@midrange.com on 12/18/2000 05:40:52 PM

Please respond to MIDRANGE-L@midrange.com

Sent by:  owner-midrange-l@midrange.com


To:   MIDRANGE-L@midrange.com
cc:

Subject:  SQL - EXECUTE IMMEDITE



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
+---



+---
| 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
+---