save the SQL query result in a VARA object

[Shravan shetty]

Hi Community,

Can we save the queried data to a VARA so that I can use it processing options of JDE job?

Thanks,
Shravan Shetty

[Peter Grundler]

Hi Shravan,

yes this is possible. You have to process the result set line by line and store it in a VARA object.

regards,
Peter

------------------------------
Automic Certified Professional & Expert & Knight

For AUTOMIC trainings please check https://www.qskills.de/qs/workshops/automic/
------------------------------

[Shravan shetty]

Hi Peter,

the query gives multiple line of results. what will be stored in the VARA object?

because I need the first column data to be passed to a JDE job.

Regards,

Shravan Shetty

[Markus Embacher]

Hi,

you actually decide what to store in the VARA. Just run a PUT_VAR command for every line/value you would like to store in a loop.

Regards, Markus