DSXchange

Ouch, I fixed it

Since your sitting on Unix, write a small awk script to do it. It will be the easiest for the business folks.

Well one of our very senior guys doubts there is a limit. Get in touch with support and see what they have to say.

I checked the DS_LICENSE table. Nothing in there as well other than the LIMIT you are mentioning.

Congratulations Kumar. Its my honor to be the first to congratulate you in achieving this milestone. Keep 'em coming

What error are you getting when you try to create the 100th project?

Thats the User Limit Craig.

Thats a Walter question. Shoot an email to the editor. His id is 'whardeman'.

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.

Very funny Ray, 2B a bionic number.

Execute dsenv in $DSHOME. That should set up your ORACLE_HOME.

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.

Check this postout.

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'

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