Datastage API
Posted: Wed Nov 22, 2000 10:59 pm
Are there api functions to access the metadata for a job,table etc from BASIC, C etc.
Specifically I want to get information out of a job within a routine to get the column names, stage info for an FTP stage so that I can automatically generate an extract script. I know I can get certain information from the DS api functions about active stages for the current job. But to do what I want I need to get column names, and column metadata. I know I can get this from the DS files by reading them, but I would like to use an API if possible, as hopefully this would be maintained to keep in sync with DataStage internal changes whereas, I if do it myself, I would have to handle that.
I believer generically this would be a good thing anyway.
I have asked this before, but a function which checks a column against the metadata would also be good, as assuming the metadata is kept up to date, it would simplify the process of cleansing data.
Phil Walker
DataStage Consultant
Project Clarity
Carter Holt Harvey Forests
DDI: 96094
MOD: 025 835 197
EMAIL: phil.walker@chh.co.nz
Specifically I want to get information out of a job within a routine to get the column names, stage info for an FTP stage so that I can automatically generate an extract script. I know I can get certain information from the DS api functions about active stages for the current job. But to do what I want I need to get column names, and column metadata. I know I can get this from the DS files by reading them, but I would like to use an API if possible, as hopefully this would be maintained to keep in sync with DataStage internal changes whereas, I if do it myself, I would have to handle that.
I believer generically this would be a good thing anyway.
I have asked this before, but a function which checks a column against the metadata would also be good, as assuming the metadata is kept up to date, it would simplify the process of cleansing data.
Phil Walker
DataStage Consultant
Project Clarity
Carter Holt Harvey Forests
DDI: 96094
MOD: 025 835 197
EMAIL: phil.walker@chh.co.nz