DSXchange

Glad what you did worked for you but wondering how you have any idea that the original poster 'previously used a Oracle stage'... 3 years ago.

koti9 wrote:There is no provision to mention the key in the schema file.

Actually there is, hence my question. Let me see if I can find you an example here.

viewtopic.php?t=133949

koti9 wrote:As i can't mention the key in my original schema file

Sorry, but... why can you not?

tehavele wrote:I tried hash partitioning and sorting but it dint work.

The fact that it works correctly on a single node and didn't when running on multiple nodes implies your hashed partitioning is not set up correctly. Can you detail your settings for that?

And Koti, when you do - please stop quoting everything you are replying to. Save that for when it makes sense, otherwise learn to love the Reply to topic link.

Kel wrote:And commit if the insert is successful.

You don't as DataStage will do that automatically. No need to leverage the CLOSE command for that. Arnd already covered rollback.

A bit confusing and I'd rather not make any assumptions... here is where an example would come in handy. Can you post samples of your input and then based on those input records show us what the desired output would be? And your source is what - flat file, database table? I'd also be curious what, i...

An exact search here for "Unable to allocate communication resources" returned 54 matches, you might want to start there.

No. Or at least I don't see why it would. Once you leverage the filter, the stage is no longer reading the file itself. It runs your filter command which outputs data to stdout and the stage will consume this stream via stdin.

Off the top of my head, you have to query DS_JOBS to get the JOBNO associated with the NAME of the job. All of the project hashed files related to jobs have the job number in their name, i.e. RT_LOG123 for the job whose internal job number is 123.

Unfortunately, as a Moderator I have no such power... moving and editing posts is the extent of things I can do that are out of the ordinary.

anajitKS wrote:In the developer's guide , there is no mention of any format other than 'hh:mm:ss' for TimeToString funtion. Am I missing anything ?

What you are probably seeing is the default format, you should be able to use any valid time format codes in the function.