DSXchange

Probably. I am without DataStage at the moment, gearing up to perform another installation. My DSXchange answers are from memory. Rnd() is the equivalent server Transformer function. I vaguely recall that Rand() only returns a value between 0 and 1; if so you'll need to multiply that by an appropria...

That doesn't mean your job runs under that ID. Use ExecSH as a before-job subroutine and execute the id command to determine the actual user.

Run Cognos through Microsoft Word spell-check.

Try the following Google searches (may not work in old versions like IE6).

• tilt
  let it snow
  recursion
  do a barrel roll
  Hannukah
  anagram

should get you close.

What user ID do your DataStage jobs run under?

Weeks is easy. And if you're only interested in 01/01/yyyy as the base date, then 31 is a reasonably day count figure to use.

Months, on the other hand, require you to extract the day number and month number, and compare these. Pertinent functions are MonthDayFromDate() and MonthFromDate().

pandeesh wrote:By default , both will commit at end of all the records processed.
Correct me if I am wrong.

You're wrong. Bulk load is non-transactional, so COMMIT does not come into the picture.

There's also an APT_ environment variable that can specify the default DB2 instance. I can't recall what it is at the moment.

I, too, would use separate stage variables (they can be combined with OR) or, perhaps, write an IsValidSSN routine.

Not as good as "No keyboard detected. Press F2 to continue".

pandeesh wrote:The moving folders option should be included in future release.

That's news to me. Where did you hear that?

Gimme a B...

Gimme a U...

It's now time to involve your official support provider, as you would appear to have discovered a bug.

One example is where the table is self-referential, such as every employee has a manager ID. This is enforced with a foreign key constraint. How do you get the first row into the table? Answer: you populate the first row (maybe called a ghost row) before you apply the constraint.

Insert a "C2 is null" filter into the data flow?

You haven't really thought about this as a DataStage problem. You have to read the entire text file. Therefore you will get to see every row. A conditional transformation will be easy to construct

Multiple output links with different constraint expressions?

What do you mean by "filter"?