Search found 53125 matches

by ray.wurlod
Tue Jan 17, 2006 3:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Notification Activite + SMTP
Replies: 1
Views: 1032

You probably need to install an SMTP client on your DataStage server machine. There are plenty out there for Windows; I like blat.exe best. Search on Google or similar.
by ray.wurlod
Tue Jan 17, 2006 3:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Implementing Type 2 SCD with DS
Replies: 13
Views: 4396

Yes. They aren't.
by ray.wurlod
Tue Jan 17, 2006 3:32 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer Aborts Due to Error Code = -14
Replies: 23
Views: 11723

Everyone knows that DataStage server machines have infinite capacity and it's perfectly OK to run thousands of jobs simulaneously! :twisted:
by ray.wurlod
Tue Jan 17, 2006 3:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Setting Parameters for Jobs
Replies: 3
Views: 1025

As to "how", it depends on how you ask for a job run. If you run the job manually from Director, you are prompted to enter parameter values. If you run the job from the command line (dsjob) you provide as many -param name=value options as necessary. If you run the job from a job sequence, the job se...
by ray.wurlod
Tue Jan 17, 2006 3:29 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Erro - Converting from UTF-8
Replies: 4
Views: 2233

In the Adminstrator you can also build and install other maps. Click the NLS button. Problem is, which maps do you need? A selection of all available maps is presented when you open this dialog. There is also an NLS manual for DataStage, which should be in your Docs folder (as nls.pdf).
by ray.wurlod
Tue Jan 17, 2006 3:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.BCIConnect function's arguments
Replies: 1
Views: 873

DSD.BCIConnect is not a documented function. No function with a DSD prefix is a documented function; they are for internal use by the product. If you want to know about the publicly-available BCI functions you can establish a telnet session and enter the dssh environment on the server, then type HEL...
by ray.wurlod
Tue Jan 17, 2006 3:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning msg when calling server routine in parallel jobs?
Replies: 8
Views: 3822

U is a common name in Burmese but not an English pronoun. Cud is something chewed by ruminant animals. Wud probably rhymes with cud, but doesn't mean anything. Ur was a city in Mesopotamia thousands of years ago. To help those who do not have English as a primary language can you please avoid these...
by ray.wurlod
Tue Jan 17, 2006 3:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LOAD FROM STAGING TO REPOSITORY
Replies: 5
Views: 1649

If the load is managed in a DataStage job, and has finished, then that job's log will have a "job finished" event.
by ray.wurlod
Tue Jan 17, 2006 3:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: warning in lookup stage
Replies: 6
Views: 2725

Exactly the same error?

What are your partitioning settings on both inputs to the Lookup stage?
by ray.wurlod
Tue Jan 17, 2006 3:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Fatal Error with succesfull Completion
Replies: 10
Views: 3381

If you're running version 7.5 or later, and if you're controlling the job from a job sequence, then you can include a Terminator activity to issue stop requests to all jobs running under control of that sequence.
by ray.wurlod
Tue Jan 17, 2006 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DS.PLADMIN.CMD CLEAR STATUS
Replies: 3
Views: 2156

Sounds like an attempt to clear the status file of a job that has no active stages, such as a job sequence or a job design consisting solely of passive stages (for example SeqFile -----> DB2), or a job that has never been run (hence the lack of process numbers). It is likely that this is not a probl...
by ray.wurlod
Tue Jan 17, 2006 3:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Implementing Type 2 SCD with DS
Replies: 13
Views: 4396

There is a small, calculable probability that a CRC value will not be unique. It's the reciprocal of the number of possible different values. For example, a 32-bit CRC has a 1 in 2**32 chance of a false positive. My present technique - separate comparisons - is needed because there is a requirement ...
by ray.wurlod
Tue Jan 17, 2006 2:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Calculating age using date
Replies: 9
Views: 10975

You can convert the date of birth into internal format using Iconv() then subtract that value from system variable @DATE, which is already in internal format, to get age in days. Divide by the average number of days in a year (365.249) and apply the Int() function to yield complete years. Int(&#...
by ray.wurlod
Tue Jan 17, 2006 2:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Linux Evaluation Serial No
Replies: 2
Views: 686

There are no evaluation licences unless the account rep is fairly certain that there is a high probability of a sale.

So, you will need to convince your IBM account rep or reseller that you intend to purchase.
by ray.wurlod
Tue Jan 17, 2006 2:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warning msg when calling server routine in parallel jobs?
Replies: 8
Views: 3822

In a job sequence an OK trigger wants the return value to be 0.

Change the trigger to a custom trigger, for example

Code: Select all

RoutineActivity.$ReturnValue >= 0