DSXchange

Hello All,
I want to know the list of system files/ tables (with their structures) that stores job information ( such as SQLs used in jobs, etc.)

I work on DS server edition.

Ritesh

I have a file in which a tablename is there. My job has a DB2 stage which uses this tablename. Now I want to dynamically pass this tablename directly to my DB2 stage. Can anyone plz suggest how to do this?

No it's not a DS TX question, it is related to the Server Edition.

I have made a unix script which runs as an after job subroutine in a map. Is there a way around that i write that script in DS itself so that when the map is migrated to some other environment i don't have to carry the burden of importing that script also?

If this message is while you are doing "view data" then it is not going to affect the runtime processing of the data. If you are getting this warning during execution of your job then it is a problem. ... It is not affecting the data as it comes while viewing the data but is there any way...

I am getting a warning message "Warning: Data that exceeds the maximum display length has been truncated." The length of the column is CHAR(2700). the file has only one column which is derived by merging all the columns of a source table. Though the record can be seen properly through Unix...

Hi
I had recently started working with DataStage tool. When we do audit check on our DS jobs we use the table DS_AUDIT. I wanted to know what all are other tables being used and what are their respective functionality required for the administration purpose?
Ritesh[/code]