DSXchange

Or you can give this a shot:


I seem to recall it converts numbers into words.

Yes, if possible. Are they straight inserts? And not necessarily the Bulk Load stage, more likely just a command line scripted sqlldr call.

FYI... switching to the thick drivers didn't change the job's behaviour.

Why would you not bulk load something like this?

We're working through the trials and tribulations of consuming UTF8 XML data in a MSWIN1252 world. Have no problem with jobs that leverage the OCI stages to connect to Oracle, that was a simple matter of overriding the NLS_LANG and LC_CTYPE environment variables in any jobs that source the XML. Conv...

I can't speak to the specifics of 'Mainframe DB2 tables', but the general answer to the question 'can we connect to two different databases in the same job' is - heck, yah - you betcha.

I stick with one job to create all three files, then cat.

Typically, you'll want to generate the three files separately - header, detail, footer - and then cat them together in the proper order after job.

Why aren't you able to 'implement Arnd solution'?

Yes - I haven't but I do recall at least one someone posting here with a virus scanner induced problem. A search should be able to turn up the post, I would think.

You're right... it's over on ADN. Knew it looked familiar. Turns out your syntax isn't quite right, even when fully pathing the files - you can only fully path the first file. If you supply a full path for the second argument you get the error you posted. Try: rename E:\file1.csv file2.csv and you s...

edward_m wrote:I tried the above in execute command stage..its giving the following error
The syntax of the command is incorrect

Don't you already have a post on this issue?

Tatiana wrote:If I already have my ASOF parameter in mm/dd/yyyy format, do I need to have TO_DATE? I can just say
AS_OF_DATE = '#ASOF#', right?

No... unless your date parameter's format matches the NLS date format of the database, but I for one would never make any assumptions there.

Yup! Forgot to mention that...

There's no such thing a 'Oracle formatted dates'... and yes, you could override the date format but that in itself wouldn't speed anything up. What might is this: AS_OF_DATE = TO_DATE('#ASOF#','MM/DD/YYYY') Again, the format of the date won't matter as long as it matches the mask. If you are...