Search found 5168 matches

by kumar_s
Thu Apr 13, 2006 12:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration File Error
Replies: 10
Views: 6995

The TCP port being used for startup is 10000; the associated socket number is 3.
Was wondering with the port nunber used.
by kumar_s
Thu Apr 13, 2006 12:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trim Leading zeros
Replies: 4
Views: 6692

Use Trim to trim out the leading 0s.
You can also use Fabs or Floor or DecimalToDecimal to trim of the decimal part.
DecimalToString is used for type conversion.
by kumar_s
Thu Apr 13, 2006 12:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LookUp Error
Replies: 2
Views: 1091

Try to repopulate the lookup file set in the same configuration and rerun.
by kumar_s
Thu Apr 13, 2006 12:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Pass the Exam or Your Money Back GUARANTEED!
Replies: 1
Views: 853

Probably not for DataStage. :wink:
by kumar_s
Wed Apr 12, 2006 9:17 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Time problem
Replies: 9
Views: 1592

Why cant you read with the formate as 'Time' itself?
by kumar_s
Wed Apr 12, 2006 9:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: current itme stamp
Replies: 5
Views: 1094

TimestampToString Return the string representation of the given timestamp - from Datasetage.
by kumar_s
Wed Apr 12, 2006 9:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Getting NULL values
Replies: 3
Views: 834

And if that particular column is made to not null, then the record will be dropped.
by kumar_s
Wed Apr 12, 2006 9:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Filter and Aggregator
Replies: 5
Views: 2163

CFF stage is a passive stage. It cannot have both input and output link together.
It can have only one input link to CFF and one reject link from the CFF stage.
Perhaps you may need to use another job to read that file and aggregate it.
by kumar_s
Wed Apr 12, 2006 8:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: CoSORT
Replies: 4
Views: 1161

Perhaps you may ask the issues or doubts you have, so that you may get the answer?
by kumar_s
Wed Apr 12, 2006 8:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HAWK requirements
Replies: 6
Views: 1632

I was told, Beta 2 is for unix flavour with bit more enhancement.
by kumar_s
Wed Apr 12, 2006 8:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What's the best Stage for this scenario
Replies: 9
Views: 2125

Even if a sequence job was opened, customization should give the full list of stages available.
Make sure your server is installed with PX.
If you click on File--->New, are you able to see, Parallel jobs or only Sequence jobs.
by kumar_s
Wed Apr 12, 2006 8:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job doesn't terminate
Replies: 10
Views: 1459

As you mentioned, there is no problem when you tried loading into dataset. So no issues with the number. Also you have mentiond, that it load fine without before job subroutine.
So try to find the statement which delete some records while or after loading into table.
by kumar_s
Wed Apr 12, 2006 8:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Controller problem- need to modify UV parameters
Replies: 7
Views: 3890

Is this uvconfig file unique to a server or unique to a project in a server? Why i am asking is that only sequencers of some projects are getting aborted due to controller problem. I can find this uvconfig file in home directory of ascential. Does it mean that it is unique to server. uvconfig is un...
by kumar_s
Wed Apr 12, 2006 8:16 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What's the best Stage for this scenario
Replies: 9
Views: 2125

Is that you couldnt find all of a sudden?
Try to do a customization. Right click on the pallet and go to Custamiztion-->Custamize and select under Parallel processing.
by kumar_s
Wed Apr 12, 2006 8:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to join Header and Trailer records
Replies: 10
Views: 2421

us1aslam1us wrote:
balajisr wrote:Use Unix Cat command to merge header and trailer. Use Execsh in after job subroutine.


Can u Elaborate it little more.

Thanks
sam


cat filename1 filename2 > filename3
cat is the keyword which should be entred in Command and the rest in Parameter.