DSXchange

What i meant was if we have a stage that runs sequentially the data will be available on the conductor node (partition) [only if the stage runs parallely the data will be partitioned across available nodes else only the conductor partition will hold the data, this is what is presume] and suppose tha...

The join stage will first sort the input streams according to your join key(s), unless that has been already done or explicitly turned off. That way the join mechanism can process the data without having to store large amounts of interim data in memory or on disk. The one question that is bugging m...

There was a small typing mistake in my earlier post, sorry for that : I have a little confusion here as The DB2 database stage runs sequentially and if i connect it to a join stage which runs in parallel the DataStage will partition the data across the nodes and when this happens i guess there is a ...

kumar_s wrote:APT_CombinedOperatorController might have suppressed it.

Supressed in the sense it is present but concealed under the combined operator because that is what i also supposed intially

The score of my job is : main_program: This step has 9 datasets: ds0: {op0[1p] (sequential db2StgHaspCifDetailLkp) eOther(APT_HashPartitioner { key={ value=ACCOUNT_NUM, subArgs={ cs } } })->eCollectAny op1[1p] (parallel APT_CombinedOperatorController(1):cpyHaspCifDetail.lkpStgHaspCifDetail_Sort)} ds...

ray.wurlod wrote:Since you are on version 7, you probably will get away with changing the READONLY attribute in the Repository table DS_JOBS. You may need to change a record in DS_JOBOBJECTS as well.

Can you help me with the universe queries that will unset this read only flag in the above mentioned tables

Hi Is there a means by which i can pass DataStage NULL as an agument to a parallel routine ? in server routine there is no such problem NULL values can be passed into and can be checked within the routine using IsNULL(). Is there a specific input argument type i should select for parallel routines s...

when we use setnull() it would be out band null but how to convert out band null to in band null; makenull will do the vice versa how abt the other side?
And where do can we make a choice of using in band null or out band null for nullable fields?

ray.wurlod wrote:Read the manual. Null is represented internally as a byte with only its most singificant bit set.

Could you please tell me which mannual would help me in this regard

priyadarshikunal wrote:But i dont think you need to do anything special just to handle null values, it shouldn't drop any record.

Transformer_46,0: Field 'DELTA_FLAG' from input dataset '0' is NULL. Record dropped.

It is dropping records when null value is passed as an argument.

Hi, APT_CombinedOperatorController(0),0: Conversion error calling conversion routine date_from_string data may have been lost The above warning comes when DataStage encounters a string that cannot be converted to date for example "99991331"---->here month is 13 which is invalid To handle ...

main_program: This step has 1 dataset: ds0: {op0[1p] (sequential DB2_UDB_Enterprise_320) eOther(APT_HashPartitioner { key={ value=AP_NUM, subArgs={ cs } } })->eCollectAny ------->did this operator merge with the above one ? op1[1p] (sequential APT_CombinedOperatorController:Join_323.DSLink324_Sort)}...

Operator Combinability says that if more than one operator can be combined into a single process they will get mingled up and eventually run in single process reducing the overhead of passing the data from one process to other................ keeping this in mind i have the following question: Can t...

It worked when the type of input arguments in the routine was changed from char to char*, guess the transformer passes the address and not the values to the Parallel routine. I would be very thankful if anyone helps me in handling NULL values in Parallel routines, when i pass NULL able columns as ar...

Wrote a small Parallel routine to get started with........ this one takes 2 integers and returns the sum........works fine Hurray!!!! But due to some reason the routines with character arguments are not working I am trying to pass 2 char arguments and then check if they are equal, the function retur...