DSXchange

Possibly. This is the 7.5x2 I assume? And are you running your job on a single node or more than one node?

:roll: We're here to help people solve DataStage problems and I gave you what you needed to know to get started. We are not here to teach people Perl, there are plenty of other websites out there dedicated to that. As I wrote, the things you need to do to run DataStage jobs from the command line - r...

Please be specific as to what exactly it is that you tried, without them it is impossible for anyone to help other than to say you are on the right path but must be doing something wrong. Without the details we have no idea what that 'something' might be without guessing. Your last sentence... are ...

Help you learn Perl? Not really what we're all about here. Are you familiar with dsjob which is the command line interface for DataStage jobs? Start there by reading the documentation or searching here, that is what any 'script', Perl or otherwise, would need to leverage to do this.

Two of four questions answered.

NLS enabled? Character set of the source? Character set of the target? What database?

One too many letters, Ray.

And isn't it true that you can only leave off the drive letter if the path is on the same drive where DataStage is installed? May be safe to make the assumption that it is on the C: drive as well, but worth pointing out, me thinks.

Not really an answer or even particularly true. :? What is the difference between the two runs, anything? Or did you literally run the job twice with no changes in the job or environment and get these two results? Your results are not identical as the problem has been reported by two different objec...

Also known as an invalid solution unless they can explain it.

Never mind the fact that the simple and proper solution has already been posted, there's no need for some kind of an 'Alternate Solution Contest' here and no prize for the goofiest... sorry.

One example of how to bind is here.

[sigh]

So... do we have to guess the warning?

Format is fine. Details, please - stage used, datatypes (job v. table), sql used, etc etc etc.

I'm way past making any assumptions about what people may mean here, hence the request for clarification.

Again, manual mode in the Bulk Loader stage doesn't insert anything. So is this happening when you manually invoke sqlldr afterwards? Please be specific regarding exactly what it is you are doing.

Exactly what I saw... and never solved. Just went back to working without any intervention after not running for a couple of days.