DSXchange

Yes, it can be done. Others will post suggestions that use CLEAR.FILE; please try to avoid that, as you also lose all the control records. And purging the log of a running job has potential hazards; after all, that log is still being updated if you access it from an after-job subroutine. It is bette...

There is also a number of competent consultants who could create your initial few and mentor you in the process at the same time.

Try using the ODBC driver for text files rather than the ODBC driver for Sybase. I vaguely recall, however, that one requirement to use this driver is that the text file has column headings in line 1. This may thwart you.

Precede the Pivot stage with a Transformer stage in which there are two more columns with constants as values ('CELL' and 'EMERGENCY'). Include these as pivoting columns.

Not really sure what the connection with ProfileStage is here. Have you sought advice from your support provider? Sounds like there's something odd about released jobs - maybe overheads associated with determining the actual release number. Meantime, the workaround is to use non-released jobs. Use V...

This is a known bug in version 7.1. It typically occurs immediately after execution pauses at the first breakpoint is encountered. Have not yet had the chance to test at 7.5.

Take a backup of your DataStage server. Take an export of the project. Verify that each is good. Axiom: if you have good backups, you'll never need them. Corollary: Disaster occurs only when you lack good backups. Install as per instructions, not forgetting the new run time library on the mainframe....

This stage type allows DataStage to prepare control and data files for the DB2 (UDB) bulk loader. You can choose to have the bulk loader started automatically from DataStage's control, or to execute it outside of DataStage.

The NULL representation specified in the Sequential File stage is how you want NULL to be represented in your text file. By default it is "" (a zero length string). Whatever string you put into this field replaces NULL. For example, "<NULL>" is quite a common representation. I am not aware of any me...

Create two simple routines FirstOfPreviousMonth and LastOfPreviousMonth and invoke them through Routine Activities in a job sequence. Use the return value from the routine to supply the value to the job parameters. FUNCTION LastOfPreviousMonth(Arg1) * Arg1 is an internal format date, for exa...

Definitely works through to version 7.1. Have not had opportunity to check on version 7.5 but have not reason to believe it's any different.

Hawk (8.x?), however, is another story entirely!

The most likely problem for error 81016 is that dsrpcd is not running on the server machine. If it's not running, you can diagnose why it won't start, or simply try to re-start DataStage services and check that it's now running. The most usual cause for failure to restart dsrpcd is that it can't bin...

There are other files.
Scripts are provided (in the sample directory IIRC) for enabling or disabling impersonation mode. These will look after setting permissions correctly.

JezT, a) You can use a pivot stage on the data, and then remove all 00000000 valued rows. b) write the data to a Hash file with a key being the branch number and a multivalue column containing the account string, with each account separated by a @VM. Then read the hash file and normalize on the acc...

You can't do it through the sequence. You must multi-select the jobs in question in the dialog from the Manager. Please note that releasing jobs is deprecated technology. The preferred approach nowadays (since about version 3.3!) is to use Version Control to create read-only jobs and other objects i...