DSXchange

I'd suggest TinyInt() as the appropriate receiving data type. The TinyInt will, of course, only ever have 0 or 1 as its value.

You can use DecimalToDecimal() function. But beware that you are potentially trying to load large values into a data type that is not big enough to store them, so DataStage will unavoidably generate an alert message to this effect. (Tou can, of course, use a message handler to demote his alert to in...

Your BASIC routines will still work.

Copy the relevant lines from DSParams to DSParams in the prod project. Note that there are two sections pertinent to environment variables; the definitions and the values.

What is the record delimiter used in the file? What is the record delimiter specified on the Format tab?

If you have downloaded the functions you can use the Test facility to verify their efficacy and, if necessary, add debugging statements (usually DSLogInfo() functions) to diagnose how particular values are being handled.

#!/bin/ksh export DSHOME=`cat /.dshome` export PXHOME=$DSHOME/../PXEngine export APT_ORCHHOME=$PXHOME # Run the dsenv script . $DSHOME/dsenv # Now run the dsjob command set projectname=FINGL_DEV set rundate=`date +%Y%m%d` $DSHOME/bin/dsjob -run -jobstatus -param RunDate=$rundate $projectname CheckF...

Recompile the job. This will reinstate the Orchestrate scripts.

MNS (multi-national (address) standardization) is what you need. The main pain point is that it does not always standardize to street-level addresses (and, indeed, not all countries have these). But it's pretty good to city/town level.

Change the Record Delimiter property to use a Record Delimiter String property and set its value to "DOS style".

Use a server job, or server Sequential File stage in a server Shared Container in a parallel job.

What are your authentications and what are your DataStage credentials?

A hashed file must have a key. No alternative. Create the hashed file with a key, even if it's a constant such as 'X'.

Unlock the job.

Never kill jobs. You get into this trouble. Issue stop requests instead.