DSXchange

I don't believe you can. From the command line, that is.

Thank you for confessing your sin, my child. It helps all of us.

Hansel and Gretel? Trail of breadcrumbs to know where they've been? Eaten by the... ok, never mind. I just mean add debugging statements, lines that write to the log using DSLogInfo at key points, like you'd do in C for example with printf. "Made it to A", "Now at B" or whatever you deem to be appr...

Weird - who set this up for you? This is the significant part... ORACLE_HOME=/u01/app/oracle/product/10gR2/db_1; export ORACLE_HOME ORAHOME=/u01/app/oracle/product/10gR2/db_1; export ORAHOME LD_LIBRARY_PATH=/usr/lib:$ORACLE_HOME/lib:$ORACLE_HOME/lib32:`dirname $DSHOME`/branded_odbc/lib:$DSHOME/lib:$...

You need to put in 'breadcrumbs', write to the log at various points so you can figure out where it is dying. There's no batch debugger.

You'll also need to reverse the order you declare the Oracle libraries - DataStage is 32bit so the 'lib32' library needs to come first. Unless you know for a fact everything you have is 64bit...

They are not in the order you've shown here in the actual dsenv file, are they? That obviously wouldn't work as they would be set 'out of order'. I also see you are using $ORACLE_BASE to set your $ORACLE_HOME value - is that also being set somewhere in the dsenv? I would make no assumptions about wh...

So... since your question is actually about capturing it as a reject from the DB2/UDB stage... you recognise the fact that you can't 'insert string into an integer column', yes? What happened when you setup a reject link from the transformer feeding the database and tried to capture that error as a ...

Hard to say, especially without more information. What does your job design look like? Are you using Automatic mode? I know you said you are using it for the very first time, but has the stage ever worked for you? Are there any other error messages in the log besides the abnormal termination ones? I...

Also, bear in mind that MCM ( Multi-Client Manager) will not work properly if you have 'Version Control' installed. You can have any one of them, not both. I know there's something to that effect in the MCM readme, and it's been awhile since I've had a need for the MCM but I think that's a little t...

You can get this problem when pretty much any error happens during a direct path bulk load. That's the price you pay for the speed of a direct path load - any problem will leave indexes in an UNUSABLE state.

That's it? We can't help if you don't give us the information we'd need to help us help you. Details please. How is your command attempting to get this 'integer o/p'? Are you running a script or an O/S command? Post them - the script or the command(s) you are using... The job parameter you are tryin...

Bitmap indexes are notoriously picky and prone to going bad during a load. As people have said, have a chat with your DBAs but I'd bet you'll need to drop them before the load and then rebuild them post load.

Ok... details, please. You've never said what exactly you are executing in the command stage, postd the script, what kind of information you are returing, how the parameter is defined in the job it needs to be used in... nada. Let's start there. As much information as you can stand regarding what yo...

I don't believe you can use functions in expressions in your release, pretty sure that wasn't added until 7.5. From my 7.5.1A readme: - Expression Support BASIC-like expression syntax has been expanded and is now allowed in most job sequence activities. Context-menu help is available when editing ex...