DSXchange

gradkarthik, the line number displayed is not the exact line number of the error message; you need to offset this by up to a couple of lines (this is due to the way the compiler works and has been a problem for years...). The line you listed is a comment, just look downwards to a line that issues an...

Hello afsal_abdul,

several of the lines in your output state that there is a probable orchestrate configuration error. You need to look at your configuration file or post that so that someone might find the problem.

srivvds, the "deadlock" error message is coming from the database, not datastage. Two or more processes are waiting for some resource to be released that the other holds. You should speak with your DBA, who can examine the locks and determine which process might be holding a lock that it shouldn't h...

Hello Salil,

the first error message in your log is

Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".

. Look at your transform stage - do you have a reject link?

You an call external programs from DataStage and, with a bit more work, you can embed external library functions into DataStage. How is this service you are looking into calling normally invoked? If through either of the 2 methods listed above then the answer is "yes"

The concept of a subroutine exists in many, if not most, programming languages. DataStage is no different in this this case. Subroutines are used to re-use common programming code and/or to make a program modular and maintainable. Simple example - if you have a job with 50 Text columns containing na...

Pavankvk, I believe that no production job should generate warnings. So in my opinion it is very important to attempt to program even PX jobs so that no warnings are generated. Sometimes specific warnings are not possible to get rid of in PX jobs, so I will take that warning message and demote it to...

Hello Rohanf, The DataStage basic language doesn't have strict data types and there is no explicit cast function; it is always done implicitly. If you have a VarChar2 data field containing "123.456" in your job you can perform numeric operations or comparisons and it will automatically convert to th...

Hello Aliso,

the format string should be of the form %yyyy-%mm-%dd %hh:%nn:%ss; I am not using a terminal with the PDF files available, but have used manual formatting without problems (well, no problem once I figured out how to define the attributes) before.

If your project isn't broken (a DS.TOOLS REINDEX and clean up doesn't change the problem) then I think you need so submit this to Ascential support, since we won't be able to reproduce it either. Please remember to post a solution so that others may profit from your thread.

Hello Falchetto,

in addition to what Craig is asking (I just assumed that you were using the terms batch and job interchangeably) it might be a good idea to re-rate your assessment of DS skills - it might help in getting relevant responses in the future.

Ahh, I think you might be right (I just tried to find the thread in question but didn't locate it). I've never been proponent of Windows (any OS that schedules by round-robin doesn't deserve being called a modern OS) but I have never really done a cost comparison - and Windows has come a long way.

The UNIX level program "dsjob" will, with the correct options, give you the finish status of any job plus a lot of other information. You can use this as part of a script to automatically get this information.

Start off with the easiest part, look into all of messages in your director's log file for this job run, starting at the end and working backwards. A clearer explanation of the error cause should be visible.

Did you have problems installing DS or the project? Might you still have a UNIX session open (installing plugins, for example) that has locks open? If you execute the UNIX command "list_readu EVERY" you might be able to see the process locking your file, or you can use the UNIX "fuser" command on th...