SQL output in Print function

[narayanan_kuppuraj]

Hi Experts,

I have a table with one columne with few rows. I want to print all the rows in BODS using print function. I used as below , but its printing only the first row from the the oracle table and does not print the rest of the rows. What settings i need to change in order to print all the rows.

print(sql('DSSTAGING',  'select col from test_error '));

Appreiate your help..

Thanks,

narayanan

[Former Member]

Hi Narayanan,

I doubt it can be done in single print statement. If you need to bring in all the rows for processing in DS, then it's best to use the table itself or SQL transform if you need to use the result set of a query.

May be other people in the forum can suggest options.

Thanks, Arun.