DSXchange

And of course I agree 100% with Ray's last post, as I don't use any of the bulk loader stages myself.

If this is your DML:


then you have a trailing comma

It appears you are not passing a properly formatted timestamp string as well as your user-defined SQL does not mask to 6 decimal places.

It's like: What do you prefer, a kick in the head or a punch in the gut? Both stages suck, which one sucks less for your situation? With the ORABULK stage you will have to initiate the sqlldr command line manually. But, you can add switches to sed the CTL file to your liking.

I'm confused, I thought you wanted a reusable CTL file for "on-the-fly" loading. If you have the ORABULK stage just use the APPEND option in the load properties.

Are you using the OCI stage with a 9i or 10g database? If so, the generated SQL should work fine.

Programmatically open the CTL file, go to the line that says "INSERT", and change it to "APPEND".

You mean using ksh or DS Basic from a before/after routine call? Seems straightforward to me, pick your poison...

Thanks for sharing, since you did all of the work, your solution is here for everyone. Had I posted it, I would have marked it Premium.

You need to store your sequence number somewhere when the job finishes and then the next time the job runs it knows where to get the sequence value. Consider using job control to feed it to the job, or use a stage variable and in the initialize cell do a routine call to go fetch the starting value.

Since you're on Windoze you can't do a "head -n2 yourfile" unix command. You're going to having to write your own. For small files you could just use DSExecute API with command "type yourfile" and then use the first two rows in the screen output variable. But for large files you might as well write ...

The compiled routine is requiring 3 arguments per the message. Check the routine and if necessary recompile it. See if the job complains again after you recompile the routine. If this is a standard before/after Routine there are only two arguments allowed, it it's a custom Universe function then mor...

Emails are easy in unix, just use mailx and pass it the space separated list of addresses.

1. Thou shalt remember that PX comes with Server as well, so decide when to do it as pure PX and not. 2. Thou shalt spend remember not to hog the server nodes until running full stress tests. 3. Thou shalt use a wimpy node pool during minor test runs so that Director doesn't crawl and (-14) errors d...

Why use bourne shell? You can use korn shell and have lots more functionality. Just stick this as the first line in your script and it will work under the korn shell interpreter: