topic Re: Native SQL - Get query in Application Development and Automation Discussions

Native SQL - Get query

Former Member — Wed, 07 Oct 2015 17:00:45 GMT

Hi there,

I have many codes like this:

EXEC SQL.

INSERT INTO T_ORACLE_TABLE ( field1, field2, field3 )

VALUES ( :t_sap_table-field1, :t_sap_table-field2, :t_sap_table-field3 )

ENDEXEC.

This is just an example, but the real queries are bigger than that.

I would like to save this query with values in a Ztable, something like a string "insert into oracle_Table(field1,field2,field3) values('value1', 'value2', 'value3')".

Does anyone know if is it possible to get the query I'm doing?

Re: Native SQL - Get query

juan_suros — Wed, 07 Oct 2015 22:27:05 GMT

You can execute one or more pre-created queries in your Z table by doing the following steps:

1) Loop through the Z table of queries

2) for each query you want to execute, add five rows to a itab of code lines as follows:

code_itab = 'FORM one_of_n.'. APPEND code_itab.

code_itab = 'EXEC SQL.'. APPEND code_itab.

code_itab = '<query string here>'. APPEND code_itab.

code_itab = 'ENDEXEC.'. APPEND code_itab.

code_itab = 'ENDFORM.'. APPEND code_itab.

3) create a utility report containing your query using this command:

GENERATE SUBROUTINE POOL code_itab NAME zmy_utility MESSAGE errors.

4) Call each query in turn

PERFORM one_of_n in PROGRAM z_my_utility CHANGING results.

PERFORM two_of_n in PROGRAM z_my_utility CHANGING results2.

PERFORM three_of_n in PROGRAM z_my_utility CHANGING results3.

that should work nicely. Here are a couple of tips.

You might try defining "code_itab" as follows:

DATA: code_itab TYPE STANDARD TABLE OF tline-tdline.

See below for a complete solution to a simpler but similar problem:

Re: Native SQL - Get query

raphael_almeida — Wed, 07 Oct 2015 23:50:56 GMT

Why you just do not use the ADBC and tries to dynamically run your DML statements?

(Just a suggestion for improvements).

BR,

Raphael Pacheco.

Re: Native SQL - Get query

Former Member — Thu, 08 Oct 2015 10:56:16 GMT

Thanks for your suggestion, but I will not use ABDC because this is not a mine development. There is another guy who works with me and he doesn't know how to do that by himself, I just posted here to help him.

Thanks for your suggestion too, !

Re: Native SQL - Get query

raphael_almeida — Thu, 08 Oct 2015 12:36:07 GMT

Thanks for your feedback.

Show to him the demo program called "ADBC_DEMO", it's a sample program what explain all statements using ADBC.

Warm regards,

Raphael Pacheco.