DSXchange

Open DataStage Manager client. Find the Documentation Assistant tool in the toolbar (it looks like a typewriter) or in the Tools menu. Opening the tool gives you a dialog where you can select objects to push out into the other database. On the Options tab you can take the default DSN (DSReporting) o...

You don't get a report heading (which you do get in RetrieVe queries) but you do get column headings. To suppress column headings in DataStage/SQL, use the COL.SUP keyword or the SUPPRESS COLUMN HEADING clause. For example: SELECT PRODUCT, QTY FROM EXAMPLE1 SUPPRESS COLUMN HEADING; At the TCL prompt...

Gotta be a TLA.

The ODBC stage type is equipped for multi-row returns from lookups.
Invoke help, and search for Multi.

To create a new project simply open the Administrator client, select the Projects tab, click Add and follow the prompts. Projects don't have parameters in their own right. You can usually handle parameters by having Templates created in the old project. Also consider Parameter Manager from the good ...

You need the following declaration at/near the beginning of your routine, certainly ahead of any executable statement.

You can use as many as you like; though any one link partitioner supports a maximum of 64 outputs. Read the manual about inter process communication, particularly the section about process boundaries. Learn about how many processes are generated in a job design (approximately one per active stage, b...

You can NOT call a before/after subroutine from a job sequence directly. You have two main choices. Create a transform function that invokes the before/after subroutine (you will need a DEFFUN declaration or to use a "DSU." prefix in your CALL statement). Invoke the transform function using a Routin...

Arabic is one of the more difficult character sets, particular for sorting and comparing. I don't currently have access to an NLS-enabled DataStage, so can't see what maps are supplied with the product. What you will need to know (to build your own map) is how your Arabic characters are encoded and ...

$DS.NULLTRX is a catalog (VOC) entry for a "null Transformer" function that may or may not be present. The "not found" message in an upgrade is generated by an attempt to delete it, and may safely be ignored.

Command = "SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'jobname';" Shell = "UV" Output = "" ExitStatus = 0 Call DSExecute(Shell, Command, Output, ExitStatus) Ans = Trim(Trim(Output,@FM,"A")) This counts as "a documented method" because t...

ProfileStage is more about discovery, while AuditStage can deliver more metrics about the patterns in the data.

If the table exists, then you can execute DROP TABLE command from the dssh environment on the server, or from the command window in the Administrator client.

Welcome aboard! :D Sounds like the connection between DataStage and Oracle was interrupted between (because?) when the error occurred and when DataStage issed a query (effectively an oerr command) to retrieve the text associated with the error code. Or it may be some incompatibility between the 9i c...

DROP TABLE if created with CREATE TABLE or UV stage DELETE.FILE if created with CREATE.FILE or with Hashed File stage in account rm -rf (or DEL /S) if created with mkdbfile or with Hashed File stage in directory (a subsequent DELETE VOC ' hashedfilename ' may be required if SETFILE has been used to ...