Re: [U2] SELECTs on FILEs

Hi, a good trick to speed selects like this up is to add an index to the IDtry it and see what happens to your selects Cheers Les Sherlock Hewkin Project Manager, Group Financial Systems, I.T. Department T 01604 592289, M 07917 856195 -Original Message- From:

Re: [U2] SELECTs on FILEs

Using an index will only work for certain types of selects - for equality, or string 'starting with'. They won't work for string 'containing' or string 'finishing with'. Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] SELECTs on FILEs

There is a 'key section' to each group in a UniData hashed file. If you have no level 2 overflow, selecting on the keys will result in just the primary groups being read from disk. Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel:

Re: [U2] SELECTs on FILEs

While you are on the subject I have discovered another little annoyance from Windows as opposed to Unix. On Unix, Linux, Solaris, et al you can do a select on an account and get the same results every time, however, on windows you may not. At least with Universe. For a simple test do a select

[U2] UVPE linux setup

I have just setup uvpe 10.3.3 on opensuse 11.1 Locally universe seems to be running fine. However I can't access it via telnet or UO.NET either local or remote. I must have missed something in the installation guide - how do we configure uvpe on linux to accept connections via telnet uo.net ?

Re: [U2] UVPE linux setup

Universe for Linux does not install its own telnet server like the Windows version does. Make sure your Linux telnet daemon is running. u2ug wrote: I have just setup uvpe 10.3.3 on opensuse 11.1 Locally universe seems to be running fine. However I can't access it via telnet or UO.NET either

[U2] [UV] UPS + ODBC

I got faked out. Although I was able to get United Parcel Service's WorldShip v11 to export data, at the time, ODBC was not properly configured. UPS is NOT able to export to UV via ODBC since the UPS export has no primary key. Without a primary key, UV-ODBC returns an error message. Thus, I

Re: [U2] UVPE linux setup

In message 47c1b98393896f41a7bfe435442394e5268...@gmsdc.gerzio.ca, u2ug simpson-u...@gerzio.ca writes I have just setup uvpe 10.3.3 on opensuse 11.1 Locally universe seems to be running fine. However I can't access it via telnet or UO.NET either local or remote. I must have missed something in

Re: [U2] UVPE linux setup

Ok - half way there - I got the telnet part working by installing telnet opening up the port through the firewall I still can't connect via UO.NET though - I tried opening up port 31438 - that didn't work so I completely disabled the firewall - still no joy -Original Message- From:

Re: [U2] UVPE linux setup

Thanks jeff - I got telnet working ok - uo.net is still a problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: December 14, 2009 03:26 PM To: U2 Users List Subject: Re: [U2] UVPE linux setup

Re: [U2] UVPE linux setup

Thanks - this is just for my own internal use so security isn't really a concern - telnet will do just fine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman Sent: December 14, 2009 03:36 PM To:

Re: [U2] UVPE linux setup

You need to configure and turn on the Unirpc daemon too: See the Universe Administration PDF under Managing Network Services Administering the UniRPC on Unix System u2ug wrote: Thanks jeff - I got telnet working ok - uo.net is still a problem -Original Message- From:

Re: [U2] SELECTs on FILEs

Thanks Wally, By primary groups, does that mean the key and data sections? In other words, if there are no level 1 or 2 overflows, does that mean the entire file will be read into memory? -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] UVPE linux setup

Thanks - that did it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: December 14, 2009 04:12 PM To: U2 Users List Subject: Re: [U2] UVPE linux setup You need to configure and turn on the Unirpc

Re: [U2] [UV] UPS + ODBC

Unfortunately, I don't think BCI is going to get you where you need to go for this particular problem. BCI (Basic Client Interface) allows UV to be an ODBC client to another database server. If the server on the other end is anything other than UV, you'll need a 3rd party ODBC driver to