Search found 357 matches

by richdhan
Thu Apr 13, 2006 2:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DataStage Client Slow response
Replies: 17
Views: 12796

Hi Rob,

We access DataStage 7.1 client components using Citrix Metaframe XP.

The performance is very good.

HTH
--Rich
by richdhan
Wed Apr 12, 2006 3:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Nullable warning
Replies: 16
Views: 6983

Hi Somu,

What is the data type of the 2 columns. If it is varchar then you have to specify the null field value as ' '.

HTH
--Rich
by richdhan
Wed Apr 12, 2006 3:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Modify stage
Replies: 4
Views: 1233

Hi Seanc,

You cannot have 2 orchestrate functions in a single specification. You probably have to use the Transformer in this case.

HTH
--Rich
by richdhan
Wed Apr 12, 2006 3:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error executing a Parallel routine
Replies: 5
Views: 2246

Hi,

Did you do a search. We had a discussion few days back.

Check if this helps.

HTH
--Rich
by richdhan
Tue Apr 11, 2006 4:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to retrieve the source file name dynamically
Replies: 7
Views: 3571

Hi Hadi,

A Job Sequence is a server kind of job and is capable of running both server and parallel jobs as job activities.

Yes you can execute the server routine using the routine activity.

Activities are nothing but stages in the Sequence Job

HTH
--Rich
by richdhan
Tue Apr 11, 2006 4:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: sap r/3 pack and mySAP
Replies: 1
Views: 569

Hi,

Have you registered with Ascential Developernet.

There are some downloads such as this one.

Maximize_Ascential_for_SAP_09_08_2004.zip

There are also some white papers here.

http://www.ascential.com/litlib/index.html

HTH
--Rich
by richdhan
Tue Apr 11, 2006 4:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Executing Stored Procedure
Replies: 5
Views: 2193

Hi Raj,

Did a web search and this is what I found.

http://www-128.ibm.com/developerworks/f ... 298&cat=19

HTH
--Rich
by richdhan
Tue Apr 11, 2006 12:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup Condition not correct
Replies: 6
Views: 2504

Hi Sam, By default the previous stages would have a setting of propogating the existing partition to the following stages. But you would have defined a new partitioning for the following stage. So DataStage gives a warning stating that the existing partiton cannot be preserved and rather the new par...
by richdhan
Sat Mar 25, 2006 1:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is there any bug in Join stage
Replies: 8
Views: 2808

Hi,

Are you doing some kind of partitioning in the input?

Are you using the configuration file with multiple nodes for running this job?

--Rich
by richdhan
Wed Mar 08, 2006 6:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job with transformer giving problem
Replies: 6
Views: 1933

Hi Kumar, One fine day the environment had some changes and we had the same kind of library problems that legendkiller has. We compiled the job 'n' number of times but in vain. Nothing happened. Then we were advised to do a force compile. After we did the force compile the job ran normally as it sho...
by richdhan
Mon Mar 06, 2006 6:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job with transformer giving problem
Replies: 6
Views: 1933

Hi legendkiller,

Do a Force Compile and then run the job. If the problem still persists do as advised by Arnd.

HTH
--Rich
by richdhan
Mon Mar 06, 2006 6:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal Error: (nullFieldEntry) in Transformer
Replies: 5
Views: 4676

Hi Yogesh,

Most of the time this problem occurs because of invalid derivation for stage variables or because of improper use of Environmental variables.

HTH
--Rich
by richdhan
Thu Feb 16, 2006 6:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid APT_Locator
Replies: 3
Views: 4593

Hi csimms,

Are you using the $APT_CONFIG_FILE environment variable as a job parameter? In the job parameter list move $APT_CONFIG_FILE parameter to the top of the list.

HTH
--Rich
by richdhan
Fri Feb 10, 2006 3:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to find count of nodes or processors
Replies: 2
Views: 1245

Hi,

You can view the configuration files from Datastage Manager-->Tools-->Configurations. Also you can check the job log in the Director. It gives the configuration file used, the number of datasets, the number of operators and the number of processes.

HTH
--Rich