DSXchange

Of course he can't, because he has not idea how you're using this function nor does he have any idea - apart from what you posted earlier and which both he and I addressed - what the values supplied to that function might be.

The database manager is not able to accept new requests.

This is an issue in the database manager, not in DataStage. In short, it's overloaded. Discuss with your DBA about resource allocation or timing.

yyyy-mm-dd is 10 characters long, not 8.

You need to re-examine your metadata.

Not really. Within the loop, use the Field() function to extract the nth field where n = @ITERATION (the current value of the loop counter). svDelimitedFieldCount = DCount(InLink.DelimitedField, ",") Loop While @ITERATION <= svDelimitedFieldCount lvNthField = Field(InLink.DelimitedField, &...

Why not just have the Sequential File stage generate the row number? That would serve as the key you seek.

Yes. Stage variables are evaluated before loop variables, so you could count the delimiters into a stage variable then build your loop exit condition based on @ITERATION being less than that value.

Didn't notice any commas in hargun's example, but the same is true in DataStage. If there are commas, they need to be removed.

Trimming the leading currency symbol should suffice before feeding the value to a StringToDecimal() function.

Reject link will capture ALL records rejected by Oracle. You can add a column containing sqlcode to the reject link to get Oracle's reason for rejecting the record.

I would like to have the ability to use the special token $PROJDEF irrespective of the parameter type - for example Date and List types.

Who said?
<rant>Resist stupid requirements!</rant>

If these can be job parameter values you could create environment variables in the project. Then add the environment variables to jobs with default value of $PROJDEF.

What does "call" mean in this context? For example, if you try to invoke a txt file from a CMD shell, nothing happens.

Use a Pivot stage (or a PXPivot stage).

If you mean "leads to a Sequencer" you've got it.

Properties are usually to be found in the properties tab for the stage (not the Columns tab). There are some exceptions, such as the Format tab in the Sequential File stage, and non-standard stage editors such as Lookup and Transformer stages.