DSXchange

Job parameters provide insurance against things that can change over time (like passwords and selection criteria) and things that can be different on different environments (like DSNs, passwords, user IDs, schema names, pathnames). You should have made them into job parameters in the first place. My...

Is there any way to change a job parameter value with in the same job while the job is running?
No.

Not that way. It is the nature of the design that EndLoop is triggered by completion of the Job Activity. You could have a RoutineActivity in the loop that starts the job asynchronously. But even easier would simply be to have N instances of a Job Activity on the canvas with no dependencies. In this...

Server jobs are run by a DataStage BASIC program called DSD.RUN, for which source code is not available. It uses data (metadata?) in the RT_CONFIG file to figure out what to do, what dependencies there are, and so on. Passive stage types expose method functions (some in BASIC, some in C) that are in...

Just drag the column name from the Sequential File link into the key expression field. A line will be painted on the canvas to show that this has been done. Make sure that the input from the sequential file is a stream input, not a reference input. Drag columns from both input links onto the output ...

Yes, provided there is information in the one that can be used as the key to the other. If so, you can use one on the stream input and the other on a reference input.

Otherwise you can use a UV stage and SQL (for example to join on non-key columns, form a UNION, etc.)

We would be interested to see your solution using a hashed file to solve a range selection query?

Or have you simply loaded the hashed file with every possible value - a solution that would not scale well (not a problem if you know for a fact that it will never need to).

If, as earlier posts suggest, your files are all sorted on the same key already, you may be able to use paste alone. You will need the -d option to specify your non-default delimiter character. OR allow the default character (tab) to separate the original lines, and change them subsequently with a t...

In server jobs at least, a stage type with no links is already inactive. It does not prevent the job from compiling.

Show us how you convert 001 to 01/01 and 059 to 02/28 and 060 to ... umm ... is it 02/29 or 03/01, using substring.

It's not a DataStage problem. No database will let you use NULL in an "=" expression. If you need to update a column in which a search column is null, you must use IS NULL explicitly. So you need two outputs. One which does as you've done, but which only passes rows in which both search columns are ...

Welcome aboard! :D What do you mean by "practising on hashed files"? Did someone create them for you? Or did you create them and, if so, how? To read the data from a hashed file you can use a Hashed File stage (or a UV stage under certain circumstances - search the Forum for SETFILE). Process this t...

If you can be certain that your source data are correct you can write a simple expression, maybe encapsulating it for re-use in a Transform. Oconv(Iconv(JulianDate, "DYJ"), "D/MDY[2,2,4]") (assuming you want month-day-year order. Adjust the second argument of Ocon...

The only restriction is that both tables must exist in the same data source. Beyond that, you can do joins, group by, and so on within generated SQL (with additional clauses on the Selection tab, and aggregate functions in the Derivation cells on the Columns tab). With user-defined SQL you can do th...

FIX(If (N = Int(N)) Then N Else N+1, x, y)