Parametersing Table definitions?

jaksani · Post by **jaksani** » Wed Mar 30, 2011 2:48 am

Hi,

I would like to create a reusable job by parameterising everything.
I do not know whether it is possible in datastage or not.
Please let me know how to do if it can be done .

chulett · Post by **chulett** » Wed Mar 30, 2011 6:54 am

Define 'everything'... and what exactly would this job be doing? Simply moving data unchanged from source to target? Have you looked into the use of RCP and schema files?

GJ_Stage · Post by **GJ_Stage** » Wed Mar 30, 2011 9:22 am

Yes. It is possible using schema file (this is for reading seq file to writing into table). Only one DS job is enough for that you need to pass schema file name and tablename and anyother parameters.

jaksani · Post by **jaksani** » Wed Mar 30, 2011 11:46 pm

Thanks!
Yes, My aim is move data from source to target location.
Please let me know where can I get more information on Schemas.