DSXchange

Welcome aboard! :D Hashed files are, originally, the means by which the UniVerse RDBMS implemented its database tables. Instead of using a primary key index, they use a computational method (called a "hashing algorithm") to determine the location of a record. UniVerse is the database on which the or...

I was able to prove to Ascential's satisfaction that there is a bug in the Folder stage; even when you select only the file name, it seems to load the entire file. An ecase has been generated; I don't yet have the number. On a lighter note, and in response to OS takes about 100-150 MB of RAM (seen a...

You might also investigate the possibilities of the complex flat file (CFF) stage, which can do some of what you require.

It's certainly fun to hack away at the foundation of your project to gain a better understanding of how DS works, but this hacking can and does sometimes lead to corrupt projects that Ray and the others end up helping to recover! I should point out that this is a service we sell ; it's not done for...

DS_JOBS is not a command, it's a database (Repository) table used to map job names to job numbers. I believe you're asking about the dsjob command, which is a command line interface that can be used for: running and stopping jobs working with job logs discovering information about projects, jobs, st...

I usually add the caveat that the undocumented Repository structures are subject to change at any time without advice or consultation.

What's reported in the job log when you run this version? If you don't get warnings in the log, then for whatever reason the rows were accepted!
Make sure that the output link execution order is correct; that the link variable values are captured after the link has been executed.

You can enhance the unmaintainability of your job design by naming the links as follows:

HFloadlink
HFIoadlink
HFloadIink

They will all appear the same on the palette.

Welcome aboard! :D

Can you post the contents of the error log? This will help to diagnose what is being complained about.

If you solve it yourself as a result of examining the log contents, please post your solution, to help the next person who encounters this error.

More detailed statistics about performance can be had by choosing the Tracing tab in the Job Run Options dialog (when you're about to run a job in Director), selecting an active stage from the list, and checking the Performance Statistics check box before clicking Run.

That "other user" can even be another window from your own PC; each window has its own agent process on the server. Deisgner locks, Manager locks, and the Monitor view in Director locks. Locks can also be held by abnormally terminated processes, such as when your network connection is broken. This c...

... provided, of course, that the directory for uvsh ($DSHOME/bin) is in your search path (PATH).
Otherwise $DSHOME/bin/uvsh will do it for you, provided you've already executed $DSHOME/dsenv

Much more important is why your Administrator client can't find the UV account. If this works you will be able to delete a project using this client. The most usual cause is that someone has moved the DSEngine directory from where it was originally installed. If that has occurred have it put back; t...

Welcome aboard! :D Can you please post this as a new topic? It's not related to job sequences. Posting as a reply to this thread makes it difficult for future searches. We'll answer it as soon as the new topic appears. You might also profitably use the comprehensive Search capability of the forum (f...

Selecting zero rows is not a failure as far as the database is concerned, so DBMSCODE will be 0, SQLState will be empty and LASTERR will be empty. There's no point in returning them. SQLSTATE is specific to ODBC protocol; does the DB2/UDB stage actually return these? (You should check with a dummy j...