Dynamic Update Statement in Native SQL

abhishek_katti — Thu, 30 Sep 2010 19:23:17 GMT

Hi Experts,

I want to dynamically pass the field in Update statement in Native SQL. For eg.

data: str1 type string.

str1 = 'MARKETS'.

EXEC SQL.

UPDATE PRDT.TBVEHDS4 SET (str1) = :'U'

WHERE VEH_NO = :'K1WK-54520'

AND SEGMENT_NO = :'01'

ENDEXEC.

But this is not taking (str1) as MARKETS field to update as U , its taking STR1 itself, Giving native SQL exception as Invalid Token as we are using DB2 as external DB system.

I checked with field-symbols also, but nothing helped.

Please help, thanks in Advance.

Regards,

Abhishek

Re: Dynamic Update Statement in Native SQL

Former Member — Thu, 30 Sep 2010 19:39:09 GMT

Hi,

Check this demo program in SE38 ADBC_DEMO, take as example to construct your own dynamic native sql

Regards,

Felipe

topic Dynamic Update Statement in Native SQL in Application Development and Automation Discussions

Dynamic Update Statement in Native SQL

Re: Dynamic Update Statement in Native SQL