DSXchange

If @A or @B (what are these, in your job design) have not been assigned, then they will be replaced with zero. This will generate the results that you are seeing. Any reason you can't use explicit constants, for example initialize iniVAR to 0 and deriving the output column as (iniVAR + 1)?

Hashed files are how the UniVerse database implements its tables. Every column in the primary key must be defined as NOT NULL. This is the same as every table in every database product I have ever worked with. It follows that no key column in a hashed file can accept NULL as a value. That definite e...

The on-line help in Designer is also a valuable tool. It's more than a reference, it's also a "how to" guide. Open the help. Choose the Search tab, and search for job sequence. Choose appropriate topics (Activities is a good one on which to start; these are a job sequence's equivalent of stages in s...

The best way is DIY. Then you have explicit, custom control over what is happening and what can happen. Run everything from job control code, and use (possibly table or file driven) flags to indicate whether jobs can be started. For example, at my current client this is table driven, and the table i...

Sounds to me like the hashed file was created as "type 1" or "type 19" (which is simply an operating system directory) rather than "type 18" (which is a static hashed file) or "type 30" (which is a dynamic hashed file). Whether this is a bug in the product or in your job design is not something I ha...

Dynamic hashed files (the kind used by DataStage for repository tables) are updated in 2KB blocks unless their GROUP.SIZE parameter is set to use 4KB blocks, which is not the case (though you can change it, it would be of no benefit for log files, since each event goes to a different group, because ...

Teej wrote:Why not? What is the proper way to abort?-T.J.

You don't. You provide a path through your job control code whereby jobs don't get started. Usually with IF.

Running jobs are killed. Examine the ds.rc script. There's one in /etc/rc2.d (or whatever the auto-start directory is on your particular UNIX). There's another in the sample directory under the DS Engine. You should, for preference, make sure that there are no running jobs before shutting down DataS...

A cleanup project does do a re-index, but there's no command line interface to the "cleanup project" capability. You can, however, get to the DS.REINDEX ALL via the uv command on a command line interface. Supply the "Press any key" responses from /dev/null (UNIX) or .NUL (Windows) using redirection ...

The two Commands run in separate process. And, if I read your original requirement correctly, one after the other. If they ran concurrently, there may be some capacity for creating IPC routines for communication between them. But, without that, there's no common environment. You have to use the file...

There are a number of techniques for making job control code bullet proof. They include: ensuring that the job is attached properly ensuring that a job is in a runnable state before requesting its run ensuring that parameter values are read accurately from wherever ensuring that parameter values are...

The FTP stage is for file moving. Not everyone has the luxury of shared drives. If you've got shared file systems, then you should be able to access these without using FTP. FTP can overcome the restriction of not having network file systems. Also, FTP can work from any location (for example FTP web...

Depends on what your commands are. Probably the easiest thing to do, if your commands are shell scripts, is to write the value to a file in the one, and read it from the same file in the other. For example: echo $MyValue > $filename `head -1 $filename` The two commands run in separate processes, so ...

Alas, that's not what TRIM does. TRIM( string ) removes leading, trailing and redundant white space characters (usually space and tab) from string . This may have achieved what you need, if the extraneous characters were white space (for example, if STATE were a CHAR(5) column, which may have been r...

kduke wrote:I can write BASIC in my sleep.

No comment.