DSXchange

You can also - more easily in my opinion - create a server routine and invoke it from a Routine activity in the parent job sequence once the job has completed.

That will suffice. The number is the primary key to the table in which support cases are recorded (the "*AUA" suffix indicates that it was first accepted by the Australian support group).

You have moved on from the original problem, and now getting a different problem. Again, it is likely that a required stage property (the temp directory pathname) has not been provided.

Is there another option for unzip to specify the target location?

If not, change the command to

You don't. DS Macros are written in DataStage BASIC, and defined in DSINCLUDE/JOBCONTROL.H Because of the language in which they are written, you can only use DS Macros in BASIC Transformer stage, or in server shared containers, within parallel jobs. Neither is recommended. You might also ask yourse...

It's doing precisely what you're asking it to do.

Look at the property help for the "Load immediate" property.

This is an Oracle error. To find out more execute the following command on the DataStage server. oerr ORA 1841 Basically, however, your data (column R263_FISCAL_DATA_END) contains at least one date with the year less than -4713, zero, or larger than +9999. This is not acceptable to Oracle when stori...

Never kill DataStage processes in this way. You are unaware of the relationships between DataStage processes; there are typically at least two processes involved in running a server job. Having done so, as others have pointed out, you (or an Administrator) need to effect repairs; in particular unloc...

If the FTP transfers are under control of an enterprise scheduler, such as Control-M, SeeBeyond, etc., then the same scheduler can be used to initiate the DataStage job sequence.

Is there a CHAR_LENGTH function, or something similar?

Otherwise, use the Len() function within DataStage; the Len() function returns the number of characters in the string.

Probably set the "First line is column names" property to True. Second possibility is to set the field delimiter property to the correct value.

Hi I have hash files in my server jobs as those files were used as lookups, I need to access hash files for lookups in parallel but parallel ext doesn't support hash files. So, do I need to convert hash files to different format to access them in parallel and how ? Instead of Hashed File stage, use...

What is job number 118? SELECT NAME, CATEGORY FROM DS_JOBS WHERE JOBNO = '118'; Have you made an earlier attempt to delete this job? From the Administrator client or from a telnet session execute the command DS.CHECKER This will check for orphaned jobs and hashed files associated with them. If that ...

Are you being paid by the hour? Seriously, though, yes it can be automated; the script to which Kim referred is a good starting point. An alternative - and maybe easier - is to back up the entire project then use a DSX cutter to create separate per-category DSX files. Do they require routines, table...

Re-organize the string with substring and concatenation.