DSXchange

Do a "LIST DICT <yourfilename>" and tell us the output.

I'm not sure how much you are expecting to do here - if your data is coming in different order then you need to write (or buy) software to do this complex chore. QualityStage will do it for you. The INDEX() function, as mentioned earlier, can let you parse elements from your string. For example, IND...

If you have the same data on both machines then your NLS settings are different.

Your text has some characters that exist in UTF-8 but have no mapping to Unicode defined and these are triggering the conversion warnings.

Do you want to extract the first 4 characters from the line, but ignoring spaces?

Have you tried specifying a binary transfer? If not, give that a go and see if it changes the behaviour. Also, which UNIX OS are you reading from?

Have you searched your dsenv file to see if you might have declared INSTHOME more than once?

a) when you run the job, does it show that the correct number of rows were read from the dataset?
b) what method are you using in your Oracle stage?
c) Have you tried adding a reject link to your Oracle stage and analyzing the output?

@INROWNUM will give you the actual input row per partition, i.e. it is not unique. If you want a unique number, you will need to combine your @INROWNUM and your @PARTITIONUM

Does your second file, with the "10" and "50" values, have only one row?

"emp_temp.txt" looks like a file name, not a directory.

Load one of the files into a hashed file, the use that hashed file as a reference for the other. If the lookup fails it is a "N"ew one, if it succeeds then it is a "M"odified one. Capturing deleted records this way is a bit more difficult, you could always load both files into hashed files and do lo...

Moderator - please delete this duplicate thread of this one.

You will need to explain how you classify an "E"rror or a "W"arning or "N" type of record. A specific example might go a long way in helping you get an answer.

Yes, it might have a performance impact. As Ray has already pointed out, you can change a number of parameters using an explicit sort; and these changes can impact performance.

How were you tring to view the uvconfig file (this means which program were you using)? This is a text file normally only modified from the OS command line.