DSXchange

aaah...yup..I got myself into a loop and I have been working since 8 in the morning( should i say yesterday morning..)...time to take a break and sleep... Now we are migrating this project into an UNIX env leaaving this really bad Windows 2003 env and i get this drsoci error..I know I know.. u are g...

Thanks folks.. I dont know what I was thinking...I think I am clear now... YOu configure the ODBC DSN if you accessig SQL Server using DRS stage...WHen you are accessing DB2, Oracle, Informix you dont need to configure the ODBC at all..YOu just need the vendor client softeware installed and connecti...

Thanks Chulett/Ray.. but if I am using Oracle as DB Type in DRS stage...I am implicitly using OCI right ? Then how come I donot get this error when I use Oracoci stage directly... What is the difference between using DRS with Oracle as type and OCI Directly.. This opens up one more Q for me...Is DSN...

Actually I am sorry....I did not give you accurate information...I think I am barking the wrong tree (in terms of blaming the driver)...I am not sure if I tried the ODBC option at all...I always used the native Oracle interface... I always felt the behavior is interchangable (selecting the DBMS type...

No clue why what you are doing would cause the errors you are seeing. I'm just curious enough to ask - why not just use an OCI stage? Or use the DRS stage set to Oracle so it sticks with the native interface? In other words, why use ODBC for this? :? --> That is a very very reasonable question. Tha...

Hello, I am trying to load a table on Oracle database instance ( Ver 9.2.0) running on UNIX. I am using DRS stage which uses an ODBC driver version 9.0.2. (Ascential Version 7.1r1 running on Windows 2003) While loading the table I get 2 Unique key violations and the DB generates this error: ORA-1215...

Yamini..I hear ya.. I faced exactly the saame problem at a client last month..Interestingly, I was facing this problem only on 1 particular table but the rest of them were fine.. (it was one of Peoplesoft EPM implementations).. I left the issue with the DBA assuming its got to do with the table conf...

No Ray. I donot have any after-stage or after-job subroutines. Does the type and properties of the hash file cause this ? I have a dynamic type 30 hash file with the default properties and min modulus of 1. Do you think that matters ? I have a pretty decent speed of reading from teh database into IP...

You think it would take that long ?
Just to write the memory cache to the disk ? 384MB...
Hmm..I would try turning it off and trying it..but I think it would delay the rest of the process...

Thanks for the reply though
-Xanadu

Hello all, My job takes such a long time to finish. I have this in the log : DSD.stagerun active stage finishing This is my job setup: DRS Stage - IPC Stage - hashfile. (Writing from the table into the hashfile.) (Single CPU , 2 GB RAM server) The table size is 10.2 million. All the 10.2 million are...

thats cool... let me restate so that i can confirm if I am understanding it right.. 1) so if I have this in the sequence Routine-->Job 2) I put the trigger in the routine as otherwise 3) enable the "automatically handle the activities that fail.." in the sequence. Then the sequence would i...

Kim, If I still have to explicitly use UtilityAbortToLog/UtilityWarnToLog then what is "Automatically handle activities that fail" option for? My understanding says that if we check "Automatically handle activities that fail" in the administrator the while creating the sequencer...

columns to rows .. I know that using pivot stage I can split one row into multiple columns - but can I do it the other way too.. here is my problem: I have a table like this ID Colname New_Value 23 colA 100 23 colB 200 23 colC 300 24 colA 400 24 colB 500 24 colC 600 which should be converted to this...

Thanks for your response Chandru. But I get this error when I try doing that : db2 "connect to <databasename>"; "String Constant unexpected, Was expecting: Assignment Operator" I am positive that I am doing some trivial error and missing something - but not able to figure out wha...

Array size of 100 and transaction size of 100 fixed the problem :-S
Can anyone help me understand why ?

Thanks
-Xan