I have a requirement which is a following
I have a table XX which has a column QUERY_TXT which contains a select query .
|select * from xxx|
Now I have to extract the query form the above table and use that as my select statement to populate another table using BTEQ ,some thing like this
insert into xxxx
select * from xxx ;
Quich help is really helpfull
Thankyou in advance
How many rows / Select statements are there in QUERY_TXT?
Do you have to repeat this BTEQ for all the rows in QUERY_TXT?
RAJA : Thankyou for the quick response .
Khurram : We have to repeat this for all the rows(50 approx) to take the back up in BTEQ .
RAJA : I am not able to figureout the logic can you please be a bit more clear on this
you can export the SQLs (as full Insert/selects) with bteq and can import and call these generated SQLs in the same job.