DSXchange

A process is started executing uv (ultimately uvsh) running DSD.RUN, which is a DataStage BASIC routine that runs server jobs. This obtains job parameter values, or run-time default values for them. Before starting anything else, the job will execute its before-job subroutine. In your design, the jo...

I am not aware of any upper bound on the size of T30FILE. Certainly none is documented in the Administering UniVerse manual. As I have explained in the past, the T30FILE parameter determines the number of rows in a shared memory table in which the dynamic sizing values for each open hashed file is s...

Until version 5.2, DataStage was licensed by project. .

Would you prefer that?

Where is that maximum documented?

This IS because you have too many hashed files open. The clue is in the message "Unable to allocate Type 30 descriptor, table is full.". Don't forget that DataStage itself uses hashed files, as many as ten per job, in addition to any that you are using. What can you do? Investigate increasing the T3...

The two plug-ins are obtained on a separate CD. I do not know whether you get them from PeopleSoft or Ascential, nor what the commercial arrangements are; this was organized for me when I presented the class. I only know for sure that they're on a separate CD. The DS324PSFT class was not the same as...

Now that I've looked I'm sure. In version 7 and later:

Details can be found in the Server Job Developer's Guide, page 18-85.

The only difference in the product shipped by Ascential originally were the two stage types I described earlier - one for getting at table-based rows, the other for working with hierarchies. Meanwhile, Ascential and PeopleSoft engineers have been working on about a thousand Transforms and/or Routine...

Then don't use a temporary table.

Use a "real" table, and drop it once all jobs that need to deal with it have finished.

Of course, you need different authorization to create "real" tables, which will probably require negotiation skills!

Best practice is to make the passwords into job parameters whose type is encrypted, and not provide a password from dsjob . Use Director menu to set run-time defaults that are correct from time to time. This way they remain encrypted. Ensure that the design-time defaults are not correct for the prod...

I'm not sure, but I created a function called IsMultiInstance some time ago. It returns true/false depending on whether the job was multi-instance-capable. It checks the appropriate field in the Repository table record that describes a job.

Just to make life difficult, it's also changed between the two versions of Red Brick that my client is using. This from the release notes for Red Brick version 6.20: C. Trailing Spaces for CHAR Columns Preserved in Query Results In V6.20.xC1, trailing spaces in fixed-width CHAR columns are preserved...

Is there any documentation about the handling of CHAR data type in server jobs and whether it has changed between 5.2 and a later release? In 5.2, you could compare a CHAR( 8 ) and a CHAR( 2 ) and, provided the first two characters were the same and the remaining characters in the CHAR( 8 ) column w...

Yes and yes. If you move doc_tool.mdb, simply edit (configure) the ODBC data source DSReporting To use an Oracle database, there's a bit of setting up. In the DataStage client directory ( C:\Program Files\Ascential\DataStage\Documentation Tool ) you will find oracle.sql , which is a script to create...

Use the Fmt() function for padding. Look it up in on-line help or in the BASIC manual. Its first argument is the value to be formatted, its second argument is a specification about how to format that value, and includes [ width ] [ background ] justification [ conversion ] [ mask ] In your example, ...