DSXchange

In the transformer, specify the constraint as OTHERWISE for your reject link. See if that works. I am not sure if DB2 API supports reject links. The enterprise stage does.

I would defer to the folks who have had experience with timestamp microseconds and sql loader.

Try giving .6 instead of .x

WHen you say direct load, you mean using the OCI Load stage? If yes then make sure the date is in the format YYYY-MM-DD 24HH:MM:SS.nnnnnn before sending it to the load stage. If you are using the API stage and doing an INSERT, then let OCI stage take care of the format in TO_DATE() function. I think...

You are missing the forward slash after the FileDirectory. Try this

Welcome Aboard,
I have never seen timestamp with length 6. You sure you got the length right?

Specify 'upc_cd' as key in the output of the sort stage as well. If that does'nt help. Then go back and specify the key of the hashed file as the first column instead of the last column.

Wrong forum.
Search on "Unable to allocate memory".

You have to write your own after stage subroutine. One that will cat the contents of both the files (file containing the header count and the file containing the number of records processed). Compare the two, if equal, well and good if not , send out an email using DSSendMail().

Please dont quote the entire message, especially if its 9 yards long

As I said, the metadata will be identical. Make sure the columns are named right. And check the input/output of the sort stage and the sequential file stage.

I'm not sure where you draw the distinction between reading a remote file and transferring it (for purposes of reading). I use FTP to get data and be able to process it line-by-line instead of having to copy the whole file contents to the local machine before processing. Well, with the FTP stage th...

What is your design, is the output of the sort stage directly connected to a sequential file stage or some other stage? If yes then they will be identical. Post your design as its hard to pin point your issue without looking at the design.

It might still be running. Be patient. What happens when you run it from your favourite sql tool. How much time does it take for the stored proc. to complete outside datastage?

Does this happen in the source as well (in the sequential file stage view data)? If it does then its a dos file that you are viewing as a unix file. Change it to dos style in the sequential file stage properties so that it does not transfer it over to the database.