Re: [U2] Any code share for Levenshtein distance
How hard can porting 20 lines of code be ? ;-) http://en.wikipedia.org/wiki/Levenshtein_distance -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Wednesday, April 17, 2013 1:39 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Any code share for Levenshtein distance Hi, Does anyone have any Basic code that implements the algorithm, Levenshtein distance? We are playing with words for a fraud detection project, trying discover bad guys better. TIA, -Baker Thanks for all the good discussions - I'm lurking and reading now and then. Others usually provide splendid answers. This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
mv basic doesn't require an END to an IF either -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Louie Bergsagel Sent: Sunday, December 09, 2012 3:21 AM To: U2 Users List Subject: Re: [U2] Another job ad written by people who have no clue I'm in my current job because I was willing to learn Python at work and on my own dime. I took a beginner's course in Python at the University of Washington because I didn't know much besides Prime Information, Henco's Info, Structure/4, UniVerse, UniData and MITS. It was fun to learn Python as the syntax was so similar to Pick basic. Program controls is through indentation, which we usually use anyway. They even go Pick one better: an IF statement doesn't need an END. They all require one, right, so why not assume it? I love that thinking. Learn some Python. You'll be glad you did. ___ 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] [u2] Parallel processing in Universe
pipes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 01, 2012 4:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Parallel processing in Universe What's the largest dataset in the Universe user world? In terms of number of records. I'm wondering if we have any potential for utilities that map-reduce. I suppose you would spawn phantoms but how do they communicate back to the master node? ___ 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] [u2] Parallel processing in Universe
True - but why would you want it any other way ? Once one end closes it - process is complete -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe The only thing about a pipe is that once it's closed, I believe it has to be re-opened by both Ends again. So if point a opens one end, and point b opens the other end, once either end closes, It closes for both sides, and both sides would have to reopen again to use. To eliminate this, you could have one end open a file, and have the other sides do a append To that file - just make sure you include some kind of dataheader so the reading side knows which Process just wrote the data. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, October 01, 2012 4:11 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe pipes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 01, 2012 4:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Parallel processing in Universe What's the largest dataset in the Universe user world? In terms of number of records. I'm wondering if we have any potential for utilities that map-reduce. I suppose you would spawn phantoms but how do they communicate back to the master node? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Variable Interpolation
http://www.thefreedictionary.com/interpolation in·ter·po·late (n-tûrp-lt) v. in·ter·po·lat·ed, in·ter·po·lat·ing, in·ter·po·lates v.tr. 1. To insert or introduce between other elements or parts. 2. a. To insert (material) into a text. b. To insert into a conversation. See Synonyms at introduce. 3. To change or falsify (a text) by introducing new or incorrect material. 4. Mathematics To estimate a value of (a function or series) between two known values. v.intr. To make insertions or additions. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, August 24, 2012 12:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Variable Interpolation Sorry but I always thought iterpolation means describing a mathematical function like Y=2X for instance by producing a graph from it or describing key parameters in a system of coordinates (x,y) like where it crosses the y- or x-axis, if it rises or falls and in which degree etc. . On 24/08/2012 04:56, Tony Gravagno wrote: From: jjuser Does UniBasic have a way to do variable interpolation (without writing to a file, compiling it as a program, and calling it)? Do you mean something like this? VAL = 0 CALL @SUB FOO(X,Y);Y=X+1;RETURN( 3, VAL ) CRT VAL ; * 4 That would be Awesome! I don't believe any of the MV platforms do that because I've been looking for it for 15 years. It can be simulated in various ways, but you did limit the scope of the challenge. I think you're trying to avoid this?: CODE = \ CRT DATE()+20\ EXECUTE PGEN :CODE CAPTURING OUT * OUT is 16327 In this case the PGEN program reads from TCL, writes, compiles, runs, and that output gets captured. But at least the mechanism for performing that task is abstracted from this client/application code. Cache' allows you to enter code at TCL and then execute it without saving/compiling. That can also be simulated in U2. I don't think I've ever seen anyone else ask for it here - certainly no one willing to pay for it. ;) Out of curiosity, what's your application for this? And please correct the above if I've misunderstood the question. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] trimming a list (a test of your ability)
For universe, I believe that used to be true - I seem to recall running into this maybe 15+(?) years ago. I also seem to recall that the resolution to this issue was, as was mentioned, prepending all strings with a length. Try it: x=abc:char(255):xyz crt [:x:] crt len(x) crt index(x,x,1) end [abc xyz] 7 5 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, July 13, 2012 12:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] trimming a list (a test of your ability) Yes/No A string is stored in a fixed length *spot*, and is ended by an FF. This is *why* if you actually try to create a string in BASIC (or read one) with an embedded FF in it, the runtime will truncate the string It doesn' actually truncate the variable spot, what it does is fool the run-time into thinking you've hit the end of the string so it ignores anything else after it thinking it's leftover garbage from trimming or something. So initially let's say you get a spot of 8 bytes which is the default size of any variable, if you're string is only 8, it will then allocate you 50 bytes, and *move* the string into that new spot and the old spot will just be a direct pointer to the new spot. If you exceed 50 bytes, it then *allocates* you a new *spot* of 250 bytes elsewhere, and the original 8 byte spot now points at the new spot And so on. However, as it scans the string looking for the *end*, if it encounters an FF, that's the end. The run-time will also garbage-collect the old spots by the way, for use as other things. I'd be surprised if it actually wastes effort to store the length constantly at the fore, but I'm willing to be edumacated on that abstruse point. (Or pointer) Will -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Jul 13, 2012 3:53 am Subject: Re: [U2] trimming a list (a test of your ability) On 12/07/12 16:15, Dave Laansma wrote: I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares' about pointers, it still has to get to the end of the 'string' one way or another. Except that a string, as far as I am aware, uses the pascal method I hink it's called - namely a string is stored as its length followed by he string (or a Hollerith string as I used to do in FORTRAN). So, the question then is, does concatenation := establish and append to a 'string' faster than -1? Very much so And if so, why doesn't the database use the same logic for -1 as it does for := since technically they're accomplishing the same thing? ecause it's doing it in a completely different way. The -1 logic just happens to work whereas the append logic was designed to work hat way. If you use a field number, the code searches for that field - I think it akes the field as a counter, and searches the string decrementing the ounter every time it hits a field mark. When the counter hits zero it's ound what it's looking for. Of course, if you start at -1, it never hits zero and ends up at the end f the string. But this is by accident not design. To do what you uggest would require special case code which doesn't - logically - elong there. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions heers, ol __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] trimming a list (a test of your ability)
Just to be complete : for j=0 to 255 if char(j)='x' then continue x=abc:char(j):xyz l=len(x) p=index(x,x,1) if j=0 or l#7 or p#5 then crt j=:j crt x =[:x:] crt len=:l crt pos=:p end next end j=0 x =[abcxyz] len=7 pos=5 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Friday, July 13, 2012 1:10 PM To: U2 Users List Subject: Re: [U2] trimming a list (a test of your ability) For universe, I believe that used to be true - I seem to recall running into this maybe 15+(?) years ago. I also seem to recall that the resolution to this issue was, as was mentioned, prepending all strings with a length. Try it: x=abc:char(255):xyz crt [:x:] crt len(x) crt index(x,x,1) end [abc xyz] 7 5 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, July 13, 2012 12:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] trimming a list (a test of your ability) Yes/No A string is stored in a fixed length *spot*, and is ended by an FF. This is *why* if you actually try to create a string in BASIC (or read one) with an embedded FF in it, the runtime will truncate the string It doesn' actually truncate the variable spot, what it does is fool the run-time into thinking you've hit the end of the string so it ignores anything else after it thinking it's leftover garbage from trimming or something. So initially let's say you get a spot of 8 bytes which is the default size of any variable, if you're string is only 8, it will then allocate you 50 bytes, and *move* the string into that new spot and the old spot will just be a direct pointer to the new spot. If you exceed 50 bytes, it then *allocates* you a new *spot* of 250 bytes elsewhere, and the original 8 byte spot now points at the new spot And so on. However, as it scans the string looking for the *end*, if it encounters an FF, that's the end. The run-time will also garbage-collect the old spots by the way, for use as other things. I'd be surprised if it actually wastes effort to store the length constantly at the fore, but I'm willing to be edumacated on that abstruse point. (Or pointer) Will -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Jul 13, 2012 3:53 am Subject: Re: [U2] trimming a list (a test of your ability) On 12/07/12 16:15, Dave Laansma wrote: I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares' about pointers, it still has to get to the end of the 'string' one way or another. Except that a string, as far as I am aware, uses the pascal method I hink it's called - namely a string is stored as its length followed by he string (or a Hollerith string as I used to do in FORTRAN). So, the question then is, does concatenation := establish and append to a 'string' faster than -1? Very much so And if so, why doesn't the database use the same logic for -1 as it does for := since technically they're accomplishing the same thing? ecause it's doing it in a completely different way. The -1 logic just happens to work whereas the append logic was designed to work hat way. If you use a field number, the code searches for that field - I think it akes the field as a counter, and searches the string decrementing the ounter every time it hits a field mark. When the counter hits zero it's ound what it's looking for. Of course, if you start at -1, it never hits zero and ends up at the end f the string. But this is by accident not design. To do what you uggest would require special case code which doesn't - logically - elong there. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions heers, ol __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] trimming a list (a test of your ability)
Yep - I've run into that at some time as well. I seem to remember this being a problem with the editor or with reading/writing values to an mv file rather than internal string handling. If you re-edit the source, do you find that it has been split into : 001 PRINT DOG 002 :CHAR(255):CAT ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, July 13, 2012 1:49 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] trimming a list (a test of your ability) Well I'll be a horned toad. However try this ED BP TESTFF 001 PRINT DOG:CHAR(255):CAT .^ Up arrow mode .R/DOG/DOG^255 001 PRINT DOG :CHAR(255):CAT .FI BASIC BP TESTFF No closing quote The compiler doesn't see the FF as the same sort of thing as other characters even if the editor does -Original Message- From: u2ug simpson-u...@gerzio.ca To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jul 13, 2012 10:43 am Subject: Re: [U2] trimming a list (a test of your ability) Just to be complete : for j=0 to 255 if char(j)='x' then continue x=abc:char(j):xyz l=len(x) p=index(x,x,1) if j=0 or l#7 or p#5 then crt j=:j crt x =[:x:] crt len=:l crt pos=:p end ext nd =0 x =[abcxyz] len=7 pos=5 -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of u2ug ent: Friday, July 13, 2012 1:10 PM o: U2 Users List ubject: Re: [U2] trimming a list (a test of your ability) For universe, I believe that used to be true - I seem to recall running into his maybe 15+(?) years ago. also seem to recall that the resolution to this issue was, as was mentioned, repending all strings with a length. Try it: x=abc:char(255):xyz crt [:x:] crt len(x) crt index(x,x,1) nd [abc xyz] Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Friday, July 13, 2012 12:27 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] trimming a list (a test of your ability) es/No A string is stored in a fixed length *spot*, and is ended by an FF. his is *why* if you actually try to create a string in BASIC (or read one) with n embedded FF in it, the runtime will truncate the string It doesn' actually runcate the variable spot, what it does is fool the run-time into thinking ou've hit the end of the string so it ignores anything else after it thinking t's leftover garbage from trimming or something. So initially let's say you get a spot of 8 bytes which is the default size of ny variable, if you're string is only 8, it will then allocate you 50 bytes, nd *move* the string into that new spot and the old spot will just be a direct ointer to the new spot. If you exceed 50 bytes, it then *allocates* you a new *spot* of 250 bytes lsewhere, and the original 8 byte spot now points at the new spot And so on. However, as it scans the string looking for the *end*, if it encounters an FF, hat's the end. he run-time will also garbage-collect the old spots by the way, for use as ther things. I'd be surprised if it actually wastes effort to store the length constantly at he fore, but I'm willing to be edumacated on that abstruse point. (Or pointer) Will -Original Message- rom: Wols Lists antli...@youngman.org.uk o: u2-users u2-users@listserver.u2ug.org ent: Fri, Jul 13, 2012 3:53 am ubject: Re: [U2] trimming a list (a test of your ability) n 12/07/12 16:15, Dave Laansma wrote: I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares' about pointers, it still has to get to the end of the 'string' one way or nother. xcept that a string, as far as I am aware, uses the pascal method I hink it's alled - namely a string is stored as its length followed by he string (or a ollerith string as I used to do in FORTRAN). So, the question then is, does concatenation := establish and append to a string' faster than -1? ery much so And if so, why doesn't the database use the same logic for -1 as it does for = since technically they're accomplishing the same thing? cause it's doing it in a completely different way. The -1 logic just happens o work whereas the append logic was designed to work hat way. f you use a field number, the code searches for that field - I think it akes he field as a counter, and searches the string decrementing the ounter every ime it hits a field mark. When the counter hits zero it's ound what it's ooking for. f course, if you start at -1, it never hits zero and ends up at the end f the tring. But this is by accident not design. To do what you uggest would require pecial case code which doesn't - logically - elong there. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions eers, l
Re: [U2] trimming a list (a test of your ability)
Oops - meant to say : I seem to remember this being a problem writing values to an mv file rather than internal string handling. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Friday, July 13, 2012 2:54 PM To: U2 Users List Subject: Re: [U2] trimming a list (a test of your ability) Yep - I've run into that at some time as well. I seem to remember this being a problem with the editor or with reading/writing values to an mv file rather than internal string handling. If you re-edit the source, do you find that it has been split into : 001 PRINT DOG 002 :CHAR(255):CAT ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, July 13, 2012 1:49 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] trimming a list (a test of your ability) Well I'll be a horned toad. However try this ED BP TESTFF 001 PRINT DOG:CHAR(255):CAT .^ Up arrow mode .R/DOG/DOG^255 001 PRINT DOG :CHAR(255):CAT .FI BASIC BP TESTFF No closing quote The compiler doesn't see the FF as the same sort of thing as other characters even if the editor does -Original Message- From: u2ug simpson-u...@gerzio.ca To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jul 13, 2012 10:43 am Subject: Re: [U2] trimming a list (a test of your ability) Just to be complete : for j=0 to 255 if char(j)='x' then continue x=abc:char(j):xyz l=len(x) p=index(x,x,1) if j=0 or l#7 or p#5 then crt j=:j crt x =[:x:] crt len=:l crt pos=:p end ext nd =0 x =[abcxyz] len=7 pos=5 -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of u2ug ent: Friday, July 13, 2012 1:10 PM o: U2 Users List ubject: Re: [U2] trimming a list (a test of your ability) For universe, I believe that used to be true - I seem to recall running into his maybe 15+(?) years ago. also seem to recall that the resolution to this issue was, as was mentioned, repending all strings with a length. Try it: x=abc:char(255):xyz crt [:x:] crt len(x) crt index(x,x,1) nd [abc xyz] Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Friday, July 13, 2012 12:27 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] trimming a list (a test of your ability) es/No A string is stored in a fixed length *spot*, and is ended by an FF. his is *why* if you actually try to create a string in BASIC (or read one) with n embedded FF in it, the runtime will truncate the string It doesn' actually runcate the variable spot, what it does is fool the run-time into thinking ou've hit the end of the string so it ignores anything else after it thinking t's leftover garbage from trimming or something. So initially let's say you get a spot of 8 bytes which is the default size of ny variable, if you're string is only 8, it will then allocate you 50 bytes, nd *move* the string into that new spot and the old spot will just be a direct ointer to the new spot. If you exceed 50 bytes, it then *allocates* you a new *spot* of 250 bytes lsewhere, and the original 8 byte spot now points at the new spot And so on. However, as it scans the string looking for the *end*, if it encounters an FF, hat's the end. he run-time will also garbage-collect the old spots by the way, for use as ther things. I'd be surprised if it actually wastes effort to store the length constantly at he fore, but I'm willing to be edumacated on that abstruse point. (Or pointer) Will -Original Message- rom: Wols Lists antli...@youngman.org.uk o: u2-users u2-users@listserver.u2ug.org ent: Fri, Jul 13, 2012 3:53 am ubject: Re: [U2] trimming a list (a test of your ability) n 12/07/12 16:15, Dave Laansma wrote: I'm puzzled by '... doesn't care ...' terminology. Of course it 'cares' about pointers, it still has to get to the end of the 'string' one way or nother. xcept that a string, as far as I am aware, uses the pascal method I hink it's alled - namely a string is stored as its length followed by he string (or a ollerith string as I used to do in FORTRAN). So, the question then is, does concatenation := establish and append to a string' faster than -1? ery much so And if so, why doesn't the database use the same logic for -1 as it does for = since technically they're accomplishing the same thing? cause it's doing it in a completely different way. The -1 logic just happens o work whereas the append logic was designed to work hat way. f you use a field number, the code searches for that field - I think it akes he field as a counter, and searches the string decrementing the ounter every ime it hits a field mark. When the counter hits zero it's ound what it's ooking for. f course, if you start at -1, it never hits zero and ends up
Re: [U2] U2, satya satya has invited you to open a Gmail account
This user is very suspicious - email harvesting maybe ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: Monday, May 07, 2012 1:23 PM To: U2 Users List Subject: [U2] U2, satya satya has invited you to open a Gmail account I've been using Gmail and thought you might like to try it out. Here's an invitation to create an account. You're Invited to Gmail! satya satya has invited you to open a Gmail account. Gmail is Google's free email service, built on the idea that email can be intuitive, efficient, and fun. Gmail has: *Less spam* Keep unwanted messages out of your inbox with Google's innovative technology. *Lots of space* Enough storage so that you'll never have to delete another message. *Built-in chat* Text or video chat with satya satya and other friends in real time. *Mobile access* Get your email anywhere with Gmail on your mobile phone. You can even import your contacts and email from Yahoo!, Hotmail, AOL, or any other web mail or POP accounts. Once you create your account, satya satya will be notified of your new Gmail address so you can stay in touch. Learn morehttp://mail.google.com/mail/help/intl/en/about.htmlor get startedhttp://mail.google.com/mail/a-adc6c0ff73-a5ce85720e-fzY4YzufE9cf iSCZYeifL-PBXKY ! Sign uphttp://mail.google.com/mail/a-adc6c0ff73-a5ce85720e-fzY4YzufE9cfiSCZY eifL-PBXKY Google Inc. | 1600 Ampitheatre Parkway | Mountain View, California 94043 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Hello
Is the list alive ? Haven't seen anything for a week. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Passing by Value 101 ?
It gives the calling routine a way to ensure that a called routine can't modify the variables value ( intentionally or inadvertently ). FOR COUNTER=1 TO 10 IF IWANTTOCAUSEPROBLEMS THEN CALL *BADSUB( @LOGNAME , COUNTER ) ;* go boom ! ELSE CALL *BADSUB( (@LOGNAME) , (COUNTER) ) ;* everything ok NEXT SUBROUTINE BADSUB (ARG1,ARG2) ARG1=XXX ;* this will globally change the value of @LOGNAME believe it or not ARG2=XXX ;* this will mess up the FOR NEXT END -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, January 27, 2012 7:52 PM To: U2 Users List Subject: Re: [U2] Passing by Value 101 ? It is not clear to me why Passing By Value is worth anything. I am surprised that this thread has led to so many responses... most... I did not read. From here... having a variable with a name... and calling an external subroutine... is all the bread and butter that I would ever need. myGuzInTa = '' myGuzOutA = '' errorFlag = '' Call *SUB.MY.THING.R1(myGuzInTa, myGuzOutA, errorFlag) Begin case Case myGuzOutA = '' ; gosub xx Case 1 ; gosub yy Endcase Putting a thingy-poo in double parens seems to be at odds with good programming practice. Perhaps I am missing something... I promise to try to read clarifying responses... --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] Passing by Value
BASIC -X !!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Thursday, January 26, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Passing by Value One of these searches should eventually work: L A= L A = L A= L A = Unless the original author used some kind of ridiculous syntaxt like: A = 500 Granted, you're also going to get results for any IF/THEN equality tests in the mix, but you'd have the exact same issue if the variable were named I.LIKE.TO.USE.VERY.LOOONG.VARIABLE.NAMES. You might get more false positives with A if you also have variables like AA, AAA, BA, etc., but one can only hope any programmer that incompetent would get fired before they could leave behind too much code like that. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, January 26, 2012 12:59 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Passing by Value Mecki you're not paying attention. You have an 8000 line program that uses a variable A You didn't write it. You need to find where that variable is assigned. You search for A ? That's not going to work. ___ 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] Passing by Value
It generates a variable cross reference listing which gives you a list of all variables and labels in your program along with and the lines on which they are referenced in your program, I believe it even identifies lines where the variables are assigned to ( as opposed to just being referenced ) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, January 26, 2012 4:27 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Passing by Value What does -X do? I'd probably compile it with -Z2, run the program in debug and put a trace on A. On 26/01/2012 21:22, u2ug wrote: BASIC -X !!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Thursday, January 26, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Passing by Value One of these searches should eventually work: L A= L A = L A= L A = Unless the original author used some kind of ridiculous syntaxt like: A = 500 Granted, you're also going to get results for any IF/THEN equality tests in the mix, but you'd have the exact same issue if the variable were named I.LIKE.TO.USE.VERY.LOOONG.VARIABLE.NAMES. You might get more false positives with A if you also have variables like AA, AAA, BA, etc., but one can only hope any programmer that incompetent would get fired before they could leave behind too much code like that. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, January 26, 2012 12:59 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Passing by Value Mecki you're not paying attention. You have an 8000 line program that uses a variable A You didn't write it. You need to find where that variable is assigned. You search for A ? That's not going to work. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Brilliant? or not?
You can get pretty close : SMAX = IF S1 S2 THEN S1 ELSE S2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Friday, January 13, 2012 3:32 PM To: 'U2 Users List' Subject: Re: [U2] Brilliant? or not? Are you trying to emulate C? SMAX = (S1 S2) ? S1 : S2; David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, January 13, 2012 10:42 AM To: u2-users@listserver.u2ug.org Subject: [U2] Brilliant? or not? SMAX = (S1 S2) * S1 + (S2 = S1) * S2 ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Testing . . .
1 ... 2 ... 3 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Testing . . .
Well that's 1 After the posting overload last week this week has been zero. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Verhagen Sent: Thursday, November 24, 2011 11:40 AM To: 'U2 Users List' Subject: Re: [U2] Testing . . . 4 ... 5 ... 6 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Thursday, November 24, 2011 8:34 AM To: U2 Users List Subject: [U2] Testing . . . 1 ... 2 ... 3 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Changing TCL prompt?
There is - PROMPT 'x' - but it only allows 1 character -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of gcan...@coverys.com Sent: Wednesday, October 05, 2011 2:06 PM To: u2-users@listserver.u2ug.org Subject: [U2] Changing TCL prompt? Hi everyone, Maybe I am going back to my Prime INFORMATION days, but I thought there was a way to set the '' prompt to a free form prompt, or to display the account name you were in as the TCL prompt. I know that can be done at the OS level. Am I dreaming, or is there a (fairly easy) way without having to write code to do it? Thanks Gary P. Canedy Senior Database Analyst P: 617.757.6775 F: 617.428.9803 gcan...@coverys.com (Embedded image moved to file: pic24821.jpg) 101 Arch Street, 4th Floor Boston, MA 02110 www.coverys.com Toll Free: 800.225.6168 -- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reading Dictionary Items
The same as you would with any other file - off the top : open 'DICT','filename' to dfp else abortm 'Cant open dict filename' execute 'SELECT DICT filename WITH TYPE=D' loop while readnext id writev id on dfp,id,4 repeat Gerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, September 29, 2011 2:44 PM 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] Comparing numeric strings
Have you looked at the COMPARE() function ? Does the trick under universe. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers Sent: Friday, August 12, 2011 1:11 PM To: U2 Users List Subject: Re: [U2] Comparing numeric strings Thanks all. I should have mentioned that I already knew about the alpha-concatenation hack. I was sort of looking for a cleaner approach. It looks like SCMP falls down on floating point numbers. That should probably be mentioned in the docs, but instead it just fails silently. ;-( -Rob On Fri, Aug 12, 2011 at 9:51 AM, Rex Gozar rgo...@gmail.com wrote: In July I added to PickWiki: http://www.pickwiki.com/cgi-bin/wiki.pl?UniVerse_Tips_And_Tricks#Forci ng_string_comparison_on_numbers rex On Fri, Aug 12, 2011 at 8:15 AM, Rob Sobers rsob...@gmail.com wrote: Say you have two strings that happen to be numeric: FOO = 401.0101 BAR = 401.0101000 Since UniBasic is untyped, even though I've wrapped each value in quotes , they are treated as numbers. As a result, FOO EQ BAR evaluates to @TRUE. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selecting a List
What system ? this works fine in UV. 001 x=@VM:@VM:@VM 002 crt x 003 crt convert(@VM,x,x) 004 end RUN DEV.BP X ²²² xxx -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, June 08, 2011 11:47 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selecting a List Hi All, Again, I need a little help. The following PROCEDURE LINE works just fine. In this case I'm just inserting the variable V.CALENDAR.YEAR to complete my file suite and I am going after 2 alphanumeric records ('P2021422' 'P2083158'). PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = 'P2021422' 'P2083158' The problem arises when I attempt to select from a LIST (below) PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = : VL.JS.LIST.VAR1 Of course the system does not like the Value Marker so I need to get rid of it... VL.JS.LIST.VAR1 = ':CONVERT (@VM,' ',VL.JS.LIST.VAR1):' The hope here is to replace @VM with ' ' and then place the ' at each end... but CONVERT will only switch one for one - one @VM for a single single quote (') which results in a quote mismatch. Any suggestions? Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe PE
This link was posted to the list a while back : http://www.rocketsoftware.com/u2/resources/premium/downloads/universe-li nux?searchterm=universe+personal+edition+linux I just recently downloaded and installed from here. I am thinking that the rocket fish site download setup hasn't really been thought out very well :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Wednesday, May 25, 2011 2:15 PM To: U2 Users List Subject: Re: [U2] Universe PE Thats pretty much standard behavior nowadays. At least every time I've tried it... You really do have to wait for someone to contact you and give you a free license for it. Please someone enlighten us if I'm wrong... On Wed, May 25, 2011 at 1:57 PM, Dan Fitzgerald dangf...@hotmail.comwrote: To clarify, it appears that this happens for the Linux PE. The Windoze PE downloads. From: fft2...@aol.com Date: Wed, 25 May 2011 13:56:34 -0400 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe PE I tried to again go to the download link for the Universe PE. It lets me fill out the registration form, but then nothing downloads, I just get an email saying someone will contact me What's up? Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Hello ?
Well - it looks like I can talk to myself - lots or practice there. Actually what is this u2-users-boun...@listserver.u2ug.org : bounces ??? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, May 02, 2011 9:39 PM To: U2 Users List Subject: [U2] Hello ? The list has gone silent for me for the past week - is there anybody out there ? Just yell if you can hear me ... ___ 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] Hello ?
Thanks Dan - so I guess the list has just gone on hiatus ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Monday, May 02, 2011 9:48 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Hello ? I hear you. Date: Mon, 2 May 2011 21:43:08 -0400 From: simpson-u...@gerzio.ca To: u2-users@listserver.u2ug.org Subject: Re: [U2] Hello ? Well - it looks like I can talk to myself - lots or practice there. Actually what is this u2-users-boun...@listserver.u2ug.org : bounces ??? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, May 02, 2011 9:39 PM To: U2 Users List Subject: [U2] Hello ? The list has gone silent for me for the past week - is there anybody out there ? Just yell if you can hear me ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Hello ?
Aaaah , Bach. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Barouch Sent: Monday, May 02, 2011 9:48 PM To: U2 Users List Subject: Re: [U2] Hello ? I can see you. This may just be that post Spectrum triptophan nap. Charles Barouch u2ug simpson-u...@gerzio.ca wrote: Well - it looks like I can talk to myself - lots or practice there. Actually what is this u2-users-boun...@listserver.u2ug.org : bounces ??? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, May 02, 2011 9:39 PM To: U2 Users List Subject: [U2] Hello ? The list has gone silent for me for the past week - is there anybody out there ? Just yell if you can hear me ... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
agreed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: March 4, 2011 11:05 AM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? I still think all of these constructs as just sooo basic that if you can't just read them either which way, then you had better think about another career. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rex Gozar Sent: 04 March 2011 14:09 To: U2 Users List Subject: Re: [U2] Is this worth rewriting? good comprehension = faster, accurate programming (that's programming, not code execution) We all want fast and accurate programming. To improve comprehension, you have to write code to (a) reveal its logical structure, and (b) reveal the business rules implemented in the code. Sorry, but structures like: IF A:B:C NE '' THEN CUM(M) = A+B+C (concatenating variables as a string, then performing numeric operations on them) slows down the comprehension process. And for what benefit? To me, that's just a lazy programmer that doesn't want to type a few extra keystrokes. Another structure caused a number of comments: IF condition THEN statement ELSE other-statement END (inline THEN followed by block ELSE). It appears that some readers saw the # in the condition and assumed an If Not Not structure at first, missing the THEN. I find it interesting that no one has commented on the fact that CUM(M) gets conditionally reinitialized, and whether or not that is important. But it proves my points that neither the structure nor business rules are clear within the OP's code. You can have 2 years programming experience, or 20, it does not matter. Better structure and variable naming will vastly improve program accuracy. (On the other hand, I could make this code really, really fast if it didn't have to be accurate!) rex ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1204 / Virus Database: 1435/3480 - Release Date: 03/03/11 ___ 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] Clear Messages
I believe those are the program counters -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: February 10, 2011 06:29 PM To: U2 Users List Subject: [U2] Clear Messages The following program (and sub) returns the following string. What is nice about it is that if running SYSTEM(9001) from a sub, it comes back with the grand path. 2ý/usr/ibm/uv/catdir/*SUB.GET.PROGR/AM.NAME.R0ý0x0þ1ý/u2/CODE/B.BP.O/GET.CODE.DATA.R0ý0x16aþ What is the significance of the data at the end of the sub-strings... that is... 0x0 and x16a ? --Bill * call *SUB.GET.PROGRAM.NAME.R0(Who.Am.I) crt Who.Am.I * SUBROUTINE SUB.GET.PROGRAM.NAME.Rx(This.Program.Name) This.Program.Name = SYSTEM(9001) RETURN END Thanks to those who responded earlier especially Steve and Will. ___ 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] How to Clear Empty VM marks in Field
That gets rid of all @VMs not just the empty trailing ones. I realize it answers the very specific example posted , but if that example was really the case being questioned I would say just use FXI=FXI1,1,1 or count=1 I would assume that this question is really being asked about a more general situation such as FXI = 1ý2ýý In which case FXI=trim(FXI,@VM,'T') To remove all empty @VM delimited fields FXI=trim(FXI,@VM,'R') -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: January 31, 2011 09:13 AM To: U2 Users List Subject: Re: [U2] How to Clear Empty VM marks in Field Am I missing something, or would CONVERT CHAR(253) TO IN FXI not do the job? or FXI=CHANGE(FXI,CHAR(253),) Maybe: EQU CLEARVM TO CONVERT CHAR(253) TO IN ... ... ... CLEARVM FXI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, January 28, 2011 8:26 PM To: U2 Users List Subject: Re: [U2] How to Clear Empty VM marks in Field I suspect that there is no canned function. I little homemade sub could look like SUBROUTINE SUB.XM.Counter(FXI, XM.Count) XM.Count = 0 Total.String.Length = len(FXI) For Posn = 1 to Total.String.Length Next = Posn + 1 This.Char = FXI[Posn, 1] Next.Char = FXI[Next, 1] Begin case Case This.Char = VM ; begin case Case This.Char = Next.Char ; null Case 1 ; XM.Count += 1 Endcase End case Next Posn return END I hope that I made no speling mistakes this time... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Garry Smith Sent: Friday, January 28, 2011 7:30 PM To: U2 Users List Subject: [U2] How to Clear Empty VM marks in Field FXI = 1ýý DCount(FXI,VM) returns 3 Is there function to clear the blank value marks so that FXI = 1 and then DCOUNT would return 1 TIA Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: Garry Smith Sent: Friday, January 28, 2011 2:04 PM To: 'U2 Users List' Subject: RE: [U2] What do you do with CallHTTP? I tried to but we are still using AIX 4.3.3 and UV 9.6 Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Friday, January 28, 2011 1:29 PM To: U2 Users List Subject: Re: [U2] What do you do with CallHTTP? On 1/28/2011 1:50 PM, David Wolverton wrote: What uses have you found for CallHTTP for in your applications? None whatsoever. Are you 'eating' someone else's data with it - like doing lookups against a web service call? Or are you using it to 'serve' data to others? Rocket says you can do this, but I can't see how it would work offhand and would like to know the scenario. How complex have you found it and how stable? Too complex, not sure about stability. I am following someone on c.d.p's lead from 2006 and using curl. I have also used wget in the past for a dictionary items to do a filecheck on web images. You can use wget in --spider mode and it will just give you back an http 200 if the file resolves, but will not actually download it. Thanks for your thoughts! ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UUID [was Data in Dict]
This is only guaranteed to be unique per process due to the usage of named common. Different processes running on the same system could generate duplicate values. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: January 26, 2011 07:35 PM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] Interesting trade-off between the overhead of calculating a unique-yet compact sequential number and calculating a consistently long UUID. We use the last-number-stored-in-a-file method. We recently had need for a UUID as part of an XML exchange with a third party. I looked at the various options available, and eventually ended up writing a UV subroutine to create a UUID in v4 format. It is not overly complex - the hardest part was working out the bit manipulations needed. The result is unique across UV systems due to the use of the UV system id. - subroutine MAKE.UUID( UUID ) * * This subroutine generates a version 4 UUID, following the * rules outlined in the RFC found here: * http://tools.ietf.org/html/rfc4122.html * common /UUID$GEN/ UUID$lastgen if unassigned(UUID$lastgen) then UUID$lastgen = '' DECLARE GCI getpid time.NOW = system(12) date.NOW = date() date.BASE = iconv( 15 Oct 1582, D) * We need to determine the accuracy of the time value * From this we derive the appropriate factor to apply to * convert our time from seconds/milliseconds to nanoseconds if index( time.NOW, ., 1) then * The TIME.MILLISECOND compiler option is NOT active time.NOW = time.NOW * 1 nano.FACTOR = 10 time.PERDAY = 86400 * 1 end else * The TIME.MILLISECOND compiler option IS active nano.FACTOR = 100 time.PERDAY = 86400 * 1000 end * We need to ensure we can cope if we create more than 1 UUID * in the same millisecond. this.STAMP = date.NOW:-:time.NOW * Need to use 'compare' on large 'numbers'. * A result of 0 means they are equal if compare( this.STAMP, field( UUID$lastgen, ., 1)) = 0 then * We have already created one this (milli)second. TAIL = oconv( field( UUID$lastgen, ., 2), MCN) + 0 if TAIL then TAIL += 1 this.STAMP = fieldstore( UUID$lastgen, ., 2, 1, TAIL) end else TAIL = 1 this.STAMP := .1 end time.NOW += (TAIL / 10) end * Track our latest generation UUID$lastgen = this.STAMP * Now we can build our UUID time.UUID = ((date.NOW - date.BASE) * time.PERDAY) + time.NOW nano.UUID = time.UUID * nano.FACTOR port.NOW = abs(@USERNO) port.HEX = oconv( port.NOW, MCDX)R%4 ver.VAL = rnd(65535) ver.VAL = bitreset( ver.VAL, 12) ver.VAL = bitset( ver.VAL, 13) ver.VAL = bitreset( ver.VAL, 14) ver.VAL = bitreset( ver.VAL, 15) ver.HEX = oconv( ver.VAL, MCDX) rnd.VAL = rnd(255) rsvd.VAL = bitset( rnd.VAL, 6) rsvd.VAL = bitreset( rsvd.VAL, 7) rsvd.HEX = oconv( rsvd.VAL, MCDX) sysid.HEX = oconv( system(31), MCDX)R%6 pid.NOW = getpid() pid.HEX = oconv( pid.NOW, MCDX)R%6 * UUID Structure * 1 = time-low : 8 char hex value for time * 2 = time-mid : 4 char hex value * 3 = time-hi-and_version : 4 char hex value * 4 = clock-seq-and-reserved : 2 char hex value : clock-seq-low : 2 char hex value * 5 = node : 12 char hex value UUID = '' UUID1 = oconv(nano.UUID, MCDX)R%8 UUID2 = port.HEX UUID3 = ver.HEX UUID4 = rsvd.HEX:oconv(rnd(255), MCDX)R%2 UUID5 = sysid.HEX:pid.HEX convert @AM to - in UUID return - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, 27 January 2011 10:46 AM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] We also are using a form of UUID instead of sequential numbering on most of our new files. A lot easier to handle and makes maintenance easier. Thanks for the Stuart, I wasn't aware of that. For those using UniData, you can use the VOC as follows instead: UUID 0001 S 0002 !/etc/ncs/uuid_gen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Thursday, 27 January 2011 10:07 AM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] Most OSs have a call available for generating a UUID (Universally Unique ID) or GUID (Microsoft's acronym for Globally Unique ID). By definition and accepted generation standards these are almost guaranteed (!) to be unique (the probability of a clash is extremely small) across all computers. In UV you could use GCI to create a UV verb to invoke the OS call. Or just create a VOC item which you can execute and capture. There are usually options which affect the format of the output. For AIX the VOC item might look like this: UUID 0001 V 0002 /etc/ncs/uuid_gen 0003 U 0004 CGHIM For Linux use: /usr/bin/uuidgen For Windows (not installed by default): guidgen HTH
Re: [U2] UUID [was Data in Dict]
Sorry - I missed the second page. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: January 27, 2011 05:25 PM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] The use of both the @USER.NO and the current PID ensure the UUID is unique across the installation, and the presence of the UV system id makes the UUID unique between systems. The named common ensures the current port does not generate the same UUID within the same second/millisecond. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Thursday, 27 January 2011 11:19 PM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] This is only guaranteed to be unique per process due to the usage of named common. Different processes running on the same system could generate duplicate values. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: January 26, 2011 07:35 PM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] Interesting trade-off between the overhead of calculating a unique-yet compact sequential number and calculating a consistently long UUID. We use the last-number-stored-in-a-file method. We recently had need for a UUID as part of an XML exchange with a third party. I looked at the various options available, and eventually ended up writing a UV subroutine to create a UUID in v4 format. It is not overly complex - the hardest part was working out the bit manipulations needed. The result is unique across UV systems due to the use of the UV system id. - subroutine MAKE.UUID( UUID ) * * This subroutine generates a version 4 UUID, following the * rules outlined in the RFC found here: * http://tools.ietf.org/html/rfc4122.html * common /UUID$GEN/ UUID$lastgen if unassigned(UUID$lastgen) then UUID$lastgen = '' DECLARE GCI getpid time.NOW = system(12) date.NOW = date() date.BASE = iconv( 15 Oct 1582, D) * We need to determine the accuracy of the time value * From this we derive the appropriate factor to apply to * convert our time from seconds/milliseconds to nanoseconds if index( time.NOW, ., 1) then * The TIME.MILLISECOND compiler option is NOT active time.NOW = time.NOW * 1 nano.FACTOR = 10 time.PERDAY = 86400 * 1 end else * The TIME.MILLISECOND compiler option IS active nano.FACTOR = 100 time.PERDAY = 86400 * 1000 end * We need to ensure we can cope if we create more than 1 UUID * in the same millisecond. this.STAMP = date.NOW:-:time.NOW * Need to use 'compare' on large 'numbers'. * A result of 0 means they are equal if compare( this.STAMP, field( UUID$lastgen, ., 1)) = 0 then * We have already created one this (milli)second. TAIL = oconv( field( UUID$lastgen, ., 2), MCN) + 0 if TAIL then TAIL += 1 this.STAMP = fieldstore( UUID$lastgen, ., 2, 1, TAIL) end else TAIL = 1 this.STAMP := .1 end time.NOW += (TAIL / 10) end * Track our latest generation UUID$lastgen = this.STAMP * Now we can build our UUID time.UUID = ((date.NOW - date.BASE) * time.PERDAY) + time.NOW nano.UUID = time.UUID * nano.FACTOR port.NOW = abs(@USERNO) port.HEX = oconv( port.NOW, MCDX)R%4 ver.VAL = rnd(65535) ver.VAL = bitreset( ver.VAL, 12) ver.VAL = bitset( ver.VAL, 13) ver.VAL = bitreset( ver.VAL, 14) ver.VAL = bitreset( ver.VAL, 15) ver.HEX = oconv( ver.VAL, MCDX) rnd.VAL = rnd(255) rsvd.VAL = bitset( rnd.VAL, 6) rsvd.VAL = bitreset( rsvd.VAL, 7) rsvd.HEX = oconv( rsvd.VAL, MCDX) sysid.HEX = oconv( system(31), MCDX)R%6 pid.NOW = getpid() pid.HEX = oconv( pid.NOW, MCDX)R%6 * UUID Structure * 1 = time-low : 8 char hex value for time * 2 = time-mid : 4 char hex value * 3 = time-hi-and_version : 4 char hex value * 4 = clock-seq-and-reserved : 2 char hex value : clock-seq-low : 2 char hex value * 5 = node : 12 char hex value UUID = '' UUID1 = oconv(nano.UUID, MCDX)R%8 UUID2 = port.HEX UUID3 = ver.HEX UUID4 = rsvd.HEX:oconv(rnd(255), MCDX)R%2 UUID5 = sysid.HEX:pid.HEX convert @AM to - in UUID return - -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, 27 January 2011 10:46 AM To: U2 Users List Subject: Re: [U2] UUID [was Data in Dict] We also are using a form of UUID instead of sequential numbering on most of our new files. A lot easier to handle and makes maintenance easier. Thanks for the Stuart, I wasn't aware of that. For those using UniData, you can use the VOC as follows instead: UUID 0001 S 0002 !/etc/ncs/uuid_gen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell
Re: [U2] data in dict
Hi Jay, What is the 'multiple data levels' you are referring to here - distributed files ? Gerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jay rappaport Sent: January 26, 2011 12:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] data in dict Once upon a time, it might have made perfect sense to store in the dict of a file other bits of information to be used by programs. However, since the indroduction of multiple data levels within a file, this would seem to be a non-issue if you just created a fields data portion for a file, and then loaded it up with anything you wanted. This would leave the dictionary clear of anything that might conflict with the OS you are using. Jay ___ 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] Migration
Agreed, that this is how it is often done. But there is nothing that says that this is how it has to be done OR even how it should be done. These 2 files could be setup such that : The CUSTOMER file contains no such embedded 'cross reference' field for appointments The APPOINTMENTS file could be keyed as : @ID = CUSTOMERNO*APPTDATE*APPTTIME*APPTTYPE With ITYPE entries setup for CUSTOMERNO = @ID['*',1,1] APPTDATE = @ID['*',2,1] APPTTIME = @ID['*',3,1] APPTYPE = @ID['*',4,1] -- OR -- @ID = sequentially generated With data fields defined for CUSTOMERNO, APPTDATE, APPTTIME APPTYPE In both cases, indexed on CUSTOMERNO. I believe you will find the following 2 snippets pretty comparable performance wise : * I know there are other better (?) ways to do this * insert your own list traversal code appcnt=dcount(custrecappxref,@VM ) for appidx = 1 to appcnt appid = custrecappxref,appidx next execute 'SELECT APPOINTMENTS WITH CUSTOMERNO = ':squote(custno) loop while readnext appid repeat Dropping the xref field in the parent table would help immensely with file sizing as records would tend to be a lot closer in size to the average instead of having CUSTOMER records that have accumulate massive xref fields over time - this is a problem I see in systems all the time. This also gets around your problem of knowing what is related to what - you know that all keys are automatic indexes in sql server and anything that could be used for lookup/joining purposes should also have an explicit index in sql server else it would be a bottleneck in sql server as well. There is also nothing that says that a file's key value has to be based on anything related to the data in the record - some would argue that key values should NEVER be related to the data. The only reason to prefer the 1st method over the 2nd is for human readability which imo shouldn't be a concern anyway. The 2nd scheme also gets around the sql-mv field mapping, no defined relation, no key, non-unique key and key length max exceeded problems, and would definitely produce a much more even hash distribution. Just some thoughts, Gerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: December 24, 2010 01:41 AM To: U2 Users List Subject: Re: [U2] Migration Oh, one more point. What if your SQL environment had NOT defined a primary key for APPOINTMENTS, but had multiple indexes, one of which happened to have CUSTOMERNO, APPTDATE, APPTTIME and APPTTYPE. How would you figure out what to use as the item-id of the PICK file? What if you had a SQL table that actually did not have a set of fields that guaranteed a unique value? Then you have NOTHING to create an item-id from! I have to stop this, it will consume me! :o But the list goes on. Oh the humanity! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Thursday, December 23, 2010 10:36 PM To: U2 Users List Subject: Re: [U2] Migration I may have been unclear in my earlier post, so I'll clarify. Consider a CUSTOMER file and an APPOINTMENTS file. The item-id of the CUSTOMER file is the customer number. The item-id of the APPOINTMENTS file is CUSTOMERNO*APPTDATE*APPTTIME*APPTTYPE. When you have a parent/child relationship in multiple files in MV, except in those cases where the key to a child file is the item-id of the parent file with a sequential ordinal, the common way to indicate a parent-child relationship involving more than one file in MV is to embed, in the parent item a multivalued set of either all the entire item-ids of the child table, or the portion that needs to be concatenated to the parent's item-id. That is what I call a cross reference field. If you don't have this, you are faced with trying to scan the whole APPOINTMENTS file to find all item-ids that start with your CUSTOMERNO value. What you might actually have in the CUSTOMER file is a set of 3 correlated multivalued attributes that have APPTDATE, APPTTIME, and APPTTYPE values for all the APPOINTMENTS items that pertain to the CUSTOMER item. In a SQL environment, the primary key to the child table would consist of at least two fields, one or more of which would be the full primary key of the parent table. In SQL Server a true primary key forces the file to actually be sorted by those key fields (it forces a clustered index). You can also have secondary indexes that are also pre-sorted by their indexed columns. They are effectively complete copies of the indexed fields and a copy of the primary key so it can directly read the data once you've found the index entries that match your query. In our example above, you'd have CUSTOMERNO as a primary key to the CUSTOMER
Re: [U2] Why don't calendars show the pick date?
Simple if you have a calendar that shows the Julian date. Find out what the internal date for December 31st of the previous year is and write it somewhere on the calendar. Then all you have to do is add the Julian date to it. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, November 11, 2010 8:01 AM To: U2 Users List Subject: [U2] Why don't calendars show the pick date? Wouldn't it be so much easier if those desk calendars and wall calendars had the pick date on them, as well as the julian date.that would make them so much more useful! George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse On RedHat?
I've never moved UV from HP-Ux to Red Hat but I have worked on both. We went from a Sun Risc system to Red Hat on Intel and, like Drew said, you would have to do recompiling of programs and I-descriptors, and either uvbackup/uvrestore or fnuxi the files. If you use any operating system scripts or programs those will have to be checked for differences. The spooler should work pretty much the same. I did our conversion on a Saturday morning. Moving from a 'nix system to Windows was not as easy. Jerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, November 05, 2010 4:59 PM To: U2 Users List Subject: [U2] UniVerse On RedHat? 0. We are considering migrating from HP-Ux to RedHat. 1. How is RedHat? 2. Will I have to re-compile and re-catalog everything? 3. Did anyone migrate from HP-Ux to RedHat and then back to HP-Ux? 4. Is the RedHat Standard Edition Suitable? 5. Did anyone try running UV on RedHat on an HP Integritity (Itanium) server? 6. Are there any gotchas? 7. Insights and hind-sights 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] I'm baaaack
There are discussion email groups like this one as well as forums. Go to the www.u2ug.org web site and sign up for all of that you want to belong to. Welcome home. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon Sent: Thursday, October 28, 2010 8:49 AM To: U2 Users Subject: [U2] I'm bck Greetings Group, I just started a new position with a company running a Unidata / SB+ shop after my hiatus from the multivalue market. It seems some things have changed since I left (Rocket instead of IBM) but many things seem the same. I look forward to the discussions on this group which I've missed. Gordon Gordon J Glorfield | Software Application Engineer | Vertis Communications 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664 | M 443-280-7093 gglorfi...@vertisinc.com | http://www.vertisinc.com Vertis Communications is a results-driven marketing communications company that delivers inventive advertising, direct marketing and interactive solutions to prominent brands across North America. Our deep industry knowledge and extensive range of offerings-including integrated data solutions, digital program management systems, creative services, world-class print and mail production, logistics, out-of-home and business process outsourcing-are used to deliver superior program performance that drives bottom line results for our clients. With 100 strategically positioned locations and more than 5,000 dedicated professionals, we deliver impeccable quality and fast turn-around to any market. ___ 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] Building XML using the UV XDOM API functions
I'll have to disagree with you on this one Tony. As a vendor yourself you would of course think this way. As an end user of the product we would like it all to come from one source. This is the reason that Microsoft has got such a jump on everyone else, they will provide you with all of the tools as well as the database. I'm talking about the harsh reality of things, at one time if you went IBM you went all the way, now it's Microsoft. Companies don't want to deal with several vendors they want one. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, October 25, 2010 11:35 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Building XML using the UV XDOM API functions Gregor, your comments serve as a testimonial to support my position against using many of these vendor-supplied toolkits. Some of them are OK, but many not. People insist on the DBMS vendors building stuff for them, but then we get the mess that you've described. For this reason I continue to recommend at least consideration for integration with tools that are outside of the DBMS. DBMS vendors should be focusing on making superior databases, not XML, web services, or a lot of this other fluff. People in the open source and commercial markets spend a great deal of time focused on these things, and because of this, their offerings are often much better. So take a look around and weigh other offerings against the built-in functionality. It would be nice to see people here comparing more toolkits - it might save others from feeling like they're stuck with whatever is provided by the DBMS vendors. T ___ 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] too many values in sort
I don't think UniVerse has the same limits (SELBUF controls in memory size) but then UniVerse doesn't use the same structure as Unidata in their selects. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 25, 2010 11:52 AM To: U2 Users List Subject: Re: [U2] too many values in sort Of course, why would anyone need a BASIC program larger than 32K? I believe it's called progress. Non-configurable size limits are just __NOT__ acceptable in today's computing environment. The attendant work-arounds are just plain ugly, and inexcusable. The greatest aspect of PICK is the narrow gulf between the logical and the physical; database structure is logical, query syntax is logical, in fact, the entire machine is a logical machine. Twenty year old physical limitation should have been resolved at least ten years ago. :-( Bill Kevin King said the following on 10/25/2010 8:27 AM: Agreed on all points. Will check this on my customer's system. On Mon, Oct 25, 2010 at 9:11 AM, Dave Davisdda...@harriscomputer.comwrote: That's some shopping list. I haven't seen anything anywhere that lets you adjust this limit. Besides breaking the record up into separate tables, you may need to make a temp file that normalizes this for you, by doing something like stringing the value or row number into the key. I've never had anything approaching 10240 values in a multivalue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 10:54 AM To: U2 Users List Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Compiling 102
The usage of the CATALOG command depends on the flavor you are using. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, October 21, 2010 2:24 AM To: U2 Users List Subject: Re: [U2] Compiling 102 Bill, By default CATALOG will catalog programs globally. To catalog a program locally you have to use the LOCAL option. This will generate a VOC entry for the program name without the file name. So CATALOG BP CODE LOCAL will generate a VOC entry named CODE. To run the program you only need to type CODE at ECL and your program will run. Quite simple really. Mecki On 20/10/2010 17:06, Bill Brutzman wrote: I have been using Revision suffixes and VOC. In other words... LOGTO SANDBOX ED VOC SAMPLE.PROGRAM PA RUN BP SAMPLE.PROGRAM.R1 -- R2 save BASIC BP SAMPLE.PROGRAM.R2 After the program is found to be workable... LOGTO METAL ED VOC SAMPLE.PROGRAM PA RUN BP SAMPLE.PROGRAM.R1 -- R2 save I have only been using CATALOG to register global SUBs. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: Wednesday, October 20, 2010 11:44 AM To: U2 Users List Subject: Re: [U2] Compiling 102 You might want to consider having two BP files - Production and Test (Sandbox?) - e.g. BP and TEST.BP You then use the CATALOG command to control which version is running. Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, October 20, 2010 8:28 AM To: U2 Users List Subject: [U2] Compiling 102 1. It works. Thanks to Kat, Tom, Vance, and Drew. 2. I am wondering if others keep their source code in an UV account as such. 3. Prior to this thread, I had two accounts /u2/METAL /u2/SANDBOX 4. The source code was not in a UV account in /u2/SOFTWARE 5. An advantage that I seem to have now is that I can compile code when logged in to either METAL or SANDBOX and the compiled code works in both METAL and SANDBOX. In other words, I do not have to compile the same source code for each account. It is not clear to me how VOC and Q-Pointers are setup to handle this scheme. 6. Comments would be welcome. --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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CUPS printing and sequence of jobs
When we used cups on our Linux server I had to go directly to the IP address of the printer circumnavigating the Windows print server. Going through the print server created too many problems, especially for print jobs that we had imbedded pcl coding. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, October 05, 2010 1:21 PM To: U2 Users List Subject: Re: [U2] CUPS printing and sequence of jobs it's a Canon Imagerunner copier/printer with it's own pc acting as a server. I'm not really sure what OS it's running, I don't think it's windows. I'm submitting lpd protocol to it, directly to it's IP I switched our side so that cups sends to a Windows PC running RPM lpd server, and RPM then sends the raw data to a windows network printer (same copier/server) except it's getting it's jobs through the networks windows printer server, and the jobs print as expected. So, it's definitely in the Canons PC's lpd server specifically. This all sounds great..and solved, EXCEPT, we have found another little issue with cups, it seems when the lpd server is busy, cups triggers the printer queue to disable (ErrorPolicy stop-printer), which is extremely annoying to have to keep reenabling the queue when you send a flurry of jobs. So we changed it so the ErrorPolicy retry-job instead, now it doesn't take the queue offline, instead now it just doesn't send a job to the server, but still deletes it from it's queue. SoUntil I can get this lost job issue solved, looks like I have choices: 1. Look into changing from lpd protocol (port 515) to Ipp protocol (port 9100) (next attempt) 2. See if the server's admin can set something so the lpd server does FIFO 3. have fun sorting printed jobs back into their correct order! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Tuesday, October 05, 2010 1:50 PM To: U2 Users List Subject: Re: [U2] CUPS printing and sequence of jobs Is this with a standalone hardware printer server, or a PC acting as a printer server? If the latter, with what software on the PC? Our Print Wizard software for Windows can act as a printer server. We have *some* capabilities for job sequencing, and we could explore more options with you if this is critical. On Tue, 5 Oct 2010, George Gallen wrote: the debug info shows they were sent to the printer in the numerical unix job# order. I disabled the printer, sent the jobs again, and the unix job# order was the same as the order sent, I renabled the printer and when the jobs printed they were in random order, according to the cups log, they were sent in the correct order. So it looks like it's the receiving print server that is sending them in random order to the printer, of course the admin for that server swears it does FIFO... Thanks for the debug tip... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Saturday, October 02, 2010 12:51 PM To: U2 Users List Subject: Re: [U2] CUPS printing and sequence of jobs Maybe turn the logging up a notch and verify the order they are being submitted? It might not be considered submitted until it finishes spooling, where a large job can be surpassed by smaller jobs. We would not really want it to block on large print jobs. Take for instance you start spooling an invoice run that may take 5-6 minutes to spool, you do you not want to process any other jobs while this thing is transferring to the queue? ___ 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 Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] where did everyone go ?
I guess everyone is just happy happy so no reason post ? Or has the list just become irrelevant ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: September 30, 2010 10:00 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] where did everyone go ? I'm still here :) I noticed the same thing though. Wonder if some people dropped off the mailing list.. -Chris Date: Fri, 1 Oct 2010 06:52:26 +0530 From: anantkum...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] where did everyone go ? Same here :-) Anant On Tue, Sep 28, 2010 at 12:58 PM, bpar...@nemianlife.lu wrote: I'm lurking as usual, nothing to add, lots to learn. 8-) Brian From: u2ug simpson-u...@gerzio.ca To: u2-users@listserver.u2ug.org Date: 27/09/2010 18:07 Subject: [U2] where did everyone go ? Sent by: u2-users-boun...@listserver.u2ug.org The number of postings has drastically dropped over the past few weeks down to virtually zero Has the list been relegated the dust bin and I missed the notice ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV index with duplicate nodes
Does the correlative have any special coding in it? I would suggest deleting the index for this field recreate the field as a D type then add the field to the index again. Some correlatives don't give you what you would expect. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Thursday, September 30, 2010 7:47 PM To: U2-Users@listserver.u2ug.org Subject: [U2] UV index with duplicate nodes We've just uncovered a rather unusual and unsettling situation. We have a file with a single index that has somehow gotten nodes with duplicate keys. A simple example would be having an index on ZIPCODE in a address database, and finding that there are _two_ nodes (records) in the index for ZIPCODE 12345, for example. The source records referred to in the nodes are not duplicated, but since most operations find the 'first' node, any source records referred to in the duplicate node appear to not exist in the index. LIST.INDEX fname ALL Alternate Key Index Summary for file fname File... fname Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type fieldnameANot Reqd YesYes ML N2 The file contains 6,539,233 records, with 574,547 unique values in fieldname (which is actually a single-valued field, and has been verified that each record's fieldname contains one and only one value). We found that 9 source records appear to have not been included in the index, but upon further research found the nodes with duplicate keys. We created an F-pointer to the index file itself (not normally recommended, but useful), then got the results like the following: LIST indexfile WITH @ID = 12345] F1 F2 fname. F1 F2 12345 987654 876543 12345-6789 765432 543219 12345 654321 We are having our UniVerse administrator ask our dealer for assistance, but were interested if any other users have had any recent similar experiences, or advice. Sincerely Best Regards, Richard Lewis IBM Certified Solutions Expert Nu Skin Enterprises ___ 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] UVRESTORE error
Look up the command in the documentation. You will notice that if you are going to restore to a lower revision you will need to back up with one of the -rev options. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, September 28, 2010 1:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] UVRESTORE error Hello, We have a new version of UniVerse on our new server and every night we make a backup image using UVBACKUP. Today I tried to do a UVRESTORE from last night's backup onto the old server which is running a slightly older version of UniVerse and received the following message: WARNING: Unable to restore image of revision level 10. This process is only capable of restoring backup images created with revisions between 2 and 9, inclusive. I'm assuming this message is due to the different versions of UniVerse but I was curious if there was a quick workaround that people have found? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] where did everyone go ?
The number of postings has drastically dropped over the past few weeks down to virtually zero Has the list been relegated the dust bin and I missed the notice ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] FW: Warning: mvargh...@silverlinewindow.com - User unknown!
Any idea why I got this bounce back ? shouldn't this just have gone to the list server and not to me ? -Original Message- From: MDaemon at mdaemon.slbp.com [mailto:mdae...@silverlinewindow.com] Sent: September 27, 2010 12:08 PM To: u2ug Subject: Warning: mvargh...@silverlinewindow.com - User unknown! mvargh...@silverlinewindow.com - no such user here. There is no user by that name at this server. : Message contains [1] file attachments ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] where did everyone go ?
So it wasn't just me -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: September 27, 2010 12:27 PM To: U2 Users List Subject: Re: [U2] where did everyone go ? The number of postings has drastically dropped over the past few weeks down to virtually zero Has the list been relegated the dust bin and I missed the notice ? All of the problems have been solved. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] Does Reality Flavor have globally cataloged subroutines?
We are running in Reality flavor and have many globally cataloged programs. We have separate catalog commands for doing this just as others have mentioned. I have never seen a problem doing this. Jerry -- From: George Gallen ggal...@wyanokegroup.com Sent: Thursday, August 26, 2010 9:53 AM To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] Does Reality Flavor have globally cataloged subroutines? I'll have to play around this this then Thanks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Thursday, August 26, 2010 9:49 AM To: U2 Users List Subject: Re: [U2] Does Reality Flavor have globally cataloged subroutines? Hi George, If I do that, then I lose the features of the Reality Account correct? Or Do I change it, catalog the routine, then change it back? You could create an alternative named VOC entry that uses INFORMATION.FORMAT to save changing it back. However, it may not really be an issue. The Reality mode version of CATALOG behaves the same as the Information style one with no extra options (what Ideal/Information and PI/open call normal mode). By selecting the INFORMATION format you gain LOCAL and global modes. The problem is that those accounts were imported from a Reality system, and I wanted to use some of the subroutines that were written on another account imported from a Prime system. The mode of CATALOG has no effect on what you can call. It only determines how the cataloguing is done. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unix to SQLServer
Hear, hear, and as an end user I welcome knowing about new, and old, products that are available for my use. Jerry -- From: Larry Hiscock lar...@wcs-corp.com Sent: Friday, August 13, 2010 11:26 AM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] Unix to SQLServer At the risk of being roasted for mentioning my vendor product (see other threads - it seems to be unpopular) ... I'm not speaking for the U2UG officially, but as a moderator on this list, and as the list host. IMHO, there is nothing wrong with mentioning or endorsing a product, whether it's free or commercial. If it provides a solution to the problem in question, then it's germane to the discussion. What I personally find distasteful is when someone gives a product a glowing review without disclosing the fact that they stand to benefit from its sale. That's why we've simply asked that when endorsing a product with which one has a fiduciary relationship, that it be disclosed as such. Ok, back to the topic... Larry Hiscock Moderator ___ 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] RetrieVe enhancements
Yes, all of the time. It's still a very good ad hoc reporting tool. Plus we have many reports that are generated using retrieve that we transform into PDF's. -- From: Symeon Breen syme...@gmail.com Sent: Friday, July 16, 2010 2:42 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] RetrieVe enhancements This got me thinking - pardon the question, I have not used retrieve for such things for many years , but do people still use retrieve for print or screen reporting ? Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 16 July 2010 16:28 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RetrieVe enhancements With full agreement that C justification would be helpful if built-in, this function is easily accomplished with a correlative or even a call to a common subroutine. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] @LOGNAME on Unidata
We ran into a similar situation in the past with uv on hpux Although @LOGNAME is documented as a readonly value, we found out that it is possible to change it ( and other readonly system variables ) by passing it as an argument to a subroutine - the subroutine can then change the value. I guess uv doesn't actually mark the variable as readonly in any way at run time - readonliness is a compile time attribute - so a subroutine has no idea that its calling args are readonly system variables - so in effect they aren't. Look for any subroutines called with @LOGNAME as an argument then check that the sub doesn't alter that argument. Given : ... CALL *SOMESUB( @LOGNAME ) ... DEFINE SUBROUTINE SOMESUB ( ARG ) ... * this will change the argument value in the calling routine * including 'readonly' system variables ARG=Something ... END Pass temp variable instead of @LOGNAME : CALL *SOMESUB( @LOGNAME: ) -or- CALL *SOMESUB( (@LOGNAME) ) -or- Ensure that argument is never modified in the routine -- DEFINE SUBROUTINE SOMESUB ( ARG.IN ) ARG=ARG.IN ;* the only place IARG is ever used ... ARG=SomethingElse ... END Note that this also applies to functions and routines called via SUBR() and once the variable is changed it is changed for the lifetime of the current session not just for the current program. Gerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: June 17, 2010 02:04 PM To: U2 Users List Subject: [U2] @LOGNAME on Unidata We recently migrated from Unidata 7.1.8 on Solaris to Unidata 7.2.5 on RedHat. We make use of @LOGNAME quite a bit to determine a person's username. Since our migration, however, we've documented some cases where @LOGNAME is not returning the proper username - it returns someone else's. What's bizarre is that most of the time it's right, but occasionally it's not. Has anyone seen or heard of this? When we had a report of this (with documentation) I thought it was weird. Today we just got a call about a different problem which I'm 99% sure is tied to this since it makes use of @LOGNAME. Like the above, sometimes it's correct, sometime it's wrong. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ 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] @LOGNAME... Changing @variables
That is different from universe where you get the error @Variable (Read-only) unexpected when you try to directly assign to @LOGNAME -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: June 17, 2010 06:53 PM To: U2 Users List Subject: Re: [U2] @LOGNAME... Changing @variables I looked into this and there appears to be 2 different type of system variables in UniData. There are those like @AM which cannot be changed and those like @LOGNAME which can be. It is not required to pass them to a subroutine to change those that can be. A program will not compile if you assign to the first type. First type (Those that cannot be changed): @ACCOUNT @AM @COMMAND @CRTHIGH @CRTWIDE @DATA @GID @LASTVERB @LEVEL @LPTRHIGH @LPTRWIDE @PARASENTENCE @PATH @RM @SM @SVM @SYS.BELL @SYSTEM.RETURN.CODE @TM @TRANSACTION @TTY @UDTNO @UID @VM @WHO Second type (Those that can be freely changed): @CONV @DATE @DICT (This is actual usage. Documented) @FORMAT @HEADER @ID (This is actual usage. Documented) @LOGNAME @MONTH @RECORD (This is actual usage. Documented) @RECUR0 (This is actual usage. Documented) @RECUR1 (This is actual usage. Documented) @RECUR2 (This is actual usage. Documented) @RECUR3 (This is actual usage. Documented) @RECUR4 (This is actual usage. Documented) @TIME @USER0 (This is actual usage. Documented) @USER1 (This is actual usage. Documented) @USER2 (This is actual usage. Documented) @USER3 (This is actual usage. Documented) @USER4 (This is actual usage. Documented) @USER.RETURN.CODE (This is actual usage. Documented) @YEAR Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Friday, June 18, 2010 8:29 AM To: U2 Users List Subject: Re: [U2] @LOGNAME on Unidata We ran into a similar situation in the past with uv on hpux Although @LOGNAME is documented as a readonly value, we found out that it is possible to change it ( and other readonly system variables ) by passing it as an argument to a subroutine - the subroutine can then change the value. I guess uv doesn't actually mark the variable as readonly in any way at run time - readonliness is a compile time attribute - so a subroutine has no idea that its calling args are readonly system variables - so in effect they aren't. Look for any subroutines called with @LOGNAME as an argument then check that the sub doesn't alter that argument. Given : ... CALL *SOMESUB( @LOGNAME ) ... DEFINE SUBROUTINE SOMESUB ( ARG ) ... * this will change the argument value in the calling routine * including 'readonly' system variables ARG=Something ... END Pass temp variable instead of @LOGNAME : CALL *SOMESUB( @LOGNAME: ) -or- CALL *SOMESUB( (@LOGNAME) ) -or- Ensure that argument is never modified in the routine -- DEFINE SUBROUTINE SOMESUB ( ARG.IN ) ARG=ARG.IN ;* the only place IARG is ever used ... ARG=SomethingElse ... END Note that this also applies to functions and routines called via SUBR() and once the variable is changed it is changed for the lifetime of the current session not just for the current program. Gerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: June 17, 2010 02:04 PM To: U2 Users List Subject: [U2] @LOGNAME on Unidata We recently migrated from Unidata 7.1.8 on Solaris to Unidata 7.2.5 on RedHat. We make use of @LOGNAME quite a bit to determine a person's username. Since our migration, however, we've documented some cases where @LOGNAME is not returning the proper username - it returns someone else's. What's bizarre is that most of the time it's right, but occasionally it's not. Has anyone seen or heard of this? When we had a report of this (with documentation) I thought it was weird. Today we just got a call about a different problem which I'm 99% sure is tied to this since it makes use of @LOGNAME. Like the above, sometimes it's correct, sometime it's wrong. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ___ 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 __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email
Re: [U2] UV Memory issues
Do you have or have you added any other applications running on the same server or is it dedicated to UV? I have seen where having another application running on the same server will conflict with UV. -- From: u2ug simpson-u...@gerzio.ca Sent: Tuesday, June 08, 2010 10:31 AM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] UV Memory issues We started running into a situation recently where a box running universe 10.2.11 on hpux 11.31 started to have severe performance problems, zero response, processes that normally take seconds to run taking hours etc. In Top we could see that the reported free memory was averaging about 28M at times dropping to less than 5M and that the vhand process was chewing up a most of the cpu. With the free memory that low, vhand hogging the system makes sense. Why the memory is that low is the question. The machine has 4G of memory, right after reboot before anyone but me gets on the system top shows us at 3G free. If we just let the system sit, free memory will sit happily at 3G. As soon as we start using universe, the free memory starts to fall. Logging out all universe processes and even bringing universe down has no effect on free memory - I would have expected the memory to be freed up once the universe processes and in particular universe itself was terminated but that's not what we are seeing. We were in the process of setting up a new box physically the same as the old box but running uv 10.3.6 on hpux 11.3.1. So I am looking at this problem now on that box in isolation. We were hoping that this would turn out to be a hardware issue but we are seeing the same problem on this new box as well. This is out of my realm of experience and I am stumped as to where to go next. I have the system guy checking with hp , my guess is they are going to point the finger at uv. I am going to check with our var - I'm not overly optimistic there either. Any suggestions ? - Hpux/uv tunables we should be looking at - can we tell universe to restrict the amount of physical memory that it uses ? - Or maybe this is a garbage collection issue ? - universe or hpux being overly aggressive about caching - any hpux utilities that we can use to see exactly where the memory is being used ? - ? Gerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: June 8, 2010 09:41 AM To: 'U2 Users List' Subject: [U2] [Unidata-Windows] Can login, but not execute any command Upfront: The problem was solved by re-installing UniData My client had UniData 7.2.3 on Windows within his domain. He rebooted all servers within his company over the weekend. Yesterday UniData suddenly didn't work anymore. I could log in to the database, but any command, whether Write, Select or catalogued subroutine would stop dead in its track. There was no error message, no indication what could have gone wrong. UniObjects had no time-out, the application hung for hours. I telneted into the database and many users got the unknown user error, I just found one user that allowed me to log in. I ran a few commands and that worked. My hunch is that a Windows update changed NT-Authentication and UniData didn't like it. Poking through the logs, I see in the Windows security log two entries for every UniData login, one success and one failure: The first a success audit: A trusted logon process has registered with the Local Security Authority. This logon process will be trusted to submit logon requests. Logon Process Name: \udapi_server.exe Then a failure audit: The logon to account: HHC-Unidata by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0 from workstation: HORIZONSERV4 failed. The error code was: 3221225572 The error code means: 32212255720The specified user does not exist. This behavior started already last year, and even now that everything works again. Does anyone have ideas or similar experiences? Martin Scholl 18910 New Hampshire Ave Brinklow, MD 20862 Phone: 301-924-5537 Cell: 301-613-9572 martin.sch...@hipaasuite.com www.HIPAAsuite.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ and Abnormal termination of UV
Let me see, can it be because you are trying to cram over 4 GB of data into a single cell. Unlike the OPEN statement that just puts the file variable into a variable, the OPENSEQ opens the whole file to the variable. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rajesh Menon Sent: Monday, May 17, 2010 1:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] OPENSEQ and Abnormal termination of UV Does anyone knows what is happening here: I am trying to open a text file (over 4Gb) using OPENSEQ and storing the file variable into a array as follows: COMMON /MYPROG/ FILEVARS(10) OPENSEQ /tmp/file.txt to FILEVARS(1) ELSE ... This operation results abnormal termination with fault type error 11. Fault occurred at address 1c (which is the OPENSEQ command.). If the file size is less than 2147483647 bytes (2Gb), it works. Opening the same file using a scalar file variable always work irrespective of the file size. OPENSEQ /tmp/file.txt TO FV.FILE ELSE ... Any reason why the first method failing for +2Gb files? Any workarounds? Universe: 10.2.7 AIX: 5.3 Thanks Rajesh Menon ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV on Windows
Anybody know what permissions a person needs to use all of the UniAdmin options on a Windows server running UniVerse. Right now I can bring up the UniAdmin when I rdp to the system but I can't see any of the users except myself. I can't kill a user because they don't show up on the users window. Same thing with the locks. I try to clean the licenses but that doesn't seem to do anything. I need to know what I need so I can tell the network administrator what he has to do. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert Administration and Development ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Looking for a Job.....
You do realize that you have more of a chance of finding a job in India than you do here, right. Most of the jobs here have been outsourced to your country or China. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed Sent: Monday, April 12, 2010 10:58 AM To: u2-users@listserver.u2ug.org Subject: [U2] Looking for a Job. Hi everyone, I have around 9yrs of experience on Unidata, Pick Basic, Unibasic, Redback and other technologies like ASP.Net, C# and XML. I am currently leading a offshore team in India and now looking for a change. I am looking a job near Dallas, Texas. Thanks Jaweed ___ 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] import data to excel sheet...
This is a function of the operating system. On Unix systems only a linefeed character is added to the end of a line whereas on Windows both carriage return and linefeed characters are added to the end of a line. If you open a file created on a Unix system with the notepad app it will have one line with strange characters in it. A quick fix, if you open the same file with word pad it will be converted and you can save it. If you created a file on a Unix system for use on a Windows system you have to add a carriage return character to the end of the line. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, April 12, 2010 11:01 AM To: U2 Users List Subject: Re: [U2] import data to excel sheet... Hi Jaweed, I haven't looked too closely at your code, but I did notice on thing that I would consider the most likely candidate: CHAR(13) is a carriage return, not a line feed. Try using CHAR(10) instead for your LINE.FEED variable. You might have to use CHAR(13):CHAR(10), but I think CHAR(10) should do it. Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed Sent: Monday, April 12, 2010 7:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] import data to excel sheet... Can anyone tell me what is wrong with the following code for importing data from txt file to an excel sheet, when its launch Excel it giving some error message, but when I open the downloaded file from my disc, all the data is in one line with some especial Chars. Any help will be appreciated. 034: ** 035: * OPEN FILES * 036: ** 037: ERRMSG = '' 038: OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE 039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!' 040: END 041: IF ERRMSG THEN 042: GOSUB 91000 043: RETURN 044: END *--: P 045: ** 046: * INITIALIZE * 047: ** 048: PAGE.FEED = CHAR(12) 049: LINE.FEED = CHAR(13) 050: ;* 051: ;* Read the text file to convert 052: ;* 053: READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE 054: ERRMSG = ITEM : TEXT.REC.NAME : DOES NOT EXIST IN : TEXT.FILE.NA ME 055: GOSUB 91000 056: RETURN 057: END 058: ;* 059: ;* Set default values (none are used now) 060: ;* 061: VALUE = DEFAULT 062: LOCATE PROPERTY IN FORMATSTR1 SETTING PTR THEN 063: VALUE = FORMATSTR2,PTR 064: END 065: ;* 066: ;* Remove the first line if it contains a PAGE.FEED *--: P 067: ;* 068: LOOP WHILE TEXT.REC1 = PAGE.FEED DO 069: TEXT.REC = DELETE(TEXT.REC,1) 070: REPEAT 071: IF TEXT.REC1[1,1] = PAGE.FEED THEN 072: TEXT.REC1 = TEXT.REC1[2,LEN(TEXT.REC)] 073: END 074: ;* 075: ;* Find the header for each page 076: ;* 077: SLK.REC = '' 078: SLK.ROWS = 0 079: SLK.HEADER.LINES = 0 080: IF TEXT.REC1[1,10] = RUN D - T: THEN 081: SLK.REC-1 = F;SD;R3 082: SLK.REC-1 = F;SD;R4 083: SLK.REC-1 = C;Y1;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC1[1,30],';',';; '))) 084: SLK.REC-1 = C;Y2;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC2[1,30],';',';; '))) 085: SLK.REC-1 = C;Y3;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC1[31,90],';','; ;'))) 086: SLK.REC-1 = C;Y4;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC2[31,90],';','; ;'))) 087: SLK.ROWS = 4 088: SLK.HEADER.LINES = 2 *--: P 089: END 090: ;* 091: ;* Find the number of lines in the header 092: ;* 093: LINES = DCOUNT(TEXT.REC,@AM) 094: SLK.HEADER.CNT = 0 095: FOR IDX = SLK.HEADER.LINES+1 TO LINES 096: IF INDEX(TEXT.RECIDX,---,1) THEN 097: SLK.HEADER.CNT = IDX 098: EXIT 099: END 100: NEXT IDX 101: ;* 102: ;* Find the column locations 103: ;* 104: COL.LIST = '' 105: IF SLK.HEADER.CNT THEN 106: DASHES.LINE = : TEXT.RECSLK.HEADER.CNT : 107: DASHES.LINE = TRIM(DASHES.LINE,'-') 108: DASHES.CNT = COUNT(DASHES.LINE,'-') 109: DASHES.LINE = TEXT.RECSLK.HEADER.CNT 110: FOR DASHES.IDX = 1 TO DASHES.CNT *--: P 111: COL.START = INDEX(DASHES.LINE,'-',1) 112: DASHES.REMAIN = LEN(DASHES.LINE) - COL.START + 1 113: COL.LEN = INDEX(DASHES.LINE[DASHES.REMAIN],' ',1)-1 114: IF COL.LEN 1 THEN COL.LEN = LEN(DASHES.LINE) 115: COL.LISTDASHES.IDX,1 = COL.START 116: COL.LISTDASHES.IDX,2 = COL.LEN 117: DASHES.LINE[COL.START,COL.LEN] = SPACE(COL.LEN) 118: NEXT DASHES.IDX 119: END 120: ;* 121: ;* Extract the column titles 122: ;* 123: COL.CNT = DCOUNT(COL.LIST,@AM) 124: FOR HDR.IDX = SLK.HEADER.LINES+1 TO SLK.HEADER.CNT-1 125: SLK.ROWS = SLK.ROWS + 1 126: SLK.Y = Y : SLK.ROWS : ; 127: ;* 128: ;* Make sure the header properly fits into the column 129: ;* If it does not, then add it to the spreadsheet's first column 130: ;* 131: CHECK.LINE =
Re: [U2] Regex searching UD files
I'm on UV and from the Unix command line I can do the following: cd /usr/ibm/uv uv port.status | grep j_banker It will list every line with my login. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, March 29, 2010 4:13 PM To: U2 Users List Subject: Re: [U2] Regex searching UD files Not even close... We run in ECLTYPE P and don't have access to EVAL and the like. ^[Cc][Hh][Qq].*[5-8][0-9][0-9][0-9]x Unless you can explain how to duplicate the above search with ESEARCH? @Stuart, that would be ideal, but unfortunately I can't go dumping out multi-gigabyte files. :( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, 30 March 2010 5:22 AM To: U2 Users List Subject: Re: [U2] Regex searching UD files Does UniData ECL ESEARCH command not fill the bill already? Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Monday, March 29, 2010 12:22 AM To: U2 Users List Subject: Re: [U2] Regex searching UD files I think this should be one for Rocket to implement a RegexSearch in U2. However, if it's size non-impactive, what I would normally do is copy the file to a temporary directory then run grep across that. Stuart Boydell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, 29 March 2010 17:08 To: U2 Users List Subject: [U2] Regex searching UD files I've written a small utility to be able to run egrep on a UD file (not UD directory), however its implementation is not ideal. Essentially, I select the file I'm searching, writing each record one at a time to a temp UNIX file and running egrep on it as follows !egrep -q -f MyTempRegexFile MyTempRecordFile ; echo $? Where MyTempRegexFile is a file containing the desired regex pattern stored earlier and MyTempRecordFile is a file name unique to each user. My problem with it is that I have to do a READ on each record, followed by a WRITE then have egrep read it in as well. That's a lot of seemingly unneeded disk IO if I could only stream the record to egrep without have to do a WRITE after the READ. Any ideas? I feel I'm missing something quite obvious. Regards, Dan ### 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 ___ 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 __ 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
Re: [U2] Pick on Mac
I think I saw someone on this list that was using one of the U2 products on Mac OSX or on the Windows virtual emulator. Could be wrong. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Monday, March 29, 2010 2:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick on Mac Are there are native implementations of a Pick system on Macs? Or are all Mac connections just terminal emulators into a Windows/Unix system? I know there is or used to be an emulator by Carnation that rode on a Mac. But have all such implementations been to have it talk with a Pick system living on a Windows or Unix box? Does Universe have any sites where users are connecting using Macs as their PC? Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Microsoft SQL Server Driver Support
The U2 team at Rocket Software announces a renewed focus on improving SQL interfaces to the UniData and UniVerse data servers. Microsoft SQL Server Driver Support Starting with the November release of UniData on Windows, the Rocket U2 team will deliver and support the Microsoft SQL Server driver for External Database Access (EDA) on Windows platforms. The same driver is available now in the Early Adopter release of UniVerse 11. To obtain the SQL Server driver for EDA, contact u2as...@rs.com. Please tell us what database you're using when you do so. External Database Access (EDA) is required in order to use the SQL Server Driver. EDA is available for Workgroup and Server edition and is included with Enterprise edition of the databases. Common Mapping Tool and Schema Generator In addition, we are in the early planning stages for an improved, common mapping tool and schema generator for fully describing the U2 data model in order to generate SQL and EDA schemas. This new tool will provide a modern, extensible interface for both initial mapping as well as updating of schemas. This tool, with its associated APIs, will improve deployment of ISV solutions to end customer sites thereby saving time and speeding time to market. This tool will be available with UniVerse 11.1 and in a UniData 7.3 release to follow. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert Administration and Development ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniObjects 'Exec'
I did some playing around with this and was surprised at what I found. First I would have assumed that any error messages would have been returned as part of the command.Response But they aren't. So I tried setting up a simple program to execute a command line, capture the output and CRT it. crt 'start' get(ARG.) xqt else return crt 'before' execute xqt,OUTrslt,STATUSst crt 'after' crt '[':rslt:'][':st:']' crt 'done' This works fine as long as there is no error in the EXECUTED command. LIST VOC WITH @ID LIKE 'A...' SAMPLE 1 Console output : start before after [þ1 record(s) selected to SELECT list #0.þ][1] done UO command.Response contains: start before after [þ1 record(s) selected to SELECT list #0.þ][1] done however with an error LIST VOC WITH BadField LIKE 'A...' SAMPLE 1 Console output : start before after [Retrieve syntax error. Unexpected explicit item. Token was 'BadField'.þ Scanned command was LIST VOC WITH 'BadField' þ3][-1] done UO command.Response contains: start before after [][-1] Done So it seems that any error messages are eaten - the really bad thing about this is that if you have a program that handles this type of error - it won't work because it will never see the error and that's pretty BOGUS !!! Gerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: February 19, 2010 09:49 AM To: 'U2 Users List' Subject: [U2] UniObjects 'Exec' We are using a product and just found out that one of the reasons we're having some difficulties on an installation was that one of my dictionaries was not defined at a new site. This caused a 'Exec' of a SELECT to fail, but here's the kicker -- in BASIC, we could have 'seen' the error with CAPTURING and RETURNING -- but I'm told the interface to UniObjects does not return this diagnostic information on the 'Exec'... So in BASIC, I would have EXECUTE 'SELECT FILENAME WITH DICTITEM = A' CAPTURING THIS RETURNING THAT And I could 'query' what is in THIS and THAT to decide if there is a problem if the DICTITEM didn't exist for some reason. I'm told that the product we're using cannot do this same thing -- there is no way to 'know' the message 'select criteria DICTITEM is not a field' was returned from the 'Exec' as we could have seen in the BASIC EXECUTE. Is there no way to get back this same REALLY valuable feedback in UniObjects? How do you code for this issue in UO? This would not be big deal if we had source code or a 'log' of what was happening -- we just had a screen that didn't come up, and with dozens of fields, it's not obvious what the issue was -- until we found it! But the failure of the 'SELECT' command causes the 4GL based on UO to just 'die' I don't want to be stung another time with this, and am never afraid to ask for thoughts or ideas!! If there is a way to handle this, I want to find it and get the idea into their head so I never have a 'lost day' trying to hunt down this kind of issue... TIA!! David Wolverton ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Spooler for Windows
What products are out there that mimic the Unix UniVerse spooler in a Windows environment? From what I can see on Windows, UniVerse uses the Windows printer subsystem and in my estimation that was a mistake. There's no retention of print jobs, no form type, no ability to use scripts, it is the biggest stumbling block for conversion from a 'nix environment. I would only like to look at packages that are built to work with UniVerse and are like the Unix spooler with all the bells and whistles. We have moved from Unix V5, to Solaris, to RH Linux, and our spooler scripts only needed minor changes long the way. Now we are trying to go to Windows and the only stumbling block the we have encountered is the spooler. We did so much with it. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert Administration and Development ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData ICONV function
Changing DIMDY to D-MDY will do what you want in universe regardless of any system settings. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: February 10, 2010 02:05 PM To: U2 Mail List Subject: Re: [U2] UniData ICONV function The problem I'm having is people with different XP date settings (U.S. International) access one of the programs in our application. This program prints an amortization schedule. Our code parses the day, month, and year via... DUEMO = OCONV(BEGDATE , 'DM') DUEDAY = OCONV(BEGDATE , 'DD') DUEYR = OCONV(BEGDATE , 'DY') ...then the information is converted to an internal PICK date via... DUEDATE = ICONV(DUEMO:'-':DUEDAY:'-':DUEYR, 'DI') Once this is done the date is printed along with the various loan payment information. The month is incremented (and year when necessary) then the process repeats. We notice when an international date configured XP machine accesses our code via UniObjects (DesignBais), we think DATE.FORMAT is adjusted and our code fails. Instead of getting Feb 1st, we get Jan 2nd. Instead of getting Mar 1st we get Jan 3rd. etc. We noticed if we implement this ICONV code all is well. DUEDATE = ICONV(DUEMO:'-':DUEDAY:'-':DUEYR, 'DIMDY') We were curious if this is standard and whether it works in UniVerse? Thanks, Bill Ron Hutchings said the following on 2/10/2010 5:50 AM: It didn't work for me with your conversion code but when I changed it to 'D' it worked just fine. Internal conversions don't need all the fancy output codes. Date: Tue, 9 Feb 2010 22:14:40 -0800 From: iako...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData ICONV function Hi Bill, What version of UD are you running? We had serious problems with date conversion using ICONV in version 10.2.7 of Universe. However this problem of yours looks like a DATE.FORMAT problem Its looking at the month and thinks its a date and looking at the date and thinks its a month. change your date format (ON / OFF) depending on which part of the world you're in. jack Bill Haskett wrote: 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 -- View this message in context: http://old.nabble.com/UniData-ICONV-function-tp27526458p27526610.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ Your E-mail and More On-the-Go. Get Windows Live Hotmail Free. http://clk.atdmt.com/GBL/go/201469229/direct/01/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] extraction conversion codes
I wonder the same thing. All he's doing is converting a D type to a correlative and in that case I would much rather have it an A or S type so you don't have to be misled by the type and not looking for the special coding in field 3. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Friday, February 05, 2010 1:33 PM To: U2 Users List Subject: Re: [U2] extraction conversion codes Hi Gerry, Out of curiosity, why are you against I-types? 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] extraction conversion codes
I don't see this as misleading if anything it makes a simple list of a dictionary much more obvious as all D types for the same location are listed together as opposed to having to SEARCH the DICT for references hidden in I types. I can't speak to A or S types as I've never used them. But to the point, the preference for D over I was performance, I-types take roughly 3.5x longer to execute that the corresponding D-type. On an older/slower box churning through very large amounts of data this can have an impact. I reran the timings since the original post on our current machines ( this process has been around for a few hardware/software generations ) and the 3.5x still holds but the overall impact has decreased to the point where this issue is pretty much moot. Gerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: February 8, 2010 05:59 PM To: 'U2 Users List' Subject: Re: [U2] extraction conversion codes I wonder the same thing. All he's doing is converting a D type to a correlative and in that case I would much rather have it an A or S type so you don't have to be misled by the type and not looking for the special coding in field 3. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Friday, February 05, 2010 1:33 PM To: U2 Users List Subject: Re: [U2] extraction conversion codes Hi Gerry, Out of curiosity, why are you against I-types? 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 ___ 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] Resize Question
If you are starting out with trying to use SQL on a legacy database your best bet would be to create a separate account just for SQL. In the new account put in pointers to the main data files you will be using and create dictionaries to the files locally. In this way you can build the dictionaries to be SQL compliant and only have the fields that you will be using for your SQL apps. It's a little more work to set up but will save loads of time later. If you have files with the same data (current and history files) you can use the same dictionaries so that can cut down on the number of dictionaries used. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, February 03, 2010 2:57 AM To: 'U2 Users List' Subject: Re: [U2] Resize Question Hi Andrew Because UniVerse dictionaries contain not only solid column definitions, but also synonyms and virtual fields, you have to choose which of these will be exposed for ODBC or similar relational protocols. A typical dictionary for a mature system might have a thousand entries which makes navigating these in something like MS query or the .NET data set designer very difficult! So for this you need to do two things: First, create a phrase named @SELECT. This is a dictionary entry in the format: Key: @SELECT 1: PH 2: list of fields SPACE delimited. You can test this out by doing a SELECT * from file at TCL, which uses the same phrase. Then, you need to update the file information cache used by ODBC (prevents it having to scan every dictionary on connect). For this, run the HS.UPDATE.FILEINFO command after making your changes. However, you might also want to step back and consider whether ODBC is really your best choice. To use ODBC effectively you need to understand about dynamic normalizing and the differences between the UniVerse data model and the relational model expected by ODBC. Depending on what you wish to do, ODBC may tie you up in knots and you may be better off looking at one of the native protocols (the UniObjects family) or web services instead. Also, I don't know why you chose to copy your VOC across. That will contain pointers to all the files from the original system, which you don't have on yours, hence the large number of errors you are seeing. If you are brave, you can try a CLEAN.ACCOUNT command, but take a backup first! [AD] You might want to consider my latest book, 'IBM UniVerse Client Developer' (written when this was still an IBM product) which covers the various protocols in depth. You can find details on my website, www.brianleach.co.uk. [/AD] Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E. Tegenkamp Sent: 02 February 2010 4:17 PM To: 'U2 Users List' Subject: Re: [U2] Resize Question Thank you very much! That has helped a lot and I can now see the data in the UV command line :) If possible, I am now hoping to be able to expose this imported data to ODBC so I can work with it in PHP, etc. But I am again finding problems I cannot find an answer for in the help docs or searching the list archive. First, I created a PICK account using the U2UG guide mentioned. I then used HS.ADMIN option 3 to Activate access to files in an account which went well and showed it as an activated account. I copied over the TEMP and VOC (D_VOC, D_VOCLIB, VOC, VOCLIB, etc) files from the live UniVerse server to my account as well as my test table ZIP (ZIP and D_ZIP). I fnuxi'd and SET.INDEX'd them and could see the data on the command line using SELECT COUNT(*) FROM ZIP and the like. However, when I went to ODBC I could only see 3 tables. AE_DOC, HELP_FILE, and HS_FILE_ACCESS (ODBC reported no rows in HS_FILE_ACCESS). I ran HS.ADMIN option 3 again on the account and for most things it said: Could not open file FILENAME. STATUS() = -2 FILENAME was not written into File Information Cache. For the file I copied over, ZIP, it said: ZIP's dictionary has no @ phrase or @SELECT phrase. ZIP was written into File Information Cache but may not behave as desired. This is a little confusing as I thought D_ZIP was the dictionary file and SELECT works on the command line. After this, I checked ODBC and saw the 3 above and one more table called UVMD. I am not sure what this was so I got it but it appears to be a system table of some sort. Thanks again for any tips on how to properly setup/expose this file/table to ODBC! Andrew -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, February 01, 2010 11:55 AM To: 'U2 Users List' Subject: Re: [U2] Resize Question Okay, a few things here... First the index issue. When UniVerse creates an index on a file, it puts the absolute pathname
Re: [U2] Resize Question
We have a process that works strictly with I D type dictionary items. The fewer I-types we have the better. One scenario where we can drop I-types in favour of D-Types is : DATA.VALUE D multi part '*' delimited : date / time 2 ... DATA.VALUE.DATE I DATA.VALUE[*,1,1] D4-YMD ... DATE.VALUE.TIME I DATA.VALUE[*,2,1] MTS ... This can be cooked down to : DATA.DATE D 2 G0*1|D4-YMD ... DATA.TIME D 2 G1*1|MTS ... This works perfectly as long as the delimiter is not a system delimiter ( FM , VM , SVM , TM ) If we have : DATA.VALUE D multi value @VM delimited : date / time 2 ... DATA.VALUE.DATE I DATA.VALUE1,1 D4-YMD ... DATE.VALUE.TIME I DATA.VALUE1,2 MTS ... I don't see any way to drop the I-types because I don't see any conversion codes that cam extract using system delimiters. Am I missing something or are we just stuck with the I-types in these cases ? Gerry ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] extraction conversion codes
Sorry - I forgot to change the subject - didn't mean to hijack the other thread. We have a process that works strictly with I D type dictionary items. The fewer I-types we have the better. One scenario where we can drop I-types in favour of D-Types is : DATA.VALUE D multi part '*' delimited : date / time 2 ... DATA.VALUE.DATE I DATA.VALUE[*,1,1] D4-YMD ... DATE.VALUE.TIME I DATA.VALUE[*,2,1] MTS ... This can be cooked down to : DATA.DATE D 2 G0*1|D4-YMD ... DATA.TIME D 2 G1*1|MTS ... This works perfectly as long as the delimiter is not a system delimiter ( FM , VM , SVM , TM ) If we have : DATA.VALUE D multi value @VM delimited : date / time 2 ... DATA.VALUE.DATE I DATA.VALUE1,1 D4-YMD ... DATE.VALUE.TIME I DATA.VALUE1,2 MTS ... I don't see any way to drop the I-types because I don't see any conversion codes that cam extract using system delimiters. Am I missing something or are we just stuck with the I-types in these cases ? Gerry ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Sharing files
I am very familiar with how to do things on Unix/Linux systems but my knowledge of the MS Windows Server environment is substantially lacking. So I am wondering if the group can give me some pointers. I have a folder on a RH Linux system that I would like to share on a Windows 2K8 server running UV 10.2. The share has been set up using Samba on the RH Linux as3 server and from a desktop or an RDP session to the Windows server I can map the share and us it. But, I would like to use the share from within our main UV account for multiple telnet sessions. On 'nix all I had to do was mount the folder from another system, put a pointer to it in the VOC, and I was up and running. From UV Windows I am at a loss to know where the mount is. I have tried to use a UNC path in the VOC pointer but it doesn't seem to work or possibly I didn't create it properly (\\IPaddress\smbshare\file file:///\\IPaddress\smbshare\file ). They are on two different subnets. Can anyone enlighten me on how they are doing it? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ 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 its column’s values?
No column names but what about LIST.ITEM ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Evan Carroll Sent: January 20, 2010 07:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse RetreiVe how do I query a file for all of its column’s values? This is a repost from a stackoverflow question I asked: http://stackoverflow.com/questions/2068026/universe-retreive-how-do-i-query-a-file-for-all-of-its-columns-values === START REPOST === In UniVerse you can't query a file for all of its columns unless the @ phrase in your file's dictionary is set to all of the tables columns. If it isn't how do you query a table for all of its column's values? So I can get the total column listing (column name display name) using: LIST DICT file NAME This will return a listing of all columns and their display names. How do I then query the table for all of the columns it has? LIST file Will only query it for LIST file @id (@id is the only thing in @). === END REPOST === I'd like to follow up with a request to see if anyone has a copy of a BASIC program that does this, I imagine it is something every heavy universe must keep in arms reach. Thanks a ton, -- Evan Carroll System Lord of the Internets ___ 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] Error connecting to UD 5.2 from SQL Server 2008 SSIS
Is 5.2 still supported? That may convince them that it is time to upgrade. I can't seem to find an availability matrix on Rocket's site. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: Wednesday, January 13, 2010 10:25 AM To: U2 Users List Subject: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS Thanks Bill, I don't think it is an ODBC problem since SSIS connection managers unlike DTS don't use ODBC. They use OLEDB and connect even without the IBM U2 ODBC driver installed. I maybe have to add that both SQL Server 2000 and 2008 run under Windows 2003, so I don't think this is an OS issue either. If anybody has any suggestions how to use UniObjects with SSIS I would give that a try immediately. Easiest would of course be to upgrade to UD 7.2 but unfortunately I haven't been able to convince management to approve that. Mecki Original-Nachricht Datum: Wed, 13 Jan 2010 10:36:27 -0500 Von: Brutzman, Bill bi...@hkmetalcraft.com An: U2 Users List u2-users@listserver.u2ug.org Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS This problem resembles my recent problem with ODBC between HP-Ux and MS-SQL. Tech Support at Rocket indicated that I would probably have to buy special (ODBC) drivers from companies that specialize in data integration because... ODBC is a Microsoft thing and this sort of connectivity is not bundled with most (maybe any) flavors of Unix. Rocket agreed that using UniObjects would be an easier alternative. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, January 13, 2010 7:39 AM To: U2 Users List Subject: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS Hi I am trying to use SSIS to load UniData tables to SQL Server 2008. I already have been using DTS with SQL Server 2000 successfully for a while and I set up everything (System DSN and UCI Editor) the same on the 2008 server. The connection test works fine, but when I try to go further I get this error message. Cannot get string literals from the database connection Provider=Informix.UniOLEDB.1;Password=;Persist Security Info=True;User ID=admin;Data Source=LIVE_DATA;Location=LIVE_DATA;Mode=Read We are running Unidata 5.2 on Solaris. And I am using UniDK for that release on both SQL Server boxes. I had tried using a later version of UniDK before, but that didn't seem to want to connect to the older version of UD at all. Any ideas? Thanks Mecki ___ 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 -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 ___ 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] An interesting find....
Instead of CASE -1 use CASE 1 -- From: George Gallen ggal...@wyanokegroup.com Sent: Tuesday, December 15, 2009 1:23 PM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] An interesting find Here is an interesting tidbit I happened to run across. PROGRAM A: OPEN ,FILE1 TO F.FILE1 ELSE STOP NO FILE1 OPEN ,FILE2 TO F.FILE2 ELSE STOP NO FILE2 * F.FILETOUSE = F.FILE1 (Adding this here will get rid of the compile warning) BEGIN CASE CASE X=1 F.FILETOUSE = F.FILE1 CASE X=2 F.FILETOUSE = F.FILE2 CASE -1 F.FILETOUSE = F.FILE1 END CASE READ XDATA FROM F.FILETOUSE,TEST ELSE XDATA= The above program when compiled says F.FILETOUSE never assigned a value and when it executes, gives an improper file type error HOWEVER: PROGRAM B: OPEN ,FILE1 TO F.FILE1 ELSE STOP NO FILE1 OPEN ,FILE2 TO F.FILE2 ELSE STOP NO FILE2 F.FILETOUSE=F.FILE1 IF X=1 THEN F.FILETOUSE = F.FILE1 IF X=2 THEN F.FILETOUSE = F.FILE2 READ XDATA FROM F.FILETOUSE,TEST ELSE XDATA= Compiles and run just fine, no errors. This is using UV 10.0.2 under the Prime Information flavor George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SELECTs on FILEs
While you are on the subject I have discovered another little annoyance from Windows as opposed to Unix. On Unix, Linux, Solaris, et al you can do a select on an account and get the same results every time, however, on windows you may not. At least with Universe. For a simple test do a select on your current account: SELECT UFD Then do it a second time: SELECT UFD On 'nix systems you will get no difference, but, on windows you will get a list of entries that it says do not exist and the selection count is lower. What I have found is that on the first pass it will select all entries but on the second pass none of the folder type files can be found. An account is usually made up of a variety of file types; including segmented hash and types 1, 19, 25, and 30. What an annoyance when you're trying to create lists for backing up or moving to a test location. -- From: Dan McGrath dmc...@imb.com.au Sent: Sunday, December 13, 2009 6:15 PM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] SELECTs on FILEs Hi all, Just a quick question on SELECTs for UD. I was under the impression that performing a wildcard SELECT with @ID would only result the key section of a FILE been read. Eg, SELECT MYFILE WITH @ID = prefix] Is this incorrect? Does it actually result in the entire FILE being read into memory to complete this SELECT? Regards, Dan ### 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UVPE linux setup
I have just setup uvpe 10.3.3 on opensuse 11.1 Locally universe seems to be running fine. However I can't access it via telnet or UO.NET either local or remote. I must have missed something in the installation guide - how do we configure uvpe on linux to accept connections via telnet uo.net ? Gerry ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UVPE linux setup
Ok - half way there - I got the telnet part working by installing telnet opening up the port through the firewall I still can't connect via UO.NET though - I tried opening up port 31438 - that didn't work so I completely disabled the firewall - still no joy -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: December 14, 2009 03:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] UVPE linux setup I have just setup uvpe 10.3.3 on opensuse 11.1 Locally universe seems to be running fine. However I can't access it via telnet or UO.NET either local or remote. I must have missed something in the installation guide - how do we configure uvpe on linux to accept connections via telnet uo.net ? Gerry ___ 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] UVPE linux setup
Thanks jeff - I got telnet working ok - uo.net is still a problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: December 14, 2009 03:26 PM To: U2 Users List Subject: Re: [U2] UVPE linux setup Universe for Linux does not install its own telnet server like the Windows version does. Make sure your Linux telnet daemon is running. u2ug wrote: I have just setup uvpe 10.3.3 on opensuse 11.1 Locally universe seems to be running fine. However I can't access it via telnet or UO.NET either local or remote. I must have missed something in the installation guide - how do we configure uvpe on linux to accept connections via telnet uo.net ? Gerry ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UVPE linux setup
Thanks - this is just for my own internal use so security isn't really a concern - telnet will do just fine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman Sent: December 14, 2009 03:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UVPE linux setup In message 47c1b98393896f41a7bfe435442394e5268...@gmsdc.gerzio.ca, u2ug simpson-u...@gerzio.ca writes I have just setup uvpe 10.3.3 on opensuse 11.1 Locally universe seems to be running fine. However I can't access it via telnet or UO.NET either local or remote. I must have missed something in the installation guide - how do we configure uvpe on linux to accept connections via telnet uo.net ? I don't think you do! Okay, going back to my days with PI/Open on 7330s, but you logged into Unix then invoked UV. You need to set up telnetd on SuSE (it's disabled or, more likely, not even installed on pretty much every linux nowadays). You can then just log in remotely over telnet, and fire up UV either from the command line or from .profile. General advice nowadays would be (I've never done it myself) to fire up a terminal session over something rather more secure than telnet - something like SSH for example. UO.net, someone else will have to guide you with, but I'd check the firewall rules first ... Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ 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] UVPE linux setup
Thanks - that did it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: December 14, 2009 04:12 PM To: U2 Users List Subject: Re: [U2] UVPE linux setup You need to configure and turn on the Unirpc daemon too: See the Universe Administration PDF under Managing Network Services Administering the UniRPC on Unix System u2ug wrote: Thanks jeff - I got telnet working ok - uo.net is still a problem -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: December 14, 2009 03:26 PM To: U2 Users List Subject: Re: [U2] UVPE linux setup Universe for Linux does not install its own telnet server like the Windows version does. Make sure your Linux telnet daemon is running. u2ug wrote: I have just setup uvpe 10.3.3 on opensuse 11.1 Locally universe seems to be running fine. However I can't access it via telnet or UO.NET either local or remote. I must have missed something in the installation guide - how do we configure uvpe on linux to accept connections via telnet uo.net ? Gerry ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Uniobjects and login paragraph
Did I see that someone said Uniobjects bypasses the login paragraph? What else bypasses the login paragraph? Is this on both 'nix and Windows? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uniobjects and login paragraph
Not true - phantoms execute the login paragraph - in which case you have to have the logic in your PA to skip the menu for phantom processes. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: December 10, 2009 11:44 AM To: 'U2 Users List' Subject: Re: [U2] Uniobjects and login paragraph Jerry Anything that can't be interactive. If that were not the case, and you started e.g. a menu system from your LOGIN paragraph, it would try to run that whenever you logged in through UniObjects and you would be stuffed. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 10 December 2009 4:38 PM To: 'U2 Users List' Subject: [U2] Uniobjects and login paragraph Did I see that someone said Uniobjects bypasses the login paragraph? What else bypasses the login paragraph? Is this on both 'nix and Windows? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.709 / Virus Database: 270.14.101/2555 - Release Date: 12/09/09 19:41:00 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV Transaction logging
If you have transaction logging turned on in UniVerse do all changes get logged even those that don't have the code in the programs to start the transaction and commit it? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mapping files.
You also have to have Allownfs set to 1 in your configuration and permissions set on the other server so you can use the file. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Paul Parkinson Sent: Monday, November 30, 2009 9:58 AM To: 'U2 Users List' Subject: Re: [U2] Mapping files. Thanks Mas, tried that didn't work Kind Regards Paul Parkinson Director, Ideal Business Services Ltd mob: +1 758 721 4487 (Caribbean) skype: 0161 408 2098 eml: pparkin...@idealnet.co.uk -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mats Carlid Sent: 30 November 2009 11:46 To: U2 Users List Subject: Re: [U2] Mapping files. Mount \\serverB\unidata as disk Z say and make the voc entry: F Z:filenamn Z:D_filename BUT there is a real gotcha: Don't even think about updating that file from server A as there's no common lock mechanism. -- mats Paul Parkinson skrev: I have 2 servers both running Unidata 7.1 on Windows 2003. In an application on server A I want to access data held in an application on server B I have tried the voc entry in the application on serverA 001: F 002: \\serverB\unidata\filename file:///\\serverB\unidata\filename 003: \\serverB\unidata\D_filename file:///\\serverB\unidata\D_filename I have also tried replacing serverB in the above with the IP address But I get the error open file error no such file. Anyone know what I should be doing? Paul Parkinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Coverage Project
It won't be used by programmers but would by QC/QA types to check and see if the code is being used or is just a bunch of fluff. One good example would be if your company is using outsourcing to do your programming and the outsource is getting paid on the amount of code they produce, instead of the correct way of getting paid on the quality of their code. You can check to see if all paths through the code are being used or not. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, November 27, 2009 10:47 AM To: 'U2 Users List' Subject: Re: [U2] Code Coverage Project Dan, Although I missed code coverage in programming school, I'm not sure how much UniBasic programmers would or could use code coverage. That being said, why not take an existing program that is fully developed and change the syntax to handle basic syntax. This way you do not have to develop the entire infastracture to run this tool. My suggestion is there are several open source plug-in for Eclipse that can be modified to handle code coverage. There are several examples like jcoverage or gcov that could be used for this type of project. Regards, Doug www.u2logic.com Native U2 drivers for PHP -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, November 26, 2009 2:35 PM To: U2 Users List Subject: [U2] Code Coverage Project Hi all, For those that are interested, I have setup a project on SourceForge for a Statement Level Code Coverage Tool for UniBasic. It is based on the prototype for a similar tool we now use at my current employer. Although this version is incomplete, it still enables statement level coverage for multiple programs/subroutine with html output. The parser (I really shouldn't use that term) is still quite primitive in this version and may not work with how some programs are coded. http://sourceforge.net/projects/ucov/ For a screen shot of the output and a short post about it, visit: http://u2tech.wordpress.com/ Regards, Dan ___ 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] [UV] Where is the COMMON block reserved ?
In the first example the common is declared in program 1 and can be used in both program 1 and the called subroutine program 2. In the second example the common is declared only when the second program is called and can only be used by the second program, and any programs called from it. In this case program 1 doesn't know of the common at all. It doesn't matter if you are using connection pooling. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Thursday, November 19, 2009 2:02 PM To: U2 Users List Subject: Re: [U2] [UV] Where is the COMMON block reserved ? Hello, I have a question pertaining to how the shell used by the connection pooling works as it relates to memory allocation. In the following cases: Case 1: Program 1 has a number of variables and matrixes declared in a common section it calls Program 2 which has the same common matrixes and variables declared. Ex: Program 1: COM ABC(100), D,E,F ARG = BLAH CALL PGM2(ARG) Program 2: SUBROUTINE PGM2(ARG) COM ABC(100), D, E,F CRT ARG RETURN Case 2: Program1 doesn't have any common variables declared it calls Program2 which does have common matrixes and variables declared: Program 1: ARG = BLAH CALL PGM2(ARG) Program 2: SUBROUTINE PGM2(ARG) COM ABC(100), D, E,F CRT ARG RETURN In Case 2, is the common block declared in the stack segment or will the common be declared in the same place in both cases ? ___ 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] Unidata odd error
I can't speak for Unidata but with UniVerse there was no problem going from Solaris to Red Hat. We went to it 4 years ago and I did it on a Saturday. I set up the printers and themaster account ahead of time. 99% of the commands are identical, I think the only problems I had were with the cp and rm commands having an extra switch. If you don't use any of the operating system commands you won't have any problems. Unlike going to Windows the spooler is the same and cups is easy to use. If you are moving from a RISC system to INTEL you have to run fnuxi on the accounts if you don't use backup and restore utilities. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor Sent: Monday, November 16, 2009 8:10 AM To: Jeff Butera; U2 Users List Subject: Re: [U2] Unidata odd error We will be doing the same move next year. Please let us know how the process went, any gotcha's, etc. I've already tested once and did not have any problems with compiling and running the application. Didn't test printing, so I'm a little worried about that. Jeff Butera jbut...@hampshire.edu 11/14/2009 6:47 PM I have a question for you. Why are you moving to RedHat from Solaris? Do you think that Redhat is a better o/s? We run everything else on linux here, the Solaris boxes for unidata are the oddballs. Also, when you compare hardware costs (even with .EDU pricing from Sun) it's a no brainer to move. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] printing html documents
If your html files are in a type 19 file and the location on your network is reachable from your pc, you can kick off the IE browser from Accuterm sending the path of the file and it will pop up like the wed editor. Then you can print it or view it. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Friday, November 13, 2009 12:56 PM To: U2 Users List Subject: Re: [U2] [UV] printing html documents Thanks everyone for your suggestions, I will try them all out! BTW, I'm using Accuterm on linux. -Dianne Dianne Ackerman wrote: I have some documents that were created by users using html editors (different kinds) which then were saved into uv files. I want to read in these documents from within a basic program and send them to the printer, all nicely formatted. Any ideas? The reason I'm doing it from basic is because I have a lot of other data that I'm working with also, the html files are just a small part of it. Thanks. -Dianne ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Agile and Scrum
http://www.agilegamedevelopment.com/2007/12/pair-programming.html XP Development Jerry Banker ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program - to extract data from Table
Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 22:54 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table If you are going to go that far with the minutia then why not just type it in and get done with it? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 2:09 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Actually for many it is mass produced. Specification is being done to the absolute minutia, for example in the Unified Rational process, when generating use cases these get transmitted down to the architectural specifications and become the actual classes in the code (there is even software to build such skeleton code), with each method and property defined, again this is then used by the test plan to test each class/method/property etc. The coder kind of just fills in the gaps. In my previous employment we had whole teams of BA's, DBA's, System Architects, UI Designers, UX analysts etc, Then a bunch of people in the Philipines to do exactly as was written down in front of them. This kind of scenario happens a lot in larger projects. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 18:00 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer
Re: [U2] Unibasic: Sample program - to extract data from Table
Documenting the program or application is always a good idea, it also helps if changes to the programs are documented, but having to write the specs to the smallest minutia is overkill. Unless, you are writing the specs for someone else that doesn't know your business or the next person in line shouldn't be in the position to start with. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Wednesday, October 14, 2009 11:35 AM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table John, I agree that listening to the super users is critical. However, writing a detailed spec will give those super users the ability to review the spec, add their 'second thoughts' (and the wow, this is really cool - could it also do this? ideas before the files are designed and the code written, and really does not take a lot of time. It ensures that the coding team all understand all the aspects of the project the same way. So even with super users, I always waited for a sign-off on the detailed spec before laying out the files and writing the code. I had clients that I worked with for years, and knew their business very well, but taking the time to write a detailed spec was never a waste of my time. I am glad for you that your system works well, but I hope I never have to come in after you all retire! ;-) Susan Lynch - Original Message - From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: 10/14/2009 12:14 PM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table You cannot buy knowledge of a business. Experience with a technology: yes. Knowledge of how a specific company works: no. That only comes with time working at that site. A key to our success is having super-users that really know how the business works, how the software works, and the ability to clearly describe how they want things enhanced. The other half of this coin is having programmer/analysts that understand what the user wants, where the data is stored (or will need to be stored), who ask the right questions, and can work with those super-users. Our users are very happy with what we produce. We have a small U2 team, but a well seasoned team. I rarely have specs and never very detailed. It is all screen shots with hand written notes that come from a meeting or two with the super-users. Requests from non-super-users must go through the super-users. It is my job to understand what they want (which is usually, but not always what they ask for). However, not every business will have these conditions. Contractors have it even tougher since they may have little knowledge of the business they are trying to help. Just my experience... John Israel -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Wednesday, October 14, 2009 12:00 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table As a programmer who has had to maintain and enhance systems that were written apparently based on a one-page spec that everyone on the team understood, when the team members are no longer there, and the documentation was all between their ears (and left with them), I am a big believer in detailed written specs that get turned into test plans and then into documentation. Eventually the lack of specs turns around and bites the organization that allowed it to happen (unless the application was a one-time quick-and-dirty project that will never have to be resurrected). Susan Lynch - Original Message - From: jpb-u2ug jpb-u...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: 10/14/2009 8:18 AM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. ___ U2-Users mailing list
Re: [U2] Unibasic: Sample program - to extract data from Table
I don't think anyone was questioning Jay's intelligence. He is probably a very intelligent person or he would not have been hired. What is in question is the intelligence of the individuals that hired the firm he works for and the intelligence of the people that gave him the work to do without first of having him trained on it. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor Sent: Tuesday, October 13, 2009 8:26 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Excellent points. In my personal experience, I've had terrible dealings with overseas firms. On the flip side, the sharpest person I've ever worked with was from New Delhi. Getting back to the point at hand, I believe that Pick Systems had some development work done in Russia, during the early 90's. I remember their work as being very good and remarkably bug-free. (Of course, I also drank a lot during those days, so my memory may not be that good.) Now,all of a sudden, at the same time that Rocket Software picks up U2, we start getting questions from rsystems in India. Naturally, I wondered if Rocket Software was the company that hired them. Probably not, but I'm still curious. Larry Hiscock lar...@wcs-corp.com 10/12/2009 5:09 PM Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program - to extract data from Table
I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program - to extract data from Table
If you are going to go that far with the minutia then why not just type it in and get done with it? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 2:09 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Actually for many it is mass produced. Specification is being done to the absolute minutia, for example in the Unified Rational process, when generating use cases these get transmitted down to the architectural specifications and become the actual classes in the code (there is even software to build such skeleton code), with each method and property defined, again this is then used by the test plan to test each class/method/property etc. The coder kind of just fills in the gaps. In my previous employment we had whole teams of BA's, DBA's, System Architects, UI Designers, UX analysts etc, Then a bunch of people in the Philipines to do exactly as was written down in front of them. This kind of scenario happens a lot in larger projects. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 18:00 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2
Re: [U2] U2 is now Rocket U2
Prime Information Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: Monday, October 12, 2009 3:32 PM To: U2 Users List Subject: Re: [U2] U2 is now Rocket U2 Love the U2-rocket story, Dominic. I don't know if there is any U2 in Russia or related countries, but I understand that some PICK or PICK-a-like system was used to track Russian spies in the US, perhaps all the way to the end of the cold war. If anyone has details on that, such as which MV flavor it was (something I might have known at one time), I'd be interested. [And, yes, I know, I know, I shouldn't be on this list--it should move over to U2C, but ...] Cheers! --dawn -- Dawn M. Wolthuis Take and give some delight today On Mon, Oct 12, 2009 at 2:36 PM, Dominic Baron dominic.ba...@publictrust.co.nz wrote: Yes, I also like U2. It has interesting historical associations, for those of us of a certain age. It was a U2 spy-plane that was shot down by a rocket over the USSR in 1960 that led to quite a frosty first meeting between Khruschev and Kennedy in Geneva that year. Which leads me to ask if anyone knows whether any U2 (DB's of course) installations exist in Russia or in any of the former Soviet Republics? Dominic Baron. ___ 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] U2 is now Rocket U2
This all depends, if I am reading it correctly, their other products are being advertised until their original names and Rocket is more in the background. So they may advertise the U2 products under a completely different name. What would you like the name to be? Maybe Rocket would like some input on this point. After all we created the term U2 and IBM adopted it. Now, I think we should drop the U2 brand, since a lot of people think we are talking about the rock group, for a more 21st century name. Also we have got to stop calling them Pick databases. Multi-dimensional, multi-valued and extended relational are okay but maybe we can come up with a more futuristic name than that. How about Rocket or the users group starting up a contest to name the new division? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Smith, Robert Sent: Friday, October 09, 2009 8:24 AM To: U2 Users List Subject: Re: [U2] U2 is now Rocket U2 At some point, we will hopefully evolve beyond the old = undesirable mentality that is pervasive in our society, and once again appreciate the imagery that old things can evoke. As a technician with over thirty years experience, I have thoroughly enjoyed the journey I have witnessed since the days of the LP Player...to the iPod of today. What we largely lack today is a sense of history relative to what it has taken for us to progress to this point...and the imagination to achieve even more phenomenal accomplishments in the future. Where once our thoughts were expansive and limitless, they are now reserved and pedestrian. If someone with a sense of history and a determination to use Rocket as a means to evoke the imagery of a time when we thought in grander scales...then they were sadly mistaken. The company should seriously consider changing its name, otherwise they will be the butt of many a jokes. My two cents Rob -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of inquieti Sent: Friday, October 09, 2009 5:03 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 is now Rocket U2 IBM is very sixties also. Have you ever been to the Apollo space centre? All the computers were IBM and the IBM logo is splashed all around the control room. So I think if you're thinking retro then IBM sits there right along side Sputnik et al. Jacques G. wrote: I wonder what is the marketing idea behind the name Rocket ? To me it invokes late 1950 - 1960's Sputnik/Apollo technology to an epoch when cars designs were made to look like rockets, when there was a hockey player nicknamed Maurice The Rocket Richard and people watched Flash Gordon on a black and white television. When I hear Rocket I think retro like a LP Player, a typewriter, a PDP-1. Wouldn't one want a software product to sound more state of the art ? Sci-fi hasn't used the term Rocketship in decades. Jacques ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://www.nabble.com/U2-is-now-Rocket-U2-tp25693358p25817827.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] hpux to linux; Solaris 2.6 to Solaris 10
A company decision to make everything Microsoft. -- From: Jeff Powell j...@powellclan.com Sent: Wednesday, October 07, 2009 1:25 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] hpux to linux; Solaris 2.6 to Solaris 10 Just out of curiosity, why are you moving to windows? Are there specific benefits? Thanks. On 10/07/2009 10:55 AM, jpb-u2ug wrote: We have moved from Unix V5 on Motorola, to Solaris 2.6, to Solaris 8, to RH Linux AS3, and are now in the process of moving to Windows 2008. ___ 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] [U2C] what's in a (rocket) name?
Yes, but it may not be all that bad for Universe, you can Take a Rocket to the Universe! But, that doesn't work for Unidata. Jerry Banker -Original Message- From: u2-community-boun...@listserver.u2ug.org [mailto:u2-community-boun...@listserver.u2ug.org] On Behalf Of Results Sent: Saturday, September 19, 2009 11:45 AM To: U2 Users Community Subject: Re: [U2C] what's in a (rocket) name? Allen, I love it... I have it on good authority that the U2 brand (however it is branded) will probably not have Rocket anywhere in then name. So, all, the field is wide open: What would you name the U2 company if you were in charge? - Chuck I Would Name It Chuck Barouch Allen E. Elwood wrote: A LOT! Lets just hope nobody gets acronym crazy and decides to call U2 programs Software Hardware Intelligence Packet Streams Because then we'd have ROCKETSHIPS instead of programs Although, to compete with SQL U2 needs a name boost. Studies show that audiences respond more favorably to names with Q's and X's So, perhaps 'Rocket X2' or 'Rocket XQL' would be a better name than U2??? And of course 'Rocket Extreme' might make it more appealing to youngsters entering college. :-) ___ U2-Community mailing list u2-commun...@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-community No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.107/2382 - Release Date: 09/19/09 06:03:00 ___ U2-Community mailing list u2-commun...@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-community ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing
I just tried it on 10.2.4 or UV and it works! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: Monday, September 14, 2009 8:55 PM To: 'U2 Users List' Subject: Re: [U2] Indexing Yes indeed, however it was removed. Hopefully, it will reappear. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Monday, September 14, 2009 4:26 PM To: U2 Users List Subject: Re: [U2] Indexing I seem to recall that they added the CONCURRENT option to BUILD.INDEX several years back but didn't document it except in the patch file for that release. Does anyone else remember this? Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Sep 9, 2009, at 2:43 , Dan Fitzgerald wrote: Building indices means exclusive locks on the file, i.e., downtime. The good news is that the builds are usually very quick. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] FW: Running a test program and getting an error
Forwarding for one of our .NET developers. Have you got an answer? Jerry Banker Running the test program below and getting an error. Any idea's? C:\Program Files\IBM\SQLLIB\BINtestconn20.exe Database=AACSQL;UserID=swd;Server =linux2;Pooling=False;ServerType=UniVerse Step 1: Printing version info .NET Framework version: 2.0.50727.4016 DB2 .NET provider version: 9.0.0.2 DB2 .NET file version: 9.5.4.2 Capability bits: ALLDEFINED Build: 20090430 Factory for invariant name IBM.Data.DB2 verified Factory for invariant name IBM.Data.Informix verified IDS.NET from DbFactory is Common IDS.NET VSAI assembly version: 9.1.0.0 VSAI file version: 9.5.2.157 ERROR - VSAI file version different from DB2 .NET provider Elapsed: 0.2028169 Step 2: Connecting using Database=AACSQL;UserID=swd;Server=linux2;Pooling=False ;ServerType=UniVerse ERROR [Env_CreateConnection] [IBM U2][UCINET][UNIVERSE]:Failure to logi n as remote user. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Running a test program and getting an error
Hum, oh yeah, that's the ticket, removed it from the line. :-) I've got to start reading what they send me. Good thing that system is our development system on a separate network. I think you were right. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of br...@brianleach.co.uk Sent: Thursday, September 10, 2009 8:39 AM To: U2 Users List Subject: Re: [U2] FW: Running a test program and getting an error Jerry Well, let's deal with the obvious one first - I assume they did also specify the password and you've removed it for the reason of not dumping passwords on to the list? Brian On 10 September 2009 at 15:25 jpb-u2ug jpb-u...@hotmail.com wrote: Forwarding for one of our .NET developers. Have you got an answer? Jerry Banker Running the test program below and getting an error. Any idea's? C:\Program Files\IBM\SQLLIB\BINtestconn20.exe Database=AACSQL;UserID=swd;Server =linux2;Pooling=False;ServerType=UniVerse Step 1: Printing version info .NET Framework version: 2.0.50727.4016 DB2 .NET provider version: 9.0.0.2 DB2 .NET file version: 9.5.4.2 Capability bits: ALLDEFINED Build: 20090430 Factory for invariant name IBM.Data.DB2 verified Factory for invariant name IBM.Data.Informix verified IDS.NET from DbFactory is Common IDS.NET VSAI assembly version: 9.1.0.0 VSAI file version: 9.5.2.157 ERROR - VSAI file version different from DB2 .NET provider Elapsed: 0.2028169 Step 2: Connecting using Database=AACSQL;UserID=swd;Server=linux2;Pooling=False ;ServerType=UniVerse ERROR [Env_CreateConnection] [IBM U2][UCINET][UNIVERSE]:Failure to logi n as remote user. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Hmmmm...Learn something new every day!
You can tell it's Friday :-) Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steven M Wagner Sent: Friday, September 04, 2009 3:56 PM To: U2 Users List Subject: Re: [U2] H...Learn something new every day! And a fine PERFORMance you are providing us. . . . . -- Sent from my Palm Pre George Gallen wrote: I wonder if you use EXECUTE without any CLAUSES, the compiler converts it to a PERFORM? sounds like I'm anti-Santa hereEXECUTING CLAUSES! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, September 04, 2009 4:33 PM To: U2 Users List Subject: Re: [U2] H...Learn something new every day! But the question is, why does removing the CAPTURING CLAUSE fix the problem (allow passing the data). with the CAPTURING, user0 won't pass without the CAPTURING, user0 passes fine I thought PERFORM and EXECUTE were the same? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Friday, September 04, 2009 4:30 PM To: U2 Users List Subject: Re: [U2] H...Learn something new every day! EXECUTE creates a new environment, try PERFORM. From BASIC Help: EXECUTE creates a new environment for the executed command. This new environment is initialized with the values of the current prompt, current printer state, Break key counter, the values of in-line prompts, KEYEDITs, KEYTRAPs, and KEYEXITs. If any of these values change in the new environment, the changes are not passed back to the calling environment. In the new environment, stacked @variables are either initialized to 0 or set to reflect the new environment. Nonstacked @variables are shared between the EXECUTE and calling environments. Tom ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] back to the socket problem....
I did this once and ran into the same issue and came up with a scheme using pipes. The server process handles all incoming requests and starts up a phantom to actually handle each request. The server and the phantom process communicate via pipes. The server then does a round-robin polling for data to be moved between pipes connections and vice versa. I am not sure how many concurrent connections this could handle before things started to crawl. But typically the requests were simple one request packet one response packet and finished. There was also some phantom/pipe pooling involved to cut down on the phantom startup and pipe creation overhead. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: August 28, 2009 09:53 AM To: U2 Users List Subject: Re: [U2] back to the socket problem The problem at hand is that you can't pass the client handle obtained from the accept() onto another process, then go back and wait for another connection. If you fire off a phantom, it's a new Process, and isn't able to receive the handle from the other process. Any suggestions? I considered the method of returning a new port number and having the client reconnect on that port, but I'm not ready to go that route just yet. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Glen Batchelor Sent: Thursday, August 27, 2009 5:50 PM To: 'U2 Users List' Subject: Re: [U2] back to the socket problem It appears that you are stacking instances of Program A on top of each other when you should be starting a client socket handler instead. The listen() socket function uses a single server socket handle to wait for all connections and then accept() creates one new socket handle for each incoming connection. You need to pass the client handle to another process and let it do its own thing for that one connection. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] What ever happened...
Whatever happened to the Toucan? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users