DSXchange

They should work. Can you post the complete query here.

CurrentDate
CurrentTime
CurrentTimestamp
all of the above are px specific solutions.

You can have an after job subroutine (custom) that check for the link count. If its zero, you can log the error as a fatal error which will cause the job to abort.
Its not a good practice to abort jobs in production.

How are you reading it as? Is it varchar? If thats the case then you dont need to do any month or day check. Just send it to StringToTimestamp() with the mask I gave you in my first post. It should work.

You need to check if day and month are single digit and only then prefix it with zero. Specify stage variables to fix the day and month StgMonth- If Len(Field(in.Date, "/", 1)) = 1 then "0":in.Date else in.Date StgDay - If Len(Field(StgMonth, "/"...

You need to work on two things:
1) Check the length of day and month, if its one then prefix it with a zero.
2) Append :00 as seconds to the end.

Then pass it to StringToTimestamp() with the mask of %mm/%dd/%yyyy %hh:%nn:%ss.

As far as I remember, if its just date "DATE(10)", then db2 accepts it in internal format. If you just sent it as ICONV() it will accept it.

What is the maximum that you will expect? Set it to varchar 4000. It should be able to accept that. If thats way, way too much, then set it to varchar 255.

You need to sepcify the conversion mask for your second StringToDate.

Impressive work leaves a mark forever. We got your back Kim.

You can see it now.

You can write a small stored proc. to do that and call the stored proc. from within datastage.

Well, then just check each incoming value for 400 (if it is static). And if you find 400, increment the counter.
Something like

Initialize the counter with 0. counter is a stage variable.

What are the rules of assignment? From the data, what tells you that this is sequence number 1 and this # 2 ?

Cast it As Integer using that function in the transformer stage.