DSXchange

You can split the new name from the old name with an EVAL.

Do a search for TCL commands. Here is the TCL command:

select * from DS_JOBS ORDER BY NAME;

Ray only developers down under are punctilious or are the only ones who would admit to it.

Look here http://www.dsxchange.com/viewtopic.php?t=95821

hi KDuke, I downloaded etlstat & imported into DS but now I cannot delete them.. ? This solution does not work for me, because we have very limited access to DB, therefore I'm still searching for solutions based on hash or files only (anything that's only limited to ds, w/o touching DB)' Thanks...

You hacked the DSX instead of hacking the repository directly. Nice.

Can you use a period or a backslash?

Well, anyway the categories are stored in DS_JOBS. You would need to hack one to figure out what it needs.

You might be able to copy the job control code from a 7.5 sequence job to a 7.1 batch job. I doubt if you can import the job.

I think he is talking about RT_LOGnnn. I am not sure it gets created when a job compiles or not. Try it and let us know.

You guys are on another wave length.

Call support at IBM and get the patch.

Is this Anil? If so then call Ron. He got it first from ASCL. There is a dll they sent which goes into the DataStage client folder.

Once you have validated the columns this way and this will only validate a straight copy of a field then row counts are very valid on a on going basis. You may need to validate this way again if you change the ETL. These are all ideas to get you started if you are stuck or have never done this before.

Some more tips. If you have the source keys and a dblink back to the source then you can validate a field by select the source keys in the target table and join them to the source table where target.column <> source.column. Very easy. Count these and then do outer joins to see if there are missing k...

I would out all DataStage users in one group like dstage. I would change the projects so other groups cannot read or write to these directories.

chmod -R 770 ProjectDir

or

chmod -R o-rwx ProjectDir

Write files to /usr1/shared or somewhere outside of the project.