DSXchange

Thank You. I will think twice before I move on to it. I do not want to open another topic. I have seen couple of forums on renaming the jobs. So i went ahead and renamed the jobs using update statements given to update DS_JOBS and DS_JOBOBJECTS. Do you think is to ok and safer to rename the jobs by ...

Thank You. I will think twice before I move on to it. I do not want to open another topic. I have seen couple of forums on renaming the jobs. So i went ahead and renamed the jobs using update statements given to update DS_JOBS and DS_JOBOBJECTS. Do you think is to ok and safer to rename the jobs by ...

Thanks for your information. I did try renaming of jobs using Update statement and that was the reason i was thinking if there would be column for Full Job Description too. For Renaming i updated ds_jobs and ds_jobobjects. Would that be sufficient.? Is that the safer way to do it.?

Kalyan

Hello

Is there any script or any way in datastage we can do a mass compile.

Thanks
Kalyan

Thanks for the Reply. I would like to know how to update or clear the table with sql. If at all if you can specify the column and table name that would be great.

Thanks for the help in advance
Kalyan

Hello All,

We need to Clear all the Job Description Created by Version Control in all the Job Properties. Is there any easier way (like SQL) to Clear all the Job Descriptions for all the jobs.

Thanks
Kalyan

Hi, I would like if i can create and run jobs using datastage client version. Reason i'm asking is, we have around 10 developers who are working on the server and it slows us down. So i was just thinking is there could be a way to work using client version instead of installing server version in all...

I tried using system variables. But the problem with that is counter is being added for each record. It does not summarize the value.

Thanks
Kalyan

We have three load odbc stages. At the end of the job i need to write a control report which should show # of rows loaded in stage1 , stage2 stage3.

Thanks for the help
Kalyan

Hi, I'm new to Datastage. All the time i was working in cobol and we are used to increment the variables and use them in control reports. Can we build something in datastage similar to that where we can increment a variable and use the vairable to write a control report. Please let me know if this i...

HI,

I'm trying to load SQL Server Table using BCP Stage. The Job works fine if i give an user id and password (USERid was created for that specific database). If i try to use NT id and password it gives login error.

Thanks for the help in advance
Kalyan