DSXchange

Hi,
It is a known bug which Ascential also have a fix for.
Contact your support provider to obtain it.

IHTH,

Hi, Using ODBC to load Oracle only makes scense if your using the DRS stage to be DB independant in generic job design that should be run on various DBs along time implementing the same logic. Having that said I asume this is the case (otherwise use the other methods of manual bulk or OCI stages) Tr...

I do belive ADN has a download file with this info.
In any case you should have no problem getting the release notes from your provider as long as it might help you to make the choice of upgrading

Just wanted to point that using "need help" as your topic will make finding anything usefull it may have more dificult to others using the search mechanism.

Hi,
Have you got a 505 characters limit for the row data?
Do you read the row as a single column?
Can you verify the 506th character get lost in the process?
Could it be a row delimiter issue?

IHTH,

I wonder has it become like hearing the first notes of a song and knowing what song it is for you Ray???
Probably influenced by the release of the latest star wars movie, I guess Ray found the force

(any chance you might share how you do that with us Ray???)

Hi, I was not saying anything about respect or lack of it . The point is that we need info not 20 questions for the guru/s. This way we all benefit: The poster has moe chance for a quick response (less experianced persons tend to hesitate answering obscure posts) The readers can actually learn from ...

Hi, 1. that might have some syncronization/partition and performance issues (using lookup file sets) 2. don't forget the partitioning issues. 3. the routine used by others as you mentioned takes care of the process partitioning (cost is having holes in the sequence key). IMHO, there is no need to re...

Hi, your issue can be devided into 2 seperate topics: 1. getting the warnings/errors or what ever. 2. sending a mail notification. both were covered extensively in the past (use search in this forum). In short: 1. you can: - get the warnings from the logs using routines like DSGetJobInfo(...) and th...

Hi, what do you mean by routine? (a rpg routine?) Your limited to the DB syntax you connect to, so is there any syntax to run this routine using a sql statement? i.e. In MSSqlServer you can invoke a bulk load using a sql statement you issue via user defined sql in an ODBC/OLEDB stage. IHTH,

Hi,
Do you really mean from VB(Visual Basic)???
In DS you can try using the ODBC stored procedure or simly run a user defined sql to run it.
(depending on wether it has a result set or not might determin if you need to use an output or input link.

IHTH,

Hi, In case you auto back up your DS instance via the script available from ADN you should also have your VC project dsx file (or if you back it up manually), so you can restore from there. The job design does get deleted just the info that it was there and related info stays with VC "forever". IHTH,

Hi, Enabling row buffering means you use a limited buffer to pass several rows in bulks between active stages when you use unprocess buffering; Or between processes when using inter process buffering. As far as I noticed along time the gain you normally get is not that significant (though I always u...

Hi Amos, how do you statr the jobs? you did mention a 3 secs wait? having 40 jobs? even starting all 40 in the same sequence job will not be instantanious. they will gradually all come up but some later then others. can you specify a bit more on how do you run all of then in parallel? Another thing ...

Hi,
Just wanted to point this was covered before several times and that some times the row number is not 100% acurate so look around 71 .

IHTH,