DSXchange

If the format is YYYY-MM-DD then your mask should be "%yyyy-%mm-%dd"

How about making views of the source tables which have timestamp instead of date, then use RPC and generic jobs for the transfer.

If you replace your output ODBC with a sequential file, you will see that 8 records get sent down that link. The same applies to ODBC, but for some reason not all 8 records are doing what you expect in the database. Can you try to execute these 8 statements manually and separately to the database an...

Is it called with exactly the same parameters from the sequence? Is it a multi-instance job and is it called up with an instance name?

Does that mean after you put a reject link *some* of the acno=2 or 3 or 4's are being updated?

The first error is a write error in the Join stage, so that leads to the question of what stage is that? If you make a test copy of your job and output to a peek stage, does the error remain?

Put a reject link on your ODBC output to see what error might be occurring on your update.

I don't know what you have done with your libpath; the first entry, "=/datastage/dsadm/Ascential/DataStage/Projects/scbtransdev/RT_BP3.O" shouldn't be there at all!

In addition, "/Datastage/DSEngine/lib" is NOT in that libpath, which explains your error.

You cannot change that limit from within the job itself, that needs to be done before the job is started.

No, can you "View Data" in your 2 source sequential stages in the designer program.

If you have 2 instances of DataStage running on the same machine you will have to use the server name and port number in your dsjob command so that it know which engine to go to.

i.e. dsjob -server Mybox:31540 -user me -password secret -run -mode NORMAL ric_dss_dev Job_UsingColumnGenerator

It is very hard to understand your requirements. The output file(s) are defined in the jobs and only you have access to those.

I think that you will have to ask your support provider on this one - I've not seen "not running" displayed on a system that is running before.

bin/dsjob -run -mode NORMAL ric_dss_dev Job_UsingColumnGenerator

what does bin/dsjob -ljobs ric_dss_dev show? Is "Job_UsingColumnGenerator" in the list?

Can you "view data" on your 2 input files?