DSXchange

Now, there are ways to automatically create 200 jobs from the table metadata. A colleague of mine just did something like this to create 478 jobs to extract CDC data to matching flat files. Agnivesh, I responded via private message, but... Send me an email with details if you're still interested in...

Make me a bit weepy.

I am envious. Congrats!

Performance will almost always be better. But, if the Oracle server instance and the DataStage server don't exist on the same box, you won't be able to use the ORAOCIBL, as that stage relies on an Oracle DLL present in the Oracle instance installation (not the client installation). There MAY be a wa...

Sounds like you didn't create at least one project during the install. You may try un-installing the server then re-installing, this time creating one project, like "dev". It can always be deleted later if you don't want it. Seems like there used to be some connection, during install, betw...

Yet another, more straight forward approach is to define 4 Stage Variables, say A,B,C and D. Create your routine with 9 args, the last 4 being A, B, C and D. Inside your routine assign the answers as applicable to A, B, C and D. When you return from the routine, your stage variables are populated wi...

As a final (maybe) note, job parameters are not allowed in User-defined SQL Query files...

I believe you type the entire path (directory and filename) in the space provided (where you would normally type the sql)

Remember, the file will need to be on the DataStage server (not the client).

In DataStage, will you be wanting to connect to Oracle via the ODBC stage or the OCI8 stage?

If via OCI, you shouldn't need to configure anything past installing the Oracle client and stopping and starting the DataStage server.

As of DS 6.x, there is not a way to detect rows that reject via the DB2 (and I think even OCI) stages for PX. The Server functionality for detecting rejects is non-existent in PX as of 6.x and I don't think it's made it into 7 yet. The concept is that if there is a reject, the job aborts, you fix th...

Also, check in Job Properties if you have Row Buffering enabled. Enabling this option, albeit a performance enhancement, has lead to strange errors for us on Version 6 on HP, like dropping a row or processing a row twice (really). Disabling it solved our problem.

DS 390 probably won't help you here since DS 390 COBOL code (should) only runs on IBM 390 machines, but... VSAM files are (at least) two files in one... one for data, the other is an index into the data. What you could is have an AS400 admin run a system utility (the name escapes me now) to create j...

If the data is truely packed, EBCDIC to ASCII conversion won't work. You need to know HOW the data is packed in order to use the appropriate routine to unpack it (and hope the ODBC stage isn't messing up the data on retrieval). Several routines exist to convert packed data, such as DataTypePicComp1....

We're implementing Ascential's "CDC for Oracle" and wondering if anyone out there would be open to a discussion around architecture scenarios? We'd take the discussion off-line and then post back to here any useful information we find. It may turn into more of an "Oracle Replication c...

Casting issues "usually" deal with dates.

What does the DDL look like (i.e. is Yrmtdy a date or timestamp or varchar?)

I think ODBC is expecting a YYYY-MM-DD HH:MM:SS.TTT format.

-Craig Rouse

Didn't mean to ruffle the feathers... This capability has never been referred to as a bug by Ascential, but rather demonstrates the flexibility of DataStage. I've been working with DS since 3.6 (a newbie by some standards) and the capability has been there since at least then. Even Ascential would h...