DSXchange

Some OS's are pretty bad at terminating pids and releasing locks; and it is easier to bounce the DataStage engine than to go in and clean up any zombies or locks. I would guess that if you do that cleanup you wouldn't need to restart. I've seen system uptimes of over a year and the developers can't ...

Yes, this is because DataStage is trying to convert a row's string data to numeric and the data contains non-numeric data. You cannot get rid of this error without actually correcting your data. Perhaps you could put in a derivation such as IF NOT(NUM(In.Column)) THEN 0 ELSE In.Column

ajay - as mentioned before by Ray and myself - check your connectivity. Most likely your rsh rights or perhaps even userid/password have changed and DS can no longer connect to your remotely defined machine. Until you sort this out, you can complain to us that you are only looking at a local sequent...

You've now narrowed down the problem to your source stage and transform stage. You can now try a job which doesn't use an explicit transform stage and just go from source -> sequential file. Does the error persist? If you remove all the columns apart from the key and some small data column does the ...

I'm not at a DataStage box so cannot confirm your CREATE.FILE syntax, in my opinion you would be creating a local hashed file called "/applis/psoft/FSCM4_APPL/CBLKOM/Datastage/Projects/FDM84_90_CBLKOM/HF_T84_PS_SHIP_INF_INV " and that would cause issues when creating the actual files since they cont...

But your missing variable and error is from a list based loop. If you activate the list and remove all text in there, then go back to counted loop, does the error go away?

Oops, I just re-read what I posted. I should have checked the cut-and-paste since I did miss some syllables in the middle line!!! But I did miscount line 1.

Jobs aborting now,
Crash dumps sighing wistfully;
Director missing.

I thought I did a 5-7-5 but I'm terrible at syllables. Pehaps it is my German pronounciation that did me in.

I would either do an external "select count(*)" from a sequence and parse the results in order to conditionally call a job; or do that count in a DataStage job and set the user return code and use that as the condition in the sequence.

SubStrings() checks the string for specific value marks, which happen to map to characters in the German set and thus can (and did) give you strange results.

If you have fixed decimal to 2 places, do "ABS(In.Column*100)/100"

Ok, if you don't believe me, try viewing a DataSet. Do you get the same error? You also didn't answer if this is a new installation or one that used to work but has now changed.

Look at your start loop activity, are you actually using a list and how did you define it?

So you really want the last 3 lines of output per job, is that correct?

That is not an error message, that is a command.