Search found 53125 matches

by ray.wurlod
Wed Feb 28, 2007 3:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: import external function fails
Replies: 4
Views: 1590

Probably that they lack input arguments. External functions are expected to act as transform functions - to take one or more arguments, effect a transform and to return a result.
by ray.wurlod
Wed Feb 28, 2007 3:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error in writing to named pipes (in Sequential File stage)
Replies: 2
Views: 1164

Try to use fewer named pipes simultaneously system wide.
by ray.wurlod
Wed Feb 28, 2007 3:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Performance when using ODBC stage
Replies: 14
Views: 4153

Can you try the same SELECT statement using a Sybase OC stage?
by ray.wurlod
Wed Feb 28, 2007 3:19 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: datastage warning
Replies: 2
Views: 979

It means that server side tracing is enabled, which slows everything by about 10% and records trace files in the &COMO& subdirectory in the project. Check with your administrator whether it should be ON - maybe something is being diagnosed. Server side tracing can be enabled/disabled in the ...
by ray.wurlod
Wed Feb 28, 2007 3:17 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Universe Stage - [RPC] error code = 81002 - Timeout ?
Replies: 9
Views: 5647

Question 1. Is there a UniVerse account on BAMBI called DS?

Question 2. Is there a file/table in this account called FE.FERRYY000? In particular, is this the name in the account's VOC file? It looks like LONGNAMES might be OFF in this account.
by ray.wurlod
Wed Feb 28, 2007 3:14 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Varchar issues..
Replies: 7
Views: 1834

How do you propose to source "(whatever the size of the target field is)"?
by ray.wurlod
Wed Feb 28, 2007 3:10 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: RPC daemon
Replies: 7
Views: 2135

Try clicking on the Omit check box, as a workaround.

Can you telnet to the server (which uses port #23 rather than port #31538)?
by ray.wurlod
Wed Feb 28, 2007 3:09 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to find EOF using DataStage
Replies: 9
Views: 5525

Not a good solution, because the file variable that you SEEK to eof only has scope within the routine. The OP's requirement was to "find" eof (whatever that means - I have no idea). You could get the size of the file (from DIR) and use that, I guess, as the address of EOF. But what purpose will it s...
by ray.wurlod
Wed Feb 28, 2007 3:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Ended jobs with 'Finishing' status..
Replies: 2
Views: 894

A long-running after-job subroutine can cause this effect. An after-job subroutine with an infinite loop will cause the Finishing state to remain indefinitely (infinitely).
by ray.wurlod
Wed Feb 28, 2007 3:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Securing Production components
Replies: 4
Views: 1470

There is to be an interface between DataStage and ClearCase (both owned by IBM) in approximately version 8.2 of DataStage. In the meantime, your methodolgy will need to be to use DataStage export files as the "source code" to be registered in Clear Case, and management control to ensure that folks c...
by ray.wurlod
Wed Feb 28, 2007 2:58 pm
Forum: General
Topic: Reading a sequential file from an EE job into a server job
Replies: 16
Views: 4777

What stage type did you use to write the sequential file in the Parallel job?

Try changing the format of the file so that it uses UNIX-style record delimiter. No record delimiter is contra-indicated if the data are variable length and/or delimited format.
by ray.wurlod
Wed Feb 28, 2007 2:56 pm
Forum: General
Topic: Import Project from Project Directory
Replies: 10
Views: 2938

It's probably not that simple. You may need to update the schema name in the copied project using VERIFY.SQL and to rebuild the indexing on the Repository using DS.REINDEX. But do let us know whether it runs.
by ray.wurlod
Wed Feb 28, 2007 2:54 pm
Forum: General
Topic: Pls Explain about "Orchestrate Architecture" Data
Replies: 3
Views: 1615

You will learn about the Orchestrate architecture if you enrol on IBM's class DX434 (Introduction to Enterprise Edition) or on my class DataStage Fundamentals (Enterprise Edition).
by ray.wurlod
Wed Feb 28, 2007 2:47 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: No response from server testing connection
Replies: 7
Views: 4666

Can you connect using any other ODBC client, such as MS Query?
by ray.wurlod
Wed Feb 28, 2007 1:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SME
Replies: 15
Views: 4466

It's a three letter acronym. To the best of my knowledge it is not used in the Ascential suite of products.

My best guess would be Subject Matter Expert.
Or School of Mechanical Engineering.
Or Steamboat Model Engineers.
Or South Melbourne Eagles (a football team).