DSXchange

ray.wurlod

No. VOC. VOC is vital. If you don't have a VOC you have major problems.

There was a post once about recovering a project where VOC had been hosed. It wasn't pretty, but it was done. Perhaps you could search for that.

ray.wurlod

I think it wants to see

Code: Select all

SELECT * 
FROM 
TABLE_XYZ 
WHERE 
ARRG_ID = ORCHESTRATE.ARRG_ID 
AND ARGFIN= ORCHESTRATE.ARGFIN

The lookup expects the lookup keys to be supplied from the stream input, via the ORCHESTRATE structure.

ray.wurlod

Start a new thread for the header and trailer, or search.

There IS an answer for these.

ray.wurlod

Code: Select all

SELECT * FROM USERS WHERE CLUE > 0;

0 rows selected.

We're not ignoring you - we'd post if we had anything cogent to say.

ray.wurlod

After GoSub RunNTCmd there is nothing to prevent your code falling through the RunNTCmd code again.

You need to branch away. Perhaps a GoTo NormalExit or RETURN immediately following the GoSub statement.

ray.wurlod

You can count the lines and total the lengths as the row passes through your ETL design, aggregate these as required and create a new row for each in your audit table. Writing to the audit table impresses as a great opportunity to use a shared container, in which the audit columns such as job name, ...

ray.wurlod

Yes, but the answer would have been different in a server job. That's why I asked. Well done on finding a solution.

Have you tried StringToDecimal(InLink.Col_1) + 0?

ray.wurlod

Server job (as marked) or parallel job (as posted)?

ray.wurlod

WHAT errors? Without knowing that, it's impossible to advise.
DataStage does not use the same shared memory segments or the same TCP port numbers as UniData, so it's not that.

ray.wurlod

In the Transformer stage.

ray.wurlod

Is there a VOC file in this directory? If so, can you get to TCL within this project in a telnet connection?

ray.wurlod

Because they come from different products. The Modify stage (modify operator) is part of the original Orchestrate product; the Transformer stage comes from DataStage.

ray.wurlod

Not enough information. Where is the DB2 instance located? Does the table already contain rows? If so, do any of these need to be updated, or are all the rows new rows, to be inserted?

ray.wurlod

Is that the pathname mentioned for the project in UV.ACCOUNT? You must specify the pathname of a project directory.

ray.wurlod

The "To" functions are for the Transformer stage. Modify stage functions are "from" functions, for example string_from_decimal().

Search found 53125 matches