Re: [U2] Hosted UniData UniVerse (generic response)
Stephen, can you clarify please - when you say host, I presume you mean 'be the hosting service provider' and not an end user who has their hardware in a hosting centre rgds Symeon. On 09/08/06, Stephen O'Neal [EMAIL PROTECTED] wrote: Just make sure your on the same O/S. Don't go windows to *nix for example. We had this at one customer site and they had a Learning Experience.:-( Make sure you test it too, about once or twice a year, just to make sure nothing has changed. Only U2 OEM Partners can run Hosted systems. If you pay maintenance directly to IBM and are a direct end user, you cannot Host. Check with your U2 License person. And lastly, U2 Licensing maint fees *may change. At a minimum, you have to execute a new license agreement when you move from single system to hosted. Steve David Wolverton [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/09/2006 08:53 AM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] Hosted UniData We have a customer wanting to review options for 'Outsourcing' their servers - either to a CoLocation facility, or a fully hosted site. Does anyone have their servers for UniData CoLo or Hosted, and if so, would you mind sharing your provider and experience? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
We use this little routine (found it somewhere) : P 0001: STELPROMPT = @WHO : '' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN STELPROMPT TO SYSTEM(4002) Bottom at line 3. Schalk van Zyl UVPROMPT command sort of does this, but it only allows a single character. Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, August 09, 2006 11:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Change command prompt character Does anyone know if you can change the TCL(ECL) prompt character? I'd like to be able to put some text in there. Example: Server or Account Bob Woodward Senior Programmer/Analyst Ha rbor Wholesale Grocery --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JP Du Plessis, JGD Smit, AO MJW Smit, WG MJG Stander, JC v/d Ryst, JH van Dyk(MD/BD), A MM van Zyl, Sekr/Secr: HA Nolte. Hierdie e-pos is onderworpe aan `n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] FW: Opening
Not to open a can of worms, but what does Good Programming Skills mean? Thanks Mark Johnson - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: U2Users u2-users@listserver.u2ug.org; U2Community [EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 2:01 PM Subject: [U2] FW: Opening -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew McLaughlin Sent: Thursday, August 03, 2006 13:18 To: [EMAIL PROTECTED] Subject: [ManageUG2K] Opening Howdy all, First of all, a quick note to let everyone know, I've decided to resign from Shurflo and get back in to full time Java development. Woohoo! :) My last day here is 8/11. Now, my position will be open and we're interested in interviewing a suitable replacement. Anyone with M2K experience and good programming skills is a candidate. The office is located in beautiful Cypress, CA (Orange County). If you or someone else you know is interested, please send resume or CV directly to: [EMAIL PROTECTED] Thanks, Andrew __._,_.___ Messages in this topic (1) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar You are receiving Individual Emails Change Delivery Settings Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your Group SPONSORED LINKS a.. Business application software b.. Business application development c.. Business application d.. Epicor Yahoo! HotJobs Be Discovered! Employers find you Upload your resume New web site? Drive traffic now. Get your business on Yahoo! search. Y! Messenger Talk it up - free! Call your friends worldwide - free! . __,_._,___ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] FW: Opening
I believe that GOOD is an acronym for Graphical Object Oriented Data. ;) - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: Re: [U2] FW: Opening Date: Thu, 10 Aug 2006 03:22:44 -0400 Not to open a can of worms, but what does Good Programming Skills mean? Thanks Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
What language is this for and upon which machine does it work? It looks great, but it won't work as a paragraph or a basic program on a UniVerse system. Uv 10.1.11 AIX 5.2.2. Thanks Tom Dodds [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character We use this little routine (found it somewhere) : P 0001: STELPROMPT = @WHO : '' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN STELPROMPT TO SYSTEM(4002) Bottom at line 3. Schalk van Zyl UVPROMPT command sort of does this, but it only allows a single character. Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, August 09, 2006 11:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Change command prompt character Does anyone know if you can change the TCL(ECL) prompt character? I'd like to be able to put some text in there. Example: Server or Account Bob Woodward Senior Programmer/Analyst Ha rbor Wholesale Grocery --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JP Du Plessis, JGD Smit, AO MJW Smit, WG MJG Stander, JC v/d Ryst, JH van Dyk(MD/BD), A MM van Zyl, Sekr/Secr: HA Nolte. Hierdie e-pos is onderworpe aan `n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unicommand Paragraphs
I am using UniObjects for Java. I am working on trying to run datatel query paragraphs using the Unicommands. I have successfully been able to run select statements, list statements and download statements individually with the unicommands. But I have several queries in paragraph forms and having trouble getting the unicommands to execute them. Any suggestions will be helpful. Thank you for your advice. DG -- View this message in context: http://www.nabble.com/Unicommand-Paragraphs-tf2084377.html#a5743265 Sent from the U2 - Users forum at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
It's Universe Basic. It works on UV 10.0.19 on HPUX. From: [EMAIL PROTECTED] on behalf of Tom Dodds Sent: Thu 10/08/2006 8:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character What language is this for and upon which machine does it work? It looks great, but it won't work as a paragraph or a basic program on a UniVerse system. Uv 10.1.11 AIX 5.2.2. Thanks Tom Dodds [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character We use this little routine (found it somewhere) : P 0001: STELPROMPT = @WHO : '' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN STELPROMPT TO SYSTEM(4002) Bottom at line 3. Schalk van Zyl DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unicommand Paragraphs
On 8/10/06, gibboda [EMAIL PROTECTED] wrote: I am using UniObjects for Java. I am working on trying to run datatel query paragraphs using the Unicommands. I have successfully been able to run select statements, list statements and download statements individually with the unicommands. But I have several queries in paragraph forms and having trouble getting the unicommands to execute them. Any suggestions will be helpful. Before you do anything Datatel-related, make sure you execute 'ENVINIT' and FR.JUMPSTART'. (That's for Benefactor. It might be ST.JUMPSTART for the student system, etc.) My guess is that an I-Descriptor in one of your paragraphs expects the Envision environment to be there. -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Hosted UniData
We've colo'd at an SBC (ATT) data center also for the last 2+ years. The best thing about the ATT center is the communications connected to the Matrix [smirk]. With the 4 hurricanes last year and 3 the previous, Our US locations didn't even blink (I on the hand, beg, borrowed, and yes, even stole fuel). We use to have it in our own site with generators, the servers were up, but no one could connect because the telecom lines were down. David W, If you want some pricing info call me direct, you know the numbers. Thanks, Don Verhagen Tandem Staffing Solutions, Inc. On 8/9/2006 at 1:40 pm, in message [EMAIL PROTECTED], [EMAIL PROTECTED] wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Wednesday, August 09, 2006 7:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] Hosted UniData We have a customer wanting to review options for 'Outsourcing' their servers - either to a CoLocation facility, or a fully hosted site. Does anyone have their servers for UniData CoLo or Hosted, and if so, would you mind sharing your provider and experience? We've had our UV server colo'd at one of SBC's (now ATT) data centers for about 5 years, and have been happy with their service. They provide what you'd expect from a hardened data center: Multiple layers of physical security - you pass through 2 man traps and a biometric palm scan to get on the data center floor. Connections to multiple power grids and redundant diesel generators. 24x7 access. 24x7 staffed NOC if you need something power-cycled (i.e. a hung Windows server). Data center floor elevated above the flood plane. Built to withstand a 7.4 earthquake. A fire suppression system that won't damage electronics. Redundant internet connections to your cabinet. As Symeon noted, the software you're running is irrelevant to your colo provider since you manage the servers yourself. AFAIK, SBC only had 2 data centers prior to the merger with ATT (southern California and west Texas), but I think ATT had a few more. They also offer some degree of managed hosting, but I've never checked into the details. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
Sorry my mistake, it did not work in the Pick flavor of UniVerse. When I went to an ideal flavor it works great. Thanks Tom Dodds [EMAIL PROTECTED] 513-563-2800 Cincinnati Office 708-234-9608 Chicago Office 630-235-2975 Anywhere Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian Sent: Thursday, August 10, 2006 9:05 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character It's Universe Basic. It works on UV 10.0.19 on HPUX. From: [EMAIL PROTECTED] on behalf of Tom Dodds Sent: Thu 10/08/2006 8:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character What language is this for and upon which machine does it work? It looks great, but it won't work as a paragraph or a basic program on a UniVerse system. Uv 10.1.11 AIX 5.2.2. Thanks Tom Dodds [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character We use this little routine (found it somewhere) : P 0001: STELPROMPT = @WHO : '' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN STELPROMPT TO SYSTEM(4002) Bottom at line 3. Schalk van Zyl DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
Wow! I'm pretty excited about learning about this. This is something I've been looking for some time. It seems to work great except after setting the prompt using this method the usual prompt which shows you have an active select list disappears. Does anyone have any more information about SYSTEM(4001), SYSTEM(4002) and/or the disappearing ? Perry Taylor -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character We use this little routine (found it somewhere) : P 0001: STELPROMPT = @WHO : '' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN STELPROMPT TO SYSTEM(4002) Bottom at line 3. Schalk van Zyl UVPROMPT command sort of does this, but it only allows a single character. Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, August 09, 2006 11:22 AM To: u2-users@listserver.u2ug.org Subject: [U2] Change command prompt character Does anyone know if you can change the TCL(ECL) prompt character? I'd like to be able to put some text in there. Example: Server or Account Bob Woodward Senior Programmer/Analyst Ha rbor Wholesale Grocery --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JP Du Plessis, JGD Smit, AO MJW Smit, WG MJG Stander, JC v/d Ryst, JH van Dyk(MD/BD), A MM van Zyl, Sekr/Secr: HA Nolte. Hierdie e-pos is onderworpe aan `n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
Works fine for me (uv 10.0.8, Solaris 8). The best coding... cut, paste, BASIC, CATALOG :) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom Dodds Sent: Thursday, August 10, 2006 8:28 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character What language is this for and upon which machine does it work? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
uv basic UV 10.1.4 PICK FORMAT ED PRG TST 3 lines long. : P 0001: MYPROMPT = 'Whatever ' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN MYPROMPT TO SYSTEM(4002) Bottom at line 3. : FI TST filed in file PRG. BASIC PRG TST Compiling: Source = '/kts.bron/PRG/TST', Object = '/kts.bron/PRG.O/TST' Compilation Complete. RUN PRG TST Whatever Whatever Whatever Whatever What language is this for and upon which machine does it work? It looks great, but it won't work as a paragraph or a basic program on a UniVerse system. Uv 10.1.11 AIX 5.2.2. Thanks Tom Dodds [EMAIL PROTECTED] - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JP Du Plessis, JGD Smit, AO MJW Smit, WG MJG Stander, JC v/d Ryst, JH van Dyk(MD/BD), A MM van Zyl, Sekr/Secr: HA Nolte. Hierdie e-pos is onderworpe aan `n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
Don't know, but you get used to it! SvZ Wow! I'm pretty excited about learning about this. This is something I've been looking for some time. It seems to work great except after setting the prompt using this method the usual prompt which shows you have an active select list disappears. Does anyone have any more information about SYSTEM(4001), SYSTEM(4002) and/or the disappearing ? Perry Taylor -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character We use this little routine (found it somewhere) : P 0001: STELPROMPT = @WHO : '' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN STELPROMPT TO SYSTEM(4002) Bottom at line 3. Schalk van Zyl - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JP Du Plessis, JGD Smit, AO MJW Smit, WG MJG Stander, JC v/d Ryst, JH van Dyk(MD/BD), A MM van Zyl, Sekr/Secr: HA Nolte. Hierdie e-pos is onderworpe aan `n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] FW: Opening
probably meaning .. not like old pick (mv) guys DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] FW: Opening From: Mark Johnson [EMAIL PROTECTED] Date: Thu, August 10, 2006 12:22 am To: u2-users@listserver.u2ug.org Not to open a can of worms, but what does Good Programming Skills mean? Thanks Mark Johnson - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: U2Users u2-users@listserver.u2ug.org; U2Community [EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 2:01 PM Subject: [U2] FW: Opening -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew McLaughlin Sent: Thursday, August 03, 2006 13:18 To: [EMAIL PROTECTED] Subject: [ManageUG2K] Opening Howdy all, First of all, a quick note to let everyone know, I've decided to resign from Shurflo and get back in to full time Java development. Woohoo! :) My last day here is 8/11. Now, my position will be open and we're interested in interviewing a suitable replacement. Anyone with M2K experience and good programming skills is a candidate. The office is located in beautiful Cypress, CA (Orange County). If you or someone else you know is interested, please send resume or CV directly to: [EMAIL PROTECTED] Thanks, Andrew __._,_.___ Messages in this topic (1) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar You are receiving Individual Emails Change Delivery Settings Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your Group SPONSORED LINKS a.. Business application software b.. Business application development c.. Business application d.. Epicor Yahoo! HotJobs Be Discovered! Employers find you Upload your resume New web site? Drive traffic now. Get your business on Yahoo! search. Y! Messenger Talk it up - free! Call your friends worldwide - free! . __,_._,___ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe ODBC driver performance issues
I am new to the group and to UniVerse. We are experiencing issues in UniVerse 10.1.3 downloading data via the ODBC connection to SQL Server. 2.6 mil records can take 2 hours to complete. We are currently using the default settings for the ODBC driver. I will soon make changes to increase the prefetch and threshold values. Any experience with the ideal settings? From my testing the best performance seems to be at prefetch = 16383 and threshold = 4096 on the ODBC driver. At this settings seem to get a 30% performance increase. I would like to see it improve even more. To complicate things the UniVerse is using a SAN for storage. Multiple processors on the box and they are set to multi-threaded operations. During the download the CPU is utilized less than 10%. Anyone have any ideas of additional performance things to check in UniVerse? Thanks Chris --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
You need to set the second and third fields in SYSTEM(4002). 0001: STELPROMPT = @WHO : '' STELPROMPT2 = @WHO : '' STELPROMPT3 = '+' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN STELPROMPT TO SYSTEM(4002) Field 2 is for the active select list prompt and field 3 is for the command continuation prompt, which I simply left as the single character +. This worked in a PICK flavor account in UV 10.1.18 on WIN Server 2003. This is documented in the online HELP for UV.PROMPT. The command is actually UVPROMPT but the online docs are accessed by UV.PROMPT. Strange, but true. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 8:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character Don't know, but you get used to it! SvZ Wow! I'm pretty excited about learning about this. This is something I've been looking for some time. It seems to work great except after setting the prompt using this method the usual prompt which shows you have an active select list disappears. Does anyone have any more information about SYSTEM(4001), SYSTEM(4002) and/or the disappearing ? Perry Taylor -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character We use this little routine (found it somewhere) : P 0001: STELPROMPT = @WHO : '' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN STELPROMPT TO SYSTEM(4002) Bottom at line 3. Schalk van Zyl - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JP Du Plessis, JGD Smit, AO MJW Smit, WG MJG Stander, JC v/d Ryst, JH van Dyk(MD/BD), A MM van Zyl, Sekr/Secr: HA Nolte. Hierdie e-pos is onderworpe aan `n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe ODBC driver performance issues
If it's speed you want, go with a text file dump of the data and then an SQL bulk insert job. I did much the same thing (though with fewer records) and improved performance dramatically. Sometimes the good old tools really are better. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [U2C] FW: Opening
Hi Eric Andy is just a friend that I sent this email on behalf of, and isn't actually a member of this group. By M2K he meant Manage-2000 which is now owned by Epicor. This product has been around since 1978, and at last count had something like 700 menus. Never bothered counting the number of programs but it's probably around 10 to 12 thousand programs/subroutines. http://www.epicor.com/www/products/manufacturing/manage2k/ And on the other subject of 'good programming skills' if anyone here has ever seen one of Andy's programs they would know what he meant. He almost redesigns the language with his custom functions, so if you don't have a good handle on Unidata you might be lost for a month or so. I imagine that if you had 5 to 7 years of Unidata programming you'd be in like Flynn. M2k has a huge number of Utilities but they are fairly easy to learn, so the familiarity with Unidata would be more important, imho... hth, Allen -Original Message- From: Eric Armstrong [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 09:19 To: [EMAIL PROTECTED] Subject: FW: [U2C] FW: Opening Andrew, What did you mean by M2K? Did you mean W2K? Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 714.995.7012 fax -Original Message- From: Allen E. Elwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 11:01 AM To: U2Users; U2Community Subject: [U2C] FW: Opening -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew McLaughlin Sent: Thursday, August 03, 2006 13:18 To: [EMAIL PROTECTED] Subject: [ManageUG2K] Opening Howdy all, First of all, a quick note to let everyone know, I've decided to resign from Shurflo and get back in to full time Java development. Woohoo! :) My last day here is 8/11. Now, my position will be open and we're interested in interviewing a suitable replacement. Anyone with M2K experience and good programming skills is a candidate. The office is located in beautiful Cypress, CA (Orange County). If you or someone else you know is interested, please send resume or CV directly to: [EMAIL PROTECTED] Thanks, Andrew __._,_.___ Messages in this topic (1) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar You are receiving Individual Emails Change Delivery Settings Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your Group SPONSORED LINKS a.. Business application software b.. Business application development c.. Business application d.. Epicor Yahoo! HotJobs Be Discovered! Employers find you Upload your resume New web site? Drive traffic now. Get your business on Yahoo! search. Y! Messenger Talk it up - free! Call your friends worldwide - free! . __,_._,___ u2-community mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday, August 10, 2006 8:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character You need to set the second and third fields in SYSTEM(4002). 0001: STELPROMPT = @WHO : '' STELPROMPT2 = @WHO : '' STELPROMPT3 = '+' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN STELPROMPT TO SYSTEM(4002) Field 2 is for the active select list prompt and field 3 is for the command continuation prompt, which I simply left as the single character +. This worked in a PICK flavor account in UV 10.1.18 on WIN Server 2003. This is documented in the online HELP for UV.PROMPT. The command is actually UVPROMPT but the online docs are accessed by UV.PROMPT. Strange, but true. BobW Cool! It works perfectly for me in Pick flavor, UV 10.1.4, RH EL 3. That's a lot more efficient than the 250 line program I was using, and I was never able to get the select prompt to work correctly. It's completely undocumented in the online help for this version of UV though. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe ODBC driver performance issues
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Brooks Sent: Thursday, August 10, 2006 8:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODBC driver performance issues I am new to the group and to UniVerse. We are experiencing issues in UniVerse 10.1.3 downloading data via the ODBC connection to SQL Server. 2.6 mil records can take 2 hours to complete. We are currently using the default settings for the ODBC driver. I will soon make changes to increase the prefetch and threshold values. Any experience with the ideal settings? From my testing the best performance seems to be at prefetch = 16383 and threshold = 4096 on the ODBC driver. At this settings seem to get a 30% performance increase. I would like to see it improve even more. To complicate things the UniVerse is using a SAN for storage. Multiple processors on the box and they are set to multi-threaded operations. During the download the CPU is utilized less than 10%. Sounds like you're I/O bound, although 2.6 million records in 2 hours isn't all that bad in my experience. Is it possible you're hitting the threshold of your NICs, or competing with a lot of other network traffic? If both machines have multiple NICs, you could reserve one on each machine for only talking to the other. You could add an entry to the hosts file on each so it would only know the other machine by the reserved NIC's IP, then just make sure the reserved IP addresses don't exist in DNS so no other machines will use them. If the machines are physically close, a crossover cable from NIC to NIC would eliminate any switch performance issues. At that point a rough calculation of your throughput based on the average size of each record would tell you if you're utilizing the available bandwith, or if there's some other bottleneck. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [U2C] FW: Opening
Is it In Like Flynn or In Like Flint? - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: Eric Armstrong [EMAIL PROTECTED] Cc: U2Users u2-users@listserver.u2ug.org; U2Community [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:05 PM Subject: [U2] RE: [U2C] FW: Opening Hi Eric Andy is just a friend that I sent this email on behalf of, and isn't actually a member of this group. By M2K he meant Manage-2000 which is now owned by Epicor. This product has been around since 1978, and at last count had something like 700 menus. Never bothered counting the number of programs but it's probably around 10 to 12 thousand programs/subroutines. http://www.epicor.com/www/products/manufacturing/manage2k/ And on the other subject of 'good programming skills' if anyone here has ever seen one of Andy's programs they would know what he meant. He almost redesigns the language with his custom functions, so if you don't have a good handle on Unidata you might be lost for a month or so. I imagine that if you had 5 to 7 years of Unidata programming you'd be in like Flynn. M2k has a huge number of Utilities but they are fairly easy to learn, so the familiarity with Unidata would be more important, imho... hth, Allen -Original Message- From: Eric Armstrong [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 09:19 To: [EMAIL PROTECTED] Subject: FW: [U2C] FW: Opening Andrew, What did you mean by M2K? Did you mean W2K? Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 714.995.7012 fax -Original Message- From: Allen E. Elwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 11:01 AM To: U2Users; U2Community Subject: [U2C] FW: Opening -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew McLaughlin Sent: Thursday, August 03, 2006 13:18 To: [EMAIL PROTECTED] Subject: [ManageUG2K] Opening Howdy all, First of all, a quick note to let everyone know, I've decided to resign from Shurflo and get back in to full time Java development. Woohoo! :) My last day here is 8/11. Now, my position will be open and we're interested in interviewing a suitable replacement. Anyone with M2K experience and good programming skills is a candidate. The office is located in beautiful Cypress, CA (Orange County). If you or someone else you know is interested, please send resume or CV directly to: [EMAIL PROTECTED] Thanks, Andrew __._,_.___ Messages in this topic (1) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar You are receiving Individual Emails Change Delivery Settings Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your Group SPONSORED LINKS a.. Business application software b.. Business application development c.. Business application d.. Epicor Yahoo! HotJobs Be Discovered! Employers find you Upload your resume New web site? Drive traffic now. Get your business on Yahoo! search. Y! Messenger Talk it up - free! Call your friends worldwide - free! . __,_._,___ u2-community mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe ODBC driver performance issues {Unclassified}
John, Chris is transferring on average about 360 (2.6M / 2 / 3600) records per second. If the records are ~200 chars, then he's getting about 700kb/sec (that's kb, not kB), or about 1.5% of the throughput you might hope for on a 100Mbps Ethernet pipe! So I'd say Chris does have an issue here. I can see how increasing the block size would make the network traffic less inefficient, it would be interesting to see what percent busy the network card reports. One of the other issues can be that the data contains, on the UV side, complicated I-Type Dictionary items that mean that the exported data isn't nearly as simple as it looks. This can cause an unexpectedly large amount of I/O on the UV side. Mike -Original Message- From: [EMAIL PROTECTED] On Behalf Of John Hester Sent: Friday, 11 August 2006 08:39 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe ODBC driver performance issues -Original Message- From: [EMAIL PROTECTED] Behalf Of Chris Brooks Sent: Thursday, August 10, 2006 8:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODBC driver performance issues I am new to the group and to UniVerse. We are experiencing issues in UniVerse 10.1.3 downloading data via the ODBC connection to SQL Server. 2.6 mil records can take 2 hours to complete. We are currently using the default settings for the ODBC driver. I will soon make changes to increase the prefetch and threshold values. Any experience with the ideal settings? From my testing the best performance seems to be at prefetch = 16383 and threshold = 4096 on the ODBC driver. At this settings seem to get a 30% performance increase. I would like to see it improve even more. During the download the CPU is utilized less than 10%. Sounds like you're I/O bound, although 2.6 million records in 2 hours isn't all that bad in my experience. Is it possible you're hitting the threshold of your NICs, or competing with a lot of other network traffic? If both machines have multiple NICs, you could reserve one on each machine for only talking to the other. You could add an entry to the hosts file on each so it would only know the other machine by the reserved NIC's IP, then just make sure the reserved IP addresses don't exist in DNS so no other machines will use them. If the machines are physically close, a crossover cable from NIC to NIC would eliminate any switch performance issues. At that point a rough calculation of your throughput based on the average size of each record would tell you if you're utilizing the available bandwidth, or if there's some other bottleneck. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe ODBC driver performance issues {Unclassified}
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
HENDERSON MIKE, MR
Sent: Thursday, August 10, 2006 4:22 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Universe ODBC driver performance issues
{Unclassified}
John,
Chris is transferring on average about 360 (2.6M / 2 / 3600)
records per
second. If the records are ~200 chars, then he's getting about
700kb/sec (that's kb, not kB), or about 1.5% of the
throughput you might
hope for on a 100Mbps Ethernet pipe!
So I'd say Chris does have an issue here.
ODBC is known to be very chatty and inefficient, so you have to add
quite a bit of overhead for the protocol itself (though I don't know how
much). Even so, you're right, that's pretty poor performance over 100MB
ethernet and it would be abysmal for a gigabit link.
-John
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [U2C] FW: Opening
OK - we're going to be asked to move over to the U2 community pages, but... Is it In Like Flynn or In Like Flint? The phrase is 'In Like Flynn' as in Errol Flynn, the actor from the 1930's. http://www.imdb.com/name/nm0001224/bio He had a flambouyant style and was arrested and subsequently charged with statutory rape (three times). After being aquitted on all charges, the phrase 'In Like Flynn' became popular. Jeff Butera Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 You're not right, Daddy my 3-year old showing her wisdom --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
Tom, can you use $OPTIONS PIOPEN in a program in a Pick account? Does it work in that case? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
How about replacing the third line with ASSIGN MYPROMPT : (IF SELECTINFO(0,IK$SLACTIVE) THEN ELSE ) TO SYSTEM(4002) to handle the active Select List #0 case? (To use the mnemonic you will have had to include INFO_KEYS.H.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [U2C] FW: Opening
I'm just wondering how many vendors have purchased M2k to resell it...Once upon a time ADP had purchased it, then dumped it -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Thursday, August 10, 2006 7:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: [U2C] FW: Opening Is it In Like Flynn or In Like Flint? - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: Eric Armstrong [EMAIL PROTECTED] Cc: U2Users u2-users@listserver.u2ug.org; U2Community [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:05 PM Subject: [U2] RE: [U2C] FW: Opening Hi Eric Andy is just a friend that I sent this email on behalf of, and isn't actually a member of this group. By M2K he meant Manage-2000 which is now owned by Epicor. This product has been around since 1978, and at last count had something like 700 menus. Never bothered counting the number of programs but it's probably around 10 to 12 thousand programs/subroutines. http://www.epicor.com/www/products/manufacturing/manage2k/ And on the other subject of 'good programming skills' if anyone here has ever seen one of Andy's programs they would know what he meant. He almost redesigns the language with his custom functions, so if you don't have a good handle on Unidata you might be lost for a month or so. I imagine that if you had 5 to 7 years of Unidata programming you'd be in like Flynn. M2k has a huge number of Utilities but they are fairly easy to learn, so the familiarity with Unidata would be more important, imho... hth, Allen -Original Message- From: Eric Armstrong [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 09:19 To: [EMAIL PROTECTED] Subject: FW: [U2C] FW: Opening Andrew, What did you mean by M2K? Did you mean W2K? Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 714.995.7012 fax -Original Message- From: Allen E. Elwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 11:01 AM To: U2Users; U2Community Subject: [U2C] FW: Opening -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew McLaughlin Sent: Thursday, August 03, 2006 13:18 To: [EMAIL PROTECTED] Subject: [ManageUG2K] Opening Howdy all, First of all, a quick note to let everyone know, I've decided to resign from Shurflo and get back in to full time Java development. Woohoo! :) My last day here is 8/11. Now, my position will be open and we're interested in interviewing a suitable replacement. Anyone with M2K experience and good programming skills is a candidate. The office is located in beautiful Cypress, CA (Orange County). If you or someone else you know is interested, please send resume or CV directly to: [EMAIL PROTECTED] Thanks, Andrew __._,_.___ Messages in this topic (1) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar You are receiving Individual Emails Change Delivery Settings Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your Group SPONSORED LINKS a.. Business application software b.. Business application development c.. Business application d.. Epicor Yahoo! HotJobs Be Discovered! Employers find you Upload your resume New web site? Drive traffic now. Get your business on Yahoo! search. Y! Messenger Talk it up - free! Call your friends worldwide - free! . __,_._,___ u2-community mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
Huh? That makes no sense. The ASSIGN is only done once per session, i.e. at login time. I think having your prompt showing whether there was an active select list active when you logged in, isn't really that useful ;) FWIW We have our own command editor, which shows which selectlists are active in front of the prompt - so, for example, if selectlists 1 2 are both active, the prompt would be: 12: Where the 12 is in half intensity. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Friday, 11 August 2006 11:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character How about replacing the third line with ASSIGN MYPROMPT : (IF SELECTINFO(0,IK$SLACTIVE) THEN ELSE ) TO SYSTEM(4002) to handle the active Select List #0 case? (To use the mnemonic you will have had to include INFO_KEYS.H.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
