DSXchange

Version Control.

The job runs twice a day , and when it runs i have 18 links comming out. Instead of writing to different files and merging or concatenating the files, I am trying to write them to one file with all append option but this file needs to be cleared everytime as this is a full data extraction and not i...

The fastest method would be to not land the data on disk at all, going straight to the output stage writing to DB/2 You might be surprised how often that is not the case in a Server job. Can't speak directly to DB2, but take an Oracle job with two OCI stages with a Transformer in between. Nothing f...

I haven't ask "them" yet.

The key columns are only used for the Update action. As noted, unless the Insert fails the update will never happen. The failure that is expected to trigger the insert is from some kind of unique constraint violation - without anything like that in your target table you should not be using that acti...

Thanks, that's something I am seriously considering having the ^M folks do.

I built some specific test cases and they are showing a problem with the Array Size set to anything other than 1. Sent 200 rows to an Oracle target and used an array size of 100. Made sure two of the rows (13,69) in the first 100 would be bad and cause an ORA-01400 'cannot insert null' failure. It w...

Umm... nothing. There's nothing wrong with what's happening. Any number of character zeroes sent to an integer field will become a numeric zero.

About the only way to 'avoid this transformation' would be to redefine your target field to be character as well.

Again, refer to the Command Line Interface help. Both #1 and #2 are achieved using the dsjob command, while #3 is just a call to whatever you've got installed to handle email based on a returned status code. Something like blat for a Windows server, for instance.

naveendronavalli wrote:Can Datastage return error codes to the calling batch (.BAT) script?

Sure, check the Command Line Interface section of the Server Job Developer's Guide - specifically the -wait and the -jobstatus options of the dsjob command.

You don't have to, but you are correct that I in fact do have a script involved here. Not sure how it could have changed what came back from the job, but I'll certainly ponder that. Perhaps involve my SAs...

Click me -> :D <- for one example. Yes, it's a UNIX script - but it should give you an idea or two.

Is anyone finding that in more recent versions of DataStage and the OCI stages (say, 7.x) that there is still a problem with error reporting and the array size? In the past, if you wanted ORA errors to be properly reported you needed to leave the Array Size at 1. That way if it said you had three du...

Nope. Unless there are dependant sections in your job and you are checking from the 'other side' of the dependancy, none of the stages complete until the job completes.

Typically, people 'wrapper' their call to dsjob in a nice little package (like a Korn shell script or batch file) to make the call more robust. You'll find at least one example posted in the forum. Ours, for example and amongst other things, verifies the project and job, resets the job if needed, bu...