DSXchange

Quote or Misquote, it is the truth..Excel is indeed a harsh mistress.... Thank you very much for your suggestions. I had indeed tried convincing them to give out the file with uniform formatting or standardize a length...since this affected only a few thousand records, the file format was updated an...

Thanks for the help earlier. Seems like the excel issues are here to haunt me once more :) I have the below scenario. Let us consider a column C1 from the source. For certain records it has the content "01" with format as text. These records are read as "01". For certain other re...

"The database is damaged"? Not really sure how a job would cause that error. Have you involved your DBAs, done any troubleshooting as noted here? Ha ha...What has got me even more confused is the randomness with which it is occurring. I am not able to consider it as a volume issue since t...

The Auto Commit in the DB connector is set to off and the Transaction and Array sizes are having default values of 2000 records. The reason we have not played around with the commit sizes is because we do not have records actually going into the update flow. Another thing I wanted to clarify is that...

Hello all, Yet another call for help to the wonderful people. Thanks for all the help in advance. DataStage Version: 9.1.0 DataStage Job Type: Parallel Hosted on: AIX Database Type: DB2 for z/OS Database Version: v10 We are having a simple job having two datasets as source. Both with volumes in the ...

Thanks for your help Craig.

Ha ha...you are right..It is indeed a PITA..But on the topic..you mentioned moving columns around right...just curious how you had tested that particular scenario..For the bad data..i guess checking if it is valid data using functions in the transformer would be possible.. Also is there any unix com...

Thank you Craig. I also had a similar thought process on handling this scenario. Just wanted to check if there was any other settings that could help. It would mean that we could possibly run a transformer in sequential mode after the unstructured file stage and validate the first row e.g. @INROWNUM...

Dear Friends, Need your help in resolving a small issue I am facing. I am using DataStage 9.1.2 (server installed on AIX and Windows Client). We are trying to read an excel file using the Unstructured File Stage. File contains 5 columns and the range has been specified as A1:F1. The First line is co...