Re: [U2] REPLICATING DATA
Andrea - are you wanting to replicate for the purposes of having a warm backup as DR solution, or for reporting from, or some (what) other purpose? This question will dictate the strategy and what tools to employ. We copied the entire db every night to a hot system for Business Analysis. That was put in place before EDA was available. You could spend a lot of resources and time cobbling a 'replication solution' into place, while trying to dodge an upgrade... and perhaps spend more and have less satisfactory results than proceeding with standard methodology (upgrade to get the new toolset). HTH. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ard956 Sent: Tuesday, September 03, 2013 11:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] REPLICATING DATA Does anyone do replication with a tool outside of the U2 toolbox? We are on UV 10.2.10 which does not support UV replication. We have no plans to upgrade at this time but need a backup for our Universe server. Our database is about 180GB. Thank you, Andrea Dente Taylored Services Sent from my iPad ___ 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] 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
Re: [U2] Levenshtein's distance algorithm
Thanks George. Looks like a very workable starting point. Thank you. -Baker x3598 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Hammerle Sent: Wednesday, April 17, 2013 2:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Levenshtein's distance algorithm I got this from some other pick source and modified it a bit. *PROGRAM.TYPEUTILITY/PROGRAM.TYPELANGUAGE.CONVERTNO/LANGUAGE.CONVERTROLL.TO.DEAD.CODENO/ROLL.TO.DEAD.CODE $BASICTYPE 'U' SUBROUTINE GBH.STRING.DISTANCES( SOURCE.STRING, TARGET.STRING, CASE.INSENSITIVE, DISTANCE, MISC.IN.OUT, ERROR.MSG ) *com- * Written By : George HammerleDate : * * Purpose : Determine the number of permutations needed to make the source * string match the target string. A permutation may be a * substitution, addition, or deletion of a character. This * programs uses Levenshtein's distance algorithm for string * comparisons. * * Send In : SOURCE.STRING *TARGET.STRING *CASE.INSENSITIVE1 or 0 *MISC.IN.OUT - future use * * Send Out : DISTANCE *MISC.IN.OUT - future use *ERROR.MSG * * Modifications : * */com MISC.IN.OUT = '' ERROR.MSG = '' TESTING = 0 IF @LOGNAME = 'zhammerl' THEN TESTING = 1 END IF TESTING THEN CASE.INSENSITIVE = 1 SOURCE.STRING = GUMBO TARGET.STRING = GUMBO TARGET.STRING = xyz TARGET.STRING = 'OBMUG' TARGET.STRING = GAMBOL TARGET.STRING = 'gumbo' TARGET.STRING = 'gambol' END IF CASE.INSENSITIVE THEN SOURCE.STRING = UPCASE(SOURCE.STRING) TARGET.STRING = UPCASE(TARGET.STRING) END IF SOURCE.STRING = TARGET.STRING THEN DISTANCE = 0 RETURN END LEN.SOURCE = LEN(SOURCE.STRING) LEN.TARGET = LEN(TARGET.STRING) IF LEN.SOURCE = 0 THEN DISTANCE = LEN.TARGET RETURN END IF LEN.TARGET = 0 THEN DISTANCE = LEN.SOURCE RETURN END TABLE = '' FOR SS = 1 TO LEN.SOURCE + 1 TABLESS,1 = SS-1 NEXT SS FOR TT= 1 TO LEN.TARGET + 1 TABLE1,TT = TT-1 NEXT TT FOR SS = 2 TO LEN.SOURCE + 1 SOURCE.CHAR = SOURCE.STRING[SS-1,1] FOR TT = 2 TO LEN.TARGET + 1 TARGET.CHAR = TARGET.STRING[TT-1,1] IF SOURCE.CHAR = TARGET.CHAR THEN COST = 0 END ELSE COST = 1 END MINIMUM.OF = TABLE(SS-1),TT + 1 IF (TABLESS,(TT-1) + 1) MINIMUM.OF THEN MINIMUM.OF = TABLESS,(TT-1) + 1 END IF (TABLE(SS-1),(TT-1) + COST ) MINIMUM.OF THEN MINIMUM.OF = TABLE(SS-1),(TT-1) + COST END TABLESS,TT = MINIMUM.OF NEXT SS NEXT TT DISTANCE = TABLELEN.SOURCE + 1,LEN.TARGET + 1 IF TESTING THEN CRT SOURCE.STRING = :SOURCE.STRING CRT TARGET.STRING = :TARGET.STRING FOR TT = 1 TO LEN.TARGET + 1 FOR SS = 1 TO LEN.SOURCE + 1 CRT TABLESS,TT: : NEXT SS CRT NEXT TT CRT CRT DISTANCE = :DISTANCE CRT - DISTANCE indicates the number of substitutions, deletions or additions CRT required to make the source and target string match. END RETURN *com-- *- G O S U B S - */com- George Hammerle Programming Dude Hubert Company LLC. 9555 Dry Fork Road Harrison, Ohio 45030 513-367-8974 zhammerle@hubertREMOVE_THIS.com This e-mail and any files transmitted with it are confidential and intended solely for the use of the individual or company to whom they are addressed. If you have received this e-mail in error, please notify the sender immediately and delete this e-mail including all attachments from your system. Thank you ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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
Re: [U2] Any code share for Levenshtein distance
Thanks Jeff. I saw the wikibook and even scrolled through the examples but somehow missed the PickBasic example. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, April 17, 2013 1:19 PM To: U2 Users List Subject: Re: [U2] Any code share for Levenshtein distance Proper attribution: http://en.wikibooks.org/wiki/Algorithm_Implementation/Strings/Levenshtein_distance#Pick_Basic Wjhonson wrote: Note my link is to the page's ARCHIVE, which has about 20 different examples of code in various languages One of those should be better to trans into Pick BASIC, than the others. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Wed, Apr 17, 2013 10:52 am Subject: Re: [U2] Any code share for Levenshtein distance http://en.wikipedia.org/w/index.php?title=Levenshtein_distanceoldid=6 3073322 -Original Message- From: Baker Hughes baker.hug...@mouser.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Wed, Apr 17, 2013 10:39 am Subject: [U2] Any code share for Levenshtein distance Hi, Does anyone have any Basic code that implements the algorithm, Levenshtein distance? We are playing with words for a fraud detection project, trying discover bad guys better. TIA, -Baker Thanks for all the good discussions - I'm lurking and reading now and then. Others usually provide splendid answers. This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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
Re: [U2] Any code share for Levenshtein distance
Thanks for those insights Dan. Yes this is a serious matter due to increa$ing fraud activity. I saw the D-L variant on the wiki page and will take a look at that. We are currently using a metaphone and not very pleased but will look at the dbl metaphone. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Wednesday, April 17, 2013 2:58 PM To: U2 Users List Subject: Re: [U2] Any code share for Levenshtein distance If this is something you take seriously, there are several other techniques you should use in conjunction with Levenshtein (I've done work in this area before). The first 3 you should also look at acronym and abbreviation matching (eg, UK = United Kingdom, abbr = abbreviation) as well as some variant on phonetic matching (such as Double MetaPhone http://aspell.net/metaphone/dmetaph.cpp) Do also look at the Damerau-Levenshtein variant as it is better suited catching intentional misspellings. Regards, Dan -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 11:39 AM 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.16 Multiple Active Select Lists
Can you use SELECT yourfile WITH whatever TO 8 {specific list number} in the master process, and let your SUBR virtual field default to list 0 {zero}? The other option could be to do a READLIST within the SUBR function and reset the list when RETURNing, but this could be onerous in terms of processing speed. HTH -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, September 24, 2012 11:43 AM To: U2 Users List Subject: [U2] Unidata 7.1.16 Multiple Active Select Lists How does one manage multiple active select lists in Unidata? I could have sworn I've done this before, but for some reason it's not working at all as I recall. I have this SUBR(..) type field in file A that selects records from file B to calculate an aggregate. This works fine when listing file A and showing the field. However, if there's an active select list when file A is listed with this field, the select statement in my SUBR(..) is consuming the active select list 0 and returning incorrect results. My subroutine is $BASICTYPE U and is selecting records using the lower case select and selecting to active list #3. It then processes from list #3 and returns its result. I've tried using the RTNLIST and PASSLIST options on the EXECUTE statements and I get a Misuse of Reserved Word 'PASSLIST' or Misuse of Reserved Word 'RTNLIST'. I've tried UDTEXECUTE with no compilation errors but also no improvement on the problem. I've even tried MDPERFORM but I get the misuse errors with the RTNLIST and PASSLIST options. Oddly enough, removing $BASICTYPE U I don't get an error on MDPERFORM but I can't READNEXT from a numbered select without the $BASICTYPE U. How should I structure this SUBR(..) so that it does not consume list 0 when selecting to list 3? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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
Re: [U2] Multi-value explode in AE
From inside the AE editor, HELP VE for value edits. *--: HELP VE Concept: value.edits (ve) Commands: ListValues (LV), KeepValues (KV), ListKeptValues (LKV), InsertValue (IV), ReplaceValue (RV), DeleteValue (DV), EditValues (EV), EditSubValues (ESV), ChangetoValues (CV), ChangetoWords (CW) Wonderful help feature; reduces traffic on this channel. ;-) Thank you. -Baker 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
Re: [U2] Including Code - A Best Practice?
I want to thank each contributor to this thread for the reasoned and professional responses. As always, very illuminating and instructive to be a part of this list. Thank you each. -Baker 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
Re: [U2] Including Code - A Best Practice?
David, Could you elaborate a little more on your two positive arguments? Thanks for your insights, and all those shared from others so far. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Wednesday, February 08, 2012 8:21 AM To: 'U2 Users List' Subject: Re: [U2] Including Code - A Best Practice? I don't think using an INCLUDE is bad, but it must be done in the right way. Pros: * It is the fastest way to use reusable code. * It can be debugged just fine if you use the correct compile arguments. Cons: * You must, MUST, address the variable names. I always prefix mine with CODE$NAME where CODE is the prefix I've chosen for my INCLUDE and should be unique for your system. * You must recompile all instances if you want the change to be updated everywhere. * More difficult to edit program logic, unless you have a nice editor that brings in INCLUDES/INSERTS for you automatically. 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 Baker Hughes Sent: Tuesday, February 07, 2012 4:05 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Including Code - A Best Practice? A friendly discussion arose recently among some U2/MV Developers about whether to include code. If any of you have opinions about the positive aspects or negative aspects of this practice, please respond. Should it be adopted as a best practice, or rejected as special situation use only? Many shops probably include long sections of variable assignments, or perhaps globally opened files. This is pretty much accepted everywhere as a good practice. In question here is the insertion of actual code - business logic or screen I/O programs or code snippets. Maybe you know of methods to overcome some of the obvious downsides: unintended reassignment of local variables, difficulty in debugging, others. What are the positive upsides? Performance gains? What is the longest snippet you think should be included, if allowed? What advantage has included code over a CALL or a Function? Reuse. What else? Can the downsides be mitigated satisfactorily to justify the gains? Thanks so much. -Baker 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] Including Code - A Best Practice?
A friendly discussion arose recently among some U2/MV Developers about whether to include code. If any of you have opinions about the positive aspects or negative aspects of this practice, please respond. Should it be adopted as a best practice, or rejected as special situation use only? Many shops probably include long sections of variable assignments, or perhaps globally opened files. This is pretty much accepted everywhere as a good practice. In question here is the insertion of actual code - business logic or screen I/O programs or code snippets. Maybe you know of methods to overcome some of the obvious downsides: unintended reassignment of local variables, difficulty in debugging, others. What are the positive upsides? Performance gains? What is the longest snippet you think should be included, if allowed? What advantage has included code over a CALL or a Function? Reuse. What else? Can the downsides be mitigated satisfactorily to justify the gains? Thanks so much. -Baker 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] MV based Financial GL packages sought
Howdy, I am helping someone come up with a list of multi-value based Financial/General Ledger packages. It would be very appreciated if any of you could send the names, even url's, my way. If giving a pitch for your own package I suppose the customary [ad] should be included in the subject line, or just ping me off-list; either way. TIA, -Baker Baker dot hughes at nospam please mouser dot com 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
Re: [U2] ENCRYPT in Universe
Data At Rest encryption became available with UV 10.2 I believe. We implemented it after that upgrade. If you're asking whether you can INDEX an Encrypted DAR field, I rather doubt it, but have not tried it. I would ping Nic Kesic with this question; perhaps he is listening or has a google alert set for his name. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Curt Stewart Sent: Wednesday, September 21, 2011 11:41 AM To: U2 Users List Subject: Re: [U2] ENCRYPT in Universe DAR = Data At Rest John Thompson jthompson...@gmail.com wrote: Or better yet, what is DAR? On Wed, Sep 21, 2011 at 12:11 PM, Curt Stewart cstew...@tri-sysconsulting.com wrote: Does the DAR data support indexes? And do you know which release DAR became available? Curt Stewart 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
Re: [U2] ENCRYPT in Universe
Hey John, The ENCRYPT uniBasic function is for encrypting something on the fly. Whereas, with Data At Rest encryption, you simply specify which fields in the file, or the whole file itself, to be encrypted, and the database takes care of the encryption/decryption, without any programmer intervention. Before we had DAR going I toyed with the ENCRYPT function. If you want a code snippet that would demonstrate how this works, email me off list. HTH, -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Tuesday, September 20, 2011 8:51 AM To: U2 Users List Subject: Re: [U2] ENCRYPT in Universe I think I am understanding it a little more now. It seems as long as you don't decrypt it or store the keys in an insecure place, you are good to go. You can just compare the encrypted strings to see if a password matches or not. I'm curious though, whats the difference between the actual Encrypted Files features vs. the ENCRYPT function in BASIC? I'm guessing you might use encrypted files if you are doing something like credit cards? 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
Re: [U2] [UV] Adding a multi-value using SQL UPDATE
Perry, Using the AE editor, you could create a pre-stored command that will execute in a loop. This assumes that you will append a specific string constant or same numeric value to the same field, in every record. If you need help loading a prestore, then executing in a loop, feel free to tap me off line (unless others want to read or contribute to this thread). Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Tuesday, September 13, 2011 8:27 AM To: U2 Users List Subject: Re: [U2] [UV] Adding a multi-vaue using SQL UPDATE Hrm... no bites?? Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Thursday, September 08, 2011 10:11 AM To: U2 Users List Subject: [U2] [UV] Adding a multi-vaue using SQL UPDATE I have a need to add an additional value to a multi-valued field on a bunch of records. I was hoping I could do this using SQL UPDATE but it appears you have to explicitly list all the muli-values... UPDATE FILE SET MVFIELD = 'FIRST', 'SECOND', 'THIRD', 'THE.NEW.VALUE'; Anyone know of way to append a new value using UPDATE? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ 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
Re: [U2] Eclipse release 3.7 (Indigo)
I agree with Bill. There is value in letting the others on this list know what is available. One of the complaints MV developers are taunted with is that tools/software are not available to work with our systems, which we all know is BravoSierra. If you bracket your [ad] accordingly, then who can complain? Is it most proper to bracket in the subject line? Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, June 23, 2011 8:22 PM To: U2 Users List Subject: Re: [U2] Eclipse release 3.7 (Indigo) G-Man: You __SHOULD__ advertise, as I'd never know what's up without guys like you, Doug, and others letting us know of their offerings. I'm not in the least offended by yours, and others, advertising, as I own a business and understand the need. Remember, if you get too much flack then FTITCTAJ ! :-) Bill 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
Re: [U2] Enterprise Scheduling solution
I wanted to thank those that responded to this thread. Always helpful. Thank you. -Baker 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] Enterprise Scheduling solution
Many MV systems have some kind of home-brewed or even purchased scheduling solution for handling batch processes. Many times, in distribution or manufacturing ERP applications, certain processes such as Aging A/R, or stock replenishment/reserving, is performed 'after hours' by these schedulers. We've all worked with one or perhaps written our own. We have one of these, that gets the job done. Does anyone know of an Enterprise Scheduler solution that can handle jobs across a heterogeneous enterprise, that is also MV or *nix compatible? Rather than try and take our UniVerse based scheduler front end to the next level of perfection, we need a job/phantom/scheduler solution that would allow an Operator with little or no MV knowledge to monitor/adjust/manage jobs across a plethora of different OS-based enterprise applications. The Enterprise Scheduler we are interested in can be MV based, or other DB based, but must have a graphical front end, and must be able to manage jobs on non-MV systems as well as MV systems. Thanks for any ideas. -Baker 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
Re: [U2] Leaving Locks in UOJ
Maybe this is a ticket that should be opened on the BB application, for discussion with Rocket. To get there, login to www.u2ug.net and click on BB link on left toolbar. Just fyi, -Baker David Wolverton ... said... I'm thinking that it's got to be a bug SOMEWHERE if Universe Unix and Universe Windows behave differently. Sounds like a case for Rocket! ... Doug said... We noticed a problem with locks being left when we delete our temporary programs using UniObjects for Java on the new code we are using for XLr8Editor continuous compile. We used the standard setDefaultReleaseStrategy(). This should release the record when it was written or deleted, but some of our users found they were not being released. We are using the current version of UOJ and this happens in Unidata Windows, Universe Unix and not Universe Windows. We have since coded around the problem, of course. However, my question is this: Are we looking a bug or do we not understand the strategy? 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
Re: [U2] Multi-Threading Universe Socket traffic
Does anyone have a good method to 'throttle' the number of child processes? We authorize a few $million per day in CC transactions doing each 'near' real-time auths as the orders arrive. This is single threaded master phantom opening / writing/ reading the socket for each transaction. Works fairly well. Very reliable but not real time enough to hold the customer on the phone till the 'approve' comes back. I've toyed with having the master phantom spawn child phantom processes but need a way to 'throttle' the thread count, and queue anything over a specified threshold. The method I tried, grabbing a 'token' from a control record when the child phantom spawns, and replacing it when the child process concludes does not work. I found that this becomes unworkable after 4 or 5 child phantoms get spawned. They conclude closely enough that the contention over the update lock for the 'tokens' record degrades any performance gain by going multi-threaded. Seems I can get an auth faster than the control record can be locked, updated, and written back. I fully agree with everything David said about logging the pid and have done this also. @nschroth - if you want some code snippets of the socket calls email me off list. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Monday, March 07, 2011 7:04 PM To: 'U2 Users List' Subject: Re: [U2] Multi-Threading Universe Socket traffic I'd agree with this approach...I've used it many times before... A good well thought out design well help you...design first: code second :-) I've in the past done the following: - control program to configure, start/monitor/stop phantom processes - I find writing a phantom process which logs what it is doing/done is used for debugging purposes too (saves guessing what's going) - just remember to have a toggle to turn this on/off for production (to save disk space) - it is important that each phantom logs its progress, its process ID, start, last checkpoint reached and that it has successfully terminated. This helps prevent the case of you accidently firing off 100 phantoms and consuming all your UV licenses, etc. :-) The purpose of this is to: - make the process scalable and tuneable without re-coding via parameter record (include things like operating windows, etc) - have an application to manage the phantoms and monitor what they're doing (or if they're doing anything) - have phantom processes log what they're doing and allow options for a verbose logging mode to log everything they're doing in case of problems Some approaches I've used: a) each phantom could be started with a unique saved list of record keys to processed (generated by a control program or some other process beforehand) b) each phantom can perform its own query (but sleeping for a specified period so not to continuously performing disk I/O) c) Inbound and outbound transaction phantom process - each handles only response or send requests respectively. Such an approach only works if you can reconcile the response with the original request. Very application specific and not generally optimised for throughput. Good luck. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of nschroth Sent: 05 March 2011 16:55 To: u2-users@listserver.u2ug.org Subject: [U2] Multi-Threading Universe Socket traffic On Universe 10.1.14 over AIX 5.3, we currently communicate Credit Card transactions via sockets (ISO-8583) using the following logic (works fine): OPEN.ERR=openSocket(THIS.IP,THIS.PORT,TCP.MODE,TIMEOUT,THIS.HANDLE) INFO.ERR=getSocketInformation(THIS.HANDLE,PEER.FLAG,SOCKETINFO) WRITE.ERR=writeSocket(THIS.HANDLE,SEND.MSG,TIMEOUT,TCP.MODE,SEND.SIZE) READ.ERR=readSocket(THIS.HANDLE,RECV.MSG,RECV.LEN,TIMEOUT,TCP.MODE,RECV.SIZE ) I am looking into using some sort of multi-threading logic to allow increased volume in shorter timeframes. For example, we now send batches of up to 3,000 cards via a ftps mechanism that responds normally within 3-5 minutes. We want to benchmark doing this via the sockets instead. The Subroutine that does this Socket comm takes about 0.7 secs per trx, so a 3,000 card batch would take over 30 minutes single-threaded (unacceptable). Probably 80% of that 0.7 secs is transforming the data to send and then transforming the response back to process. 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.
Re: [U2] how to round to 2 decimals?
Would someone like to submit the DROUND function to the BB for a UV enhancement request? If it is already implemented on UD then it should be fairly easy to justify to add to UV. A short business case should be sufficient. Log into U2UG and then click on BetterandBetter link, it will redirect to the application. Thank you. -Baker U2UG BB workgroup -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: Thursday, October 14, 2010 11:38 AM To: 'U2 Users List' Subject: Re: [U2] how to round to 2 decimals? No idea if it's been implemented in UV ... it appears not, from your error message. It works in UD shrug -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Thursday, October 14, 2010 9:35 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] how to round to 2 decimals? Are you sure DROUND() is a UniVerse function? When I do the following code: X = 2596 * 8.333 * PRINT DROUND(X,2) I get the following error: Array 'DROUND' never dimensioned. From: lar...@wcs-corp.com To: u2-users@listserver.u2ug.org Date: Thu, 14 Oct 2010 09:25:23 -0700 Subject: Re: [U2] how to round to 2 decimals? What's so difficult about ANS = DROUND(N1 * N2, 2) ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 8:59 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi Never heard of the DROUND() function in Universe. Anyway, why would I want to use a function syntax when I can do ANS = N1 * N2 'R2' and it is the answer that gets rounded? Easy to write. Easy to read... John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 14 October 2010 16:49 To: 'U2 Users List' Subject: Re: [U2] how to round to 2 decimals? Does UniVerse not support the DROUND() function? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 1:02 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi I've always used 'R2' e.g. ANS = N1 * N2 'R2' No scaling, just rounding Regards John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 13 October 2010 22:22 To: u2-users@listserver.u2ug.org Subject: [U2] how to round to 2 decimals? I'm trying to figure out how to round to 2 decimal places with a floating point in UniVerse For example 2596 x 8.333 = 21,632.468 How would you round that in UniVerse to 21,632.47? Thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users
[U2] Looking for Glenn
Hey all, Does anyone have an updated email address for Glenn Sallis? I'm trying to follow up on a BB request he entered. I think he changed contracts back in June and I'm not sure how to contact him. TIA, -Baker 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] [UV] Is anyone storing multi-byte names or addresses
Hey, Just wondering how others have approached this - storing multi-byte names and addresses for non-English languages. I don't think we're approaching the demarcation line where an NLS implementation would be warranted, with the Administrative overhead that incurs. We are doing a lot more other language business though since we are opening more and more off-shore call centers, and have deployed multiple non English language websites. Our immediate need just relates to Name, and ship to / bill to addresses, such words as Mosiężno-Żelaznych. Thanks in advance for the always enlightening insights. -Baker 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
Re: [U2] Better and Better Triage Gurus Needed
If I could jump in this thread that Ross started... yes - The BB is a bit shy on bandwidth to handle the enhancement / bug requests that are coming in. There's some pretty fine ideas coming in actually, and we hate to see them slowed down but our day jobs are causing a bit of a drag. If we just had a few (can we get 5, at least 5) more people to donate a bit of their time here and there, many hands make light work and all that. We just sort and refine them before sending on to the fine folks at Rocket. This isn't a huge time commitment but could prove very important to the improvement of the U2 Suite. Thanks for your kind consideration. -Baker Hughes BB Workgroup member Former U2 Board member presid...@texmug.org -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Morrissey Sent: Friday, August 20, 2010 12:31 AM To: u2-users@listserver.u2ug.org Subject: [U2] Better and Better Triage Gurus Needed The U2UG Better and Better Committee receives enhancement requests from the U2 community and attempts to triage them - discarding some because equivalent (occasionally obscure) functionality exists, augmenting some by working with the submitter to clarify and develop a compelling business case, and forwarding some gems directly to Rocket. The problem we have today is that some of the requests are real edge cases dealing with interaction with other technologies and development environments. If you're a guru's guru and think you can be the alpha geek on some compelling conference calls, please swagger forward (i.e. email me at u...@rossmorrissey.com). Curious about Better and Better? Log in to http://www.u2ug.org to learn more. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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
Re: [U2] 24 X 7 MV systems
Nick, Dawn, Tony, David, Glen, John, Jeff, Bill, everyone. Thanks for the posts on this thread. There is good material for me to share with the rest of our team and hopefully overcome inertia and set some new direction. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: Thursday, July 29, 2010 4:53 PM To: U2 Users List Subject: Re: [U2] 24 X 7 MV systems You said MV system rather than something more specific, so I would encourage you to look at Cache'. I think it has the best features in the MV space in this regard (as well as scalability and other ilities). --dawn 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] 24 X 7 MV systems
Hey y'all, I'm interested in hearing from folks who are currently on, or have worked with fault tolerant MV systems. We'd like to host our Business Layer on the MV system and serve It to our e-commerce portals, instead of re-coding our business rules first in Basic, then in .Net In order to get there though we must meet the primary business requirement of zero downtime (not even 2 minutes to manually switch). We're not talking about different levels of Raid - it's assumed the storage array is up and available. If the MV system has a hiccup of more than a few seconds it needs to hot failover to a backup twin sister. Is anyone doing this or something close to it? When I worked in public safety, Stratus sold such an automatic hot failover. I'm sure the EnRoute folks are doing something like this still. Maybe Nick G. or Margaret M. is listening in today. Thanks, -Baker 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
Re: [U2] 24 X 7 MV systems
Glen, Thank you for the good observations, and suggestion to ping Ross, which I will do. It is the MV db paradigm which in this case is hampering us, which drives the solution to either the OS level or some middle ware solution. Pausing the db to flush memory is what keeps us just seconds from a full solution. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glen Batchelor Sent: Monday, July 26, 2010 10:03 AM To: 'U2 Users List' Subject: Re: [U2] 24 X 7 MV systems Hey Stranger, The best way you'll get there is with a transaction/request based redundancy setup. Does U2 have anything that isn't trigger related? Even a block-level DRDB config won't help with databases since transactions in memory aren't committed to disk promptly enough for the replicator to get all of the new data pieces as the fault happens. I've been looking for a remote hosted failover solution myself (not for U2). A truly fault tolerant setup requires that the incoming requests be replicated to multiple machines before anything happens inside. You might think of the user app as a web service consumer that makes requests to a proxy. That proxy mux's the requests to multiple machines, compares all of the responses and then passes back the response of one machine based on failover priority. If one of the responses aren't the same then an error is sent to the admin. Unfortunately, this spits in the eye of MV which is designed to be a stand-alone central data store. Maybe you can do it with your own TCP packets, but if you don't use an encrypted media you may get into security trouble. Web services are horribly bloated, but the security layer is already in there. You should bug Ross Ferris and pick his brain about his DRS product versus other options for U2. DRS supposedly uses a small amount of bandwidth but it isn't encrypted AFAIK. Regards, Glen Batchelor IT Director/CIO/CTO All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com 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
Re: [U2] 24 X 7 MV systems
Jeff, Thank you for giving your experience with HA AIX and a cluster. We are also doing the HA but not clustering. The couple minutes time lag you mention and the possibility of broken transactions make one wonder if it's worth going that distance. I didn't know Stratus was still out there so thanks for that. What about Sequoia? That was also a very coveted system in the 911 offices back in the day. Awesome story about the Sequoia still tooling right along while the disk is on fire. So did the system switch itself over to 'B' or did y'all do it, when? I can't match that one, but even with Reality 7 (sorry to mention this on the U2 list) we could throw a manual switch (took me about 30 seconds to get from my office to the switch in the computer room) and when the dispatchers logged in, there were their sessions with screens looking identical to system A. That's why I gotta believe we can do better, 20 years later. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Monday, July 26, 2010 10:24 AM To: U2 Users List Subject: Re: [U2] 24 X 7 MV systems We are running an IBM high availability cluster of AIX machines which do auto fail-over. There is a couple minutes of time lag involved and there can be broken transactions since the switchover is OS level and not applications based so this is probably not a good solution for you since it sounds like you are looking for a truly fault tolerant solution. Stratus is still out there and probably a good choice for your needs. I know they have at least one series of boxes which run Red Hat and therefore are U2 compatible. I worked on a fault tolerant Sequoia system running Pick OA many years ago supporting an alarm monitoring application. Amazing machines. True Story: The operations manager gets a call from the computer operator who tells him Theres smoke coming out of one of the disk drawers on the Sequoia 'A' system (we had a second redundant Sequoia 'B' system as well). A couple quick phone calls later 5 of us are huddled together in the computer room on various phones with Sequoia after hitting the raid disk drawer in question with a fire extinguisher, trying to decide if we should switch over to the backup system, when out of the little glass cubicle where the operators live comes the operator on duty. He walks up to the smoking system, pulls off a spinning magnetic tape, and mounts the next reel of a file restore he's doing for someone. We all look at each other and laugh because the system is still running along just fine while on fire. Baker Hughes wrote: Hey y'all, I'm interested in hearing from folks who are currently on, or have worked with fault tolerant MV systems. We'd like to host our Business Layer on the MV system and serve It to our e-commerce portals, instead of re-coding our business rules first in Basic, then in .Net In order to get there though we must meet the primary business requirement of zero downtime (not even 2 minutes to manually switch). We're not talking about different levels of Raid - it's assumed the storage array is up and available. If the MV system has a hiccup of more than a few seconds it needs to hot failover to a backup twin sister. Is anyone doing this or something close to it? When I worked in public safety, Stratus sold such an automatic hot failover. I'm sure the EnRoute folks are doing something like this still. Maybe Nick G. or Margaret M. is listening in today. Thanks, -Baker 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 -- 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] Saying Goodbye...
Karl, Like you, I'm not a frequent poster, but I remember your occasional contributions as very useful and enlightening the humor and clarity help. There's an ebb and flow to I.T. and the tool set changes accordingly, so I won't be surprised to see you back later... But regardless ... God speed in your future campaigns. -Baker presid...@texmug.org U2UG past Board member 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] Quick poll - how many use 3-tier or N-tier Architecture
Would those of you mind responding that use 3-Tier or N-Tier architecture - I'm trying to gather some quick numbers for some decision makers (somewhat urgent). Please respond if your site, or sites who you service have UniData, UniVerse, or any other MV db on the backend, and any fully graphical user interface: a. How many have a middle-tier application server? b. How many use IBM Websphere? c. How many use some other? Please give product name if you can. d. How many have a Java front end User Interface? e. How many have a C# front end User Interface? f. How many have other UI? Please give name. For anyone - what Multi-Value aware / friendly middleware products are there? (That don't require data normalization before sending to the middleware.) Thank you so much, -Baker 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
Re: [U2] Pick Pocket Guide
At the risk of stating the obvious, I think the following is the best 'centrist' approach for the common query commands: MVQL - Multi Value Query Language. As for the database resource - it's almost a non-issue any more who the provider is since most have 'flavors' that mimic the major variants. This generic primer would be the documentation that most interests the potential reader. System internals would come later and that would be something that we all obtain from the vendor. Free code is an excellent way to get others to embrace MV. We frequently borough code from PHP or other code sharing sites and cobble it into our basic routine if we're doing something new. If we could get more of this going, and offer the 'pocket guides' there, we'd garner more respect and affection. I know we have a couple wiki's out there - lets improve these and get a generic MV code foundry up. I must express my debt of gratitude to Jon also. He graciously allowed me to republish parts of his work when I taught a Programmers class for clients of Pick Professionals in St Louis. Fascinating thread. I've only read thru 1/2 of it so forgive me if any of my suggestions are redundant. -Baker 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
Re: [U2] Comparing two DIMsnsioned arrays
Dave, This is just the sort of enhancement that users can now suggest/request through the Better and Better workgroup of the U2UG. You could go to the Better and Better website http://109.104.64.69/db/dbweb.asp and enter the request. Bug fixes / enhancement requests are then triaged by the BB workgroup, submitted to Rocket, and then tracked for resolution. If you can add a few sentences about the business case for this (or any) enhancement that will add weight to the request. [Soon we will have a form to capture the business case; for now just put in desc.] U2-Basic has been robust and stable for so long that we tend not to think about enhancements to it but a new feature like you've suggested show us more can be done. -Baker BB workgroup member Perhaps this is something that Rocket would be interested in doing for us dinosaurs? Can you do a MATBUILD to two dynamic arrays, then compare the two dynamic arrays as a workaround? VS looping through the arrays and comparing element to element? 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
Re: [U2] Credit Card info
I think someone made slight reference to logging but this PCI requirement also merits considerable thought. Read the logging requirements imposed by PCI - any access to the sensitive data, viewing or updating cardholder data, must be logged. What's more, the log must be consolidated so that access to any 1 cardholder data 'set' across your enterprise should be combined so it can be viewed holistically. So you're probably facing an export of your UV/UD/MV logs to some tool like loglogic.com to monitor security events. This is a new administrative requirement for users of your software pkg. At minimum some human must consistently scan the logs, or the flagged events, if performed by some forensic tool. Your network - once you store cardholder data on your enterprise, you must now perform due diligence on your network such as penetration testing to insure the network is secure from external or internal intrusions. This involves everything from routers to wireless access points. Hth, -Baker 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] Encryption errors - don't care
The native encryption in UV 10.2 is very nice. But does anyone know the secret to 'turn off' the encryption errors on our development system? We have the development machine setup identical to the live so it serves as a hot backup. We don't have an encryption key loaded though since all sensitive data has been cleansed from the dev db. Is there a way around this: Unable to get encryption info (19690) in ENCINFO. and others like it. Cloudy 50 in Texas regards, -Baker 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
Re: [U2] RECORDLOCKED statement
Thank you Raul. We don't use shared locks so started at -2, but it won't hurt to get them all. Changed made. Thank you. -Baker x3598 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of raul_doming...@neimanmarcus.com Sent: Tuesday, December 15, 2009 5:27 PM To: U2 Users List Subject: Re: [U2] RECORDLOCKED statement The only consideration is that your second case statement picks up at -2 instead of -1. I think you are going for CASE RECORDLOCKED(PICH.TX, SO) = LOCK$OTHER.READL which is the -1 return value. At least according to the UniVerse documentation. Regards, Raul Dominguez raul_doming...@neimanmarcus.com 972-401-6502 Baker Hughes baker.hug...@mouser.com Sent by: u2-users-boun...@listserver.u2ug.org 12/15/2009 05:17 PM Please respond to U2 Users List u2-users@listserver.u2ug.org To 'U2 Users List' u2-users@listserver.u2ug.org cc Subject [U2] RECORDLOCKED statement I admit I have never used this little jewel of a [UV] statement, so although the code runs and works as designed, before I load it to production, someone please tell me if there are any nuances that would improve the design/operation. CASE RECORDLOCKED(PICH.TX, SO) = LOCK$MY.READU * This user/process already has a lock on the record, and we DO NOT * WANT to clear the lock if process is ORDER.UPDATE so check the stack. IF INDEX(SYSTEM(9001),ORDER.UPDATE,1) THEN WRITEVU ON PICH.TX, SO, 37 END ELSE WRITEV ON PICH.TX, SO, 37 RELEASE PICH.TX, SO END CLEARED.CCA.HOLD = TRUE CASE RECORDLOCKED(PICH.TX, SO) = LOCK$OTHER.READU * Another User has the record locked, we cannot update at this time ERR.NUM = 'C043' ERR.MSG = 'PICH.TX RECORD IS LOCKED, TRYING TO CLEAR CREDIT CARD HOLD' DOC.NUM = SO ; DOC.TYP = 'ORDER' ; FILE.NM = 'PICH.TX' GOSUB SEND.ERROR CASE RECORDLOCKED(PICH.TX, SO) = LOCK$NO.LOCK * There is no lock on this record presently, free and clear READVU HOLD.RSN FROM PICH.TX, SO, 37 LOCKED * ...but that could change in 1 ms so still handle the locked condition. ERR.NUM = 'C043' ERR.MSG = 'PICH.TX RECORD IS LOCKED, TRYING TO CLEAR CREDIT CARD HOLD' DOC.NUM = SO ; DOC.TYP = 'ORDER' ; FILE.NM = 'PICH.TX' GOSUB SEND.ERROR RELEASE PICH.TX, SO END THEN WRITEV ON PICH.TX, SO, 37 CLEARED.CCA.HOLD = TRUE END CASE Thank you. -Baker 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
Re: [U2] RECORDLOCKED statement
Thank you Gregor. Good efficiency. Change made. Thank you. -Baker x3598 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Tuesday, December 15, 2009 7:40 PM To: 'U2 Users List' Subject: Re: [U2] RECORDLOCKED statement The other consideration is that each case statement uses the same RECORDLOCKED(PICH.TX, SO) function reference, meaning it runs the function 3 times (according to your snippet). I would normally assign the function result to a variable and test the variable in the case statements: stat.LOCK = RECORDLOCKED(PICH.TX, SO) CASE stat.LOCK = CASE stat.LOCK = ... Gregor Scott 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
Re: [U2] RECORDLOCKED statement
Thanks Brad, good catch. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav Sent: Tuesday, December 15, 2009 9:48 PM To: gregor.sc...@pentanasolutions.com; U2 Users List Subject: Re: [U2] RECORDLOCKED statement Assign the result to a variable: that reduces the i/o to the lock manager by 60%+ Brad 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] RECORDLOCKED statement
I admit I have never used this little jewel of a [UV] statement, so although the code runs and works as designed, before I load it to production, someone please tell me if there are any nuances that would improve the design/operation. CASE RECORDLOCKED(PICH.TX, SO) = LOCK$MY.READU * This user/process already has a lock on the record, and we DO NOT * WANT to clear the lock if process is ORDER.UPDATE so check the stack. IF INDEX(SYSTEM(9001),ORDER.UPDATE,1) THEN WRITEVU ON PICH.TX, SO, 37 END ELSE WRITEV ON PICH.TX, SO, 37 RELEASE PICH.TX, SO END CLEARED.CCA.HOLD = TRUE CASE RECORDLOCKED(PICH.TX, SO) = LOCK$OTHER.READU * Another User has the record locked, we cannot update at this time ERR.NUM = 'C043' ERR.MSG = 'PICH.TX RECORD IS LOCKED, TRYING TO CLEAR CREDIT CARD HOLD' DOC.NUM = SO ; DOC.TYP = 'ORDER' ; FILE.NM = 'PICH.TX' GOSUB SEND.ERROR CASE RECORDLOCKED(PICH.TX, SO) = LOCK$NO.LOCK * There is no lock on this record presently, free and clear READVU HOLD.RSN FROM PICH.TX, SO, 37 LOCKED * ...but that could change in 1 ms so still handle the locked condition. ERR.NUM = 'C043' ERR.MSG = 'PICH.TX RECORD IS LOCKED, TRYING TO CLEAR CREDIT CARD HOLD' DOC.NUM = SO ; DOC.TYP = 'ORDER' ; FILE.NM = 'PICH.TX' GOSUB SEND.ERROR RELEASE PICH.TX, SO END THEN WRITEV ON PICH.TX, SO, 37 CLEARED.CCA.HOLD = TRUE END CASE Thank you. -Baker 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] IBM Certification: CertMag Invitation - Amex Gift Certificate Drawing
Who all else received this invite to take the certification survey? What did you check for your IBM U2 Family Application Certified Solutions Expert? I've carefully scanned the list of options, it is a bit early in the morning, but I'm not finding anything that resembles U2 solutions. Maybe this is an area that we as a community need to work on in the future, in the transition and beyond, a non-proprietary certification model. This has been discussed before so just tuck this away for future consideration, unless you have a new revelation or insight to contribute, let's not pick over old bones. -Baker -Original Message- From: IBM Certification Program [mailto:ibmc...@us.ibm.com] Sent: Tuesday, September 22, 2009 8:31 PM To: Certification Today Subject: IBM Certification: CertMag Invitation - Amex Gift Certificate Drawing MediaTec Publishing conducts an annual in-depth salary survey of Professional Certification across the IT industry. The survey is critical in helping the industry gauge the financial impact of certification. Each year, the analysis of the survey results is published in the December issue of Certification Magazine. All IT Certified Professionals are invited to participate. It should take just a few minutes to complete. Everyone who complete the survey will be entered automatically into a drawing for American Express gift certificates awarded by MediaTec Publishing. Your input is important so that your certification may be included in the final report. As you may think, recognition in Certification Magazine can increase awareness in the value of the certification you hold. Additionally, you may find the results useful in your own career development. Litchfield Group, an independent research firm, collects the survey data and the results are compiled by certified role. All data is confidential. Your anonymous response will be compiled and the aggregate results reported. No personal demographic information is collected other than state and/or country. The survey is currently available on-line and will end on September 25, 2009. Please take a few minutes to complete the survey and be included in the drawing for American Express gift certificates awarded by MediaTec Publishing. You can access the on-line survey from here ( https://www.surveymonkey.com/s.aspx?sm=_2fCbRm50Bf5lx8DdEA9E4uA_3d_3d). You can also link to the survey by selecting the CertMag Salary Survey graphic on the IBM Professional Certification home page ( http://www.ibm.com/certify/). Your IBM Professional Certification Team This email was generated by an automated machine. Please DO NOT REPLY to this email. 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
Re: [U2] u2/rocket/datastage
I Learned yesterday that the Datastage being sold now in no way resembles the UV based Datastage that was. It is actually another product that IBM bought and rebranded as Datastage. The datastage that we all like is still available as U2-Datastage and can be bought for $10k and is the same kernel as IBM bought [back] from Ascential software (which Informix wanted, but IBM didn't want when they 1st bought U2 so they spun it off, but then later decided they did want so went and bought it back ) That said, I expect U2-Datastage (or whatever it will be called when likely re-branded) will go with the U2 assets. Complete conjecture FWIW, -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, September 16, 2009 9:35 AM To: U2 Users List Subject: Re: [U2] u2/rocket/datastage Datastage is not part of U2. There is no comment about it being sold and I doubt if it would. It is a strategic component of their business intelligence stable. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: Thursday, September 17, 2009 12:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] u2/rocket/datastage has anyone heard anything about datastage? Since it uses universe I would think that IBM would of sold it as well ... dougc ___ 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 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
Re: [U2] GOOD NEWS From Susie
Looking at their website, from the number of offices that Rocket has, it looks like they grant some autonomy to the Product/Groups they purchase. This could bode well for Susie and her group if they are given more latitude to do what they need to 'to build a better rocket'. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Results Sent: Tuesday, September 15, 2009 3:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] GOOD NEWS From Susie All, I just got off the phone with Susie Seigesmund. She has assured me that her entire team has been invited to stay together, Rocket didn't just buy the software or the customer list or the channel, they are buying into the people who supported us all along. More news as I have it. Also, watch U2UG.org, as we will be updating teh front page several times in the next few days. - Charles Barouch ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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
Re: [U2] U2 being sold!
I'm banging my cup against the bar for what Tony just said about Susie and her team, Here here !! They've done a dang good job over the years, given the ball field they had to play in. The best news we've heard in all this is that she and her team are staying on. We have to also say that the product offering is still strong as any MV offering out there. None of these things have changed. Maybe the U2UG will have to bring to fruition the plans already laid to increase market share and name recognition, like the learner packs, and incubator projects. Maybe we've each 'come to the kingdom for such a time as this'. We may not like some of the aspects of this, but we can each help shape the outcome. One thing Rocket probably hasn't ever experienced in all their acquisitions - a user community like this one. I trust they will come to understand that this is one of the greatest of the U2 assets they acquired in the deal. We know the U2/MV story, and we have each been telling it longer than IBM. We will teach it to Rocket. Thanks. Have a great day, -Baker Hughes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, September 15, 2009 5:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 being sold! All that said, I think Susie Siegesmund and her team have done a great job within the IBM machine to preserve the platforms and keep them moving forward. My reservations have always been about what IBM wasn't doing for the platform, which isn't related to what it looks like the U2 team have done and have been trying to do. Good luck to everyone on the U2 team making the move. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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
Re: [U2] Better and Better Application - Launching today Friday 8/21/09 -- Browser instructions
Thank you everyone for the intensely helpful insights offered so far in this thread regarding the BB rollout. Let me just say up front that I will take responsibility for an inadequate QA process on this rollout. I thought (wrongly) that we had resolved any browser compatibility issues we had, but we should have done more testing. We are working now to get the BB application into a mode that is compatible with a wide range of browsers. We will do better at testing each one, and even different versions. (Please email me if you're willing to help QA.) I can't express how thankful I am to have worked with a great group of volunteers to get us to this point. This launch (albeit a bit frustrating thus far) has been the [partial] culmination of the vision of several people, as I said in the announcement. We are not done, and you will have a BB application that you can enjoy, and point to as a good example of multi-value technology. That is still one of the primary goals of this project, and we thank you for holding us to a high standard. There have been a wide range of emotions expressed in this thread. What many don't know is the range of emotions and struggles that the BB team has experienced in the 2 or 3 years since inception. Because of the long fight to get to this point, the BB group made the decision to go ahead with the launch, although we knew there was more work to be done to improve the application. It has been a long wait and we felt the most positive thing was to get the application available to the users. We didn't anticipate the browser compatibility issues, but we did expect more suggestions on the application itself. I still believe this was the right decision, to go ahead and launch. The net effect of the discussion about the BB app is positive, because we have actionable items as a result. This has also, I hope, pointed up the need for more involvement from other users. 3 have already volunteered to join BB. We could use more, and other work groups on the U2UG could use more. I want to thank each of you for the [at times lengthy and heated] posts on the thread. I esteem each of you and consider many of you my seniors. Your passion for the technology is in large part what is fueling the success we are experiencing in the MV sector. Don't change. Thanks for your patience as we shepherd this user group application to a satisfying conclusion. Hope this helps, -Baker Hughes U2UG Board member (at large) BB Workgroup member 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
Re: [U2] Better and Better Application - Launching todayFriday 8/21/09 -- Browser instructions
You are now signed up for the BB QA effort. Thanks Glen. You will begin receiving emails from Betterandbetter, but only so you're in the loop on what's going on. I know you're not signing up for the meetings on a regular basis (but you're always welcome). Hey Baker, Sign me up for some QA checks. You can drop an e-mail to me @work or @home with the details. I've got access to a bunch of different browsers. The only condition is that there can't be a tight deadline schedule for QA. I'm sure all of the volunteers work on things as they can and I'm no different. I will have to devote blocks of free time, which may disappear in the near future, in order to fully test things. Funny thing I've noticed about most everyone that's significantly involved in U2UG (or any of the other various boards I work on) most everyone is pretty busy thanks for being willing to add one more skillet to your stove. The surprising thing is that some pretty good things turnout in the end. -Baker 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
Re: [U2] Your shell program
Thanks to each who responded on and off list. -Baker 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] Your shell program
Many programmers have a 'shell program' or two that they use as a starting point when they are writing a new chunk of code. While I also have my own, I like to learn from others. Anyone willing - please post, or respond to me off-list with yours. I'm particularly interested in these forms: a) The BP top most program (as opposed to an external sub) with a Driver Loop or main loop. b) A single function subroutine - straightline with no driver c) A standard input subroutine if you use one, to receive input and validate user response. Thanks so much, -Baker 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
Re: [U2] Performance reports on 4 Terabyte files vs Distributed Files
Thanks Ross and Tony for your insights. -Baker 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] Performance reports on 4 Terabyte files vs Distributed Files
Does anyone have any real life examples of performance gains from converting your large file to 64 bit files? Does anyone have a performance comparison of 64 bit files vs. distributed files. I wonder if a 4 terabyte file responds better/faster than a distributed/part file? SELECTs, WRITES, other access. UV 10.2 - I guess UD has the same? Thanks, -Baker 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
Re: [U2] General guidelines on indexing
Maybe one of you would be willing to pull all these good posts on indexing into a wiki article? It would be handy reference material and could save someone from hours of pain can't get this stuff from reading the system docs. http://212.241.202.162/U2UGWiki/moin.cgi/ForDevelopers -Baker 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
Re: [U2] Universe Telnet service won't start
I'd like to tag onto what Brian said, once I had a similar situation, and the netstat didn't reveal any *active* services with that port number, but a service I had killed still had the port number bound so this can be pernicious issue, difficult to detect. -Baker --- First things to check: 2/ Use netstat -a -o from the cmd shell to check that there's no other process using the telnet port. Brian UV Telnet service won't start - on reboot the other services start but Telnet doesn't, and attempting to start it from the control panel hangs. Last time the server was replaced! There's a known problem of conflict with MS Telnet, but that's not the case here. Any suggestions where to start looking? Thanks, Francis 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] Basic Developer Toolkit - Eclipse SDK
Is anyone using the Eclipse SDK that was released recently (I think part of the UV 10.2 rollout pkg)? I don't remember seeing any threads regarding it so I'm wondering if folks are just working away with it with no issues or questions, or if most haven't found a use for it, or haven't discovered it. I haven't had a project yet 'in my day job' that calls for it, but am thinking about other projects. Does anyone know of a fast-start guide? The look and feel is a lot like visual studio, but it's been a couple of years since I dabbled in that either. If Nathan R. or Marcie G. are listening, this could be an opportunity for a webinar. -Baker 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
RE: [U2] Best algorithm for UV part files
Very helpful Stuart (and Brian) thanks. 1 follow-up question: given your algorithm below, when you edit or copy those records over, what does the key look like. E.g. do you have to prefix the key generated by your algorithm, with the part file number or name? To edit the record would you simply: AE HAIRY.PF.NAME B123456 Or AE HAIRY.PF.NAME 23-B123456 ? 74 Clear regards from Ft Worth, -Baker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Wednesday, May 27, 2009 7:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best algorithm for UV part files Well, it's a 'how long's a piece of string' type of question but we had a requirement to archive old data from a heavily used file. The file has several indices too many and is in use 24/7 This makes copy/delete a fairly heavy impact on the system and archiving was always an issue. The IDs in the file are a mix of numeric and prefixed keys eg 123456 or B123456 from different systems. We decided that a part file would solve the issue because you can remove the part from the DF and because the indices are attached to the part it's a very quick, clean action. If for some reason you need to put it back - it's also very quick and easy. So, we came up with a part file system which puts 10 sequential IDs into a part then moves onto the next one. For our requirement numeric keys go in a different part from prefixed keys. Theoretically this makes it easy to archive chunks of data by moving a whole part and also to find specific date ranges for records based on their keys within a particular part. @PART.ALGORITHM = OCONV(@ID,'MCN':@VM:'MR05')[1] + 1;IF @ID MATCH '0N' THEN @1 ELSE @1 + 10 Regards, Stuart Boydell -Original Message- Does anyone have an opinion about the best algorithm to use for UV distributed files? The goal is ease of moving the records in the distributed files to other files. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best algorithm for UV part files
Thanks JayJay, Wol, Jerry Brian for enlightening. The UV docs on distributed files are extremely sparse, so the peer experiences are essential to a good strategy. JJ's comment about adding archive part files whose key does not fit the algorithm already in place is what I ran into. -Baker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of John Jenkins Sent: Thursday, May 28, 2009 4:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best algorithm for UV part files It's really useful for archiving if the key contains a date - build the algorithm on the date in the key and have a separate partfile for each year (or quarter or month - you get the idea), When you want to archive old data you just drop the partfile concerned - remembering to add new partfiles for new dates as you go forward (this bit can be automated), ALWAYS remember to have an ELSE or CASE 1 on your algorithm just in case, and monitor the specified partfile to fix whatever problem caused data to be placed in there (incorrectly - or maybe you just forgot to create a new partfile soon enough). Caution - I have seen some grief where partfiles are added that already contain data - and data that does not hash to this partfile under the distribution algorithm rules. OK - it doesn't happen often - but it can cause grief and confusion - just be careful. Which algorithm to use ? sorry - answer is it depends. 1/ do you want even distribution - ? 2/ do you want context distribution (such as a date or a zip code)? 3/ How unique is your key? 4/ what are your data volumes? It all depends. Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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 To unsubscribe please visit http://listserver.u2ug.org/
[U2] Best algorithm for UV part files
Does anyone have an opinion about the best algorithm to use for UV distributed files? The goal is ease of moving the records in the distributed files to other files. There may be other criteria by which to gauge the best DF strategy, but in this case I'm just working with restored archive records, and moving records here and about. Regards, -Baker 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 To unsubscribe please visit http://listserver.u2ug.org/
[U2] U2-Stage (Datastage lite) anyone using it yet ?
Is anyone using U2-Stage yet that would like to comment about it? -Baker 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 u2lic.dll
Bill, Could you describe 'where' the IP address is displayed, do you mean in the title bar, Settings tab 4? What functions are you using that leverage this IP address? We are using UV 10.1 and Accuterm 2K2 Release 5.2.301 with no issues, but I'm not sure we are relying on the IP as you are. -Baker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, April 27, 2009 9:43 AM To: U2 Mail List Subject: [U2] U2 u2lic.dll I'm using AccuTerm to access UD UV...have been for years. When I upgraded to UD v7.2 the IP address displayed for anyone connecting to UD via AccuTerm, when device licensing was turned on, is 127.255.255.255. This messes up all functions we use that rely on the IP address, and device licensing. IBM wants an exorbitant amount of money from AccuTerm for a new u2lic.dll, effectively doubling the cost of AccuTerm. Does this same problem manifest itself in the newest version of UniVerse? As always, thanks. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 u2lic.dll
Wow. I don't see a way to fix the regular method of getting at the IP; it for sure sounds like 7.2 broke it. Could you code around it? Execute a little program at Login that considers the number of connections in the specific account? Write their WHO info to a file, and make each connection obtain a token. Set the number of tokens at your ceiling for that account. When the tokens run out, they have to wait. You have the inherent security of hashed files not being accessible from *nix or *dos so they couldn't easily hack this. Regular login credentials must first validate anyway, so you'll know who didn't get a token when they wanted to login provides a sales opportunity. HTH, -Baker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, April 27, 2009 1:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 u2lic.dll Baker: In UniData, when I use the LISTUSER command from TCL, or use the LISTUSER() function in BASIC, the IP address is displayed as 127.255.255.255. We run a hosted system, where we have multiple accounts using our application. We need to limit each account to {X} number of logins, and need the IP address to perform this function while allowing device licensing. All AccuTerm versions have this problem in UD v7.2, but not in any previous version of UD. Thanks, Bill __ From: Baker Hughes baker.hug...@mouser.com Sent: 4/27/2009 9:50 AM To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: Re: [U2] U2 u2lic.dll Bill, Could you describe 'where' the IP address is displayed, do you mean in the titl e bar, Settings tab 4? What functions are you using that leverage this IP address? We are using UV 10.1 and Accuterm 2K2 Release 5.2.301 with no issues, but I'm n ot sure we are relying on the IP as you are. -Baker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug .org] On Behalf Of Bill Haskett Sent: Monday, April 27, 2009 9:43 AM To: U2 Mail List Subject: [U2] U2 u2lic.dll I'm using AccuTerm to access UD UV...have been for years. When I upgraded to UD v7.2 the IP address displayed for anyone connecting to UD via AccuTerm, when device licensing was turned on, is 127.255.255.255. This messes up all functions we use that rely on the IP address, and device licensing. IBM wants an exorbitant amount of money from AccuTerm for a new u2lic.dll, effectively doubling the cost of AccuTerm. Does this same problem manifest itself in the newest version of UniVerse? As always, thanks. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This communication, its contents and any file attachments transmitted with it a re intended solely for the addressee(s) and may contain confidential proprietar y 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 o r use the contents, attachments or information in any way. Please destroy it a nd contact the sender. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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 To unsubscribe please visit http://listserver.u2ug.org/
[U2] MV based Financials ready for Intl business
Hey, I'm looking for names of some multi-value based Financials. They must be ready for International business. Hopefully something that would interface nicely to a highly customized order fulfillment system. What should it contain? GL, AP, AR, be able to do it all in multiple currencies and use bank accounts in various countries, based in other currencies. We are in the distribution business and most facets of our custom package are up to the task of international business. Our financial package is lagging and is difficult to maintain so we're maybe reaching the tipping point where's its better for business to convert to something more up to date. You can respond off list if you like. baker.hug...@mouser.com Thanks in advance, -Baker 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV to SAP mig... GOOGLE funds for MV worldwide !
Bob, I'm thinking along the same line as Symeon. In the US we have Nat Crime Infor Cntr (NCIC) which (I assume is still) administered by the FBI. Are you suggesting that local folkal be able to also share crimes/incidents that don't make it onto the NCIC? It's been years since, but I was the IT shop for a PD, and then, even someone's arrests [prior to conviction] were on their record. What else are you going to share? Sounds interesting, just trying to understand the 'mission statement'. -Baker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, April 22, 2009 3:13 AM To: u2-users@listserver.u2ug.org Subject: RE: RE: [U2] UV to SAP mig... GOOGLE funds for MV worldwide ! Surely an interface into each countries criminal database would be easier to maintain - in the uk we have the PNC (Police National Computer) which contains all such records, access to this is very tightly controlled. I know our police have enough paper work to do without having to fill in records on another database !? -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Bob Fox Sent: 21 April 2009 23:48 To: u2-users@listserver.u2ug.org Subject: RE: RE: [U2] UV to SAP mig... GOOGLE funds for MV worldwide ! Yes and also to create a local agency records management system. Most police chiefs and sheriffs are willing to share their information but we must provide a comprehensive local database. This overcomes points of: 1. Must be Windows (and browser) based. 2. They must own and control their own local databases. 3. Gives them ownership and control of sharing 4. Provides standard crime reporting (which saves significant resources alone) 5. Local database fully indexed to assure easy and comprehensive access 6. Many other points/issues/concerns to numerous to list... Bob 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV Timed INPUT
David, Not sure what you need to accomplish, Brian's offer looks promising. You might also try INPUTIF. I use it in status screens. got the idea from my days working with computer aided dispatch. ACT='' LOOP INPUTIF YOUR.WISH THEN BEGIN CASE CASE UPCASE(YOUR.WISH) MATCHES XQUIT ; ACT = EOJ CASE YOUR.WISH GE 1 AND LE OPTION.CNT ; Go do the option nbr CASE 1 ; Error handler here END CASE END ELSE SLEEP REFRESH.SEC.CNT.FROM.INSTALLATION.PARAMS GOSUB REFRESH.AMBULANCE.STATUS.SCRN END UNTIL ACT = 'EOJ' REPEAT We have someone who watches a status screen for Credit Card Auths that are on some status that requires human interaction. Works nice. -Baker I'm sure I've seen something about this recently, but I've searched the past 2 years with no luck. I want to do a timed INPUT in UV - if after n seconds the Enter key hasn't been pressed, do something. Anyone got any clever ways of doing this ? Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia 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 To unsubscribe please visit http://listserver.u2ug.org/
[U2] Passing of Don Willis
I am posting this for the benefit of those who knew Don in some way, and so we can all benefit from his example ... It is with great sadness that we report the passing of Donald Willis on Friday, January 9, 2009. Don was a close member of the PVI family for over thirty years and most notably served as the Information Systems Manager, a member of PVI's Senior Management Team and a shareholder. Don was the architect of the PVI information systems software, developed over twenty years ago to meet the unique needs of PVI customers and management alike. As PVI has grown, Don was instrumental in keeping our ability to serve our constituents, always knowing that our ability and desire to serve our customers is what makes PVI the company it is today. -Chris Bollas of PVI management team (Ft Worth, TX) Simply, Don was the best boss I've had in my 30 years of programming. He effectively employed his heart-felt Christian values in the work place --- no small accomplishment. He cared deeply for all the people here at PVI and especially for us in the IT Group. He was an inspiration to all of us and a talented programmer, too. He'll be sorely missed. I'm just thankful that we had the time together. -Devon Osborne, PVI Developer, Texmug Member I remind Texmug members that Don made a very fine presentation at our June 19th meeting on the document management system he created for PVI - this was Don's description of the requirements --- We could never seem to get a document management system to the top of the budget, so we (Infosys) decided to experiment with the interaction of Universe and other software. Goals were no cost, secure and simple for the user. We created the system, named SOS for Secure Online Storage, and currently have almost 750,000 documents stored. Universe controls it all, from setting NTFS security, generating barcodes on everything, to allowing productive document set displays based on cross reference from the main Universe database. This was one of the best Texmug presentations to date, and a well attended meeting. Don represents the pioneer spirit that many Multivalue developers have, who meet and exceed the requirements of their employers or customers and over the years tune their business systems to meet the challenges of the changing business environment. Don was one of the best and brightest of these pioneers who humbly, quietly, crafted a robust, custom, IT solution which played a significant role in his employer's continued and storied success. He did this while also caring for others and showing consistent integrity. We are richer as a community for having had him among us. Those wishing to express condolences to his family or friends can obtain contact information from myself or Devon [dosborne at removethis pvi dot com]. -Baker Hughes Texmug President Member at Large, U2UG Board presid...@texmug.org You can read the obit at this link, search on Willis in ft worth, tx: http://www.legacy.com/dfw/Obituaries.asp?Page=SEARCHRESULTS 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 To unsubscribe please visit http://listserver.u2ug.org/
[U2] Passing of Don Willis
I am posting this for the benefit of those who knew Don in some way, and so we can all benefit from his example ... It is with great sadness that we report the passing of Donald Willis on Friday, January 9, 2009. Don was a close member of the PVI family for over thirty years and most notably served as the Information Systems Manager, a member of PVI's Senior Management Team and a shareholder. Don was the architect of the PVI information systems software, developed over twenty years ago to meet the unique needs of PVI customers and management alike. As PVI has grown, Don was instrumental in keeping our ability to serve our constituents, always knowing that our ability and desire to serve our customers is what makes PVI the company it is today. -Chris Bollas of PVI management team (Ft Worth, TX) Simply, Don was the best boss I've had in my 30 years of programming. He effectively employed his heart-felt Christian values in the work place --- no small accomplishment. He cared deeply for all the people here at PVI and especially for us in the IT Group. He was an inspiration to all of us and a talented programmer, too. He'll be sorely missed. I'm just thankful that we had the time together. -Devon Osborne, PVI Developer, Texmug Member I remind Texmug members that Don made a very fine presentation at our June 19th meeting on the document management system he created for PVI - this was Don's description of the requirements --- We could never seem to get a document management system to the top of the budget, so we (Infosys) decided to experiment with the interaction of Universe and other software. Goals were no cost, secure and simple for the user. We created the system, named SOS for Secure Online Storage, and currently have almost 750,000 documents stored. Universe controls it all, from setting NTFS security, generating barcodes on everything, to allowing productive document set displays based on cross reference from the main Universe database. This was one of the best Texmug presentations to date, and a well attended meeting. Don represents the pioneer spirit that many Multivalue developers have, who meet and exceed the requirements of their employers or customers and over the years tune their business systems to meet the challenges of the changing business environment. Don was one of the best and brightest of these pioneers who humbly, quietly, crafted a robust, custom, IT solution which played a significant role in his employer's continued and storied success. He did this while also caring for others and showing consistent integrity. We are richer as a community for having had him among us. Those wishing to express condolences to his family or friends can obtain contact information from myself or Devon [dosborne at removethis pvi dot com]. -Baker Hughes Texmug President Member at Large, U2UG Board presid...@texmug.org You can read the obit at this link, search on Willis in ft worth, tx: http://www.legacy.com/dfw/Obituaries.asp?Page=SEARCHRESULTS 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 To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Identifying the pid for a user
DECLARE GCI getpid ; * general C interface call PID = getpid() ; * get the unix process ID for this process -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Taylor Sent: Saturday, November 08, 2008 1:32 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Identifying the pid for a user Tom, Try @USERNO, or the USER.NO in LISTU on the entry with the asterisk or the first field from WHO, all on the User's connected line. hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Tom Dodds [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, November 07, 2008 12:37 PM Subject: [U2] Identifying the pid for a user I know this has been address before, but I can't find any of the references to the solution. We are running UniVerse 10.2 in a Suse environment and I would like a reasonably simple method of acquiring the pid of the current process. Thanks for the help. Tom Dodds [EMAIL PROTECTED] 630.235.2975 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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 To unsubscribe please visit http://listserver.u2ug.org/
[U2] Linux Telnet client
Hey, I've just changed the OS on my laptop to SUSE Linux. I got back hours of my life, just in boot time alone, but I won't rant. Would anyone like to suggest their favorite *nix based telnet client? Must be free or close to it. If it would handle UV device licensing that would be fantastic (and could perhaps have implications in our desktop group, if you know what I mean). Baker the world is so beautiful out of MS prison Hughes --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData PROC tip: DB command
The man (person) who writes a PROC interpreter/conversion utility that can take a PROC and turn it into either Basic, or a PAragraph, will have a product to sell... esp. if it can decipher all the PROC nuances and tricks that have been introduced over the years. Same goes for a tool to convert A correlatives to I-descriptors. But pity the wretch that is assigned the task of writing the tool to convert F correlatives. We'll sooner inhabit Uranus. -Baker /snip I have been often labeled a PROCtologist by accidentally becoming very good with Procs back in the day. Unfortunately there is no clear simple replacement and/or 'replacement over time' that occurs when replacing F corelatives with A's or retiring Batch processes. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData PROC tip: DB command
Martin, After I wrote this, I said to myself, if anyone would/could do this it would be someone close to the Development of one of the Mv systems. I thought Northgate, but I'm not surprised that you've done it. I'll know where to go when I get a contract converting a reality or R83 to OpenQM, or am asked 'to what MVdb can we move our app ...?' -Baker /snip Back in the days when I was working on the development of PI/open, I had a go at this. It is not difficult to produce Basic code that does the same job as the Proc but producing good code rather than a simple step by step interpretation of the Proc is difficult. Also, there are some strange interactions between Procs and the underlying command environment that are different from how Basic programs work so you can never get a true replacement. Same goes for a tool to convert A correlatives to I-descriptors. This is relatively easy. If you think there is a market, we might even do it. We looked at this as part of the migration process for users moving to OpenQM but we chose to implement correlatives instead as it was easy. Ours are compiled (like an I-type) rather than interpretive for best performance so actually the task of writing the convertor is probably little more than ripping apart our existing correlative compiler. But pity the wretch that is assigned the task of writing the tool to convert F correlatives. This is probably easier than A correlatives. Again, if there is a real market that would pay a sensible price for it, we might do it. Martin Phillips --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Basic SORT() Function not avail in UniVerse?
John - me too, when I can. In this case I'm reading in a mv list of other record ID's. They are likely in order, but its imperative that they are, so the SORT is a precaution, since 'stuff' happens. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: Tuesday, July 22, 2008 10:44 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: Basic SORT() Function not avail in UniVerse? When I need an array to be sorted, I always build it that way using the LOCATE command with the BY option. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Basic SORT() Function not avail in UniVerse?
Thank you Bill, Brian Norman, If I'm allowed to deploy a separate Function or Sub you've virtually coded it for me. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Basic SORT() Function not avail in UniVerse?
Thanks WOL, A colleague also directed me to PickWiki and the thoughts on SORT there are a good read, and show the options. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, July 22, 2008 10:53 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: Basic SORT() Function not avail in UniVerse? Look on PickWiki - there are several sort routines there. Of course, I'd recommend the SHELL sort :-) NB - which version of UV are you using - it's long fixed but there's a nasty bug in the COMPARE function in 9.6. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows
Telnet behind your own firewalled, secure Enterprise, IS PCI compliant. Telnet across a non-secured, unencrypted connection is not. As Rex stated, you could simply turn on SSH if you want added comfort. On the subject of unencrypted communication, consider that MANY credit card clearing houses are reached through a Frame Relay connection, using an unencrypted, clear text socket. In Theory, this is 'secure' because its 'yours'. You bought that virtual 'channel' through the ma-bell network. But in reality, how secure is it to send cardholder info across the telco network? [which likely includes satellite up/down links] I would venture that this represents more vulnerability than you have inside your own enterprise. The PCI data security standard also allows for any site to present offsetting safeguards to mitigate any non-compliant aspect of their operation by the implementation of business rules and procedures. A frank discussion with your clearing house that demonstrates 'due diligence' goes a long way toward keeping your 'compliant' certification. I state all this because I hate to see anyone making a database move out of a knee-jerk reaction to PCI. ... or a CIO wrapping their secret [sql] agenda in a 'PCI Compliant' guise. fwiw, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Monday, July 21, 2008 9:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] converting from UniVerse on Redhat Linux to UniVerse on Windows There is a discussion here to either do completely away from UniVerse to SQL because 99% of our servers are windows applications and our network administrator doesn't know much about Linux and believes because we have to open up telnet for UniVerse and an old application on a Solaris box of Mumps that we are making the Linux less secure and that PCI requires we don't use telnet at all. We use SSH to login everywhere except for the communication between UniVerse and Mumps. As a stop gap the company may switch from Linux to Windows. I thought I remembered a discussion on this sometime in the last couple of years. I'll search the archives. In the meantime, has anyone have an experience with this? If so, did the costs stay the same, go up, go down. Any difficulties? Seems like it would be the same procedures as we had to run when we was transferring data from our live server (linux) to our old test server (Solaris), you had to do funxi on the data and that was that. They are in the process of getting comparison costs between UniVerse and SQL now. For those with both UniVerse and SQL experience, how does the development time differ. To me it appears that it takes the VB and SQL folks longer to get changes done then it does on the UniVerse systems. If we switch, it seems to me that the quick fixes users demands will be pretty much going away. Am I correct on this? I am 99.9% certain that the switch will happen at some point in the next few years. Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO 65079 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT - Pick mentioned in letter to the editor... [not-secure]
It was virtually accurate, IMHO. %-) I sympathize with Karen. This is why we offered 3 new technologies at the recent Texmug meeting: XML, Imaging MV, and the new object enabled MV database - OpenQM. We must add new tools to our belt to keep ourselves viable. I'm sorry you couldn't make it out ... hopefully next time. -Baker [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bessel, Karen Sent: Tuesday, July 08, 2008 3:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] OT - Pick mentioned in letter to the editor... [not-secure] LOL I agree. He should speak for himself. I'd trade my legacy software developer job for a data warehousing/business intelligence/database developer job tomorrow. Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3777 Email: [EMAIL PROTECTED] Web: http://www.tylertech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Land Sent: Tuesday, July 08, 2008 2:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OT - Pick mentioned in letter to the editor... [not-secure] Interesting, it's a shame that what he says isn't really true. George On 08/07/2008 19:59, Hennessey, Mark F. [EMAIL PROTECTED] wrote: This appeared in the letters to the editor section of the July 1 Software Development Times HIS PICK FOR AN OS IS CLEAR --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] locking code question
Doug, The 2 cleanest methods I can see are: a) Set the permissions at the OS level at checkout time. If they don't have write permission the checkin will fail (after they've made all their changes 8-D ) b) During checkout, back the real source code to another name 'cool.screen.io.sub.BKP' and remove the original while it is checked out. When checked in, the new version becomes the 'cool.screen.io.sub'. If they uncheck with no changes then put the .BKP back in place. FWIW, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: Thursday, May 15, 2008 3:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] locking code question we COULD use source safe as Israel pointed if source code is kept in unix directories they can be samba mounted on a PC and then checked into and out of source safe. The main issue I am trying to get resolved is to lock the record at the pick level , in case someone does nto check out a code and then tries to edit it when another developer already has it checked out, since most of our developers use a pick aware editor as long as the record was locked at the pick level, they would get a warning message, teh question is whats the best way to lock program x at the pick level? 1. I could AE/ED and lock it that way (programtically of course) but then how do I exit gracefully? 2. I could READU the item in a program and keep that program running forever (at least until the developer checks it back in then the program could terminate) 3. If I could somehow manage to modify the lock table to say that this item is locked and once checked in modify the lock table to release the lock (this is my preferred solution but I am not sure if its doable or if I have the skill to modify the locking table without corrupting it) 4. other iseas/suggestions? thanks all dougc Israel, John R. wrote: Yes and no. Since basic program files are just Unix Dirs and the source code is just text, you could map these files via Samba so that Windows could see it cleanly and use it that way. It might take a little playing, but we did something like that and it worked to some extent. Might not be the best way, but I thought I would throw it out. There are similar Open Source products for Unix, though I have not had experience with them. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, May 15, 2008 2:30 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] locking code question It appears that SourceSafe is a Microsoft product. Thus, I expect that it would not be the best fit in a Unix shop. --B -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Israel, John R. Sent: Thursday, May 15, 2008 2:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] locking code question I worked at a site that actually used SourceSafe to check in/out programs. This worked fairly well in a lot of ways, but it is a shift in how source code is stored and accessed. The nicest thing is the historic versioning and comparing features. John Israel Sr. Programmer/Analyst Dayton Superior Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Press any key to continue...
If I could extend the question just a little ... would anyone like to share their Standard.Input.Sub that they call from all their input screens. Its always illuminating to see how others do it. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Press any key to continue...
Ah. a new product line MS Keyboard, esquire -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson Sent: Wednesday, April 30, 2008 3:50 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Press any key to continue... In this case, simply re-labeling the Enter key as Any would be the best way to proceed -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Colin Alfke Sent: Wednesday, April 30, 2008 4:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Press any key to continue... We had one user (a lawyer - go figure) complain, quite vigorously, that the Shift key wouldn't be accepted as ANY key. Colin Alfke Calgary, Canada -Original Message- From: Steve Ferries Hi All, We were coding a standard INPUT ANS after asking a user to Press any key to continue We noticed that the program would not accept a Space Bar as a valid key; it only moves the cursor to the right. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniVerse Triggers
Hello, We have received reports that UV triggers have shown some instability. Does anyone have anything to share on this? We have been using them for a couple of years with no issues but were hoping for more details from other users, if available. Thanks much, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL Command stacker
David, Is there a switch to turn this on? When I try it I get this: COMMAND.EDITOR Command/Input editing switched off -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: Tuesday, April 15, 2008 5:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL Command stacker UniVerse 10.x has COMMAND.EDITOR, ported from PI/open but it is not officially supported nor documented by IBM. It has most, but not all the functionality of the PI/open version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] TCL Command stacker
Thats it. Thanks Raul, and David. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, April 16, 2008 11:07 AM To: u2-users Subject: Re: [U2] TCL Command stacker Try COMMAND.EDITOR ON ALL Raul - Original Message - From: Baker Hughes [EMAIL PROTECTED] Sent: 04/16/2008 10:14 AM EST To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: RE: [U2] TCL Command stacker David, Is there a switch to turn this on? When I try it I get this: COMMAND.EDITOR Command/Input editing switched off -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: Tuesday, April 15, 2008 5:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL Command stacker UniVerse 10.x has COMMAND.EDITOR, ported from PI/open but it is not officially supported nor documented by IBM. It has most, but not all the functionality of the PI/open version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Skype cannot connect
Helen, I wouldn't rush to fdisk your HD. A re-install of all the same software will probably result in the same conflict, unless you resolve it. There is a known conflict between UV PE and some communications software pkgs. Another user (in Texmug) had some Verizon (I think) software on his laptop to make his cell work as a modem - whatever the function of the software, it was binding the same port that UV wanted though it didn't show as bound, so no telnet connections could open to UV, only the shell. Go to ZDnet and download SystemExplorer. Run that and find out what all is running on your system. It's much more thorough than the Win Task manager. Disable everything but the essentials - SE will tell you who signed the driver or whatever so you'll be able to recognize if it's an addon or an OS essential. Then start UV by itself, check your telnet connection. If good, then start Skype or whatever else you think is maybe conflicting. If the issue arises then, you know you've got to reassign some ports. HTH, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Helen Chenoby Sent: Tuesday, March 11, 2008 7:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Skype cannot connect Tony, Thank you very much. I have checked and rechecked everything that you suggested and it still doesn't help my situation. Also Firefox cannot connect to the internet, and I also installed Opera just to check, which also cannot get a connection. At the moment I am seriously considering re-installing the whole computer and wiping the hard drive clean. Do you have any other suggestions that I can try to help me solve this problem? I have included my config.sys path for you if that would help you in any way. PATH %SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;c:\Program Files\ASUS Security Center\ASUS Security Protect Manager\bin;C:\Program Files\ATI Technologies\ATI.ACE\;C:\Program Files\Sonic\MyDVD;C:\PROGRA~1\COMMON~1\SONICS~1\;C:\Program Files\QuickTime\QTSystem\;c:\Program Files\Microsoft SQL Server\90\Tools\binn\ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Totaling an Oconv'd DICT column
Brian, Thanks for the help. Yes, thats the dilemma, applying a mask that holds true for all the currencies, when some have no decimals. The MD20 does seem to help the original issue, with the data I have, mostly USD and GBP. I'll have to try it against Yen. The Sub-Total is actually most valuable, from the accounting perspective, and what I'm most troubled for. Believe it or not, our people actually look at the grand-total too, just to check it against some Screens that provide sales by currency and do the same combining of spinach and berries. [I guess this confirms that accountants also employ Art and emotion, not just skill; just like programmers 8-) ]. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Wednesday, February 06, 2008 3:44 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Totaling an Oconv'd DICT column Baker It's clearly giving floating point maths errors, but if scaled back would the figures be correct? i.e. you could add an extra MD20 conversion in field 3 of AR.TOT.USD.FRGN (ignoring the fact that combining currencies in this way is pretty meaningless...) Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Totaling an Oconv'd DICT column
Hey Dennis, that's quite a kewl work-around. Thanks for the idea. The suggestion by Brian of forcing it to 2 decimals with the MD20 seems to have placated our finance folks. But if this one raises its head again I may have to punt it into the end zone with this method from you. As you said - List only does so much, and I don't want to replace this report series with code, or sink a subroutine into the I-descriptors. I think the erratic floating point math error actually stems from the actual OCONV in the I-descriptor, and not something I can fix, only mask. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: Wednesday, February 06, 2008 11:38 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Totaling an Oconv'd DICT column Regards Dennis Bartlett DB Admin/Programmer [EMAIL PROTECTED] +27-21-526 4300 (tel) +27-21-555 3970 (fax) For what it's worth, I've been known to COMO the output of a LIST statement and then run the COMO file through a program that reformats the report... some things are just not possible for LIST to do, but it's way easier to get the results via LIST than it is to write (and forever have to maintain) code for it... plus it's easy to add to. It's quite simple to identify the lines you are interested in. I simply HUSH ON, run the listing, HUSH OFF, and then process the output. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Totaling an Oconv'd DICT column
Hey, UV 10.2 / PIOPEN Flavor I'm trying to resolve an erratic issue with totaling on some reports, where it runs the column out to 9 decimals. It only happens when we apply the 'MD2' conversion with an OCONV, rather than using the Conv field in the DICT item. And, it does not happen consistently. Why, then, do it this way? Because we must decide whether to present a foreign currency amount, or a USD amount. We store the foreign currency amount in its output format, but USD in its internal format. Our accountants want the AR Amount to appear in the same column, regardless of currency code. Consider the DICTs: This is what formerly appeared on reports, before handling other currencies: Top of D10 in DICT CRJ, 6 lines, 51 characters. 001: D ACCOUNTS RECEIVABLE AMOUNT 002: 10 003: MD2 004: A/R-TOTAL 005: 10R 006: S Bottom. For diagnostic purposes only, to demonstrate there is no embedded decimal in the data: Top of D10.RAW in DICT CRJ, 6 lines, 52 characters. 001: D AR AMT WITH NO (02/04/08,RBH) 002: 10 003: 004: AR-TOT RAW 005: 10R 006: S Bottom. A simple form of the actual OCONV, without the conditional IF: Top of D10.OCONV in DICT CRJ, 20 lines, 542 characters. 001: I AR AMT - Oconv'd (2/5/8, rbh) 002: OCONV(D10,MD2) 003: 004: AR-TOT OCONV 005: 16R 006: S What is used now in the report; We present field 10 if USD, or field 26 (already converted) otherwise: Top of AR.TOT.USD.FRGN in DICT CRJ, 20 lines, 1,407 characters. 001: I ACCOUNTS RECEIVABLE AMOUNT USD / FGRN (JMK, 15 MAR 2007) 002: IF D22 = USD OR D22 = THEN OCONV(D10,MD2) ELSE D26 003: 004: A/R-TOTAL 005: 10R 006: S Top of D26 in DICT CRJ, 6 lines, 57 characters. 001: D FOREIGN ACCOUNTS RECEIVABLE AMOUNT 002: 26 003: 004: A/R-TOTAL 005: 10R 006: S Bottom. The output: LIST CRJ TOTAL D10 TOTAL D10.RAW TOTAL D10.OCONV TOTAL AR.TOT.USD.FRGN TOTAL D26 ID.SUP DET.SUP A/R-TOTAL.AR-TOT RAWAR-TOT OCONVA/R-TOTAL. A/R-TOTAL ====== == nn86.5nn8655nn86.5499989nn49.835.64 5 399989 Beaucoup records listed. [actual figures masked] Thanks for any insights offered, or diagnostic steps. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Totaling an Oconv'd DICT column
Jerry, Thanks for that thought, but I've already tried it without the CONV in D10. I've removed it temporarily to demonstrate how it all looks, working on that hunch [ but, alas...]. LIST CRJ TOTAL D10 TOTAL D10.RAW TOTAL D10.OCONV TOTAL AR.TOT.USD.FRGN TOTAL D26 ID.SUP DET.SUP 15:26:35 02-05-08 PAGE 1 A/R-TOTAL.AR-TOT RAWAR-TOT OCONVA/R-TOTAL.A/R-TOTAL. ======== nnn655nnn655nnn6.5499989nnn9.8 35.64 399989 bunchof records listed. D10 currently: D10 0001 D ACCOUNTS RECEIVABLE AMOUNT 0002 10 0003 0004 A/R-TOTAL 0005 10R 0006 S What's mysterious - is that many days it looks right: LIST CRJ TOTAL D10 TOTAL D10.RAW TOTAL D10.OCONV TOTAL AR.TOT.USD.FRGN TOTAL D26 ID.SUP DET.SUP 15:30:15 02-05-08 PAGE 1 A/R-TOTAL.AR-TOT RAWAR-TOT OCONVA/R-TOTAL.A/R-TOTAL. ======== nnn480.83 nnn48083 nnn480.83 nnn480.83 0 1516 records listed. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, February 05, 2008 1:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Totaling an Oconv'd DICT column Both D10.OCONV and AR.TOT.USD.FRGN are using D10 which is already converted. Jerry Banker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] PE UV on XPpro - Admin question
Hey, Can someone tell me the character based way to create another account on a Personal Edition UniVerse install? UniAdmin is not running on this machine and the time it would take to get it up is not worth it if we can create a new account through a character menu. In the UV account now, the old MENU.FILE is not there, and the following command fetches 'no such file or directory': RUN BP NACCT.ADMIN -ACCOUNT -ADD [doesn't work 8-{ ] I'm helping another user so I don't have direct access to this machine, someone else has to be my eyes. So if you can give the simple steps it would be most appreciated. Dry windy thanks from tejas, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] forms / imaging / doc overlay software
Terry, 3 vendors come to mind at present, no order or endorsement intended: www.stamina.com.au - visage (I think you can just use the forms as standalone although it's a full-blown 4gl) www.binarystar.com - mvlaser www.synergetic-data.com - unforms hth, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Terry Stennette Sent: Monday, January 21, 2008 1:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] forms / imaging / doc overlay software Hello U2 group, Anyone out there using and / or have a recommendation for a forms imaging / document overlay software package that runs in a Universe / AIX environment. Goal being to use the software rather than buy pre-printed forms. Any ideas would be appreciated. Thanks, Terry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Slave Printing Problem
What emulator are you using? [Assuming you are using an emulator and not an actual terminal 8-) ] If Accuterm, make sure you have selected the default printer. Tools, Settings, 8-Printer tab, click radial button - use default. hth, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bessel, Karen Sent: Monday, January 21, 2008 2:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] Slave Printing Problem Turning auxiliary port on/off using CHAR(18) and (20) - I have also tried (24) (20). After the CHAR(18)/(24), the slave output is turned on but it does not capture any of the output. This is occurring with both proc BP type output. If I run the proc/BP to spooler hold, there is printed output so it's not an issue with selection criteria/data/etc. This is a really old version of UV (9.5.1.1). Any ideas? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Phonetic Name Algorithms
Ray, That sounds interesting. I can see why you would need a new approach to Maori since the 1st step in Soundex is to collapse or remove the vowels altogether. In a vowel heavy language this would be self defeating. Is there a degree of intonation required to speak Maori? something else soundex doesn't consider. How do you handle the extra vowels during segmentation/syllabification. What is the application for your algorithm? I'm trying to do some reading about Standard Arabic (SA). Thankfully there's been some recent scholarly work done on this language. They discuss algorithms and the additional/different rules for SA. I'm not sure yet how easily I'll be able to convert their work into code. The approach I'm leaning toward is to add 1 or 2 newer algorithms to the code base, in addition to soundex (Hopefully one of the 3 will handle the name well) then Build a separate index using each of these. Do a selectindex on each, make a Union list, then present a match list to the User for human analysis. Since U2 is now international, and with the advent of NLS, maybe IBM could provide something more than the Basic SOUNDEX function. This would give them a selling edge for getting U2 embedded in public safety apps. Thanks, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Monday, January 14, 2008 11:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Phonetic Name Algorithms I have one that is suited to Pacific Islander languages, such as Maori, which tend to be vowel-heavy. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [Ad] XLr8 Editor and Web Developer Updates
I had a similar thought, I don't want the XLr8 Editor writing directly to the primary source repository. Will it respect the Unix permissions on an item in that Dir? Thanks. Have a great day, -Baker Hughes x3598 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Horn, John Sent: Thursday, January 10, 2008 9:48 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [Ad] XLr8 Editor and Web Developer Updates Are there any plans to make XLr8 and PRC play nicely together? - John M. Horn HealthLink -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of daverch Sent: Wednesday, January 09, 2008 12:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] [Ad] XLr8 Editor and Web Developer Updates U2logic announces that our Free eclipse based plugin for Universe and Unidata has been updated. Instructions for downloading this tool is available at www.u2logic.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Phonetic Name Algorithms
Hey, Does anyone have any info/insights about good phonetic algorithms? We are all very familiar perhaps with the Soundex, Metaphone or Double-Metaphone, but these were all designed for Latin/English language names. The basic logic was patented in 1918. http://en.wikipedia.org/wiki/Phonetic_algorithm Maybe some of our mates across the pond in the public sector, or even stateside, have devised algorithms that also work with Arabic language names, or other languages. What are you other Distributors doing in this regard to not sell to anyone on the government's list of badguys, or prevent ITR or EAR products from getting into the wrong hands? We have a pretty successful program in place in this regard but I'm looking to tighten our search capacity, and that means better phonetic algorithms. For an example of a newer algorithm, here is the Daitch-Mokotoff Soundex, designed for Slavic and Yiddish origin names. http://www.jewishgen.org/jos/jossound.htm Anyone that doesn't want to divulge your advances in this area on-list, email me off list. bakerdothughes atmouserdotcom Regards, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] sigh phantom ?
Doug, Try: SH -c ps -ef | grep -v grep | grep phantom hth, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: Wednesday, December 12, 2007 11:56 AM To: u2-users@listserver.u2ug.org Subject: [U2] sigh phantom ? Sigh I feel like such a newbie but anyway is there a way to using PORT.STATUS to tell if a process is a phantom process? If it wasn't for the fact that I called my program FTP.PHANTOM ftp://ftp.phantom/ I never know it's a phantom process. All phantom process in jBASE are given port numbers above 10,000 so it's very easy to tell a phantom process by it's port number I won't say jBASE does .. anymore but assume that :-) PORT.STATUS output: 24998 chando 0xACEB9E59 RUN TEST FTP.PHANTOM [ FTP.PHANTOM @ 0x38 ] Any insight on what the text in brackets means? [ FTP.PHANTOM @ 0x38 ] Thanks everyone dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Standards [was:OCONV Extraction Question - Good Practice]
Colin Stuart, Forgive my bluntness - quit wasting time - Write your spec. That's the challenge. I agree with much of what you've each written, but unless you codify it into some document of lasting value, we're not really going to remember it past lunchtime. Charles has submitted the Barouch spec, and people have responded to it. I would sincerely value your Spec - and would take a shot at responding to it. HTH, -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] PE Edition Telnet Service Won't Start
We recently resolved this error for a TEXMUG member - in this case it was some Verizon wireless software that had a ghost bind on port 23. It didn't show as bound anywhere but when that software was un-installed telnet to UV began working. Perry, Brenda, If you want to read the whole thread, connect to http://tech.groups.yahoo.com/group/texas_mug/ I'll extend a courtesy membership to you (Missouri is Texas Area, isn't it?) -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need to partially hide a file
Augusto, sort of along the same line of thinking as Dave ... play with the user's logon as soon as they login... Modify your LOGIN VOC item so that it: a) Checks a Data Security flag for that specific user [ @logname = Item ID in DSA.Flags file] b) Open the Cust.Secure.Data file to a named common in a short program if they have clearance c) If they don't have clearance Open the Cust.Skinny.Data file to the same file name in the named Common The named common will follow the user to whatever account they logto (if you log them around in the app or if they can Logto). Downside: You will have to modify the code where you are opening this file in the App, since it will already be opened. BTW - This approach should meet PCI compliance, and others, since you are making a positive grant of access based on the User logon (rather than role based or menu based security). I would check the language of the controlling standard - sometimes they hint at the approach they want you to take. HTH, -Baker snip from Dave Another approach is the following: In UniData this could be done by using environment variables, and assigning the variable with different values for some users than for others. For example: F @ENVVAR/PRIVATEFILE D_PRIVATEFILE User A (privileged) could have it set to C:\private. User B could have it set to . I don't know how much trouble that is to set up for windows users though. /snip snip Augusto: We need to hide some private data (customer personal data) in order to fit with our Private Data Protection Law. But only for some users, the others, they need to have full access. Our app is complex enough to modify the source code. snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Via Systems
Try viasystemsinc.com (no ad because I'm just answering someone's question) Just got an e-mail from DBTA advertising a Via product. So... Ross you everyone on the list a coke. It was not as you bet a case of someone forgetting to renew their domain. It was a case of someone not leaving a forwarding placard on their old domain or just re-directing to their new one when you put their old url in your browser. %-) -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Monday, November 19, 2007 1:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Via Systems NOT HAPPY JAN!! (will make sense to the aussies) I'm guessing that someone may have forgotten to renew their domain, which has been swooped upon by an E-squatter. If something more serious has happened, I can offer you my alternative viewpoint for one of the products mentioned oops - AD?? Ross Ferris Stamina Software Visage Better by Design! Does anyone know what the current status of Via Systems is? Their domain appears to be for sale. As I am contemplating making a commitment to MyViewPoint and use ViaDuct rather extensively, the sudden disappearance of their website is unsettling. Thanks, --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OCONV Extraction Question - Best Practises
It's JUST a preference, presently I know we all reach for a good balance between brevity and clarity. I have some preferences too which I think are ideal, which seem less than ideal to others. ... but rather than mount my own hobby horse I have a suggestion / question that could put these types of exchanges to rest: WHAT IF - the U2UG took it as a future project to compile a Best Practices coding guideline document for our language? There's always helpful 'How to' stuff exchanged here. ...but style question sometimes spiral downward. As someone pointed out recently, we have the blessing and curse of using a rather free style language. Not much Structure-Style is not imposed by the construct of the language itself, like some others. Is it time to codify some best practices relating to structure, modularity, reuse, length of internal subs, etc? I may not like some of the resulting definitions myself but it would build cohesion and greater respect for the MV space. Another thing it would do is chart a clearer path for those coming behind us - we need new blood if the VARs in this space are going to continue to sell/support embedded MV apps. I would personally find it fascinating to see some of our venerable coders get together and see what they produced along this line. I have some names in mind but I'll wait for the nominations to officially open. Happy Thanksgiving. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MAJ Programming Sent: Saturday, November 17, 2007 12:58 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OCONV Extraction Question According to who? I know there are some pluses and minuses but where is this decided or is it just a preference. Thanks Mark Johnson - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, November 16, 2007 11:30 AM Subject: RE: [U2] OCONV Extraction Question Speaking of mis-used commands and side-stepping some of the given code craziness... It is better practice to atomize the code into discrete elements such as... Var1.F = oconv(Var1, 'MD0') crt Var1.F 'R#11' rather than to try to kill two birds with one stone by including an oconv statement inside a crt statement such as... crt oconv(Var1, 'MD0') --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MAJ Programming Sent: Friday, November 16, 2007 12:48 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OCONV Extraction Question This is real smart, making things harder than they should be. Just use . Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, November 14, 2007 5:23 PM Subject: RE: [U2] OCONV Extraction Question Didn't work for me either. It may not fit what you need, but SWAP can make it work. VAR1 = 'SAM':@VM:'TRUDY' SWAP @VM WITH '*' IN VAR1 FMTSTR = 'G*1' CRT OCONV(VAR1,FMTSTR) Brad U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OCONV Extraction Question - Best Practises
Susan, snip All of which makes the determination of best practices rather difficult, since it depends on the criteria you choose for the evaluation - efficiency? Ease of maintenance? Conformation to 'site standards'? Ability to call a logical module from multiple locations in the wider application? Auditability of the results? Various standards of presentation of data for the user interface? Once you get beyond the very simple aspects of programming, everything has to be judged in the context of the application as a whole, rather than on the brilliance (or lack thereof) of small code fragments. Susan Lynch /snip If there were a set of best practices, no one would expect old code to conform to it, only new or re-factored code. Obviously, if you are working with 20 year old code, as many of us are, you have a huge limitation out of the box (unless you have unlimited freedom to re-write your app [and multiply QA time exponentially]). The purpose of any 'best practices' document{s) would be to set forth ideal methodologies. It is up to the art and skill of the individual programmer to incorporate those methodologies, insofar as s/he can, into their every project. However, well formed, well structured, modular code will satisfy all the evaluation points you mentioned. The one sticky point could be 'site standards' - but hopefully those sites that have arcane 'standards' would consider the weight and authority of a 'industry recognized' [De Facto] standard 'best practices' document, and change their archaic ways. just my .002 -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -UV- HTTP secure logins
Thanks Rex and Symeon. Got it. Trying it. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar Sent: Thursday, November 08, 2007 9:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] -UV- HTTP secure logins Baker, I use Firefox's Firebug and Live HTTP Headers plug-ins to see what's going on in web pages. rex --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] -UV- HTTP secure logins
Karl, Rex, What firefox plugin is best suited for this? I'm looking at 'About site', 'JSView', and 'Yslow'. Which did you use? I have to do a similar feature enhancement as Karl. Our Sales Mgr wants Universe (10.2) to launch a browser from within their Accuterm session and get a comparative price quote. The only problem is the website they want to use hides everything in the form / POST method. tia, -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar Sent: Wednesday, October 31, 2007 11:29 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] -UV- HTTP secure logins Karl, The site you want to access may be using either cookies, form variables, or both for user authentication. In order to use curl, wget, or any other programmatic retrieval, you will need to understand what exactly needs to be passed back and forth between the client and the website. I suggest getting FireFox (if you do not have it already) and installing one of the free plug-ins that displays the http content headers and responses. You can then log into the site and retrieve the data manually, while logging any cookies, session ids, and the like. You will then be prepared to create the curl scripts for automating the retrieval. I suspect that your script will have to mimic the user/password form request, get the cookies from the response, and pass them in the subsequent data request. I also suspect that the cookie will be set to expire once the session ends, so you will not be able to reuse it for the next request. rex --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good bye and good luck
Congrats Michael, all the best. Thanks for your labors and contributions. (Should we talk to Wally or Susie about applying for your job?) [It's just a joke!]{well, sorta} Seriously - hope it goes great in your new IBM unit. -Baker snip After 22 years in the MV world, a new opportunity has come up within IBM that I will be pursuing. As such, I will be unsubscribing from this list. While I've not done a lot of posting to these forums (I leave that to Wally!), I have read almost every post going back almost 10 years, when Clif was hosting this list. I've learned a lot about what UniVerse and UniData can do from the folks here, and while my new role isn't technical in nature, there were lots of other lessons to be gleaned 'between the lines' of these posts. Good luck to everyone in their future MV endeavors! P. Michael Logue U2 Technical Support Engineer /snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms (AD)
Robert, Janet, Thanks for these mind expanding contributions to the discussion. I rejoice with you at these successes, as we do for all our MV colleagues. I trust I and others will benefit from your insights as we get the opportunity, with similarly challenging projects, hopefully in the not too distant future. And it wouldn't be a bad thing if someone gave your product a hard look when they are faced with that project... ;-) -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janet Bond Sent: Thursday, October 25, 2007 1:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms (AD) Hello Baker, We have a customer who is processing tens of thousands of transactions a day. These transactions are centralized on SQL Server so that the Oracle ESB, UniVerse and Web Systems can share the data. The key LOB Application is on Universe, so it drives the live process. Every weekend they transfer millions of records in a large batch to ensure that everything is synchronized. The data flows both ways to SQL and Oracle. This is a Worldwide 24x7 company that is experiencing massive monthly growth, the transactions generate a serious amount of revenue. The environment needs to be fast, stable and scalable. The technology (Legacy to SQL Bridge) can access remote databases from Universe. The tables are viewed as if they are Universe files, records as items and fields as attributes. This lets Universe read, write and select data from the remote databases as if they were Universe files. On our demonstration environment here are the numbers. Using the Legacy to SQL Bridge to transfer data from SQL Server into PICK took about 1.2 seconds for 10,000 rows. Thatbs over 8,000 rows per second. Going the other ways, we were able to get, in the end, about 250 rows per second, as I recall. A better SQL Server configuration would probably have helped. These are actually very modest numbers, when you consider the configuration that was running: b Everything was running on a Lenovo Laptop: o Intel Centrino Duo o 2 GB RAM o 100 GB Disk (very full, fragmentation moderate) b Windows XP Professional b SQL Server 2005 b Microsoft Virtual PC 2004, running: o Red Hat Enterprise Linux 3: o' Universe 12 might have been 11? o' FusionWare Integration Server with the Legacy to SQL Bridge Everything was vying for CPU and I/O on one system, and we had the overhead of Microsoftbs Virtual environment (not known to be best of breed at this point). So, in an ideal tuned environment, the numbers could be much better. Then again, in a real-world environment where both your MultiValue and your SQL systems are shared, overloaded, hardworking systems, these numbers may still be about right. Hope that is useful. Janet /AD -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Thursday, October 25, 2007 12:54 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms Baker, Given the scenario you have just outlined, and my imaginings of the way that each of the 3 systems SHOULD work, you have no likelihood of deadlock collisions (this could be guaranteed with possibly relatively minor tweaks to all sides of the equation). If you want a solution, I just need a few more FACTS (guestimates AOK for numbers) - what is the database behind the WCS system - does the WCS have automated/robotic picking, manual/RF or a combination - average number of line items on a transaction originating from the Universe system - average line items for an order from the web portal - assume you want LIVE inventory on the portal (may be reasons why this is BAD, but that is another story) - peak transactions/hr from OLTP web portal Baker, I know you mean well, but I'm just questioning the need for Fastest in this scenario, unless I see some seriously LARGE numbers for some of the above :-) Ross Ferris Stamina Software Visage Better by Design! [ad] BTW, we also do applications, covering areas like web ordering, warehousing, distribution etc just for the record, and have had to tackle issues like this before [/ad] -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Thursday, 25 October 2007 12:20 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non- MV dbms Ross, Yes, there is a real-world application to the question, at least one where I may try to 'sell' the solution after the theory is worked out. 3 Different systems play with the same live Inventory of products: a UniVerse based OLTP, a MS SQL db based web-order portal, and a Warehouse Control System which fills the orders and receives stock. At night we batch the daily stock receipts from WCS up
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms
Glen, Good thoughts here as always, thanks. Right now, the UV db is not fully replicated to the MSSQL tables, rather the other way around (for the most part). The ISAM WCS tables also update UV. Therefore, at present, the UV db comes closest to being the reference, and it still runs the business. The main thing, as mentioned, is trying to bring some batch processes into real time, especially those that hinder global commerce. Some of this will have to be resolved with code, others may be helped by some of the good contributions to this thread. thanks much, -Baker snip OK. So use the existing MS SQL server as your reference point. You don't _have_ to put another data store in the mix. I'm definately no SQL expert, but can't SQL views and stored procedures be used to blend tables and provide the proper updating and reference paths/points for the UV and the ISAM DB by themselves? The suggestion of the additional MySQL/MS SQL server was to serve as a live multi-point data store, but now that I think about it you would be able to get the same results with what you have. /snip --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms
Ross, Yes, there is a real-world application to the question, at least one where I may try to 'sell' the solution after the theory is worked out. 3 Different systems play with the same live Inventory of products: a UniVerse based OLTP, a MS SQL db based web-order portal, and a Warehouse Control System which fills the orders and receives stock. At night we batch the daily stock receipts from WCS up to UniVerse, update the Avail to Sell qty for the OLTP and allocate Order Reserve Qty to backorders. Then UV sends the updated ATS to the web database (which is always 24 hours behind). Ross has asked the most astute question in all this, that of data collisions, where the same product is updated on 2 or 3 sides at once. This is perhaps the question that looms largest and keeps people (like us) in batch mode rather than real-time. Thanks everyone for the very worthy contributions to this science. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Wednesday, October 24, 2007 1:58 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non MV dbms Baker, How live and active is this bi-directional transfer likely to be? Do you need to consider the possibility of data collisions (ie: will someone change a record in your UV database that could also be changed on the other end) OR are the discrete changes somewhat atomic transactions, with no chance of duplication Are both systems running live databases? What are you REALLY trying to do (your question is nearly as big as Texas) ... if you have some specific goal in mind, then some potential road blocks may be removed (or emerge) Ross Ferris Stamina Software Visage Better by Design! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/