DSXchange

Hashed files are created by default using 32-bit internal pointers. That is the source of the 2GB limit - it is the largest address that can be accessed with a signed 32-bit integer. You can create hashed files with 64-bit internal pointers, or convert existing hashed files to 64-bit internal pointe...

There are no online guides. Only the manuals that come with the product.

Test the returned key column, or any returned not null column, to determine whether it is null. That is all you need. If it is null, the lookup failed. Your constraint expression on the "good rows" output should therefore be

Can you use MERGE or JOIN stage .That can be helpful to you. through that stages you can remove what you want?the columns which are not matching that can be reject . Efficiency Note This approach involves the not inconsiderable overhead of converting from a server job to a parallel job. Server jobs...

TRY THIS. IF ISNULL(LINK.FIELDNAME) OR TRIM(LINK.FIELD) = '' THEN @TRUE ELSE @FALSE Efficiency Note ISNULL(TRIM(LINK.FIELDNAME)) OR TRIM(LINK.FIELD) = '' performs the same task. IF test_expression THEN @TRUE ELSE @FALSE is inherently redundant. Similarly, trimming NULL has n...

You can create the paragraph (a series of TCL commands) in the Administrator client's command window. One of these can execute the UNIX command: SH -c "<<UNIX command>>" Once all the TCL commands are contiguous in the command window, multi-select them and save under a name not used for any...

Search will reveal that you query a Repository table called DS_JOBS.

There is no View Data for Lookup File Set. Nor is there any tool for viewing the rows in a Lookup File Set. This is because streaming data is not how a Lookup File Set works. Its operation is predicated upon receiving a key value and returning that row. If you must view the data sent to a Lookup Fil...

Depends what has to be in them. If the header is fixed text, for example, you could set up a before-job subroutine to use echo command. The Sequential File stage in your job would then be set to append, rather than to overwrite. Similarly trailer could be an operating system command that picks up th...

File Pattern is NOT read from another file; the property value must be the wildcard itself. For example, in your case, Test?.txt would be a suitable value. What you need to do is to read TestControl.txt in an ExecuteCommand activity in a job sequence then supply its output as a "list of things" to a...

If the job has never before existed in production this should happen automatically. Inspect the code of the key management routine that you are using (it's in the SDK part of the Routines branch of your Repository).

I needed to run this in job stage and wanted to avoid Sequencer. I needed to run this in job stage and can not use sequencer.... Why can't you use a job sequence? It would make testing the condition under which you want to unwind the load easier, given that the job that performs the load can be fin...

What data type are you using in DataStage? This behaviour might occur, for example, if you were using an unsigned numeric or an inappropriate scale value. Are any warnings logged?

If you are executing a Match stage within QualityStage one of the early columns in the match report is the match type; you structure the report by loading it from a system variable. Work through the examples in the QualityStage manual and/or tutorial to get examples.