Dynamic SQL
Posted: Sat Oct 01, 2005 11:22 am
hi,
I am having a mapping table consists of many table names and columns and these data were available in the database.Eg:
tablename columns functype1 functype
row1 x1 name1, Id1,sal1 y1 z1
row2 x2 name2,Id2,sal2 y2 z2
using functypes, tablename and columns have to identified and metadata of the tables i.e columns has to be loaded dynamically in the DS job.
Iam doing this job using Stored procedures (dynamic SQL) and called in DS. Is there any method in DStage without using routines.
Any solution, thanks
vinod
I am having a mapping table consists of many table names and columns and these data were available in the database.Eg:
tablename columns functype1 functype
row1 x1 name1, Id1,sal1 y1 z1
row2 x2 name2,Id2,sal2 y2 z2
using functypes, tablename and columns have to identified and metadata of the tables i.e columns has to be loaded dynamically in the DS job.
Iam doing this job using Stored procedures (dynamic SQL) and called in DS. Is there any method in DStage without using routines.
Any solution, thanks
vinod