How do i get the data after i execute the sql statement with database.activity.run query

[jojo11050702 (永定 馮)]

Hi everyone, i was wondering how do i get the data after i use database.activity.run query. Should i create the argument to retrieve the data? Or use other activities?

[sasi_poosarla (sasi p)]

For run query activity need to create a variable in property panel…
the result of query Will be stored in that variable…
The output would be datatable

[neha.upase]

Hi,

need to create output variable for the output of query and the type of this variable is datatable. your output will be stored in that. you can use this variable in further process…

[jojo11050702 (永定 馮)]

thanks everyone. By following the suggestions from @neha.upase, the problem was solved