DSXchange

We are extracting multi valued data from a Unidata table into Oracle, which contains an asset number and a current reading for the asset. So when the data normalizes there are multiple records per asset. We want to add a sequence number to this, that would start at 1 with the most recent reading and...

You probably need to have the datastage service running as the same user who has the mapped drive, LocalAccount I dop not believe will have access to this functionality.

I either unchecked the option or took the value out completely, not sure which but I can check if need be, and yes you need to recycle the Datastage service (on windows) to cause the change to take effect.

It was the timeout. It's was set to 24 hours, which is why I only seem to get calls regarding this on the weekends. Thanks for the help.

Wouldn't it make more sense for the timeout to be in minutes or hours as oppsed to seconds??

This morning I found the following errors on the director window(s) that were open on the physical server running datastage. I say windows because there were multiple copies of director open on this server, in case that might have some cause. The errors are as follows Error calling subroutine: DSR_E...

Is there a way to see the values of a ( or all) job parameters in my sequencers, I have a parameter in all sequencers that points either to my production or test database, in several cases I have found that this was not switched when the job was moved into production and would like to find any more ...

I'm not sure about wether or not you could do this on sql server, but loading into oracle, we created files in the format needed by the Oracle bulk loader and then created a stored procedure in oracle that executed the bulk loader as a process on the oracle server. This runs extremely fast, about 35...

Thanks, Setting the user in adminstrator did it, the service was already running as a user instead of local machine so I don't know if I would have needed to change this as well.

I have a job that uses an odbc connection which links to a visual fox pro file residing on a novell server, ver intranetware 4.1.1 service pack 9. When I run the job myself it runs fine. However when the scheduler runs the job it fails with the message all to SQLConnect failed. SQLSTATE=S1000, DBMS....

We have an Oracle table that is updated daily with about 100,000 records, doing and update/insert. This takes us about 15 minutes. Are you doing updates/inserts or just inserts? Do you have indexes on the table? If you are doing updates then this will greatly speed the performace, but if you are onl...

re-installing the client didn't resolve the problem, it had something to do with a dll that either wasn't removed/over written, or was a windows dll.

I had a problem a couple of months ago where after we were hit by a virus, several dll's were corrupted. I believe that after running the fix from microsoft the problem went away. I had to contact Ascential to resolve the issue, but unfortunately I can't remember exactly what they had me do.

Do the tables that you are inserting into have indexes on them? If so drop these before teh insert and recreate them afterwards. We move over 10 gigs of data nightly into Oracle and while we are definately pushing the limits of our capacity to do this we can get the job done during the night most of...

Ok, I have more information now. With the above code, I seem to be getting data that is scattered through out the dates in the table. When I hard code it to look like OIC_RECEIVED_DATE >= "02/01/2004" OR OIC_SYSTEM_DATE >= "02/01/2004" it works fine. Is there some setting that co...

This looked like it was working, but I have recently found out that not all of the data is being pulled over. The Unidata field is multi valued, does this affect the selection statement?