DSXchange

OpenPath HashedFilePathname To FHashedFile Then Select fHashedFile To 9 Loop While ReadNext Key From 9 Read rHashedFile From fHashedFile, Key Then CenNo = rHashedFile<1> IPaddr = rHashedFile<2> ... * Calls to DSAttachJob, DSSetParam, etc. here ... End Repeat End

Think also about Templates or prototype jobs, creating routines that are more general than specific (and perhaps Transforms to interface to them via more meaningful names. And the big one is table definitions - import them once, with column descriptions added, and only ever use Load to bring them in...

Why can't you just use the DB2 stage and connect through DB2 Connect to the DB2/400 database?

There are two aspects. Is NLS installed but not enabled (NLSMODE exists in uvconfig but has the value 0)? In this case, all you have to do is toggle that setting and regenerate the configuration. If, on the other hand, NLSMODE does not exist in uvconfig at all, then it requires that the server be re...

No. Whenever you modify a Rule Set (including using overrides) you must provision it (copy it to the server) afresh.

Check for duplicates first then pass only the non-duplicates. Search the forum for "fork join" where I'm fairly confident one of the cases was capturing duplicate records in a separate stream.

Faster than what? Getting a faster server and faster network might be one approach. I'm curious about how you get reports using the Administrator. Please advise. Any automated solution involves YOU creating a script or routine to iterate through all the job names and produce the reports using approp...

Your Unidata Sys Admin or Unidata support analyst will guide you through the process. It's my understanding that it's an essential step in being able to access Unidata from DataStage, hence my original "ODBC" response. SQLConnect() is one of the functions in the ODBC API.

An example without a score dump (these tend to be governed by non-disclosure agreements signed with clients). DataStage inserted tsort operators on both inputs to Join stage even though the data were already sorted by the SQL query. So the data were re-sorted unnecessarily (and it was a large number...

Create a sequence. When you compile it you will have your routine.

ray.wurlod wrote:Resist stupid requirements!

Small philosophical problem with the subject line.

A3) The big one - parallel Transformer can executed on any node in a clustered/grid configuration, whether or not the DataStage server engine is visible. You don't need any others.

SQLConnect() says "ODBC" to me. Have you rendered the Unidata account into a schema using VSG ?

The fact that it's library liborchsybasent that cannot be found suggests that it's actually a library search path failure. This is backed up by the "PATH failure" diagnostic. The library search list on your DataStage server needs to include DataStage libraries.