Re: [U2] Embedded help as hypertext
The Universe 'HELP' (and HELP BASIC and HELP SQL) listings are all contained as records in the file 'HELP.FILE'. Creating a program to make an index page and html-ized versions of the individual items would be an easy project: LIST HELP.FILE PICK*SAVE.LIST TEXT 07:59:54am 12 Mar 2014 PAGE1 HELP.FILE. PICK*SAVE.LIST Text.. SAVE.LIST . . Use SAVE.LIST to save an active select list. You can use GET.LIST . to recall this list for subsequent processing and avoid having to . repeat the selection process each time you want to use the same selec . list. . . . Syntax . . SAVE.LIST [ [ filename ] listname ] [ FROM n ] . . . Parameters . . . The following table describes each parameter of the syntax. . On Tue, Mar 11, 2014 at 11:49 PM, Hona, David david.h...@cba.com.au wrote: I assume you're talking about UV? Define 'improved'? It could be improved by actually having all the commands, options and functions in it first. Even the PDF versions are missing information :) However, if you want another/better built-in HELP facility for your own purposes...PIHELP may help you (it offers paging back, sub-topics, indexing, etc.)... If so, take a look at PIHELP (TCL verb) and SHOW.HELP (subroutine -SHOW) which is a port of the Prime INFORMATION help which has 'hypertext' (sub-topics) and paging (back/forwards). In PI, there was also a subroutine you could call (rather than EXECUTE PIHELP subject. It has own format where you can specify the help file source and sub-topics indexed based on keywords in the topic/help message, like this in field/line one: 0001: .*X PIHELP ONLINE COMMAND VERB TOPIC SUBJECT AID ASSISTANCE An index on the help file would on the above field allow PHELP ABOUT keyword. The FROM key word lets you specify you own help file. It is better than the native UV HELP in some respects and utilises the default SYS.HELP file or your own (if required). I did note that there is no indices for the SYS.HELP file, so the PIHELP ABOUT topic function doesn't work...the required I-type dictionary item to parse the help records appears to be missing from the dictionary of SYS.HELP (Rocket Support should be able to assist there). The source is in APP.PROGS (PIHELP.B and SHOW.HELP.B) - good luck! I guess it has been ported over for PI/open users that used this facility for their own applications... The U2 Tools have built online help too - which are handy. If you use them - I'd encourage all newcomers to use these tools and similar commercial products to supplement the built-in native command-line tools (aka terminal shell session)... Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, 12 March 2014 3:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] Embedded help as hypertext Does anyone have an improved version of the TCL command HELP ? Are there any wiki's or anything that comprise all of the HELP text and perhaps more ? I sometimes use it, sometimes use the PDFs and sometimes just google. I think it would be a great resource were there a better solution. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- --- Jeff Schasny - jschasnyATgmailDOTcom --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
Jeff, What I think many of us are suggesting is essentially if it hurts when you do that, don't do that i.e. if the query language won't accomplish what you want to do, use something else. jeffrey Butera wrote: On 3/3/14, 2:58 PM, Brian Leach wrote: Jeff Try mvQuery, that should not have any problems with those volumes. Hi Brian We've isolated the problem to Unidata itself, not the reporting tool. In short, when we do a LIST with about 150 fields, it throws: too many items in LIST As soon as we erase a field (any field), the LIST statement runs properly. Unfortunately, I cannot locate any parameter that might control this. I thought we were hitting U_SENTLEN - but we're nowhere near that value. -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reporting Tools
Let me put in a good word for Cedarville Download which I have been using for years to export stuff into all sorts of flat files. Works great and it free. http://www.cedarville.edu/Offices/Information-Technology/FTP-Site.aspx dale kelley wrote: We generate an annual GASB depreciation report that became too big for paper. We simply began putting those same print lines into an export record with the column spaces replaced by , 's and named it as .CSV. You need a programmer to do this but you can generate almost any size excel file and there are products like Nebula XL that apply excel formatting. Would save the email recipient any manipulation. Dale On 02/28/2014 02:31 PM, Jeff Lettau wrote: Without knowing exactly what you are doing, why not take a look at ODBC and linking an excel sheet to your database and use the powerpivot to create your report? If you are really doing a ETL you need a tool or a programmer. I've pulled over 300k worth of records without an issue. Although the record set was not 200 columns, but I'd bet you could get down to under 50 then do calculations in excel, then pivot the data to the report. Please note that my email address has changed. Beginning immediately my new address is jeff.let...@soundunited.com . Use this new address for all communications. Jeffrey Lettau | ERP Systems Manager | O 410.358.3600 | D 410.764.5242 | 5601 Metro Drive | Baltimore MD 21215 | www.soundunited.com Polk Audio - WWW.POLKAUDIO.COM Definitive Technologies - WWW.DEFINITIVETECH.COM BOOM Movement - WWW.BOOMMOVEMENT.COM -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: Friday, February 28, 2014 9:42 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Reporting Tools On 2/28/14, 9:29 AM, Jeff Lettau wrote: In the past I've made dictionary names that are very short to save characters. But my real reason for responding is I can't help but wonder what you need 200+ columns for? My first instinct when hearing this is that a report is not what you need. To be clear - this is not MY choice of report, I'm trying to explain that they are using a report as a poor person's ETL tool to dump vast amount of data to Excel and manipulate offline. But I though I'd ask the question anyway. How many rows are in this report? Perhaps 10,000 - 30,000 -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer.
SPOOL -LIST will show you all the print queue names Charles Stevenson wrote: SETPTR 0,80,60,3,3,1,AT \\BAD\NAME seems to execute w/o throwing an error. but an actual PRINT statement yields a fatal error: Program PRT: Line 2, Printer name \\BAD\PRINTERNAME is not recognized by the system. I'd like to verify we're printing to a good printer *before* attempting to do so. Execute some DOS command, maybe? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users . -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer.
I was assuming, based on the fact that he is using SETPTR to address which printer he is directing the data to, that he was looking at queues available to the machine since that is what SETPTR does. Wols Lists wrote: On 28/01/14 15:07, Jeff Schasny wrote: SPOOL -LIST will show you all the print queue names Is that all the printer names known to U2, or all the printer names known to the network? In Chuck's example, this particular printer will never have been declared to U2 - I did this all the time. The only printer UV was told about was DEFAULT, which didn't exist ... In fact, I suspect this syntax will list all the printers known to the server on which U2 is running, which could easily NOT include a valid printer the user is trying to print to ... Cheers, Wol Charles Stevenson wrote: SETPTR 0,80,60,3,3,1,AT \\BAD\NAME seems to execute w/o throwing an error. but an actual PRINT statement yields a fatal error: Program PRT: Line 2, Printer name \\BAD\PRINTERNAME is not recognized by the system. I'd like to verify we're printing to a good printer *before* attempting to do so. Execute some DOS command, maybe? ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer.
I've been using Universe since it was in beta and I had no idea you could use a URI in SETPTR. Its a good day, I've learned something new. Thanks! Wols Lists wrote: So if I am working on \\ASHDOWN (the name of my computer) I can use SETPTR to point at \\TIGGER\HP - a printer logically connected to a different computer that I've never told UV anything about. Setptr is quite happy to be given a windows remote computer reference and it works fine. That was how all our printers worked - they usually had network cards in them, so when a new printer turned up, I would assign it a name in DNS, and for anybody who was supposed to use it I would just edit their login script to add eg SETPTR ...,AT \\ACCOUNTS-HP\RAW And it just worked. No UV printer setting up whatsoever. Okay, my setup was a little bit cleverer than that, but everything, and I mean EVERYTHING, was done in my programs. Nothing at the UV level whatsoever. Cheers, Wol Correct. Except he was *also* using the URI syntax, ie \\COMPUTER\QUEUE. Wols Lists wrote: On 28/01/14 15:07, Jeff Schasny wrote: SPOOL -LIST will show you all the print queue names Is that all the printer names known to U2, or all the printer names known to the network? In Chuck's example, this particular printer will never have been declared to U2 - I did this all the time. The only printer UV was told about was DEFAULT, which didn't exist ... In fact, I suspect this syntax will list all the printers known to the server on which U2 is running, which could easily NOT include a valid printer the user is trying to print to ... Cheers, Wol Charles Stevenson wrote: SETPTR 0,80,60,3,3,1,AT \\BAD\NAME seems to execute w/o throwing an error. but an actual PRINT statement yields a fatal error: Program PRT: Line 2, Printer name \\BAD\PRINTERNAME is not recognized by the system. I'd like to verify we're printing to a good printer *before* attempting to do so. Execute some DOS command, maybe? ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interfacing Touchscreens directly to UniVerse
I may be confused here but the device's (tablet, phone, what have you) operating system is what drives/runs/interprets the touch screen. To Universe it's just another input stream. Russ wrote: We've already done the iPad/browser/web server/universe solution. But are wondering if anyone has successfully approached this in another way. Thanks Happy New Year to all. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Interfacing-Touchscreens-directly-to-UniVerse-tp42426.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BASIC code - upper, lower, CamelCase, what say you?
All upper. All variables global to the program. Everything is untyped. I've always wondered why anyone would induce an increased level of complexity into an inherently simple language. It's part of the beauty of the development environment. George Gallen wrote: Wonder if anyone has ever done a study on whether by using U/l variables, now you will be hitting the shift a whole lot more, does this lead to or worsen carpel tunnel? Kind of a serious concern. I think it also makes debugging more difficult, I'd rather stick to all UPPER or all lower Nothing better Than wasting 2 hours going through a program to find out Oops, mean L instead of l George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, December 20, 2013 2:32 PM To: U2 Users List Subject: Re: [U2] BASIC code - upper, lower, CamelCase, what say you? This is really what got my thought-process flowing on this subject. I saw this code on github after the Rocket Software Whats New in 11.2 webinar: https://github.com/RocketSoftware/u2-servers-lab/blob/master/UniVerse-11.2/Local/BP/LocalMain PROGRAM LocalMain ** Let's have a quick look at local scoping CRT Calling the local SUBROUTINE CALL Main(@SENTENCE) ;* This will call Main() below, rather than an external subroutine CRT Back from the local SUBROUTINE END SUBROUTINE Main(Args) CRT Running inside the local SUBROUTINE CRT Args: :Args FOR Counter = 1 TO 3 CALL InnerLoop(Counter) NEXT Counter RETURN SUBROUTINE InnerLoop(OutsideCounter) * Notice this won't affect Main()'s 'Counter' variable due to scoping FOR Counter = 1 TO OutsideCounter CRT *: NEXT Counter CRT RETURN ___ 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 . -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] List of display control @ variables for UVBasic
Not really. It has the named @ variables like @userno, @ selected, @vm, etc but the terminal control codes @(-1), @(-2), @(-3), etc are not there. At least not in my (admittedly old, 10.2) version. HELP BASIC @ worked for me. Thanks all. Gregor Scott wrote: The UniVerse BASIC Commands Reference documents it (look for @ function in the TOC) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, 20 November 2013 8:54 AM To: U2-Users@listserver.u2ug.org Subject: [U2] List of display control @ variables for UVBasic Anyone know where the list of @ variables for display control ( @(-1) = clear screen) is in the Universe documentation? I can't seem to find it. Thanks -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1IpKwm7RGU/5YCbcDsMLoLdzSG18nYGvY/0.204 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] List of display control @ variables for UVBasic
Anyone know where the list of @ variables for display control ( @(-1) = clear screen) is in the Universe documentation? I can't seem to find it. Thanks -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] More than one way to list the Number of licensed users ?
CONFIG Configuration data for license number XXX: User limit = 112 Expiry date= 1/1/2500 -GCI package is installed. User limit = 112. Expiry date = 1/1/2500 -UCI package is installed. User limit = 112. Expiry date = 1/1/2500 -UVCS package is installed. User limit = 112. Expiry date = 1/1/2500 -UVADM package is installed. User limit = 112. Expiry date = 1/1/2500 -UVODBC package is installed. User limit = 112. Expiry date = 1/1/2500 -iPHANTOM package is installed. User limit = 112. Expiry date = 1/1/2500 Wjhonson wrote: STATUS NETWORK on Universe, will list Number of licensed uniVerse users: 110 Are there other ways to get this number? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Globally catalogs - source code
LIST GLOBAL.CATDIR PROG.PATHNAME Leverett, Brendon wrote: We are running UV on AIX We have some programs that have been globally catalogued - they are visible in the GLOBAL.CATDIR file. I am aware some are system commands but a number are programs we have globally catalogued as (shown as *ProgName). Any tips on the best way to find which program library the source code resides in? Buried in the GLOBAL.CATDIR record, along with all the compiled code 'junk' I can see the path but viewing (via a CT or ED) it is not user friendly as the 'junk' will often crash/lock the screen. Regards, Brendon Information Services Spotless Services Australia Limited T: 03 9269 7738 M: 0419 349122 F: 03 8399 7013 E-mail brendon.lever...@spotless.com.au W www.spotless.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Globally catalogs - source code
Are you running UV on AIX? Wjhonson wrote: PROG.PATHNAME not found -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 21, 2013 9:10 am Subject: Re: [U2] [UV] Globally catalogs - source code LIST GLOBAL.CATDIR PROG.PATHNAME Leverett, Brendon wrote: We are running UV on AIX We have some programs that have been globally catalogued - they are visible in the GLOBAL.CATDIR file. I am aware some are system commands but a number are programs we have globally catalogued as (shown as *ProgName). Any tips on the best way to find which program library the source code resides in? Buried in the GLOBAL.CATDIR record, along with all the compiled code 'junk' I can see the path but viewing (via a CT or ED) it is not user friendly as the 'junk' will often crash/lock the screen. Regards, Brendon Information Services Spotless Services Australia Limited T: 03 9269 7738 M: 0419 349122 F: 03 8399 7013 E-mail brendon.lever...@spotless.com.au W www.spotless.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Globally catalogs - source code
This is a Type I Descriptor last compiled on 03/27/13 at 10:28. 20 lines long. : P7 0001: I 0002: SUBR(*SRS.UV.HEADER, @RECORD, 41) 0003: 0004: 0005: 30L 0006: S 0007: Looks like this got here courtesy of Mr. Pflugfelder's SRS stuff he mentioned earlier. Dianne Ackerman wrote: I'm running UV on AIX and I also get that error. -Dianne On 8/21/2013 2:59 PM, Jeff Schasny wrote: Are you running UV on AIX? Wjhonson wrote: PROG.PATHNAME not found -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Aug 21, 2013 9:10 am Subject: Re: [U2] [UV] Globally catalogs - source code LIST GLOBAL.CATDIR PROG.PATHNAME Leverett, Brendon wrote: We are running UV on AIX We have some programs that have been globally catalogued - they are visible in the GLOBAL.CATDIR file. I am aware some are system commands but a number are programs we have globally catalogued as (shown as *ProgName). Any tips on the best way to find which program library the source code resides in? Buried in the GLOBAL.CATDIR record, along with all the compiled code 'junk' I can see the path but viewing (via a CT or ED) it is not user friendly as the 'junk' will often crash/lock the screen. Regards, Brendon Information Services Spotless Services Australia Limited T: 03 9269 7738 M: 0419 349122 F: 03 8399 7013 E-mail brendon.lever...@spotless.com.au W www.spotless.com ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick flavor in U2 personal edition
With Universe you will be prompted for the account flavor when you create an account Eric Armstrong wrote: I downloaded the U2 personal edition to my pc, and it is working, but how do I get it to use the Pick flavor? Eric Armstrong Programmer/Analyst Lobel Financial LOBEL FINANCIAL PRIVACY NOTICE: This communication may contain confidential company information that is protected by federal law. Federal regulations prohibit the disclosure (or re-disclosure) of confidential information without the written consent of the person(s) to whom it pertains. Additionally, the views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects dll question
Doug, The .dll does not need to be installed. Visual Studio will include it in the installation package for your C# application after you add it to the project. doug chanco wrote: Is it possible to just put the uniobjects dll on a system without installing it? I am working on a home project where I have an android app call a web service to get UV data from my linux server. I have a hosted system running windows server and I am working on a c# web service that will receive data and pass it to a subroutine (via uniobjects) on my linux box. I have it working locally on my home test system (windows 2003 with uniobjects installed) but I would like to move it to my ISP, I have an email in to them to ask if they could install uniobjects and they are looking into it but I was wondering if they just put the dll somewhere I can reference it, if it would work (in case they say no). I may try creating a VM and trying it but I was hoping that someone on here would know if it would work or if it has to be installed. thanks dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects dll question
S... like I said, you don't need to install it on the client. If I add a reference to the UODOTNET.dll to the project references it includes the .dll on publish. Every time. Granted, I'm writing in VB not C#, so maybe things are different over there where the cool kids hang out. Tony Gravagno wrote: [many paragraphs of stuff snipped for brevity] Coming back to the original question for a moment, I think Doug might have wanted to know if you need to install the Client Library on a client PC just to get the UO DLL. The answer is no, you don't need that 110MB+ installer just for the one tiny DLL, and the licensing permits the DLL to be deployed with your solution. Regards, Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Signature Capture and use
I wrote a VB.net application which integrates with our Universe system via Uniobjects and store the signatures on a shared Windows server directory using the sample code which Topaz provides with their signature capture pads. We decided on the Topaz hardware because (Surprise!) it pretty cheap @ around $100 for their low end USB signature pad. http://www.topazsystems.com/ I'd be happy to share the source code if you're interested. Oaks, Harold wrote: I'm sure some of you are implementing signature pad capture to a Universe system. What are you using and doing? I'd like to look into adding that feature to our jail system. Thanks- Harold Oaks Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users . -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
You can create a custom format in Excel containing a zero mask of how ever many characters you like and that will preserve (well, actually replace the already stripped) leading zeros. Anthonys Lists wrote: With our phone numbers ... we are forced to use a database that exports to excel ... And if you don't put spaces and whatnot in phonenumbers to force excel to realise it's text, all your phone numbers have their leading zeroes stripped ... (I believe it's written by outside consultants, but the lady internal to the organisation who looks after it thinks it's wonderful. As a database programmer forced to use it, my opinion of it is unprintable ... I can't be too rude though because this lady is a good friend of and sort-of-boss-to my wife) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Would anyone else like a change to *HS.UPDFINFO?
That would be a nice feature. I do believe that it only processes files with a * or *SELECT dictionary item however. Gregor Scott wrote: I am trying to get Rocket to improve the behaviour of *HS.UPDFINFO to support active select lists so that only the files I want built into the .hs_fileinfo cache item (rather than have EVERY SINGLE F/Q-type item from the VOC included). Support inform me that I seem to be the only person interested in such a change, so I thought I would at least ask the question of the U2 community. Would anyone else find it useful to have the *HS.UPDFINFO command enhanced to support select lists, or have a new command created that deals with select lists? Thanks Gregor This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What tools do you use for data warehouse...
There is really no reason to export the data from Universe. When I created the data warehouse product for Eclipse we simply collected all the data from the various transaction files associated with a specific reporting function and wrote them out on demand for a given query to a flattened out Universe file specifically designed to accommodate reporting/SQL. For example all of the data pertaining to sales for a particular time period on a sales order line item by line item basis as records. One the data is in an SQL friendly normalized format (and perhaps even moved to a non-production server) all of the popular data warehouse reporting tools (Cognos, Pentaho, MS Business Intelligence, SAP Crystal Solutions, etc) can be used via ODBC to create your slice and dice graphical reporting. If you absolutely HAVE to export the data I would recommend the simplest possible solution, tab delimited flat files since pretty much any SQL database can import that. Tom Whitmore wrote: Hi, I was wondering what tools you use to export data to an SQL data warehouse from UniVerse. This export could occur on multiple flavors of Unix. What we would need to do is extract the UV data and perform some data translations before importing the data into the SQL table. I know at one point DataStage was a powerful but expensive tool that would accomplish this task. All suggestions are greatly appreciated! Tom Whitmore RATEX Business Solutions ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Refactoring Tools
*https://en.wikipedia.org/wiki/Code_refactoring Code refactoring is a disciplined technique for restructuring an existing body of code, altering its internal structure without changing its external behavior,[1] undertaken in order to improve some of the nonfunctional attributes of the software. Advantages include improved code readability and reduced complexity to improve the maintainability of the source code, as well as a more expressive internal architecture or object model to improve extensibility. My translation: Remove the spaghetti without changing functionality. *Wjhonson wrote: Perhaps by refactoring you mean just to make the code more consistent. Yes and no. Decompiling the object code, will enforce consistency, however at the expense of readability. -Original Message- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Sun, Apr 21, 2013 5:26 am Subject: [U2] Refactoring Tools Hi All I'm doing some intensive work with a large UniVerse site to assist them in migrating their 20 year old code base and working practices to full Agile, XP and TDD. They are really enthusiastic in embracing the modern world and making good progress, but there is a huge amount of legacy code to be cleaned up and test harnessed. So before I spend time possibly reinventing the wheel, does anyone know of any good refactoring tools for UniVerse Basic? Brian ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uvbackup linux command line - multiple specific files
I knew there had to be a way. Thanks Manu Perry. Manu Fernandes wrote: hey, Another method, put the list of files to backup into a textfile, use the -cmdfil param of uvbackup cmd. Manu Perry Taylor perry.tay...@zirmed.com a écrit : cd to the directory where the files live then... find -maxdepth 1 -name 'BUY.[ST]MF*' -print | uvbackup Should get 'em. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, April 17, 2013 1:51 PM To: U2-Users@listserver.u2ug.org Subject: [U2] uvbackup linux command line - multiple specific files Unix 'find' is failing me and I have not found documentation on specifically what I'm trying to do. I need to use uvbackup from the command line to back up 4 specific Universe files to one archive so they can be restored to a different platform without all the fnuxi stuff. I need to pick up the following files only. ./BUY.SMF ./BUY.TMF ./BUY.SMF.LAST ./BUY.TMF.FIND Help me Mr. uvbackupWizard! -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Any code share for Levenshtein distance
After a little digging: Pick Basic IF STRING1 = STRING2 THEN LD = 0 END ELSE S.LEN = LEN(STRING1) C.LEN = LEN(STRING2) MAT LD.MTX = '' DIM LD.MTX(100,100) FOR I = 3 TO S.LEN + 2 LD.MTX(I,1) = STRING1[I-2,1] NEXT I FOR I = 3 TO S.LEN + 2 LD.MTX(I,2) = I - 2 NEXT I FOR I = 3 TO C.LEN + 2 LD.MTX(1,I) = STRING2[I-2,1] NEXT I FOR I = 3 TO C.LEN + 2 LD.MTX(2,I) = I - 2 NEXT I FOR I = 3 TO (S.LEN+2) S.LETTER = LD.MTX(I,1) FOR J = 3 TO (C.LEN+2) C.LETTER = LD.MTX(1,J) IF C.LETTER = S.LETTER THEN COST = 0 ELSE COST = 1 P1 = LD.MTX(I-1,J) + 1 P2 = LD.MTX(I,J-1) + 1 P3 = LD.MTX(I-1,J-1) + COST IF P1 P2 THEN LD.NUM = P1 ELSE LD.NUM = P2 IF P3 P2 THEN LD.NUM = P3 LD.MTX(I,J) = LD.NUM NEXT J NEXT I LD = LD.MTX(S.LEN+2,C.LEN+2) END Wjhonson wrote: http://en.wikipedia.org/w/index.php?title=Levenshtein_distanceoldid=63073322 -Original Message- From: Baker Hughes baker.hug...@mouser.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Wed, Apr 17, 2013 10:39 am Subject: [U2] Any code share for Levenshtein distance Hi, Does anyone have any Basic code that implements the algorithm, Levenshtein distance? We are playing with words for a fraud detection project, trying discover bad guys better. TIA, -Baker Thanks for all the good discussions - I'm lurking and reading now and then. Others usually provide splendid answers. This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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 . -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Any code share for Levenshtein distance
Proper attribution: http://en.wikibooks.org/wiki/Algorithm_Implementation/Strings/Levenshtein_distance#Pick_Basic Wjhonson wrote: Note my link is to the page's ARCHIVE, which has about 20 different examples of code in various languages One of those should be better to trans into Pick BASIC, than the others. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Apr 17, 2013 10:52 am Subject: Re: [U2] Any code share for Levenshtein distance http://en.wikipedia.org/w/index.php?title=Levenshtein_distanceoldid=63073322 -Original Message- From: Baker Hughes baker.hug...@mouser.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Wed, Apr 17, 2013 10:39 am Subject: [U2] Any code share for Levenshtein distance Hi, Does anyone have any Basic code that implements the algorithm, Levenshtein distance? We are playing with words for a fraud detection project, trying discover bad guys better. TIA, -Baker Thanks for all the good discussions - I'm lurking and reading now and then. Others usually provide splendid answers. This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] uvbackup linux command line - multiple specific files
Unix 'find' is failing me and I have not found documentation on specifically what I'm trying to do. I need to use uvbackup from the command line to back up 4 specific Universe files to one archive so they can be restored to a different platform without all the fnuxi stuff. I need to pick up the following files only. ./BUY.SMF ./BUY.TMF ./BUY.SMF.LAST ./BUY.TMF.FIND Help me Mr. uvbackupWizard! -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using the PUT method in an HTTP connection in UniBasic
I use Curl for this sort of stuff. I have a generic http/https send/get routine you can get here: http://www.schasny.com/bp/HTTP.TRANSFER jim.sto...@esc.edu wrote: Hello everyone, We have been playing around with the UniBasic commands createRequest and submitRequest for use with some web services provided by our external vendors. Unfortunately, one of the web services requires updates to existing data records to be submitted using the PUT method, instead of POST. According to the UniBasic Commands Reference for both UniData 7.2 and 7.3, the PUT method appears to not be supported for the createRequest command. That struck me as a little odd, so just to be sure, we tried it and couldn't get it to work. Does anyone know of an alternative way to create http requests in UniBasic that would support the PUT method? We have UniData 7.2 running on HP-UX. Most of my programming experience is on other platforms, typically on Windows, so my normal solution to this problem would be to make use of Microsoft's WinHTTP object (or one of its equivalent siblings) to handle the http request. Is there a way to do something equivalent to that in UniBasic on HP-UX? Thanks in advance for any suggestions you can give me! Jim Stoner ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] ISO Date Format
Has anyone come up with an OCONV string that will product an ISO standard date (-MM-DD)? After a vendor insisted on this last week I ended up creating a subroutine called by an I descriptor but it seems like there should be an easier way. A quick trip through the Universe Basic manual, my old Prime Info-Basic manual, and Pick Basic: A programmer's guide didn't shed any light. -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ISO Date Format
I knew it had to be possible. Thanks Brian Leach wrote: D-YMD[4,2,2] -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: 11 March 2013 13:57 To: U2-Users@listserver.u2ug.org Subject: [U2] ISO Date Format Has anyone come up with an OCONV string that will product an ISO standard date (-MM-DD)? After a vendor insisted on this last week I ended up creating a subroutine called by an I descriptor but it seems like there should be an easier way. A quick trip through the Universe Basic manual, my old Prime Info-Basic manual, and Pick Basic: A programmer's guide didn't shed any light. -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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 . -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another silly job ad
That appears to be straight out of the new account setup dialog in Universe: cubs5a:/u1/local mkdir ttt cubs5a:/u1/local cd ttt cubs5a:/u1/local/ttt uv This directory is not set up for uniVerse. Would you like to set it up (Y/N)?Y 0. Ideal UniVerse compatibility 1. IN2 compatibility 2. Prime Information compatibility 3. PICK compatibility 4. PI/open compatibility 5. Microdata Reality compatibility Which way do you wish to configure your VOC ? Brian Leach wrote: i wonder if that includes the wonderful IN2 franglais and never knowing if a prompt needed a Y or an O. Those were the days... Sent from my iPad On 9 Mar 2013, at 13:21, Wjhonson wjhon...@aol.com wrote: http://jobview.monster.com/getjob.aspx?JobID=12003JDNJobDocument.JobID=68567260AdID=9418275ImpressionGuid=c9232410-cf9f-4fc4-9b86-d95482fc6304AffiliateGuid=88096a2b-ecd2-4480-aa16-55a154eae025CampaignID=Premium=RendererID=699code=unit=stracking=WT.mc_n=JDN03 Obviously since the company is moving from PI/Open to Universe you *must* have IN2 compatibility Bizarre. ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] fnuxi error
Universe 10.3.9 Linux (Red Hat) Anyone seen this before? [root@cubs6 CUB]# fnuxi TX.TMF Processing 'TX.TMF'. File 'TX.TMF' is an SQL file and may not be fnuxi'ed. More importantly what can I do to fix it? Thanks -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Epicor job near Denver
Their Eclipse Development group is in Broomfield, CO which would explain why they are looking for the combination of Java and Universe. Wjhonson wrote: http://www.dice.com/job/result/10170902/8005?src=19q=software%20developericidcnt=CT:AF If I'm reading it right this job is in Denver area (area code 303), but Epicor is based in Minneapolis ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [AD] FREE pick date conversion android app [/AD]
Brian, Brian (and Doug), I too have been using Basic4Android to make a some simple Android apps and I've posted some questions to the Basic4Android community about the inclusion of 3rd party libraries like Uniobjects for Java and really have not gotten a satisfactory answer, or at least one I understand (the answer was: yes we support 3rd party .jar libraries but you'll have to write a wrapper around it, to which I said wrapper?? and got no response). So my question is, do any or the other alternative VB like environments support the inclusion of Uniobjects for Java? Thanks Brian Leach wrote: Now there really IS an app for it ... :) PS if you want a VB-like way of building apps, also check out NS Basic. Simple and cool. (Neither of which are the first things to spring to mind about Titanium, which I use... the results are blistering but I always feel I'm running up-hill avoiding potholes) Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV: Generating XML from Retrieve
0007: PENDING_AUTHS : EX --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UD] Disabling/blocking ODBC
I believe both Universe and Unidata run ODBC via the standard UniRPC port 31438 unless you are running UniRPC on a different port. bradley.sch...@usbank.com wrote: We may need to figure out a way to disable ODBC access to UniData due to data access concerns. I've set up connections before, but have never approached ODBC from this perspective. I'm hoping there's a service we can turn off or a port we can block. One possible constraint is that we still need to be able to connect to UniData via DataStage. We use the native unidata connector, so I'm hoping that won't get in the way. Thoughts? UniData 7.1 AIX 5.3 TIA, Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly
The AIX errpt command reads the system error log. See man errpt for details. That would be a good place to start Kevin King wrote: We have a customer with a box as described in the subject that has recently been experiencing something odd. Overnight, the system will just lock up and stop responding. Normally there isn't anyone doing anything at night; the backup runs, that sort of thing, but then some days when they come in early in the morning the entire machine is unresponsive. Connecting with telnet there is no login prompt, just a blank screen. It happened last night and I've confirmed from the logs that the backup (which is using a split mirror backup strategy) ran successfully and finished at 2:02am. Sometime between then and 4am, when there really should not have been anything going on, it just locked up. Are there any logs that can be enabled on AIX to record some evidence for these kinds of failures so we can figure out what's going on with this machine? -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sleeping in Basic
Something I ran into with long ago in Universe with sleep/nap. Both use the current TIME() as the starting point (which is milliseconds since midnight) and then waits for your desired period. If your sleep/nap period rolls over midnight your process will hang because its waiting to count to a number it never gets to. Doug Farmer wrote: Wow, thanks of all of the responses. Unfortunately, none of them will seem to work on UniData. I will be using NAP on UniVerse. PAUSE and WAKE, I had not heard of. This is only on UniData so not a UniVerse option. It would seem to be a good way to go, except for if the phantom process aborts, the WAKE is never executed and the invoking process (UniObjects subroutine) hangs forever. David's openSocket suggestion does not wait at all if the socket can be opened. If it cannot (for example host name is bad), the timeout is sometimes much longer, probably due to DNS lookup of the bad host name. I tried these examples in the code below. The results are show below the code. When I run this, using NAP 250, I get 4 times the same, then another 4 times the same etc. This seems to show NAP 250 does sleep for a quarter of a second. Doing NAP 1 for 2000 iterations took 31 seconds. Probably due to overhead of setting up NAP 2000 times. The openSocket came right back all the time. Any other ideas, I am open to testing. Again, thanks for all of the responses! Doug Farmer 952-417-5225 Program Listing 0001 PRINT 'Nap 250' 0002 FOR IDX = 1 TO 20 0003 PRINT IDX R#2:' ':OCONV(TIME(),'MTS') 0004 NAP 250 0005 NEXT IDX 0006 PRINT 'Start of 2000' 0007 PRINT OCONV(TIME(),'MTS') 0008 FOR IDX = 1 TO 2000 0009 NAP 1 0010 NEXT IDX 0011 PRINT OCONV(TIME(),'MTS') 0012 PRINT 'DONE WITH 2000' 0013 PRINT 'Open Socket' 0014 FOR IDX = 1 TO 20 0015 SleepTime = 250 0016 ERR = openSocket('loopback',25,1,SleepTime,HBUFF) 0017 PRINT IDX R#2:' ':OCONV(TIME(),'MTS') 0018 NEXT IDX Output from Program Nap 250 1 09:11:29 2 09:11:29 3 09:11:29 4 09:11:30 5 09:11:30 6 09:11:30 7 09:11:30 8 09:11:31 9 09:11:31 10 09:11:31 11 09:11:31 12 09:11:32 13 09:11:32 14 09:11:32 15 09:11:32 16 09:11:33 17 09:11:33 18 09:11:33 19 09:11:33 20 09:11:34 Start of 2000 09:11:34 09:12:05 DONE WITH 2000 Open Socket 1 09:12:05 2 09:12:05 3 09:12:05 4 09:12:05 5 09:12:05 6 09:12:05 7 09:12:05 8 09:12:05 9 09:12:05 10 09:12:05 11 09:12:05 12 09:12:05 13 09:12:05 14 09:12:05 15 09:12:05 16 09:12:05 17 09:12:05 18 09:12:05 19 09:12:05 20 09:12:05 This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Eclipse ? was Job ad in Ardmore, PA
Accuterm/Wintegrate would not work with Eclipse. They have there own terminal emulator called Eterm. Wjhonson wrote: http://en.wikipedia.org/wiki/Intuit#Intuit_Eclipse Does Eclipse *require* the use of the Java client? Or is that optional? That is, can some users at one site, be using Accuterm / Wintegrate as dumb terminal emulators, while others are using the Java client? -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:34 am Subject: Re: [U2] Job ad in Ardmore, PA Oops Berean is the name of the recruiter or company The job is in Ardmore. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:33 am Subject: [U2] Job ad in Berean, PA http://www.ziprecruiter.com/job/Senior-Programmer-116879/546532a0/?source=cpc-simplyhired Interesting they are looking for a Programmer but you must have strong knowledge of Unix, but only intermediate knowledge of their actual application environment :) Silly rabbits. ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Eclipse ? was Job ad in Ardmore, PA
Clark wrote the original DOS version of Eterm. The windows version (the one in the video you linked to) was completely re-written from scratch in C (by Bill Weir) after he left the company. If you tried to run Eclipse without Eterm you would have a very scrambled screen. Eterm uses proprietary control sequences to do things like multiple overlapping windows and scrolling messages to name just a couple. Wjhonson wrote: Hmmm I've updated the Intuit page to show the links to Eterm. I see that Clark Yennie (apparently) claims to have written it himself. He is on LinkedIn, I wonder if he is still in the Pick world ? What would happen if you just tried to Telnet into the system *without* using Eterm ? -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 11:19 am Subject: Re: [U2] Eclipse ? was Job ad in Ardmore, PA Accuterm/Wintegrate would not work with Eclipse. They have there own terminal emulator called Eterm. Wjhonson wrote: http://en.wikipedia.org/wiki/Intuit#Intuit_Eclipse Does Eclipse *require* the use of the Java client? Or is that optional? That is, can some users at one site, be using Accuterm / Wintegrate as dumb terminal emulators, while others are using the Java client? -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:34 am Subject: Re: [U2] Job ad in Ardmore, PA Oops Berean is the name of the recruiter or company The job is in Ardmore. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:33 am Subject: [U2] Job ad in Berean, PA http://www.ziprecruiter.com/job/Senior-Programmer-116879/546532a0/?source=cpc-simplyhired Interesting they are looking for a Programmer but you must have strong knowledge of Unix, but only intermediate knowledge of their actual application environment :) Silly rabbits. ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Eclipse ? was Job ad in Ardmore, PA
Don, See my reply to Will's question. Eterm did a lot more than just emulate a Wyse 50. Don Robinson wrote: Jeff, Why? A terminal emulator is a terminal emulator Sounds like a needless restriction to me or does Eterm do more than emulate a termainl? Don From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Friday, December 28, 2012 2:15 PM Subject: Re: [U2] Eclipse ? was Job ad in Ardmore, PA Accuterm/Wintegrate would not work with Eclipse. They have there own terminal emulator called Eterm. Wjhonson wrote: http://en.wikipedia.org/wiki/Intuit#Intuit_Eclipse Does Eclipse *require* the use of the Java client? Or is that optional? That is, can some users at one site, be using Accuterm / Wintegrate as dumb terminal emulators, while others are using the Java client? -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:34 am Subject: Re: [U2] Job ad in Ardmore, PA Oops Berean is the name of the recruiter or company The job is in Ardmore. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:33 am Subject: [U2] Job ad in Berean, PA http://www.ziprecruiter.com/job/Senior-Programmer-116879/546532a0/?source=cpc-simplyhired Interesting they are looking for a Programmer but you must have strong knowledge of Unix, but only intermediate knowledge of their actual application environment :) Silly rabbits. ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Eclipse ? was Job ad in Ardmore, PA
That's funny. I think (it's been a few years) there is actually and option under the F2 System menu to reset ones password without resorting to shelling out. Also note all menu options availability are customizable in Eclipse on a user by user basis and the ability to shell out is generally very tightly controlled. Wjhonson wrote: Hmm here is a Youtube showing someone changing their password in Eterm http://www.youtube.com/watch?v=97g2kyeHl-s -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 11:19 am Subject: Re: [U2] Eclipse ? was Job ad in Ardmore, PA Accuterm/Wintegrate would not work with Eclipse. They have there own terminal emulator called Eterm. Wjhonson wrote: http://en.wikipedia.org/wiki/Intuit#Intuit_Eclipse Does Eclipse *require* the use of the Java client? Or is that optional? That is, can some users at one site, be using Accuterm / Wintegrate as dumb terminal emulators, while others are using the Java client? -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:34 am Subject: Re: [U2] Job ad in Ardmore, PA Oops Berean is the name of the recruiter or company The job is in Ardmore. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:33 am Subject: [U2] Job ad in Berean, PA http://www.ziprecruiter.com/job/Senior-Programmer-116879/546532a0/?source=cpc-simplyhired Interesting they are looking for a Programmer but you must have strong knowledge of Unix, but only intermediate knowledge of their actual application environment :) Silly rabbits. ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Eclipse ? was Job ad in Ardmore, PA
In the past actually. As you noted, the front end was completely re-written in Java. Wjhonson wrote: Oh my... I see an 18 million dollar rewrite boondoggle in their future. We can make it better, faster, rewritten in (hunts for the buzzword of the day) Ruby on Rails! Smithers: But wait chief that's not really a GUI Mr Burns: We'll rewrite that too! -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 12:47 pm Subject: Re: [U2] Eclipse ? was Job ad in Ardmore, PA Clark wrote the original DOS version of Eterm. The windows version (the one in the video you linked to) was completely re-written from scratch in C (by Bill Weir) after he left the company. If you tried to run Eclipse without Eterm you would have a very scrambled screen. Eterm uses proprietary control sequences to do things like multiple overlapping windows and scrolling messages to name just a couple. Wjhonson wrote: Hmmm I've updated the Intuit page to show the links to Eterm. I see that Clark Yennie (apparently) claims to have written it himself. He is on LinkedIn, I wonder if he is still in the Pick world ? What would happen if you just tried to Telnet into the system *without* using Eterm ? -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 11:19 am Subject: Re: [U2] Eclipse ? was Job ad in Ardmore, PA Accuterm/Wintegrate would not work with Eclipse. They have there own terminal emulator called Eterm. Wjhonson wrote: http://en.wikipedia.org/wiki/Intuit#Intuit_Eclipse Does Eclipse *require* the use of the Java client? Or is that optional? That is, can some users at one site, be using Accuterm / Wintegrate as dumb terminal emulators, while others are using the Java client? -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:34 am Subject: Re: [U2] Job ad in Ardmore, PA Oops Berean is the name of the recruiter or company The job is in Ardmore. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:33 am Subject: [U2] Job ad in Berean, PA http://www.ziprecruiter.com/job/Senior-Programmer-116879/546532a0/?source=cpc-simplyhired Interesting they are looking for a Programmer but you must have strong knowledge of Unix, but only intermediate knowledge of their actual application environment :) Silly rabbits. ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Eclipse ? was Job ad in Ardmore, PA
Last I knew you could still use both concurrently, but I left Eclipse in 2003. Wjhonson wrote: No I was asking *if* every customer is required, at every seat to use the Java component, or if that is optional, on a seat basis, or on a customer basis. Did they end of life Eterm ? -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 12:58 pm Subject: Re: [U2] Eclipse ? was Job ad in Ardmore, PA In the past actually. As you noted, the front end was completely re-written in Java. Wjhonson wrote: Oh my... I see an 18 million dollar rewrite boondoggle in their future. We can make it better, faster, rewritten in (hunts for the buzzword of the day) Ruby on Rails! Smithers: But wait chief that's not really a GUI Mr Burns: We'll rewrite that too! -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 12:47 pm Subject: Re: [U2] Eclipse ? was Job ad in Ardmore, PA Clark wrote the original DOS version of Eterm. The windows version (the one in the video you linked to) was completely re-written from scratch in C (by Bill Weir) after he left the company. If you tried to run Eclipse without Eterm you would have a very scrambled screen. Eterm uses proprietary control sequences to do things like multiple overlapping windows and scrolling messages to name just a couple. Wjhonson wrote: Hmmm I've updated the Intuit page to show the links to Eterm. I see that Clark Yennie (apparently) claims to have written it himself. He is on LinkedIn, I wonder if he is still in the Pick world ? What would happen if you just tried to Telnet into the system *without* using Eterm ? -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 11:19 am Subject: Re: [U2] Eclipse ? was Job ad in Ardmore, PA Accuterm/Wintegrate would not work with Eclipse. They have there own terminal emulator called Eterm. Wjhonson wrote: http://en.wikipedia.org/wiki/Intuit#Intuit_Eclipse Does Eclipse *require* the use of the Java client? Or is that optional? That is, can some users at one site, be using Accuterm / Wintegrate as dumb terminal emulators, while others are using the Java client? -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:34 am Subject: Re: [U2] Job ad in Ardmore, PA Oops Berean is the name of the recruiter or company The job is in Ardmore. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:33 am Subject: [U2] Job ad in Berean, PA http://www.ziprecruiter.com/job/Senior-Programmer-116879/546532a0/?source=cpc-simplyhired Interesting they are looking for a Programmer but you must have strong knowledge of Unix, but only intermediate knowledge of their actual application environment :) Silly rabbits. ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stripping line breaks from InfoTrieve output
Sounds like a job for the old AIX dd to me Colin Alfke wrote: When creating the file he would need to use WRITEBLK... :) The TO syntax will create an Aix file using the Aix linefeed char (10 or 13 - it's been a while). You will have to then have to join the lines together in the format required. It's whichever you find easiest - or is easier for the next guy to support Hth Colin -Original Message- From: Marc A Hilbert Sent: December 12, 2012 5:59 PM To: 'U2 Users List' Subject: Re: [U2] Stripping line breaks from InfoTrieve output Brad, I know nothing about infotrieve, but why can't you use OPENSEQ and then a READBLK loop? READBLK reads the next N bytes from a file, not caring if there are line delimiters of other strange characters. Regards, Marc -Mensaje original- De: bradley.sch...@usbank.com Enviado el: miércoles, 12 de diciembre de 2012 18:19 Para: U2 Users List Asunto: [U2] Stripping line breaks from InfoTrieve output I'm guessing it doesn't matter if this is UD or UV, but I have UD7.1 under AIX. We have a request to extract some data to what I call a tape file. The data is fixed length and there are no line breaks. Just one continuous stream of data. My thought is that this could be accomplished with an InfoTrieve using 'list TO' as in list AGREEMENT F1 F2 TO file.txt There is of course more to it than this, but if I can strip out whatever creates the line break, I think I can do what I need. So my question to the group is: what character(s) are create the new line when ouptutted from an InfoTrieve? Has anyone done this before? I'm thinking I'd used tr or sed to clean things up. Thanks Brad ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Advantage of indirect call in BASIC
Primos, much like it's predecessor Multics implemented a ring protection model. Here's a fair explanation: http://en.wikipedia.org/wiki/Ring_(computer_security) Wjhonson wrote: Why do you call it ring jump in particular? What's the ring ? -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Dec 4, 2012 4:07 pm Subject: Re: [U2] Advantage of indirect call in BASIC On 04/12/12 17:03, Wjhonson wrote: Ring-jump ? Vas is das It's when the processor jumps between restricted user mode, and kernel can do anything mode. Cheers, Wol ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Advantage of indirect call in BASIC
I'll second Allen Egerton's left over from Prime Information theory. I distinctly remember being told that indirect subroutine calls were measurably faster way back in my days at Prime. Wjhonson wrote: I've not encountered this is my career previously, but now I'm seeing a system written almost entirely with the use of indirect calls in Universe BASIC. That is SOURCE = *SOME.PROGRAM ... CALL @SOURCE(INPUTS) Is there some advantage to the use of indirect calls that a system would be written entirely in this fashion? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Advantage of indirect call in BASIC
Of course blindingly fast on a 4 MIPS 9955 is what we might now call quaintly tortoise like and that's why we still find things like the all indirect subroutine calls in an attempt to squeeze any available drop of performance out of applications. Wols Lists wrote: From my knowledge of Pr1me architecture (which isn't great) this was one of Pr1me's very strong points - the hardware/software subroutine call architecture was *extremely* fast. So much so that, clocktick for clocktick, it is probably STILL several times faster than the now-ubiquitous x86 architecture. Shame they haven't caught up :-( (I'm thinking particularly here of a ring-jump, but I think it was just blindingly fast regardless - linux goes to great efforts to avoid such jumps, Pr1mos didn't care...) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Loading a UNIX-based UNIDATA file system on a Windows system...
After loading the data on the Windows system you will have to run fnuxi (C:\u2\UV\bin\fnuxi) on each file you wish to access. I would suggest you do this as follows: - locate the directory where the Unidata files are loaded - run fnuxi on the VOC and D_VOC - drop into Unidata and create a listing of the files in the directory (LIST ONLY VOC WITH F1 = F) output to the hold file and copy the list from the hold file to the directory containing the Unidata files - using the editor of your choice prefix each line in the file tie c:\u2\UV\bin\fnuxi.exe and save it as a windows .bat file - run the batch file to convert all the files. - edit the batch file and change all the filenames to D_filename - run it again Robert wrote: I have a client that has a client's tape containing the file system from a UNIDATA system running under some form of Unix. They want to load it up on a Windows PC and using the Windows version of UNIDATA, retrieve file data. I have seen in the past that sometimes a file from one OS (like Unix) was not able to be read under a different OS (Windows). This happened once to me with a PKZIP file. There was something slightly different about the file headers or something like that. So the question is, what is the best way to load the data? Is there a conversion utility that you run AFTER you load the data to convert any file header differences? Or are the file headers compatible? Or...? Robert Norman ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What remote support product do YOU use?
We use LogMeIn with two factor authentication to satisfy PCI/DSS. The free IOS app is actually usable from my iPad and now that I have mobile hotspot enabled on my Droid Razr all I really have to haul around to be available 24/7 is the phone and tablet. Kind of nice after all these years of dragging a laptop everywhere I went. Ross Ferris wrote: Just posted this to the pick/multivalue Google group, but figure there may be some (larger?) U2 only people who may have valuable insight on the subject, so We have been using TeamViewer (www.teamviewer.com) for the past 18 months or so, and I'm generally very happy with it - I can access Windows, Linux apple hosts from my desktop, or even my iPhone (screen is too small for remote support so will be upgrading to a GalaxyNote 2 Phablet soon, so will have a chance to try out the Android client), and would be happy to recommend others looking for a solution (quote coupon code 95051-42-600991 to get a 3% discount) We had previously used LogMeIn, RDP for server access, and/or even VNC if we had VPN access, but TeamViewer just works for us. Licencing is one off, based on number of people our end that will be running concurrent sessions to clients, rather than paying per client system, and I keep toying with the idea of integrating with Visage as a Support button. We also use TeamViewer to run presentations, though I tend to use Skype rather than integrated VOIP capabilities That said, I'm also curious if anyone has a better product they have used (first hand, rather than just something they have read about which sounded good), and/or especially if you had previously had a commercial TeamViewer licence moved on. Hoping for confirmation of our choice, but happy to have my horizons expanded :-) Ross Ferris Stamina Software Visage Better by Design! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Consuming web services
I know we have both the SOAP and RESTful web services development for publishing web services from Universe but how are folks consuming other peoples web services into the database? Are there tools for this or am I going to just open a socket, read, and parse 'till I'm blue in the face? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows]
I'll second this one. It's exactly what group policies are for. And it doesn't require loading anything on the workstations. Marc Harbeson wrote: i would set it with a GPO instead of visiting each and every pc... On Thu, Sep 27, 2012 at 12:24 PM, Wjhonson wjhon...@aol.com wrote: I'm not saying there is no solution. I'm saying we have 1500 PCs It doesn't make me giddy to think this is the default setting on newly installed PCs Nor that having it, makes telnet sessions self-destruct, perhaps in the middle of a nightly job for which they must absolutely *not* self-destruct :) Come to think of it, it explains two other issues we been having intermittently. This doesn't only affect one PC, it affects all of them :) Really our guys should visit every PC in the org, one-by-one, either virtually or in person to reset this. -Original Message- From: Glen Batchelor webmas...@all-spec.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 27, 2012 9:18 am Subject: Re: [U2] [Windows] Change your power settings in windows to not allow the PC to go into sleep mode. Enable monitor power-off and disk power-off only. I have never trusted suspend and resume on Windows. On 9/27/2012 12:11 PM, Wjhonson wrote: OK so with the KeepAlive box checked in the Accuterm session, and with a Loop-On running in the session (on the remote Universe host) printing the time to my screen every five minutes The session was disconnected after three hours. So that's when the PC went to sleep ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Glen Batchelor IT Director/CIO/CTO All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: glen.batche...@all-spec.com Web: http://www.all-spec.com Mobile: http://m.all-spec.com Blog: http://blog.all-spec.com 24-hour Automated Voice Response. Get order status and tracking information 24-hours a day from any touch-tone phone. Call now: 877.404.6165 [910.550.2220] (you will need your 6-digit order# and the ship-to postal code of that order) D U Txt? Get order and tracking info via SMS/Text. Add your mobile# to MyAccount to activate. Text your 6-digit order# to 910.550.2220 to get order status. Text track, space and your 6-digit order# to 910.550.2220 for latest tracking info. ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multivalue Work In South Dakota
They may be referring to the Williston Basin oil boom, in which case they do need many people, just not IT types: http://www.epmag.com/item/Williston-Basin-Oil-Boom-Gains-Momentum_95509 Charlie Noah wrote: I saw a TV news piece this morning saying that South Dakota was in dire need of employees in many fields, including IT. I started searching, and haven't been able to find any multivalue companies in SD, much less jobs. Am I looking in the wrong places? Thanks, Charlie Tiny Bear's Wild Bird Store Everything For The Backyard Bird Enthusiast, Except For The Birds http://www.TinyBearWildBirdStore.com Toll Free: 1-855-TinyBear (855-846-9232) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [U2[UV] @TIME and TIME() not reliable
if I recall correctly @TIME returns the time that the program began running, TIME() returns the current time. Jacques G. wrote: Hello, Has anyone else here observed this behavior for Universe 11.1.3 on a OS other than HP-UX ? Sometimes, @TIME will report an incorrect internal time. When I first observed this behavior, I changed my use of @TIME for a call to TIME(). It fixed the problem on one HP-UX server I was working on, but when I installed the program on a different HP-UX server, TIME() now sometimes reported an incorrect internal time. For example, it was around 6:00 am but the time reported was for about 4:00 am. I fixed the problem on that server by replacing TIME() by ICONVS(TIMEDATE()[1,8],MTS) We have a setup for temporary locks that expire after a given time these temporary locks were being created as already expired. It's a problem when a server can't determine the correct internal time. Thanks Jacques G. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows]
netstat -f Wjhonson wrote: When a remote PC, asks the Windows server to open a Telnet session, Windows assigns a Process ID to that request. While the telnet session is open,that Process ID will appear in the Windows Task Manager. Is there a way to tell, WHO ask for that Telnet session to be opened? That is, the name of the remote PC, Foreign Address, Mac Address, IP or something of that sort that identifies the requestor/asker ? This has to be done *outside of* Universe, not inside it, for a particular reason. Anyone know the answer? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows]
yes there is: NETSTAT [-a] [-b] [-e] [-f] [-n] [-o] [-p proto] [-r] [-s] [-t] [interval] -aDisplays all connections and listening ports. -bDisplays the executable involved in creating each connection or listening port. In some cases well-known executables host multiple independent components, and in these cases the sequence of components involved in creating the connection or listening port is displayed. In this case the executable name is in [] at the bottom, on top is the component it called, and so forth until TCP/IP was reached. Note that this option can be time-consuming and will fail unless you have sufficient permissions. -eDisplays Ethernet statistics. This may be combined with the -s option. -fDisplays Fully Qualified Domain Names (FQDN) for foreign addresses. -nDisplays addresses and port numbers in numerical form. -oDisplays the owning process ID associated with each connection. -p proto Shows connections for the protocol specified by proto; proto may be any of: TCP, UDP, TCPv6, or UDPv6. If used with the -s option to display per-protocol statistics, proto may be any of: IP, IPv6, ICMP, ICMPv6, TCP, TCPv6, UDP, or UDPv6. -rDisplays the routing table. -sDisplays per-protocol statistics. By default, statistics are shown for IP, IPv6, ICMP, ICMPv6, TCP, TCPv6, UDP, and UDPv6; the -p option may be used to specify a subset of the default. -tDisplays the current connection offload state. interval Redisplays selected statistics, pausing interval seconds between each display. Press CTRL+C to stop redisplaying statistics. If omitted, netstat will print the current configuration information once. Wjhonson wrote: There is no -f option on netstat -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 6, 2012 12:15 pm Subject: Re: [U2] [Windows] netstat -f Wjhonson wrote: When a remote PC, asks the Windows server to open a Telnet session, Windows assigns a Process ID to that request. While the telnet session is open,that Process ID will appear in the Windows Task Manager. Is there a way to tell, WHO ask for that Telnet session to be opened? That is, the name of the remote PC, Foreign Address, Mac Address, IP or something of that sort that identifies the requestor/asker ? This has to be done *outside of* Universe, not inside it, for a particular reason. Anyone know the answer? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows]
Oh yeah, and your welcome, asshat. Wjhonson wrote: There is no -f option on netstat -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 6, 2012 12:15 pm Subject: Re: [U2] [Windows] netstat -f Wjhonson wrote: When a remote PC, asks the Windows server to open a Telnet session, Windows assigns a Process ID to that request. While the telnet session is open,that Process ID will appear in the Windows Task Manager. Is there a way to tell, WHO ask for that Telnet session to be opened? That is, the name of the remote PC, Foreign Address, Mac Address, IP or something of that sort that identifies the requestor/asker ? This has to be done *outside of* Universe, not inside it, for a particular reason. Anyone know the answer? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows]
Really kills you to not have the last word doesn't it. Sort of like a petulant 12 year old. Wjhonson wrote: Uh for a solution that ignored what I wanted? Yeah... uh.. thanks for not answering my question. -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 6, 2012 3:21 pm Subject: Re: [U2] [Windows] Oh yeah, and your welcome, asshat. Wjhonson wrote: There is no -f option on netstat -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 6, 2012 12:15 pm Subject: Re: [U2] [Windows] netstat -f Wjhonson wrote: When a remote PC, asks the Windows server to open a Telnet session, Windows assigns a Process ID to that request. While the telnet session is open,that Process ID will appear in the Windows Task Manager. Is there a way to tell, WHO ask for that Telnet session to be opened? That is, the name of the remote PC, Foreign Address, Mac Address, IP or something of that sort that identifies the requestor/asker ? This has to be done *outside of* Universe, not inside it, for a particular reason. Anyone know the answer? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
You seem to be missing a TO clause Eric Malmberg wrote: I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] RESIZE - dynamic files
size of record data .. 258687736 bytes Total size of record IDs ... 19283300 bytes Unused space ... 171626404 bytes Total space for records 449597440 bytes -- 258,687,736 bytes - Total size of record data 19,283,300 bytes - Total size of record IDs === 277,971,036 bytes (record + id's) 277,971,036 / 4,084 = 68,063 bytes (minimum modulus) -- 68,063 is less than the current modulus of 82,850. Something with this formula doesn't seem right because if I use that formula I always calculate a minimum modulus of less than the current modulus. Thanks, Chris Date: Mon, 2 Jul 2012 16:08:16 -0600 From: dave...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] RESIZE - dynamic files Hi Chris: You cannot get away with not resizing dynamic files in my experience. The files do not split and merge like we are led to believe. The separator is not used on dynamic files. Your Universe file is badly sized. The math below will get you reasonably file size. Let's do the math: 258687736 (Record Size) 192283300 (Key Size) 450,971,036 (Data and Key Size) 4096 (Group Size) - 12 (32 Bit Overhead) 4084 Usable Space 450971036/4084 = Minimum Modulo 110424 (Prime is 110431) [ad] I hate doing this math all of the time. I have a reasonably priced resize program called XLr8Resizer for $99.00 to do this for me. [/ad] Regards, Doug www.u2logic.com/tools.html XLr8Resizer for the rest of us ___ 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 ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem running script from crontab
Are you running it at the command line as the same user that it runs under in cron? charles_shaf...@ntn-bower.com wrote: Having a problem running a Unix script from the crontab. We use Redhat and Unidata 7.1 This script runs fine from command line UDTHOME=/NTN/CMI export UDTHOME UDTBIN=/usr/ud/bin export UDTBIN CMIHOME=/NTN/CMI/TRANS4M export CMIHOME PATH=$PATH:@UDTBIN export PATH cd /NTN/DATA/PRODUCTION $UDTBIN/udt PHANTOM REQIMPORT_MA But when it is run by the cron it doesn't seem to run. We do a lot of this sort of thing here, but I have never tried running a script that used a PHANTOM command like this. Does anyone see anything obvious here that would not let this run from cron? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Runaway Jobs
UV cron jobs don't need to be launched as phantoms. This shell script, and many more like it, have been running here from cron each morning for years: cubs5a:/u1/local more loh.rpt.ksh # !/bin/ksh cd /u1/local /dbms/uv/bin/uv RUN.LOW.ON.HAND exit 0 CT VOC RUN.LOW.ON.HAND RUN.LOW.ON.HAND 0001 V 0002 *local*RUN.LOW.ON.HAND 0003 B 0004 BN ED BP RUN.LOW.ON.HAND 21 lines long. : P 0001: * 0002: * runs daily low on hand report and emails results 0003: * j.a.schasny 0004: * 12/03/2009 0005: * 0006: OPEN 'CONTROL' TO CONTROL.FILE ELSE STOP 'CONTROL' 0007: 0008: READ CONTROL.REC FROM CONTROL.FILE,'RUN.LOW.ON.HAND' ELSE STOP 'REA D FAILED' 0009: EXECUTE LOW.ON.HAND.RPT 0010: 0011: * EXECUTE 'SH -C /u1/local/hold/convert.ss.ksh LOW.ON.HAND.txt' 0012: 0013: VALS = DCOUNT(CONTROL.REC,@FM) 0014: SUBJ = 'Daily Low On Hand Report' 0015: ATTACH.PATH = '/u1/local/hold/LOW.ON.HAND.txt' 0016: FOR NDX = 1 TO VALS 0017: TO.ADDRESS = CONTROL.RECNDX 0018: CALL EMAIL.REPORT(SUBJ,ATTACH.PATH,TO.ADDRESS) 0019: NEXT NDX 0020: 0021: END Bottom at line 21. : CT VOC LOW.ON.HAND.RPT LOW.ON.HAND.RPT 0001 PA 0002 SETPTR 0,132,6000,0,0,3,BANNER LOW.ON.HAND.txt,NFMT,NHEAD,BRIEF 0003 SELECT GM.SMF_ 0004 WITH STORE = 1_ 0005 AND WITH USER.REFERENCE1.CUBS NE DO NOT REORDER_ 0006 AND WITH USER.REFERENCE1.CUBS UNLIKE ...DNR..._ 0007 AND WITH TOTAL.QTY.CUBS LE 10_ 0008 AND WITH CLASS.CUBS NE 0009 LIST GM.SMF_ 0010 CLASS.CUBS_ 0011 SKU_ 0012 UCOLB.DESC.CUBS_ 0013 ON.HAND.QTY_ 0014 ON.ORDER.QTY_ 0015 TOTAL.QTY.CUBS_ 0016 ON.WEB.CUBS_ 0017 ID.SUP_ 0018 BY TOTAL.QTY.CUBS_ 0019 HEADING LOW ON HAND REPORT FOR 'TL'_ 0020 LPTR 0021 SET.ITHP OBTW - note the explicit exit 0 in the shell script. I've seen random strange things happen when those are not present. John Hester wrote: Are you launching the UD programs via the PHANTOM command? I don't know if this applies to UD, but UV cron jobs must be launched as phantoms. If the programs are executed from cron as non-phantoms, any jobs that overlap in time will use the same shared memory segment, and chaos will ensue. Our UV cron scripts typically look like something this: #!/bin/sh UV=`cat /.uvhome`/bin/uv cd /uvdata/LIVE.ACCOUNT $UV PHANTOM UV.PROGRAM -John -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Serial to Ethernet device from Mettler Scale to Unidata/Universe
I have not communicated with the type of device you are thinking of using but I would suggest that if there is no specific reason to connect to the scale via Ethernet you could hook it to your Unix box serially and read/write via the !ASYNC (aka !AMLC) subroutine. Ahh the joys of serial communication. George Hammerle wrote: Hello, Has anyone used a Serial to Ethernet Device between a Mettler Scale ( PS60 ) and their Unidata / Universe System? We are running Unidata on a Unix machine. What I would like to do is network a scale in our receiving department. The Serial to Ethernet device would be set up as a server. The Unidata Unix machine would connect via a socket to the Serial to Ethernet device, pass W* to the Mettler Scale ( give me the weight ), the scale would then pass back the weight through the Serial to Ethernet device. If someone has done this and can provide any feedback, that would be spectacular. And if you know of a serial to Ethernet device that works well, please let me know. George Hammerle zhammerle@hubertREMOVE_THIS.com This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or company to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and delete this e-mail including all attachments from your system. Thank you ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Serial to Ethernet device from Mettler Scale to Unidata/Universe
That's why I asked. For all we know it could also be 10 feet away. Robert Porter wrote: There are lots of reasons... How far is the device?We span an 11 floor set of buildings where the UV box is, plus 3 dozens other buildings across a radius of upwards of 100 miles. With serial the farther you go, the slower you have to set it. Or are you going to put in short hauls to get overt distance/speed limits? How about cabling costs? When they want to move the scale, you're going to pay to move the point to point cable again? Ethernet drops tend to be everywhere. The most that has to happen is an IP change. When it doesn't work, then what... cable itself? Connector? With a serial over ethernet, I instantly know if the device server is up and running. A potential problem is localized to at the device. Plus I get to use the included full hardware control cables - off the shelf not custom made. So I've got access to DTR, DSR, CTS, etc. signals. They're molded so I don't generally worry about them breaking. And if I ever suspected one was, I'd grab another and swap it out. Moving away from PtoP serial drops was one of the smartest moves we ever made. To the OP: Digi's are nice (use some for fax modems)... I'd also suggest Lantronix as an alternative. Specifically the UDS-1100 for single port or UDS-2100 for a 2 port. They run about $125 $175 respectively. They are rock solid. In a dozen years, I can could the failed devices on one hand. Robert Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. Jeff Schasny jscha...@gmail.com 5/4/2012 8:38 AM I have not communicated with the type of device you are thinking of using but I would suggest that if there is no specific reason to connect to the scale via Ethernet you could hook it to your Unix box serially and read/write via the !ASYNC (aka !AMLC) subroutine. Ahh the joys of serial communication. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job: Hampshire College
We have an opening and someone with good U2 skills could certainly be an asset (*unidata preferred*). Emphasis Mine. Seems pretty specific to me. Wjhonson wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing in Unidata ? -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job: Hampshire College
I was going to write a polite well structured response pointing out that Colleague is a special skill set above and beyond U2 but you know what, for my own personal satisfaction and that of the whole group, Shut the fuck up Will. Wjhonson wrote: To this list. Then the job description ITSELF does not mention Unidata whatsoever. To me that says that posting this job anywhere other than this list, for example Dice or Monster is NOT going to mention Unidata Since it's not going to say Hi I'm Jeff Butera chatting here and I'm going to make an offhand remark and THEN post the specific job description. The specific job description itself, without Jeff's offhand starting remark does NOT mention Unidata. It's practically blasphemy. -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:33 pm Subject: Re: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be n asset (*unidata preferred*). Emphasis Mine. Seems pretty specific to me. Wjhonson wrote: Your ad doesn't even mention U2 (Universe or Unidata) You're assuming that Colleague will show up in searches for job seekers typing n Unidata ? -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Apr 25, 2012 2:14 pm Subject: [U2] Job: Hampshire College We have an opening and someone with good U2 skills could certainly be an sset (unidata preferred). While academia can't always compete dollar-for-dollar with those of you n industry, we offer a competitive salary for this market and great enefits (4 weeks paid vacation from day 1, among others). ttps://jobs.hampshire.edu/index.cgi?JA_m=JASDETJA_s=164 ampshire College, an independent, innovative liberal arts institution nd member of the Five College consortium in Amherst Massachusetts, is ccepting applications for a Database Systems Developer in its nformation Technology Department. The Database Systems Developer is the lead developer and administrator roviding a variety of technical and user support for the college’s olleague administrative computing system; develops programs to augment endor-supplied software; and enhance web-based services. This position nalyzes, develops, implements and documents custom administrative oftware enhancements, and supports end-users by creating ad-hoc reports nd providing application training. The developer creates new pplications, determines user needs, and implements efficient solutions o end-user concerns, questions and problems. A bachelor's degree in Computer Science is required with emphasis in nformation systems and software design or equivalent training and xperience. Application programming and analysis experience in the esign, development and implementation of administrative application unctions such as Finance, Human Resources, Student and Academic records nd Development or equivalent systems highly desirable. Five years of xperience with at least one relational database, using a query language nd with several programming languages, especially BASIC, is also equired. Previous experience with Colleague highly desirable. Prior web rogramming experience, knowledge of Java, PERL, Python or PHP, and xperience with MySQL also desirable. This full time, 12 month position begins July 2, 2012. We offer a ompetitive salary and excellent benefits program. Please submit your over letter, resume and names/phone numbers of three professional eferences via our website at http://jobs.hampshire.edu -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BETWEEN operator
A point? It's Will... ;-) Seriously though, this points out yet again, one of the best parts of our common U2 and associated environments. There are almost always multiple ways of skinning the proverbial cat. Often one's approach is based on what 'flavor' you are most familiar with. I know I'm an old school Prime Information guy (my copy statement has only one carriage return) so my solution almost never includes a proc or a correlative. Allen Egerton wrote: So what was/is your point? 'cause I'm like the other Allen, sitting here wondering what it is that you're asking or responding to... On 4/17/2012 9:08 PM, Wjhonson wrote: There is no question. -Original Message- From: Allen Elwood RR aelw...@socal.rr.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Apr 17, 2012 6:01 pm Subject: Re: [U2] BETWEEN operator did u hit send b4 the question? On 4/17/2012 5:46 PM, Wjhonson wrote: Pick BASIC IF MYVALUE 9 AND MYVALUE 20 THEN... or IF 9 MYVALUE 20 THEN ... or IF BETWEEN(MYVALUE,9,20) THEN ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DOS /c and the HOLD file
I generally create a symbolic link to HOLD called hold in my Universe account directories to avoid the effects of the evil ampersands. Wols Lists wrote: Just a quickie - I'm trying to run a command and pass a pathname to the HOLD file DOS /c 'pcl6 -sOutputFile=HOLD\PO.pdf HOLD\PO.pcl' I can't work out how to get dos to handle the properly - everything seems to work perfectly until I put an into the command. Seeing as it's a print file I've just created with a mode 3 setptr and LIST LPTR, I really don't want to struggle to move everything around. That said, I might be better off writing a basic program to move it to UFD and working on it from there :-( Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Monitoring a U2 server?
I have used Nagios for monitoring systems.networks very successfully. You can monitor your entire network from a single point and go from things as simple as 'is this thing pingable' to has the disk space on drive X changed by more than 10%' or Are the following list of services available on this machine. Oh, and did I mention it's free. Rutherford, Marc wrote: I have a request to help setup a monitoring process for Unidata on HP-UX. So far the outside tools have not been specified, but will most likely be MS Windows based. I am looking for any examples/documentation on what can be done to provide visibility into system status. Has anyone done something similar before? What Unidata and/or HP manuals should I look for? Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2U 2012 Denver Registration Open
Do we have an ETA on the sessions list yet? Daniel McGrath wrote: U2 University 2012 - Denver Registration is now open! Visit: http://u2u.rocketsoftware.com/ May 8-10, 2012. Mark your calendar. Get set. GO! Registration in UK and AUS coming soon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2U 2012 Denver Registration Open
I dont see a list of sessions anywhere. Is one available? Daniel McGrath wrote: U2 University 2012 - Denver Registration is now open! Visit: http://u2u.rocketsoftware.com/ May 8-10, 2012. Mark your calendar. Get set. GO! Registration in UK and AUS coming soon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Hello
I'm afraid we're all quite dead. Haven't you heard about the zombies? u2ug wrote: Is the list alive ? Haven't seen anything for a week. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] keeping track of opened files
-- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe's DOS command
@listserver.u2ug.org Sent: Wed, Feb 15, 2012 1:00 pm Subject: Re: [U2] Universe's DOS command They actually do document these. Go to a command prompt and type: cmd /? Or help cmd (Both produce the same output) Enjoy! -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: February-15-12 11:00 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] Universe's DOS command h... My... God mazing try DOS /C DIR hen try DOS /K DIR how come they don't document this and we have to make guesses? -Original Message- rom: Bob Rasmussen r...@anzio.com o: U2 Users List u2-users@listserver.u2ug.org ent: Wed, Feb 15, 2012 10:38 am ubject: Re: [U2] Universe's DOS command n educated guess would be that the DOS command invokes the command rocessor ommand.com in long-ago Windows, cmd.exe now) and passes the \c (or is it /c?) to it. f in Windows you open a CMD prompt, and type cmd /? u can see what options it accepts. My output includes: /C Carries out the command specified by string and then terminates urther down the help display, it gives more information. n Wed, 15 Feb 2012, Wjhonson wrote: The DOS command in Universe takes a /c argument and then you can specify a t le like DOS \c test.bat What does \c mean? Are there other arguments like \z r \x that it can take? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users egards, ..Bob Rasmussen, President, Rasmussen Software, Inc. ersonal e-mail: r...@anzio.com ompany e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com treet address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Passing by Value
Hear Hear! If you don't like being called a troll, don't be a troll. Woodward, Bob wrote: And yet I agree with him, too. You take advantage of the generosity of the folks on this list with what appears to be a main motivation of stirring up a conversation just for the sake of seeing how many different directions you can twist things. Your statement that Tony's comments are unprofessional has a ring of a reflected image in a mirror. If you want things to be professional, ask specific, detailed questions and forget the endless array of hypothetical variations that MAY happen one time out of a thousand forever's. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, January 27, 2012 10:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Passing by Value Tony your comments are unprofessional. -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Jan 27, 2012 10:13 am Subject: Re: [U2] Passing by Value I recognized Will's troll from his first post and was tempted to omment but thought that would just stir up more OT discussion. nd yet it continues anyway. Don't you guys recognize the pattern here? He'll keep changing he scenario, adding road blocks and confusing arguments that ake proposals seem inadequate, and then he won't accept common nswers anyway. You guys have been generously providing feedback o an enquiry that's not going anywhere. He's just stirring the ot. He does this all the time. Look back on prior threads if ou're not seeing it yet. T No - I thought we were talking about creating a **NEW** counter variable in a large old program, call it xx1 do a search on xx1 no lines, then use it. ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Adding UniObjects for Jave to a Netbeans project
After a couple days of reading, searching and trying various combinations I've come up blank. Can someone tell me exactly what I need to do to add Uniobjects for Java to a project in the NetBeans IDE? Thanks -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Adding UniObjects for Jave to a Netbeans project
No problem, and thanks, that was exactly what I needed. Daniel McGrath wrote: Sorry Jeff, I was talking to a John but a few moments ago. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Monday, January 23, 2012 11:53 AM To: U2 Users List Subject: Re: [U2] Adding UniObjects for Jave to a Netbeans project Hi John, I did this myself last month. IIRC I had to make sure that Netbeans (and CLASSPATH environment var) as set correctly to find the asjava.zip file in the UOJSDK directory. Once that is don't, you need to add UniObjects into the references of the project. For an example of where this has already been done, I setup a NetBeans project to do Unit Testing via JUNIT in Netbeans in the opensource UniBasic Code Coverage project. http://sourceforge.net/projects/ucov/ Have a look in the Testing/Unit directory. Hope it helps. Regards, Dan McGrath U2 Product Manager Rocket Software -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Monday, January 23, 2012 11:02 AM To: U2 Users List Subject: [U2] Adding UniObjects for Jave to a Netbeans project After a couple days of reading, searching and trying various combinations I've come up blank. Can someone tell me exactly what I need to do to add Uniobjects for Java to a project in the NetBeans IDE? Thanks -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I-Type question in PH
FIELD(@ID,'_',3) 2 is the time 3 is the date John Thompson wrote: So I thought I would build an I-type to get the date of the PH items in Universe so I could more easily purge them... The item id looks like so: AUTOMATED.UPDATE.REO_23400_15641 The friendly manual says that the item id is: phantomverb_time_date So my I-type looks like so: 001 I 002 FIELD(@ID,'_',2) 003 004 Date 005 10 006 R And of course, I have not put in the conversion code yet... The output of the I-type is this: ID.. Date.. AUTOMATED.UPDATE.REO_23400_15641 23400.0 What am I missing? Shouldn't Date be 15641? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Uvbackup core dumps
Universe 10.3.9 on AIX 5.3 I was testing the use of uvbackup to back up our production data (we currently use a combination of rsync tar) for transfer to a Linux off site backup machine using this shell script: today=$(date +%Y +%m +%d) cd /vr find * -print | uvbackup -f -limit 1 -l Full Backup - /vrbkup/uvb$today date and at some point it failed with the following: Abnormal termination of UniVerse. Fault type is 11. Layer type is Command Language. ./test.sh[6]: 733396 Segmentation fault(coredump) Sun Nov 6 12:44:29 MST 2011 Anyone have an idea what might have caused this?? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uvbackup core dumps
Excellent. I'll try that. Thanks Perry Taylor wrote: As a suggestion add the -v option so you can see what file it was backing up when it fails. Perhaps you have broken file that uvbackup cannot tolerate. ??? Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Monday, November 07, 2011 7:28 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Uvbackup core dumps Universe 10.3.9 on AIX 5.3 I was testing the use of uvbackup to back up our production data (we currently use a combination of rsync tar) for transfer to a Linux off site backup machine using this shell script: today=$(date +%Y +%m +%d) cd /vr find * -print | uvbackup -f -limit 1 -l Full Backup - /vrbkup/uvb$today date and at some point it failed with the following: Abnormal termination of UniVerse. Fault type is 11. Layer type is Command Language. ./test.sh[6]: 733396 Segmentation fault(coredump) Sun Nov 6 12:44:29 MST 2011 Anyone have an idea what might have caused this?? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uvbackup core dumps
cubs5a:/vrbkup ulimit unlimited Michael Pflugfelder wrote: What is your ulimit before running the command? It's possible that you're trying to create a file that is larger than what Unix will allow you to create. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Monday, November 07, 2011 9:28 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Uvbackup core dumps Universe 10.3.9 on AIX 5.3 I was testing the use of uvbackup to back up our production data (we currently use a combination of rsync tar) for transfer to a Linux off site backup machine using this shell script: today=$(date +%Y +%m +%d) cd /vr find * -print | uvbackup -f -limit 1 -l Full Backup - /vrbkup/uvb$today date and at some point it failed with the following: Abnormal termination of UniVerse. Fault type is 11. Layer type is Command Language. ./test.sh[6]: 733396 Segmentation fault(coredump) Sun Nov 6 12:44:29 MST 2011 Anyone have an idea what might have caused this?? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata AIX commands for commands like LIST.READU and LIST.QUEUE?
Kevin, Yeah, ps # PORT.STATUS. Note to self, don't type before thinking. I can't say for sure about Unidata but for Universe there is a port.status and a list_readu command in uv/bin that can be executed from AIX. As a final resort you can execute universe commands from AIX using the uv COMMAND.NAME syntax. Just be sure you are in an account that drops you directly to a TCL prompt. Kevin King wrote: My apologies on the LLOCKS; Steve's right, that's a Prelude-ism. And while I could write a script to start up udt, the problem here is that if all of the udt licenses are in use, there's no way to get this kind of information in AIX to figure out what might be going on with the system (i.e. a deadlock). And PORT.STATUS is definitely not the same as ps; while both have their place, I'm not entirely certain how I would get the CALL.STACK option from PORT.STATUS out of ps. Jeff, if you have a solution for that one, I'm all ears. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] HP UX to IBM AIX questions
Both AIX and HP-UX are System V derivatives so the command structure is as close to the same as any two Unix environments. Uvbackup/Uvrestore should take care of any endian problems for both data and programs. If I've been told that Universe licenses are transferable between operating systems. Unless your directory structures are identical on the 2 machines you will probably have to rebuild indexes. You'll have to recreate all your unix spool queues and if I remember correctly (it been a while since I've been around HP-UX) the spooler setup procedures are different than AIX. I've never done an operating system move with U2 that didn't have something bite me at least a little but this one should be much easier than say HP-UX to Windows. Lunt, Bruce wrote: Hi All We are considering going from our HP 9000 systems to IBM AIX. What has to be done to make that happen? Do we need to recompile our source code? Are there any licensing issues? Is the data transportable or do we need to massage it? What about the dict items? Any other gotcha's? Is this an easy or difficult? Thanks, Bruce Lunt ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata AIX commands for commands like LIST.READU and LIST.QUEUE?
ps would be PORT.STATUS. Try man ps for the billions of options. Kevin King wrote: Are there AIX equivalent commands for the following Unidata TCL commands: PORT.STATUS LIST.READU LIST.QUEUE LLOCKS Also, is there any AIX command that will show that a particular telnet session is no longer active (i.e. user X'd out incorrectly or network dropped them)? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FAST (File Analysis and Sizing Tool)
-- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] network drives
If the uvconfig parameter ALLOWNFS is set you yes you can do this, however there will be no support for record locking. If you need record locking then you will want to get UVNet which is a separately chargeable product. Wjhonson wrote: Can Universe point at other computer and their drives on the Windows network? //server1 running Universe //server2 running something else Universe basic program EXECUTE COPY FROM server2.file.pointer to myfile Is this possible? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] DataVu Query and other delights
Just wanted to let everyone know that thanks to Mike Rajkowski and Dan McGrath I've been able to get a query executed in DataVu. It apparently does not like a D type dictionary item pointing to attribute 0 other than @ID. -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
Kevin, I think that the closest you are going to be able to get is the program in question using LIST.READU to determine the PID and PORT.STATUS to then find the program. I don't know of any way to dynamically get to the program line number from there. You could, of course, just look through the program source and the READUs then make an educated guess from there. Kevin King wrote: Unfortunately, no love there either John. I even went to the GETREADU( .. ) function in BASIC.. nothing there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
I believe that if the program ended the lock would be released, so by finding the PID via LIST.READU and then determining the program name associated with the PID via PORT.STATUS you are identifying the program which currently holds the lock unless the program ends between the LIST.READU and PORT.STATUS. At least in my Unix/Universe world. Wjhonson wrote: This won't work unless the program is halted-waiting. Most likely it's moved on to do a hundred other things since the lock in question, but left it hanging because the pid is still living. If the pid dies it would release the lock, but for example, even on non-SB systems, phantoms which run constantly can leave locks hanging forever. -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 8, 2011 8:34 am Subject: Re: [U2] Lock Status Kevin, I think that the closest you are going to be able to get is the program n question using LIST.READU to determine the PID and PORT.STATUS to hen find the program. I don't know of any way to dynamically get to the rogram line number from there. You could, of course, just look through he program source and the READUs then make an educated guess from there. Kevin King wrote: Unfortunately, no love there either John. I even went to the GETREADU( .. ) function in BASIC.. nothing there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Lock Status
I disagree. If I run LIST.READU and note the PID of a process holding a lock on an item then run PORT.STATUS on that PID the only way that the program shown by PORT.STATUS as currently running is not the process holding the lock would be if the program ended (thus dropping the lock) before I ran the PORT.STATUS. Wjhonson wrote: That's not the case. PORT.STATUS shows you what that PID is currently doing when you run it. Not what it was doing an hour ago for example. Not what it was doing when it set the lock. Just what it's doing now. In Unix/Universe world. If you are so lucky to know about the lock *right when* it's being set, then you are right. But in my experience that is a very rare occurence. And in this particular example, he already stated that it was a lock left set some time earlier. You can only know the program being run by that PID if that program is in some sort of waiting condition and had been waiting since it set the lock. -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 8, 2011 10:30 am Subject: Re: [U2] Lock Status I believe that if the program ended the lock would be released, so by inding the PID via LIST.READU and then determining the program name ssociated with the PID via PORT.STATUS you are identifying the program hich currently holds the lock unless the program ends between the IST.READU and PORT.STATUS. At least in my Unix/Universe world. Wjhonson wrote: This won't work unless the program is halted-waiting. Most likely it's moved on to do a hundred other things since the lock in uestion, but left it hanging because the pid is still living. If the pid dies it would release the lock, but for example, even on non-SB ystems, phantoms which run constantly can leave locks hanging forever. -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 8, 2011 8:34 am Subject: Re: [U2] Lock Status Kevin, I think that the closest you are going to be able to get is the program n question using LIST.READU to determine the PID and PORT.STATUS to hen find the program. I don't know of any way to dynamically get to the rogram line number from there. You could, of course, just look through he program source and the READUs then make an educated guess from there. Kevin King wrote: Unfortunately, no love there either John. I even went to the GETREADU( .. ) function in BASIC.. nothing there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query [ad]
I've just been setting up DataVu Query as well and the first thing I've noticed is that the documentation installed by the setup process does not match the version of the software installed. Screens are completely different. Daniel McGrath wrote: CONVERT.SQL is only for UniData. DataVu uses UOJ and JDBC. When you actually *run* the queries it does it via SQL. Remember that DataVu can use more than one data source, including SQL databases. This keeps everything uniform and always you to use those data sources together in a more seamless manner. Regards, Dan Sent from my Verizon Wireless 4GLTE smartphone -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] DataVu Query
I've managed to get this installed, define a repository, successfully connect to it, and construct a simple query. When I run it I get a pop up that says: Applications Error BIC4. 5 Any thoughts? So far, I would not give this to an end user under any circumstances. Running an ODBC query from Excel/MS Query is vastly simpler. I have not completely given up hope yet since I'm early in the process of learning the product and getting used to the interface. Perhaps I'll pause my normal process of click on stuff and see what it does and read the 351 page Getting Started PDF. -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] List Voc Like ....
LIST VOC WITH @ID LIKE ...DOG... no quotes, especially not single quotes which woulf indicate an explicit record ID Wjhonson wrote: LIST VOC LIKE ...'DOG' fails, listing everything LIST VOC LIKE '...DOG' passes, listing just those items ending in DOG The online HELP documentation gives no examples of using the quotes, they just state it without an example. Or rather the example is just the 'string' by itself without it's use in context of the ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Stuck getting started with DataVu
Have you enabled the account you selected for ODBC access? Perry Taylor wrote: I had the very same problem when I last tried it a few weeks ago. Got discouraged and gave up :( Perry - Original Message - From: Oaks, Harold [mailto:harold.o...@clark.wa.gov] Sent: Wednesday, August 24, 2011 11:56 AM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] Stuck getting started with DataVu Anybody using DataVu? Rocket's free data viewer? I think this is a tool my users might like, if I can only get it to work! But I can't get past a seemingly beginning point... I have created a repository. I can now define a new U2 data source. After entering the server name, Universe login and password, testing that the connection is good, I am then able to pick an account as the data source (The list shown surely comes from the UV.ACCOUNT file). Fine. Seemingly the data source is now defined, call it MyDataSource. The 'repositories' view shows this tree: [-] MyRepository [-] U2 Data Sources [-] MyDataSource [+] Files Now, if I click on the [+] next to Files, I expect it to expand with the available files making use of the VOC file to know what these are. But it simply flashes 'pending' for about 1/2 a second and becomes 'Files' with no [-] or [+] next to it. What step am I missing? Does there need to be some special VOC record created in the account? I am thinking perhaps the JDBC drivers are not known to DataVu, and that is the problem. The documentation states that U2 DataVu does not include JDBC drivers, however it states that one can import the JDBC library settings file. To do this, it says, one clicks on File - Import - Connection and JDBC Library Settings, etc. However! After clicking on File, there is no Import selection available at all in the drop down. (I just hate it when the documentation doesn't match the product!). Has anyone gotten past these issues? Does anyone actually use this product? I might mention that I am also looking at the Web Services product from Rocket. After specifying an account and clicking on Database Files it instantly displays all the available files in the account. Which is good. Thanks- Harold Oaks Clark County IT Clark County, WA This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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 http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Doing Multiple Selects in BASIC and combining the lists
try: HELP MERGE.LIST John Thompson wrote: This may be an easy one, or a hard one, however, I realized I don't recall ever having to do this until today, or I could just be tired... How can you do a SELECT from two different files in a BASIC program and then combine the lists of ID's so that you can do a READNEXT on it? I ask this because I believe by default that Universe does not store the select lists as dynamic arrays. For example: EXECUTE \SELECT FILE1 WITH AMOUNT = 112.50\ RTNLIST FILE1_LIST EXECUTE \SELECT FILE2 WITH AMOUNT = 112.50\ RTNLIST FILE2_LIST ...Code to combine FILE1_LIST and FILE2_LIST into FINAL_LIST... REANEXT ID FROM FINAL_LIST THEN do something NEXT ID I am using Universe 10.3.x on AIX 5.3. I'm in a PICK flavor account. -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Doing Multiple Selects in BASIC and combining the lists
The lists are stored in SAVEDLISTS as a multi-attribute dynamic array John Thompson wrote: Yes it occurred to me some minutes ago that they ID's in the two files are different, so you are correct. So I'll probably end up just doing the two readnext's anyway like a previous poster suggested. However, thanks for all the examples. I started out on an older PICK system that did not have multiple select lists, I have never used the feature that much, and I'm pretty new to it, and sometimes I wish they just stored the lists in a BASIC program as dynamic arrays... On Wed, Jul 27, 2011 at 2:56 PM, Allen E. Elwood aelw...@socal.rr.comwrote: If I understand correctly, you're going to end up with a list that has entities from two files, therefore you're going to need to do a test when you do the read to see which file the ID came from and ergo which file to read So to add to the code below, you'd need READ RECORD FROM FILE1, KEY THEN GOSUB PROCESS.RECORD END ELSE READ RECORD FROM FILE2, KEY THEN GOSUB PROCESS.RECORD END ELSE PRINT KEY : ' WAS NOT IN EITHER FILE???' INPUT WAKKA.WAKKA END END -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buffington, Wyatt Sent: Wednesday, July 27, 2011 11:27 AM To: U2 Users List Subject: Re: [U2] Doing Multiple Selects in BASIC and combining the lists EXECUTE SELECT FILE WITH VALUE = 'A' TO 1 EXECUTE SELECT FILE WITH VALUE = 'B' TO 2 EXECUTE MERGE.LIST 1 UNION 2 TO 0 TOT.VAL = 0 END.OF.LIST = FALSE LOOP READNEXT KEY FROM 0 ELSE END.OF.LIST = TRUE UNTIL END.OF.LIST = TRUE DO READ RECORD FROM FILE, KEY THEN VALUE= OCONV(RECORDX,'MD2') TOT.VAL += VAL END REPEAT -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Wednesday, July 27, 2011 1:17 PM To: U2 Users List Subject: Re: [U2] Doing Multiple Selects in BASIC and combining the lists Ok, got stuck again... How would your example play out in BASIC? Its just a bunch of archive info in a file that only has a couple of indexes, but, I would like to look at the active file as well... EXECUTE \SELECT FILE1 WITH VALUE = 'A' TO 1\ EXECUTE \SELECT FILE2 WITH VALUE = 'A' TO 2\ EXECUTE \MERGE.LIST 1 UNION 2 TO 0\ I get an error claiming select list 1 is not active this way. I need the selects to be separate and not stack. I know how to stack them with PASSLIST and RTNLIST... I'm just fuzzy on how to do them separately and then combine them? Would I need to save them and use LIST.UNION? Or just do the two READNEXTS? (I'm trying to avoid because the READNEXT loop is kind of big) Any help is appreciated. On Wed, Jul 27, 2011 at 1:22 PM, Buffington, Wyatt wgbuffing...@hydro.mb.ca wrote: In a nutshell SELECT FILE WITH VALUE = 'A' TO 1 SELECT FILE WITH VALUE = 'B' TO 2 MERGE.LIST 1 UNION 2 TO 0 SORT FILE VALUE -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Wednesday, July 27, 2011 12:16 PM To: U2 Users List Subject: [U2] Doing Multiple Selects in BASIC and combining the lists This may be an easy one, or a hard one, however, I realized I don't recall ever having to do this until today, or I could just be tired... How can you do a SELECT from two different files in a BASIC program and then combine the lists of ID's so that you can do a READNEXT on it? I ask this because I believe by default that Universe does not store the select lists as dynamic arrays. For example: EXECUTE \SELECT FILE1 WITH AMOUNT = 112.50\ RTNLIST FILE1_LIST EXECUTE \SELECT FILE2 WITH AMOUNT = 112.50\ RTNLIST FILE2_LIST ...Code to combine FILE1_LIST and FILE2_LIST into FINAL_LIST... REANEXT ID FROM FINAL_LIST THEN do something NEXT ID I am using Universe 10.3.x on AIX 5.3. I'm in a PICK flavor account. -- John Thompson ___ 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 -- John Thompson ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com
Re: [U2] Document Management
Check out 1mage http://www.1mage.com/ On Fri, Jul 22, 2011 at 3:17 PM, Tony Gravagno 3xk547...@sneakemail.com wrote: It looks like your responses, including mine here, are unanimous - it's preferred to store blobs outside the DB and metadata inside. I see no benefits to storing blobs in the DB and lots of reasons not to do so. I wrote a blog a while back on signature capture, which I implemented much like Rob Porter did his document scanner. In addition to capturing images, a real signature scanner collects biometric data. It's all the same, and best kept outside the database, indexed and referenced by the database. nospamNebula-RnD.com/blog/tech/2009/09/signatures01.html As far as document management in general, my wife works in the legal department for a large USA company. They're looking for a new system to store contract source/Word documents, to scan and generate PDFs, OCR and index TIFF/PDF, and to link all of these with clients, trading partners, employees, events, legislation requiring specific language, other documents with with similar language, and other databases. They need workflow, historical reporting, and of course high security. I know all of that can be done very well in a Pick environment - if we just separate frilly document-related functions from data-related functions. Software like this easily sells for $100K upwards, but if you look at those packages, they do a lot of the frilly document processing (which is trivial and very low-cost for anyone who knows how) and minimal data processing. Post-sale development work to make these systems do what's required can easily double the package cost. Writing a new system like this in U2 would take many months but could yield a really nice package, more malleable, and at a much lower TCO. What we generally see (as in this thread) is that most Pick people are strong on the DB but not so strong on external interfaces, which is what people see and pay the big bucks for. If anyone is familiar with a Pick-based package that fits the above description, please contact me. If you have the budget to create one in preference to buying one, I'm open to that as well. Thanks! Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno Does it make any sense to use a U2 database to save scanned pdf's? That is... Does it make any sense to save small blobs in a U2 data base? Would a Type 1 file be best? Are there any advantages to using MS-SQL, MySQL, or some other database technology? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- --- Jeff Schasny - jschasnyATgmailDOTcom --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Rocks
You were given many reasons and dismissed them all with nothing more than a shrug. Apparently, now you believe you've made your point. Good for you. Amazing as it may sound, on a list full of people who are U2 developers you're going to find people who use U2 because we're experts in it, and to us it's as easy as pie to develop in this environment. We use it with various front end tools to make it pretty like any other database environment. We also use a variety of other open source and proprietary tools when the situation calls for it. And now I believe I'll stop feeding the troll and go have some more coffee. Holt, Jake wrote: U2 has an easy learning curve ..? What? MV is a completely foreign concept to most people and I'd wager a large number of DBAs. There is no conceivable way that installing U2, setting up a database, developing an application and presenting it using a technology that's not a dinosaur can be considering easy in comparison to the majority of other databases out there. If you're happy with the current MV market then that's fine, but my original intention in asking the question was to find out if there was really any conceivable reason that NEW users would adopt U2 over another option. If people are happy to just watch it bleed and die that's fine, but if you want the market to grow you're going to have to address some of the issues already brought up. Issues that many other databases addressed a decade ago. Like I said initially, I like U2, I just have no conceivable reason to use it outside our ERP system when I have a number of other options available that are, frankly, better. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, July 14, 2011 9:30 AM To: U2 Users List Subject: [U2] Rocks Rob: This is the U2 list. The developers on this list... like, live, and breathe U2. U2 is a legacy database for in which, over decades, companies have invested in mega-mountains of code. I find it galling when newbies so often expect companies to instantly bail on their colossal stake. Is U2 ever going to be cloud-based? Maybe... maybe not. Although U2 is the UniVersal choice... for fresh new projects, designers may have good reasons to opt for a rival technologies. For add-on projects, U2 has an easy learning curve. I hope that this explanation sheds some new light. --Bill -Original Message- Sent: Wednesday, July 13, 2011 9:26 PM Subject: Re: [U2] Why Pick U2 ? I have to heartily disagree that U2 has a sophisticated business rules engine. ... -Rob ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Why use U2, was Interesting Article
It scales well. I benchmarked 20K concurrent users for a wholesale distribution application on a single (HP Superdome) server and that was 10 years ago. The database structure can be painlessly modified which makes it much easier for new applications development. Need a new field, slap it on the end of the table and go on with your day, try that with your favorite relational environment. Not so important today as it once was when disk was more expensive,but it uses significantly less disk space than a relational database storing the equivalent data. This also contributes to needing significantly less overall computing power to support X number of users for a given application due to more efficient IO, i.e. less disk reads required. You can use SQL, but you don't have to. This, above all, is the MY most significant reason to use U2. Holt, Jake wrote: I'm not sure being cheaper than Oracle can really be touted as an advantage, there aren't many things out there that are more expensive than oracle =D. And all of those things you just mentioned are also true of many FREE databases, so again, why pick U2? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, July 13, 2011 9:31 AM To: 'U2 Users List' Subject: Re: [U2] Interesting Article You may have answered your own question. Why do YOU like it? It is easy to develop, quick to code, fairly robust query language, and a lot cheaper than the BIG databases (Oracle, DB2, etc). John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Wednesday, July 13, 2011 10:26 AM To: U2 Users List Subject: Re: [U2] Interesting Article I have come to like U2 over the past few years but an honest question: Why would anyone ever pick U2 beyond familiarity and personal preference? Can anyone think of any situation that another (and in a lot of cases a *far* cheaper) database isn't a better fit? Maybe if U2 had it's own niche like MySQL has with web hosting, there would be a market Rocket could focus on ? ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selecting a List
EREPLACE function? SYNTAX EREPLACE (expression, substring, replacement [,occurrence [,begin]] ) DESCRIPTION Use the EREPLACE function to replace substring in expression with another substring. If you do not specify occurrence, each occurrence of substring is replaced. occurrence specifies the number of occurrences of substring to replace. To replace all occurrences, specify occurrence as a number less than 1. Glorfield, Gordon wrote: What about SWAP? SWAP str.expr1 WITH str.expr2 IN var The UniBasic SWAP command replaces all occurrences of one substring with a second substring. The search string does not have to be the same length as the replacement string. SWAP supports mulitbyte languages. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, June 08, 2011 11:47 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selecting a List Hi All, Again, I need a little help. The following PROCEDURE LINE works just fine. In this case I'm just inserting the variable V.CALENDAR.YEAR to complete my file suite and I am going after 2 alphanumeric records ('P2021422' 'P2083158'). PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = 'P2021422' 'P2083158' The problem arises when I attempt to select from a LIST (below) PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = : VL.JS.LIST.VAR1 Of course the system does not like the Value Marker so I need to get rid of it... VL.JS.LIST.VAR1 = ':CONVERT (@VM,' ',VL.JS.LIST.VAR1):' The hope here is to replace @VM with ' ' and then place the ' at each end... but CONVERT will only switch one for one - one @VM for a single single quote (') which results in a quote mismatch. Any suggestions? Greg ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple UniQuery Question
I actually ran into the same thing about a month ago and solved it by creating an I descriptor which calls a basic subroutine that returns a multivalued version of the single value. Doug Farmer wrote: For some reason, in all the years I have been doing this, I don't ever remember being asked this. A user asked me, if I have a UniQuery report listing a single value and a multi value, how can I repeat the single value for every multi value. For example CustomerInvoice 100012345 12389 13101 200014000 14001 Would become CustomerInvoice 100012345 100012389 100013101 200014000 200014001 I can probably do it with a I Desc subroutine, but is there any UniQuery command to do the same thing without having to create many more dictionary items? Thanks in advance, Doug This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users