DSXchange

PeterPol, when you install the DataStage client on your PC you will get 4 programs: Designer Developer Manager Administrator and the last one is what is being referred to. I prefer to open up a telnet session with whatever tool I have and then entering the TCL environment from that shell (after sett...

Julio, just as on the other thread none of us have seen this error before, and the original poster stated that the same job imported into another project would work correctly. Is this also the case for you? If the error persists then can you make a copy of the "bad" job and remove just about everyth...

The message you posted are informational and are not error messages. When the DataStage sequences are used for the first time in a project the system will create these files and issue these messages. This only happens the first time, after that the file exists and is not created again, so you won't ...

y2ariyas - in this case it might be easier to figure out the issue by using the command line interface. If you set your DS/PX environment appropriately in a shell and execute the command orchadmin ll {path to dataset} could you post the output here?

The file shown is a partfile for the dataset. Check your sytem to see if this file exists or might have been deleted.

I think that your routine contains more than you've shown, since the output line "Arg1 = d:/ds/sam1/sample" isn't part of the normal code, either. Could you change your code portion to read PRINT 'Before' PERFORM Cmd PRINT 'After' to prove that the "Not Found." text is being output by the PERFORM co...

PX formats have to match exactly; in your case the time part in the string is "0:00:00" which I think is causing the problem.

This thread doesn't really point out any timeouts directly. There are some hard-coded values in DataStage that the engineers put in, thinking that no normal system could hit them during processing. As we all know, systems are often used in ways that designers and engineers don't consider and thus wh...

Assuming you aren't trying your job in production, you might try to copy your development DSParams file to this location and see what happens; make a copy of this possibly corrupt DSParams file just to be on the safe side. Can you see the Date/Time modified for this file and try to figure out who or...

It sounds like you have a corrupted or edited DSParams file - can you find the reference to the "Trim" function in there or is it gone?

I can't see anything wrong there at all, except that the SUBSTRINGS function is meant to be used with dynamic arrays; it will work here because you only have one element; but I would prefer to see "BeginLoop.$Counter[1,1] = 'Z'" used instead - neverthe less it shouldn't affect your error. Is this ex...

Linit, you need to take things step by step in order to find out where (or even if) the characters are being converted. First off, do you actually have NLS activated in DataStage? Then do a simple read of your source file and write it out to another flat file. Do not use the "view data" but your fav...

I would say the number intended is 0.35 but somehow that formula doesn't look correct to me - are the parentheses correct? But that only takes one process into account. What if you had 10 concurrent jobs running with different data files that are all at the maximum size? That would fill up scratch q...

And it sucks, unlike his previous book!

The truncation portion of your job occurs outside of the IPC stage timeout.