DSXchange

I have a datastage Job that gathers statistics from a number of tables and then outputs the result to an excel file. Currently I am manually copying the results to a specific worksheet(WA2) in an excel file. Another worksheet(WA1) summarizes the results using excel's lookup function. I am trying to ...

I placed an incorrect data type in the 5th record....so that it will reject the record..... What do you mean by Error in 5th record? Is it a Lookup fail or Something which the job doesnt abort? Try to abort the Job if you find any error, then only the Transaction Size=0 will work. But, Wait for the ...

Tried the suggestion (Transaciton Size=0 ) and yet it commits

DS_SUPPORT wrote:Try Setting the Transaction Size to 0, it means either all records will be commited, Else Nothing will be commited.

May be this wont be Suitable for Large Volume of records.

Hello I have a source file with 5 records......and the 5th record contains an error. Array Size= 1 Transaction size =5 I am expecting the transaction to be rolled back due to the error in the 5th record but the other 4 records are committed.... How do I set it up such tha all records are committed i...

Hi, I am baffled as to why the job is failing because it was working fine before the addition of the new field in theTarget DB and the statement to derive the value for this field. A Db2 Stage extracts Data from 9 tables based on a particular date. B.The extracted Data while passing through a transf...

Rays suggestion resulted in the correct sequence number......
but when I run it it's given me -1 as the ID

how can i overcome this issue...please advice

Hi Ray, I managed to get the correct value...but when I run its still -1..I went through the code for this routine...and it seems when the file cannot be opened it returns -1. Prior to this execution the job aborted as one of the tables were locked......now all that is resolved but the ID which is g...

Hello ,

I am using the function KeyMgmtConcurrentNExtValue to derive a primary key.....it was wokring fine and now it has set it self to -1 and my job is hanging up.....what is the reason for this and how do i find out what the current value is

Is it true that even if you set the Job Warning Limit to " No Limit" in the director, when you Run the Job in Batch the Job warning Limit follows the Default (ie After 50 Warnings ) ?

How do I change it so that the setting will apply when I run my job in Batch as well ?

Ok Thanks.....

ray.wurlod wrote:Not at all, without hacking the Repository. This is not provided for in DataStage "out of the box". ...

Hi,

I need to rename one of our shared containers. How can I rename it without having any impact to the jobs it references.

Thanks

Thanks !!!

Hi,

I updated my table definitions for a certain table..Then using the usage analysis recompiled the referencing jobs...But the change has not taken effect...Have I missed out a step or should I manually set them up ?

I have a target DB2 Stage with the Array size Set to 1 and Transaction size set to 100. when I set a the array size to 50 I get a warning in the director log. the update action s set to " Update or insert" . What would be a reccomended setting for these two sizes to get a decent performanc...

Thanks Hello, I am doing an insert from a Sequential File to a Db2 Stage table. There are no contraints for the input link. If the target table consists of an incoming row then the row will not be inserted. I have a reject link to capture the records that were not inserted. The problem I am facing i...