topic Re: Dynamic native SQL Insert Statement in Application Development and Automation Discussions

Dynamic native SQL Insert Statement

Former Member — Tue, 20 Nov 2007 15:31:51 GMT

Hi,

i will execute/modifiy the following code example to work dynamic. I mean that i want to configure how many fields and which field should be insert in the DB-Table

Samplecode:

LOOP AT vendor_tab INTO vendor_wa.

EXEC SQL.

insert into DatabaseTable.Dummy

(

ve_vendor_no,

ve_name,

ve_country

<b>.......(dynmaic)</b>

)

VALUES

(

:vendor_wa-a-lifnr,

:vendor_wa-a-name1,

:vendor_wa-a-land1

<b>............(dynamic)</b>

)

ENDEXEC.

ADD 1 TO commit_count.

IF commit_count EQ db_comit.

COMMIT WORK AND WAIT.

MOVE 0 TO commit_count.

ENDIF.

ENDLOOP.

If anyone has an idea it will be greatfull.

Thx

Joachim

Re: Dynamic native SQL Insert Statement

Former Member — Tue, 20 Nov 2007 15:55:46 GMT

Hi JWR,

Try this: build dynamically the part between the brackets ( ).

Define 2 string fields and concatenate inside what u need to build your SQL statement.

Then u'll have:

data: str1 type string,

str2 type string.

LOOP AT vendor_tab INTO vendor_wa.

build strings of fields - u cane move this part any where it suits

concatenate 've_vendor_no' 've_name' 've_country' .......(dynamic) into str1

separated by space.

concatenate ':vendor_wa-a-lifnr' ':vendor_wa-a-name1' ':vendor_wa-a-land1'

............(dynamic) into str2 separated by space.

EXEC SQL.

insert into DatabaseTable.Dummy

(

str1

)

VALUES

(

str2

)

ENDEXEC.

...

ENDLOOP.

Good luck

Pls reward if helps

Igal

Re: Dynamic native SQL Insert Statement

rubenswalter_blattler — Mon, 09 Jan 2023 14:19:41 GMT

Hello, Joachim!

Could you share the source code for the solution indicated by Igal, please? I did several tests, but all without success. Thank you very much

Re: Dynamic native SQL Insert Statement

thelazyhangman — Fri, 12 Jan 2024 10:27:34 GMT

Me too. It's not working. It says "Invalid column name 'str2'.