DSXchange

There are quite a few ways. The job log records the number of rows processed on each link in the job. You can create job control or after-job routines to interrogate the link row counts. All have been described on this forum. Why not institute a Search for them? A good starting topic might be link r...

I've done exactly what Craig suggested, though in a DIY job control routine (it was before the days of job sequences). The function call you require is DSRunJob(hJob, DSJ.RUNVALIDATE).

The vendor will argue that hashed files were never intended for persistent storage and now that UniVerse and DataStage are separate products their argument carries more weight. If they ever decide to remove hashed file support from the product, you'll have a problem. A suitable replacement already e...

Craig has it right. The extra routines imply extra entries in the VOC, but all they and the hashed files are is a small waste of disk space. Worry about it only when you need an extra few KB of disk space.

The job parameter value must be obtained before you run this job. You can create a routine to read the value from the hashed file, then use the return value from this routine in a job sequence to provide the value for the job parameter in a Job Activity. FUNCTION GetHashedFileValue(HashedFilePat...

Make sure there are no DataStage processes. Take an export of each entire project. Take a backup of C: drive. Delete the projects from C: drive using Administrator client. Create projects with the same names on D: drive using Administrator client. Connect to each project with Manager and Import from...

Check whether the database and/or ODBC driver needs any environment variable (such as NLS_LANG) to be set to indicate the character set being employed.

I see this under circumstances that I haven't quite resolved yet, and it's been around since at least version 4.0. It seems to occur when the user ID is not Administrator, even though the user is a member of the Administrators group. And it only ever happens when the DataStage server is on Windows. ...

Posting on the parallel forum would have been a good first step. You can download the Orchestrate v7.0 manuals from Ascential Developer Net - among these is a manual describing all the operators. Or, if your C++ is good enough, you can set up your own signal handlers. All exceptions are notified by ...

None documented, and no reason why there should be. Rows are buffered (you can increase the buffer sizes), but the downstream process is draining the buffer ideally at least as fast as the upstream process is populating it. If your downstream processing can not go as fast as your upstream processing...

DSR_GETJOB and DSD.Update are internal DataStage functions. Are you using a routine such as UtilityRunJob in the Transformer stage. Can you post the 10 lines either side of line 577 in the file RT_BP585/JOB.1620143548.DT.1363942389.TRANS1 and the 10 lines either side of line 298 in the file RT_BP585...

Avoid random, for reasons already given. Use a sequence. All you are needing is uniqueness. Random numbers detract from performance when checking for uniqueness. You can generate the sequence using an Oracle sequence, a DataStage routine (such as KeyMgtNextValue), a stage variable and so on. Search ...

A key-only hashed file would do the job for you. Assuming your operating system allows files over 2GB, you can create or resize a hashed file to use 64-bit addressing, allowing a theoretical upper limit of approximately 19 million TB. In your case, you have 30 million keys, let's say 100 bytes per k...

You don't need to restart DataStage after changing .odbc.ini and/or uvodbc.config - however you may need to refresh the view in any already-connected client, or re-connect the client, so that they can pick up the new entries. The Import Table Definitions mechanism will always re-read these files, so...

Can Lotus Notes act as an SMTP client? If not, you may need to download an SMTP client, such as blat (search the forum for other possibilities).

SMTP = "Simple Mail Transfer Protocol". Nothing Lotus does is simple, imho.