DSXchange

Changing it in the DataStage job is not enough. If the target table still has it defined as a numeric data type, it still won't work with the alphabetic characters in it.

You can set environment variables on Windows through Control Panel. Choose the System applet, there's a command button for environment variables. You may need to re-boot (go Microsoft!) for them to take effect.

If you have the Oracle client server installed on the DataStage server machine you have sqlplus on that machine. If you don't have the Oracle client software installed and properly configured, then you can't use DataStage to connect to Oracle. As far as Oracle is concerned, DataStage is just another...

The PeopleSoft PACK consists mainly of a lot of canned jobs and routines for accessing data in the various PeopleSoft modules. So you do not need to re-invent the wheel.

In production open Director and choose the Job menu. Select "Set Defaults". This allows an administrator to change the defaults to be appropriate for the new environment, and to determine whether or not they get prompted for.

Yep, right there between FILEUNLOCK and FINDSTR (the latter is like FIND but can perform a partial match - VERY handy sometimes). Page 6-243 in my BASIC manual (version 7.5) but easily found through the index. LOCATE searches at one level, FIND and FINDSTR at three. You have two, so FIND was more ap...

If it were a specific file prefix I'd agree but, as it's not, that might be a bit of a long bow to draw.

Not much to go on there. Are Sybase_FINHDR_Load_job and Sybase_FINASST_Load_Job jobs or job sequences? In either case, please set APT_PM_SHOW_PIDS to True before executing again - that way you will be able to work out which process was executing what.

Then don't (miss out a column). Take care. Take breaks, so you can continue to concentrate (and for your eye health).

What warning and error messages appear in the job logs of the jobs that aborted, such as Sybase_FINHDR_Load_job or Sybase_FINASST_Load_Job ?

Why? You only construct the expression once, if you take care to get it right first time.

The "to" in the original command was also problematic.

2B or not 2B - that is the pencil.

Open your Administrator client. Select your project. Click on the Command button. This opens a window in which your can enter "TCL" commands. Enter the command CLEAR.FILE &PH& and await a response. Close the command window. PID in this context means "process ID" - this is not the cause of th...