DSXchange

Probably invalid syntax. "Returned value = 0 OR 1" should in reality be "Returned value = 0 or returned value = 1" and I'm guessing it wasn't. That and the Field Mark you'd have to deal with in any Execute Command result.

No field delimiters = fixed width file = char fields of a constant size. No varchars to be had here.

That would have been awesome information to include in your first post, don't you think?

That's crazy talk, as noted I would never design anything of the sort. However... maybe that's just me.

OK, hold on... according to what you posted that's exactly what you need to do. I am not sure if vertical pivot works in this case because from 11th row till end of the file the data should go into one column. So are you saying that the entire file should be converted into a single record? :?

Ok... 1 to 99999, then what happens?

FYI - that function returns just the date from a DATE field which is an Oracle data type that includes the time. Technically it returns the date with the time set to midnight so again (technically) they are equivalent when your time portion is set to midnight. Since you are mentioning their "fo...

There is no such thing as an "infinite loop" in a Sequence job, nor is it a good idea to run one 24x7. At the very least have it stop once a day and then schedule it to restart shortly thereafter.

Does it need to run immediately when new rows are inserted? Or can it run periodically and process any new rows it finds then?

You don't want -jobstatus as that reflects the value the job returned. You should be able to use -wait for a simple 0/1 return status, assuming you want to wait for the job to complete, that is.

Field Mark, I would assume. Try removing @FM from the message.

You can't. Strangely enough, I just had this exact same conversation with a co-worker yesterday. All of the MERGE processing happens inside the database completely out of sight of DataStage, all it knows about is the one record that triggered the procedure / anonymous block. Perhaps it could be engi...

Understood. Have you opened a support case?

I think one of the problems is they don't know where or even if there is anything in the image that may need to be masked. That's the first piece of the puzzle that needs to be solved - finding the text data in an image and then deciding if it needs to be masked. Then comes the image replacement / m...

I'm curious what makes you think the hint is an issue. Are you saying that if you remove the hint that it runs correctly?