DSXchange

Welcome aboard, This is usually done post-run with a routine that invokes DSGetLinkInfo() a sufficient number of times to get the row count for each link. This could then be matched, for example, against a set of business rules (in a database?) that stores information about which sums need to match.

What do you want to happen with the third decimal place digit?

Load 10 million records as a single transaction. Buy beer for your DBA so that a sufficiently large UNDO segment will be created.

:? There's no "then" in a constraint expression as expressions just evaluate to true or false. A "then" only has a place in an assignment, something you would use in a derivation. That's not correct - not sure what Craig was thinking at the time. Maybe this. The IF expression must have both a THEN ...

Did you mean '01/08/2006'? If not, what is your business rule for date arithmetic?

Try ISO8859-1 as your DataStage NLS map.

I'd have to think that's some legacy in the product when fixed-width was all that was possible. Use a message handler to demote/suppress this message.

Who knows? "Your mileage may vary." It may not even work (the transaction size may become too large for the UNDO tablespace).

A Routine activity in which the routine invokes the DSGetJobInfo() function with DSJ.ME as the job handle and DSJ.JOBCONTROLLER as the InfoType argument should do this for you. If there is no controller this returns a zero-length string. Or you could use a User Variable whose value is set via the eq...

Can you please inform us how you changed the encoding style to get this to work?

If you know the name of the job then you can use the dsjob command, specifying ANALYZERPROJECT as the project name. This command is documented in the Parallel Job Advanced Developer's Guide and in the Server Job Developer's Guide manuals.

You woul dhave had the answer faster had you bothered to Search DSXchange.

You need to clear the preserve partitioning flag from the upstream stage.

Curious. You shouldn't get that message for VarChar. Does the job still work despite that error? Can you make sure it's not defined as Char anywhere downstream (in particular in the export operator)?

There is no error log file for DataStage jobs - the log is a database table in the local Repository database. You can view its contents using the dsjob command.

By "open" do you mean in a firewall? DataStage clients use a specific port number to connect to DataStage servers (by default 31538). To connect your browser to the web console for Information Server you specify the port number (by default 9080) in the URL.