DSXchange

For text files, change the representation of NULL (either at the file level or at the individual column level) from "" to something else, perhaps "<NULL>".

That's why the word "Filtered" appears in the status bar.

The Epoch property sets the earliest date to be used.

It defaults to 1960-01-01.

Welcome aboard.

Does your particular UNIX support access control lists (ACLs)? If so, you can control delete permission separately from write permission.

As far as I'm aware it's not possible. The Hashed File stage does not even support parameters for the File Name property.

Well done!

That was so much better than us guessing at any of the myriad other things that might have been the cause.

They are not.

Query the XMETA database with a filter of table name like '%USER%'. Something should come up. If you use TOAD you can plug this filter in at the top of the list of tables.

Summary of what the (Auto) partitioning algorithm sets.

• Parallel-to-parallel: Same (except as below)
  
  anything-to-DB2(executing in parallel mode): DB2
  
  reference input to Lookup stage (not sparse): Entire
  
  inputs to stage types that need key adjacency: Hash

First, disable operator combination so you can learn where this is happening.

Then try to diagnose which decimal field is giving the problem - your metadata don't match what's out there.

Sparse lookup is substantially slower than normal lookup (the latter uses an in-memory virtual Data Set).

Specification = MKTG_CHANNEL_CD: string = substring[0,2] (MKTG_CHANNEL_CD)
Specification = NOWARN

Is that because folks can also put anything anywhere in the Repository tree, do you think?

DSJobName can be found as a DataStage macro in the operands menu of the Expression editor.

It is equivalent to (and much easier to write than)

What response did you give to the question about whether or not to install NLS?

What DO you think the Oracle OCI stages use?

Hint: what does "OCI" stand for?