DSXchange

Not quite; MonthFromDate() returns a TinyInt which may only have one digit. That would need to be padded.

You can see the entirety of Arnd's response.

Another possibility, to lose the first five characters, is to take the rightmost portion of the string:

The directory in which ls.op is exists, but what about the directory it's meant to be listing? Does that exist and do you have requisite permission to it and its parents?

Sort and partition on the third column, which is declared as the "key" for the purposes of the Remove Duplicates stage.

Sequential Files don't have keys anyway. They are accessed sequentially.

My, what a big typeface you're using!

chrisjones wrote:Hi ,
I am working on new project and need documents related to RTI Stages,MQ Stage and XML..can anyone please forward the documents or send me the link or guide me where can i get .

If you have these stage types installed in the project then you have the relevant on-line help and manuals too.

The limit is not in DataStage - it's in UNIX, which is why you can address the problem with the UNIX ulimit command.

A process terminated unexpectedly. That's all the information you've provided us. What do you expect us to do with it? There are very many reasons a process might terminate. Were there any other warnings logged? Do you know - or can you ascertain from the score - what player 15 actually is on node &...

And, as noted, the Null Field Value for fixed width must contain the same number of characters as are defined for the field.

As I said earlier, and Arnd confirmed, DataStage operates in its own shell, so does not have a stdout/stderr in the conventional sense.

How is this question different from this question that you posted in the General forum?

Posting the same question in multiple fora won't give you better or more answers - it only serves to annoy those of us who read all fora.

Interview question?

Did you find nothing on an internet search?

I have a particular definition of subroutine that stems from a background in UniVerse BASIC; it's a section of code that is called from another section of code, but does not have to return a value.

Hi karry450

I don't have a desire to have DSXchange die through lack of funding can you please obtain a premium membership?

Thanks

What precisely is the data type in the target Oracle column?