DSXchange

The sequential file contains three rows. In the second row I created an error( placed a character value to be loaded to a numric column) It seems second row never went into database using odbc. May be DataStage ifself throws that error for second row. That is why rollback not happening in your case...

Hope you have written routine like following NullChecking: if ((Trim(Arg1, ' ', 'B') = '') Or (isnull(Arg1))) Then Ans = 1 end Else Ans = 0 end Trimlt: Ans=Trim(Arg1, ' ', 'B') What is svNullIdst?? is this stage variable? what is it's value?? if svNullIdst Then 112 Else Remove this line and check it.

Phantom error is not specific error, it can be for serveral issue.
Please post more log information.

Basically what ur job does here??

It all depends on ur requirement. For example Table A = 50,000 records Table B = 300,000 records If u have one to many or many to one or both relationship on above two table the the result u will get a cartesian product from both which may differ from your expected result set, when u fire the query ...

it is giving result value 1. Is this related to @TRUE

Yes 1 means @true in the transformer

Array Size = number of records being loaded. not like that.

Parameter array size =the number of rows written at a time.

What Isolation level you set in Transaction Handling tab?

Check with defaullt value like
Isolation level=None,
Row per transaction=0
and Parameter array size=1

1) as long as your server identifies Network drive, you can easily create and access hash file using "Use directory path"
2) I believe clear file before wrting is faster that delete file before create as in later option it invloves overhead of deleting and creating the file.

What do you want? Be more specific.

Do you want latest information based on date or flag for a employee or the information chulett mentined in his reply?

Initially I thought that pivot stage would help, but having checked privot stage I found that it's for different requirement.

Hi, I am in process of creating one job where I need to transponse a table i.e. row into column and column into row. For example, input is like this Table col1 col2 col3 row1 10 20 30 row2 15 35 45 row3 25 55 65 output would be like this: Table col1 col2 col3 row1 10 15 25 row2 20 35 55 row3 30 45 6...

The error is in the network. There is not enough information about it generated to produce any meaningful diagnosis. Have your network administrator, possibly with the DBA involved, investigate wher ... As per DBA this is not network issue. When I ping the remore system, it's responding fine. One m...

so you requirement is to get only 2 digits after decimal point. Either you can use round off function to get nearest values after decimal point or write a small basic rountine and call it in tranformer stage. You need to manipulate column value using basic function. Use string or field funtion to ge...

The job aborts at halfway and giving following error message while loading db2 in linux. The same job runs perfect while loading on db2 in windows enviroment. Can you please let me what the issue is going on? I am really stuck on this. Any help will be highly appreciated. CUS_Load_Customer_Mst..TRN_...

Which update action you set in target table stage?

This is error shows you are tying to alter the table constraint.

Also check after setting same nls map at both the stages(Sequential file and Oracle stage)