DSXchange

OK, convert to a string, take the leftmost N-1 characters, then convert back to decimal.

Welcome aboard. DataStage is also more than 10 years old. How would you load data into a nested table using sqlplus? Use the same SQL as user-defined SQL in an OCI stage. View Data will almost certainly not work, for the same reasons that a standard SELECT statement in sqlplus will not work. There a...

Merge stage.

What changed last week? Clearly "nothing" is not the correct answer.

It's never safe to assume anything. Test your theory and post your results.

It's never safe to assume anything. Test your theory and post your results.

... and the "earliest" of these is the one with the oldest date. We don't do "urgent". If you want "urgent" sign up with your support provider for priority service, and learn just how much "urgent" costs. Here at DSXchange we are a community of volunteers who post as and when we can. We earn our liv...

Windows XP is not a supported operating system for DataStage server so, if anything doesn't work as advertised, you're pretty much on your own.

Welcome aboard. It's not clear whether you are in a server job (you've posted in the server job forum) or a parallel job (you've marked the job type as parallel). There are at least 14 different encodings for Japanese characters, you need to find out which has been used in your file. Chances are, ho...

All the job log stored in hash file with the name of RT_LOGxxx in project dir.I need to clear the logs.Is there any option for the same? As posted in your other thread the answer is no. You can use CLEAR.FILE on the job logs from the TCL prompt (which is NOT the operating system) with the caveats t...

This forum is for "Forum for Master Data Management theory and Razza Dimension Server - a Master Data Management software application". Please don't encourage posting in the wrong place by answering.

It's just possible that 2008102 means the 102nd day of 2008. You need to determine what the rules are, and why you're getting seven digits and whether this is correct. We can't help with that - it's something that you have you resolve with the provider of the data.

trunc_zero

Would your DBA be amenable to setting up a mechanism to create a snapshot from which DataStage could work?