DSXchange

Maybe your job monitor is not running.

Is your target a number ?

Take one step at a time. Add one function at a time and see where it throws an error.

It seems the data coming into the tx is of dd-mon-yyyy format.

Are you going to call the routine once per job or once per record ?

Multi-job compile !!??

Normally it given the SQL statement which it is complaining about. Did you check it? Can you paste it here?

Did you use any parameters?

Is it the correct db you are connecting to ?

Normally it given the SQL statement which it is complaining about. Did you check it? Can you paste it here?

Did you use any parameters?

Is it the correct db you are connecting to ?

But what do you intend to restore? DS may be spread across disks.

But what do you intend to restore? DS may be spread across disks.

Few queries 1.) What is your job design? 2.) Do you get the name of stage that throws this error? 3.) What happens when you view the counts through monitor? 4.) Replace the final stage in the job into a copy and attempt to run. Repeat it by removing each stage and making it a copy till the error dis...

Few queries 1.) What is your job design? 2.) Do you get the name of stage that throws this error? 3.) What happens when you view the counts through monitor? 4.) Replace the final stage in the job into a copy and attempt to run. Repeat it by removing each stage and making it a copy till the error dis...

Multi-instance ?

Obviously you have not tested or checked the code. So not intended to point mistakes. Few changes required in the code 1.) look for non-alpha as seperators. So rather than restricting check for blank, look for anything between 'A-Z' or 'a-z' and do an 'else' capitalisation. 2.) Need return of char p...

Wouldn't it be rejected in the source sequential file itself ??

You can capture the rejects from seq file.

UpCase is your lead.