DSXchange

I've the flow job of my project written in a .H file and called in the Master job with $INCLUDE DSINCLUDE MASTER.H. My question is, how is it the best way to work with .H file? Is it possible to import them in an DS editor to validate the code? Thanks Nic I'd be surprised if your first assertion we...

You're right, there are tons of threads, some as recent to day. Search for CHashedInput or CHashedOutput would be a good start.

With TO SLIST you don't need to capture anything. The Select List is activated.

In BASIC you should use Pick style SELECTs and not SQL SELECTs. Why? They are equally valid. The SQL SELECT with a TO SLIST clause generates an identical Select List to the RetrieVe SELECT, with the added advantage that it's easier to save a list of secondary key values (no need for SAVING or SAVIN...

"&" is a meaningful character to the shell. You must escape or quote it.

or

When INROWNUM is 1 there is no previous row against which to compare.

You will need to use a Routine activity. It is important that the file is moved before or after processing, so that a subsequent scan does not find the file again. Imagine that you have three arguments to the routine; the directory where the files land, the directory to which they are to be moved fo...

The number of posts per day here is growing. One piece of evidence for this is the time needed to read through them all. Another is the number requiring replies. Over the past few months, my long-run average number of posts per day has climbed from 8.33 to just over 9. Here's one for the arithmetici...

Do you actually have a table name in the Table Name field when using generated SQL? Something of this ilk has been seen and discussed on the forum before, when there was some "memory" of a previous iteration of the design-time objects. If I recall correctly, the fix was to emplace a replacement OCI ...

The StartLoop activity does not read a file. You would need to construct an expression of some kind that generated a "list of things" by reading the file. Read the help and the manual on the StartLoop activity to get some ideas. One is to cat the file and tr the line terminators into delimiter chara...

Take a look at the routine that calculates WEEK.TAG - you can probably adapt its business rule algorithm.

Or you can use the fact that Mod(internal_date,7) is 6 if the day is Saturday, and adjust forward from Iconv(first_of_month,"D").

gurus, can anybody tell me what mkdb.file and create.file will do in the hashed file context.what kind of hashed file both the command will create? my second question is what are the problems in loking up a database table not a hashed file? please put some light on the above question. thanks in adv...

It's all in on-line help and in the DataStage BASIC manual. You will also find examples in code snippets posted here. Try a Search.

And it's "hashed" file, not "hash" file. A hash file is used to shape a block of hash. A hashed file uses a hashing algorithm.

Before you attempt it again, use DS.CHECKER to check for orphaned components. Run this from Administrator client Command window or from TCL on the server.

ccatania wrote:I had heard that there could be some loss in DataStage functionality when sites upgraded to DS 7.5.2.

Where? Please advise your source (so we can weight its reliability in our minds), and any further information that may have been imparted, such as what particular loss.