DSXchange

I am unable to login to the DS IBM server 8.0 from Designer.The security info in the repository is screwed up.Please help me.

Hi, I have one problem in my job. I have to compare source table and look up table based on key column using look up stage. If any mismatch records between these tables, then I have to store those records in particular column 'R' flag in RPRCS_C column.. If these records continiously retained in nex...

Yes! that is the derivation for unique primary key. How can i take reject link from transformer?..... Can you explain briefly how to resolve this?...

Hi, My source table having 14,00,000 records. When i have tried to insert the records in to database, out of 14,00,000 records only 10,00,000 records only inserted. Even i have checked in source table any records are duplicate. There no records are duplicate. I hope there is some problem in creating...

No. My condition is if date and ro_code are same i want to combine multiple rows into single row

Thanks

Hi Arndw,
I want to combine output like this


01/10/2006 12 REGION 0 1 1 0
02/10/2006 12 REGION 0 1 1 0

can u help me how to combine?

Thanks

prabakaran

Just i want to know how to combine identical rows(date)in a column sample data date ro_code desc mv sv uv C 01/10/2006 12 REGION 0 1 0 0 02/10/2006 12 REGION 0 1 0 0 03/10/2006 12 REGION 0 1 1 0 01/10/2006 12 REGION 0 0 1 0 02/10/2006 12 REGION 0 0 1 0 CAN ANYONE PLZ HELP ME HOW TO COMBINE IDENTICAL...

Hai, I have tried to view data in odbc. Unfortunately the job has been locked. I went to director and select cleanup resources then i have select the corresponding job id and i have pressed logout button. But, that job is not log out. Even i have tried job by process and i have selected RELEASE JOB ...

Yes, that was true. I got some warnings. Then i have read ur mail clearly. Then , i have understood the concept. And applied ur code. Atlast i, have received data with ur help. Now, my job is working fine without any error and warning. Thanks Chulett.

Thanks for timely help. :D

Yes,

Thanks to Everyone.

Sorry, for the mistaken. Finally, I have solved my problem. Thanks to Everyone. Particulary Chulett.


Thanks for ur timely help :D

With Regards,

prabu

Hai Chulett, At last I got data for that column. But Still i have problem. I have applied ur code. But I did not get the correct result. Same Source data has inserted(22/12/2006) in to the target stage like this (22/12/2006). My table Both Source and Target no primary key. How can i solve that? :(

I have tried Even this code also. OConv(IConv(Link.Column, "D"),"D-YMD[4,2,2]"):" 00:00:00" . Still I am getting Null value for that corresponding column. My target is OCI Stage. Column Name : Earned_date Datatype: TimeStamp Length :20. Source Date Format : 21/31/2006 d...

Guru, Is your code convert the date format MM/DD/YYY(12/03/2006( TO DD-MON-YYYY(03-DEC-2006) like this? pls clear my doubt.. And I have one more doubt. I need date format like this 03-DEC-2006 in OCI stage. Is it possible to change the date format inside the OCI STAGE like this ( To_date(Mycolumn DD...

Hai, I want to convert date like this MM/DD/YYYY IN TO DD-MON-YYYY. My Source is Oci Stage and My Target also Oci Stage. My Date Column Name is Earned Date in source (VARCHAR 38) NULL - YES, In My Target Column Name is Agg_Earned_date(DATE ) NULL -YES. I have written query in transformer like this O...

Thanks for ur kindly reply Arnd,

I got answer. I have applied the condition with sql query in OCI stage.

Now, the jobs are working fine. :D