Search found 53125 matches

by ray.wurlod
Thu Sep 28, 2006 3:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unziping file from Windows environment
Replies: 25
Views: 9309

You might also investigate using the START command in DOS for running your command.
by ray.wurlod
Thu Sep 28, 2006 3:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read the max_key value and increment by 1 to the key
Replies: 15
Views: 4555

Create a (server?) job to select the max key value and park it somewhere, for example in a file, in that job's user status area. Run this job and your main job from a job sequence. The job sequence picks up the value, and supplies it as a job parameter to your main job. Increment the value in a Tran...
by ray.wurlod
Thu Sep 28, 2006 3:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence Job
Replies: 1
Views: 805

Welcome aboard. :D

It sounds like you might be running your client on Windows XP. There is a specific patch that you need to be able to open Routine activity (and some other controls). Ask your support provider for the Windows XP sp2 patch for DataStage.
by ray.wurlod
Thu Sep 28, 2006 3:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_PMwaitForPlayersToStart error
Replies: 3
Views: 1226

Then it's likely to be a network problem of some kind. Get your network administrator to check the NICs can cabling, and network configuration. Otherwise, monitor the network (LAN?) to make sure it's not saturated; if it is, install a dedicated network (separate domain) between the machines in your ...
by ray.wurlod
Thu Sep 28, 2006 3:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Null_filed Length
Replies: 2
Views: 1004

The Null Field Value property must have the same length as the field to which it applies when the format is fixed-width.
by ray.wurlod
Thu Sep 28, 2006 3:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling
Replies: 4
Views: 1754

All five parallel jobs will be attempted to be started at 9 o'clock. If you have sufficient system resources, they will all end up in a running state, but remember you will have five conductor processes, 25 section leader processes, and lots of player processes. If you don't have sufficient resource...
by ray.wurlod
Thu Sep 28, 2006 3:15 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get BETWEEN DATE FROM HASH FILE
Replies: 7
Views: 2423

Hashed files are not available in parallel jobs.
by ray.wurlod
Thu Sep 28, 2006 3:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we load data into Teradata View using Enterprise Stage
Replies: 3
Views: 1006

Provided that it's an updatable view, it should be OK. I suspect you lack privileges to SELECT the system tables in which the database layout is stored. Search the forum for the names of these tables, then involve your DBA to grant these privileges to the user ID that you use to run DataStage jobs.
by ray.wurlod
Thu Sep 28, 2006 3:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata_Enterprise Error
Replies: 4
Views: 1957

I suspect you lack privileges to SELECT the system tables in which the database layout is stored. Search the forum for the names of these tables, then involve your DBA to grant these privileges to the user ID that you use to run DataStage jobs.
by ray.wurlod
Thu Sep 28, 2006 3:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Scheduling thro director
Replies: 4
Views: 2725

Yes, but there's no "every hour" setting - you need a separate entry for each time that you want the job to run. If it's already (still) running at any of these times, the new instance will not start.
by ray.wurlod
Thu Sep 28, 2006 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replacing a string
Replies: 17
Views: 6988

Good point - though a parallel Routine is not a BuildOp (which is a stage).
by ray.wurlod
Thu Sep 28, 2006 2:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Please post clear and descriptive topics
Replies: 1
Views: 18287

Etiquette Note
Do not hijack threads. In particular, do not hijack "sticky" threads.
by ray.wurlod
Thu Sep 28, 2006 2:56 pm
Forum: IBM QualityStage
Topic: Creating an override
Replies: 3
Views: 1601

There are indeed five different overrides, so five tabs. The choices allow you to intercede at different steps in the analysis (bucketing) process. There's a list of the order of operations in the User's Guide or in the student manual for the QualityStage Essentials class.
by ray.wurlod
Thu Sep 28, 2006 5:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading more than one file.
Replies: 2
Views: 1251

Use a Transformer stage to parse the record structure. This can have separate outputs for each of the DB2 tables. There is no need whatsoever for a Link Collector stage.
by ray.wurlod
Thu Sep 28, 2006 5:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SDKSequence access from remote location
Replies: 10
Views: 3459

It is singularly dangerous to do, because the record-level lock taken when you update a record in SDKSequences is recorded in shared memory on the executing machine, so that the other server will be unaware of it, and may engender lost updates. There is no networking software, so you would need to c...