Search found 95 matches

by chanaka
Tue Jan 04, 2011 5:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: issue with file read
Replies: 1
Views: 2052

Looks like you some of your input fields are having CR & LF characters. You can use a routine on that field to strip of unwanted characters in hte case business users are okay with that.
by chanaka
Wed Dec 29, 2010 8:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: call to function SQLConnect failed.
Replies: 2
Views: 4650

Re: call to function SQLConnect failed.

Hi Ravi,

Please check the $DSHOME/.odbc.ini and confirm that the ODBC DSN entries are pointing to the proper path based on your new DS upgrade path.
by chanaka
Wed Dec 29, 2010 8:25 am
Forum: General
Topic: Ports used for BW.
Replies: 6
Views: 4503

I just checked my /etc/hosts file and it is defined in that range only. Can someone else confirm?
by chanaka
Mon Dec 20, 2010 11:01 am
Forum: General
Topic: Supported Releases and Operating Systems
Replies: 4
Views: 2249

Re: Supported Releases and Operating Systems

Which version of the IBM Infosphere product you are planning to install?

Cheers!

Chanaka
by chanaka
Mon Dec 20, 2010 10:55 am
Forum: General
Topic: Ports used for BW.
Replies: 6
Views: 4503

Re: Ports used for BW.

Hi Abhijit,

As I recall it is tcp ports in the range 3300 to 4900.

Cheers!

Chanaka
by chanaka
Wed Dec 08, 2010 6:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Question on PX lookup
Replies: 3
Views: 2360

Question on PX lookup

Hi All, I know this is a simple question. However I hear different answers from different people and I dont know whats the truth. Consider the following scenario in a PX job. Job reads field A(char 6) from table X. In a lookup stage input link it is reading fields B & C where C is of VARCHAR 120...
by chanaka
Mon Nov 15, 2010 1:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Standard on number of reference links per Lookup stage
Replies: 1
Views: 1385

Standard on number of reference links per Lookup stage

Hi Team,

Is there any known standard on number of reference links per Lookup stage? This just for my knowledge.

Cheers!

Chanaka
by chanaka
Mon Nov 15, 2010 1:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Open source DSN creation
Replies: 2
Views: 3397

Re: Open source DSN creation

What is the database type?
by chanaka
Thu Dec 03, 2009 2:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS warnings after migration
Replies: 0
Views: 1087

NLS warnings after migration

Hi Friends, Earlier we had some jobs running DS 7.5.2 windows that processes multibyte character set data and those were executed successfully without any warnings with the default MS 1252 character set. After importing the same jobs into the DS 8.1 RHEL 5.3 64 bit environment we are getting warning...
by chanaka
Thu Nov 26, 2009 6:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installation Problems V8.0
Replies: 3
Views: 2058

First you have to map the logical user name created on WAS domain on port 9080 to relevant DataStage physical user. After doing that only you will be able to login to the DS Administrator.
by chanaka
Thu Nov 26, 2009 6:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to get file from another Server
Replies: 22
Views: 9171

If not use a simple java code given in the below page to split it. and use the sequential file stage in wild card mode to perform your task.

http://www.go4expert.com/forums/showthread.php?t=236
by chanaka
Thu Nov 26, 2009 6:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to get file from another Server
Replies: 22
Views: 9171

Check with your SA whether you have Large File support enabled.

http://publib.boulder.ibm.com/infocente ... tune35.htm
by chanaka
Thu Nov 26, 2009 5:37 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to get file from another Server
Replies: 22
Views: 9171

you need to do it using a DS job? or an alternative way?
by chanaka
Thu Nov 26, 2009 4:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Need to get file from another Server
Replies: 22
Views: 9171

What is the source system OS & the DS server OS. How big is the file? Do you need to do this repeatedly?

Cheers!
by chanaka
Thu Nov 26, 2009 4:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installation Problems V8.0
Replies: 3
Views: 2058

As I remember you need to upgrade the projects from DS Administrator. Can you see that the Upgrade button is available on DS Administrator?

Cheers!