topic Re: Single program to execute several queries in Application Development and Automation Discussions

Single program to execute several queries

former_member237439 — Tue, 27 Nov 2012 09:26:58 GMT

Hi guys

I have two queries that I have created in SQ01. Both queries have PRPS-PSPHI as a selection parameter and have variants with output into private files.

The above works just fine.

What I would like to do is execute a single program that calls both queries with just one selection screen.

Is that somehow possible?

BR
Stefan

P.S. I have located the FM RSAQ_QUERY_CALL that might be usefull?

Re: Single program to execute several queries

Sijin_Chandran — Tue, 27 Nov 2012 11:15:54 GMT

Hi Stefan ,

Am not sure about FM RSAQ_QUERY_CALL , but I think that you can use SUBMIT command to accomplish your task.

When you execute your Query from SQ01 , selection screen appears just check the program name from System > Status.

The name usually is alpha numeric and a bit long.

I think you can use SUBMIT command with Variant option to call this from another program.

eg : SUBMIT AQZZ/GRC/APPL===FI_AP_21_Q1=== USING SELECTION-SET variant.

Re: Single program to execute several queries

former_member237439 — Tue, 27 Nov 2012 12:22:16 GMT

Hi Sijin

That seems to work just fine!

Thanks!

Re: Single program to execute several queries

RaymondGiuseppi — Tue, 27 Nov 2012 13:55:57 GMT

For information on RSAQ_QUERY_CALL and more recent IQAPI_QCALL, read Note 393160 - SAP Query: Using queries

You could also generate program name (and insure it is generated in a transport target system or after an upgrade, database change, etc.) with RSAQ_CREATE_QUERY_REPORT, then SUBMIT the returned program WITH parameters or selection set.

Regards,

Raymond