DSXchange

[Server jobs] What program are the processes running? (DSD.RUN or DSD.StageRun) Use ps -aef to determine what resources each is consuming; take more than one sample and calculate the deltas. Try reducing the dsdlockd interval to, say, 450 seconds. Are the jobs and stages reported in Monitor view as ...

[Server job] You haven't really given us enough information to diagnose what's happening versus what you want to happen. If the sequences to be generated are independent, and in different jobs, and being used to load separate tables, then you can simply design both jobs with one stage variable in ea...

1. (a) Don't use C. DataStage BASIC is specifically designed to work with hashed files. (b) There are three libraries that can be used to use C with hashed files. One is the UCI (which accepts SQL functions - it's like using the ODBC API), one is InterCall (the underlying architecture for UniObjects...

Here's one I baked earlier. It calculates the number of completed months between two dates, so is not an answer to this post; rather it demonstrates techniques. You've pretty much got AddMonths nailed, though perhaps not optimally. For example, if DeltaMonths is >= 12 you could add (12*Int(DeltaMont...

Buried in Kim's code you would see a function called DSStopJob.
I think this is the function you seek.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

XML capability was introduced into UniVerse BASIC after code streams for DataStage and UniVerse diverged, in version 10.0 of UniVerse. Those XML functions are not available in DataStage BASIC. You could, perhaps, create a capsule that copied the XML streams into sequential files then used a UNIX com...

This is feasible but more complex than LOGTO. You then have to run the job in the other project which, in turn, means establishing that it is in a runnable state and so on. Then - and this is probably one of the more difficult pieces, you have to return to the project in which the original sequence ...

The final line of code ("Kenneth Bland") does not compile! [:D]
Sorry, couldn't resist.

Try INT(value+0.5) or OCONV(value, "MD0").
The second specifies "masked decimal, 0 decimal places, rounding". To get truncation it would be OCONV(value, "MD0T").


Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

Now you're getting into maintaing slowly changing dimensions, which has been covered more than once in this forum. In summary, you pre-load the hashed file with the current maximum value of the surrogate key (which is independent of CustID). Each time a CustID is processed that does not exist in the...

Yes, the BCI functions are agnostic about what ODBC driver you use. Whatever driver you use, though, it must be properly configured and a DSN entry (with DBMSTYPE = ODBC) must exist in the uvodbc.config file for your project.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

All this is fully documented in the Parallel Job Developer's Guide, chapter 35. This manual installs with your DataStage client software, in a folder called Docs. You can also get at it via the Start menu: Start > DataStage > OnLine Manuals > DataStage Documentation Ray Wurlod Education and Consulti...

Since Kim was cool enough not to do any self-promotion, let me also suggest DSWebMon (from Duke Consulting, Inc).
Visit http://www.duke-consulting.com/P1_DsWebMon_Main.htm for more information.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

It's pretty much impossible to do directly in BASIC because most FTP clients don't have an API that can be called from BASIC. Further, most FTP clients do not permit redirection of the password. You could, of course, have your BASIC create a shell script containing all the contents needed for your F...

UVFIXFILE is no longer being developed, and does not work with hashed files where 64-bit addressing is in effect. The replacement utility is called fixtool, and is executed only from an operating system shell. Always take a backup of your hashed file before using these repair utilities, as they can ...