DSXchange

It's simply not possible with WriteSeq, since this statement "writes a line to the operating system file". A line ends with the appropriate end-of-line character for that operating system. What you can do is append the LF character yourself to the line of data you wish to write, and use the WriteBlk...

Is it not possible to set a default schema (and owner, if apposite) name as an environment variable? If so, this would get around your problem. Otherwise, if you add the schema name to the table name field in the stage type, then surely the generated DDL would include the schema name. Normally, when...

(Vladimir) It is true that server jobs can be encapsulated in shared containers and these can then be used in parallel jobs, though there are some restruictions. Even though you don't have PX licensed, you do have the Parallel Job Developer's Guide installed with your DS client software and so can r...

Stephan, Another thing you can do, which I sometimes do with code in these posts, is to precede it with the <pre> tag (pre-formatted) and follow it with the </pre> tag. For example: LOCATE Arg1 In CodeList By "AL" Setting Location Else Ins Arg1 Before CodeList End Craig, Anything is poss...

Yes. The main things to watch out for are pathnames (which should be job parameters anyway), calls to ExecDOS (which must become calls to ExecSH on UNIX), and calls to DSExecute to invoke operating system commands (parameterize the Shell argument, or use System(91) to determine the platform). Ray Wu...

1. Yes. Read about Custom Folders in the Version Control manual. 2. Yes, you can separate them by the batch number under which they were imported into Version Control, or by the auto-incrementing version number that Version Control applied because the names were the same. 3. Yes. Whenever you want t...

This stuff is all HTML-based. I suspect it's seeing your < as the beginning of an HTML tag. You can use & L T ; (with no intervening spaces) to represent < and, similarly, & G T ; for >.

The whole point of PX is to avoid touching down on disk wherever possible. A data set, in PX, is essentially a memory resident table. But it is not accessed via SQL.

The table name is a property of the link, not of the stage.
A stage connects to a database instance. A link connects to a table.

The "trick" that Vladimir described works because all writes to hashed files are destructive overwrites. However, parallel jobs do not have a hashed file stage, so you need to write to some kind of data set or table with a "replace existing rows" rule, for example a DataSet stage with "Overwrite" as...

You don't get transaction grouping with multiple stages. You can only get transaction grouping with multiple inputs into the same passive (for example ODBC) stage. You can have multiple outputs from a Transformer stage running into the same passive stage. +------+ +------+ | | -----> | | ----->| Tfm...

Aha! In DataStage BASIC, NULL always takes the ELSE path, on the grounds that it can't be asserted to be true. Therefore, field 'Y' as an output constraint will not select rows where field IS NULL.

Link Partitioner and Link Collector stage types (and IPC stage too) are only for server jobs, but they provide functionality for server jobs that is inherent in parallel jobs. Yes, you do need multiple transformers. At 6.0 there is not copy and paste, so you need to be careful, or embed the transfor...

If other values than 'Y' and 'N' can exist, simply change the logic to where field 'Y'.[:D]

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

The Aggregator stage does not request all the memory it requires up front, because it can not know a priori how many distinct values it will need to group. Instead, it allocates an initial space (default 8KB), then increments this by a small multiplier (default 2) until a particular threshhold is re...