DSXchange

It is on the install cd. There should be a program item for installing plugins on your server in the Ascential Datastage program group. Read the pdf that's on teh cd though as you will need to import some information off of the cd before you can use this. Search this site, there is definately more i...

I hard coded the data and it worked, i.e. OIC_SYSTEM_DATE >= "02/04/04" and this worked, but I need this to be dynamic.

Is the C++ compiler casuing name mangling to occur? Depending on the settings used by the compiler, c++ will add unusual symbols to the function name so that is can support two functions with the same name, but differnt parameter lists/types. In this case a function name GetMyFile might actually loo...

I have two date fields in a Unidata file that I would like to use as criteria in order to limit the number of records I am returning, but I have not been able to figure out the syntax to use for this, instead of getting the limited number of records I get everything back. The syntax I was trying to ...

We are using bulk loader files created with a sequential file in our environment, but found that our network connection greatly slowed the bulk loader. To get around this we copy the file to the oracle server and created a stored procedure that invokes the sqlldr on the oracle box. Using this we can...

I'm not familiar with the ODBC stage, but if you are trying to get the value back, wouldn't you need a function to do this in Oracle, not a procedure? From what I see you are populating a variable local to the procedure and then doing nothing with it besides outputting it in a sql plus window? i.e. ...

From my own (recent) experiences, if you are planning on inserting large amounts of data into Oracle, create text files and use the Oracle SQLLDR, using this I was able to cut hours from my datastage jobs, this includes the time it takes for Oracle to handle the import.

Try this one http://www-physics.mps.ohio-state.edu/~prewett/hexedit/ it's free so your not wasting any money if it doesn't work out for you. Ultra edit also works, but unless you pay for it you can only use the trial version. Hex editors are similiar to a text editor like notepad, except that you ar...

Since you stated that loading each file works, I'd suggest using a hex editor to look at the concatenated file, at the byte position starting where the first file ends, to see if there's anything unusual in the data that won't show up in an editor.

Kenneth, thanks, I checked and yes they are f type pointers. Ray, your idea is great and we use that methedology often in our oracle environment where we control everything, unfortunately we cannot add such a column, as the Unidata database is from third party vendor who supplies us the application ...

ok, I'm taking in alot here. As for Kenneth's post, I looked up the original he mentioned. In it he recommends setting up an account specific to datastage. I believe that we do have this as our setup on the unix server looks like this /prod/db /prod/db/db_sql and datastage is looking at /prod/db/db_...

nice source for documentation, although the website is actually at http://www-306.ibm.com/software/data/u2/pubs/library/52unidata/ I have downladed the documentation and will look into this. If we were to use this methedology, wouldn't we still need to pull all of the unidata data from our database ...

Ok, I seem to be a little lost on the I descriptor in the Unidata file, I understand the concept in regards to how we would use this with Datastage but the details on the Unidata side are not that clear to mel. Can someone provide some more information on this. We are running Unidata 5.2.2

Unforunately we cannot change the structure of any of the unidata files, without voiding the support we receive from the software vendor who provides us the application that is riding on the database, but yes that sounds like it would have been good for our scenario if we were allowed to do it.

Kenneth, I like your methedology for finding the incremental changes and have many places using the oracle oci control where I can use this to speed up our processing. From what I understand I would be splitting the data into multiple flat files using an algorith like the one you mentioned, and then...