DSXchange

OOPS you hae already mentioned the target. Sorry ! When writing into Sequential file and then to DB2 in which stage are you having the error. I would suggest for that job, break it into 2 jobs. First write into Sequential file in Link Partitioner job and then use this file to write into DB2 with the...

The double quotes around the single quote worked for me !

What is your target Database in the job and what is the stage you are using to write into ?

there u go .. U have a very elegant solution !

Did u try using the same if...then..else in the column derivation within Transformer, instead of a Routine ?

Do u know the number is just a fictional number or is it true. Because it is

5 billion rows. Are u really sure you have that many number of rows in it?

I haven't seen a table so big until now ? or am I reading it wrong.

Please explain a bit more !!

Like what is that you are trying to achieve and what is that you are doing now ?

One quick fix if you have time limitations is: to use another Reject link to Sequential file and then in after-job subroutine merge them into one as they have same structure.

This is not solution for the error. It is just a quick fix. Meanwhile we will wait for other inputs on this...

Just another design suggestion, I would highly recommend that you create 2 jobs instead of one to write/update on ORACLE instead of using 2 output links to ORACLE stage. There is nothing wrong in it, but it gives you again modularity which many people here stress including me. Something wrong in the...

Did you try

LK1.REJECTED OR LK2.REJECTED if LK1 and LK2 are your output links.

Just an idea, I am not sure whether this will work or not. But surely worth a try as OR is perfectly acceptable in Constraints.

Taking any guess on the job time or the time to write into a Hash file will be a wild guess. Did u calculate the size of the file approximately? You are almost writing 1 million rows into hash file. Can you filter the rows? If you have any constraints, check if you can move them to ORAOCI 8i stage. ...

plaire poste en anglais

Pardon me If I typed something wrong in above line !! For others I asked the Poster to post in English

Please rethink your design of the job, as you want to delete the record which you are reading. I will assume that ur doing it for learning DS, then: Then do this, write ur source into a Sequential file or Hash file and then do the delete. I believe the syntax would be something like: DELETE FROM AMC...

Do you have any hash files in the job? Are you clearing up the hash file before writing into it ?

Sequencers are another type of jobs that execute the Server jobs conditionally/unconditionally which you have already developed. Start a new Sequence job and drag the jobs on to the design area and start connecting them with links. These links are by default black in color. That means the second job...