DSXchange

Use a simple if then else statement in stage variable to see if its numeric or not.
Use another if then else statement in the derivation to check on the value of stage variable and putting proper values for particular columns.

It might be. Report this behaviour to your support provider.

If then else ----->Yes
Case ---- > No.

Ok, then change the FixDay stage variable's derivation to the following:

The StringToTimestamp() derivation will remain the same. Read the date as varchar.

Delete is a logged activity. It will take time. Are you only deleting records that are found in your sequential file stage? If yes then why not do an instant update?

Do you have two spaces between the Month and Day in all your date fields or just a few?

Just switch NVARCHAR to VARCHAR and NCHAR to CHAR in your job.

Unlock the routine from DataStage director. Its the same way you unlock a job. Search for more info.

You gave -warn two times. Only one is needed.

What is Arg in your routine? Is it really Arg or Arg1.
Plus you need a space between ksh +x and your argument.

The easiest method, without much custom coding, is thompsonp's method. This way will cause and immediate abort and prevent further stages to execute.

This is'nt the entire code is it? WHere are you opening the file (OPENSEQ) for writing. Plus, I dont think you need a WEOFSEQ. All you need to do is OPENSEQ 'myfilename' to FILE ELSE ABORT LOOP WRITESEQ ..... END LOOP CLOSESEQ FILE This is just to give you a general idea. Its not complete code. Does...

But would'nt a lookup mean that the function return should have a matching key with the incoming data?

You should get 'XYZ' everytime for the first incoming record. Change your output to a sequential file. If you have a hashed file then you might be overwriting it due to identical keys.

Check the section 'Command Line Interface' in Server Job Developer's Guide.