DSXchange

In the intervening year I would wager they've either solved this problem or given up and moved on to another. :wink: ps. I doubt it is useful for "u" as our dear friend "U" wasn't asking the question. If you actually meant "you" next time it would be great if you actual...

So now you're taking what I assume is the result of the lookup from an integer back to a string with no conversion? Why?

There's no "conversion script" and no need to trim the dang zeroes. Simply call the function with your source column and populate an Integer field with the results. I am waiting for your reply.

Help us help you. Show us the latest version of your function syntax and post the dang fatal error message(s) from the log.

If you have a "lib32" and a "lib" for Oracle, that means the "lib" directory contains the 64bit drivers. You need to match the "bitness" of DataStage and/or Oracle so if DS is 32bit on AIX 5.3 then you should have "lib32" in dsenv rather than simply ...

So... first DataStage job? Do you have any colleagues there with you that you can turn to for some help or guidance? This is all pretty basic stuff and we're not really here as a substitute for training as it is impossible to teach an entire DataStage 101 class in a forum post. :( That was a serious...

Bejeebus, have some patience. You posted at just before 4 o'clock in the morning my time and waited what - an hour - before getting impatient? Chill.

Did you try an exact search for "LinkReport"? I found 17 other examples here, did none of them help?

FYI - if we get no joy here, I would suggest you go straight to your official support provider if you haven't already. That stage in 'automatic mode' does not use command line sqlldr like the OE stage would or how you tested things manually. It uses kind of a back door API straight into the database...

And you are certain that you are qualifying the table name in the stage correctly with the appropriate schema / owner rather than trying to rely on a synonym or does the connecting user own the table? I don't recall exactly how it logs things, if it uses the table name in the sqlldr invocation or in...

And we're waiting for you to clarify your need.

What does "to a database AS400" mean? You need to read a csv file and load it into what - a DB2 database on an AS400? What have you tried? What issues are you having?

The same error? In exactly the same circumstances? And you're running Server jobs in EE 7.5.1 on AIX? Things are fine on your Dev but not on your Test server? The error comes from jobs with an XML Input stage? No? Then it's not "the same error". :evil: :idea: Don't jump on the end of a 4 y...

Exactly, as that is what controls the actual field size. Could you mark your post as Resolved using the button at the top of the page, please?

Was hoping for a little 'self discovery' along the way from gentle nudges in the proper direction.

How have you defined the file metadata in the FTP stage?