Search found 53125 matches

by ray.wurlod
Wed May 20, 2009 11:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Raw(varbinary) to string(varchar)
Replies: 1
Views: 1771

You can use Column Import stage to reparse the Raw data type, or you can write it into a text file.
by ray.wurlod
Wed May 20, 2009 11:50 am
Forum: General
Topic: How to report on all jobs that use a column
Replies: 5
Views: 2037

Column based impact analysis is in a future version (8.2?). It was demonstrated at IOD 2008.
by ray.wurlod
Wed May 20, 2009 11:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Requirement
Replies: 3
Views: 1113

Use a sequence with an appropriate Execute Command activity to retrieve the file name and pass it to a Job activity as a parameter value.
by ray.wurlod
Wed May 20, 2009 11:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Metadata Repository
Replies: 3
Views: 1925

Use the report-generating capabilities in Designer preserving the "intermediate XML" and grab what you want from that.
by ray.wurlod
Wed May 20, 2009 11:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Order of rows in hashed file
Replies: 3
Views: 1583

Long answer is also "no".
It's the hashing algorithm that governs on which page/group/frame any particular record resides.
As noted, the only way to get sorted data out is to sort those rows.
by ray.wurlod
Tue May 19, 2009 4:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SCD stage END_Dt column derivation
Replies: 3
Views: 2572

Make sure that the date literal is of the correct format for your job.
Try surrounding your date with quote characters.
by ray.wurlod
Tue May 19, 2009 4:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: split record
Replies: 2
Views: 1291

Probably a BuildOp.
by ray.wurlod
Tue May 19, 2009 3:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Why is Hashed File data changing randomly
Replies: 4
Views: 1707

I suspect you have these strings (separated by / in your example) as separate fields in the hashed file. Fields in hashed files are accessed by ordinal number, not by name, so your metadata in the link where you are writing to the hashed file does not correspond to the metadata in the link where you...
by ray.wurlod
Tue May 19, 2009 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can't access to server
Replies: 1
Views: 1154

Welcome aboard. You need to do some work setting up users via the Web console for Information Server. Users must be Suite Users and also have a product role (either Administrator or User) for DataStage. Then you need to use DataStage Administrator to assign DataStage roles to anyone credentialled as...
by ray.wurlod
Tue May 19, 2009 12:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Conversion of special character to normal character
Replies: 9
Views: 2083

Correct. This can only be changed (deliberately) at the TCL command line, and you would only do that if other applications were going to access the hashed file using non-UV-UTF8 character encoding. This was more important prior to version 6.0, when other UniVerse applications might have accessed dat...
by ray.wurlod
Tue May 19, 2009 12:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Restart a job
Replies: 2
Views: 1049

No. Once a stage failure causes the job to stop all virtual Data Sets (data in memory) are discarded. If you want to preserve them then you DO need intermediate storage (which implies separate job for Stage C at the very least). There *may* be something clever you could do with message queues, but y...
by ray.wurlod
Tue May 19, 2009 12:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Runnning a data stage job continiously
Replies: 8
Views: 5706

It would probably be a sequence, rather than an individual job, that runs continuously. What happens if another of the files appears while one is being processed? You have to be able to handle rapid arrival of files. Don't forget to be able to trigger the job to shut down gracefully, perhaps by chec...
by ray.wurlod
Tue May 19, 2009 12:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Conversion of special character to normal character
Replies: 9
Views: 2083

You won't. You won't see it for HASHED file stage either. That's how "they" make sure you can't change it from NONE in the GUI.
by ray.wurlod
Mon May 18, 2009 7:53 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Partitioning question
Replies: 3
Views: 1861

Join stage requires its inputs to be sorted on the join key(s).
by ray.wurlod
Mon May 18, 2009 7:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Range lookup issue
Replies: 18
Views: 5126

OK, three keys, and therefore three comparisons in the lookup SQL.

Please post the SQL statement on the reference link.