DSXchange

Are these default hashed files (dynamic)? Is there anything unusual about the output stage?

What I'm thinking here is a behaviour of UniVerse when constructing file names, to substitute the "?" character for "". But I've not seen this occur with data.

You CAN upgrade from server to parallel version, simply by purchasing an extra licence. All the software is already in place. However, at version 6 (indeed at any version other than 7.5x2 specificially) you can only design parallel jobs on Windows platforms - you will not be able to execute them. Ha...

You're way off track, but not as far off as your friend.

Read Chapter 2 of Parallel Job Developer's Guide, which explains the architecture requirements. SMP can be a single CPU server, but this will have limited capacity.

It doesn't need to be recursive. Use a simple counted loop from month number down to 1, perhaps in a Start Loop activity.

Were there 9 files in the archive, by any chance?

The job number (317 in this case) is in the last line of your code. Otherwise get into the Administrator client Command window and SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<Job Name>>'; Since the new version is working I'll not devote more thought to runaway osh processes. There's nothing in the cod...

LIST.DICT is a paragraph (macro, if you like) that invokes LIST DICT but prompts for the file name if you forgot it give it on the command line. The default display for file dictionaries, governed by the @ phrase in the dictionary for dictionaries, specifies sorting by TYPE then by KEY.CODE, so that...

gpbarsky wrote:P.D.: does it exist an user guide for server jobs and sequencers ?

Server Job Developer's Guide
Core Developer's Guide
Both manuals are in the Docs folder with your client software.

That doesn't solve the mystery of the "?" character. Can you post a couple of source records that illustrate this issue? Also tell us your exact DataStage version. Maybe someone can try to replicate.

Of all the answers given, adding zero requires the fewest CPU cycles and is therefore the most efficient. Both arithmetic solutions (add zero, multiply by one) rely on the fact that DataStage BASIC always returns the shortest possible character string as its arithmetic result - leading and trailing ...

Does your manager seek to access data from UniVerse using parallel jobs, or just expressing concern about the DataStage Repository? If the latter the answer is that there is no choice. All job designs and other components are stored in the same tables, irrespective of job type. There is only the one...

You can do a lookup directly against the target table. If the record is not found, you need an insert.

But this will be slower (far slower, if it's a remote Oracle table) than pre-loading a hashed file with the keys from the target table and looking up against that.

No, 0 means unlimited. Slightly increasing SPINSLEEP (maybe to 6000) will mean that the wait between retries is extended, so that the likelihood of hitting the timeout is reduced.

Changes do not take effect until uvregen has been executed and services restarted.

But wait! There's more!

It (Display Width) also controls the column width if you write to (or read from) a fixed-width sequential file.

Not every database has a function called DATEDIFF. This is where you might run into an issue using DRS.