|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/16/2008 3:31:05 PM
Posts: 2,
Visits: 13
|
|
Hi,
I am trying to pass on a parameter value into a BTEQ script. The query is to accept parameters and query the paramater and export the result into a Textfile or Table.
Paramaters to be pass onand Resident_ID.
.RUN FILE = 'LOGON.DAT';
SELECT distinct q.Resident_ID
, q.LName
, q.FName
, q.Address
FROM QueryReside AS q
WHERE q.Resident_ID = '¶_number'
AND zip = '&zip'
.LOGOFF;
and I obsolutely have no idea of passing a paramater. Can someone please help out??
Kim
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 9/8/2008 7:42:33 AM
Posts: 22,
Visits: 53
|
|
Hi Kim,
I am not sure , that we can pass runtime parameter in BTEQ utility, But If you really want to do this
Do follow these steps:
----------------------
1) Create the BTEQ Scripts
2) Create the Shell scripts & call those Scripts inside this & use the variables over here
this could help you...... let me know if any issues. Also I will let you know some other Approach for this as soon as poss
Best Regards,
Maran A
Oracle Certified & DW+BI Proffessional
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/16/2008 3:31:05 PM
Posts: 2,
Visits: 13
|
|
Hi Maran,
Thanx for the heads-up. Could you please be of assistant, given the below SQL-script, to help create or send a sample Shell script and explain how to go about it.
SELECT distinct q.Resident_ID
, q.LName
, q.FName
, q.Address
FROM QueryReside AS q
WHERE q.Resident_ID = '¶_number'
AND zip = '&zip'
Kim
|
|
|
|