Skip to Content
0
Former Member
May 08, 2008 at 09:07 AM

Native SQL

251 Views

Hi Experts,

I am in a fix on how to convert a code written in Native SQL into Open SQL.

Can ne1 plzz help me out with this.

The piece of code is given below:

call function 'STRING_CONCATENATE_3'

exporting

string1 = 'dbcc updateusage (0,"'

string2 = tabname

string3 = '")'

importing

string = usupstr

exceptions

too_small = 1

others = 2.

exec sql.

insert into $xsql values( :usupstr ).

endexec.

The last 3 lines is the main code in native SQL and i want to convert it to Open SQL... the functionality has to be the same...

I will reward all the helpful answers 😊

Thanks,

Ajay.

Edited by: ajay singh on May 8, 2008 11:22 AM

Edited by: ajay singh on May 8, 2008 11:29 AM