topic Re: Native SQL using variables? in Application Development and Automation Discussions

Native SQL using variables?

Former Member — Sun, 02 Nov 2008 08:13:13 GMT

Hi folks,

Is it possible to assign a SQL query to a variable, and then using an OPEN statement to read the variable?

E.g.,

query TYPE STRING VALUE 'SELECT * FROM mytable'.

EXEC SQL.

OPEN c1 FOR :query

ENDEXEC.

Re: Native SQL using variables?

Former Member — Sun, 02 Nov 2008 08:30:57 GMT

Host variables are for transferring data from database table to abap program.So i don't think so that we can use for reading the variables

Re: Native SQL using variables?

Former Member — Sun, 02 Nov 2008 08:38:25 GMT

Hi, thanks for the quick reply.

So do you have any idea how to do to open using a variable? This is because my SQL statement needs to be constructed dynamically depending on other data (I am doing string processing before the statement is finalized).

Or is there another way to do this instead of using cursor processing in Native SQL?

Thanks in advance.

Re: Native SQL using variables?

Former Member — Mon, 03 Nov 2008 01:49:40 GMT

OK, I've tried to narrow this length of string down to the following:

data mystring type string.

"SELECT ... ... ... WHERE" ... and then "mystring" needs to be appended to the end of the SQL statement.

E.g., mystring could be " field1 = '1234' AND field2 = 'XYZ' "

Is this possible? Thanks in advance for reading.