DSXchange

In the mean time the OP has an alternate solution.
derekchu, i forgot to mention that in your sequential file, delimiter should be set to comma (,).

First you need to change your date in char(10) format to Date using StringToDate() and then use JulianDayFromDate() function to convert it to JulianDay.

Ok. It can work in both sequential and parallel operation.

Specify two columns in Sequential file stage. Place the following code, as it is, in the Filter options. File name should be your source file. sed -e 's/[0-9][0-9]/,&,/g' -e 's/^,//' | awk 'BEGIN{FS=",";OFS=","}{for(i=0;i<=(NF/2)-1;i++) print $&...

Can you also have variable length integer that is 1 digit? Like

I highly doubt you can get a OUT parameter from the before/after sql tab. For that you need to run it via STP stage.

All rows get committed when your job finishes. But just for fun sake, specify Array size to 500 and Transaction size to 0. Post your finds.

He is not getting any warnings as per his very first post. Thats what makes it even harder to tackle.
Load your data to a flat file and do wc -l and post the outcome here.

What about the other set of questions I , ArndW and Craig asked? Help us in helping you.

Are you using Insert rows without clearing? Can you confirm that you are not using Insert and then update or the its twin.

Never heard of that term. Do you mean a lookup file set?

You sure you are quering the same table in the same schema on the same server that was loaded with your job? If yes and no warning messages then this might be strange. Clear the status file via director, try running again. If you still get the same results, load your data to a text file and at the u...

Search on keywords "IDOC extract stage". You will get reading material with the plugins which will give you full description of its functionality and on the "how to's" with respect to usage. If you are interested to get trained specific to SAP R/3 PACK, then click here.

xjonny wrote:"If we knew what it was we were doing, it would not be called research, would it?"
- Albert Einstein

I like this guy, he quotes Albert Einstein.

You have to understand that the two animals (server and px) work in a different way, that includes the database stages as well. Rejects are handled via transformer in server. But with enterprise stages, it is possible handle rejects like Ray advised.