Search found 53125 matches

by ray.wurlod
Thu Jul 01, 2010 2:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Version Control
Replies: 4
Views: 2282

Setting up is very straightforward, and is managed by the installation script. Essentially you have a separate project (by default called VERSION) in which are stored version-stamped copies of the objects from your actual DataStage projects. The Version Control tool provides an interface through whi...
by ray.wurlod
Thu Jul 01, 2010 2:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage initiated unix processes
Replies: 3
Views: 1383

It depends on which user is used to start DataStage.
by ray.wurlod
Thu Jul 01, 2010 2:37 pm
Forum: IBM QualityStage
Topic: standardize error
Replies: 10
Views: 9762

Please mark this thread as Resolved using the green button at top.
by ray.wurlod
Thu Jul 01, 2010 11:43 am
Forum: IBM QualityStage
Topic: standardize error
Replies: 10
Views: 9762

Right click on the SET icon in the Repository toolbar and choose Provision All. Or, as you're selecting the rule set within a design you can do the same thing.
by ray.wurlod
Thu Jul 01, 2010 11:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Column Naming Conventions
Replies: 4
Views: 1665

Not really. I guess you could create synonyms in the database. But DataStage can't deal with column names that are numeric.
by ray.wurlod
Thu Jul 01, 2010 11:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequential_File_0,0: Field "TRIP_NAME_IDENTIFIER"
Replies: 4
Views: 2019

Come on, look at the value that was rejeced!

Then enable "first line is colunn names".

Import errors at offset 0 are almost always due to this property not being properly set.
by ray.wurlod
Thu Jul 01, 2010 11:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: output inconsistent in link collector
Replies: 4
Views: 1624

Row buffering must be on if the Link Collector stage is used.
by ray.wurlod
Thu Jul 01, 2010 11:06 am
Forum: General
Topic: DS installation - packages - fix pack
Replies: 5
Views: 3104

Always use the right version of updater.jar - the one that ships with the software. For example, version 188 does not work installing FP1 client - it hangs - you need to use version 164-176 (from memory) - the one that ships with, or is linkd to from - FP1.
by ray.wurlod
Thu Jul 01, 2010 11:00 am
Forum: General
Topic: Another id to create project
Replies: 4
Views: 1421

Projects are created from the (Administrator) client. Therefore su is not an option.
by ray.wurlod
Thu Jul 01, 2010 10:57 am
Forum: IBM QualityStage
Topic: standardize error
Replies: 10
Views: 9762

Usually this message stems from failure to provision all files in the rule set.
by ray.wurlod
Thu Jul 01, 2010 10:56 am
Forum: IBM QualityStage
Topic: Problem with locked rule set.
Replies: 1
Views: 1167

The second person personal pronoun in English is spelled "you", not "u". U is one of our posters. And it's YOU (or your aborted job) that locks the rule set. If the deadlock daemon is running, the lock will be released automatically in the fullness of time. The trick is to creat...
by ray.wurlod
Thu Jul 01, 2010 3:16 am
Forum: General
Topic: Table value to local variable
Replies: 27
Views: 5848

It's an activity variable. Search DSXchange or the manuals for details.
by ray.wurlod
Thu Jul 01, 2010 3:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Date in oracle Timestamp in datastage
Replies: 4
Views: 4147

Because Oracle stores all dates with a time component.

Oracle is... different.
by ray.wurlod
Thu Jul 01, 2010 3:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stop the sequence at specific time
Replies: 7
Views: 2328

Depends, but almost certainly not. A sequence spends most of its time uninterruptably asleep waiting for activities to finish. If you check the system time after each activity finishes you can direct control to an "ending" path. The more complex the sequence, the more additional activities...
by ray.wurlod
Thu Jul 01, 2010 2:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Multiple lookups to lookup stage
Replies: 2
Views: 1607

I do so hate "we heard", particularly "we heard somewhere". Please cite your references so we can judge their provenance. Each reference input to a Lookup stage consumes more memory, because the data set associated with the link must be fully loaded into memory. But this will onl...