Search found 53125 matches

by ray.wurlod
Sun Oct 22, 2006 11:26 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: regarding connection to profile stage
Replies: 9
Views: 4766

Etiquette Note Please don't "shout" (use all upper case), as it is offensive. I do not have the benefit of being able to see what you're doing, so am perforce obliged to ask questions in what I believe to be a systematic diagnostic process. If you would like me to visit your site to diagnose the pr...
by ray.wurlod
Sun Oct 22, 2006 11:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DATASTAGE GRID
Replies: 5
Views: 2093

I don't, but everyone in IBM can find everyone else. Get your local rep to find Bob for you. (I am not an IBM employee, so don't have access to their internal systems. And Bob had run out of business cards at IOD.)
by ray.wurlod
Sun Oct 22, 2006 11:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read DataSet file name patterns
Replies: 8
Views: 1936

It's in the earlier posts - multiple Data Set stages feeding through a Funnel stage to bring them together.
by ray.wurlod
Sat Oct 21, 2006 4:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting a single record into multiple records
Replies: 6
Views: 1209

Doesn't matter what the actual values are. I'm sure A,B,C,D was just an example. You can hard code any string value such as "ItemNo,ItemClass,PkgType,PkgQty" Unfortunately in this case it will require 83 comma-delimited fields. On the up side, it will only need to be constructed once. Copy...
by ray.wurlod
Sat Oct 21, 2006 4:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link Collector job continues to run
Replies: 14
Views: 4019

Probably something missed updating the status file in the repository. This is one of those cases where Clear Status File (from Director) might be indicated.
by ray.wurlod
Sat Oct 21, 2006 4:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Job 222 Phantom 20314
Replies: 3
Views: 1006

It's not an error, it's a warning. DataStage alerts you to any unusual event via a message with warning severity. This event is unusual; you needed to know that you didn't have a hashed file called SDKSequences and now you do (in case, for example, you micromanage your disk space).
by ray.wurlod
Sat Oct 21, 2006 4:42 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: regarding connection to profile stage
Replies: 9
Views: 4766

Did you create a user DSN or a system DSN? User DSNs are not selected by the client software.
by ray.wurlod
Sat Oct 21, 2006 7:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read DataSet file name patterns
Replies: 8
Views: 1936

I misunderstood - I thought you wanted to read "a bunch of files" as if it were a Data Set. Now I understand that you want to read "a bunch of Data Sets". This is not possible, and kinda defeats the purpose of Data Set, which is already a parallel structure. Why not simply append all sources to a si...
by ray.wurlod
Sat Oct 21, 2006 7:33 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: regarding connection to profile stage
Replies: 9
Views: 4766

What error message (precisely) is logged?
by ray.wurlod
Fri Oct 20, 2006 8:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting a single record into multiple records
Replies: 6
Views: 1209

:idea: Generate a new column containing the column names (destined for COL_NAME) as a constant using a Cycle Generator with just one value.
by ray.wurlod
Fri Oct 20, 2006 8:32 pm
Forum: IBM QualityStage
Topic: QualityStage Certification
Replies: 0
Views: 896

QualityStage Certification

Has anyone attempted the test (Test #416)? If so, please post your impressions of it.
by ray.wurlod
Fri Oct 20, 2006 2:48 pm
Forum: IBM QualityStage
Topic: Caching problem in QualityStage
Replies: 3
Views: 1262

Could the latency be in your checking tool (UltraEdit?) left open?

If not, it's probably time to involve your system administrator and your support provider.
by ray.wurlod
Fri Oct 20, 2006 2:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Read DataSet file name patterns
Replies: 8
Views: 1936

Well it wouldn't be a Data Set (which uses internal, binary, forms for numeric data), but it might be a File Set. You can craft a File Set control file containing the pathnames of the actual files (which require identical record structure, and probably no "first line is column names") and a record s...
by ray.wurlod
Fri Oct 20, 2006 2:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error in Data conversion
Replies: 7
Views: 2766

It's generated because Oracle does not have a true INTEGER data type, and converted your INTEGER specification in CREATE TABLE to NUMBER(38) or - in your particular case - because the default size of NUMBER is 38. But your job design takes this and tries to import it into an int32 (specified in your...
by ray.wurlod
Fri Oct 20, 2006 2:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Version Control Batch
Replies: 6
Views: 1576

Version Control is not supported - and does not work - at version 8.0. This is because it interacts with the old style repository. IBM is investigating alternatives, including interaction with utilities such as ClearCase.