DSXchange

It is saying that the link mentioned has a 'Abort after' row limit set in it and that it hit that limit. You need to check that, see why it is happening.

DSMaestro wrote:DSGetJobInfo(GetJobStatus(JobName), DSJobController)

Your syntax is bad and you need to let the routine do all the work.

Welcome. Best to take a stab at the documentation first - bring up the docs Bookshelf from the Start menu and then open the Parallel Job Developer's Guide pdf. Appendix B lists all functions, and the first section has the Date & Timestamp specific functions. Keep in mind the fact that a day is 6...

Did you try using the macro instead? Did you try looking up the error codes? They are documented.

Recheck the syntax. It requires a job handle, not a name, so you'll need to put it in a routine and add a call to DSAttachJob(), then call it with the appropriate InfoType: jHandle = DSAttachJob(JobName) jStatus = DSGetJobInfo(jHandle, DSJ.JOBSTATUS ErrCode = DSDetachJob(jHandle) Begin Case Case jS...

ray.wurlod wrote:

chulett wrote:Kaboom.

Someone is channeling Marvin the Martian!

Who, me?

I don't see how that would affect only the use of sqlldr and not OCI in general, but hey fixed is fixed...

Date generation? Did you perhaps mean data generation? Regardless, your question is way too nebulous for anyone to answer, can you... expand on that a teensy bit? Rephrase?

Kaboom.

And just to be perfectly anal, can you still run the OCI Bulk Loader stage against the original instances?

These 'normal' ODBC connections, are they setup with the wired or the non-wired drivers? The former will work without an Oracle client on the DataStage server while the latter (and any OCI stages) require a client to be installed and for DataStage to be properly configured. This 'configuration' that...

Does anyone know exactly how long is "too long" for a SQL query in the OCI stage? I'll ask IBM, but hoping for a speedier answer here, if anyone knows. Trying to cut one down from over 2000 lines, ~40k bytes.

Thanks.

Use of the FTP Stage as a source is your only other option I can think of, with all the normal caveats it brings being metadata-driven and all.

Yup - your constraint says both need to be non-null to pass. You want an or rather than the and there to say it's only bad if both are null.