Search found 53125 matches

by ray.wurlod
Mon Oct 15, 2007 4:31 pm
Forum: General
Topic: Oracle Stored proc thru ODBC Stage
Replies: 4
Views: 1375

Welcome aboard.

Have you imported the stored procedure definition (under the Import menu in Designer)?

Having done so you will be able to determine the number of columns that the stored procedure expects to process.
by ray.wurlod
Mon Oct 15, 2007 4:29 pm
Forum: General
Topic: Information Server
Replies: 2
Views: 1442

There is no WebSphere Data Analyzer. There is, however, Information Analyzer, which contains functionality from both ProfileStage and the investigation capabilities of QualityStage, and in future will contain some of the pattern analysis capabilities of QualityStage and some of the business rule com...
by ray.wurlod
Mon Oct 15, 2007 4:25 pm
Forum: General
Topic: Set Job parameters using unix script
Replies: 10
Views: 2390

The way that job parameters are set for parallel jobs (ultimately via a call to DSSetParam() function) is identical to the way the job parameters are set for server jobs and job sequences.
by ray.wurlod
Mon Oct 15, 2007 8:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: convert datastage 7.0 code to datastage 7.5 / 8.1
Replies: 3
Views: 1779

Yes, it's part of the standard manuals set. Title, if I remember correctly, is Installation and Upgrade Guide
by ray.wurlod
Mon Oct 15, 2007 8:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Title Case in Parallel
Replies: 6
Views: 5235

Arnd meant "MCT", or you could use the CAPITALS Transform (which does the same thing), in a BASIC Transformer stage.
by ray.wurlod
Sun Oct 14, 2007 10:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DRS Stage- Environmenta Variable
Replies: 10
Views: 4877

Does this connection string include a correct reference to an entry in the tnsnames.ora file?
by ray.wurlod
Sun Oct 14, 2007 10:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequential:50 out of 200
Replies: 8
Views: 1420

If it's in sequential mode use a Filter command that invokes the head command. Otherwise use a downstream Head stage.
by ray.wurlod
Sun Oct 14, 2007 10:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ACRONYM OF APT
Replies: 3
Views: 1199

The plural of "guy" is spelled with an "s". The word "wat" refers to a Buddhist temple. Please use professional writing DSXchange; English is not everyone's first language, so that strangely-abbreviated forms makes their task of comprehension even more difficult.
by ray.wurlod
Sun Oct 14, 2007 10:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: concatenate two fields (dont use a transformer)
Replies: 10
Views: 5294

You must use a Transformer stage unless you can perform the required concatentaion at source (during extraction). Modify stage functions can only be applied to a single input argument, which automatically rules out that stage type. Your only other alternative is to create some kind of custom stage. ...
by ray.wurlod
Sun Oct 14, 2007 10:31 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: SQL SERVER - Character missing in Datasatge
Replies: 5
Views: 1977

The default value of MAXFETCHBUFF is 8192 (bytes). I am not aware of any limit. However, if characters are being truncated from multiple fields, it is not MAXFETCHBUFF that is at fault. Can you enable ODBC tracing, and determine what SQL is being sent to the database server and what data are being s...
by ray.wurlod
Sun Oct 14, 2007 8:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT
Replies: 1
Views: 1113

Applied Parallel Technologies.

Before Torrent Systems called themselves that, the business name (and, perhaps, the product name) was Applied Parallel Technologies.
by ray.wurlod
Sun Oct 14, 2007 8:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: problem with load command while online backups running
Replies: 3
Views: 1237

You ask the DataBase Administrator. Some kind of inducement is often good, too.