Re: [U2] Green Screen - Wide Screen
600 characters wide is a lot to display at the same time I'm pretty sure it would be illegible at that size - can't you just code your program to scroll the data sideways? - DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, 18 October 2011 5:57 AM To: U2 Users List Subject: [U2] Green Screen - Wide Screen We have a large application that runs in Dynamic Connect... and needs more in the way of columns. DC is limited to approx. 132 characters. I believe that wIntegrate (when in text mode) is the same. We need maybe five times that. While I have almost concluded that this app needs to be re-written in GUI... before punting... are there any other angles worth consider... such as AccuTerm or some other text-based terminal emulator. Is there a way to do this in DC or wIntegrate? --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reading Dictionary Items
I realise you already have an answer - but here's a one liner that would do the same thing, without writing any code: UPDATE.RECORD DICT filename F4,@ID ALL - DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, 30 September 2011 2:44 AM To: U2 Users List Subject: [U2] Reading Dictionary Items I would like read open a (large) dictionary, read the line items, and write back the @ID field to Attribute 4 (the column heading) of each. Syntax help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] test
Test reply - DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ANOTHER TEST
I saw those two test messages, so I thought I'd test posting as well. I haven't been able to post or reply to any messages on this list for well over a year (IRC) - so, somebody seems to have fixed something somewhere. - DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another NEW cutting-edge column based database concept!
try it without the spam filter string nospam_please! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shawn Hayes Sent: Friday, 6 August 2010 10:09 AM To: U2 Users List Subject: Re: [U2] Another NEW cutting-edge column based database concept! I am getting Firefox can't find the server at nospam_pleasenebula-rnd.com I am interested in your thoughts. I will keep trying... You have another link? 'We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.' DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
Thankyou, thankyou! Phil. H didn't work - but it made me go and look up what other options are available for field 4 in the VOC. I needed to add a G - Allowed in an SQL CALL statement. So, no coding changes required at all - fantastic, just the way I like it. Thanks again. Adrian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Wednesday, 30 June 2010 12:02 PM To: U2 Users List Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? You could try setting adding an 'H' (I think) to attribute 4 or 5 of the VOC MESSAGE record. This will allow the verb to be issues as part of a transaction Sorry to be vague, but I am not connected to a system at the moment... Cheer,s DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
I'm wondering if it's because MESSAGE can optionally prompt for input, and because the call statement is executed from the jsp page via executeQuery - maybe it won't allow input inside a query (similar to the rule about input inside a transaction). Perhaps if I execute a PHANTOM command to perform the MESSAGE commands in a different process - maybe that would work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 9:18 AM To: 'U2 Users List' Subject: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? We have a jsp page that calls a Universe subroutine using that method detailed in the JDBC manual, this works as expected and the subroutine completes it's task successfully. Also from a separate phantom process for certain important events we have some code that sends a splat message to line 23 of specific users' sessions (this uses the Universe MESSAGE command) -this also works fine. We're now trying to get the subroutine called via JDBC to also use the MESSAGE command. But each time it throws this error message into the uv errlog: root VOC entry MESSAGE illegal as or in a procedure. Does anyone know what's wrong here? I've looked through the manuals and the help and can't find any mention of this particular restriction. Thanks, Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
Oh, great - now I'm getting the same error for PHANTOM - so I can't use that workaround. VOC entry PHANTOM illegal as or in a procedure. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 9:50 AM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? I'm wondering if it's because MESSAGE can optionally prompt for input, and because the call statement is executed from the jsp page via executeQuery - maybe it won't allow input inside a query (similar to the rule about input inside a transaction). Perhaps if I execute a PHANTOM command to perform the MESSAGE commands in a different process - maybe that would work. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
Thanks for that Dan - I was coming to the same conclusion myself. We already have another phantom that uses MESSAGE, so I knew that wouldn't be a problem. I was a bit disheartened when I found out i could use PHANTOM either - that would have been a relatively painless approach. We do have a number of other phantoms already doing tasks at various intervals, so adding an extra task to just poll a file would be too much to ask. It's a pity that I can't use MESSAGE (or PHANTOM) directly. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, 30 June 2010 11:54 AM To: U2 Users List Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? I just checked on our system and I can call MESSAGE within a PHANTOM if it is executed from a normal session. With this in mind, a possible work around would be to run a 24/7 phantom that either accepts data from a named piped/socket or polls a file and sends out a message based on the data received. From your UV subroutine you could then just passed the required data by the appropriate method. It's dirty and obviously having it work natively from your UV sub would be better, but if it isn't possible... Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, June 30, 2010 1:39 PM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Oh, great - now I'm getting the same error for PHANTOM - so I can't use that workaround. VOC entry PHANTOM illegal as or in a procedure. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 9:50 AM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? I'm wondering if it's because MESSAGE can optionally prompt for input, and because the call statement is executed from the jsp page via executeQuery - maybe it won't allow input inside a query (similar to the rule about input inside a transaction). Perhaps if I execute a PHANTOM command to perform the MESSAGE commands in a different process - maybe that would work. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments
Re: [U2] Creating an index
This should do the trick - Create a multi-valued i-descriptor with this code: CATS(REUSE(DATE:*),CATS(CATS(PART,REUSE(*)),QTY) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Shawn Hayes Sent: Friday, 21 May 2010 5:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] Creating an index OK, I am hoping this is a simple question... It has been a while since I have done this and I was hoping someone could help easily. I have a file with 3 attributes... DATE - Single value PART - Multivalue QTY - Multivalue (Part and QTY are associated) I want to create an index that has the key DATE:*:PART:*:QTY for each MV item in the PART and QTY attribute. I realize that it is probably a poorly constructed key but I want to quickly get the quantity of parts within a given range... Any thoughts? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Creating an index
Now that's weird - I just noticed David A Greens similar reply - but it was further down in my mail box, it has a time 39 minutes earlier than Shawn's original question! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Friday, 21 May 2010 9:53 AM To: 'U2 Users List' Subject: Re: [U2] Creating an index This should do the trick - Create a multi-valued i-descriptor with this code: CATS(REUSE(DATE:*),CATS(CATS(PART,REUSE(*)),QTY) DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Creating an index
Here's another variation on a theme: CATS(REUSE(DATE:*),SPLICE(QTY,*,PART)) I was totally unaware of the useful SPLICE function until reading David's post. Thanks David. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData ICONV function
On Universe the help for conversion code DI only specifies using DI on it's own without any trailing options (the help for the usual D however shows all the various additional options). I've tried your example and it didn't work at all - nothing was displayed. I tried changing DIMDY to just DI and 15373 was displayed (15373 = 01 Feb 2010). Note: in your example 15343 = 02 Jan 2010. Normally we run the DATE.FORMAT command when logging into an account (making dates display with the month in the middle). In this case using ICONV with DI the output is 15343 (the same as yours). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, 10 February 2010 1:48 PM To: U2 Mail List Subject: [U2] UniData ICONV function The following works in UniData: DD = '01' DM = '02' DY = '2010 CRT ICONV(DM:'-':DD:'-':DY, 'DIMDY') ...returns '15343'. Does this work in UniVerse? Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse RetreiVe how do I query a file for all of itscolumn's values?
Here's another simple option: Use REVISE (or ENTRO, MODIFY, etc) on the file - this will automatically create an @REVISE phrase in the file's dictionary. You could then use LIST filname @REVISE to see all the fields. (Note: REVISE will only create the @REVISE phrase if you don't already have an @ phrase in the dictionary). Alternatively write a simple program to SELECT all the D-types in the dictionary and append their names into a string and then build up a LIST statement containing all the field names. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Thursday, 21 January 2010 12:39 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse RetreiVe how do I query a file for all of itscolumn's values? So, the choices are to edit the @ item in the dict add all of the columns, or write a basic program that reads Rec, then outputs Rec1, Rec2, etc. A third solution would be to copy the F1 dictionary item to F2, F3, F4, etc., change the attribute (column) field to match, then list 'em all, maybe in a proc. Sounds like you have options... DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] An interesting find....
You may be better off using something like this instead: DIM F.FILETOUSE(2) OPEN FILE1 TO F.FILETOUSE(1) ELSE STOP NO FILE1 OPEN FILE2 TO F.FILETOUSE(2) ELSE STOP NO FILE2 then use F.FILETOUSE(X) - without the need for any conditional statements, just ensure X is assigned properly. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, 16 December 2009 4:27 AM To: U2 Users List Subject: Re: [U2] An interesting find AHA. You are correct. I don't usually have one line CASE's and those pesky semicolons usually trip me up there. Thanks...that was driving me nuts, because in the program I used it in, I would much rather have a CASE structure than the IF-THEN setup. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: Tuesday, December 15, 2009 3:24 PM To: U2 Users List Subject: Re: [U2] An interesting find In your example, the line: CASE X=1 F.FILETOUSE = F.FILE1 should be CASE X=1; F.FILETOUSE = F.FILE1 Without the semicolon, the CASE test is something like (FMT(1,F.FILETOUSE)=F.FILE1) and possibly being considered true. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Unibasic IN function
I have a routine that gets variable length keyboard input without using any naps/sleeps etc - BUT we don't have any keyboard sequences that are subsets of other sequences. eg. we don't use a single ESC character to mean anything. So I basically just keep getting characters whilst the sequence received is a subset of a known sequence, then I return immediately when the sequence is complete or no longer matches a known sequence. Note: I make use of the Universe KEYIN() function. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 11 November 2009 9:37 AM To: 'U2 Users List' Subject: Re: [U2] UniData Unibasic IN function Bob, This is kind of a FAQ and you'll find a few responses in the archives for the U2 Users groups (via Google search) in Mail Archive and similar archiving services... Here's one response from Martin Phillips (UV specific, but I think you get the idea) ... maybe an overkill for you?: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg24904.html You need to take care that you input routine 'naps' / sleeps for a few milliseconds between or risk that it hogs the CPU (especially, if in use by lots of users simulatenously). Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Wednesday, 11 November 2009 11:18 AM To: U2 Users Mailing List Subject: [U2] UniData Unibasic IN function Hi Folks, I have a need to capture control/function keys from the keyboard in a basic program. The IN() function does exactly this but I'm having a bit of trouble figuring out how to recognize the end of a multi-character keystroke. The cursor keys and function keys all start with ESC (Char-27) but have a variable number of characters afterwards. I'm looking for a way to recognize the difference between pressing the F1 key verses typing type ESCOP keys. They both bring in data, character by character, as CHAR(27), CHAR(79), then CHAR(80). I've tried using the INPUT VAR UNFILTERED command but then it requires an additional Enter key to release the data to the program. I can't set a length because of the number of characters in the function keys, and any kind of time limit is going to be too long to be bearable. Oh, and I also need to be able to recognize the difference between the escape key by itself verses the start of a function key. The system is Unidata 6.1. Thanks in advance for any thoughts or suggestions. Bob Woodward System Programmer/Analyst K2 Sports ** 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 DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sequentially Hashed Files
Have you tried setting MINIMUM.MODULUS to a high value on your dynamic file. This prevents the file from merging below the size you've set. Although it can still split to larger than that size. You can use the CONFIGURE.FILE command to set MINIMUM.MODULUS - but it won't take effect until the next time you use CLEAR.FILE. It may also be useful to set LARGE.RECORD size (see the help for CONFIGURE.FILE). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Raymond P. de Bourbon Sent: Tuesday, 20 October 2009 11:58 PM To: U2 Users List Subject: Re: [U2] Sequentially Hashed Files Thanks for the response.. Here's my situation: The app is generating records with sequential numeric keys and over time the records are deleted with the file returning to a count of zero.. The record sizes can vary considerably from record to record... Currently we are using dynamic files and are constantly having to resize and generally having to maintain the files, and it is becoming quite a headache for us .. Right now, we are just looking for other options and I had seen sequentially hashed files in the manual, and it said that they are bested suited for cases with sequential keys (but says nothing about create not delete etc) - so I thought I would ask... Looks like we may just have to spend time working on some admin scripts to maintain the dynamic files automatically... Ray DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniObject .NET Session and Common Block Bug
The common blocks you've shown are not named - maybe that's your problem. Try naming them (i.e. adding a unique slash-delimited name between the word COMMON and the variable name(s). eg. COMMON /AHC1/ AHCOMMON1 COMMON /AHC2/ AHCOMMON2 That way there won't be any conflict between the two blocks. We use named common extensively and it is mostly lazy loaded i.e. only loaded the first time it's required, and we don't have any problems. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Halid Sent: Thursday, 8 October 2009 11:07 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniObject .NET Session and Common Block Bug snip ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Null character causes odd UV behaviour
Have you tried CONVERT @NULL.STR TO IN STATE (for info on @NULL.STR see @variables in the BASIC help file) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen Sent: Thursday, 17 September 2009 8:58 AM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Null character causes odd UV behaviour Indeed. I'd call IBM or my VAR if I were you. And thanks for the mention! Laure Hansen, City of Redwood City I.T. Tel: 650-780-7087 Cell: 650-207-3235 - Original Message - From: u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed Sep 16 17:54:12 2009 Subject: Re: [U2] Null character causes odd UV behaviour -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Wednesday, September 16, 2009 5:16 PM To: U2 Users List Subject: Re: [U2] Null character causes odd UV behaviour DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Null character causes odd UV behaviour
It may also be worth playing with the RAW.INPUT and/or RAW.OUTPUT compiler directives: eg. BASIC BP progname RAW.INPUT RAW.OUTPUT These directives alter how system delimiters are mapped (I'm not sure whether null counts as a system delimiter) DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] General guidelines on indexing
The code looks fine to me. I added crt len(s) to the end of the program and it printed 10009 (that's what I'd have expected). I'm running on an HP-UX ia64 box - maybe you're on Windows? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Thursday, 9 July 2009 4:39 PM To: U2 Users List Subject: Re: [U2] General guidelines on indexing Hi Adrian, I just tried this example on Universe 10.2.6 - it took 0.0665 seconds basically instant, can't complain about that. I am sure that something must have been wrong with your test. This probably isn't long enough to do even the empty loop with no string copy. I have just repeated my test on a different system running UV 10.2.8 and the test took 38 minutes. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] General guidelines on indexing
I just tried this example on Universe 10.2.6 - it took 0.0665 seconds -
basically instant, can't complain about that.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin
Phillips
Sent: Thursday, 9 July 2009 12:59 AM
To: U2 Users List
Subject: Re: [U2] General guidelines on indexing
By way of a simple expample, I just tried the following program...
s = ''
z = str('*', 1000)
t1 = time()
for i = 1 to 10
s-1 = z
next i
t2 = time()
crt t2 - t1
This took six seconds on QM but 32 minutes on UniVerse.
DISCLAIMER:
Disclaimer. This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] default sort order
If you're talking about LIST DICT filename and getting the dictionary items listed by @ID (instead of the default field number order) then you need to edit the @-phrase in DICT.DICT - see the long LIST DICT.DICT thread from a couple of days ago for more details. You'll find that an @ phrase already exists in DICT.DICT (the default one in Universe includes BY FIELD.NO). -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, 20 May 2009 10:43 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] default sort order Ron Hutchings wrote: ED DICT YOUR.FILE.NAME @ 1) PH 2) FIELD NAMES FILTERS SORT ORDER Don't just put BY @ID in it, that can be accomplished with SORT YOUR.FILE.NAME Hmm, That is one of the things I tried. just by @id is fine for me, howver, it is not doing it. I'll look again tomorrow. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Auto-updating of secondary indices.
Use LIST.INDEX filename and check under the Build column, indexes usually say Not Reqd if they are updated automatically. The DISABLE.INDEX ENABLE.INDEX commands can be used to turn off/on automatic updating of the indexes. But, as Henry mentioned, if the subroutines are accessing data in other files, then automatic updating is not really a good idea because as soon as the other file changes your AK will be out of date (even with automatic updates on). IMO Aks should only ever reference @ID @RECORD. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Monday, 18 May 2009 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Auto-updating of secondary indices. From my reading of the Universe documentation, secondary indices should be automatically updated. I have a case where a file has about 8 secondary indices, some of which are updated automatically, and some seem not to be. A complete rebuild is done on all these indices each night. There does not seem to be anything significantly different about the ones that don't update automatically. They are I-descriptors that call a subroutine, but others like these update automatically. Any suggestions? I am thinking I should delete the indices in question, recreate them, and rebuild them. Regards, Ken Ford Universe Software Engineer DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Problem with report - need help
Change the field length in the dictionary to 9. The field length of all fields in dictionaries defines their external (output) length - eg a date using conversion code D needs a length of 11 even though it only takes up 5 characters in internal format. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of apogee79 Sent: Tuesday, 5 May 2009 1:40 PM To: u2-users@listserver.u2ug.org Subject: [U2] Problem with report - need help Hi, I have a file, in which the field length is defined to be 8. It does not store a decimal point - but has the capacity to hold 8 digits in total. Now when that has to be reflected in the report, where 2 decimal places formatting is used, the values which were 8 digits in length orignially in the database, get displayed in the report with the first digit missing. For example - 12345678 is the way the value is stored in the database. When this is brought to the report, it gets displayed as 23456.78. The report again has the field length defined as 8. How do i resolve this issue? Can anyone please help me. G -- View this message in context: http://www.nabble.com/Problem-with-report---need-help-tp23379941p2337994 1.html Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV Timed INPUT
Here's my hastily hacked together solution, it allows 5 seconds for the user to enter a string. It grabs a single character at a time and builds up a string - you need to cater for special characters manually, I've coded for enter and backspace, you could just discard any others that are below CHAR(32) or above CHAR(126). It doesn't display anything on screen - you could add CRT statements as the string is built up. CT = 0 LOOP LOOP INPUT CHAR.WAITING,-1 WHILE CHAR.WAITING CHARACTER = KEYIN() BEGIN CASE CASE CHARACTER = CHAR(10) ;* Enter CT = 100 EXIT CASE CHARACTER = CHAR(8) ;* Backspace IF LEN(THE.STRING) THEN THE.STRING = THE.STRING[1,LEN(THE.STRING)-1] CASE @TRUE THE.STRING := CHARACTER END CASE REPEAT NAP 50 WHILE CT 100 CT += 1 REPEAT -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Friday, 13 March 2009 9:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV Timed INPUT Thanks to all for the responses; yes the UniData INPUT ... WAITING looks like it would be great but it doesn't exist on UniVerse. I'm still battling with the basic problem of trying to intercept a partially entered string after a certain time. If typing has started but Enter hasn't been pressed to finalise an INPUT command, then everything waits until the INPUT is satisfied. I need to jump in after (say) 5 seconds of waiting for ENTER and abandon the INPUT. INPUTIF is part of the solution, but it also waits for an ENTER which may never arrive. Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML Escape function
Here's the code I use (similar to everyone else's) - but I've catalogued it globally as a user conversion subroutine - this allows it to be used with ICONV OCONV: Eg. CONV.XML = OCONV(ORIG.XML,U2XML) Note: I've included conversion for three mark characters, just in case they manage to sneak through! To catalog the routine - use this: CATALOG BP $2XML U2XML FUNCTION U2XML(STATUS.CODE, DATA.FIELD, INTERNAL) * * * * Arguments: * * STATUS.CODE (I/O) Input : The conversion code *Output: The value to return to set STATUS() * DATA.FIELD (I) The data to be converted * INTERNAL(I) @TRUE = ICONV; @FALSE = OCONV * * returns : The converted DATA.FIELD * * * STATUS.CODE = 0 * IF INTERNAL THEN RESULT = CHANGE(DATA.FIELD, , amp;) RESULT = CHANGE(RESULT, , lt;) RESULT = CHANGE(RESULT, , gt;) RESULT = CHANGE(RESULT, ', apos;) RESULT = CHANGE(RESULT, '', quot;) RESULT = CHANGE(RESULT, @VM, #253;) RESULT = CHANGE(RESULT, @FM, #254;) RESULT = CHANGE(RESULT, @SM, #252;) END ELSE IF INDEX(DATA.FIELD,,1) THEN RESULT = CHANGE(DATA.FIELD, amp;, ) RESULT = CHANGE(RESULT, lt;, ) RESULT = CHANGE(RESULT, gt;, ) RESULT = CHANGE(RESULT, apos;, ') RESULT = CHANGE(RESULT, quot;, '') RESULT = CHANGE(RESULT, #253;, @VM) RESULT = CHANGE(RESULT, #254;, @FM) RESULT = CHANGE(RESULT, #252;, @SM) END ELSE RESULT = DATA.FIELD END END * RETURN (RESULT) * * * END -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Ben Souther Sent: Thursday, 26 February 2009 5:13 AM To: u2-users@listserver.u2ug.org Subject: [U2] XML Escape function Years ago, I thought I saw an XML escape function in Unibasic but I can't seem to find it now. I thought it was mentioned in the Unidata Extensions PDF but I'm not able to find it. Does anyone know if such a function exists? Thanks, -Ben --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] EQUATEs Using System Delmiiters
Try putting parentheses around the expression:
eg. EQU MX TO ('ABCD':@AM:'EFGH')
That will cause each of the functions to operate on the whole string
rather than on a single element of the string.
Although something strange is obviously going wrong. I would have
expected the operations to affect just the last portion (EFGH) but it
seems to be affecting the first portion.
Why use EQUATE anyway in this case, you'd be better of just assigning a
variable.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor
Sent: Tuesday, 7 October 2008 4:06 AM
To: U2-Users List
Subject: [U2][UV] EQUATEs Using System Delmiiters
I'm trying to use EQUates to setup static arrays in a BASIC program but
am getting strange results. The UniVerse BASIC manual says you can use
any valid BASIC expression as an object to the symbol. However when I
try to create an array with...
EQU MX TO 'ABCD': @AM: 'EFGH'
... I get strange results. Consider the following code...
--
EQU MX TO 'ABCD': @AM: 'EFGH'
CRT
CRT 'MX=': MX
LC = LEN(MX)
CRT
CRT 'LEN(MX)=': LC
CRT
FOR NC = 1 TO LC
CRT 'SEQ(MX[': NC: ', 1])=':SEQ(MX[NC, 1])
NEXT NC
CRT
LAMC = DCOUNT(MX, @AM)
CRT
CRT 'DCOUNT(MX, @AM)=': LAMC
CRT
FOR AMC = 1 TO LAMC
CRT 'MX': AMC: '=': MXAMC
NEXT AMC
--
When I run this code in a Pick-flavored account I get the following
results...
--
MX=ABCD~EFGH
LEN(MX)=9
SEQ(MX[1, 1])=65
SEQ(MX[2, 1])=65
SEQ(MX[3, 1])=65
SEQ(MX[4, 1])=65
SEQ(MX[5, 1])=65
SEQ(MX[6, 1])=65
SEQ(MX[7, 1])=65
SEQ(MX[8, 1])=65
SEQ(MX[9, 1])=65
DCOUNT(MX, @AM)=2
MX1=ABCD~EFGH
MX2=ABCD~
--
What am I missing here?
Thanks.
Perry Taylor
Zirmed, Inc.
UniVerse 10.1.21/RHEL3
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential and privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. ZirMed, Inc. has strict
policies regarding the content of e-mail communications, specifically
Protected Health Information, any communications containing such
material will be returned to the originating party with such advisement
noted. If you are not the intended recipient, please contact the sender
by reply e-mail and destroy all copies of the original message.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
DISCLAIMER:
Disclaimer. This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects and setting up Common Block
I dealt with this problem by writing a new subroutine that initializes the required common variables. I then created our own session class that opens a UniObjects session and calls the initialization subroutine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Rowlings Sent: Wednesday, 16 July 2008 10:44 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects and setting up Common Block Greetings by the newbie, I am an asp.net developer and a recent adopter of UniObjects to connect to our Universe database (our student records system). We are experiencing some issues with odd values returning from some IType dictionary items, which we have narrowed to the absence of initialised globalised variables in subroutine calls. In searching the forums I think it may have been referred to in Universe parlance as the common block. I have not found a solution on the Technical Postings forums and thinking it would have to be a fairly common issue in legacy systems request a bit of advice/direction. What is the approach used to set up these global variables(common block) via UniObjects? We don't have the same issue using web service calls to the same subroutines/ITypes. We have a substantial code base that would be a nightmare to re-code, which we need to avoid. Our U2 programmers are already taxed with updating an ever changing system. regards DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] grep for @VM
If you're only looking through a few files, wouldn't it be easier to write a short basic program to read every record use INDEX() on each looking for the string? eg. STRING = 12:@VM:26 SELECT filevar LOOP WHILE READNEXT ID READ REC FROM filevar,ID THEN IF INDEX(REC,STRING,1) THEN CRT Found in :ID END REPEAT -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Beahm Sent: Tuesday, 15 July 2008 3:07 AM To: u2-users@listserver.u2ug.org Subject: [U2] grep for @VM I am trying to find an obscure setting somewhere in a UD database on HP-UX; I know that the character string is [EMAIL PROTECTED] Can anyone tell me how to grep for this combination of alpha and high-ASCII characters so I can resolve a recurring accounting issue? Thanks in advance, David Beahm --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to tell if running a subroutine though RedBack
Check the content of the @AUTHORIZATION system variable. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Farmer Sent: Thursday, 26 June 2008 2:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] How to tell if running a subroutine though RedBack I have a need to call a standard subroutine from a RedBack application call. The subroutine is meant to be used in an interactive mode and can prompt the user if there is an error in the data. If the data is coming from RedBack, I want to suppress the prompting and write the error to a log file. Is there any environment variable I can look at to tell if I am executing under the RedBack API call? Thanks Doug DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Press any key to continue...
While INPUT ANS,1 will work most of the time, if the user decides to press the backspace key or even the ESC key, nothing will happen. An alternative is: ANS = KEYIN() CLEARINPUT Which will grab a single character (including a backspace, etc). Note: if the keystroke sends two characters (eg. an escape sequence of an editing key - like Ins, Del, Page Up, etc) then KEYIN() will only get the first character. The CLEARINPUT statement clears all additional characters from the input buffer. --Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Files Open
PORT.STATUS doesn't need to be run from the uv account, just copy the command in to the local VOC. You can then EXECUTE the command from a program supplying your own PID, and then strip out the required file names from the displayed data. You could wrap this all up in a function and call it from wherever it's needed. eg. FILES.OPEN = SomeUserWrittenFunction() -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Ward Sent: Wednesday, 16 April 2008 6:23 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Files Open I'm sorry, I meant within the process running. E.g. stack=system(9001) files.open=somesystemfunction() Thanks DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] INCLUDE weirdo
Does anyone else think it's bad practice to have code in INCLUDES? Surely it would be much better to have the INITIATE.FEEDBACK GIVE.FEEDBACK routines written as subroutines, and then simply call them from the appropriate spots. If the code in either of those routines needs to be changed, you'll need to also recompile all the programs using the include. But as subroutines all you need to do is recompile the subroutine in question. Although, INCLUDES are fantastic for things like common equate definitions. Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Cumulative Trouble in paradise
Not sure if this solution will work in UniData (but it does in Universe): Try writing an iType using this code: @2;Qty+@ eg: SORT FLAT.SHD BY Frame_Color BREAK.ON Frame_Color TOTAL Qty EVAL @2;Qty+@ The @2 means use the 2nd value defined in the iType, but because the 2nd value hasn't been evaluated yet, it uses the 2nd value from the previous iteration (ie. The running total). Adrian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Tuesday, 26 February 2008 7:38 AM To: U2-Users Subject: [U2] Cumulative Trouble in paradise DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UB] Beep Error
If you use @SYS.BELL instead of CHAR(7), the bell can be turned on or off using BELL ON or BELL OFF. BELL ON/OFF - toggles the value of @SYS.BELL between CHAR(7) and . -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Friday, 15 February 2008 12:32 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] [UB] Beep Error How do I send a rudimentay ascii audio error beep message when an end-user makes a keyboard error? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SLEEP 60 slept only 53 seconds, or else TIMEDATE() is
--- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Deep and long indentations vs multiple exit points
But this is so much easier to read (note the liberal use of blank lines making the conditions easy to spot): LOOP WHILE READNEXT ID GOSUB PROCESS.REC REPEAT RETURN PROCESS.REC: READ RECORD FROM FILE,ID ELSE RETURN IF RECORDFLD.1 NE COND1 THEN RETURN IF RECORDFLD.2 NE COND2 THEN RETURN IF RECORDFLD.3 NE COND3 THEN RETURN RECORDFLD.4 = 'PROCESSED' WRITE RECORD TO FILE, ID RETURN (hopefully the mail list didn't screw with the formatting) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: Friday, 30 November 2007 1:46 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Deep and long indentations vs multiple exit points snip I had to look up the CONTINUE statement. In 25 years I've never used it, and don't even remember seeing it used. Now I know what it does I think it should be banned. /snip I use CONTINUE all the time when processing records that must meet multiple conditions in a loop. This way my code doesnt look like 'flying geese'. I will write: LOOP WHILE READNEXT ID READ RECORD FROM FILE, ID ELSE CONTINUE IF RECORDFLD.1 NE COND1 THEN CONTINUE IF RECORDFLD.2 NE COND2 THEN CONTINUE IF RECORDFLD.3 NE COND3 THEN CONTINUE RECORDFLD.4 = 'PROCESSED' WRITE RECORD TO FILE, ID REPEAT instead of: LOOP WHILE READNEXT ID READ RECORD FROM FILE,ID THEN IF RECORDFLD.1 EQ COND1 THEN IF RECORDFLD.2 EQ COND2 THEN IF RECORDFLD.3 EQ COND3 THEN RECORDFLD.4 = 'PROCESSED' WRITE RECORD TO FILE, ID END END END END REPEAT ___ Yahoo! Answers - Got a question? Someone out there knows the answer. Try it now. http://uk.answers.yahoo.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Deep and long indentations vs multiple exit points
I much prefer the multiple exit point method, it makes the code a lot easier to read. Prime examples are when you are looping through a file but only want to process certain records that pass a lot of conditions, it so much easier to test each condition individually and then RETURN immediately. Some people blindly want to stick with a single exit point, but as I see it, an early RETURN is basically an exception which the more advanced languages allow and encourage. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good Practice?
Keith said: Then, to avoid the long setup string, one has to use CONVERT (or SWAP or CHANGE). You can always hard-code value-marks: TEST = AF1}CK1}CK2}H}LHC}MP}NU1}NU2}TK1}TK2 Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good Practice?
The original new INDEX code (as posted by Keith) was... IF INDEX(TEST,'\':F200.SCHEME.CODE:'\',1) THEN THAT = Including the delimiters at the front back of the string, which prevents any false positives (like finding CK in CK1). Personally, I like the LOCATE solution as it makes for much more readable obvious code, eg. LOCATE CODE IN VALID.SCHEME.CODES1 ... But, if you're solely looking for speed, I'm pretty sure INDEX is the quickest way to go. Another possibility would be to use MATCHES, which works well (but only for shorter lists), eg. VALID.CODES = AF1}CK1}CK2}H}LHC}MP}NU1}NU2}TK1}TK2 IF TEST MATCHES VALID.CODES THEN... or even... THAT = (TEST MATCHES VALID.CODES) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Monday, 26 November 2007 1:03 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Good Practice? I find this kind of evolved junk a lot. There's one caveat that you should include: TEST = '\AF1\CK1\CK2\H\LHC\MP\NU1\NU2\TK1\TK2\' CONVERT \ TO CHAR(254) IN TEST LOCATE F200.SCHEME.CODE IN TEST SETTING FOUND THEN ELSE While actual mileage may differ, when having a lookup table and using INDEX, the value of F200.SCHEME.CODE of CK will trigger a false positive. I like to boil down complex boolean expressions into readable words as well. Somehow causes clarity, especially with very verbose variable names. MJ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OCONV Extraction Question - Good Practice
Using FMT forces correct syntax use. Having the trailing formatting characters, can cause all kinds of issues with small typos in the code (especially when the compiler just takes it all in it's stride). Look at these two examples: * Accidentally inserting a space into a numeric constant A = 123 4 CRT A * displays 123. * missing out a colon or a comma CRT XYZ ABC * Displays ABC We use a syntax checking program which throws both of these out as bad syntax, so the code never gets anywhere near production. IMO the compiler shouldn't accept this type of formatting (or perhaps there should be a compiler $option). Although, we are a closed shop and work exclusively in PI/Open flavour, so portability isn't an issue for us. AdrianW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Thursday, 22 November 2007 2:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OCONV Extraction Question - Good Practice I gotta ask. How is it a disaster waiting to happen. This 'best practices' exercise may die an early death with such unauthorized conclusions. How are you judging the CRT example as 'disasterous'. Mark Johnson BTW, the FMT expression may not play well with other MV flavours. Thus, I tend to program continouosly to cover all of my client's needs. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OCONV Extraction Question - Good Practice
IMO, the only thing wrong with your example is the use of the trailing format strings - everyone (and I mean everyone) should be using the FMT function, making your example: CRT FMT(OCONV(VAR1,MD0),R#6 ):FMT(OCONV(VAR2,MD2),R#10 ):FMT(OCONV(VAR3,MD4),R#14) The old method is a disaster waiting to happen. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Tuesday, 20 November 2007 2:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OCONV Extraction Question - Good Practice Here begins the voting for differences. I actually do not care for the inclusion of the extra Var1.F variables as, mentioned earlier, is that variable used elsewhere? Plus, it implies that it maybe part of a calculation instead of an upcoming, disposable CRT statement. Will I rot as I use this CRT statement? CRT OCONV(VAR1,MD0)R#6': :OCONV(VAR2,MD2)R#10: :OCONV(VAR3,MD4)R#14. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] What is this error??
Take a look at the ED code - it's in the BP of the uvhome account, named ED.B There's a bunch of code relating to CASE, and there's this mod line at the top of the program: 06/01/03 E2835 LFD For 10.1 TCL Case Insensitivity project So, I guess you can blame someone with the initials LFD ;) But, what I can't believe is that some of you guys are still using ED. Why? You must have access to something better than a line editor. AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] - Getting the call stack trace within a program
Checkout SYSTEM(9001) - this should return what you're after. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lubin Sent: Monday, 3 September 2007 3:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] - Getting the call stack trace within a program I would like to write a program that will enable me to identify which program has modified our master file. I have a generic program that issues the write command, but would like to know what program/subroutine called this generic program. Alternatively, I am also looking at putting a trigger on the file to identify when the record was modified. One of the details that I want to capture is the call stack trace (Like the one produced by the debugger/RAID T command) Is it possible for me to execute a basic statement/function that will return the call stack trace. I know that we can issue a PORT.STATUS PID LAYER.STACK, However, this is a very resource hungry command (and can only be executed by 1 user at a time) and also the PORT.STATUS command cannot be issued from a file trigger program. For example if I have PROGRAMA that calls SUBRA which in turns calls SUBRA2 and finally the GENERIC.WRITE, I would like to issue a command that will return the subroutine stack : PROGRAMA ; SUBRA; SUBRA2; GENERIC.WRITE (preferably with the line number that called the various subroutines) Thanks Bernard Lubin Development Department Reynolds and Reynolds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Speeding up a big BY.EXP select
Just one thing to be aware of: SSELECT implies BY @ID so the BY @ID in your statement is redundant. To prevent sorting by @ID just use SELECT not SSELECT. So, if you are using SSELECT then you're already sorting by @ID, so I doubt you are going to make it any quicker by modifying your SELECT statement. One cheap nasty way to speed up a sort would be to programmatically dump all the keys to a flat file (e.g. 10 lines for each @ID concatenated with each MV formatted), and then use the UNIX sort command. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Thursday, 9 August 2007 3:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Speeding up a big BY.EXP select I have a large file with an MV set I need to do an exploding sort against (about 2 million records, about 20 MVs per record). I'm not actually after any particular sort order but it's taking hours. I'm wondering if there is any efficiency advantage by telling it to use a primary sort on the ID or just to sort on the MV attribute? My (probably flawed) reasoning is that if the primary sort is on the id then the sort process wouldn't have to build up one big explode - as it would have a primary sort by record, it then only needs to explode each record at a time. Eg. SSELECT BIGFILE BY @ID BY.EXP MV.ATTRIBUTE Or SSELECT BIGFILE BY.EXP MV.ATTRIBUTE Anyone know the answer to that one? Stuart Boydell DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Logged user list
Try SYSTEM(1302) - each attribute holds details about one user (no, username, pid, type) eg: USERS = SYSTEM(1302) CRT USERS1 CRT USERS2 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of chuchi Sent: Tuesday, 10 July 2007 5:34 PM To: u2-users@listserver.u2ug.org Subject: [U2] Logged user list Hi all, I have some problems getting the users currently logged into the system. If I launch a LISTU command, in some operating systems I cannot see the user names, only the ids. There are any way to get the user name list in TCL, basic or any operating system commnad? Regards, Chuchi DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] Conversion code for week number
Does anyone know of a conversion code that returns the week number of the year? DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Conversion code for week number {unclassified}
Thanks for that Mike. I'd forgotten about pickwiki.
I found this function which should do the trick:
http://www.pickwiki.com/cgi-bin/wiki.pl?IsoWeekNum
Thanks,
Adrian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE,
MR
Sent: Wednesday, 11 July 2007 12:14 PM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] Conversion code for week number {unclassified}
Adrian,
This has been discussed before on the list.
IIRC, there is no built-in U2 support (i.e. conversion code) for this,
at least partly because it's one of those nasty 'depends what you mean'
questions.
For example,
* is the first week in the year week # 0 or 1?
* when does the first week start - the first day in the year, the first
Sunday in the year, the first Monday, ... ?
There is I believe an ISO standard, but that may not be what you want.
There may be something in Pickwiki
Regards
Mike
DISCLAIMER:
Disclaimer. This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
{Blocked Content} RE: [U2] Tony Jones/WA/QBE/Insurance is out of the office.
Warning: This message has had one or more attachments removed Warning: (not named). Warning: Please read the AngelicHost-Attachment-Warning.txt attachment(s) for more information. Karl, You're right about these messages being annoying - but you're wrong about 5 months. It's actually 5 days. You Americans never did manage to get your date formatting correct did you? ;) From: [EMAIL PROTECTED] on behalf of [EMAIL PROTECTED] Sent: Thu 5/07/2007 10:25 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Tony Jones/WA/QBE/Insurance is out of the office. Dear Mr. Admin, Please unsubscribe Mr. Jones as looking forward to 5 months of 'out of the office' auto-replies is a highly annoying consideration. Thanks A Heap! KLP quote who=Tony Jones I will be out of the office starting 04/07/2007 and will not return until 09/07/2007. I will respond to your message when I return. - IMPORTANT NOTICE : The information in this email is confidential and may also be privileged. If you are not the intended recipient, any use or dissemination of the information and any disclosure or copying of this email is unauthorised and strictly prohibited. If you have received this email in error, please promptly inform us by reply email or telephone. You should also delete this email and destroy any hard copies produced. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com http://www.atsindustrial.com/ 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. This is a message from the MailScanner E-Mail Virus Protection Service -- The original e-mail attachment winmail.dat was believed to be infected by a virus and has been replaced by this warning message. If you wish to receive a copy of the *infected* attachment, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Thu Jul 5 08:24:18 2007 the virus scanner said: Could not parse Outlook Rich Text attachment Note to Help Desk: Look on the AngelicHost MailScanner in /home/virtual/site2/fst/var/spool/mail.quarantine/20070705 (message l65FOEbI013736). -- Postmaster MailScanner thanks transtec Computers for their support --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
{Blocked Content} RE: [U2] @VARIABLES
Warning: This message has had one or more attachments removed Warning: (not named). Warning: Please read the AngelicHost-Attachment-Warning.txt attachment(s) for more information. If the includes only contain EQUATES then there is no point in using GOSUB, as EQUATES are resolved at compile time. From: [EMAIL PROTECTED] on behalf of MAJ Programming Sent: Fri 23/03/2007 9:55 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] @VARIABLES snip Maybe I'm missing something. Since I still have a few old Microdata clients and I miss using regular Includes (and regular called subs), I make the very first line of code GOSUB GET.INCLUDES and put all of my Includes at the end of the program. That takes care of the line number offset problem. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. This is a message from the MailScanner E-Mail Virus Protection Service -- The original e-mail attachment winmail.dat was believed to be infected by a virus and has been replaced by this warning message. If you wish to receive a copy of the *infected* attachment, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Sat Mar 24 03:54:03 2007 the virus scanner said: Could not parse Outlook Rich Text attachment Note to Help Desk: Look on the AngelicHost MailScanner in /home/virtual/site2/fst/var/spool/mail.quarantine/20070324 (message l2OArwp4013691). -- Postmaster MailScanner thanks transtec Computers for their support --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] @VARIABLES
Are you guys aware of the universe supplied include: ATFUNCTIONS.INS.IBAS (or ATFUNCTIONS.H) which resides in .../uv/INCLUDE Here's an extract: EQUATE IT$CSTO -1 ;* clear screen (ANSI) EQUATE IT$CAH TO -2 ;* cursor absolute home (ANSI) EQUATE IT$CLEOS TO -3 ;* clear to end of screen EQUATE IT$CLEOL TO -4 ;* clear to end of line EQUATE IT$SBLINKTO -5 ;* start blinking field EQUATE IT$EBLINKTO -6 ;* end blinking field We created our own include to define the most commonly used, using the supplied names: EQUATE ERASE LIT @(IT$CS) EQUATE HOME LIT @(IT$CAH) EQUATE CS LIT @(IT$CLEOS) EQUATE CL LIT @(IT$CLEOL) EQUATE BLNK LIT @(IT$SBLINK) EQUATE BS LIT @(IT$CUB) EQUATE BG LIT @(IT$SHALF) EQUATE FG LIT @(IT$EHALF) EQUATE INVLIT @(IT$SREV) EQUATE NORM LIT @(IT$EREV) etc. IMO it's best to use EQUATES as then there is no possibility of someone accidentally assigning something else to those names. Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] @VARIABLES
Nothing wrong with TO. LIT means literally, I usually use TO for numbers and LIT for everything else. Using LIT with strings containing spaces is a little clearer than using TO. The help for EQUATE states TO is for equating to an expression, whereas LIT is for equating to a string. Regarding INCLUDES, I did state We created our own include to define the most commonly used. We also have one set of equates for each of our data files (used for field numbers), but they all exist in their own include, making field names unique across all of our systems. Most of our programs will have five or six INCLUDES at the top and then they drop straight into the code. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Friday, 23 March 2007 1:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] @VARIABLES Two things: 1. What does LIT mean? 2. How popular is having this double equate situation. What's wrong with EQUATE ERASE TO @(-1) I have a small pet peeve with equates like this. If not in an include it causes the programs to become very hard to read as you're listing hundreds of lines before you get to any real action. Second, not being in an include, the prior programmers may have had many sets of equates (one per data file) taking up so much room and the gist of the program is: LOOP WHILE READNEXT ID DO READ CUST FROM F.CUSTOMER, ID ELSE CONTINUE CUSTCM$MTD.SALES= WRITE CUST ON F.CUSTOMER, ID REPEAT So this program may be 200-300 lines only to support this function. Third, not having them in an include may cause some deviation amongst the different programs using the same files. I've got a new client with an old box using the ABEST programming structure and while it supports INCLUDES, each program may have hundreds of lines of individual equates for simple updating like above. I'm trying to rein in the horses by converting to an include but I have to neutralize the field name differences. Very unreadable. For the newbies, if you're going to use many equates, put them in an INCLUDE for consistency. My 2 cents Mark JOhnson - Original Message - From: Womack, Adrian [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 22, 2007 7:29 PM Subject: RE: [U2] @VARIABLES Are you guys aware of the universe supplied include: ATFUNCTIONS.INS.IBAS (or ATFUNCTIONS.H) which resides in .../uv/INCLUDE Here's an extract: EQUATE IT$CSTO -1 ;* clear screen (ANSI) EQUATE IT$CAH TO -2 ;* cursor absolute home (ANSI) EQUATE IT$CLEOS TO -3 ;* clear to end of screen EQUATE IT$CLEOL TO -4 ;* clear to end of line EQUATE IT$SBLINKTO -5 ;* start blinking field EQUATE IT$EBLINKTO -6 ;* end blinking field We created our own include to define the most commonly used, using the supplied names: EQUATE ERASE LIT @(IT$CS) EQUATE HOME LIT @(IT$CAH) EQUATE CS LIT @(IT$CLEOS) EQUATE CL LIT @(IT$CLEOL) EQUATE BLNK LIT @(IT$SBLINK) EQUATE BS LIT @(IT$CUB) EQUATE BG LIT @(IT$SHALF) EQUATE FG LIT @(IT$EHALF) EQUATE INVLIT @(IT$SREV) EQUATE NORM LIT @(IT$EREV) etc. IMO it's best to use EQUATES as then there is no possibility of someone accidentally assigning something else to those names. Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with File Pointers
FILEINFO always returns the correct fully resolved path (without any double dots) under Universe on Unix. Maybe this problem only affects Windows. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Tuesday, 13 March 2007 6:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with File Pointers The FILEINFO idea is a good one -- but it will not serve. [SJ] Here's one file pointer PRCPROCESS: F PRCPROCESS D_PRCPROCESS Here's the other: DEMO.DOTS: F ..\PRC\PRCPROCESS ..\PRC\D_PRCPROCESS They actually do point to the same file. But the output of FILEINFO IS THIS: FILE NAME = DEMO.DOTS, FILEINFO.PATH = C:\SJ\REALMS\PRC\..\PRC\PRCPROCESS FILE NAME = PRCPROCESS, FILEINFO.PATH = C:\SJ\REALMS\PRC\PRCPROCESS So you wouldn't be able to tell by comparing those that they were the same. You still have to resolve the dot business somehow. Susan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] old dog, new tricks
This is more of an old trick. The reason that -1 is so much faster is because using -1 just appends to an already existing string in memory. Where using n will cause an entirely new string to be created and the old one thrown away (to be eventually garbage collected). The process gets slower slower as each successive string becomes larger and larger. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Friday, 9 March 2007 11:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] old dog, new tricks Perhaps this is not a revelation to many of you, but I did not realize how _much_ faster it is to append items to a large array using -1 vs. an incrementing count, e.g. n. I was trying to speed up a program that builds large arrays, and changed to the -1 style append. Wow [can I say that? this is a linux box, not MS-Vista; is wow copyrighted yet?], huge improvement! (UV 10.1.4 pick flavor, intel cpu). Of course, when using -1 you need to check for nulls as appropriate, but even adding after adding code to test for and handle appending a null attribute this is still way faster. Also, I think UV is optimized for AMs vs VMs, so that it pays to CONVERT @VM TO @AM IN XXX, do your thing, then CONVERT @VM TO @AM IN XXX back when done if you need VMs. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Using CONV in XML output string
I just tried this out - and it does let you use multiple CONVS one after the other. BUT, I would normally use FMT L#100 rather than CONV T100. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Thursday, 22 February 2007 10:56 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Using CONV in XML output string I'm constructing a LIST TOXML sentence on the fly. Does anyone know if you can combine two CONV modifiers on a TCL line? I'm extracting data which needs to meet length criteria (T100) and also needs to ensure that all the characters are printable (MCP). Eg LIST TEMP ID.SUP @ID AS ProductID F1 AS Description CONV T100 CONV MCP TOXML Cheers, Stuart Boydell DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Using CONV in XML output string
We're on UV 10.1.20 (in PI/Open flavour). The L#100 is a format not a conversion, so should be used with FMT not CONV. Eg. LIST TEMP ID.SUP F1 AS Description FMT L#100 CONV MCP TOXML Or using two CONVs: LIST TEMP ID.SUP F1 AS Description CONV T100 CONV MCP TOXML I even tried three CONVs and it still worked - eg. LIST TEMP ID.SUP F1 AS Description CONV T100 CONV MCP CONV MCU TOXML (causing the Description to be 100 characters long, printable uppercase) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Thursday, 22 February 2007 1:51 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Using CONV in XML output string Hi Adrian, Thanks for the response; multiples aren't working for me [UV10.0.7]. What syntax are you using? L#100 works differently to T100 (here) - T truncates to a particular length (which is what I want to ensure that the column width does not exceed the size of the target SQL column). Eg L#6 vs T6 L#6 - ... Description=Widget with multiple frustum gimlets / T6 - ... Description=Widget / Cheers, Stuart DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Saving daylight.
We had a specific problem with Redback - when the OS went to daylight savings time, Universe also went to daylight savings time - BUT Redback did not. This was because the Redback ini file (rgwresp.ini) has it's own TZ parameter, which in our case was wrong. I should think you'll be OK as long as this parameter matches your OS timezone parameter. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Tuesday, 6 February 2007 6:35 AM To: u2-users@listserver.u2ug.org Subject: [U2] Saving daylight. Worried management is asking verification that UV RedBack will be ok with the upcoming savings time change to the start end dates. But I don't see any statement to that effect. I don't think see how it would be a problem inherent in U2, since dates and times are resolved by the OS. The only place I think they'd possibly have a chance to screw it up would be under transaction log restores or data replication. Maybe RedBack, when figuring out how old a request from a web client is. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [BB] Internal functions in Basic
I'd really appreciate a way to write an internal function which can have
parameters and can contain it's own local variables (although global
variables would be OK). Often it's just not worth the effort to write a
full blown external function that's only called a few times by one
program.
Perhaps these could be defined after the final END statement in the
program.
Something like:
.
.
ANS = MYFUNCT(12, 34)
CRT MYFUNCT(56, 78)
END
DEFFUN MYFUNCT(I, J) {
FUNCT.VAR = I * J
RETURN (FUNCT.VAR)
}
DISCLAIMER:
Disclaimer. This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV/Redback] Daylight Saving
I'm in Perth WA, and we're on Daylight Saving for the fist time in years (as of 2am Dec 2nd). This has caused all kinds of problems, as it was a last minute decision by the government and we had hardly any time to get the various config files setup correctly. We're running UniVerse 10.0.19 (PI/Open flavour) in HPUX. We updated the appropriate config files and rebooted the Unix boxes last week. Unix Universe both clicked over successfully to use the WDT (Wester Daylight time) timezone instead of WST (Western Standard Time). And both Unix Universe are returning the correct time. BUT, our single redback process, which calls Universe routines to update files with some data derived from TIME(), is still returning the WDT time (i.e. 1 hour earlier). We've restarted redback (using restartrgw, I've also tried stoprgw followed by startrgw), and this made no difference. Anyone have any ideas? Thanks, AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Query calculating 120 days.
A couple of points: Gordon's example: DATE()[EMAIL PROTECTED]6 should really be using a D-type named field instead of using @RECORDnn Jeff's example: DATE() - ICONV(*YOUR.DATE.FIELD.HERE*,D4/) - the date field should already be in internal format, so what's the point of the ICONV ? AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] is a file 32bit or 64bit?
Well, I do think there should be a documented method of finding out whether a file is 32 or 64bit. Surely that should be added to ANALYZE.FILE. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Thursday, 19 October 2006 1:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] is a file 32bit or 64bit? So what you're really after is a list of the undocumented options? DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] is a file 32bit or 64bit?
Something interesting I just noticed: If I create a file and resize it to 64bit and then create alternate keys (with CREATE.INDEX) the alternate key file (I_filename/INDEX.000) is also created as 64bit. BUT, if I add the alternate keys BEFORE resizing to 64bit, the AK file is left as a 32bit file. As a 64bit file, the data portion can now contain many, many more records than a 32bit file. So if the file has a number of different alternate keys, it could be possible to blow the size of the INDEX.000 file. So, I guess it may be best to delete and re-create the AKs after converting to 64bit. Thoughts? Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] is a file 32bit or 64bit?
Is there a UV tool that shows whether a file is 64bit or 32bit? I've tried the obvious ANALYZE.FILE with no success. I ended up using the unix xd command to see the file's header, but I expected there to be UV command to provide this function. First bytes of a 32 bit file: 0xACEF010C First bytes of a 64 bit file: 0xACEF020C AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] is a file 32bit or 64bit?
That works well, thanks. For some reason our BASIC help file only has attributes 1-30 defined for the result of the STATUS statement. I just checked the BASIC pdf manual and that documents from right up to attribute 33. I never think of using the STATUS statement - but it certainly returns a lot of useful information! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, 19 October 2006 11:19 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] is a file 32bit or 64bit? Hi Adrian, You could use the STATUS function in basic. STATUS STATS FROM FILE ELSE ABORT BIGFILE = (STATS32 = 5) DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Weird Logging Issue
Karl, Is that a UniData thing? Because with UniVerse exactly the reverse would be true - writing to a sequential file (via CRT statements to a COMO or with WRITESEQ to a record in a directory) would be much more efficient and use less memory than performing a WRITEV (which has to read the entire record in to memory so it can replace the field and then writes the entire record out again), and that's without your overhead of reading the record in the first place to simply count how many lines it has. I'd be surprised if the size of the PH record has anything to do with the problem. AdrianW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 11 October 2006 12:48 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UD] Weird Logging Issue I suspect you are right, but consider that you are writing to a sequential file when you use the PH file as a 'log' file. Handling that much data in an ongoing process will fill up the memory space assigned to the phantom process. At least that's my story... I would recommend actually opening up an item in a file, counting the number of lines in the file (with a routine to delete the top of the file as it grows beyond a useful size) and then doing: WRITEV DATALINE on FILE,LOGNAME,NEWLINE# THEN/ELSE . . . That way, you have very little user space memory wasted and can control the log file size. HTH, Karl DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] How to create unix .netrc file?
I wanted to do something similar (allowing a user to edit their .profile record from within UV). What I ended up doing was using a file name without a dot and then using SH to execute a unix cp to change the file's name. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 4 October 2006 1:57 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] How to create unix .netrc file? Just wondering how to create a new unix file prefixed with a dot. I have tried: openpath b/home/acctb to ff then write x on ff,b.netrcb However, this creates b ?.netrcb with a question mark. Anyone know what might be a better way to do this? Thanks, Stuart DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] UniQuery SELECT WITH Limits
The OP never made it clear what he was trying to do. He may in fact be trying to select randomly numbered ID's and if that is the case, he doesn't actually need a select statement at all. Perhaps we should wait until he gives us a little more info. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Using DICT items in basic program
Assuming you're dictionary items are D-types, just read the dict item
then use field 2 as a field number to extract the data from your record.
Use field 3 with OCONV and use field 5 with FMT.
If you want to use I-types, simply set @RECORD to the contents of your
data record, and @ID to the record id, and then use the ITYPE function.
eg.
READ DATA.REC FROM FILE.VAR,DATA.ID
ELSE STOP
READ DICT.REC FROM DICT.VAR,DICT.ID
ELSE STOP
* D-type example
FIELD.NO= DICT.REC2
CONV = DICT.REC3
FORMAT = DICT.REC5
CRT FMT(OCONV(DATA.RECFIELD.NO,CONV),FORMAT)
* I-type example
READ ITYPE.REC FROM DICT.VAR,ITYPE.ID
ELSE STOP
CONV = ITYPE.REC3
FORMAT = ITYPE.REC5
@RECORD = DATA.REC
@ID = DATA.ID
THE.DATA = ITYPE(ITYPE.REC)
CRT FMT(OCONV(THE.DATA,CONV),FORMAT)
AdrianW
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward
Sent: Thursday, 31 August 2006 6:21 AM
To: U2-Users List
Subject: [U2] Using DICT items in basic program
Hi folks,
I'm trying to set up a general use utility and what I'd like to do is to
be able to call this utility, passing it an open file handle, a couple
other parameters plus one that could be used to specify a dict entry
name, not a field number. The catch is I'd like to use the dict entry
regardless of what type of definition it is. Obviously there would be
some limits but the general definition is that the dict item ultimately
points to a piece of data. An example would be I would want to use a
data position field like CUST.NUM in the INVOICE file. I'd also want to
be able to use something like CUST.NAME in the INVOICE file which would
be a pointer to the CUSTOMER file's NAME field. The utility would use
READ or maybe XLATE to obtain the desired information. I looked at
ITYPE() but I'm not sure that's going to get me what I'm looking for.
In AREV it was simply using the {} brackets.
TIA
BobW
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
DISCLAIMER:
Disclaimer. This e-mail is private and confidential. If you are not the
intended recipient, please advise us by return e-mail immediately, and delete
the e-mail and any attachments without using or disclosing the contents in any
way. The views expressed in this e-mail are those of the author, and do not
represent those of this company unless this is clearly indicated. You should
scan this e-mail and any attachments for viruses. This company accepts no
liability for any direct or indirect damage or loss resulting from the use of
any attachments to this e-mail.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] up-arrow w/command stack
Rather than writing a program and using SYSTEM(4001) SYSTEM(4002), a slightly easier way is to use: COMMAND.EDITOR ON ALL acct name PI/Open had the COMMAND.EDITOR command years ago, and it was documented. The version in Universe is not documented and is most likely not supported. When we switched from PI/Open a few years back, we determined that the Universe implementation of COMMAND.EDITOR was buggy (which is probably why it's undocumented). We just ended up writing our own emulator to do everything the PI/Open version did. (We also wrote our own version of EDFS without the bugs). AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Show Empty Fields in Vertical Listing
I wonder if this problem is flavour dependent. I'm using PI/Open flavour UV 10.0.19 and ALL fields show up when listing vertically whether they are blank or not. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need help - UV intermittent roving file open error
I don't believe it - you're right! I could have sworn that using a DIM on a previously defined common array would do nothing, well I stand corrected. Maybe I'm remembering what happened under PI/Open, but it certainly does work under Universe. Sorry for the misinformation. :( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 25 August 2006 2:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need help - UV intermittent roving file open error Really? It's redimensioning in common here on UV10, aix, PICK flavour, no question about it. Exactly for the purpose of a file open subroutine used in hundreds of programs with hundreds of users... No complaints. I have even just written a test program which redims a vector in common and works. Although it seems logical not to be able to change a dimension in common, if common variables are just pointers to a memory slot then extending an array probably just means pointing to some non-sequential memory for the new dimensions (just a guess). Maybe there is some other flavour/uvconfig flag which affects this? Stuart __ Dimensioned arrays can be resized - BUT arrays defined in common can't. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Continuing Long Lines
The original poster was asking about a single IF statement and how to split it into several lines, I don't think using a CASE structure would solve this particular problem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol Sent: Friday, 25 August 2006 11:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Continuing Long Lines Goo'day, At 11:01 25/08/06 +0800, you wrote: One way to break up a large condition is to do something like this... COND1 = (condition1 OR condition2) COND2 = (condition3 OR condition4) COND3 = (condition5 AND condition6 AND condition7) IF COND1 OR COND2 OR COND3 THEN... You could make the variables COND1, COND2, etc. meaningful (like AMOUNT.TOO.LARGE, OVER.LIMIT, WRONG.SUBURB). Wouldn't this look much cleaner and neater (not to say more understandable) with CASE statements? Regards, Bruce Nichol DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Where's the beef??
There should be a file pointer to SYSCOM in your VOC. Ours contains: 1: F 2: /opt/universe/uv/INCLUDE 3: /opt/universe/uv/D_INCLUDE Here's the bit that's relevant to SELECTINFO... * Keys for SELECTINFO function EQUATE IK$SLACTIVE TO 1 EQUATE IK$SLCOUNTTO 3 AdrianW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Tuesday, 22 August 2006 8:27 AM To: U2-Users List Subject: [U2] Where's the beef?? Straight out of the online help is the following code: $INCLUDE SYSCOM INFO_KEYS.INS.IBAS IF SELECTINFO(3,IK$SLACTIVE) THEN READLIST LIST3 FROM 3 ELSE LIST3 = '' END Question I have is where the @[EMAIL PROTECTED] is SYSCOM located? I can't seem to find it anywhere. If not that then does anyone have the numeric values for SELECTINFO(x,???) DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
It's Universe Basic. It works on UV 10.0.19 on HPUX. From: [EMAIL PROTECTED] on behalf of Tom Dodds Sent: Thu 10/08/2006 8:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character What language is this for and upon which machine does it work? It looks great, but it won't work as a paragraph or a basic program on a UniVerse system. Uv 10.1.11 AIX 5.2.2. Thanks Tom Dodds [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character We use this little routine (found it somewhere) : P 0001: STELPROMPT = @WHO : '' 0002: ASSIGN 1 TO SYSTEM(4001) 0003: ASSIGN STELPROMPT TO SYSTEM(4002) Bottom at line 3. Schalk van Zyl DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change command prompt character
Huh? That makes no sense. The ASSIGN is only done once per session, i.e. at login time. I think having your prompt showing whether there was an active select list active when you logged in, isn't really that useful ;) FWIW We have our own command editor, which shows which selectlists are active in front of the prompt - so, for example, if selectlists 1 2 are both active, the prompt would be: 12: Where the 12 is in half intensity. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Friday, 11 August 2006 11:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change command prompt character How about replacing the third line with ASSIGN MYPROMPT : (IF SELECTINFO(0,IK$SLACTIVE) THEN ELSE ) TO SYSTEM(4002) to handle the active Select List #0 case? (To use the mnemonic you will have had to include INFO_KEYS.H.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] FIND vs LOCATE- speed?
If you don't care about the resulting position - i.e. you just want to know if the list contains the item, then the absolute quickest method is to use INDEX(). Eg looking for JKL in ABC}DEF}GHI}JKL}MNO}PQR THE.LIST = @VM:ABC}DEF}GHI}JKL}MNO}PQR:@VM IF INDEX(THE.LIST,@VM:JKL:@VM,1) THEN found The extra value marks at the beginning and end are required to ensure the value you're looking for isn't contained within another value. Even if you do need the position, INDEX can be quicker, just use COUNT afterwards to determine the number of marks that appear before the INDEX position. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, 3 August 2006 8:24 AM To: U2-users (E-mail) Subject: [U2] [UV] FIND vs LOCATE- speed? When using FIND or LOCATE on a dynamic array, is one faster than the other, and is there any reason to sort the array to (hopefully) improve the speed of FIND or LOCATE? I don't need to use LOCATE... BY... SETTING, I'm just doing a raw FIND or LOCATE. Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] lock records
We do exactly the same thing but with READU locks instead. The locks can be on non-existent records and the record names can be meaningful (eg. processname.running) - so a LIST.READU will show which phantoms are running. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Thursday, 27 July 2006 4:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] lock records A most useful mechanism (and much ignored) for controlling and communicating with PHANTOMS: LOCK n e.g. A Phantom process starts up and sets (for example) LOCK 1 to say it is running. If the lock attempt fails then the PHANTOM process is already running and it terminates. A controlling process wants to check if the PHANTOM is running - it tries to set LOCK 1 and if successful releases the lock and knows that it is not running. If the lock IS set then the PHANTOM is running. When the controlling process wished to shut the PHANTOM down then it sets LOCK 2 and goes into a loop (with limits and SLEEP2) and waits for LOCK 1 to be released: As part of its normal cycle the PHANTOM checks LOCK 2 at intervals. If the lock is gained then it is released (no action). If LOCK 2 is set however then the PHANTOM unsets LOCK 1 and self-terminates normally under full control (no kills / logoffs etc). The controlling process detects the clearing of LOCK 1 (by trying to set it in its watching loop) and unsets LOCK1 and LOCK 2 - end (happy bunnies). If the PHANTOM does not terminate within a set period then you may choose to escalate to a force logout or try again. They same technique can be used for driving communications or application events, and if you have a LOT of processes so that the number of LOCKs available is insufficient then you can allocate pairs of locks dynamically (i.e. not hard-coded in the programs) from the pool available (default 1 - 64). Just so long as the number of locks in use at any one time does not exceed the maximum number of locks available. Works Neat (if I say so myself) Well tried and tested (over 12 years running to my knowledge). Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re-Comile I-Descriptors ?
Sounds like you've got INTEGER specified in field 8 (SQL Data) and MD1 specified in field 3 (Conversion) of the dictionary for the problematic field. Just removing INTEGER will fix the problem - but if you're using SQL on the file/table maybe you should replace INTEGER with the correct field type. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Wednesday, 28 June 2006 8:05 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Re-Comile I-Descriptors ? Several (working) legacy paragraph scripts yield errors on our new UniVerse server. The errors resemble... Conversion MD1 is incompatible with an INTEGER datatype. Do I need to re-compile I-Descriptors ? The legacy UniVerse is v 8.3.3; the new UV is v10. Both machines are HP-Ux. Suggestions would be appreciated. -Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] User exit help?
U035A exists in the file APP.PROGS (.../universe/uv/APP.PROGS) as 035A without the A. You could modify that to do what you want, or just write your own subroutine to do the same thing. IMO, you'd be better off writing your own, as the source code for that routine is atrocious (and commented in French!). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, 1 June 2006 4:58 AM To: U2-users (E-mail) Subject: [U2] [UV] User exit help? I've been using this for a long time to get a 1 character input from the user with a simple validation mask: RESPONSE = UPCASE(ICONV(0:@FM:'qQtTcC':@FM:'','U035A')2) Does anyone know another user exit that will do the same thing, but require the user to press ENTER after they enter their response? Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OPEN Statement DICT Default
All the months order (full names): CRT OCONVS(ICONVS(1}2}3}4}5}6}7}8}9}10}11}12,DM),DMAL) Abbreviations: CRT OCONVS(ICONVS(1}2}3}4}5}6}7}8}9}10}11}12,DM),DMAL[3]) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Tuesday, 9 May 2006 10:50 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OPEN Statement DICT Default I meant all of the months in order. Thanks. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE:[UV:Redback] Automatic Garbage Collection not running
John, Thanks for the tips. We are running 4.2.5 redback on UniVerse 10.0.19 on HP-UX. There's definitely an issue with GC getting stuck when it reschedules itself to run very close to midnight. I've got it running again and I'm monitoring it. If it does get stuck in the future, I guess we'll just have to run GC manually (via cron or another background task) disable the built in scheduler. I have resized the file to make it a lot larger, and I did keep it as a type 18. I was considering changing it to dynamic (99.99% of all our application files are dynamic - we came from PI/Open), but I'm not sure of any other implications of doing that to any of the WWxxx files. AdrianW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Friday, 24 March 2006 6:57 AM To: u2-users@listserver.u2ug.org Cc: 'Stevenson, Charles' Subject: RE: [U2] RE:[UV:Redback] Automatic Garbage Collection not running Charles From 4.2.6 you have WWSESSION to consider as well - AFAIK there is nor eason to do this manually nowadays. Historically UNIVERSE on UNIX had a specific issue Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: 22 March 2006 03:35 To: u2-users@listserver.u2ug.org Cc: Womack, Adrian Subject: [U2] RE:[UV:Redback] Automatic Garbage Collection not running We recently ran into a problem where the garbage collection (GC) process would no longer run (our WWSTATE file contained over a million records!, and the application response time was abysmal). RedBack 4.2.3, UV 10.0.16, HPUX 11i. When we upgraded from 3.x we expected some enhanced garbage collection but it didn't seem to work as advertised, so we went back to handling it explicitly. For our ap we know anything an hour old is not needed, so we schedule a paragraph every 1/2 hour that does: SELECT WWSTATE WITH HRS.OLD = 1 IF @SELECTED 0 THEN DELETE WWSTATE where DICT WWSTATE HRS.OLD 01: I 02: (@DATE-DATE) * 24 + INT( (@TIME - TIME)/3600 ) IIRC, IBM suggests WWSTATE should be dynamic-hashed, but I ended up with file corruption once upon a time shortly after changing it to dynamic. Go figure. So I changed it back to Type-18 with a much larger modulus than I should ever need. All access is direct reads. The only filescan is the purge selection shown above, so an extra large modulus is perfectly efficient disk is cheap. It works if ain't broke don't fix it, so I don't fix it. cds P.S. Strategy-7 is our support vendor, and their RedBack guy, Martin Fritter, has been a real gem to work with. I don't know much about RedBack and he's always gone the extra mile whenever I've needed him. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV:Redback] Automatic Garbage Collection not running
We recently ran into a problem where the garbage collection (GC) process would no longer run (our WWSTATE file contained over a million records!, and the application response time was abysmal). There is a control record VERSION in the file WWCONTROL which contains a date time that GC is next due to run. The date field was set to zero (meaning everyday) and the time field was set to 86397 (23:59:57). According to the WWLOG file, the last completed run of GC was at 22:59:57 (GC was set to run at the default value of every 60 minutes). It seems to me that there is probably a bug in the redback code that determines whether it is time to run GC or not. If the process doesn't run in the three seconds between 23:59:57 and midnight, then the current time will never be after 23:59:57 and therefore GC won't run - this seems to be the case for us. Has anyone else come across this problem? And what was your solution? I've heard of someone setting up a cron job to tidy up the WWSTATE file. I've altered the GC parameters to run every 1 day instead of every 60 minutes. Hopefully this will fix the problem as the VERSION control record now contains an actual date (tomorrow) instead of zero. AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV: tests for inequality failing. Wide0 parameter?
Wide0 should have no bearing on numbers in that range. The Wide0 problem that I've encountered is when values do look (and print) the same and an equality comparison fails (not the other way around). Are you sure COST.VISIBLE is true? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joey Walter Sent: Thursday, 2 March 2006 8:30 AM To: U2-Users@listserver.u2ug.org Subject: [U2] UV: tests for inequality failing. Wide0 parameter? I'm having a problem with comparisons for equality between variables failing. Very simple code: IF COST # COST.WAS THEN IF COST.VISIBLE THEN GOSUB SHOW.COST END And I'm expecting of course for the gosub to be executed when I know for certain the variables COST and COST.WAS are not equal - but it doesn't happen. For instance the test for inequality fails when the variable COST = 1505 and variable COST.WAS = 1507. I wrote a line of code to display the OCONV'd variables and in the case mentioned above it displayed this: recalc.unit.cost; cost was 15.07 cost is 15.05 But, the subroutine to display the new cost did not get executed. Anyway, I'm guessing it's a problem with that bizarre little parameter called Wide0? I currently have it set to 0x3eb0. Why do I have it set that way - purely because I had problems with the default setting and someone tossed me a clue and told me to try 0x3eb0 and I never had problems since on my development machine or any other - until now. Anyone that can help me out with this? What's a reasonable/functional setting for Wide0 parameter. I don't need accuracy past six decimal places. Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Passed argument in Subroutines
The arguments are passed by reference - so both RtnValue and InValue are pointing to the SAME variable in the calling routine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Tuesday, 7 February 2006 7:14 AM To: u2-users@listserver.u2ug.org Subject: [U2] Passed argument in Subroutines I was converting a few programs from D3 to UD and noticed the following: BILL 001 InValue = Test 002 CALL BILL.SUBR (InValue, InValue) 003 END BILL.SUBR 001 SUBROUTINE BILL.SUBR (RtnValue, InValue) 002 CRT InValue before-: : InValue 003 RtnValue = '' 004 CRT InValue after--: : InValue 005 RETURN 006 END The value of InValue, in the subroutine, is changed when the variable RtnValue is assigned a value. :RUN BP BILL InValue before-: Test InValue after--: This seems to indicate that there's a relationship between the variable InValue in the calling program and the subroutine; in the subroutine when RtnValue is initialized the variable InValue is also initialized. I'd have thought it's the positions that are important (since there must be the number of arguments must equal in both the calling and the called programs), not necessarily the variable names. Have I figured this out right, and is this correct? As I remember, the passed arguements in subroutines: 1) don't have to be the same name, and 2) are managed solely within the subroutine. Per the UniData documentation: SUBROUTINE Syntax SUBROUTINE sub.name[(argument1 [, argument2] ...)] Description If you pass arguments, the number of arguments in the CALL statement and the SUBROUTINE statement must match, although variable names do not need to be the same. Changes made to arguments in the subroutine retain their new values when UniData exits the subroutine and control reverts to the calling program. Naturally, I resolve the program by changing the code to pass different variables, as arguments, to the called subroutine. :-) Bill Haskett Advantos Systems, Inc. www.advantos.net (760)944-5570 (CA) (360)923-4838 (WA) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Best practices
Use the attribute names everywhere - the only place attribute numbers belong is in D-type entries in the dictionary and in an equate table in a single basic include file. From: [EMAIL PROTECTED] on behalf of Bill Haskett Sent: Sat 28/01/2006 4:24 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Best practices I've been converting dictionaries from a D3 dbms and am wondering what is considered best practices in virtual attribute design. Does one build standard Direct fields first then use these fields to build virtual attributes (I-Descriptors) or should one use the direct field references, EXTRACT() or n,n,n, in virtual attributes? DEPOSITED 001 D The date of the deposit. 002 2 VOID 001 D Is this a voided receipt? 002 12 DEPDATE 001 I The displayed deposit date (if not voided). 002 IF VOID = THEN DEPOSITED ELSE *Voided* or DEPDATE 001 I The displayed deposit date (if not voided). 002 EXTRACT( @RECORD, 2, 0, 0 ) ; EXTRACT( @RECORD, 12, 0, 0 ) ; IF @2 = THEN @1 ELSE *Voided* The obvious concern is if a direct field definition is renamed, then all references to the old field name need to be changed. I rarely rename a field, until I started exposing the data to other data sources and was forced to clean up the field names. So, hopefully, this won't be an issue in the future. Any thoughts. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] detecting remote pointers in basic?
Don't know about checking before the open - but look at the FILEINFO() function (see SYSCOM FILEINFO.INS.IBAS). FILEINFO(filevar, FINFO$NODENAME) should return for local files and the machine name for remote files, but this assumes the OPEN statement worked. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, 20 January 2006 5:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] detecting remote pointers in basic? How can I detect whether or not a file is a remote pointer to another box (preferably from within a basic program)? Unfortunately, from any given account, it can be a Q pointer to another account, where it's defined as remote in that VOC, so I can't just look for an exclamation point in field 2. I don't see anything in the status statement. The status function will return a -2 if the open fails, but I want to bypass remote files before even trying the open. Anybody know this one? tia DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] list output when captured
I haven't been following this thread - but, why don't you just LIST into the HOLD file and then get your program to read the results and delete the HOLD record? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, 20 January 2006 8:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] list output when captured David: Thanks...because I need the heading. :-) A SCROLL program takes the results of a query and simply pages it so the user can move around the report (up, down, all around, and search). We need the heading passed into the program (assuming one is). Bill DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] list output when captured
If you don't want to use the HOLD file (which IMO is the easiest thing to do), how about executing TERM to change the terminal width (and height) to something really large (eg 2000), execute your list statement, and then use TERM to set the width height back to normal. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, 20 January 2006 12:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] list output when captured Thanks Adrian. With all the things to do, I make it a point to keep all things simple. :-) I can still simply execute the AQL query into the captured variable and parse that...plain and simple. We're just scrolling output that one would normally want to view on the screen. This is a simple, yet effective solution. It appears I need to monitor when the total column width equals the term width and make sure I work around that. Thanks again. Bill DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] BASIC LOCKs
We use READU locks - they're much more friendly than semaphores as they can be given meaningful names that show up with a LIST.READU. Also they are very quick and easy to test with the RECORDLOCKED() function - eg. IF NOT(RECORDLOCKED(filevar, recordname)) THEN ... AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: Named common
I'm pretty sure everyone is talking about the named common name not the variable names (i.e. the name between the slashes in COMMON /ABC$123/ LONG.VARIABLE.NAME1, ETC The variables names defined within your common block should be able to be any length you like (perhaps restricted to 32 characters). From: [EMAIL PROTECTED] on behalf of Bill Haskett Sent: Tue 27/12/2005 4:02 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD: Named common Dave: The reason I suspected a joke was because most of us have never lived with restricted variable name lengths and no longer live with 8.3 DOS file names, except of course rundll32.exe, svchost.exe, etc. :-) A real pain when the application is used on various mvDbms environments. Thanks very much for your comments though. Bill DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
An alternative to using Larry's suggestion of writing a program to create a phrase of all the D types, you can use REVISE filename which will automatically create an @REVISE phrase in the dictionary containing all the D-types. You can then just rename @REVISE to ALL. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Friday, 2 December 2005 1:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword? How about just adding a phrase to each DICT called ALL that lists all of the D-type items? eg: DICT CUST.MST ALL 001: PH 002: CUST.NAME CUST.ADDR1 CUST.ADDR2 CUST.CITY ... etc You could even write a simple program to SELECT DICT filename WITH TYPE = 'D' BY LOC, and then loop through create the ALL phrases for that particular file. One time setup, then it's available for their use. Larry Hiscock Western Computer Service DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sort help needed
The original question didn't specify that PART.NBR had to be unique. Maybe it's a list of orders and possibly contains two different orders for the same part number. From: [EMAIL PROTECTED] on behalf of Keith W. Roberts Sent: Tue 8/11/2005 11:24 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort help needed Your logic is wrong here; you are inserting whether PART.NBR is found or not. The INS should be inside the ELSE clause. -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Womack, Adrian Sent: Monday, November 07, 2005 4:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Sort help needed LOCATE PART.NBR IN RECORD14,1 BY AL SETTING POSELSE NULL INS PART.NBR BEFORE RECORD14,POS INS related.data BEFORE related.field14,POS No need to do the second locate. Note: I've used the PI/Open syntax for the LOCATE statement (that's the only one I relate to), you may have to alter the syntax slightly. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sort help needed
LOCATE PART.NBR IN RECORD14,1 BY AL SETTING POS ELSE NULL INS PART.NBR BEFORE RECORD14,POS INS related.data BEFORE related.field14,POS No need to do the second locate. Note: I've used the PI/Open syntax for the LOCATE statement (that's the only one I relate to), you may have to alter the syntax slightly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Al DeWitt Sent: Tuesday, 8 November 2005 7:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] Sort help needed Environment: UniData - Pick Flavor I'm trying to build a multi-value field in part number order. I begin with LOCATE PART.NBR IN RECORD14 BY AL SETTING POS ELSE POS = 0 The first time through RECORD14 is empty. The second time RECORD14 has one value. If PART.NBR is of greater value than what is now in RECORD14 then I want PART.NBR to be the second value, if it is of lesser value than I want PART.NBR to be inserted before the value in RECORD14. I will then do a second LOCATE to see where PART.NBR is stored (RECORD14,x) and use that position to insert data into associated attributes. My problem is that I haven't done this in a while and when I did it was in Universe. So not only am I suffering a senior moment I'm dealing with a language barrier. Any help would be greatly appreciated. Thanks. Al DeWitt Stylmark, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to Default NO.RETURN.WARN in Universe
We use +$NO.RETURN.WARN (along with a bunch of other options) on the BASIC command line for ALL programs, subroutines and functions (we've actually wrapped BASIC - so no one actually types in the options). DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good Programming Practice Question.........
We also use xnn.meaningful.name type labels. One advantage is that our editor can recognise a label and putting the cursor on a line that includes a GOSUB and pressing one function key will move the cursor directly to the correct paragraph. One thing I've never agreed with (except in COBOL) is every internal subroutine should only have on exit point - why? What is wrong with... B00.PROCESS: READ REC1 FROM file1,id1 ELSE RETURN READ REC2 FROM file2,id2 ELSE RETURN IF some.condition THEN RETURN some more statements that actually do the work with REC1 REC2 RETURN The early RETURNs are just getting out of the routine on abnormal conditions, the alternative would be to nest the code - but code nested more than a couple of tabs deep is *much* harder to read. AdrianW DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good Programming Practice Question.........
I hope you're joking - talk about making code unreadable, comments that look like code are (IMO) a very BAD idea. The indentation level makes it perfectly clear what goes with what, and if it doesn't then change the structure of the code. IMO IF XOOS.ALL.COURSES='Y' THEN some lines of code END ELSE ;* IF XOOS.ALL.COURSES='Y' THEN some lines of code END ;* IF XOOS.ALL.COURSES='Y' THEN is much less clear than my preferred way of formatting the same structure: IF XOOS.ALL.COURSES = Y THEN some lines of code END ELSE some lines of code END I can easily see the start and end of both the THEN block and the ELSE block and also easily see to which condition they belong. The same structure can be used for ALL conditional statements and each block is always easy to find and associate with it's starting statement, eg: READU record FROM file,id ON ERROR statements END LOCKED statements END THEN statements END ELSE statements END -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 28 September 2005 7:11 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Good Programming Practice Question. RETURN with a comment..that is an excellent suggestion. I'd argue that any END statement that's more than a handful (8-10) lines from the opening IF (or whatever) statement should have a comment. Here's an example (that's not long enough to satisfy my 'handful' argument above): IF XOOS.ALL.COURSES='Y' THEN some lines of code END ELSE ;* IF XOOS.ALL.COURSES='Y' THEN some lines of code END ;* IF XOOS.ALL.COURSES='Y' THEN Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 ...our behavior matters more than the beliefs that we profess. Elizabeth Deutsch Earle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Formatting Help
Also consider using FMTS on the entire string, eg. STRING = FMTS(STRING,55T) This will perform the 55T formatting on each element of the string (in this case: each sub-value). DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] SELECT without n records selected...
How about using the COUNT.SUP keyword? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, 11 August 2005 7:11 AM To: U2-users (E-mail) Subject: [U2] [UV] SELECT without n records selected... When executing SELECT from a PA, is there some keyword that will suppress the message n records selected to select list 0. Because if there is, I can't find it. Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] SELECT without n records selected...
Very strange that it doesn't work... I wrote a quick paragraph... 1: PA 2: SELECT VOC SAMPLE 5 COUNT.SUP and I receive no message regarding number of records selected. Is it a GET.LIST rather than a SELECT that's producing the message? COUNT.SUP doesn't seem to work with GET.LIST. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol Sent: Thursday, 11 August 2005 9:49 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] SELECT without n records selected... Goo'day, At 08:49 11/08/05 +0800, you wrote: How about using the COUNT.SUP keyword? Try it. I did. Doesn't work Check HELP SELECT. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Barry Brevik Sent: Thursday, 11 August 2005 7:11 AM To: U2-users (E-mail) Subject: [U2] [UV] SELECT without n records selected... When executing SELECT from a PA, is there some keyword that will suppress the message n records selected to select list 0. Because if there is, I can't find it. Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/05 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.5/68 - Release Date: 10/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
