DSXchange

Hi , Scenario: select * from product master; pcode desc --------------- 500 Edible oil select * from product_inv; Pcode stck_in_hnd rol ------------------------------ 1 10 20 250 20 30 500 30 40 I would like to have a resultset that has the following fields pcode desc stck_in_hnd ------------------...

Oracle Stage -------------------> [Product_master] Transformer----------------> Oracle stage Oracle Stage -------------------> [Product_inventory] Where is your hash file/lookup table in your diagram? Follow the steps, what Craig mentioned in his reply. As you said All these pcodes 1 ,250 and 500 w...

Can you post some sample data?

CR is carriage return or Cursor Return :( DOS-Line-Termination is CR and LF ( CR=Cursor Return CHAR(13), LF=Line Feed CHAR(10). UNIX-Line-Termination is only LF Important is to write and read with the same kind of termination. If you mix them up you get an error. (to much colums). You can use both k...

Here is one for u.
viewtopic.php?t=109565

Make sure you have deleted your post :D

First try to insert one dummy row with timestamp value '2007-05-21 15:21:00' into target db2 table, and see what output you get. If it's ok then you can try following code. I am using following format to generate current db2 timestamp in my jobs. you can try oconv(@Date,"D-YMD[4,2,2]"):&qu...

I am using following format to generate current db2 timestamp in my jobs.
you can try

Result = 2007-05-21 15:21:00

Are you using server job or parallel job?

In case of parallel job you can't use iconv/oconv function.

Hi , Thanks for the reply here is my job design : ODBC STAGE(SOURCE FILE) -------> HASH FILE-------------->TRANSFORMER STAGE----------->ODBC STAGE(TARGET) AND I HAVE ONE LOOK UP ODBC STAGE I am getting everytime some weird warning when i ran for the first time i got abnormal termination of stage an...

It's Windows 2003 server edition,
BTW IBM gave new version of datastage 8.0.1, But we didn't test it yet.

In output link in aggregator stage, what devivation value you have?
You don't need any group by clause

You will have value like this

Input ==== col1 col2 col3 A,B,C,D,E,F,G a,b,c,d,e,f,g P,Q,R,S,T,U,V It's not displaying values for each column correctly. The value of col1 is till first space(i.e A,B,C,D,E,F,G ), and the value of col2 is till second space i.e.( a,b,c,d,e,f,g ) and for col3 is ( P,Q,R,S,T,U,V ). Presently i am cre...

Can you post the sql you are using insert or update?

Also post log error message for that

Input ==== col1 col2 col3 A,B,C,D,E,F,G a,b,c,d,e,f,g P,Q,R,S,T,U,V Output ==== col1 col2 col3 A a P B b Q C c R D d S E e T F f U G g V I have implemented this I have taken input data into a Transformer, where using Ereplace(DSLink2.inputColumn, ",", CHAR(13):CHAR(10)), i have converted e...

ray.wurlod wrote:U isn't performing the query. bpaje is.

Ray, ofcourse It's not me..
But I had similar kind of issue while joining multiple source table.