Search found 53125 matches

by ray.wurlod
Tue Jun 17, 2008 6:35 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Extract Mainframe File
Replies: 4
Views: 1078

Complex Flat File stage.
by ray.wurlod
Tue Jun 17, 2008 4:54 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: regarding reusable components
Replies: 1
Views: 856

Every component in the Repository is reusable in some sense.
by ray.wurlod
Tue Jun 17, 2008 4:51 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: dsjob command not working
Replies: 13
Views: 4568

Welcome aboard. As a general rule we can not do anything useful with "not working" - it's too vague. We need to see the precise error messages that are generated.
by ray.wurlod
Tue Jun 17, 2008 4:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Join to Hash File
Replies: 9
Views: 2680

You can join hashed files using a UniVerse stage. This will require that VOC pointers exist to the hashed files, and that a suitable set of join columns (one or more) exists in each hashed file.
by ray.wurlod
Tue Jun 17, 2008 4:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Code in derivation VS routine call
Replies: 3
Views: 1079

To summarize:
Transforms become inline code.
Routines do not become inline code but are called at run time.
by ray.wurlod
Tue Jun 17, 2008 4:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hashed file
Replies: 7
Views: 1537

It is axiomatic that you ought to have no control over physical storage of any individual record; this is a function of the database server so that it can retrieve that record efficiently. Hashed files implement database tables in a number of database products, including UniVerse and UniData, and us...
by ray.wurlod
Tue Jun 17, 2008 4:40 pm
Forum: General
Topic: Industry info for standard size of a DataStage Admin Team?
Replies: 2
Views: 933

How much ongoing development is taking place? Do the developers overlap other duties, or are they separate?
by ray.wurlod
Tue Jun 17, 2008 4:36 pm
Forum: General
Topic: Datastage Installation in laptop
Replies: 15
Views: 5968

If this is Windows XP then you may need a loopback adapter (as advised earlier) or to be connected to some device that can serve you an IP address.
by ray.wurlod
Tue Jun 17, 2008 12:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error with DSJOB command
Replies: 8
Views: 2775

There is no job parameter named ACT_L00_TRG in the job called jobname.
by ray.wurlod
Tue Jun 17, 2008 12:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we use User-defined server routines in parallel jobs
Replies: 9
Views: 2632

The fault may be in the Routine code. Does it return its input argument unchanged? Is the Ans variable assigned a value? How are you calling the routine from the BASIC Transformer stage? In particular are you using the Expression Editor to create your expressions?
by ray.wurlod
Tue Jun 17, 2008 12:22 am
Forum: IBM QualityStage
Topic: QStage server INVp.FRQ,INVp.SRT,Inv.pat is not generated
Replies: 1
Views: 835

In the job list on the left of QS Designer you should be able to right click on the job and choose "view report files" from the menu.

Can you please post exact error messages? Interpreted error messages can lead to huge amounts of time being wasted.
by ray.wurlod
Mon Jun 16, 2008 11:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we use User-defined server routines in parallel jobs
Replies: 9
Views: 2632

If the routines are of type "transform function" then yes.
If the routines are of type "before/after subroutine" then no, you can not use these from a BASIC Transformer stage expression.
by ray.wurlod
Mon Jun 16, 2008 11:11 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Sort
Replies: 1
Views: 1861

Please post this question in the server job forum. It is not related to SOA Edition.
by ray.wurlod
Mon Jun 16, 2008 11:10 pm
Forum: IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
Topic: Hashed file
Replies: 1
Views: 1875

Please post this question in the server job forum. It is unrelated to SOA Edition.
by ray.wurlod
Mon Jun 16, 2008 11:09 pm
Forum: IBM QualityStage
Topic: Error mkproj:C:/Ascential/QSServer75/script_mkpro not found
Replies: 3
Views: 1318

Can you please mark this thread as Resolved?