DSXchange

The log files are NOT FILES - they are database tables.

You can use regular queries on the DataStage server machine; you do not need UniVerse installed.

Search also for a routine called ArchiveLogFiles which was published years ago - you're not the first to have this requirement.

Job design is

You can omit the Transformer stage if there is no transformation to be done. I prefer to leave it in there even if it's doing nothing, since it gives an active stage to monitor.

Now there is a useful new word: pratform

(It may have been unintentional but it's one I intend to use!)

To keep only printable characters, your "good" output can have the constraint expression InLink.ColumnName = Oconv(InLink.ColumnName, "MCP") and the "reject" output can have the logical inverse (<>) or simply use the rejected rows check box. The "MCP" conversion converts any non-pr...

Is there any required property (job name, parameter value, etc.) omitted?
Has the invoked job been successfully compiled before you attempt to use it in the job sequence? Has it been altered and/or damaged in the interim and not re-compiled?

Depends whether you want to report just the fact that the sequencer is to abort: jobA ---ok----->jobB---ok & warning--->sequencer(any)---ok-->jobC | V | +-------> Sequencer (Any) <--------------------------------+ | AbortToLog or whether you need extra information about which job...

I have a situation where I have to retrieve values for the same fields from a DB2 database every time but the where condition depends on the input data. Is there any way to dynamically change the where clause in a DB2/UDB or ODBC stage used for lookup? Thanks and regards, Bakul You can use job para...

Provided you have the VOC pointer (which you can create with SETFILE) it's a simple query. You may be more comfortable with SQL than with the RetrieVe query language that Chuck suggested. SELECT COUNT(*) FROM hashedfilename; Here, hashedfilename is the name of the pointer in the VOC file; be...

If the relevant columns in your tables are set to NUMBER(22) in the target that's not a DataStage problem. If you send your data to a text file, are the numbers truncated to 22 digits? If not, are you doing any transformation that might limit them to 22? Indeed, are you certain that the source has 3...

There are three rule sets each for a number of countries. For example, for the US there are USNAME, USADDR and USAREA. USNAME is used for bucketing - and, if you wish, subsequently correcting - individual and organization names for the US. USADDR is used for bucketing - and, if you wish, subsequentl...

What is the value of your EXACTNUMERIC tuneable? You could always SELECT CAST(THE_NUMBER AS CHAR(38)) ... FROM ... You don't need user-defined SQL for this. On the columns grid, after you've done the import, change the Derivation from schema.table.THE_NUMBER to CAST(schema.table.THE_NUMBER AS CHAR(3...

In a Transformer stage create an extra output link leading to your reject file. On your "good" output link have an expression that only allows non-reject rows through (for example InLink.City <> "DETROIT"). On the second output link, either have the logical inverse as a constraint expression (for ex...

If you use SETFILE, you're making the hashed file look like it was created in the account, by the fact that a VOC pointer exists. The fact that the hashed file is physically elsewhere is immaterial. Hashed files can always be deleted, but the correct method depends on how they were created. Put anot...

That's perfectly explicable. The project directory is the "home" directory for the process that runs your DataStage job. It's this process that is the Oracle client. The mechanism for running a server job is (slightly simplified): cd to project directory invoke uv (or uvsh ) as a PHANTOM (backround ...

For whatever reason, DRS uses the Oracle notation for parameter markers (:1, :2 and so on) despite the fact that no other database does so Surely, if democracy is such a wunnerfull thang (as Dubbya keeps telling us), we should go with the majority vote ("?" as parameter markers in this case). Indee...