Search found 53125 matches

by ray.wurlod
Fri Aug 20, 2010 4:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid Filenames using File Name Column property
Replies: 3
Views: 1323

Were any rows reported as rejected? Use Monitor to determine how many rows were handled by each node.
by ray.wurlod
Fri Aug 20, 2010 4:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Un-installing datastage 8.1
Replies: 1
Views: 827

If you had all the fix packs and patches installed, two hours is no surprise. Give it at least four hours. Ask yourself what was the total time spent installing.
by ray.wurlod
Fri Aug 20, 2010 4:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to remove all spaces in a string
Replies: 2
Views: 855

StripWhiteSpace(InLink.TheString)

This one is more "self documenting" than the others.
by ray.wurlod
Fri Aug 20, 2010 4:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Meaning and solution of the warning
Replies: 6
Views: 2102

Double precision can store larger values than single, so DataStage is warning you that there may be cases where this conversion can fail.

"Double" in SQL terms is dfloat in the record schema.
by ray.wurlod
Fri Aug 20, 2010 2:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To get Record count in Transformer
Replies: 15
Views: 18628

ravireddy25 wrote:i dont have premium account.
That is easily remedied.
by ray.wurlod
Fri Aug 20, 2010 2:43 am
Forum: General
Topic: going for datastage certification any tips
Replies: 2
Views: 1034

Have you tried the ten sample questions on the IBM certification web site? They are fairly representative of the style of question you will face. There is also much more information there about the areas covered and the relative percentage of questions you will face from each.
by ray.wurlod
Fri Aug 20, 2010 12:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To get Record count in Transformer
Replies: 15
Views: 18628

@INROWNUM
by ray.wurlod
Thu Aug 19, 2010 10:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Column Import
Replies: 5
Views: 1946

Show us the record schema that you're using for the Sequential File stage and for the output of the Column Import stage.
by ray.wurlod
Thu Aug 19, 2010 8:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORCHESTRATE
Replies: 3
Views: 1807

What are the columns named in your DataStage job, and which (if any) of these are identified as "Key"?
by ray.wurlod
Thu Aug 19, 2010 8:15 pm
Forum: General
Topic: Location of license xml file
Replies: 3
Views: 2301

Wherever you put it after you received it by email from IBM or downloaded it from Passport Advantage web site. If you can't find the file use Web Console for Information Server (Domain Management > Licensing) to view the licensing specified for your site. Don't contemplate hacking the license file; ...
by ray.wurlod
Thu Aug 19, 2010 8:10 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: What does the field "Status" (Rule/Rule Definition
Replies: 2
Views: 1641

The same set of status values can apply to a term in Business Glossary. Draft indicates that it's still a suggestion, in some sense still in a "development" state. Candidate indicates that it's been submitted for approval but not yet been accepted or rejected. Accepted means that this rule...
by ray.wurlod
Thu Aug 19, 2010 4:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IIS 8.1 backup
Replies: 5
Views: 1757

The question was not solely about DataStage jobs.
by ray.wurlod
Thu Aug 19, 2010 4:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we protect a portion of project?
Replies: 6
Views: 2364

That's right.

Jobs are records in tables, not files in directories. Therefore there's no file system permission based approach.

Currently DataStage does not include a per-job or per-category permission mechanism. As Raftsman noted the only solution is to use a different project.