DSXchange

Thanks...
Its working when i gave diff date formate.

Hi, In the Informix client database stage, I am writing query as given below: SELECT col1, col2, col3, col4, batch_dt FROM tab_nam WHERE batch_dt<Today-13 units month and batch_dt >= #start_date# But it is not selecting correct set of records. Job runs well and data is also selected, but " batc...

can u suggest some approach with existing resources and technology.

Right now for 10000 its taking 4-5 mins. And later the size of table is expected to be more, so it will go upto 100,000 records or even more.

Hi, I have developed a job, which select records from 1 table and inserts into other table. I have used Informix enterprise stage for source table and target table. I have transformer stage for mapping the columns. The source table has huge amount of data. Currently its more than 10,000. I want to i...

Thank u vey much.

Regards,
Abhilasha

Is their any other way to do this. Can we do this using User Defined Query

Hi, I am trying to use following SQL's in the User Defined section of Informix stage: UPDATE table1 SET update_user_id ='-5' ,update_type_cd = 'D' WHERE merch_num=? AND cso_cd=? AND plan_type_cd=?;; DELETE FROM table2 WHERE merch_num=? AND cso_cd=? AND plan_type_cd=?;; 1st query (Update) is not wor...

Hi, I am trying to use following SQL's in the User Defined section of Informix stage: UPDATE table1 SET update_user_id ='-5' ,update_type_cd = 'D' WHERE merch_num=? AND cso_cd=? AND plan_type_cd=?;; DELETE FROM table2 WHERE merch_num=? AND cso_cd=? AND plan_type_cd=?;; 1st query (Update) is not work...