DSXchange

Hi Chullet,

Thanks for the input.. I thought of that option.
If I have 100 jobs i need to have 100 sequential file(since my no of source links and target links may vary job to job).. then again I need to have another job to update the table.

Instead u can directly write to table from routine?

Thx.

Hi
How a variable captured in routine can be outputed to a table?

Thanks
Madi

Thanks for your help.
I could able to write the link information to a sequential file.

Is there is any simple way to write this information into a table.

FYI I am calling this routine after job. once the routine is executed, the information can be written in a table?

Thanks

Hi, I am basically looking out to document the link info.. where u'll be seeing the return from "DSGetLinkInfo" function by default? I tried to write the result of the function, I was not successful. I got the error like following: End of Line unexpected, Was expecting: Assignment Operator...

Excellent.. It is working fine
Thanks..

Hi all Is anyone came across the following warnings: 1. AGGR_SUMAMT: When checking operator: When binding output interface field "TMMBR_ADJ_A" to field "TMMBR_ADJ_A": Implicit conversion; from source type "dfloat" to result type "decimal[9,2]": Possible range/...

Thanks a lot for ur assitance.

I'm using Left Outer Joing.
In the first link i'm taking fields without transformation(Asis) from table1 and table2
in the second link calculating a measure from table1 and table3
and in the 3rd link caluculating some more measure from table1 and table4
I have common keys also

Hi
I am having 3 input links to a join stage and an output link.
I there is any possibility of getting more rows in the output than the input links. ie, if total rows of input links of join stage is 100 and output link of join can be more than 100.

Expecting ur assitance

FYI I am getting this info while running the job..
TRNS_SetTMMBR_F2,0: Field 'TMMBR_ADJ_A' from input dataset '0' is NULL. Record dropped.
Field 'TMMBR_ADJ_A' from input dataset '0' is NULL. Record dropped

Hi In the transformer stage I introduced one new column(TMMBR_F) which has a derivation like if TMMBR_ADJ_A > 0 then 'Y' else 'N'. In the input link to Transformer stage I am getting 100 rows in the output link from TRNS stage I am only getting 10 rows why is that.. Please throw some lights on this....

Hi
How to resolve the following error!

Join_inToTRNS_2: When checking operator: Dropping component "TRAN_ITEM_SEQ_I" because of prior component with same name

FYI I have 2 inputs to a join stage both the inputs contain TRAN_ITEM_SEQ_I. Is that a problem?? then how to resolve that?

Hi all, I have some unix variables and want to set that variables as a parmeters to another job. a) I want to know how to call a job from Unix and set the parameters... to that job. b) Can I recursively call the same job with different parameters.. Hoping ur extensive help in this issue. Thanks in A...