DSXchange

Which was why I asked for the Oracle version, to see if that package was available.

Is this is an urgent issue, have you involved your official support provider?

Even if one of your join tables is large and would fit not in memory, you could load it to a hashed file which is then used in a transform stage lookup to join the two tables together.

And for Server, that's not a "workaround" but How You Do It.

I'm guessing (since they move them separately) that the design time information and the run time information don't match. And I don't know how you compare the 'executable' to anything if there is a transformer involved. OSH scripts, sure, but binary code? [shrug] I don't understand why you wouldn't ...

A little old, perhaps but something I just read. Curious if there's been any IBM attention to it.

Whatever they did for 'cron' they now need to do for 'at'. Cron runs multiple schedules, at does one time schedules.

chulett wrote:So choose Record Delimiter String instead and set it to DOS format.

Instead of Record Delimiter.

"0D 0A" are DOS record delimiters - CR/LF pairs. Use #2 for that and #3 for the hex zeroes.

Those functions would need to be coded into a custom routine (or a job's "Job Control" tab) in BASIC. Note you can also get this from the command line using dsjob from the last log entry.

That's because a "Windows newline" is actually two characters, a CR/LF pair. So choose Record Delimiter String instead and set it to DOS format.

I don't know, it's certainly not an issue in 7. Have you asked your official support provider?

If you want to add comments to tables you are creating in your jobs, you'll need to switch the Generated DDL to User-defined and then add the comment clauses manually. Which means it can't be data driven.

That is if I am following your requirement, which I'm not sure I am.

A exact search for OLETYPE might turn something up.

Looks like this can come from a client / database version mismatch:

http://www.orafaq.com/maillist/oracle-l ... 7/0386.htm

This is a new 8.x install, separate from your 7.5 server? Is this the first time you've tried a 'sql loader' job or do others work but not this one?

Not sure what you mean by 'it only has 2 amount types'. And is your source static? If it is a database table, perhaps you're seeing normal changes over time in the data.