DSXchange

hi, My job design is odbc(db2).............>xfm...........>seqfile i have column name CYC_DT(date) having some of values 2011-02-23 and some of the values are null and in output i want 20110223 instead of 2011-02-23 and null values show null . I have use convert function convert("-","...

row generator dummy rows having all fields same as in ODBC.

hi craig In odbc field CYCLE_DT showing record 2010-03-02 when i view data and row generator(dummy) showing aaaaaaaa but after funnel in final peek stage i get ********* I have no idea as i am new to datastage could you please explain how can in convert' aaaaaaaaaa' to date. Can i use this functions...

thanks all as you all said i done and got the solution

hi, I am getting thw following error: APT_CombinedOperatorController(1),0: Data string 'aaaaaaaaaa' does not match format '%yyyy-%mm-%dd': an integer was expected to match tag %yyyy. APT_CombinedOperatorController(1),0: Conversion error calling conversion routine date_from_string data may have been ...

Hi ray,

i got these warning only for that two particular fields and couldn't be able to view data in ODBC.If i check peek stage in log these two fields are missing .Can you help me on this?

hi ,I am getting the following warnings ODBC_Enterprise_52: When checking operator: The modify operator keeps field "TP_PLAN_NUMBER" which is not present in the output interface. ODBC_Enterprise_52: When checking operator: The modify operator keeps field "ORIG_GUARD_WTHDRL_NEXT_AMT&qu...

hi ,

I am getting this error in source ODBC(DB2)

CURSOR IDENTIFIED IN FETCH OR CLOSE STATEMENT IS NOT OPEN (DIAG INFO: ).

my job design

odbc(db2)..............>xfm...............>file

This job run fine last week but now giving error.Can anyone help me on this.

Thanks

i am using stringTodecimal conversion in derivation field to convert char to decimal

hi chulett,

i had use the function stringtodecimal but still i am getting 0000.00 records in
target database.
could you please advise me.

hi , My design is...... seqfile.........>xfm.....> . . .................>merge..........>xfm......>odbc(db2) . odbc(db2).....>xfm....> my question is in seq file i have column market_value(char) having value $2789362.00 i have to map this column to target database column market_value(decimal)(18,2) ...

hi ray,

i check the target database from there and even log showing 0 records updated

hi., My jos update design is seq file...........>Xfm......>odbcd(db2) when i run the job and doing upsert(update only) when the job run first it update but when it run again it update 0 records. Job run fine without any error and warning. could you please tell what would be the issue Please reply.

hi my job aborted due to follwing errors merge_53:When checking operator: On output data set 0: Dropping component "PORTF_NM1" because of a prior component with the same name. Merge_53: When checking operator: On output data set 0: Dropping component "PORTF_ID1" because of a prio...

hi dev you are right if master is seq file how can i get these fields..........actually master is odbc and fileds now in reject link are portf_id,portf_nm and portf_eff_dt..... so could you please tell how can i increment the portf_id with one and insert to the reject one target database . please re...