DSXchange

DataStageBackup.bat is on my tips page. There are lots of posts about it so search for them.

Harsh, Craig. Very harsh. He is NOT a 2B any more. He has arrived. No slave work for gurus.

You are looking for work in Texas. Is Dallas okay?

The biggest issue was the values did not match between the DEV box and the TEST box. I also could not get it to match the Server values. PX KIM DUKE Peek_6,0: Exampl:-6172057588758100840 Peek_6,0: Exampl:5367974083337241752 Server KIM DUKE Peek_6,0: Exampl:-1725671448 Peek_6,0: Exampl:-1515929771 Co...

Not 2B

I loaded this up and it works great.

Thanks Kim.

P.S. Send me an email if Dallas sounds okay.

Michael I got this to work but it is inconsistent. I am not sure I am compiling correctly. I am on an AIX box. /usr/vacpp/bin/xlC_r -O -G -qspill=32704 crc32.C mv shr.o crc32.o To compile the command line version: /usr/vacpp/bin/xlC_r -O -qspill=32704 crc32.C mv a.out CRC32 To test command line vers...

That is my point. I have not done this in PX. I am working with PX but to hack a solution then I need to know what OLETYPEs they are using. I should be able to figure it out.

I read that book. I liked it. Zen and the Art of Motorcycle Maintenance.

Ray you shock me.

I prefer to telnet into the DataStage server instead of using Administrator. You need to get to TCL. Search for TCL commands and you can see a lot of posts. EtlStats includes a lot of these SQL statements. My tips page now has a link to the EtlStats install video. This explains how to do TCL commands.

Who cares. If you have need then go for it. It is fun making DataStage do something it was not designed to do.

I would start here. select DS_JOBOBJECTS.OLETYPE AS STAGE_TYPE FMT '20L', Count(*) As Cnt from DS_JOBOBJECTS group by STAGE_TYPE ; You may want to pick a specific job. select DS_JOBOBJECTS.NAME AS LINK_NAME FMT '35L', DS_JOBOBJECTS.OLETYPE AS STAGE_TYPE FMT '20L' from DS_JOBOBJECTS, DS_JOBS ...

There is a routine which creates DDL from DS_METADATA called KgdCreateDdlMetadata. It is on my tips page. You could easily modify this to do the same from hashed file of your choice. You need to extract the table names and column names into this hashed file.

You need to figure out what your stage types are. I would need to research where the SQL is stored. I wrote a routine once which can extract table names from SQL. I would need to go look for it. I was written for Oracle. It used a list of all the Oracle keywords to parse the SQL. I wrote it at BellS...

Awesome. Thanks for not passing me yet.

Ray will teach you the cool stuff. So will Ernie.