Search found 6797 matches

by DSguru2B
Mon Mar 05, 2007 3:04 pm
Forum: Site/Forum
Topic: "kumar_s" hits 4000 !!!
Replies: 15
Views: 7622

Ouch, I fixed it :oops:
by DSguru2B
Mon Mar 05, 2007 2:40 pm
Forum: IBM QualityStage
Topic: QualityStage equivalent of DCount function
Replies: 7
Views: 3068

Since your sitting on Unix, write a small awk script to do it. It will be the easiest for the business folks.
by DSguru2B
Mon Mar 05, 2007 1:46 pm
Forum: Enhancement Wish List
Topic: up the 99 project limit... and more
Replies: 27
Views: 11104

Well one of our very senior guys doubts there is a limit. Get in touch with support and see what they have to say.
by DSguru2B
Mon Mar 05, 2007 1:40 pm
Forum: Enhancement Wish List
Topic: up the 99 project limit... and more
Replies: 27
Views: 11104

I checked the DS_LICENSE table. Nothing in there as well other than the LIMIT you are mentioning.
by DSguru2B
Mon Mar 05, 2007 1:36 pm
Forum: Site/Forum
Topic: "kumar_s" hits 4000 !!!
Replies: 15
Views: 7622

"kumar_s" hits 4000 !!!

Congratulations Kumar. Its my honor to be the first to congratulate you in achieving this milestone. Keep 'em coming :wink:
by DSguru2B
Mon Mar 05, 2007 1:33 pm
Forum: Enhancement Wish List
Topic: up the 99 project limit... and more
Replies: 27
Views: 11104

What error are you getting when you try to create the 100th project?
by DSguru2B
Mon Mar 05, 2007 1:29 pm
Forum: Enhancement Wish List
Topic: up the 99 project limit... and more
Replies: 27
Views: 11104

Thats the User Limit Craig.
by DSguru2B
Mon Mar 05, 2007 1:15 pm
Forum: General
Topic: Difference btw Charter and Premium Membership
Replies: 6
Views: 1616

Thats a Walter question. Shoot an email to the editor. His id is 'whardeman'.
by DSguru2B
Mon Mar 05, 2007 1:14 pm
Forum: General
Topic: Median Calculation
Replies: 36
Views: 10179

Odd verses even is being handled in my code. Did not worry about tied values. I was just curious in getting the code written. These are add on's. Can be incorporated.
by DSguru2B
Mon Mar 05, 2007 12:56 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to update the source table in the same job?
Replies: 17
Views: 4907

Very funny Ray, 2B a bionic number. :wink:
by DSguru2B
Mon Mar 05, 2007 12:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Run MERGE sql in Oracle Enterprise Stage
Replies: 9
Views: 3428

Execute dsenv in $DSHOME. That should set up your ORACLE_HOME.
by DSguru2B
Mon Mar 05, 2007 12:46 pm
Forum: General
Topic: Median Calculation
Replies: 36
Views: 10179

Great. Thanks Ray. I was literally breaking my head going through my archives and BASIC manual to come up with a function to sort an array. Your code can be incorporated into mine. This way I dont have to build a hashed file just to get sorted data.
by DSguru2B
Mon Mar 05, 2007 12:43 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DataStage Client on Windows Vista
Replies: 1
Views: 774

Check this postout.
by DSguru2B
Mon Mar 05, 2007 12:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Run MERGE sql in Oracle Enterprise Stage
Replies: 9
Views: 3428

Ken has a very valid point. Get your command line sql working and run your query from command line as an after job subroutine 'ExecSh'
by DSguru2B
Mon Mar 05, 2007 12:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Run MERGE sql in Oracle Enterprise Stage
Replies: 9
Views: 3428

It should work. Does your sql run as expected from sqlplus or your favourite sql tool?