DSXchange

They're also not exported if the Job Designs section isn't checked.

Alternatively, always write to the same, standard, file name and use an after-stage or after-job subroutine to compute the dynamic file name and rename the file. (This is much easier on UNIX, where the output of the date command can be captured within the mv command, but I note that you are on Windo...

Ray, Kindly let us know if there is any round about way to handle Update and Insert in a single job. Thanks Run the inserts into a bulk loader stage with automatic run, and the updates into a sequential file stage, then use an after-job subroutine to trigger the bulk load of the updates. This is on...

Just for once I must disagree with Vince. There are occasions when you want to SELECT from a hashed file, such as when you've used it for de-duplicating data. I'm guessing that you created the hashed file in a directory rather than in an account. The hashed file stage can access hashed files that ar...

64-bit refers only to the internal forward and backward pointers within the file structure. Therefore, it does not matter that DataStage is a "32-bit application" (I'm not sure what that means - is it 16 times better than a "two-bit application"?). However, it is essential that the Operating System ...

Since you're on Windows as your O/S, the only option available to you - for version 7.0) is a server licence. There are at least two Ascential resellers in India. Contact Ascential (or maybe just their web site) to determine whether there are more. I don't know what the pricing structure for DataSta...

There are literally hundreds of these constants, and they're almost all defined in header files (files whose names end in ".H") in the dsinclude directory. Don't ask in class; it's a major red herring. For example, the two about which you asked are the file variable(hence FVAR) (in DataStage Run Tim...

This is definitely one for support. We mere mortals aren't privy to what a "Security Adapter DLL" is supposed to do, or how to debug it when it doesn't. My guess is that it's the component that checks to see whether your login ID belongs to a DataStage role, in order to authenticate that you're OK t...

The "correct" way to pass values between stages is to add extra columns to links. The values passed thus don't have to appear in the target database; they can be consumed by any downstream stage.

The obvious questions are (if you're the interviewer):

When is it safe and when is it not safe to back up a system on which DataStage is installed?
What steps can and should you take to make it safe?
What differences happen if you're a 24x7 shop?

Use a stage variable for each, for example called MinCol and MaxCol. MinCol is derived as If InLink.TheCol < MinCol Then InLink.TheCol Else MinCol MaxCol is derived as If InLink.TheCol > MaxCol Then InLink.TheCol Else MaxCol In the final row you will have the desired information. This is just one so...

Abort is fairly serious - is there some value in the input data that is not valid to be converted to DECIMAL(10,10)? This data type implies that your data values, when converted, will be between 0 and 1. Is this correct for all values? Is the decimal place character present in the VARCHAR field, or ...

There's not really a lot of information in your question. What stage types are you using in your design that might involve incurring a timeout? Are there delays in connecting to databases? And so on. The -99 code is a general error in the Repository that can't be diagnosed any better. It may be that...

Actually, you want an Iconv function. This converts your date into DataStage internal format, and allows you to remove the MDY vs DMY ambiguity. For example: Iconv(TheDate, "DMDY") You can then convert this to an Oracle timestamp format using your own expression, the Transform from...

Code 2 2 indicates that the product is not licensed or that the license has expired.

DBSetup not found definitely suggests that the product has not been properly installed. (This may be something as simple as the /.dshome file not existing.)