DSXchange

mahi_mahi,

Yes, datastage can do this, and you start looking in the .pdf documents on your own PC; plus a search for WaitForFile will also go a long way in helping you do this.

The error is coming because of what Ray and Ken have been posting - the nodes in the configuration file tell DataStage about virtual systems, not actual remote system CPUs (which would then be MPP). To go back to your statement that you want PX to 'round robin' through the interfaces. If you connect...

McZern, regarding row buffering as it applies to this topic, think of everything as varchar() in DataStage; all the columns are concatenated together as a long string with separators. If you want to compute buffering you need to look at the actual contents instead of the definitions. If you have a t...

DataStage PX doesn't know about network interfaces. What you can do is ensure that when trying to balance activity across multiple networks that you use the appropriate IP so that the OS and/or application layer chooses the interface to go through. Most often this is done when configuring your datab...

Veni, in a routine you can issue EnvironmentString = DSExecute('UNIX','env',ErrorCode) The EnvironemtString will contain the UNIX output of the env command, with all <LF> converted to @FM. You can then write some code to loop through all the values to find the ones you are interested in.

You can change this monitoring information in the $APT settings; but I am not quite sure what extra information would come out of this. Perhaps Kumar could explain -

That is a sales-type of open question; the answer is "Yes", there are a number of people here who have done this and can help.

But you need to tell us what you've tried and what the results (i.e. error messages) were.

I am not sure, but I always have felt that when doing composite keys in hashed files the order is based on some attribute that I don't know, perhaps the order that they are entered. So it is possible when not using definitions included from the metadata (manually entered ones) that what looks like t...

The filter command doesn't use files, but stdin and stdout; it works row by row.

Funny, this question has the same answer in a different form from this one which was posted at almost the same time :D No, DataStage strings are not allocated as the contiguous memory blocks which most compiled languages use. This is a strength of string handling in DataStage, since a string can be ...

Loveojha2, the underlying engine in DataStage has never been typed and doesn't restrict string data types, the concept of "length" has been limited to display lengths and the string mechanism doesn't reserve contiguous blocks in order to store strings. Parts of this approach have been inherited in D...

I did the same here and it said 1 in use, 8 available and there are more than that working on this environment! I wonder if this is an older program using the old licensing scheme?

I don't know what else it might be - if nothing shows up in your DB/2 logs then I think it is time to contact Ascential/IBM support.

If you have a transform with OutB and OutC StageVar - FoundCrap, 'IF In.Col1='CRAP' OR FoundCrap THEN 1 ELSE 0 StageVar - FoundCrap1, 'IF In.Col1='CRAP1' OR FoundCrap1 THEN 1 ELSE 0 StageVar - FoundCrap2, 'IF In.Col1='CRAP'2 OR FoundCrap2 THEN 1 ELSE 0 constraint for OutA : NOT(FoundCrap) OR (FoundC...

General P. :D

Thanks, I've cut-and-pasted that to my personal DataStage factoids file!