DSXchange

Yes, it's possible, but NOT in View Data! You need to provide an explicit value when prompted for the job parameter value. For some reason, the data browser can not pick up the user-defined environment variable - even though it's right there. This is probably a bug. You'll find that they work fine w...

Welcome to US Imperialism, where Shift-3 is "#" (which, curiously, those in the US call the "pound sign"). Yamini's solution is the simplest.

The base assumption - that Rnd() cannot generate the same number twice - is incorrect. That's like saying that tossing a coin can never generate two heads or two tails - what happens on the third toss? Edge? How about the fourth toss? Your logic (somewhat familiar - are you at Reliance?) suggests th...

You have a problem if the incoming timestamp is 2005-06-22 00:00:00 for which the result should be 2005-06-21 23:59:59.

Create a stage variable or routine to handle this boundary condition.

When a link is from one active stage Xfm1 to another active stage Xfm2 there will never be any error. Therefore you need a different technique, probably an output constraint on Xfm1. But do you really want to trigger Job1 and - possibly - Job2 for every row in the text file? This is what your job de...

Do you have SELECT privilege granted on the requisite system tables?

The vital part of these messages is Contact Customer Support Immediately!!! You have a dynamic hashed file in which the "dynamic" mechanism has been broken. The figures being reported can also be seen using the command analyze.shm -d if the dynamic hashed file is open. I am fairly certain that the h...

There should be an entry in /etc/services for this TCP port number.

Addressing only the Notification Activity question, do you have an SMTP client installed on the DataStage server machine?

Is there is way to call sp within VB code?

Probably, but the answer won't be found on a DataStage forum.

As well as everything Vincent said, note that Readers Per Node is intended only for fixed-width format files. It's fully described in the Parallel Job Developer's Guide

The script to which Craig provided a link will run parallel or server jobs. No change is required, unless you want to control the value of the APT_CONFIG_FILE environment variable within the shell script. The dsjob command line interface is uninterested in the job type; it can start server jobs, par...

You could use the code below to determine the month number. The rest should be a simple matter of concatenation and the StringToDate function. Put the delimited Month list in the default value for a Stage Variable (svMM). Leave the derivation empty. svMM(default) = 'Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|...

The software occurs once, but a record of its existence must be loaded into DS_STAGETYPES in each project so that it can be used in each project.

Then you need a fast method of retrieving not just the matching record but also its standardized forms. I normally solve this by adding fifteen columns to the table into which I initialize the standard forms (e.g. NYSIIS of last name, NYSIIS of city) then index these and any raw data fields that I m...