[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

SQR Question: Getting Values of Dynamic Columns in select



Hi Peoplesoft and SQR Gurus,
 
I hope you are doing fine today.
 
I am facing tough time in getting the values of
Dynamic Columns in the select.
 
I am having below SQR code:
 
begin-select
$c1 
     do Write-Data
from [$table_name]
where AUDIT_STAMP < SYSDATE - 1300  
end-select

 
In the above $c1 is all the column names of the table.
 
I want the values returned by above select.
 
Can you please give me some idea how this can be done
?
 
Thanks in advance.
 
Have a nice day and great weekend.
 
Regards.
 
Ashish Bhatt.