DSXchange

To paraphrase what Ken posted, your job control routine reads the sequential file, constructs the file name based on what it has read, and passes this to the job as a parameter value using DSSetParam before requesting execution of the job. Within the job, the parameter reference is used to provide t...

MetaStage has been around for years. It's a mechanism for storing metadata in a generic fashion so that various applications (such as CASE tools, ETL tools, BI tools) can get at it. They do this through specialized filters called Metabrokers. It's also possible for MetaStage automatically to capture...

Both parallel and server jobs are behaving as documented. Sure they're mutually inconsistent but, then again, they were developed separately. Changing one (which one?) could negatively impact existing jobs that rely on the particular functionality. Since there's no such thing as a hybrid Transformer...

Do you need it within the job, or when inserting data into a table?

If the latter, use the CURRENT_TIMESTAMP or CURRENT_DATE constant in custom SQL. (The name of the constant, and how you may need to manipulate it with a date picture, vary between databases.)

Set the constraint on your bulk load stage to "1<>1" which ensures no rows go down this path but the control file gets created when the job starts. Save some machine cycles! :D Don't evaluate 1<>1. Just use 0 (or the system variable @FALSE, which the compiler replaces with 0) as the constraint expr...

Not every Transform invokes a Routine. Certainly you can call Routines from other Routines (probably needing a DEFFUN declaration). However, if the Transform is simply an encapsulated expression, the answer is definitely no. And using the Transform's defining expression in your code means that there...

The best way to learn this stuff is to play with it.

Why not contact your local Ascential office, tell them your desires, and enrol on the DataStage Essentials (PX) class? They may even be nice enough to allow you extra "play time" with the product!

It is not possible to call a Transform from any kind of routine, including a job control routine. If you use a Transform in a server job (Transformer stage) and examine the code generated by compiling that job, you will see that the Transform is replaced by its defining expression. In effect, at com...

If they are UniVerse services they are: UniVerse Resource Service UniVerse Telnet Service UniVerse RPC Service (perhaps called UniRPC Service) UniVerse REXEC Service If they are DataStage UniVerse services they may have the above names or they may have DataStage instead of UniVerse in the name, and ...

I've done these too. Even though not part of an SCD solution I've used an alternate technique for a larger number (when LOCATE started to degrade) implementing a "bit map" technique - actually a character string of "1" and "0" values and substring. It was to determine whether a particular STD (telep...

Although I can't answer the question I'd like to pose one. Why do you want to change the definition of something that exists, potentially introducing a mismatch between the thing and its description?

Data will still be partitioned. However, you have no way of knowing in advance in which partition your particular key will occur, so you have to use the Entire partitioning method so that the lookup can "see" the entire data set. PX will automatically look after ensuring that the retrieved row ends ...

Technically it can be done. Legally it's a bit of a grey area; location of the column definitions within the metadata is not publicly documented. As you may have gleaned, the objects in a job are stored in DS_JOBOBJECTS as far as their design time properties are concerned, but it may be a more accur...

Since VC was written by and, by arrangement with Ascential, is maintained by, the good folks who bring you this forum, there's a good chance that ideas you post here will get back to those who need to know. On the other hand, requests for enhancements should really go through "the proper channels". ...

I was trying to look for a document about how to read hash file using basic language, but could not get any. Does anyone know whether there is a reference book available? The manual you need is the DataStage BASIC manual, which is part of the documentation set. OPEN, READ, WRITE, CLOSE and their va...