[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
- Subject: SQR Question: Getting Values of Dynamic Columns in select
- From: Ashish Bhatt <ashish_bhatt@HOTMAIL.COM>
- Date: Sat, 20 Oct 2001 07:35:02 -0700
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.