DSXchange

You need the DaysFromDateSince() function.

Do you want to perform this calculation in a sequence or in a parallel job?

It is not obligatory to restart WAS or the agents.

It is also not correct to use orchadmin command to stop and start DataStage.

Study the administration manual and document the correct methods for your site.

Up to date information is available from the IBM web site. There's no point posting it here, because here it will become out of date.

We can't tell if you've written the correct code unless you post that code!

Put "debugging" calls to DSLogInfo into your routine to determine which actual statement is the problem.

DataStage macros. DataStage functions. Or a Routine activity called from a sequence, and in which you invoke DataStage API functions.

Please tell us what the id command returns. You may be surprised. There's no reason you can't execute a command to get the value of an environment variable, such as echo $ISUSER - that value will be available as the output value of the Execute Command activity - possibly with added linefeeds convert...

The message suggests that, on the output link, column contract_beneficiary_nomination_comment is marked not nullable. The error occurs when you try to pass a null to it.

GetEnvironment() is only available in parallel jobs. Please perform this test. In an Execute Command activity in a sequence execute the id command to find out the user that actually runs your jobs. Then we may talk further about whether there's some easier way to determine that user's identity at ru...

The same way you'd insert into any table.

Yes. Have "them" configure your email gateway to handle sending email to SMS device. Then have DataStage send email to the appropriate address (which usually includes the phone number).

Can you please show the full error? It was truncated when you used it as your subject line.

Look for DSJ.JOBRESTARTABLE in JOBCONTROL.H (in the dsinclude directory in the project).

All of the ODBC connection information, including hostname/IP address, should be in the .odbc.ini file.