DSXchange

Since the parameter is typed as a date it won't accept a time or timestamp fomatted value.

In that case the most likely cause is that your settings for access rights on your server for different users is not correct. If you have one user create a file the others should be able to read and modify it. What access scheme or method are you using under windows?

Are you importing over read-only or versioned objects?

Greg, Your composite key of 5 columns could not be written to the hashed file. The data format for such things as date or times is irrelevant. This error will happen on DataStage hashed files when: (a) the disk is full and new space needs to be allocated for a write operation and cannot be retrieved...

One of the questions that was asked that you haven't answered is what speed are you getting when you take the DB/2 bulk load out of the equation and just write to a sequential file. You have been given lots of suggestions from various people and all you've stated is "not working" or "am still stuck"...

Rajesh,

start at Page B-1 of the Parallel Job Developer's Guide and look at the various date functions. Convert your two dates into numeric values using any one of the methods and you have a method of comparing them.

I recommend using a user variables stage to set this value; I don't think that the command will be parsed when putting it into a job activity stage.

Craig - we are guilty of aggravated thread theft and I feel little or no shame

Greg, you have special characters in your key field. Most likely CHAR(254) (the @FM). Use a OCONV(YourColumn,'MCP') to change undisplayable values to a period and check your data again.

I just saw a typo in my post - it is [2,2,4] instead of [2,24]

Cellule, this is a long-dead thread and normally it is best to start a new one with your new topic.
Look into the manual under the topic of "GOSUB" go get an answer to this query for repeating statements within a program, and the use of routines and functions for doing outside of a program.

Don't use fixed length, use FIELD(DSLink4.Field007,' ',1) and FIELD(DSLink4.Field007,' ',2) to separate the date and the time. N.B. that ' ' has a single space in it.

Define a variable in the sequence that calls this job as "OCONV(@DATE,'D-DMY[2,24]') and pass that value as the parameter named TS

You cannot, they are permanently gone.

p.s. I just cleared out several thousand jobs in development earlier today. You wouldn't happen to be working for a bank, would you?

Since your time portion remains unchanged, just append it to your result as follows: