[U2] Unidata/SBClient/SBServer Pricing - USA
Group, I'm looking for ballpark pricing for the following Unidata/SB setup for development. I used to deal with IBM directly not a var. I prefer this arrangement but it's not mandatory. I have lost all my US IBM contacts over the last 2 years. What I need is pricing for the following: 5-User Development license for Unidata 7.x for Windows Development License for SBServer or whatever the most current incarnication is. I know there was talk about making SB a .Net component(s). 1-5 SBClient licenses (if the .Net components aren't production ready). Plus Annual support/maintenance for the above. Please feel free to contact me OFFLINE as I don't want to make your pricing info public. =) Thanks, Don Verhagen (donrem...@thissoutheast-florida.com) (please make sure to remove the rem...@this from the email address). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects/socket idle time?
We are trying to see at any one moment how many ACTIVE connections we have into the database. We are looking at connection pooling and are trying to get a ballpark figure of how many connections we have into the database at any one time. I know this will not be a end all be all number but we are just looking for a rough idea. I can count the socket connection(s) but what we are trying to see is how many of these connections are actually accessing the database. Dougc -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Friday, August 07, 2009 2:57 PM To: U2 Users List Subject: Re: [U2] uniobjects/socket idle time? Doug, Can I ask what you ultimate goal is? Thanks, Jeff Doug Chanco wrote: > Hey all, > >Is anyone aware of a way to see how long a uniobjects connection has > been idle? I know that after "x" time the socket connection will close > but until that moment I assume the connection is idle and I am trying to > find a way to "look through" our uniobjects connections and figure out > at any one moment how many are actually doing something. > > > > Any thoughts/suggestions/ideas are welcomed! > > > > Thanks > > > > Dougc > > > > Aix 6.1.2 > > Universe 10.2.x > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- This message has been scanned for viruses and dangerous content by SecureMail, and is believed to be clean. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects/socket idle time?
Doug, Can I ask what you ultimate goal is? Thanks, Jeff Doug Chanco wrote: Hey all, Is anyone aware of a way to see how long a uniobjects connection has been idle? I know that after "x" time the socket connection will close but until that moment I assume the connection is idle and I am trying to find a way to "look through" our uniobjects connections and figure out at any one moment how many are actually doing something. Any thoughts/suggestions/ideas are welcomed! Thanks Dougc Aix 6.1.2 Universe 10.2.x ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] xml mapping file question
Thank you for posting your solution. I mainly do XML from within a program too.
> Date: Fri, 7 Aug 2009 13:36:45 -0400
> From: normanba...@gmail.com
> To: u2-users@listserver.u2ug.org
> Subject: Re: [U2] xml mapping file question
>
> So here is how I did it.
>
> To recap. I wanted to include the xsl-stylesheet in the xml document
> that is produced by XMLExecute(). Below is the code that produced the
> desired result.
>
>
> PROGRAM STDCSTXML
> $OPTIONS INFORMATION
> $INCLUDE UNIVERSE.INCLUDE XML.H
>
>
> ;* CMD is the paragraph that we want to run
> ;* OPTIONS are the paramters that you would normally pass to TOXML
> CMD = "SORT STOCKFILE WITH QTY GT 0 DESC UM STATDESC QTY STD.CST
> TOTAL TOTCST"
> OPTIONS = "ELEMENTS"
> STATUS = XMLExecute(CMD,OPTIONS,XML.VAR,XSD.VAR) ;* XML.VAR
> holds the variable that we'll use to create a dynamic array (DA)
> PARSE = XML.VAR ;* PARSE is now the DA
>
> PARSE = CONVERT('>',@VM,PARSE) ;* Use CONVERT function to
> convert all ending '>' in each XML elemetn to Value Marks
>
> LOCATE '?' IN PARSE<1,1> SETTING X ELSE ;* dimension the DA and
> find the first ? in the DA
> ;* Insert the new XML stylesheet element into the DA
> PARSE = INSERT(PARSE,1,2,0,' href="http://cicnet.celestecorp.com/cms/xml/xslt/cilstdcst.xsl";?')
> END
> PARSE = CONVERT(@VM,'>',PARSE) ;* convert the VM's back to '>'
> OPEN '','XMLREPORTS' TO FILE THEN ;* Open the folder and write to it.
> WRITE PARSE TO FILE, 'stdcst.xml'
> END
> END ;*Rinse, repeat, =)
>
>
>
> I'll also add that I created the file called XMLREPORTS as a Type 19,
> then edited the voc record for XMLREPORTS to actually point to a
> shared folder on our Intranet web server.
>
> This works flawlessly for me and I hope that it may also help someone
> else in the future. Oh and management loves it and is now wanting to
> do this for a lot of general purpose reports.
>
> Enjoy,
> Norm
> ___
> U2-Users mailing list
> U2-Users@listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
_
Express your personality in color! Preview and select themes for Hotmail®.
http://www.windowslive-hotmail.com/LearnMore/personalize.aspx?ocid=PID23391::T:WLMTAGL:ON:WL:en-US:WM_HYGN_express:082009
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] xml mapping file question
So here is how I did it.
To recap. I wanted to include the xsl-stylesheet in the xml document
that is produced by XMLExecute(). Below is the code that produced the
desired result.
PROGRAM STDCSTXML
$OPTIONS INFORMATION
$INCLUDE UNIVERSE.INCLUDE XML.H
;* CMD is the paragraph that we want to run
;* OPTIONS are the paramters that you would normally pass to TOXML
CMD = "SORT STOCKFILE WITH QTY GT 0 DESC UM STATDESC QTY STD.CST
TOTAL TOTCST"
OPTIONS = "ELEMENTS"
STATUS = XMLExecute(CMD,OPTIONS,XML.VAR,XSD.VAR) ;* XML.VAR
holds the variable that we'll use to create a dynamic array (DA)
PARSE = XML.VAR ;* PARSE is now the DA
PARSE = CONVERT('>',@VM,PARSE);* Use CONVERT function to
convert all ending '>' in each XML elemetn to Value Marks
LOCATE '?' IN PARSE<1,1> SETTING X ELSE ;* dimension the DA and
find the first ? in the DA
;* Insert the new XML stylesheet element into the DA
PARSE = INSERT(PARSE,1,2,0,'http://cicnet.celestecorp.com/cms/xml/xslt/cilstdcst.xsl";?')
END
PARSE = CONVERT(@VM,'>',PARSE) ;* convert the VM's back to '>'
OPEN '','XMLREPORTS' TO FILE THEN ;* Open the folder and write to it.
WRITE PARSE TO FILE, 'stdcst.xml'
END
END ;*Rinse, repeat, =)
I'll also add that I created the file called XMLREPORTS as a Type 19,
then edited the voc record for XMLREPORTS to actually point to a
shared folder on our Intranet web server.
This works flawlessly for me and I hope that it may also help someone
else in the future. Oh and management loves it and is now wanting to
do this for a lot of general purpose reports.
Enjoy,
Norm
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects/socket idle time?
And I usually read a known voc entry to reset its idle time out to keep it awake. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Friday, August 07, 2009 12:09 PM To: 'U2 Users List' Subject: Re: [U2] uniobjects/socket idle time? Doug, I have a single entry point for UniObjects and it records a Date/Time of last accessed. Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Chanco Sent: Friday, August 07, 2009 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] uniobjects/socket idle time? Hey all, Is anyone aware of a way to see how long a uniobjects connection has been idle? I know that after "x" time the socket connection will close but until that moment I assume the connection is idle and I am trying to find a way to "look through" our uniobjects connections and figure out at any one moment how many are actually doing something. Any thoughts/suggestions/ideas are welcomed! Thanks Dougc Aix 6.1.2 Universe 10.2.x ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects/socket idle time?
Doug, I have a single entry point for UniObjects and it records a Date/Time of last accessed. Thanks, David A. Green www.dagconsulting.com (480) 813-1725 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Chanco Sent: Friday, August 07, 2009 7:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] uniobjects/socket idle time? Hey all, Is anyone aware of a way to see how long a uniobjects connection has been idle? I know that after "x" time the socket connection will close but until that moment I assume the connection is idle and I am trying to find a way to "look through" our uniobjects connections and figure out at any one moment how many are actually doing something. Any thoughts/suggestions/ideas are welcomed! Thanks Dougc Aix 6.1.2 Universe 10.2.x ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] uniobjects/socket idle time?
Hey all, Is anyone aware of a way to see how long a uniobjects connection has been idle? I know that after "x" time the socket connection will close but until that moment I assume the connection is idle and I am trying to find a way to "look through" our uniobjects connections and figure out at any one moment how many are actually doing something. Any thoughts/suggestions/ideas are welcomed! Thanks Dougc Aix 6.1.2 Universe 10.2.x ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
