Search found 53125 matches

by ray.wurlod
Wed Jan 17, 2007 3:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Abnormal termination of a Stored Procedure stage
Replies: 6
Views: 2293

Reset is different from recompile. By recompiling you have destroyed any preserved diagnostic information from the previous run. Get in the habit of resetting aborted jobs, and scanning the log for an entry titled "From previous run...".
by ray.wurlod
Wed Jan 17, 2007 3:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Not able to openup Job Activity Property
Replies: 21
Views: 5869

Please mark this thread as resolved.
by ray.wurlod
Wed Jan 17, 2007 3:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Pulling out Text in between tags
Replies: 11
Views: 2405

Nah. That would open a whole other can of worms relating to style sheets, XSDs and other TLAs.
by ray.wurlod
Wed Jan 17, 2007 3:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Weird Error
Replies: 4
Views: 1708

Etiquette Note
We're not "deaf" - regular sized text will suffice. If you want it to stand out, use bold, code and/or color tags.
by ray.wurlod
Wed Jan 17, 2007 3:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Getting count from a log of job
Replies: 6
Views: 1580

Constrain DSGetLogSummary() to entries made at or after DSJobStartTimeStamp.
by ray.wurlod
Wed Jan 17, 2007 3:36 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reference lookup generated 100 rows
Replies: 7
Views: 1692

I would suggest that the assertion about "one row each" could bear closer examination. Joining one row to one row can not, under any circumstances, generate more than one row.

Or are you perhaps looking at a job log for a different job?
by ray.wurlod
Wed Jan 17, 2007 3:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to assign value from table to environment variable?
Replies: 7
Views: 1564

Premium membership is a mechanism to help to pay for the bandwidth to keep this valuable site running. At only a few cents per day it's worth it. The answer is in my earlier post. A year's premium membership would cost less than engaging my professional services for an hour to answer that question,...
by ray.wurlod
Wed Jan 17, 2007 3:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Stage which does this logic
Replies: 3
Views: 893

The operation is called a vertical pivot. You can perform it faster with a Build stage.
by ray.wurlod
Wed Jan 17, 2007 3:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Setting Job Variables in a stage and accessing it in another
Replies: 10
Views: 3281

Job parameter values can not be changed once the job is running.
by ray.wurlod
Wed Jan 17, 2007 3:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to assign value from table to environment variable?
Replies: 7
Views: 1564

In a job sequence run a small job to return the value. Write it to a file or to the job's user status area. Follow this with an Execute Command activity to set the environment variable (and, perhaps, to export the same).
by ray.wurlod
Wed Jan 17, 2007 3:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding FTP STAGE
Replies: 15
Views: 3372

Re: Regarding FTP STAGE

Hi Gurus, My team is asking me to show how FTP works. I said to them that, basically inorder to work with FTP one needs mainframe environment, and it is mainly used to migrate files from one system to another. My database is oracle.How can i use FTP component and show them the way FTP works. cheers...
by ray.wurlod
Tue Jan 16, 2007 11:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Connect to Server error
Replies: 5
Views: 1097

In the Administrator client General tab, what map have you specified for client connectivity?
by ray.wurlod
Tue Jan 16, 2007 11:17 pm
Forum:
Topic: MetaStage Version Issue
Replies: 4
Views: 1373

7.0.1 is the most recent, and final, version of MetaStage. It does work properly with DataStage version 7.5.

What error message was displayed when your import failed (in each case)?
by ray.wurlod
Tue Jan 16, 2007 11:15 pm
Forum: IBM QualityStage
Topic: Web Services on Quality Stage
Replies: 6
Views: 2546

Not in versions earlier than 8.0. I do not know the answer for version 8.0. Why not ask the vendor (and let us know what they say)?
by ray.wurlod
Tue Jan 16, 2007 10:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance tuning
Replies: 6
Views: 1702

Vectors won't help - it's still the same volume of data.

Get more space. You need it.