DSXchange

I'd have a serious chat with whomever is generating that file for you, that sounds completely... nonsensical. Can you post a real example of the file so we can get some idea if the contents can be used to determine which target column they belong to?

And no, I don't see RCP as an option here.

Not really sure how the transformer solution would be cumbersome. All you seem to be doing is putting a new column on the output link and adding up the other three. Yes?

What have you tried so far? What issues have you faced? Are you using the CFF stage to read the file?

They're asking if there will be a locking issue in this scenario, not looking for a way to lock the table. The answer is no, you'll be fine.

What can we do ? Must we make all the project directories read only ? Do that and nothing will work. You need to ensure that all files are fully pathed, as in from root. It's not enough to specify 'a directory' as any relative path will still be relative to the active project. To me this is both a ...

This has nothing to do with DataStage, in case you were wondering. While you could search online for that Oracle error, I'd suggest having a chat with your DBA for an explanation as to what is going on. They may be able to increase the amount of 'rollback' on the instance or ask you to run the job a...

That sounds to me like a conversation you should be having with your DBA.

No, that's perfectly valid. The former shows that the field has an explicit decimal point while the latter is for an implied one. Perhaps DataStage doesn't like it but it is perfectly valid.

Here's the other conversation, not sure how much help it will be however.

viewtopic.php?t=151383

OK... been quite some time since I've had any hands-on time with COBOL, for whatever reason that just looked wrong to me. Guess not. :( However, I do think there was some recent discussions that the importer doesn't like the "-" syntax but the "S" one should be fine. Let me see i...

Do your examples actually have two 'dots' in each of them? I'm assuming the trailing one is the issue if those are accurate.

As already noted, if you have both Oracle "lib" and "lib32" directories, switch to "lib32" for your LIBPATH and see if that fixes it.

Yes. Only use a 'generic' function when there isn't a specific / dedicated one for the task.

Can't check right now but I seem to recall a 'date from timestamp' function as well as a 'time from timestamp' one.

I checked my 8.5 documentation and string_trim() is the only one I could find, none of the ones you listed show up for the Modify stage.