DSXchange

If you run the job from inside a Job Sequence, set the Execution Action in the job Activity to "Reset if Required, then Run".

That sounds reasonable given your findings. I believe that DS finds the TNSNAMES based on the $ORACLE_HOME environment variable setting. ie. $ORACLE_HOME/network/admin/ $ORACLE_HOME is set in the file $DSHOME/dsenv. On my server $DSHOME is /opt/Ascential/DataStage/DSEngine. I'm not confident of a so...

I'm not sure, but since no-one else has posted I'll give it a bash. In the Format tab of your SEQ FILE stage, try setting the the Default NULL string to 000 (hexadecimal zero). This might work, but might kick up a fuss when there are many of them making up a string. Alternatively, you could use a fi...

I'm not a DB2 user, but I'll have a go... I think you're barking up the wrong tree. The DS log message you pasted in is just showing you the columns in your plug-in (look at the Columns tab of the DB2 plug-in stage) - this is before it even gets to the SQL. The question marks in your SQL are known a...

As Ray said, oerr will tell you more. I have included the oerr details below. This is a problem with the (Oracle Net) communication between the Oracle client on your DS server and the Oracle database on your database server (this still applies if DS is on the database server). It is almost certainly...

Thanks Ray. Problem is the whole thing is inter-related - believe it or not this is all related to a single client project. I have lots of job sequences because there are small ad-hoc streams that just run on request, but the big overnight run does EVERYTHING with dependencies all the way down the l...

Hmmm. I might have to leave this one to the experts. Have you tried the debugger? Right click on the output link of the Transformer and select Toggle Breakpoints, then compile and select Debug/Go from the action bar. The job will pause when the first row is ready to be output fro the Transformer. Ch...

I am having a bit of trouble understanding the English translation of this problem, but now I think I have it. You have two independent jobs with output links to a Sequencer. The output link of the Sequencer is to a Routine that writes a log file. You want the Routine to fire whenever there is a fai...

It takes about 30sec to 2mins to compile ANY (single) routine on our server. Job and Sequence compilation is fine (about 10sec for a job with b/w 2-10 stages). In fact, just about anything you do working with routines is slow: renaming, deleting, compiling. Deleting a job or sequence incurs about th...

Is TRANS1 the name of the transformer stage? If so, then ther error is referencing a line of code generated internally by DS. Makes it hard to debug, huh? :? In the Stage Variables of the transformer, check whether you are forward referencing a variable. eg. Variable number 5 references variable num...

Like kcbland sez about UNION ALL - you can do it by concatenating text files. A nice way of doing this with DS is to have each of your separate SQLs feeding into a Link Collector stage.