Search found 53125 matches

by ray.wurlod
Thu Feb 18, 2010 5:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server Batch Job aborting in DS 8.1
Replies: 2
Views: 1396

Moderator: please move to Server forum
by ray.wurlod
Thu Feb 18, 2010 5:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Checking data
Replies: 2
Views: 1021

Make sure that every load has a unique RunID which is part of every row loaded into the database.
by ray.wurlod
Thu Feb 18, 2010 5:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to update the job version number automatically
Replies: 6
Views: 3685

DataStage had Version Control until version 7.5.

Information Server Manager in a near future release will be able to interact with source code control systems - directly with ClearCase and CVS, through an interface (API or Eclipse plug-in) to others.
by ray.wurlod
Thu Feb 18, 2010 5:33 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: An insight to PX transformer
Replies: 1
Views: 872

Transformer stage code ends up being a callable object or callable function in a library (depending on how you link it). Its stage properties dialog has a Build tab where you can override the default compile and link options. The Build stage is the same, in that it generates callable objects. That's...
by ray.wurlod
Thu Feb 18, 2010 5:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server Batch Job aborting in DS 8.1
Replies: 2
Views: 1396

Please post all preceding warning/fatal messages. The one you posted is an automatic reaction to an earlier abort condition having been detected.
by ray.wurlod
Thu Feb 18, 2010 5:29 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: substring between two (different) delimiters...
Replies: 12
Views: 3013

Pairs of Field() function for the first case, a single Field() function for the URL.

Code: Select all

Field(Field(InLink.TheString, ":", 1, 1), "_", 2, 1)

Code: Select all

Field(InLink.URL, "/", 3, 1)
by ray.wurlod
Thu Feb 18, 2010 5:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ADMINISTRATOR Problem Project Permissions
Replies: 1
Views: 1099

The Administrator is any user in the Administrators group, if the DataStage server is on Windows, or the user dsadm, if the DataStage server is on UNIX/Linux. If you tell us what's disabled we may be able to be of more help. For example, NLS is disabled if NLS is not installed or if NLS is installed...
by ray.wurlod
Thu Feb 18, 2010 2:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read &PH& on UNIX
Replies: 5
Views: 2661

Yes, parallel jobs too.

DSD.RUN is a generic "job starting" routine that also appears for parallel jobs.

Beware that ampersand is a special character for the shell. You need to escape or hard quote. For example:

Code: Select all

cd MyProject
ls -alrt '&PH&

Code: Select all

cd MyProject
ls -alrt \&PH\
by ray.wurlod
Thu Feb 18, 2010 12:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conductor Node - Section Leader
Replies: 10
Views: 11853

Take node1 out of the default node pool (the one with "" as its name) - go back, perhaps, to naming a "conductor" node pool. This will push all processing onto node 2. To allow a controlled amount of processing to occur on node 1, design some (only a few) stage types to execute i...
by ray.wurlod
Wed Feb 17, 2010 7:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conductor Node - Section Leader
Replies: 10
Views: 11853

You're failing to mention server1 in your configuration file. I believe (from your description) that you intended to name server1 as the fastname for node1 but named server2 instead.
by ray.wurlod
Wed Feb 17, 2010 7:54 pm
Forum: General
Topic: switch stage, case expressions
Replies: 1
Views: 1040

There's no "otherwise" capability in the Switch stage. However, there's nothing special about a reject link except that you can't work with the Mappings (and it causes a message to be logged if it's used). You can set the If Not Found property to Output and direct these rows to the reject ...
by ray.wurlod
Wed Feb 17, 2010 1:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Any limitation on size when using Iconv and Oconv with "
Replies: 29
Views: 7641

Who told you that? It's unlikely. Changing EXACTNUMERIC ought not to affect applications catastrophically - it may give more significant digits as the result of calculations, but the target data type (precision,scale) should account for tidying that up. Other parameters in uvconfig being inadvisedly...
by ray.wurlod
Wed Feb 17, 2010 1:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CDC Warning
Replies: 7
Views: 4590

Do you have Runtime Column Propagation enabled? If you don't need it, disable it.
by ray.wurlod
Wed Feb 17, 2010 1:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Copybook to DataStage schema file
Replies: 4
Views: 9285

Import the COBOL copybook into DataStage. Then open the table definition, go to the Layout tab, open the Parallel option and (right click to) save the record schema in a file. Voila!
by ray.wurlod
Wed Feb 17, 2010 1:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: APT_CombinedOperatorController,0: [NCR][ODBC Teradata Driver
Replies: 7
Views: 2932

Could have lacked SELECT privilege to system tables where column information is stored.