[U2] Performance query

2009-09-02 Thread Jef Lee
Can anyone shed light on which is better: SSELECT MYFILE WITH FIELD1 = RED AND FIELD2 = BLUE or SSELECT MYFILE WITH FIELD1 = RED AND WITH FIELD2 = BLUE Does it make a difference if one or both are indexed. Thanks... Jeffrey Lee Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34

Re: [U2] Performance query

2009-09-02 Thread Arie van Dam
Jeffrey, In our findings, using UV 10.1.16 and below in Pick flavor the connecting word WITH is mandatory. Only the first field found to be in an index will be used to read the index If we want both to be used we use a correlative, although that needs special care since indices are only updated

Re: [U2] Performance query

2009-09-02 Thread Ross Morrissey
If this is UV, try the two sentences with the EXPLAIN qualifier appended... SSELECT MYFILE WITH FIELD1 = RED AND FIELD2 = BLUE EXPLAIN This will tell you the strategy UV is using for the query. Thanks, Ross. On Wed, Sep 2, 2009 at 12:42 AM, Jef Lee jef@itvision.com.au wrote: Can anyone

Re: [U2] Performance query

2009-09-02 Thread Tom Whitmore
I haven't verified this, but I understand that the WITH clause acts as parenthetical statements. Therefore: SSELECT MYFILE WITH FIELD1 = RED OR FIELD1 = BLUE AND WITH FIELD2 = 4 OR FIELD2 = 6 Will result in a different selectlist than SSELECT MYFILE WITH FIELD1 = RED WITH OR FIELD1 = BLUE

[U2] callHTTP - disconnect?

2009-09-02 Thread Kevin King
I have a Unidata (6.1/AIX) program using the callHTTP API to move data out to an Apache server on a transaction by transaction basis. When the transactions get dropped into the queue slowly all is well. When the transactions get flooded in, Apache gets overwhelmed. It appears like Unidata isn't

Re: [U2] callHTTP - disconnect?

2009-09-02 Thread Glen Batchelor
I don't suppose it's keep-alives going bad? Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com

Re: [U2] callHTTP - disconnect?

2009-09-02 Thread Symeon Breen
In your apache app set the http response header 'Connection' to 'Close' -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 02 September 2009 19:07 To: U2 Users List Subject: [U2] callHTTP -

[U2] SSH Viewpoint Emulation

2009-09-02 Thread Caminiti, Marc
Does anyone have any recommendations on a SSH client that has Viewpoint Emulation? We currently use Dynamic Connect, but do not think that it has SSH. Thanks in advance marc Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread Joshua Gallant
We use AnzioWin and it fits our needs very well. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Caminiti, Marc Sent: Wednesday, September 02, 2009 4:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] SSH

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread Bob Rasmussen
You can try a free demo of AnzioWin from www.anzio.com On Wed, 2 Sep 2009, Joshua Gallant wrote: We use AnzioWin and it fits our needs very well. - Josh -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread Jon Wells
Hi Marc, I believe that Accuterm can handle that [ http://www.asent.com ]. Jon Wells At 03:14 PM 9/2/2009, you wrote: Does anyone have any recommendations on a SSH client that has Viewpoint Emulation? We currently use Dynamic Connect, but do not think that it has SSH. Thanks in advance

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread Larry Hiscock
Both AnzioWin and AnzioLite from Rasmussen Software (http://www.anzio.com) do Viewpoint and SSH. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Caminiti, Marc Sent:

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread art
Caminiti, Marc wrote: Does anyone have any recommendations on a SSH client that has Viewpoint Emulation? We currently use Dynamic Connect, but do not think that it has SSH. putty does ssh, but no viewpoint, you're stuck with ansi. Art ___

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread Glen Batchelor
Accuterm? It supports A2, 60, and A2 enhanced but I use Wyse60 and linux console. Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog:

[U2] UniObjects / DBPause

2009-09-02 Thread Jeff Powell
Is there any way for UniObjects to know if the database is paused? As far as I can tell an open session will wait and a new session will throw an exception. The reason I need to know is that we're now using the SBOM method for rsync-ing with our standby server. This however is causing problems

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread Danny Ruckel
In AccuTerm, Tools/Settings/Term Type would suggest Wyse60 and Linux Console supported, at least they are listed as options on the aforementioned form... Danny R -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread James Canale, Jr.
[snip] putty does ssh, but no viewpoint, you're stuck with ansi. [/snip] This isn't the case actually. It is simple to set up a tunnel within putty and then you should be able to use the terminal emulation program of your choice (as long as you can set the host and port). For example, you set

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread Glen Batchelor
I meant that I have no experience with viewpoint. Glen.mobile RewriteRule ^(garbage|junk)$ /$1 [NC,L] On Sep 2, 2009, at 7:12 PM, Danny Ruckel dan...@southwesttraders.com wrote: In AccuTerm, Tools/Settings/Term Type would suggest Wyse60 and Linux Console supported, at least they are listed

Re: [U2] UniObjects / DBPause

2009-09-02 Thread Bill Haskett
u2-users-ow...@listserver.u2ug.org said the following on 9/2/2009 6:43 PM: The message's content type was not explicitly allowed Jeff: We're using mv.NET w/UO.NET as the underlying connection software. We pause our UniData server every night for about half an hour to do backups. Our

Re: [U2] UniObjects / DBPause

2009-09-02 Thread Tony G
From: Jeff Powell Is there any way for UniObjects to know if the database is paused? UO.NET for examples, I just blogged a generalized approach for how to handle a variety of these broken connectivity scenarios with any MV connectivity library. See Diagnosing Connectivity Errors. (Link below,

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread Kevin King
Ah yes, the infamous putty tunnel, that miracle of a feature that makes putty one of those can't live without tools. Now if only we could minimize putty to the tray instead of the task bar, that would be even cooler. ___ U2-Users mailing list

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread art
Kevin King wrote: Ah yes, the infamous putty tunnel, that miracle of a feature that makes putty one of those can't live without tools. Now if only we could minimize putty to the tray instead of the task bar, that would be even cooler. pageant ___

Re: [U2] SSH Viewpoint Emulation

2009-09-02 Thread Bob Rasmussen
On Wed, 2 Sep 2009, Kevin King wrote: Ah yes, the infamous putty tunnel, that miracle of a feature that makes putty one of those can't live without tools. Now if only we could minimize putty to the tray instead of the task bar, that would be even cooler. Or, you could run a terminal