RE: [U2] U2 / mv.net
Nick: We use both. This is because we have two different modules that were developed by two different groups of developers; one a .NET group and another an MV group (me) (guess who picked VB). :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: Friday, April 13, 2007 5:40 AM To: [EMAIL PROTECTED] Subject: RE: [U2] U2 / mv.net Hello, I'm curious, how many of you that are using .Net are using VB as opposed to C#? And why? Thanks, Nick Cipollina --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: RE: [U2] VB.NET UniObjects Example
Greg: This is a very difficult question. The IBM Knowledge Base is only accessible to IBM authorized VARs. This restriction has been discussed here and, for the most part, declared to be not in the best interests of the U2 product(s). The URL is: http://www-1.ibm.com/support/advsrch.wss?rs=203&rt=2 However, you need to contact your VAR to see if they'll give you access to the knowledge base through their access credentials, as most of the documents are "locked". The entire credential process is difficult for both users and IBM. Access to different business functions need a different set of credentials; so it becomes quite confusing to access U2 resources. Your VAR should be able to help you through this though. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: Wednesday, April 11, 2007 9:18 AM To: u2-users@listserver.u2ug.org Subject: Re: RE: [U2] VB.NET UniObjects Example Hi Colin, You wouldn't by chance have an URL to those examples would you? Thanks a lot! Greg >If you have access to the IBM knowledge base there are a couple of >example projects in there that will give you everything you need. > >hth > >Colin Alfke >Calgary Canada - Los Angeles this month > > > >From: schraibg > >Can anyone provide me with an example of how to add a new record to a >Unidata database file using VB.NET? > >I am using Uniobjects and am able to connect to the database but I >am unsure of how to go about doing record adds. The datafile has >several multi-value attributes (fields) so any examples showing >that detail would be great. > >I appreciate and help you can provide. > >Thanks, > >Greg --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] list files
:-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Monday, April 09, 2007 10:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] list files Outsourcing companies should make use of the following resource before accepting contracts for work they don't know how to do, then asking list members to do their work for them for free. *http://tinyurl.com/2trsr3 Regards, Clif Anita Panda wrote: > Hi, > I have connected . > > Thanks, > Anita --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Trying to run UniAdmin with PE`
Harold: First, you should probably uninstall UniAdmin and any other older U2 client software you have (unless you need it). Then reinstall the new version that comes with UV 10.2 (Try just installing UniAdmin first). Make sure you turn off your AV/Aspyware software first. I believe the most recent version of UniAdmin is 1.3. The reason you want to telnet to localhost is to verify UV is running, along with UV telnet on port 23 (the default port). I only have the same three services running on UV: + Resource Service + Telnet Service + UniRPC Service My "netstat" shows: C:\Documents and Settings\wphaskett>netstat -a | more Active Connections Proto Local Address Foreign AddressState TCPasibill:telnet asibill:0 LISTENING TCPasibill:31438 asibill:0 LISTENING TCPasibill:2940 localhost:31438ESTABLISHED C:\Documents and Settings\wphaskett>netstat -an | more Active Connections Proto Local Address Foreign AddressState TCP0.0.0.0:23 0.0.0.0:0 LISTENING TCP0.0.0.0:31438 0.0.0.0:0 LISTENING TCP127.0.0.1:31438127.0.0.1:2940 ESTABLISHED Port 31438 is the UniAdmin port. I've made a connection from my machine to UV on my machine via localhost. You should make sure UV is properly licensed as I've experienced the RPC service not responsive without proper licensing. The UV license I have is valid throuh 31 Mar 2008 (see UV control panel). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Thursday, April 05, 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trying to run UniAdmin with PE` Bill: Thanks for the hints! I can connect thru telnet localhost in DOS just fine. No other instances of U2 or other MV dbms. I have UniAdmin 1.2.0. Anyone know if that is current? No "Zone alert". Did not consider #4 below when installing Universe 10.2. I can type netstat -an and see TCP and UDP stuff, but I don't know what it means. What am I looking for? Defining the connection in UniAdmin to be "localhost" (it works at DOS) I continue to get the dreaded "No RPC connection active". Please, do you have the four services running? Or just 3 like I see: universe uvtelnet unirpc The older version I had of Universe had also this service: hsrexec I wonder if an older UniAdmin is looking for hsrexec and, of course, not finding it. Thanks to all who have sent in ideas. Harold -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H Sent: Thursday, April 05, 2007 9:15 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Trying to run UniAdmin with PE` A couple of things I'd look at: 1) Are you on a domain? 2) Do you have another instance of U2 or other MV dbms running? 3) Do you have an older version of UniAdmn installed? 4) Did you install UV with your anti-virus and/or anti-spyware software disabled? 5) Are you using Zone Alarm? 6) When you "telnet localhost" from a DOS window what happens? 7) What does the results of "netstat -an" show? I've installed UV, UD, and UniAdmin on my laptop numerous times and rarely had problems. The last problem was when I had UV 10.1 installed and it expired, thus causing UniAdmin barf. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Thursday, April 05, 2007 7:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Trying to run UniAdmin with PE` Brenda Price wrote: > I hadn't tried it use it for a while until last night. I am assuming > something I installed (Earthlink Total Access, or updates to Norton > security, or updates from Microsoft) after the last time I used > UniVerse UniAdmin has screwed it up. I get an error saying port 23 is > used by another program. This was the error that I was originally > getting before the motherboard and hard drive were replaced. Windows > telnet was disabled, just for grins I enabled it to see if that helped, it did not. You might want to check out "Active Ports", a windows application that will help you figure out what process is using port 23. Here's a link: http://www.download.com/3000-2085-10062969.html -- Allen Egerton aegerton at pobox dot com --- 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] Trying to run UniAdmin with PE`
A couple of things I'd look at: 1) Are you on a domain? 2) Do you have another instance of U2 or other MV dbms running? 3) Do you have an older version of UniAdmn installed? 4) Did you install UV with your anti-virus and/or anti-spyware software disabled? 5) Are you using Zone Alarm? 6) When you "telnet localhost" from a DOS window what happens? 7) What does the results of "netstat -an" show? I've installed UV, UD, and UniAdmin on my laptop numerous times and rarely had problems. The last problem was when I had UV 10.1 installed and it expired, thus causing UniAdmin barf. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: Thursday, April 05, 2007 7:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Trying to run UniAdmin with PE` Brenda Price wrote: > I hadn't tried it use it for a while until last night. I am assuming > something I installed (Earthlink Total Access, or updates to Norton > security, or updates from Microsoft) after the last time I used UniVerse > UniAdmin has screwed it up. I get an error saying port 23 is used by > another program. This was the error that I was originally getting > before the motherboard and hard drive were replaced. Windows telnet was > disabled, just for grins I enabled it to see if that helped, it did not. You might want to check out "Active Ports", a windows application that will help you figure out what process is using port 23. Here's a link: http://www.download.com/3000-2085-10062969.html -- Allen Egerton aegerton at pobox dot com --- 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] Trying to run UniAdmin with PE`
Harold & Kevin: I just installed UV 10.2 PE onto my local machine (but not the client). I already have the U2 UniAdmin v1.3 client on my local machine to access several UniData dbms servers. I opened UniAdmin and created a new server called "localhost" pointing to UniVerse. I then logged in using my local machine's user and password and everything displayed underneath it. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Oaks, Harold Sent: Wednesday, April 04, 2007 10:18 AM To: u2-users@listserver.u2ug.org Subject: [U2] Trying to run UniAdmin with PE` Looking for help - I have downloaded Universe PE 10.2, replacing an earlier version or PE. I am unable to get UniAdmin to connect despite many combinations of attempts. One thing I find curious is that, with the latest download, the number of services has dropped from four to three . and I wonder if this is somehow related. >From release notes in readme.txt, one can start the services from DOS, like so: net start universe net start unirpc net start uvtelnet net start hsrexec The last one does not work, claiming no such service. Universe Control also shows only the first three. Perhaps at 10.2 the last service is dropped deliberately (even if the notes don't reflect that). I don't really care, but I do want to run UniAdmin against the installed PE database to practice using it. My PC is networked on an NT network. I believe we use LAN manager. To start, one must define a connection in UniAdmin. One must fill in boxes for (1) Server Name (2) Transport Type (of course I click the Universe Radio button) I have tried "localhost()" for Server Name, the default 127.0.0.1 IP address which should mean the current PC, and my network IP address as well, and the specific string "localhost()" For Transport Type I have tried them all - Default, TCP/IP, and LAN manager Then, clicking on the created connection, I attempt to log in. One must enter (1) Login ID (2) Password The only combination I know is my NT login and password. I get one of two error messages: If I specify "localhost()" the error is "the host name is not valid, or the host is not responding". If I specify any one of the other connections, the error is "No RPC connection active". Any suggestions from anyone who has successfully gotten UniAdmin running against Universe PE is much appreciated. Thanks- Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 [demime 1.01d removed an attachment of type image/gif which had a name of Citrus Punch Bkgrd.gif] --- 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] Passing of Bruce Nichol - Talon Computer Services
RIP. :-( -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Sunday, March 25, 2007 2:55 PM To: u2-users@listserver.u2ug.org Subject: [U2] Passing of Bruce Nichol - Talon Computer Services I have just learned that Bruce Nichol of Talon Computer Services (Albury/NSW/Australia), a frequent contributor to this forum & long time "pick" advocate, has passed away. He will be sorely missed 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/
RE: [U2] Upper Case Only
Jeff: This thread is about __MORE__ than just the data! Kevin eloquently pointed out that some of the "old ways" in the U2 space need to be abandoned for more modern thinking. A certain perspective has survived here for years and this has spilled over into a number of areas where the U2 products have lagged behind in development. This seems to be changing, both with IBM's commitment and with this space's more recent thinking. The current state of affairs in U2 is case-sensitivity. This construct manifests itself negatively in myriad ways; data storage, command execution, indexing, searching, code production, etc, etc, etc. The current "work-arounds" only address one aspect or another of the problem; e.g. with an environment setting one can compile BASIC code in a case-insensitive mode (great - . What about the other negative aspects of case-sensitivity? There might be another "work-around" but the solution has not been engineered, and needs to be. Some may want to code in upper-case only. As far as I can see there's nothing wrong with this. But be reasonable; don't __FORCE__ me to do the same !! Most of this thread has addressed the inconvenience of forced-casing or the "it shouldn't bother anyone, get used to it" perspective. MV was designed to be a dynamic product; not constrained by the arbitrary constraints of other dbms products; which offers tremendous flexibility. But it's hard to describe the difficulties involved in manipulating strings at the application level for simple string searches. These difficulties become larger and larger with each technology one interfaces with (like the web). The solution is simple...give both U2 products the ability, at least to start with, to install as a case-insensitive product; granularity can be added. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: Friday, March 16, 2007 7:25 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Upper Case Only Different subject all together. I don't think anyone would disagree that there is a need to store (some) data in upper/lower case. The ongoing discussion has been about program source code, the 'consumer' of which is the machine itself who really doesn't give a hoot one way or another. Oh, and just because its Friday and therefore I'm in a particularly jovial mood has anyone anyone considered during this crusade that no matter how you write your source code it compiles to psudocode that is ALL UPPER CASE!!! :) Laura Hirsh wrote: > I think that the upper/lower case issue -- albeit not a show stopper for > anyone - is "much worse than that". > > Besides the "internal" back-n-forth about programming in basic, and what > case should be "current", I think that a bigger issue revolves around data > presentation and converting to a "modern" display and "modern" usage. > > For example, reports, mailing labels, "Dear John" letters... I mean, as a > programmer, I can use MCU - that works great, MCL - not as useful, but, > still works as documented. MCT? It's embarrassing. Dr. Mark Jones, MD is > almost impossible to return. Mark Jones III - allows me to send a "state of > the art" letter addressed to "Mark Jones Iii". > > SEARCH is another of my pet peeves. It should be *smart enough* to figure > out, or at least provide an option to be case insensitive. Maybe it does, > and I'm not aware. But it just always seemed crazy. So, I search - string? > "MARK JONES" then "Mark Jones" then "Mark jones" then "mark jones". > > BTREES? Although some may disagree, Mark Jones and MARK JONES are the same > thing - at least in our business environment. > > I think that if we want to work in a world that doesn't shout at us all the > time, then we need to look beyond how to write a basic program > > That's my $.02 (hey, what happened to the "cent" character... it used to be > there... I know it was... oh, maybe that was on the typewriters that didn't > allow lower case) > > Laura --- 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] Upper Case Only
Ron: Sorry for the misstatement...I'm running UniData. UniData is occasionally much less forgiving than UV (sometimes it seems the engineers enjoyed tripping up PICK people). :-o Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings Sent: Thursday, March 15, 2007 2:25 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Upper Case Only I was using pick as a generic term. I am currently working on an AIX platform running Universe with the pick flavor and the LIKE keyword works. My point was that it has to be in upper case unless you have really mucked up the VOC with extaneous synonyms. __ From: "Bill H" <[EMAIL PROTECTED]> Reply-To: u2-users@listserver.u2ug.org To: Subject: RE: [U2] Upper Case Only Date: Thu, 15 Mar 2007 12:02:10 -0700 Ron: In PICK mode there is no "LIKE" keyword. Comparisons use the normal "=", "#", etc operators. So your example should be: LIST VOC WITH @ID = "XREF]" AND WITH TYPE = "F" ...or LIST VOC = "XREF]" WITH TYPE = "F" (notice the upper-casing) :-) Hope this helps. Bill >Ron Hutchings wrote... > >Within the pick environment there is situation where you are forced to use >upper case: > >List Voc with @id like XREF... and with Type = "F" > >The interpreter won't recognize most of this statement. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Get a FREE Web site, company branded e-mail and more from Microsoft Office Live! --- 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] Upper Case Only
Ron: In PICK mode there is no "LIKE" keyword. Comparisons use the normal "=", "#", etc operators. So your example should be: LIST VOC WITH @ID = "XREF]" AND WITH TYPE = "F" ...or LIST VOC = "XREF]" WITH TYPE = "F" (notice the upper-casing) :-) Hope this helps. Bill >Ron Hutchings wrote... > >Within the pick environment there is situation where you are forced to use >upper case: > >List Voc with @id like XREF... and with Type = "F" > >The interpreter won't recognize most of this statement. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Upper Case and Editors
Arnold: One can only hope the more "experienced" engineers of the U2 products are listening. One "work-around" after another make life more difficult not less. In the 21st century a solution would be helpful. Case sensitivity is a "blight" on the landscape of computing perpetuated by systems whose history was written by two-fingured typists and engineering challenged equipment. Someone mentioned recently the "caps" limitations of "Prism" terminals, as though typewriters haven't been around since the beginning of the 20th century and, certainly, noone had ever learned to use such "contraptions". :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Arnold Bosch Sent: Thursday, March 15, 2007 12:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Upper Case and Editors [snipped] ...I find it annoying having to switch caps-lock all the time - what happens a lot is that I switch to another window and start typing away merrily, only to realise after a couple of words that everything is cASE iNVERTED, or that the help I'm trying to give to a user is not working because of case inversion. As to editing, having become accustomed over the years to the convenience of full-screen editors, and not initially knowing that it was possible to use a full-screen editor to edit BPs, it was a nightmare for me to get the simplest things done in UV. I think there are many other newbies out there that feels the same... [snipped] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Error in report generation.
An interesting test would be for those who love to upper-casing everything to try typing in their favorite word processor (where mixed casing is the norm) without looking at the screen and have one of their children keep pressing the "Caps Lock" key. If you manage to get frustrated, then you can begin to imagine how others, who know how to type, feel about this U2 style casing situation; which manifests itself in upper-case BASIC code. Remember, case-sensitivity precludes mixed-casing while case-insensitivity precludes nothing! With case-insensitivity we can both have what we want. I don't mind anyone living with case-sensitivity, I just mind others insisting, or demanding, I live with it too! Have a heart, will ya? :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Wednesday, March 14, 2007 6:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Error in report generation. I must be backwards because I actually find the second one easier to read and cleaner. And faster to type! Of course, I guess I'm one of the "old-timers", having been in multi-value for 25 years now. -Dianne [EMAIL PROTECTED] wrote: [snipped] >Loop > ReadNext Id From MYLIST Else >Fin = @True > End >Until Fin Do > ReadU CustomerRec From CUSTOMERS, Id Then > GoSub ProcessRecord > End >Repeat > >LOOP > READNEXT ID FROM MYLIST ELSE > FIN = @TRUE > END >UNTIL FIN DO > READU CUSTOMERREC FROM CUSTOMERS, ID THEN > GOSUB PROCESS.RECORD > END >REPEAT --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] unidata - setting unidata env on windows
Doug: I believe you can alter the "udtconfig" file in udthome\include (mine's in E:\IBM\ud71\include). You can also right-click on My Computer > Properties > Advanced tab > Environment Variables button and add what you want. You can also execute the command "set ENVIRONMENT_VARIABLE Value". The documentation indicates one cannot change environment variables for a session while in the session. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: Tuesday, March 13, 2007 9:39 AM To: u2-users@listserver.u2ug.org Subject: [U2] unidata - setting unidata env on windows Hey all, Does anyone know how to set an env. variable on unidata running on windows? (2003 server is the OS), I am trying to set the UDT_EDIT to allow us to use vi as the default editor Thanks! Dougc _ Doug Chanco Engineer Developer Senior, TLOTLD --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Sharing a network directory
Colin: Thanks! I'm getting success, with questions. :-) - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 2 Demo (0)-> AE VOC DTAWEB Top of "DTAWEB" in "VOC", 3 lines, 45 characters. *--: P 001: DIR 002: \\AsiOlyWaWeb\WebDev 003: D_VOC Bottom. *--: FI Filed "DTAWEB" in file "VOC". 2 Demo (0)-> LIST DTAWEB errno=2: No such file or directory can not stat() in U_get_fileid(),fname=\\AsiOlyWaWeb\WebDev. Open file error. 2 Demo (0)-> AE VOC DTAWEB Top of "DTAWEB" in "VOC", 3 lines, 30 characters. *--: 2 002: \\AsiOlyWaWeb\WebDev 002: \\AsiOlyWaWeb\E$\WebDev *--: fi Filed "DTAWEB" in file "VOC". 2 Demo (0)-> LIST DTAWEB ID-SUPP @ID_A LIST DTAWEB ID-SUPP @ID_A 18:33:21 Mar 09 2007 1 VOC... achdemo.html advantos advantos.NET aspnet_client DesignBais Logs sps WebExamples 8 records listed 2 Demo (0)-> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - First question is why am I getting directories listed here? I'd expect to only get one item listed (the "achdemo.html" file (item)). Secondly, why would I have to use the Window administrative "$" share reference? I explicitly "shared" the directory (gave it a "share" name the same as the directory), it works in DOS, what's up with UD? I've been under the impression UD handles this kind of thing easily. Since I'm not finding it easy at all I must be missing something critical. I've spent hours in the documentation and can't find anything on the IBM technical site. Not being able to access network shares from with UD is definitely causing problems. This brings up whole slew of questions regarding security. Am I able to write anything I want to anywhere I create a "path" VOC entry? Can I assume UD on NT runs under the administrator's credentials? Should I just blow off management of any security since it's so intertwined with the O/S? Any thoughts on this would be greatly appreciated. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2007 4:56 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Sharing a network directory Bill Try: Top of "DTAWEB" in "VOC", 3 lines, 51 characters. *--: p 001: DIR 002: \\AsiOlyWaWeb\E$\WebDev 003: D_VOC Bottom. In one of your earlier examples you had D_VOC in <3>. You need this to list the file. You could leave as is and still be able to edit files. If you do delete the file in UniData it will tell you that it is a remote file and remove the VOC item. It won't delete either the directory or the D_VOC. Hth Colin Alfke Calgary Canada --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Sharing a network directory
Colin: I stay away from domains as much as possible; it wrecks havoc on all kinds of software. The two machines (an IIS web server and a UniData dbms server) are on the same "workgroup", have the exact same administrator name and password (when I remote desktop in). "WebDev" is both the share name and the actual name of a directory in "E:" of the IIS Web server. When I open a DOS window on the UD server I can list the remote directory by using either path syntax: C:\Documents and Settings\myuser>dir \\asiolywaweb\webdev (or dir \\asiolywaweb\e$\webdev) Volume in drive \\asiolywaweb\webdev is Web Volume Serial Number is A4D8-DA0E Directory of \\asiolywaweb\webdev 03/04/2007 02:21 AM . 03/04/2007 02:21 AM .. 01/13/2003 01:16 PM 7,109 achdemo.html 03/08/2007 09:09 PM advantos 02/28/2007 12:42 PM advantos.NET 02/28/2007 12:42 PM aspnet_client 02/28/2007 12:41 PM DesignBais 02/28/2007 12:41 PM Logs 03/04/2007 02:21 AM sps 02/28/2007 12:41 PM WebExamples 1 File(s) 7,109 bytes 9 Dir(s) 121,820,229,632 bytes free C:\Documents and Settings\myuser> I modified the "DTAWEB" (VOC) item on the dbms and tried to list the contents. 2 Demo (0)-> AE VOC DTAWEB Top of "DTAWEB" in "VOC", 3 lines, 51 characters. *--: p 001: DIR 002: \\AsiOlyWaWeb\E$\WebDev 003: \\AsiOlyWaWeb\E$\WebDev Bottom. 2 Demo (0)-> LIST DTAWEB Open \\AsiOlyWaWeb\E$\WebDev error. Open file DTAWEB error. ...but excluding the "E$" in the path I get a different error from UD. 2 Demo (0)-> AE VOC DTAWEB Top of "DTAWEB" in "VOC", 3 lines, 51 characters. *--: p 001: DIR 002: \\AsiOlyWaWeb\WebDev 003: \\AsiOlyWaWeb\WebDev Bottom. 2 Demo (0)-> LIST DTAWEB errno=2: No such file or directory can not stat() in U_get_fileid(),fname=\\AsiOlyWaWeb\WebDev. Open file error. 2 Demo (0)-> I'm thinking there's something obvious I'm missing, maybe a UniAdmin configuration. Or maybe UD runs under different credentials, so there would be permission problems from inside of UD. Thanks, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 09, 2007 6:57 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Sharing a network directory Are the UD and web server on the same domain? I haven't been able to get it to work across domains (but I haven't tried really hard yet). It looks like webdev is a share name. Try something like \\asiolywaweb\c$\web\dev (or whatever the path is to the directory). If that doesn't work let us see what !dir \\AsiOlyWaWeb\WebDev gives you. Hth Colin Alfke Calgary Canada >-Original Message- >From: Bill H > >For the life of me I can't seem to get this to work in UniData. I >have... > >:AE VOC DTAWEB >Top of "DTAWEB" in "VOC", 3 lines, 30 characters. >*--: P >001: DIR >002: \\AsiOlyWaWeb\WebDev >003: D_VOC >Bottom. > >From Windows Explorer on the UD server I simply enter >"\\AsiOlyWaWeb\WebDev" >into the address field and I get everything listed from the web server >as I'd expect. But I can't get UniData (v7.1.9) to access the file. >All I get >is: > >:LIST DTAWEB >errno=2: No such file or directory >Open directory file DTAWEB error. >Open file error. --- 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] UD Sharing a network directory
For the life of me I can't seem to get this to work in UniData. I have... :AE VOC DTAWEB Top of "DTAWEB" in "VOC", 3 lines, 30 characters. *--: P 001: DIR 002: \\AsiOlyWaWeb\WebDev 003: D_VOC Bottom. >From Windows Explorer on the UD server I simply enter "\\AsiOlyWaWeb\WebDev" into the address field and I get everything listed from the web server as I'd expect. But I can't get UniData (v7.1.9) to access the file. All I get is: :LIST DTAWEB errno=2: No such file or directory Open directory file DTAWEB error. Open file error. : I tried to use the "net use Z: \\asiolywaweb\webdev password /user:asioywaweb/admin" command. DOS sees everything just fine. :!dir Z:\Advantos The system cannot find the path specified. : Any ideas what I'm doing wrong? I can't figure out why this doesn't work. Both the UD server and the Web server use the same "admin" user with the same password. Both directories ALLOW all the usual group of users access. Any help would be appreciated. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Printing PDF from UniData/AIX
Tom: Shouldn't this file be sent raw to the printer? I seem to recall I was working on signature fonts and was able to easily print the font to the printer in some kind of raw mode. I can't find my notes on the process but I think I used something like: lpr -PMyPrinter -bMyFont.spf This sent the job to the printer, raw, without any preprocessing. Maybe this is your issue. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Friday, July 01, 2005 1:09 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Printing PDF from UniData/AIX > > [EMAIL PROTECTED] wrote on 07/01/2005 5:53 PDT > > > Is there a way to print PDF files from AIX using a command from > > UniData? > > Troy Buss of Logitek Systems replied off-list on 07/01/2005 > 15:18:40 EDT: > > > As a one time setup, you can also print the PDF to the > printer using > > the correct windows driver but select 'print to file' and take the > > output file that would have gone to the printer and put it > in the AIX > > filesystem, then shell out (of unidata) and print the file using lp > > cat or some other aix command to send the file directly to the > > printer. > > I tried that. I did a binary ftp to put in /tmp, and > tried lp -d /tmp/. The escape sequences for > the PJL got stripped off, and I had to cancel the job. > > The printers are connected to the network JetDirect cards, > and some of them are old (e.g., HP 4+). I don't know how to > use cat to send data to an IP address, or I would have tried > that. Besides, my users specify an AIX form queue to have > documents print there - I can't change that end of the logic. > I need to be able to use the form queue name to determine > where to print it. > > Thanks for the suggestion, however. > > --Tom > --- > 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] Custom Functions
Ken: Ditto! :-) One might add faster and more stable triggers and built-in input timing. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis > Sent: Friday, June 24, 2005 6:04 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Custom Functions [snipped] > Anyway, I really don't want to go near the 'why buy UD instead of UV' > discussion...[snipped]... The only thing I will say before moving > quickly along is 'indexes'. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START & COMMIT/RO...
Clif: What distresses me about your comments is they are embedded with "should"s. There is no reason why &NEXT.AVAILABLE& style of counters "should not" be considered information; except that there are problems with the IT implementation of counters. There is no necessary accounting or auditing justification for such a position. Despite what has been suggested, an accounting transaction is not like a disk address. To think so is to conceptualize accounting using IT norms; thus a lot can get lost in translation. For those who aren't familiar with the subject of accounting, some major misunderstandings can occur when using IT analysis models. Valid counters are just tools, nothing more. If the counters don't exist, that just means less tools are available. To suggest additional tools are meaningless and "should not" be used is, well, need I say more. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Clifton Oliver > Sent: Thursday, June 16, 2005 11:55 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Best practice for Sequential IDs using > TRANSACTION START & COMMIT/RO... > > Yes, that was the point. A record counter contains no > information about the record; it is an arbitrary pointer to > the information. Our U2 (and other MV) databases do not > provide for a key that is, to use some SQL implementation > terms, AUTO_INCREMENT or INTEGER GENERATED AS IDENTITY. > So we fake it with a &NEXT.AVAILABLE& style of counter. These > should not be considered information, nor should they be used > to verify during an audit. Think of them as disk addresses in > the old sequential sector address scheme. Saying that > transaction key 12345 has meaning is about as meaningful as > an auditor saying, "Why isn't there a transaction record at > track 99AEF?" (Yes, I meant the double meaning of meaning in > that last sentence. This is English, a language that makes up > in obscurity what it lacks in style.) > > So I maintain that a sequentially assigned RECORD COUNTER, is > not something an auditor should ascribe any meaning to. In > fact, record ID's used in this manner should be able to > change from day to day, assuming referential integrity is > maintained; and the auditor should not have an issue with > that. It just a "disk address," after all. > > Control numbers, on the other hand, are a completely different issue. > Even though they may be sequentially assigned, they contain > information about the record. Check number was a good > example. These may be used as the key to a file. But the > absence or presence of a single record in a single file > should not be the sole auditing criteria. Just because there > is a record with key "2045" in the CHECKS file doesn't mean > squat. I could have put that record in there with the Editor. > Any auditor who simply accepts that the record "proves" check > 2045 was issued is the one to be flogged. Conversely, the > absence of record with key 2045 cannot be construed to mean > the check was not issued. I am not an accountant, but I think > this falls under the category of single entry vs double entry > accounting. > > That being said, we also need to recognize differences in the > term "audit." Accounting audits are different from > information system audits. So when we use the term "the > Auditors" we really should specify whether we are talking > about accounting audits with an emphasis on fraud or > information systems audits with an expanded scope of correctness. > > As always, just my opinion. > > Anyone want to discuss why most MultiValue systems don't know > the concept of check digits on control numbers as a way to > assist in information correctness? > > > -- > > Regards, > > Clif > > ~~~ > W. Clifton Oliver, CCP > CLIFTON OLIVER & ASSOCIATES > Tel: +1 619 460 5678Web: www.oliver.com > ~~~ > > > > On Jun 16, 2005, at 12:50 PM, Drew Henderson wrote: > > > I would think the key phrase is "non-information content". > Sequential > > numbers that have meaning, such as check numbers, would not, in my > > mind, fall under this category. Sequential numbers used > for assigning > > ids to people, however, would likely fall into this category. > > > > Of course, a lot of it depends on the organization's use of that > > number, as to whether it is informational or not. > > > > Drew > > > > Bill Haskett wrote: > --- > 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: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
David:
Remember, with an unlimited user CPU license there is no requirement for
pooling; as the connections don't run up against any licensing restrictions.
Bill
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan
> Sent: Monday, April 25, 2005 8:11 PM
> To: u2-users@listserver.u2ug.org
> Subject: RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ
> Series] {Unclassified}
[snipped]
> RedBack does more than provide a pooling mechanism it also
> handles scheduling, performance monitoring, status and other
> facilities one would require for a pooling application which
> is all included in the price.
>
> With an SQL Server application, one would have to add that
> functionality into the design of the client server
> application which RedBack looks after for the developer.
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
Craig:
Your right. I think you can get a webshare site license for $15,000 -
$20,000. But this doesn't help when you want to provide web services to
multiple clients who have our software on each of their machines because
RedBack is licensed at the dbms end not the web server end. :-(
Bill
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett
> Sent: Monday, April 25, 2005 5:00 PM
> To: u2-users@listserver.u2ug.org
> Subject: Re: [Fwd: Re: [U2] IBM Licensing Requirement - MQ
> Series] {Unclassified}
>
> Bill,
>
> > If I figure correctly, a hundred webshares cost $150,000 at
> $1,500 per
> > webshare retail!
>
> my understanding is that each webshare can service 20-25
> users and once you buy a certain number of webshares (my
> memory says 11, but I could be
> wrong) you are treated as having an unlimited number of shares.
>
>
>
> Craig
> ---
> 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: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
Cliff: > With SQL Server, you also need one or two CAL's (Client > Access Licenses) per named user (not concurrent). Plus I > believe the more full-featured server versions are more > expensive on the server side. A quick look on Google and you'll find an SQL Server Enterprise for $2,000 - $5,000. This product is very inexpensive. It is an unlimited client/device licensing model for a defined number of CPUs. Here's a pretty good whitepaper from Microsoft about the various costs associated with SQL Server, Oracle, and DB2. http://download.microsoft.com/download/1/0/a/10adfeca-48f4-4d89-949a-04167d6 54b40/SQL_UnderstandingDBPricing.doc This gives a small example of a price comparison: Tier Features Sample ProductsPrice Free Limited database Microsoft SQL Desktop $ 0 functionality, Memory Engine (MSDE) Limits, database size limits, etc. Basic Basic database function- MS SQL Server WkGrp Edition$ 500 - ality, Basic security Oracle Std Edition One 5,000 Up to 2 CPUs DB2 Expressper CPU StdFull database function-MS SQL Server Std Edition $5,000 - ality, Basic ManagementOracle Std Edition 15,000 Tools, Up to 4 CPUs DB2 WkGrp Edition per CPU Enterprise High availability MS SQL Server Enterprise $20,000 - Scalability Oracle Enterprise 40,000 High-end mgmt tools DB2 Enterprise per CPU Enterprise security No CPU limit As you can see a basic dbms access model over the web costs about $500 - 5,000 per CPU ! A full featured standard model costs about $5,000 - 15,000 per CPU. Of course, Microsoft products can be purchased from other vendors other than from Microsoft so significant discounts are available. In the above referenced paper, Microsoft also talks about additional costs such as support and service packs. Very interesting reading. > I am confident IBM is well aware of MS SQL and Oracle server > and client DB licensing models since DB2 plays in the same space. And they've begun playing. I know way too many people using SQL Server in the small to medium business end of the market to accept the notion that Microsoft stinks. From what I learned it is excellent software at a great price. In fact, I've started using it myself for some conversions we're doing on our application. Now all we have to do is get the U2 products priced reasonably and all the software mvDbms developers have developed over the years can be exposed over the web. :-) Bill > ...Bill H. wrote: > > > If I figure correctly, a hundred webshares cost $150,000 at > > $1,500 per webshare retail! > > > > Let's see...SQL Server unlimited site license (single CPU) > > for $5,000. Sounds like this is an invitation to get off > > the U2 products...or do I have this completely miscalculated? > > > > Bill > > > > > >>-Original Message- from Leroy Dreyfuss > >> > >>The answer here is RedBack. It is designed for exactly this > >>purpose. > >>We have customers servicing millions of requests per day on > >>a hundred or less Webshares. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [Fwd: Re: [U2] IBM Licensing Requirement - MQ Series] {Unclassified}
If I figure correctly, a hundred webshares cost $150,000 at $1,500 per webshare retail! Let's see...SQL Server unlimited site license (single CPU) for $5,000. Sounds like this is an invitation to get off the U2 products...or do I have this completely miscalculated? Bill > -Original Message- from Leroy Dreyfuss > > The answer here is RedBack. It is designed for exactly this > purpose. We have customers servicing millions of requests per > day on a hundred or less Webshares. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] color laserjet pcl programming for logos
Troy: What about switching to HP-GL/2 mode then use that language to manage graphics? e.g. PRINT CHAR(27) : '%0B' (that's a zero not an upper-case oh (O)) ...print the HP-GL/2 commands PRINT CHAR(27) : '%0A' (again that's a zero.) Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Buss, Troy (Logitek Systems) > Sent: Thursday, April 21, 2005 11:58 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] color laserjet pcl programming for logos > > Hi ALL: > > I have some forms that print to HP printers using standard > PCL formatting codes. > > We now have a requirement for certain areas to be in color > and I'm having a problem getting my PCL codes correct for > printing on an actual HP (or compatible) printer. > > I'm using the following PCL commands within a basic program: > > * r -3 U select simple cmyk color palette > * v 3 Sselect blue foreground color > > This code works correctly when I run the output through visual > software's PCL to PDF converter. I get my graphics and my selected > text in blue. > > However, when I print direct to the printer, I get a lot of > the logo in blue, but rectangular portions of the logo in > black as if the raster portions are ignoring my color selection. > > Just wanting to know if someone else out there has > successfully implemented PCL coloring. > > Using postscript on these printers is not an option since I'm > already using PCL to generate all the other formatting. > > Thanks! > > -Troy > --- > 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] MvInternet - IBM Licensing Requirement
Somehow or other this thread points out issue(s) mvDbms vendors need to come to grips with. I got onto google and entered "SQL Server site license" and picked the first link I saw and found out I could get a single processor SQL Server Standard license for $3,500 (or a single processor SQL Server Enterprise license for $7,500). To me this means I get an unlimited user SQL Server license for a single processor for $3,500 (or $7,500 if I'm interested in some advanced analysis features). This is specifically offered for e-commerce applications. It's often been pointed out that the mvDbms products are waay too expensive by comparison. This thread has wildly speculated about possible "heavy handed" action by IBM in order to continue to overcharge users for U2 products. At this rate there won't be any U2 users left. I don't believe anyone is trying to "cheat" IBM here (and IBM knows it). Developers are just trying to compete. This is good; for developers and for IBM. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan > Sent: Monday, April 18, 2005 5:38 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] MvInternet - IBM Licensing Requirement > > >I have not > >heard of a single legal case in the IT world, not just the > MV market, > >brought by a DBMS vendor against a VAR/developer for abuse of this > >common communications design. I think any company that does > so would > >be committing political suicide, if it allowed its developer > base to go > >so long without action, and then all of a sudden claimed > that accepted > >practices and established connectivity products were now in > violation > >of their legal terms. > > I am aware of Microsoft doing this. It has done software > audits on even large organisations and clobbered then for > breaches on SQL Server license. > Oracle and IBM have stringent components of their contracts > to enable them to do audits. I have had to sign distributor > contract with IBM and it stated that they were entitled to > investigate my client's sites to ensure that they have proper > licenses. > > As the pressure is on the IT vendors to build revenues and IT > spending is down, then sooner or later vendors are going to > chase licensing issues to recover revenue. > > > >Unless IBM publicly states their position on this topic, takes a > >developer to court, or just sends a polite "please rethink > your license consumption" > >note to someone, we will not know how liberal they are about their > >licensing, regardless of what their license actually says. > My guess is > >that no DBMS company will take action unless there is blatent abuse > > It is in the licensing contract and a breach of license can > lead to criminal charges to Directors. Under SOX one cannot > ignore this because one thinks it is unlikely to happen. IBM > U2 is not ignoring this area and has already placed > restrictions in the use of phantoms to contain this manipulation. > > > Additionally: > The examples you give are not the main issue that causes a > breach. There are a number of applications where users > connect and stay connected but through a 3rd party mechanism > that channels tasks through one license to the backend that > then distributes to multiple background processes. The > intent of this process is not application convenience or > style but more an attempt to avoid license fees and many > advertise this. It is this avoidance of license revenue that > can expose companies legally. > > I have discussed this issue with both jbase and MvOn as their > products talk to Oracle or SQL Server and falls into a > similar category where you really only have 1 process > accessing the RDBMS, independent of the number of users on > jBase or MvOn. Both organisations have very quickly pointed > me to Oracle and Microsoft to discuss licensing issues and > neither would publicly recommend that companies run using 1 > license of Oracle or SQL Server. This is very much on the > radar of database vendors. > > Regards > David Jordan > --- > 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] Multiple OPEN statements
Mark: I would say this is legitimate if one is reading from, or opening, a prioritized list of files. For instance, say I want to get a configuration parameter and want to: READ ParameterValue FROM ParameterFile.Fv, ParameterId THEN...ELSE... This parameter can come from any of several files already prioritized, say: LOCAL_PARAMETERS GLOBAL_PARAMETERS Then one might: OPEN 'LOCAL_PARAMETERS' TO ParameterFile.Fv ELSE OPEN 'GLOBAL_PARAMETERS' TO ParameterFile.Fv THEN...ELSE... END Just a thought. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson > Sent: Friday, April 15, 2005 7:00 PM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Multiple OPEN statements > > Call me old-school but I prefer top-down OPEN file TO handle > ELSE STOP (sic) to get them all out of the way. Whether 1 or > 50 files, the get all opened at the same time. If those > choose to have a CALL OPEN.FILES internal sub or named > commons, then that's also a respectable method. > > To have the main portion of the code be that indented only > makes maintenance later that much more difficult. Very, very > few people seem to label their END statements to indicate > what they're matched to. > > Upon further investigation (using that programmers initials) > i found that when there were 8 or more file, he did it in a > more top-down or sequential fashion. That introduces 2 forms > of coding for the same concept which is 1 form too many. > > That programmer is still at this client and uses the tired > response "That's what I was taught" when shown how hard it is > to follow all of those indents. > Can't teach an old dog... > > my 1 cent > - Original Message - > From: "Jerry Banker" <[EMAIL PROTECTED]> > To: > Sent: Friday, April 15, 2005 10:36 AM > Subject: Re: [U2] Multiple OPEN statements > > > > - Original Message - > > > From: "Don Kibbey" <[EMAIL PROTECTED]> You did mention > only a few > > > files display this type of syntax. Perhaps said programmer was > > > shown the door > > > > I don't see why you would think that and frankly I'm surprised you > > haven't come across this style of programming before. This style of > > programming > was > > taught in classrooms all over the country before the advent > of point > > and click programming. It is a structured way of > programming based on > > a logic > > sequence: > > What is the first file I need? > > OPEN FILE1 TO F.FILE1 THEN > > END ELSE PRINT "CAN'T OPEN FILE1" > > END > > > > Do I need another one? > > OPEN FILE1 TO F.FILE1 THEN > > OPEN FILE2 TO F.FILE2 THEN > > END ELSE PRINT "CAN'T OPEN FILE2" > > END ELSE PRINT "CAN'T OPEN FILE1" > > END > > > > And another? > > OPEN FILE1 TO F.FILE1 THEN > > OPEN FILE2 TO F.FILE2 THEN > > OPEN FILE3 TO F.FILE3 THEN > > END ELSE PRINT "CAN'T OPEN FILE3" > > END ELSE PRINT "CAN'T OPEN FILE2" > > END ELSE PRINT "CAN'T OPEN FILE1" > > END > > > > Now that I've got these open what do I do with them> OPEN FILE1 TO > > F.FILE1 THEN > > OPEN FILE2 TO F.FILE2 THEN > > OPEN FILE3 TO F.FILE3 THEN > > EOF=0 > > LOOP READNEXT ID ELSE EOF=1 UNTIL EOF DO > > PROCESS, PROCESS, PROCESS > > REPEAT > > END ELSE PRINT "CAN'T OPEN FILE3" > > END ELSE PRINT "CAN'T OPEN FILE2" > > END ELSE PRINT "CAN'T OPEN FILE1" > > END > > > > Although when the gosub came out most programmers took the > center out > > and put it into a separate subroutine. > > --- > > 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] [UV] Equivalent of UD's UV_RESTORE? (Unclassified)
As a side question: why are companies migrating from UniData to UniVerse, or from UniVerse to UniData? Obviously, there are enough who migrade from UV to UD since they already have a tool for such. Now it seems enough are migrating from UD to UV because they too have a tool. :-) Thanks, Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > HENDERSON MIKE, MR > Sent: Monday, April 04, 2005 8:22 PM > To: u2-users@listserver.u2ug.org > Cc: Leroy Dreyfuss > Subject: FW: [U2] [UV] Equivalent of UD's UV_RESTORE? (Unclassified) > > But wait, there's more ... ;-) > > There may be no obvious reference in the 10.1 PDF's', but I > found a reference in the "U2 Survival Kit 2003" [it doesn't > seem to be in the > 2004 edition] > It's actually in the Informix "UniVerse Technical Bulletin Part No. > 74-0108 Converting UniData Files to UniVerse Files" > > > LeRoy, maybe there could be a new Appendix "Converting > between UniVerse and UniData" to the Admin manual for both > products? Or somewhere. > > > > Mike > > > -Original Message- > > From: HENDERSON MIKE, MR > > Sent: Tuesday, 5 April 2005 11:52 > > To: 'u2-users@listserver.u2ug.org' > > Subject: RE: [U2] [UV] Equivalent of UD's UV_RESTORE? (Unclassified) > > > > Ken, > > > > "udtconv.exe" is in %UVpath%\bin\ on my Win2K3 server. > > > > "udtconv ?" gives the 'documentation' Doug showed. > > I guess it's another undocumented utility, there's no obvious > > reference to it in the UV10.1 PDF's that I can find > > > > > > HTH > > > > > > MIke > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis > > Sent: Tuesday, 5 April 2005 10:31 > > To: u2-users@listserver.u2ug.org > > Subject: RE: [U2] [UV] Equivalent of UD's UV_RESTORE? > > > > Doug Miller wrote: > > > > > Ken Wallis wrote: > > > > > >UniData has a tool specifically for restoring UniVerse data > > > >- uv_restore, > > > >does UniVerse have an equivalent for sucking in UniData files? > > > > > > Just what the doctor ordered... > > > > > > Unidata File Conversion > > > A new utility, udtconv, has been created to ease the task > > of migrating > > > from Unidata to UniVerse. > > > > Excellent Doug, but what is your source document? I just > downloaded > > the entire UV 6.1 documentation zip and searched it for any > mention of > > udtconv, but found nothing! > > > > Cheers, > > > > Ken > > --- > > u2-users mailing list > > u2-users@listserver.u2ug.org > > To unsubscribe please visit http://listserver.u2ug.org/ > > > The information contained in this Internet Email message is > intended for the addressee only and may contain privileged > information, but not necessarily the official views or > opinions of the New Zealand Defence Force. > If you are not the intended recipient you must not use, > disclose, copy or distribute this message or the information in it. > > If you have received this message in error, please Email or > telephone the sender immediately. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2]: Epicor
Don: There are a number or current laws and regulations that attempt to rid public corporations of this kind of mismanagement. The result of these new regulations may not so much be the reduction of corporate financial and IT mismanagement, but the transfer of responsibility to lower level staff. :-( It may come to pass that you'll be held personally liable for someone else's indiscriminate "business requirements". For those of us who think it is our role to provide others with the ability to trash the integrity of the organization's financial information; a rude awakening awaits! Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey > Sent: Wednesday, March 16, 2005 9:15 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2]: Epicor > > Our resident "Bean Counters" have asked for and received > several tools from me that will allow them to do the same > thing to our system. It's our job to provide the "sharp > knives", the CPA types have to be carefull not to remove > appendages with said tools. > --- > 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]: Epicor
Marc: It is possible that this sort of data movement is precisely the reason financial information, at numerous companies, is difficult to attest to, let alone use for analysis. :-) When I see this "benefit" (capability), red flags go up all over the place. It's like giving a gun to children...most will be ok but someone __WILL__ get hurt. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marc Harbeson > Sent: Tuesday, March 15, 2005 8:41 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2]: Epicor > > Being a Manage-2000 client, and having been an Oracle client > in the past > (10.x) and having seen a JD demo I must say of the t1 > suppliers, they did put on a nice show. (They could export > directly to excel, change data, and re import the data back > into the erp) > > :-) > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Lettau, Jeff > Sent: Tuesday, March 15, 2005 10:55 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2]: Epicor > > So maybe Advante, Dataflo, infoflo, M2K and the like are not > tier 1 multi-million dollar installs. But for ease of use > and the ability to tweak the system to meet your needs. I'll > take the tier 2 any day. > > Not intending to start an argument, but what can SAP or JD > Edwards do that the smaller Epicor products can't do? What > makes them worth the added cost? I don't' buy into that they > can handle more users. That is mostly a matter of database > management, hardware and infrastructure. > You also have to consider who is buying what system and what > their intensions are. What do you really get out of a > standard SAP or JD Edwards install that you can't get from > any system provided by Epicor or similar smaller priced > package? I'm not being rhetorical.(again spell checker saves > the day, I didn't know a word could start with rh.) > > P.s. you can get the Monitor Series at a Circuit city store > or other high end audio stores near you! You can't seriously > expect me to send you something for free! I can't get stuff > for free. > > Jeffrey Lettau > ERP Systems Manager > polkaudio > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Debster > Sent: Tuesday, March 15, 2005 12:50 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2]: Epicor > > Yes...and I was privy to M2K back when it went through ADP > doors and was sold back out again > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Allen > E. Elwood > Sent: Monday, March 14, 2005 4:27 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2]: Epicor > > > I believe that Jeff was speaking about Manage-2000. Polk > audio, in addition to making great speakers, is a Manage-2000 > user. Now if I could just get them to send a couple of > studio monitors my way for the plug. ;-) > > When I was working for M2k under ROI Systems, there were > several companies that choose it over JD, SAP as well as Epicor. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Monday, March 14, 2005 12:39 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2]: Epicor > > > X-Squeeze me > > But comparing Avante to JD Edwards & Sap is like putting a > 2.5 foot T-ball player up against Derek Jeter..its not in the > same league > > Avante is not a tier 1 no matter how much you would like to > think that its playing with the big boys... > > -- > Debster > > -- Original message -- > > > There are a few Epicor people that do read this list. They just tend > to > > lay low unless the discussion effects them directly. > > I can say a that there are a few people still in the > Manage-2000 group > > that are very good with the interfaces to U2. > > From my past experience with Epicor, they are a very good > company for > > support, and regardless of how many developers you have, there will > > always be bugs in the software that require patches. Many > times these > > bugs are not evident due to the fact that everyone will use the > software > > slightly different. > > I think their long term plan is to take the many packages they have > and > > migrate them all into one package that is all inclusive and > database > > independent. Although making it database independent may be counter > > productive to their plan on consolidating the software packages. > > > > If you look at who the other choices are for software, I'd > say Epicor > > is still one of the top choices. Especially when you consider the > > flexibility needed in dealing in a manufacturing > environment. What are > > your other choices? JD Edwards? SAP? > > They are also trying to focus on integrating all of their other > packages > > together into a complete solution. Kind of like cross > selling. I
RE: [U2] [UV] "non-numeric" error after passing (ANS MATCHES '0 N' & ANS>0)
I ran this on D3 (flashed and unflashed).
:bptest $options ext ; ans = str('1',1024) ; if ans matches '0N' then crt
'Yes' else crt 'No' ; ans = '':char(253) ; if ans matches '0N' then crt
'Yes' else crt 'No'
BpTest*323682190
.
[820] Creating FlashBASIC Object ( Level 0 ) ...
[241] Successful compile! 3 frame(s) used.
Yes
No
Am I to understand this is not the same on UniVerse/UniData?
Bill
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unique Ids
Dave: Since D3 can be case-insensitive, it's possible to: 1) Create an item in (VOC) named "Joe" 2) Edit an item named "JOE", which is the item "Joe", and file it. So, from a certain perspective, one could say that D3 allows an item named "JOE", "JOe", "joe", "jOE", etc to share the same record key of "Joe"; therefore, there are duplicate record keys. Did I say this right? :-) Bill P.S. I've been working with some ODBC stuff lately and really have to do the "shake" to get data to come out ok. I guess the SQL crowd doesn't care of the general illogic of it, just that regular people can't use the tools. Job security is not all bad. :-) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > [EMAIL PROTECTED] > Sent: Tuesday, March 08, 2005 12:26 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Unique Ids > > Susan, > > This is the approach I took with the speaker. There was a > period of time 'in the good old days' where the has could go > goofy either through corruption or keys containing system > delimiters .. > > But as the speaker (supposidly with the same term of > experieince as I) was teaching the benefits of MsSql Server > and the wonders of sql .. > > DSig > David Tod Sigafoos > SigsSolutions, Inc. > > > > Original Message > > Subject: Re: [U2] Unique Ids > > From: "Susan Lynch" <[EMAIL PROTECTED]> > > Date: Tue, March 08, 2005 11:54 am > > To: u2-users@listserver.u2ug.org > > > > I don't recall an MV implementation that intentionally allowed > > non-unique primary keys. Were the people in the meeting > thinking of > > secondary keys (aka indexes) in which non-unique keys are > quite possible? > > > > The only other thing I can think of would be the old (and > > non-intentional!) problems with traditional native Pick in which a > > group in overflow could have one of the linked frames > written back to > > disk and another linked frame in the group not written back to disk > > (eg. during a system crash), in which case a record which shifted > > position in the group could end up in both frames, and thus in the > > group twice. In order to get rid of one of the two, we > used to edit > > that record in the file, which would bring up the first one in the > > group - look at it to see if this is a complete and > up-to-date version > > of the record and either save it to move it to the back end of the > > group or delete it if it was obviously a damaged or > partial copy. If > > we did not delete that record, we would then edit the > record with that > > key again, which would bring up the one that used to be > second and was > > now the first in the group, and decide which one to keep. > I haven't > > seen this on a UD system, due to the way that the keys are > stored in a > > table at the beginning of the group, and I don't recall > having seen it > > on the UV system that I managed for a few years, but I did > see it a lot in the earlier days in Pick. > > > > Susan Lynch > > F.W. Davison & Company, Inc. > > > > - Original Message - > > From: <[EMAIL PROTECTED]> > > To: "U2 Users List" > > Sent: Tuesday, March 08, 2005 1:37 PM > > Subject: [U2] Unique Ids > > > > > > > I just came out of a meeting where it was stated that MV > databases > > > allow non-unique keys. > > > > > > Now I have been working in the VM world since 1983 and although I > > > can remember a time when some of the implementations had > 'problems' > > > with hash and specific data in keys .. i can not think of a time > > > when MV tables allowed non-unique keys. > > > > > > 'Say it aint so Joe' .. > > > > > > If anyone knows of any implementation which specifically allows > > > non-unique ids .. please let me know .. show me the > light. Have I > > > be in the back room eating twinkies too long? > > > > > > thanks > > > > > > DSig > > > David Tod Sigafoos > > > SigsSolutions, Inc. > > > --- > > > 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] wintegrate query builder question
Kevin: Try sending it to the "Report Viewer" first then export it from there. I think this will be easier. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Kevin Michaelsen > Sent: Friday, February 18, 2005 6:11 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] wintegrate query builder question > > > I'm an end user and I've developed some queries using Query > builder. I been > able to get the queries to the screen but I now I want them to be placed > into an Excel spread sheet. When I select my output to go to the > pc/process > and select the program to be excel and I fire my query. I get a error > window "QueryImport to PC failed Invalid Fields". Any clues to > why this is > happening? Can anyone give me places an end user can check. I'd like to > speak with some confidence before I bring it up with my overly > strapped IT > department. Any help would be appreciated. > > Kevin > --- > 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] uv pe
Adrian: I recently saw a Dell add where they partner with Oracle and one can purchase an Oracle license for about $150/license. Don't know how that works out in a web environment or a "device licensing" scenario but that's not anywhere near as expensive as it used to be. Also, Microsoft SQL Server can be had for about $5,000 (or less) for an unlimited license on a single processor. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews > Sent: Thursday, February 17, 2005 2:26 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] uv pe > > > Yes but how much does it cost to license Oracle and Access for a Live > environment? > > > > > > From: [EMAIL PROTECTED] on behalf of Phil Walker > Sent: Thu 17/02/2005 01:17 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] uv pe > > > > Hi, > > Microsoft and Oracle both GIVE away, yes I said give away > versions of their > database products, and they both interact easily with modern gui/web based > development environments, and you can search HUGE knowledge bases of > information about how to do something. > > I know people in this group think U2 is the greatest, but that > does not make > it necessary to lock it up like the crown jewels. > > Questions: > > Why can't end users access the knowledgebase? > Why isn't their developer versions of the U2 products, as it is the > developers you generate UV license sales, not IBM? > > I can pay $900.00 NZD per year, and get a copy of MS Sql Server 2000, MS > Exchange, MS SBS, 10 CALS for MS Professional XP, 10 CALS for MS Office > 2003, Sharepoint Portal, MS 2003 Server, MS 2003 Web Edition all > to use for > demos or in house to run my business. > > Some people may wonder why you would develop something in U2? > > Cheers, > > Phil Walker > +64 27 5336294 > +64 3 3120352 > [EMAIL PROTECTED] > Gnosys Consulting Limited > 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury > 8252, NEW > ZEALAND > DISCLAIMER: This electronic message together with any attachments is > confidential. If you are not the intended recipient, do not copy, disclose > or use the contents in any way. Please also advise us by return > e-mail that > you have received the message and then please destroy. Gnosys Consulting > Limited is not responsible for any changes made to this message > and / or any > attachments after sending by Gnosys Consulting Limited. We use virus > scanning software but exclude all liability for viruses or > anything similar > in this email or any attachment. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood > Sent: Thursday, February 17, 2005 12:20 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] uv pe > > I never thought I'd see grown people complaining that they hadn't gotten > their free stuff soon enough. > > As in *free* > > *No charge* > > As in if you complain *TOO MUCH* maybe they'll start charging $100.00 for > it.PER YEAR. > > You wanna know how much software I give away for free? Ok, maybe > one little > SUBR dict program using an index to retrieve data from a file with a > different id, but that was it! > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of John Kent > Sent: Wednesday, February 16, 2005 14:19 > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] uv pe > > > What a joke Leroy > > I cant get access to Tech connect as we get our universe licenses > through a > master var > This annoys us plus our client sites with inhouse programmers > > Its hard to defend IBM when they treat you like this > > jak > - Original Message - > From: "Leroy Dreyfuss" <[EMAIL PROTECTED]> > To: > Sent: Wednesday, February 16, 2005 4:05 PM > Subject: RE: [U2] uv pe > > > > They are coming. We haven't broken any promises. The quarter is > only half > > over. > > > > I would have thought a fair number of you folks would have downloaded > > earlier versions by now as they were on the U2TechConnect Website for a > > couple of years. We know you all want the latest and greatest > features we > > have to experiment with, and you'll have them with just a > little patience. > > Because they are free evaluation copies, we are required to > package them a > > bit differently, and the U2 group was not the only group involved in the > > process. We, too, had to wait. > > > > They are nearly ready to be placed on the Web again, and we do > regret the > > time it has taken to get this far. We will be sure to announce their > > arrival as soon as they are ready. > > > > Thanks again for waiting. > > > > > > Regards, > > > > LeRoy F. Dreyfuss > > Product Manager > > IBM UniVerse and UniData (U2) Extended Relational Databases > > IBM Information Management Software > > Tel: 303-672-1254 Fax: 303-294-4832 > > Mobile: 720-341-4317 Tie-line: 770-1254 > > External email: [EMAIL PROTECTED] > > W
RE: [U2] uv pe
Phil: Although this is a U2 specific list, the same pricing problem exists with ALL mvDbms products. In addition knowledge seems to be locked up and there are so many proprietary solutions to simple problems. Developers often have to pull teeth to solve some basic problems. Every business problem requiring an mvDbms solution seems to entail a steep learning curve (kind of like Linux and networking). Since the mvDbms vendors aren't interested in long-term revenue but in short-term profits I doubt whether this will change. So, in the long-term we'll all have to migrate off of the dbms (or die first). :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Phil Walker > Sent: Wednesday, February 16, 2005 5:18 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] uv pe > > Questions: > > Why can't end users access the knowledgebase? > Why isn't their developer versions of the U2 products, as it is the > developers you generate UV license sales, not IBM? > > I can pay $900.00 NZD per year, and get a copy of MS Sql Server 2000, MS > Exchange, MS SBS, 10 CALS for MS Professional XP, 10 CALS for MS Office > 2003, Sharepoint Portal, MS 2003 Server, MS 2003 Web Edition all > to use for > demos or in house to run my business. > > Some people may wonder why you would develop something in U2? > > Cheers, > > Phil Walker > +64 27 5336294 > +64 3 3120352 > [EMAIL PROTECTED] > Gnosys Consulting Limited > 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury > 8252, NEW > ZEALAND --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe/Linux Performance Issue
Anthony: Can you comment out the "WRITE" and replace with a "RELEASE" in the update code. This should identify the problem to either reads or writes. Next, try deactivating the indexes then rerun the update. This should isolate the indexing code and identify/eliminate it as an issue. Hope this helps a little. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Anthony > Dzikiewicz > Sent: Monday, February 14, 2005 8:21 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] Universe/Linux Performance Issue > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Scott > Richardson > Sent: Monday, February 14, 2005 9:51 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] Universe/Linux Performance Issue > > > Moving/Editing a parameter in uvconfig is only a small step in process > of making that change active in your systems actively running uv. Simply > editing the uvconfig file itself does not dynamically change the > currently running uv. > > You'll have to re-generate, or build, UV after making those changes, and > that, of course will require uv being stopped, and restarted after the > new parameter changes being made in the uvconfig file. Please consult > the appropriate official UV documentation for details on how to do this, > or ask for assistance from a consultant if you're not comfortable with > these types of things. > > --- > This much I do know an have done. Somethings read are understandable in > theory, but what they really do is sometimes another thing in the real > world. Experience is everything. > > > If you make any Linux kernel parameter changes, same concept applies: > you'll need to rebuild the Linux kernel and reboot for those to take > affect. Again, if not comfortable here, well worth having a consultant > come in for a few hours and help you with both tasks, and you could take > notes and learn, in case you need to tackle such tasks again in the > future. > > --- > No Linux changes are required. Linux works and doesn't seem to be the > issue > --- > > > As for file sizing - just becasue those files have always been about > that size, and always been Dynamic, doesn't mean that they're correct. > Again, if not comfortable, ... > > -- > Remember that I also said that we were on DG/UX and it always handled > this with no problem. My feeling is that the particular version of > Universe for DG/UX might have been tweaked a little. One time when I > was up at the DG benchmark lab in Marlboro, MA, I was told that they had > source code for Universe and had made some changes that had to do with > posix compliance. So, Im guessing that maybe the DG version > multi-threaded this a little better. > --- > > > I'd suggest the FAST File Sizing tool/application from Fitzgerald & > Long. > > It could be that the overhead of Dynamic Files in your situation may not > be worth the benefit, especially if those files are not growing over > time. Actual Mileages can and do vary here, of course. > > HTH! > > - Original Message - > From: "Anthony Dzikiewicz" <[EMAIL PROTECTED]> > To: > Sent: Monday, February 14, 2005 9:31 AM > Subject: RE: [U2] Universe/Linux Performance Issue > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Scott > > Richardson > > Sent: Monday, February 14, 2005 8:31 AM > > To: u2-users@listserver.u2ug.org > > Subject: Re: [U2] Universe/Linux Performance Issue > > > > > > In addition to what Trevor mentions, you may want to have a look at > > the uvconfig parameters, as well as the underlying OS kernel > > parameters, including file system settings, etc. > > > > I don't really have experience with messing with these params. I did > > increase MFILES to 300 from 12 > > > > > > Also, file system fragmentation may be an issue, depending on how long > > > it's been since it was looked at and addressed, especially if there is > > > a lot of reading / writing going on with this file system. > > > > How is your /tmp space, and swap space? > > > > No issues there. /tmp is a plenty and swap is never more than 1/2 > > used > > > > What flavor and versions of Linux, and UV? > > > > Red Hat 3 > > > > This is a process that your run when other users are not on the > > system, and possibly have these files open? > > > > Tried both ways. Last night I got in when no one was on. I shut down > > > UV and brought it back up fresh - same results. > > > > You are correct to first suspect file sizing. Depending on how > > properly, or imporperly tuned they are, Dynamic files can introduce > > some overhead. > > > > Just a few ideas off top of the head... > > > > Appreciated - Thanks > > > > Anthony > > > > > > > > - Original Message - > > From: "Anthony Dzikiewicz" <[EMAIL PROTECTED]> > > To: > > Sent: Sunday, February 13, 2005 7:11 PM > > Subject: [U2] Universe/Linux Performance Issue > > > > > > > I am experiencin
RE: [U2] [UV] RAID debugger
Great! Now if only the runtime engine would tell me a little more about the "Variable Not Assigned a Value, Zero Used" (and other such) error(s); like what variable and what value! Seems this was requested from Microdata 25 years ago too. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Maresh, Mel > Sent: Wednesday, February 02, 2005 7:20 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UV] RAID debugger > > > Talking of debuggers, > > is everyone aware that RAID will now display the values of > individual elements in a dynamic array > > :: D.CHART<10>/ > STRING: T r L=114 > `34321035593806859869452618551232605421692343520675401124 > 5611372190936940279115843867302197542611598000' > :: D.CHART<10,1>/ > STRING: T r L=10 `3432103559' > > This is really cool, something I requested from microdata 25 years ago. > > Mel > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mike Farrant > Sent: Wednesday, February 02, 2005 8:58 AM > To: u2-users@listserver.u2ug.org > Subject: [U2] [UV] RAID debugger > > > Talking of debuggers, can anyone remind me how the $INCLUDE s can mess > up the line numbers displayed within the RAID debugger. > > I had a solution to this once which I seem to remember had something to > do with the configuration or placement of the $INCLUDE lines in the > source code. > > I look forward to any response > > Thanks > > Mike Farrant > --- > 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] BREAK-ON help
Actually, D3 recently created the "GRAND-TOTAL-SUPP" modifier to solve this very problem; that mvDbms products haven't addressed in all these years. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Peter Gonzalez > Sent: Monday, January 31, 2005 11:17 AM > To: u2-users@listserver.u2ug.org; u2-users@listserver.u2ug.org > Subject: RE: [U2] BREAK-ON help > > > Thanks Richard. That worked! So it's like D3. I was afraid it was going > to be diff. 19 years in MV and still learning > > At 01:30 PM 1/31/2005 -0500, rbl000 wrote: > >Peter, > > > >You can accomplish this by adding a GRAND.TOTAL phrase with a similar > >"'P'" option string. > > > >Best Regards, > > > >Richard Lewis > >Quality Widgets and > >Software International, Inc. > >rbl at qwasi-inc.com > > > > > > --- On Mon 01/31, Peter Gonzalez < [EMAIL PROTECTED] > wrote: > >From: Peter Gonzalez [mailto: [EMAIL PROTECTED] > >To: u2-users@listserver.u2ug.org > >Date: Mon, 31 Jan 2005 12:26:07 -0500 > >Subject: [U2] BREAK-ON help > > > >Hello group,I need to assistance of this group again. I'm working > >with an Unidata Proc (and yes, i know rewriting it in Unibasic will > >solve my problems) and need help with the BREAK-ON. I'm using the > >BREAK-ON "'P'" to force a carriage return whenever the data > >changes. That is working fine. The problem I have is that > the last > >BREA-ON and the totals are printing on the last page. Is > there a way > >to carriage return and then print the grand totals?Peter > >GonzalezSenior Programmer AnalystM & M Aerospace > Hardware, Inc., a > >B/E Aerospace Company1 NW 15 TerraceMiami, Florida > >33172Phone: 305.925.2714Fax: > >305.925.2610www.mmaero.com---u2-users mailing > >listu2-users@listserver.u2ug.orgTo unsubscribe please visit > >http://listserver.u2ug.org/ > > > >___ > >No banners. No pop-ups. No kidding. > >Make My Way your home on the Web - http://www.myway.com > >--- > >u2-users mailing list > >u2-users@listserver.u2ug.org > >To unsubscribe please visit http://listserver.u2ug.org/ > > > > Peter Gonzalez > Senior Programmer Analyst > M & M Aerospace Hardware, Inc., a B/E Aerospace Company > 1 NW 15 Terrace > Miami, Florida 33172 > Phone: 305.925.2714 > Fax: 305.925.2610 > www.mmaero.com > --- > 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] [AD] Programmer needed in New Jersey
Jeeze... and I was going to make some comment about Descartes corollary: "I think therefore I'm right". :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Gordon J > Glorfield > Sent: Thursday, January 27, 2005 7:21 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [AD] Programmer needed in New Jersey > > > Well said Debster! > > > Gordon J. Glorfield > Sr. Applications Developer > MAMSI (A UnitedHealth Company) > 301-360-8839 > > [EMAIL PROTECTED] wrote on 01/27/2005 09:13:02 AM: > > > [snipped] > > > > Specifically seeking a junior is not really wrong, what would be > > wrong would be to hire a seasoned professional for a position > > that they are grossly overqualified for and most likely > > underpaid for. [snipped] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] K = K
Chris: Place: $OPTIONS EXT at the beginning of the program then try to compile again. This should do the trick. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Thursday, January 20, 2005 6:57 AM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] K = K > > > I've just started at a new site running D3 7.2.1.RS on AIX and the REMOVE > statement doesn't compile at all! It's very annoying as it's a very > convenient way of processing dynamic arrays and with larger > arrays far more > efficient than counting the markers and FOR... NEXTing through it. I'm > suprised that REMOVE isn't universal amongst U2 BASICs. > > Regards, > Chris > > > Bill writes - > In UniData and D3 the "REMOVE" statement looks like: > > REMOVE variable FROM dynamic.array AT position.variable SETTING > delimiter.variable > > This allows the explicit setting of the pointer, without resorting to > reinitialization by reassigning the array variable. I've always just > assigned "Position.Variable" prior to doing any "REMOVE" stuff. But then, > UniVerse is sometimes a different animal. :-) > > > > Checked by MimeSweeper Thu, 20 Jan 2005 14:56:43 - > --- > 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] K = K
Now that I think about this, "K" is the array being traversed? We simply remove the next attribute/value/subvalue in array "K" and assigning this value to DUM. For example: K = I^AM^HAPPY]TO]READ^THIS^LIST REMOVE DUM FROM K SETTING MORE would result in: DUM = "I" K= the above array MORE = 2 However, (from the documentation), the pointer is reset to the beginning of dynamic.array whenever dynamic.array is reassigned. Therefore, dynamic.array should not be assigned a new value until all elements have been extracted (that is, until variable = 0). So, the line "K=K" simply reassigns the array to itself, thus resetting the pointer. In UniData and D3 the "REMOVE" statement looks like: REMOVE variable FROM dynamic.array AT position.variable SETTING delimiter.variable This allows the explicit setting of the pointer, without resorting to reinitialization by reassigning the array variable. I've always just assigned "Position.Variable" prior to doing any "REMOVE" stuff. But then, UniVerse is sometimes a different animal. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Wednesday, January 19, 2005 1:22 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] K = K > > > Date: Wed, 19 Jan 2005 13:29:15 -0600 > Marilyn Hilb <[EMAIL PROTECTED]> wrote: > > > I frequently see this type of line K = K in the code > > I work on and never understood why. > > > > -Original Message- > > From: Andrea Charles [mailto:[EMAIL PROTECTED] > > > > Do you need the K = K ? > > -- > > ... (Code from Charles Stevenson) > > > > REMOVE DUM FROM K SETTING MORE ; check for any delimiters > > K = K ; * reset rmv ptr in case calling pgm cares. > > According to the UniData Help for REMOVE, in the code sample above, DUM > would be set to the first string delimited by a standard delimiter (e.g., > @AM, @VM), and MORE would be set to index the level of the delimiter > encountered: 0=End of array, 1=Record Mark (255), [EMAIL PROTECTED] (254), > [EMAIL PROTECTED] (253), > etc. A pointer is maintained so that the next REMOVE X FROM K > would return > the next string. > > The comment is stating that the "K = K" is used to reset the > REMOVE pointer > to the beginning of the string. > > Further info on using REMOVE: > > REMOVE is useful for sequentially processing all the elements of a dynamic > array without having to "recount" for each subsequent item. However, you > need to check your delimiters to find attributes/values/subvalues. A > similar method to process each attribute is to SELECT K TO KLIST and then > READNEXT DUM FROM KLIST within a loop. > > --Tom Pellitieri > Century Equipment > Toledo, Ohio > --- > 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] Where Will the .NET Apps Live ?
Tony: [stuff snipped] > Brian's comment about intepreted code wasn't lost on me and I need to > consider it - I confess I've never done that. Putting some logic at a > middle tier, not necessarily at the DBMS server, also has advantages. At > the risk of yet more bandwidth, but not consuming licenses, many basic > validation rules can be exposed as client-independent web services. That > approximates that interpreted layer, makes changes virtually > instantaneous, > and eliminates deployment issues. Goes to show you what we'll do for cost considerations. Introducing another tier seems like madness, unless it's cheaper. :-) That's why it sometimes looks like the main MV providers aren't really interested in exposing the dbms model to the mainstream. In IBM's case, they probably just want to kill the product, eventually, because growing the product competes with their other product(s). In RDUS's case, they probably just want to squeeze it for what they can because "they" believe it'll die by itself. Not sure about jBase though. Maybe if they can sell it to China they'll reach a critical mass that'll support a migration from D3 and U2. What a bizarre thought. :-) Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The list format and usefulness
I've always thought it is much preferable to read the unuseful discussions on this list than the many "Viagra", "..meds..", "complimentary...", "Why pay more", "Nice women", and other emails I regulary get. :-) Merry XMas. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Frost, Bodo > Sent: Tuesday, December 21, 2004 6:56 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] The list format and usefulness > > > Les, > > Many thanks for your reply on this 'useful' discussion. > > I am new to universe and have subscribed to get a lot of information on > what's going on, what you gurus have to say about uv, etc. > David, just a comment to you, and I apologize upfront if I seem to be > rude: You have started the one big discussions which you seem to claim > NOT to be useful. Is this the thing you have intended when posting? > > My way of dealing with very useful discussions is to delete the crap > after reading 2 or 3 lines of the reply. If the reply is not of > interest, I just delete it. And David, I suggest that you do so as well. > > For me as a newbie in uv the technical discussions are most valuable, as > an oldie in IT (20 yrs) I know about the need for people to express > themselves in useful discussions - people don't get me wrong! It is all > appreciated!!! > What I want to say is: I only keep those posts which are or seem to be > valueable for me, the rest is just being deleted. > It is as simple as that. And therefore it does not need further > discussions. > > Have a wonderful Christmas and a Happy new Year. > > > Kindest Regards > > > Bodo Frost > Midland Brick Company Pty Ltd > 102 Great Northern Highway > MIDDLE SWAN WA 6056 > Phone: (08) 9273 5589 > Fax:(08) 9273 5523 > E-mail: [EMAIL PROTECTED] > > >CAUTION: > >The information contained in this document is of a confidential nature > and its sole use is for communication purposes between the sender and > addressee. Your respect of this confidentiality is appreciated. If you > have received this document in error, please notify the sender on the > above telephone. Thank you. > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Les Hewkin > Sent: Tuesday, 21 December 2004 6:37 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] The list format and usefulness > > Just to throw oil on the fire... > > This is the technical list.please take this to the community list > > (very big grin..) > > Les "3 more days work to go" > > -Original Message- > From: Charles Barouch [mailto:[EMAIL PROTECTED] > Sent: 21 December 2004 06:31 > To: [EMAIL PROTECTED] > Subject: Re: [U2] The list format and usefulness > > > David, > What I do is subscribe to both the list and the digest. That way I can > skim and delete the individual messages as they come in (from the list), > still have all the content if I need it later (from the digest). To > control bandwidth, I have them going to two different names, so I can > opt to not pull the e-mail with the separate posts if I don't have time > or speed to spare for it. > As moderator I can't delete-without-reading, but you could. I know it's > not the answer you proposed, but I find it a workable solution. > What has me more curious is your comment about the online indexing being > insufficient. What would you like to see done differently? > > - Chuck "Info-glut" Barouch > > > Clifton Oliver wrote: > > > Full content. A lot of times watching how someone else is thinking is > > more instructive than what they are thinking. > > > > For a problem, an answer is enough. To learn how to solve a class of > > problems, watching the process that more experienced (or even just > > different) techs go through is an education worth the noise on the > > channel. > > > > IMO. > > > > Clif > > -- > - Charles Barouch > (718) 762-3884 x 1 - Key Ally Voice Mail > cbarouch - Skype (Free VoIP Phone) > > [EMAIL PROTECTED] - Consulting services > [EMAIL PROTECTED] - News > [EMAIL PROTECTED] - U2-Users Moderator > > [EMAIL PROTECTED]- Zeus Data Integration > Mount Olympus, Home of Zeus Data Integration > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > > > 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. > 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. > E-mail transmissions are not secure and Travis Perkins accepts no > responsibility for changes made to this message after it was sent. > Whilst steps hav
RE: [U2] wIntegrate (on Universe) Question
Anthony: I implemented this in our menu structure by using our standard TCL shell program (the usual tcl stacker program). So, before I actually run the wIntegrate call I automatically exit the menu to our TCL shell. Then the query is run. When it's finished the user is back at the shell with whatever restrictions they own (if restricted then anything they press returns them to the menu). If I just execute the following code (as a separate cataloged program from within a BASIC menu program): * ** Run process to start wIntegrate script SCRIPT = 'Chain "query\query.wis"' ; * path that contains the qb script CALL WIN.COMSUB(SCRIPT) EXECUTE \WIN.SERVER\ I get the query builder screen and the report and I'm returned to the menu instead of viewing the last page (which is why I route everything through the TCL shell). Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Anthony > Dzikiewicz > Sent: Thursday, December 16, 2004 12:16 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] wIntegrate (on Universe) Question > > > Yeah WIN.SERVER is good. > If you are at a command prompt all of this works just peachy. > However, when > you try this from menu it times out. It times out ONLY when you choose to > see the report in the report viewer. Otherwise, all is fine. WIntegrate > works fine here for anything I do. It seems like a great > product. The only > problem I have is that our users all login and get their menus. NO ONE is > allowed to break out of a menu to the command line. WIntegrate > doesn't like > this. It seems that it wasn't designed to do so. > > I do have a 'pseudo command interpreter' that I wrote for those occasions > where someone must break out for whatever emergency. I could program this > to allow WIN.SERVER. My preference is to have this work for users without > breaking out of a menu. > > Are you doing this at your place Bill ? Is your suggestion something that > you have working at your place ? If so, then I must be doing something > wrong. > > Anthony > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. > Sent: Thursday, December 16, 2004 12:51 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] wIntegrate (on Universe) Question > > Have you cataloged the WIN.PROGS in the local account? WIN.SERVER must be > able to be executed for the query. > > Bill > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Anthony > > Dzikiewicz > > Sent: Thursday, December 16, 2004 6:57 AM > > To: [EMAIL PROTECTED] > > Subject: RE: [U2] wIntegrate (on Universe) Question > > > > > > Ive just tried this and I get the same result. I created the program as > > suggested and put it on a menu. When you choose that menu > > option, the query > > builder pops up. However, right after you set up the query and > press ok, > > you are at a 'press any key to continue' on the menu (Universe machine). > > Meanwhile there is a wIntegrate window trying to pass the data to > > the report > > viewer and it times out. > > > > Anthony > > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. > > Sent: Wednesday, December 15, 2004 2:28 PM > > To: [EMAIL PROTECTED] > > Subject:RE: [U2] wIntegrate (on Universe) Question > > > > Anthony: > > > > Try the following: > > > > ** Run process to start wIntegrate script > > SCRIPT = 'Chain "query\query.wis"' ; * path that contains the qb script > > CALL WIN.COMSUB(SCRIPT) > > EXECUTE \WIN.SERVER\ > > > > This will pop open the Query Builder from a BASIC program and you > > should be > > able to do what's necessary from there. > > > > Hope this helps. > > > > Bill > > > > > -Original Message- > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] Behalf Of Anthony > > > Dzikiewicz > > > Sent: Wednesday, December 15, 2004 9:06 AM > > > To: [EMAIL PROTECTED] > > > Subject: [U2] wIntegrate (on Universe) Question > > > > > > > > > I forget if there is a separate group for this product. If so, sorry. > > > However, my problem is this; > > > > > > I am evaluating the wIntegrate product. One of the uses that > > we have for > > > this is the query builder/report viewer. We have a person who used to &
RE: [U2] wIntegrate (on Universe) Question
Have you cataloged the WIN.PROGS in the local account? WIN.SERVER must be able to be executed for the query. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Anthony > Dzikiewicz > Sent: Thursday, December 16, 2004 6:57 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] wIntegrate (on Universe) Question > > > Ive just tried this and I get the same result. I created the program as > suggested and put it on a menu. When you choose that menu > option, the query > builder pops up. However, right after you set up the query and press ok, > you are at a 'press any key to continue' on the menu (Universe machine). > Meanwhile there is a wIntegrate window trying to pass the data to > the report > viewer and it times out. > > Anthony > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. > Sent: Wednesday, December 15, 2004 2:28 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] wIntegrate (on Universe) Question > > Anthony: > > Try the following: > > ** Run process to start wIntegrate script > SCRIPT = 'Chain "query\query.wis"' ; * path that contains the qb script > CALL WIN.COMSUB(SCRIPT) > EXECUTE \WIN.SERVER\ > > This will pop open the Query Builder from a BASIC program and you > should be > able to do what's necessary from there. > > Hope this helps. > > Bill > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Anthony > > Dzikiewicz > > Sent: Wednesday, December 15, 2004 9:06 AM > > To: [EMAIL PROTECTED] > > Subject: [U2] wIntegrate (on Universe) Question > > > > > > I forget if there is a separate group for this product. If so, sorry. > > However, my problem is this; > > > > I am evaluating the wIntegrate product. One of the uses that > we have for > > this is the query builder/report viewer. We have a person who used to > > tinker at the command line. We have long since pulled the plug > > on this kind > > of thing, because they did some 'bad things'. However, it is > nice to let > > them have the ability to query the data (after all it is > theirs). So, it > > seems wIntegrate can do this for us. My problem is that you need > > to be at a > > command line to allow wIntegrate to operate. So, we're back to > > square one - > > user at the command line. > > > > Our system is based on standard Universe menus. Is there a way to add a > > menu option (or create a VOC) that will allow the user to 'mess' > > with query > > builder, etc ? I have tried adding WIN.SERVER as a menu option. > > However, > > this half works. I created a simple query and tried to put it to > > the report > > writer and it times out, because the WIN.SERVER closes. If I > > send it to the > > screen, it works ok. > > > > Any workarounds to this ? > > > > Anthony > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate (on Universe) Question
Mark: I've never fiddled with it but AccuTerm allows PgUp/PgDn using [Ctrl][Shift]+PageUp and [Ctrl][Shift]+PageDn. You can also scroll up and down a line at a time by using [Ctrl][Shift]+UpArrow, etc, etc, etc. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson > Sent: Wednesday, December 15, 2004 5:41 PM > To: [EMAIL PROTECTED] > Subject: Re: [U2] wIntegrate (on Universe) Question > > > If you've got Wintegrate already installed, then keep with > wintegrate. It's > pretty link-friendly. > > If you're evaluating before purchasing, keep in mind the high price (near > $200US per license). I just went through this process having been a long > time user of wintegrate but couldn't keep a straight face asking a new > client to spend $3,200 for 16 user licenses. During this evaluation, we > landed on Accuterm which is aggressively priced for $1,000 for 50 > seats (or > less). > > 2 things i miss in accuterm that wintegrate made very easy was > page up/down > the user's windows and the print-screen button. Both of these are probably > hidden in the accuterm menu choices and not that direct. > > Accuterm supports VBA which is gaining some momentum at 2 of my clients. > Thus, we are creating VBA scripts in regular Pick and sending them to the > emulator with a processing program. Very cool forms and boxes and mucho > control of the PC-level services like email etc. > > I keep both on my pc depending on what I need to do. Both have > downloadable > demo (1 user) versions. > > my 1 cent. > > - Original Message - > From: "Anthony Dzikiewicz" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, December 15, 2004 12:05 PM > Subject: [U2] wIntegrate (on Universe) Question > > > > I forget if there is a separate group for this product. If so, sorry. > > However, my problem is this; > > > > I am evaluating the wIntegrate product. One of the uses that > we have for > > this is the query builder/report viewer. We have a person who used to > > tinker at the command line. We have long since pulled the plug on this > kind > > of thing, because they did some 'bad things'. However, it is > nice to let > > them have the ability to query the data (after all it is > theirs). So, it > > seems wIntegrate can do this for us. My problem is that you > need to be at > a > > command line to allow wIntegrate to operate. So, we're back to square > one - > > user at the command line. > > > > Our system is based on standard Universe menus. Is there a way to add a > > menu option (or create a VOC) that will allow the user to 'mess' with > query > > builder, etc ? I have tried adding WIN.SERVER as a menu option. > However, > > this half works. I created a simple query and tried to put it to the > report > > writer and it times out, because the WIN.SERVER closes. If I send it to > the > > screen, it works ok. > > > > Any workarounds to this ? > > > > Anthony > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate (on Universe) Question
Anthony: Try the following: ** Run process to start wIntegrate script SCRIPT = 'Chain "query\query.wis"' ; * path that contains the qb script CALL WIN.COMSUB(SCRIPT) EXECUTE \WIN.SERVER\ This will pop open the Query Builder from a BASIC program and you should be able to do what's necessary from there. Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Anthony > Dzikiewicz > Sent: Wednesday, December 15, 2004 9:06 AM > To: [EMAIL PROTECTED] > Subject: [U2] wIntegrate (on Universe) Question > > > I forget if there is a separate group for this product. If so, sorry. > However, my problem is this; > > I am evaluating the wIntegrate product. One of the uses that we have for > this is the query builder/report viewer. We have a person who used to > tinker at the command line. We have long since pulled the plug > on this kind > of thing, because they did some 'bad things'. However, it is nice to let > them have the ability to query the data (after all it is theirs). So, it > seems wIntegrate can do this for us. My problem is that you need > to be at a > command line to allow wIntegrate to operate. So, we're back to > square one - > user at the command line. > > Our system is based on standard Universe menus. Is there a way to add a > menu option (or create a VOC) that will allow the user to 'mess' > with query > builder, etc ? I have tried adding WIN.SERVER as a menu option. > However, > this half works. I created a simple query and tried to put it to > the report > writer and it times out, because the WIN.SERVER closes. If I > send it to the > screen, it works ok. > > Any workarounds to this ? > > Anthony > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Scanner Connection
Mark: Check with Tony Gravagno. His email address is: [EMAIL PROTECTED] Don't forget to remove the "remove this". I know he can help. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson > Sent: Wednesday, December 01, 2004 12:26 AM > To: [EMAIL PROTECTED] > Subject: [U2] Scanner Connection > > > I have a client using Accuterm with telnet sessions for all the users. One > user has a Bell & Howell multi-page scanner that gets around 100 > pages per day > of work orders etc. > > That user's emulator is Ve-Client from Visual Pick and they want > to re-write > the app with Accuterm and some VB scripting if necessary. My > question is where > would someone go to find out how this can be done. > > It presently is done in VE with a 9,500 line program (4GL > generated code) that > has oodles of includes and gets very busy. It still doesn't do > what I would > like and that is for the scanner to write the scanned docs to a > temp folder, I > would use Accuterm to load in those filenames and offer them to > the user for > proper pc-filenaming to attach to the application. > > I would appreciate any insight on this. > > Thanks in advance. > Mark Johnson > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: [UD] problem with hex conversions
Goes to show ya...coming from a Pick background I see nothing wrong with the
results. :-)
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Simon Lewington
> Sent: Wednesday, November 24, 2004 3:35 AM
> To: [EMAIL PROTECTED]
> Subject: [U2] Re: [UD] problem with hex conversions
>
>
> Switch to $BASICTYPE 'U' to stop this supposed Pick-Style behaviour.
>
> Simon
>
> "Ben Gladman" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> >
> > I'm getting unexpected results from the hex conversions in
> Unidata 6.0.12
> on
> > NT:
> >
> > PROGRAM BJGTEST
> > *
> > CRT "OCONV('1','MO')=" : OCONV('1','MO')
> > CRT "OCONV('1','MO0C')=" : OCONV('1','MO0C')
> > CRT "OCONV('1','MX0C')=" : OCONV('1','MX0C')
> > CRT "OCONV('1','MX')=" : OCONV('1','MX')
> > CRT "ICONV('F','MX')=" : ICONV('F','MX')
> > *
> > STOP
> >
> >
> > the results I get are:
> >
> > OCONV('1','MO')=001
> > OCONV('1','MO0C')=061
> > OCONV('1','MX0C')=31
> > OCONV('1','MX')=31
> > ICONV('F','MX')=
> >
> > The octal conversions and the hex-ascii conversion seem okay.
> But I would
> > expect the fourth line to read '1' or '01', and the fifth line to read
> '15'?
> > Is this a problem anyone else gets?
> >
> > Cheers,
> > -Ben
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PDP vs UO, was Case
George wrote: > Bob, > Why would you buy PDP.NET from Raining Data - especially > since it comes > with Unidata 6.1 and probably Universe soon if not now. >From what I understand, PDP.NET has a number of features that the UO.NET plumbing doesn't offer: 1) it's a Microsoft certified .Net Data Provider 2) it supports ADO.NET 3) it is supposed to outperform UniObjects (speed, scalability) 4) the class libraries extend Pick Basic functionality to .NET 5) it's been on the market for over a year 6) it seems they will continue to adopt and invest in the latest .NET functionality 7) it integrates with Visual Studio(help, f1, docs, intellisense, etc.) 8) docs are extensive 9) the training tools have source for all demo apps I got this off the documentation I have on the product. Since I'm using the product I can attest to most of this. Hope this helps. Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate text box
Thanks for the help with the wIntegrate text box. It helps to use the WIN.DBEDGET and WIN.DBEDGET subroutines instead of the WIN.DBGET and WIN.DBSET (one can even choose between an VM'd or an AM'd return string). I've noticed one additional peculiarity. I wrote a wrapper subroutine to call the WIN text box routines and has an [OK] and a [Cancel] button on the form. I have a main program that asks for an newsletter item id then calls this wrapper program; which pops open the wIntegrate (or AccuTerm) text box. No other interaction with the WIN... routines occurs. I type in the information then click on the [OK] button (or can just click the [Cancel] button. The peculiarity is when, still staying inside the main program, entering another newsletter id, which pops open (and fills) the text box for a second newsletter item, I click anywhere in the text box and try to enter data. I cannot enter data. I can, however, press the [Backspace] key and erase data. I can select data, but any key I press acts like the [Del] key. If I exit the main BASIC program then reenter it, the text box functions normally. The AccuTerm textbox always operates normally. Does anyone know why the 1st call of a text box, from within a BASIC program, acts like a normal text box but subsequent calls restrict data input but not data removal? I was fiddling with the "WIN.DBDEL" and the "WIN.SSTATE" routines but the wrapper subroutine seems to be coded identical to the "WIN.DBDEMO2" routine. As ususl, any observation would be appreciated. :-) Bill > -Original Message- > From: Bill H. [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 18, 2004 10:34 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] wIntegrate text box > > > Ian: > > Thanks very much. My 1996 documentation doesn't have that style > property. After careful review of the 2003 pdf off IBMs website, > I see it. > > This gets the job done nicely. :-) > > Thanks again. > > Bill > > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Ian Renfrew > > Sent: Thursday, November 18, 2004 5:30 AM > > To: [EMAIL PROTECTED] > > Subject: RE: [U2] wIntegrate text box > > > > > > Try adding the style property ES_WANTRETURN as part of the Opts > variable. > > > > Regards, Ian Renfrew --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Case
Bob: Raining Data has their PDP.NET product available for the U2 products. I'm presently using it for D3 but can't judge its efficacy for U2...would assume it works just fine though. You might try checking this out: http://www.rainingdata.com/products/connect/dotnet/index.html Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of BobJ > Sent: Sunday, November 21, 2004 12:05 PM > To: [EMAIL PROTECTED] > Subject: Re: [U2] Case > > > Thanks. Once I had the clue I was able to find the right words > in the docs. > BobJ > - Original Message - > From: "Clifton Oliver" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Sunday, November 21, 2004 2:01 PM > Subject: Re: [U2] Case > > > > INVERT will make the case in UV opposite to the Shift-Lock key. > PTERM CASE > > NOINVERT makes it the same as the Shift-Lock key. > > > > -- > > > > Regards, > > > > Clif > > > > ~~~ > > W. Clifton Oliver, CCP > > CLIFTON OLIVER & ASSOCIATES > > Tel: +1 619 460 5678Web: www.oliver.com > > ~~~ > > > > > > > > Allen Egerton wrote: > >> On Sun, 21 Nov 2004 11:49:38 -0500, you wrote: > >> > >> > >>>Universe 10.1 PE > >>> > >>>The case appears to be reversed Is there some way to stand this > >>>thing on > >>>its head and get normal casing back? It's only a mild > irritant but it IS > >>>an > >>>irritant and the product seems to complete for something like that to > >>>have > >>>been left without an option or a fix. > >> > >> > >> > >> Try adding PTERM CASE INVERT to your VOC LOGIN paragraph. > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate text box
Ian: Thanks very much. My 1996 documentation doesn't have that style property. After careful review of the 2003 pdf off IBMs website, I see it. This gets the job done nicely. :-) Thanks again. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Ian Renfrew > Sent: Thursday, November 18, 2004 5:30 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] wIntegrate text box > > > Try adding the style property ES_WANTRETURN as part of the Opts variable. > > Regards, Ian Renfrew > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. > Sent: Wednesday, November 17, 2004 7:08 PM > To: [EMAIL PROTECTED] > Subject: [U2] wIntegrate text box > > I've created a simple text box for wIntegrate and AccuTerm from within > BASIC. The simple task is to allow data entry of up to 1200 characters. > When the [OK] button is pressed the contents of the text box is > passed back > to BASIC. > > AccuTerm works just fine. However, wIntegrate is giving me no > end of grief. > The problems are: > > 1) How can I press [Enter] in the text box without closing the text box? > 2) What character(s) are passed back to BASIC for [Enter]s? > 3) Does wIntegrate do what AccuTerm does and filter CrLf with VM/AMs? > > Can anyone help? It would be greatly appreciated. > > Thanks, > > Bill > > Code snippet in calling programlooks like: > Opts = "ES_MULTILINE|WS_VSCROLL|WS_BORDER" > Opts<-1> = 1200; ** the maximum length of field > WKAMT= NULL$ ; ** initialize the variable > CALL wIntDBEdit(DispData, 'News Item', 300, 125, 1200, 80, Opts, WKAMT) > > > The program "wIntDBEDIT" looks like (takenn from: > DBX = NULL$ > DLG.NAME = "wIntDlgBox" > dbName = "NewText" > VER = NULL$ > tbxStart = INT((300 - 125) / 2) > > ** build dialog box > CALL WIN.DBNEW (DBX, DLG.NAME, dlgTitle, 10, 10, 300, 125, '', Opts) > CALL WIN.DBEDIT (DBX, dbName, tbxStart, 15, 1200, 80, Opts) > CALL WIN.DBBUTTON(DBX, "OK", "OK", (INT(300/2)-45), (125-25), '', '', 1) > CALL WIN.DBBUTTON(DBX, "Cancel", "Cancel", (INT(300/2)+15), (125-25), '', > '', 0) > > ** load the dialog box > CALL WIN.DBLOAD(DBX, ERR) > > ** test for "already exists" load errors > IF ERR = 3 THEN >CALL WIN.DBDEL(DLG.NAME) ; ** delete dialog box >CALL WIN.DBLOAD(DBX, ERR) ; ** load again > END > > ** test for load errors (in case we did it again > IF NOT(ERR) THEN >CALL WIN.DBSET(DLG.NAME, dbName, strOut) >CALL WIN.DBSHOW(DLG.NAME, 1, ERR) >IF ERR THEN > CALL WIN.DBDEL(DLG.NAME) >END > END > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > > > -- > Incoming mail is certified Virus Free. > Checked by AVG Anti-Virus (http://www.grisoft.com). > Version: 7.0.279 / Virus Database: 265.3.1 - Release Date: 11/15/2004 > > > > > -- > Outgoing mail is certified Virus Free. > Checked by AVG Anti-Virus (http://www.grisoft.com). > Version: 7.0.279 / Virus Database: 265.3.1 - Release Date: 11/15/2004 > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] wIntegrate text box
I've created a simple text box for wIntegrate and AccuTerm from within BASIC. The simple task is to allow data entry of up to 1200 characters. When the [OK] button is pressed the contents of the text box is passed back to BASIC. AccuTerm works just fine. However, wIntegrate is giving me no end of grief. The problems are: 1) How can I press [Enter] in the text box without closing the text box? 2) What character(s) are passed back to BASIC for [Enter]s? 3) Does wIntegrate do what AccuTerm does and filter CrLf with VM/AMs? Can anyone help? It would be greatly appreciated. Thanks, Bill Code snippet in calling programlooks like: Opts = "ES_MULTILINE|WS_VSCROLL|WS_BORDER" Opts<-1> = 1200; ** the maximum length of field WKAMT= NULL$ ; ** initialize the variable CALL wIntDBEdit(DispData, 'News Item', 300, 125, 1200, 80, Opts, WKAMT) The program "wIntDBEDIT" looks like (takenn from: DBX = NULL$ DLG.NAME = "wIntDlgBox" dbName = "NewText" VER = NULL$ tbxStart = INT((300 - 125) / 2) ** build dialog box CALL WIN.DBNEW (DBX, DLG.NAME, dlgTitle, 10, 10, 300, 125, '', Opts) CALL WIN.DBEDIT (DBX, dbName, tbxStart, 15, 1200, 80, Opts) CALL WIN.DBBUTTON(DBX, "OK", "OK", (INT(300/2)-45), (125-25), '', '', 1) CALL WIN.DBBUTTON(DBX, "Cancel", "Cancel", (INT(300/2)+15), (125-25), '', '', 0) ** load the dialog box CALL WIN.DBLOAD(DBX, ERR) ** test for "already exists" load errors IF ERR = 3 THEN CALL WIN.DBDEL(DLG.NAME) ; ** delete dialog box CALL WIN.DBLOAD(DBX, ERR) ; ** load again END ** test for load errors (in case we did it again IF NOT(ERR) THEN CALL WIN.DBSET(DLG.NAME, dbName, strOut) CALL WIN.DBSHOW(DLG.NAME, 1, ERR) IF ERR THEN CALL WIN.DBDEL(DLG.NAME) END END --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Random number (RND()) help
The same on D3NT. :BPTEST $OPTIONS EXT ; FOR X = 1 TO 99 ; CRT RND(370570) ; INPUT ZZ,1 ; IF ZZ = 'Q' THEN EXIT ; NEXT X ; END BpTest*566008520 . [820] Creating FlashBASIC Object ( Level 0 ) ... [241] Successful compile! 3 frame(s) used. 334572 ? 142184 ? 359923 ? 149243 ? 346793 ? 35018 ? 107715 ? 128841 ?Q : Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Glenn Herbert > Sent: Wednesday, November 10, 2004 1:16 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] [UV] Random number (RND()) help > > > OK. I'll agree with that!! > > At 04:03 PM 11/10/2002, you wrote: > >No it's not Windoze. I'm running Unidata PE on Win2000 and I get this: > >* BBB - Test custom snippets > >FOR I = 1 TO 100 > > PRINT RND(370570) > > INPUT HUGGA > > IF HUGGA THEN STOP > >NEXT I > >STOP > >:BBB > >43874 > >? > >27779 > >? > >267409 > >? > >138481 > >? > >188948 > >? > >243449 > >? > >253422 > >? > >282865 > >? > >33416 > >? > >351549 > > > >Must be a Universe limitation on Windoze. > > > > *=aee=* > > > >-Original Message- > >From: [EMAIL PROTECTED] > >[mailto:[EMAIL PROTECTED] Behalf Of Glenn Herbert > >Sent: Wednesday, November 10, 2004 12:01 > >To: [EMAIL PROTECTED] > >Subject: RE: [U2] [UV] Random number (RND()) help > > > > > >Oh yes. That is the limitation on 32-bit Windoze. Your numbers WILL > >differ on UNIX systems. > > > > > >At 02:36 PM 11/10/2004, you wrote: > > >I ran your code on UV 10.1 on AIX and the highest number generated was > >370558 > > >I don't think it's your code > > > > > >Mel > > > > > > > > >UV 9.6.1.3 on NT. > > >I needed to generate some random numbers between 0 and 370570, > and just to > > >check the distribution of numbers, I ran this snippet of code: > > > > > >FOR I = 1 TO 99 > > > THIS.NUM = RND(370570) > > >NEXT > > > > > >What's odd is that no matter how many times I run this, the > distribution of > > >numbers is always completely in the lower 10% of the range (approx). In > > >other words, there are never any numbers generated higher than > ~ 33,000. > > > > > >Am I doing something stupidly wrong? > > >--- > > >u2-users mailing list > > >[EMAIL PROTECTED] > > >To unsubscribe please visit http://listserver.u2ug.org/ > >--- > >u2-users mailing list > >[EMAIL PROTECTED] > >To unsubscribe please visit http://listserver.u2ug.org/ > >--- > >u2-users mailing list > >[EMAIL PROTECTED] > >To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Index problem
Phil: What I don't understand about this conversation is why would one expect any different functionality from the dbms? This has been, in my experience, the way indexes have always been on the mvDbms products; whether they be U2, D3, or whatever. When an index is created, it is updated if, and only if, the file it was created for changes. Your example indicates an index on DETAIL that translates HEADER information. Since DETAIL is written first, hence no HEADER information exists, the index on DETAIL is updated with NULL. When HEADER is written, it is completely irrelevant what indexes exist on DETAIL (as it is irrelevant what indexes exist on CUSTOMER, RECEIPTS, etc). The only index that will be updated when HEADER is written are indexes on HEADER. This is a common problem with an mvDbms index structure. Your solution is probably the only practical one available. I've been fiddling with the possibility of doing an "after update" trigger to update the related DETAIL but that significantly slows down batch processes and really messes up my COPYs and RESTOREs too. So I've found your solution to be the best, in the aggregate, where a file is kept of changes in the DETAIL file and a process then reindexes DETAIL on a periodic basis. You may want to test, however, keeping a file of changed items in DETAIL. Then periodically reading/writing the DETAIL record(s) and see if the index is then updated, even though there is no change to the DETAIL. This might work and be a more practical solution. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Warren, Phil > Sent: Wednesday, November 03, 2004 6:25 AM > To: '[EMAIL PROTECTED]' > Subject: RE: [U2] Index problem > > > We've run into a similar problem with virtual attributes that reference > other files in all versions of UniData through to version 6.0.8. I wonder > if this might be a similar 'anomaly' > > For example, > In our case we have 2 order files, named HEADER and DETAIL. A virtual > attribute exists in the DETAIL file which references the HEADER file. > When the DETAIL record(s) are written out before the HEADER > record, UniData > does not update the DETAIL index when the HEADER file is written, > causing a > null value when the DETAIL index is used. As in your case, when another > attribute is used, to select the DETAIL file, which does not use > the index, > the items are selected as expected. > > The only work around that we've used, is to rebuild the index file daily. > Perhaps there is a better work around or fix? > > -Phil- > > -Original Message- > From: kafsat taiyus [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 02, 2004 10:00 PM > To: '[EMAIL PROTECTED]' > Subject: [U2] Index problem > > > We have one Unidata 5.1 data file with a virtual attribute. The virtual > dictionary calls a Unibasic subroutine and returns a single value > data from > a multi value attribute from within the same file. > > We have an index on the virtual attribute. When new records are added to > the file Unidata does not update the index on the virtual attribute. > > After adding new records that returns XXX for the virtual attribute the > command LIST FILE_NAME WITH VIRTUAL_ATT = "XXX" does not return > any record. > > > But the command LIST FILE_NAME NO.INDEX WITH VIRTUAL_ATT = "XXX" finds the > record. > > The command LIST FILE_NAME WITH VIRTUAL_ATT = "XXX" works only after > rebuilding the index using REBUILD.INDEX command. > > Do you know why is it happening and how to fix it? > > Thank you in anticipation. > > Regards > Kafsat > > > > > > > > This email and any attachments are confidential and intended > solely for the > use of the person or entity to whom they are addressed. If you are not the > intended recipient, please do not disclose, store, copy or take any action > in reliance on it or them. If you have received this message in error, > please tell us by reply email (or telephone + 61 (0) 3 9274 9100) > and delete > all copies on your system. Any opinion, advice or information in > this email > is not necessarily that of the owners or officers of this company. Please > advise us immediately if you or your employer do not consent to email for > messages of this type. > > Retail Decisions has taken reasonable precautions to ensure that any > attachment to this email has been swept for viruses. However, we cannot > accept any liability for any damage sustained as a result of software > viruses, and would advise that you carry out your own virus checks before > opening any attachment. Please note that communications sent by or to any > person through our computer system may be viewed by other Retail Decisions > employees or officers strictly in accordance with law. > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ ---
RE: [U2] [UV] Term settings for capture and no extra headings
Troy: I don't think this is possible. I spent a day trying to find it. There's a bevy of stuff Universe doesn't do that D3 does easily. This is one of them. :-( However, I think some mentioned the "Report Viewer". I use this a lot and maybe it'll work for you. Bill > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy > > (Logitek Systems) > > Sent: Friday, 29 October 2004 1:28 AM > > To: [EMAIL PROTECTED] > > Subject: [U2] [UV] Term settings for capture and no extra headings > > > > On Universe 10.0.19: > > > > > > > > I want to capture a report sent to the emulator (wintegrate) and still > > retain the first page headings, but not get a repeating heading every 60 > > lines or so. > > > > > > > > On pick D3, it was possible to get this behavior by setting the page > > depth to 0. On universe, it wants an integer from 1 to 32767 so I end > > up with page breaks and a new heading every 32k lines (which is > > currently the lesser of the 2 evils). > > > > > > > > Is there a setting on universe that will accomplish what I need? > > > > > > > > Thanks! > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > To unsubscribe please visit http://listserver.u2ug.org/ > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Stu:
Here are a couple examples from the wicki program:
For when I want to test a subroutine with common:
BPTEST $INCLUDE DTABP,INCLUDES SET.NAMED.COMMON ; $INCLUDE DTABP,INCLUDES
SET.INITIALIZATION ; A = NULL$ ; B = NULL$ ; C = NULL$ ; CALL
MY.SPECIAL.SUBROUTINE (A, B, C) ; CRT "A-: " : A ; CRT "B-: " : B ; CRT "C-:
" C ; END
For when I want to know the results of a BASIC statement:
BPTEST CRT TRIM('Now is the time', ' ', 'A')
For when I want to do something from a proc (like update something):
PQ
C-->
C--> Create the new file
C-->
RI
RO
C-->
HBPTEST $OPTIONS EXT ;
H PORT.ACCT = FIELD(OCONV('', 'U50BB'), ' ', 3) ;
H TclCmd = \LOGTO MyAccount, MyPasswd\ ;
H TclCmd<-1> = \CREATE-FILE SERVICES 1 7\;
H EXECUTE TclCmd CAPTURING OUTPUT;
H PORT.USER = PORT.USER<1,1>
H PORT.ACCT = FIELD(PORT.WHO, ' ', A.POS)
H PORT.ACCT = PORT.ACCT<1,1>
P
C-->
C--> End of job
Hope this is of some use. Someone asked me: "why use anything else?". So I
don't. :-)
Bill
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Stu Glancy
> Sent: Wednesday, October 20, 2004 9:49 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [U2] [UD] running a subroutine
>
>
> Criticisms for Mark:
>
> Your concept won't work if there are commons that need to be set in the
> calling program. However, with the use of named commons they can be set
> in a test program and then use your print which includes the "$INCLUDE
> file named.commons" in the command line. (For those who don't know,
> named commons remain in memory between programs and can be used again
> until you logout.)
>
>
>
> Bill H. wrote:
>
> >Mark:
> >
> >The program at http://www.pickwiki.com/cgi-bin/wiki.pl?BPTest
> doesn't even
> >have these limitations.
> >
> >This wiki has some pretty nice free programs. I like to take
> the non-mvDbms
> >attitude: it's free so use it. :-) We should all post our free programs
> >there.
> >
> >Bill
> >
> >
> >
> >>-Original Message-
> >>From: [EMAIL PROTECTED]
> >>[mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson
> >>Sent: Wednesday, October 20, 2004 5:54 AM
> >>To: [EMAIL PROTECTED]
> >>Subject: Re: [U2] [UD] running a subroutine
> >>
> >>
> >
> >[snipped]
> >
> >
> >
> >>In fact, I welcome any criticisms or limitations anyone would
> have against
> >>establishing this PRINT command to handle everything. I know of 2
> >>limits: 1)
> >>No hanging ELSE or THENs. 2) Cannot use READNEXT. Other than
> that I'm all
> >>ears.
> >>
> >>My 3 cents.
> >>
> >>- Original Message -
> >>From: "Peter Olson" <[EMAIL PROTECTED]>
> >>To: <[EMAIL PROTECTED]>
> >>Sent: Tuesday, October 19, 2004 8:43 AM
> >>Subject: RE: [U2] [UD] running a subroutine
> >>
> >>
> >>
> >>
> >>>"but i want more!"
> >>>
> >>>found it!
> >>>
> >>>0001: PQ
> >>>0002: HSELECT
> >>>0003: H EVAL "SUBR('
> >>>0004: A\2
> >>>0005: H',
> >>>0006: A3
> >>>0007: H )" FROM VOC FIRST 1;
> >>>0008: P
> >>>
> >>>now it's
> >>>
> >>>tcl>TS AGE.DATE -2224,42
> >>>
> >>>Cool thanks!
> >>>
> >>>
> >---
> >u2-users mailing list
> >[EMAIL PROTECTED]
> >To unsubscribe please visit http://listserver.u2ug.org/
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
RE: Memo: RE: [U2] Spooler question
Tim: In standard Pick format one can assign up to three form ques to a printer or the same form que to multiple printers. That way a report sent to that form que would either: a) print to the single printer when it's free, or b) print to the 1st available printer the que is assigned to. Of course, maybe I'm dreaming. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Timothy Snyder > Sent: Wednesday, October 20, 2004 8:11 AM > To: [EMAIL PROTECTED] > Subject: RE: Memo: RE: [U2] Spooler question > > > "Dennis Bartlett" <[EMAIL PROTECTED]> wrote on 10/20/2004 09:52:54 > AM: > > > Yes I've looked at classes - the idea would hold is we only wanted to > print to > > any one of several available printers... > > > > the bummer is getting the month-end / genled reports to come > out oneafter > the > > other (ie on one printer) > > You could set up a class that contains all of these printers, and > send most > print jobs to the class; they would show up on whichever printer is > available. Send the reports that need to appear only on a certain printer > directly to that printer instead of the class. > > > Tim Snyder > IBM Information Management > Consulting I/T Specialist , U2 Professional Services > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Mark:
The program at http://www.pickwiki.com/cgi-bin/wiki.pl?BPTest doesn't even
have these limitations.
This wiki has some pretty nice free programs. I like to take the non-mvDbms
attitude: it's free so use it. :-) We should all post our free programs
there.
Bill
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson
> Sent: Wednesday, October 20, 2004 5:54 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [U2] [UD] running a subroutine
[snipped]
> In fact, I welcome any criticisms or limitations anyone would have against
> establishing this PRINT command to handle everything. I know of 2
> limits: 1)
> No hanging ELSE or THENs. 2) Cannot use READNEXT. Other than that I'm all
> ears.
>
> My 3 cents.
>
> - Original Message -
> From: "Peter Olson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, October 19, 2004 8:43 AM
> Subject: RE: [U2] [UD] running a subroutine
>
>
> > "but i want more!"
> >
> > found it!
> >
> > 0001: PQ
> > 0002: HSELECT
> > 0003: H EVAL "SUBR('
> > 0004: A\2
> > 0005: H',
> > 0006: A3
> > 0007: H )" FROM VOC FIRST 1;
> > 0008: P
> >
> > now it's
> >
> > tcl>TS AGE.DATE -2224,42
> >
> > Cool thanks!
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] running a subroutine
Shawn: There's a program on the "wiki" that allows you to execute BASIC code from a tcl line. http://www.pickwiki.com/cgi-bin/wiki.pl?BPTest This is an extremely useful program and will do exactly what you want, and a bunch of other things as well. It was originally written for UniData, then for UniVerse, then for D3. So an example would be: :BPTEST Value1 = "Hello" ; Value2 = "There." ; CALL subr.name (Value1, Value2) ; END Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Shawn Waldie > Sent: Friday, October 15, 2004 4:59 PM > To: [EMAIL PROTECTED] > Subject: [U2] [UD] running a subroutine > > Wondering if there is a way to execute a subroutine from the colon > prompt. > > Let's say I have a subroutine that is defined as having 2 input args > like: > > SUBROUTINE subr.name(arg1,arg2). > > > I would like to test it from the colon prompt without having to > hard-code the values of arg1/arg2...something like: > > :RUN BP subr.name "value.of.arg1" "value.of.arg2" > > Is something like this possible? What I've tried so far hasn't > worked. > > > * Shawn WaldieSan Juan College * > * Programmer/Analyst 4601 College Blvd * > * Phone: (505)566-3072 Farmington, NM 87402 * > * email: [EMAIL PROTECTED] * > * * > * HP-UX 11.11 UniData 6.0.4Colleague R17 * > > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Syntax for WRITE ... ON ERROR
Wendy:
According to the UV documentation:
The ON ERROR clause is optional in WRITE statements. Its syntax is the same
as that of the ELSE clause...
This would seem to indicate:
WRITE Expr ON FileVar, RecId ON ERROR
...error statement
...error statement
END
True?
Bill
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Behalf Of Wendy Smoak
> Sent: Friday, October 08, 2004 4:46 PM
> To: [EMAIL PROTECTED]
> Subject: [U2] Syntax for WRITE ... ON ERROR
>
>
> From the manual:
> WRITE
> Syntax
> WRITE expr {ON | TO} [file.var,] record.ID.expr [ON ERROR statements]
>
> There's no 'END', so how does it know what belongs to 'ON ERROR' and
> what's just the next line of the program?
>
> I need to put an IF statement in the ON ERROR clause, to check for the
> STATUS()=10 and do something different if that happens.
>
> A quick test shows that I only get one line for ON ERROR-- code on a
> second line beneath it gets executed whether the write succeeds or not
> (though I didn't try an IF block).
>
> Any advice? A GOSUB statement, or ??
>
> --
> Wendy Smoak
> ---
> u2-users mailing list
> [EMAIL PROTECTED]
> To unsubscribe please visit http://listserver.u2ug.org/
---
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: wIntegrate
Less: To install the wIntegrate host programs do the following: 1) open a wIntegrate session and log onto the host computer 2) get to tcl (raw tcl) 3) click on Run > Script... 4) select the Host folder where the wIntegrate client is installed 5) select "inst_pgm.wis" and continue from there. Before doing this I would always create a separate wIntegrate account. Then create the appropriate 'Q' pointer to the WIN.PROGS file, from the production account, and catalog all of the WIN.PROGS. Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Less, Mirwaan > (MIRW) > Sent: Thursday, October 07, 2004 4:53 AM > To: [EMAIL PROTECTED] > Subject: [U2] RE: wIntegrate > > > Hi All > > We are trying to import data from our host server to a web interface. I > read in the wIntegrate documents some part needs to be installed on the > server, but no where it actually explains how to do this. > > Can anyone please advise? > > We're running Unidata 6.0.3 on Unix AIX 4.3.3. > > Regards, > Mirwaan > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fancy Printer
Bruce: D3 has always had an excellent solution. They create a printer device item just like they do a terminal device. When we do a: CRT @(-3):@(-13):"HELLO":@(-14) for a terminal we can do: PRINT @(-143):"The printer has been initialized and is in landscape mode.":@(-110) This would have been great of all the mvDbms players had implemented it. Oh well Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Bruce Nichol > Sent: Wednesday, October 06, 2004 3:01 PM > To: [EMAIL PROTECTED] > Subject: Re: [U2] Fancy Printer > > > At 22:29 06/10/04, you wrote: > > >That's roughly the approach I've been taking. The problem is to interject > >these lines into the dozens, maybe hundreds of reports either in > English or > >Basic that are scattered throughout the procs in the application. Too bad > >you cannot have an 'initiation string' that hayes modems had to > preceed the > >output. > > > Asked for, and made the Pick Systems list of things to do in , I think, > 1998... Heard nothing since. > > That's progress > > With UV on Windows, we've used "Page Separators" or SETPTR ...GUI, > FONTNAME, FONTSIZE for years... *nix, I have no idea > > > >thanks. > > > >- Original Message - > >From: "Bill H." <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Wednesday, October 06, 2004 6:28 AM > >Subject: RE: [U2] Fancy Printer > > > > > > > Mark: > > > > > > A typical D3 solution is to: > > > > > > 1) sp-assign > > > 2) sp-open > > > 3) print PCL5 escape sequences > > > 4) print report > > > 5) print PCL5 ending sequences (usually [Esc]+E) > > > 6) sp-close > > > 7) sp-assign > > > > > > Hope this helps. > > > > > > Bill > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] > > > > [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson > > > > Sent: Tuesday, October 05, 2004 10:57 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: [U2] Fancy Printer > > > > > > > > > > > > Two printer questions: > > > > > > > > First, any recommendations on a multiple paper printer. For > > > > example, the first > > > > page would be tray 1 with a letterhead, Page 2 would be a form > > > > using tray 2 > > > > and pages 3,4,5 etc would be tray 3 having white paper. > > > > > > > > Have a working knowledge of HP PCL (5/6) I just don't know which > > > > printer could > > > > handle this kind of output. If the printer could staple the pages > > > > together, it > > > > would be that much better. > > > > > > > > I've seen copy machines with this kind of magic. I'm just > looking for > >some > > > > direction in choosing a printer. > > > > > > > > Second, sort of for D3. Are there any repetitive printer strings > > > > that could be > > > > send to the printer that precedes the actual output for each hold > > > > file. I'm > > > > dancing with a few clients having medium HP printers and the same > > > > report comes > > > > out landscape or portrait depending on the previous output > (pick or word > > > > documents etc). I would like to either precede the output > with an ESC E > >to > > > > clear to the defaults or actually force the default continuously. > > > > > > > > Presently I'm managing each report program by hand but there > > > > should be a more > > > > global solution. > > > > > > > > These are Laserjet Series 6's. I don't have this problem on HP > > > > 2000 series. > > > > > > > > Thanks in advance. > > > > --- > > > > u2-users mailing list > > > > [EMAIL PROTECTED] > > > > To unsubscribe please visit http://listserver.u2ug.org/ > > > --- > > > u2-users mailing list > > > [EMAIL PROTECTED] > > > To unsubscribe please visit http://listserver.u2ug.org/ > >--- > >u2-users mailing list > >[EMAIL PROTECTED] > >To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > > >-- > >Incoming mail is certified Virus Free. > >Checked by AVG Anti-Virus (http://www.grisoft.com). > >Version: 7.0.271 / Virus Database: 264.10.0 - Release Date: 05/10/04 > > Regards, > > Bruce Nichol > Talon Computer Services > ALBURYNSW 2640 > Australia > > Tel: +61 (0)411149636 > Fax: +61 (0)260232119 > > If it ain't broke, fix it till it is! > > > -- > Outgoing mail is certified Virus Free. > Checked by AVG Anti-Virus (http://www.grisoft.com). > Version: 7.0.271 / Virus Database: 264.10.0 - Release Date: 05/10/04 > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fancy Printer
Mark: A typical D3 solution is to: 1) sp-assign 2) sp-open 3) print PCL5 escape sequences 4) print report 5) print PCL5 ending sequences (usually [Esc]+E) 6) sp-close 7) sp-assign Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson > Sent: Tuesday, October 05, 2004 10:57 PM > To: [EMAIL PROTECTED] > Subject: [U2] Fancy Printer > > > Two printer questions: > > First, any recommendations on a multiple paper printer. For > example, the first > page would be tray 1 with a letterhead, Page 2 would be a form > using tray 2 > and pages 3,4,5 etc would be tray 3 having white paper. > > Have a working knowledge of HP PCL (5/6) I just don't know which > printer could > handle this kind of output. If the printer could staple the pages > together, it > would be that much better. > > I've seen copy machines with this kind of magic. I'm just looking for some > direction in choosing a printer. > > Second, sort of for D3. Are there any repetitive printer strings > that could be > send to the printer that precedes the actual output for each hold > file. I'm > dancing with a few clients having medium HP printers and the same > report comes > out landscape or portrait depending on the previous output (pick or word > documents etc). I would like to either precede the output with an ESC E to > clear to the defaults or actually force the default continuously. > > Presently I'm managing each report program by hand but there > should be a more > global solution. > > These are Laserjet Series 6's. I don't have this problem on HP > 2000 series. > > Thanks in advance. > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
FW: [U2] RE: U2 User's Group Charter
-Original Message- From: Bill H. [mailto:[EMAIL PROTECTED] Sent: Saturday, September 25, 2004 3:42 PM To: [EMAIL PROTECTED] Subject: RE: [U2] RE: U2 User's Group Charter Will: I have just a few comments. Generally, my comments have to do with the Board. It has always been my view that the Board should be elected annually. Good Board members are almost always re-elected in non-profits. However, if one wants to get rid of a Board member it is much easier to simply vote them out rather than taking extreme and difficult measures. Secondly, the Board should always have the authority to constitute themselves by appointing officers. There is no need for the membership to be involved with such matters as this is every much a Board matter as say when and where to conduct their meetings. I probably missed a few things but I hope you find this useful. :-) Bill ARTICLE III - MEMBERS Section 2: Membership Term. Membership is granted for one year with sufficient grace period for renewal, unless terminated as described in Section 5 (Termination of Membership). Section 5: Termination of Membership. Membership may be terminated in the following manners: 1) A member may allow their membership to lapse by not renewing (paying dues), 2) A member may remove themselves from membership in the Group by following instructions provided in the policies and procedures document, 3) The Board of Directors may remove anyone from membership in the Group, without cause, by a two-thirds majority vote of all eligible Board members, The Board of Directors will then notify the member of their termination and the terms, if any, under which the individual may re-apply for membership. In no event will the member be entitled to any refund of previously paid dues or assessments upon termination, or thereafter. Section 6: Member Rights. Each member has the right to vote: 1) to annually elect members of the Board of Directors, 2) to remove any member of the Board of Directors. 3) in any membership polling efforts, 4) to approve the annual budget, 5) to approve non-budget expenditures, and 6) to amend the Charter. Members also have the right to comment on any issue presented by the Board of Directors. ARTICLE V - BOARD OF DIRECTORS Section 1: Composition. The Board of Directors (the Board) consists of 9 members elected annually by the majority of the membership voting. A Board member must also be a member of the organization. If a Board member resigns their membership in the organization then they also resign as a Board member. Section 2: Officers. The Board of Directors shall elect the following officers: 1) the President, 2) the Vice President, 3) the Treasurer, and 4) the Secretary A majority vote of the board is required to confirm the appointments, such vote to take place at the first meeting of the Board after the annual election of Board members by the membership. Section 4: Terms of Office. All members of the Board of Directors are elected for one-year terms. All Board Members will remain in office until their replacements are duly elected and able to assume their duties. Section 5: Eligibility. Candidates for the Board must be members, and must have an interest in the U2 product line. All Candidates must provide a brief Biography to be included on the ballot. The Biography must declare if the Candidate has a financial interest in or is an employee of either the Vendor or the Vendor competitors. Section 6: Nominations. All nominees must accept their nomination and meet eligibility requirements to be considered for placement on the ballot. Any member may nominate them self for board member. The Nominations and Elections Committee will conduct the election according to the procedures described here and in the policies and procedures document. A member of the Board will serve as the Nominations and Elections Committee Coordinator. The election cycle begins with a Nomination Period, 60 days prior to the annual membership meeting. During this period, members may submit to the Nominations and Elections Committee nominations for any vacant position. Nominations must be submitted according to the rules in the policies and procedures document. The Nominations and Elections Committee will receive nominations, verify the eligibility of each candidate and confirm that the candidate is willing to be considered for the nominated position and serve if elected. After nominations have closed, 30 days prior to the annual membership meeting, the Nominations and Elections Committee will gather brief biographies of each candidate. The candidate should provide information about his or her relationship to the U2 community, including any potential conflicts of interest. These biographies will be sent to the membership as part of the ballot for the ensuing election. The Nominations and Elections Committee
RE: [U2] mvBase spooler
Allen: The command you're looking for is "LISTPEQS" (with no space in it). I think that's where you're having trouble. Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood > (CA) > Sent: Saturday, September 18, 2004 8:55 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] mvBase spooler > > > Hi Mark, > > I can twiddle bits with the best of them, but I have to have a > target. LIST > PEQS just returns [10] FILE NAME MISSING > > Sigh.. > > After using Unidata in different flavors/incarnations since 1992 working > with a native pick system is certainly a challenge. > > I'll look up the doc's on the -F option and see if that will help me see > things better. The main problem I'm having is that my print job which is > one of those PAGE x OF xx PAGES where you stick all the header and detail > lines into a print buffer as you count the total number of pages, > is doing a > page break every 24 lines and the frustration of dealing with SP-EDIT is > certainly not helping. > > Got an end of the month deadline and my program goes nutso. Whoopee! > > Now, really, this is so simple. I think the O/S is "helping" me by adding > in extra page breaks. I've checked TERM and printer output is set to > 132,60. I think I'll just run around the house pulling my hair out for a > while, and then maybe set in the corner and go quietly insane ;-) > > PrintTheInvoice: > EXECUTE "TERM" ; *test stmt > INPUT DUH.ME ; *test stmt > PRINTER ON > PRINT.COUNT = DCOUNT(PB,@AM) > FOR AEE = 1 TO PRINT.COUNT > LNO = PB<1> > DEL PB<1> > IF LNO[1,3] = '*#*' THEN > LNO.LN = LEN(LNO) - 3 > LNO= LNO[4,LNO.LN] > PRINT LNO:PAGE.COUNT > END ELSE > PRINT LNO > END > NEXT AEE > PRINTER OFF > RETURN > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson > Sent: Saturday, September 18, 2004 06:27 > To: [EMAIL PROTECTED] > Subject: Re: [U2] mvBase spooler > > > I work with U2 and non U2 MV's (MVBase, D3, MCD, most natives) and SP-EDIT > is a pain. It's so old school it's a shame D3/MVBase still use it in its > Jurrasic Pick incarnation. Don't get me started on all the combinations of > options to handle any problems. One of the manuals even refers to it as > Spooler Warfare. > > I have a utility that converts any SP-EDIT hold file to a file-level item > for easy editing. It uses the SP-EDIT spool=F option. Some systems create > multiple records and others assemble them into one. > > These file-level items are RUNOFF records. Thus to re-print the hold file > with any changes your system must have RUNOFF. If not, you can remove the > embedded simple RUNOFF commands (lines that start with a > ) and just > convert them to form-feeds. I think _HOLD_ matches lines to the SETPTR > settings and may not have char(12)'s. > > The filename that you *are* looking for is called PEQS and while you can > type LISTPEQS the data isn't really usable data. That's > why they have > LISTPEQS. > > I also have a utility that emulates the SP-JOBS of Microdata > which I believe > is the best spooler manager. It only replicates the SP-JOBS of hold-file > management and not SP-STATUS of device management. That is a real > different > thing on native versus network versions of D3/MvBase. > > Hopefully this helps. > Mark Johnson > > > - Original Message - > From: "Allen E. Elwood (CA)" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, September 17, 2004 7:43 PM > Subject: [U2] mvBase spooler > > > > Does anybody know in a Raining data mvBase system, *is* there a file for > the > > spooled jobs, and if so, what the name might be? I really truly hate > > SP-EDIT and have a spooler that I wrote for Unidata that I would like to > > port over. > > > > > > Allen E. Elwood > > Senior Programmer Analyst > > Direct (818) 361-5251 > > Fax(818) 361-5251 > > Cell(818) 359-8162 > > Home (818) 361-7217 > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV: Indexing I-Descriptors
Karl: Think about it like this...we have an address book file with names in it and we create a customer file with a pointer to the address book entry in it. In order to get the customer name we "translate" into the address book. Now we index both the address book name and the "translated" customer name which creates two (2) separate indexes on the name: one in the address book directory and one in the customer directory. Next we access the address book and change the name. When the address book record is updated the index routine deletes the old name from the address book index then adds the new name. Since there was no change to the customer record, that index _DOESN'T_ change. Hence, you've got two unsynchronized indexes. That's the problem noted. In order to correct this problem, the Customer record has to be updated to update its index. I don't believe U2 has an internal function to resolve this situation. You'll have to develop an application specific solution. Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Karl L Pearson > Sent: Friday, September 17, 2004 11:11 AM > To: u2-users > Subject: Re: [U2] UV: Indexing I-Descriptors > > Okay, I'll bite... What you say leads me to believe that a TRANS I-Desc > is dangerous because if the data changes in the remote file, then the > index isn't updated and the data in the local file's index is out-dated, > right > > if that's the case, then doesn't that mean that the local file's index > is holding all the data that is 'TRANS'ed from the other file? Isn't > that NOT how an index works? I thought it just pointed to the attribute > in the other file where it could look that data up. > > OR, is it that the stored procedure (TRANS I-Desc) might become > different from the remote file's procedure if that DICT item is > re-written/changed/removed, etc. ??? > > I'm a bit confused and would like some clarification... Perhaps what > I've understood all these years has been superseded somehow/where. > > KLP --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] mvBase spooler
Mark: I'm surprised you say this. The only "issue" I've found with the D3 spooler is it uses a hybrid "D3" file to store the output instead of allowing spooler jobs to be configured to go to an O/S directory. MvBase it's an R83 extension from Mentor and probably only exists because D3NT couldn't get it right for 10 years. So, it is what you expect. In D3 one doesn't have to deal with multiple files or runoff or loosing control characters when using the simple sp-edit command options (b, c, k)...but of course mvBase does (I'm pretty sure). Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson > Sent: Saturday, September 18, 2004 6:27 AM > To: [EMAIL PROTECTED] > Subject: Re: [U2] mvBase spooler > > > I work with U2 and non U2 MV's (MVBase, D3, MCD, most natives) and SP-EDIT > is a pain. It's so old school it's a shame D3/MVBase still use it in its > Jurrasic Pick incarnation. Don't get me started on all the combinations of > options to handle any problems. One of the manuals even refers to it as > Spooler Warfare. > > I have a utility that converts any SP-EDIT hold file to a file-level item > for easy editing. It uses the SP-EDIT spool=F option. Some systems create > multiple records and others assemble them into one. > > These file-level items are RUNOFF records. Thus to re-print the hold file > with any changes your system must have RUNOFF. If not, you can remove the > embedded simple RUNOFF commands (lines that start with a > ) and just > convert them to form-feeds. I think _HOLD_ matches lines to the SETPTR > settings and may not have char(12)'s. > > The filename that you *are* looking for is called PEQS and while you can > type LISTPEQS the data isn't really usable data. That's > why they have > LISTPEQS. > > I also have a utility that emulates the SP-JOBS of Microdata > which I believe > is the best spooler manager. It only replicates the SP-JOBS of hold-file > management and not SP-STATUS of device management. That is a real > different > thing on native versus network versions of D3/MvBase. > > Hopefully this helps. > Mark Johnson > > > - Original Message - > From: "Allen E. Elwood (CA)" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, September 17, 2004 7:43 PM > Subject: [U2] mvBase spooler > > > > Does anybody know in a Raining data mvBase system, *is* there a file for > the > > spooled jobs, and if so, what the name might be? I really truly hate > > SP-EDIT and have a spooler that I wrote for Unidata that I would like to > > port over. > > > > > > Allen E. Elwood > > Senior Programmer Analyst > > Direct (818) 361-5251 > > Fax(818) 361-5251 > > Cell(818) 359-8162 > > Home (818) 361-7217 > > --- > > u2-users mailing list > > [EMAIL PROTECTED] > > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Trigger slowness
Dennis: Whoa! Maybe I shouldn't do any upgrade work to UniVerse. I wonder if UniData has the same problem? Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Dennis Bartlett > Sent: Friday, September 03, 2004 12:19 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] Anyone have experience "mirroring" a HDD over a WAN > > > Jeff > > Triggers that have little effect on performance would indeed be ideal. > Alas, our experiments (prompted by Adrian Matthews post) have lead to > the firm decision to stay away from triggers as implemented in > UniVerse... > > A trigger that merely activated (ie a two line program having a RETURN > statement as line 2) doing nothing takes 10 to 15 times as long to > complete > > egwithout a trigger, 500 000 records takes 60.3 secs to copy > with a empty trigger, 500 000 records took between 600 & 700 > secs!!! > > This sure sucks! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Correlative referencing multi-value field
Allen: For an F correlative: First value (a number of ways but this will work): 002 9 008 F;9R Last value: 002 9 008 F;9;P;S;_ Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood > (CA) > Sent: Wednesday, September 01, 2004 12:05 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] Correlative referencing multi-value field in another > file > > > Hi Rod, > > I too have had the 'pleasure' of F and A correlatives. > > Once upon a time, a nice man named Dick Pick, who created Pick > basic, issued > a challenge. He said that there was no way in native Pick to access the > last value of a multivalued field and challenged anyone to find a way. > Enter Me. 'A' correlatives were new at that time and I created a > three step > dict. Dict "step1" converted value marks into "1" 's. Dict > "step2" summed > those 1's into a number, and Dict "step3" used that sum as an > index for the > value and BINGO last value of a multivalued field in native Pick! > > I did the 'victory dance' big time while singing "feeling > stronger" from the > "Rocky" movies :-D !!! And then proceeded to pack up my solution and send > the results to Dick. > > Dick replied to me that the challenge was only for F correlatives (ahh, > shucks..) but that he would publish my solution since nobody else had > ever done so yet. "Publish" as in "paper" before the internet became > widely used. So, that was my 15 seconds of fame > > Today, I prefer SUBR type dicts over all else if it takes me more than a > couple of seconds to try to figure out what to do. > > However, I'm currently working for a client with a..Legacy Pick > system without SUBR's. gaa... > > Allen --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Secure connex from outside world
Dawn: AccuTerm has SSH and it works great. This is probably your best solution if the outside contractors are developing on UD. Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Davis, Dawn > Sent: Friday, August 20, 2004 7:04 AM > To: [EMAIL PROTECTED] > Subject: [U2] Secure connex from outside world > > > Greetings to all. > > For those of you who are UNIX/UNIDATA/DATATEL clients, how have you > handled the following situation? > > We have a need for outside contractors to access our server to do some > development work. I will only accept a secure connection, and therefore > wish to use SSH. Which emulator are you using? I have successfully > used Putty at the unix/unidata level, but can never get the DATATEL > screens to display correctly. I am looking for a free client. > > > Dawn Janel Davis > DBA II > [EMAIL PROTECTED] > (410) 386-8058 > > Carroll Community College > 1601 Washington Road > Westminster, MD 21157 > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Wintegrate
Dave: > 1) AccuTerm supports U2 device licensing. I knew that. > 2) Up to 160 columns I knew that. > 3) The paste speed in AccuTerm is deliberately throttled down to > accommodate serial connections. The speed can be adjusted in > Tools->Settings->File Transfer. Change the ASCII interline > delay. Zero is OK for telnet or ssh, except on AIX (on AIX > try 25 or 50). I'm so happy!! :-) > Dave Taylor > President > Sysmark Information Systems, Inc. > 49 Aspen Way > Rolling Hills Estates, CA 90274 > 800-SYSMARK (800-797-6275) > (O) 310-544-1974 > (P) 800-339-1497 > (F) 310-377-3550 > www.sysmarkinfo.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Wintegrate
Ian: Many thanks. My ignorance is sometimes astonishing. :-) > wIntegrate: > 1) Allows for widths greater that 132, In some cases, I use > width of 200 characters. This doesn't work from Setup > Terminal and the width dropdown box. It only shows 80 or 132. However, I'm guessing I can script this somehow, by changing/copying the view132.wit script, as wIntegrate has good scripting too. AccuTerm, for instance, allows me to configure the "132" column control codes as a unique width/depth (e.g. 142,42). So, when the 132 column control code is sent from the server the client changes to a configured 142cols by 42rows > 2) Open multiple wIntegrate sessions All I ever get is the proverbial "Copy of " and a new session. In other words, If I "Open > New" my current session is terminated and the new session opens up in the same instance. If I "Open > Another" it, of course, opens a new session in another window. In AccuTerm, I can open a new session within the same instance like a multi-document window. So I may have 2, 3, 4, or whatever sessions open within the same opened instance of AccuTerm. > 3) Cut and paste of screen segment (cut & paste @15,10 - 72,20) > using right mouse button This is cool. After selecting, I right-clicked and got the "Text to ..." menu but copying to the clipboard isn't one of the selections available. So, I have to click on "Edit > Copy Special" and hope I didn't previously click the printer icon as that changes the copy target from clipboard to printer. In this case I need to "Edit > Copy Special To" and change to copy to the clipboard, then "Edit > Copy Special". Oh well, I suppose I need to assign a keystroke-set to invoke the EditCopy and EditPaste scripts (like [Ctrl][Insert and [Shift][Insert]. :-) > 4) I prefer wIntegrate user interface, but just my option You're right. It doesn't make much difference. > 5) Device licensing capabilities and ability to interface with > UniObjects to speed process of populating fields, grids. AccuTerm has the device licensing capabilities too...have no clue about UniObjects though. Your right, though, Ian. I'd live with either one if I had to (I use them both) and each has unique features that users would want. In order to recommend one over the other, the users requirements should be analyzed and if a low cost site license is required, AccuTerm will fit the bill. Thanks for the info. :-) Bill > - Original Message - > From: "Bill H." <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, August 11, 2004 11:18 AM > Subject: RE: [U2] Wintegrate > > > > Mark: > > > > I concur with Ross. AccuTerm offers _very_ reasonable site licensing; I > > think it's something like $995 unlimited users. In fact, so much so I'd > > wonder why anyone would use wIntegrate at a large site. > > > > However, wIntegrate has: > > > > 1) Query Builder > > 2) Cuts and pastes way faster > > > > and AccuTerm has: > > > > 1) Significantly better terminal emulation (width beyond 132) > > 2) Multiple open sessions within the same instance > > 3) Much nicer cut-n-paste capabilities (cut & paste @15,10 - 72,20) > > 4) Friendlier interface with user (at least for me) > > 5) The best darned site license price available. > > > > This is, however, a quick overview excluding programming > capabilities, but > I > > believe AccuTerm has tremendous scriting capabilities. > > > > To check out some of the nifty functionality available check out: > > > >http://www.asent.com/technical.html > > > > Hope this helps. > > > > Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Wintegrate
Mark: I concur with Ross. AccuTerm offers _very_ reasonable site licensing; I think it's something like $995 unlimited users. In fact, so much so I'd wonder why anyone would use wIntegrate at a large site. However, wIntegrate has: 1) Query Builder 2) Cuts and pastes way faster and AccuTerm has: 1) Significantly better terminal emulation (width beyond 132) 2) Multiple open sessions within the same instance 3) Much nicer cut-n-paste capabilities (cut & paste @15,10 - 72,20) 4) Friendlier interface with user (at least for me) 5) The best darned site license price available. This is, however, a quick overview excluding programming capabilities, but I believe AccuTerm has tremendous scriting capabilities. To check out some of the nifty functionality available check out: http://www.asent.com/technical.html Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Ross Ferris > Sent: Wednesday, August 11, 2004 6:48 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] Wintegrate > > > Does it HAVE to be Wintegrate ? AccuTerm offer very reasonable > site licences > > Ross Ferris > Stamina Software > Visage an Evolution in Software Development > > >From: [EMAIL PROTECTED] on behalf of Mark Johnson > >Sent: Wed 11/08/2004 05:48 > >To: [EMAIL PROTECTED] > >Subject: [U2] Wintegrate > > > > > > > >Being U2 and Wintegrate are intimately related, anyone have any hints on > >any > >dealers/VAR's that can offer a reasonable discount on 20 licenses. $4,000 > >is > >a > >huge amount of money to pay for this as an emulator and from what I've > >gathered, there's no site licenses. Wintegrate 98 is acceptable. 5.0 has > >server based thin clients which is unnecessary. > > > >The main attraction for Wintegrate is its virtually invisible ability to > >send > >emails using the local client. A side by side comparison of it > and Accuterm > >illustrates Wintegrates ease at many of the MV-PC functionality. > This email > >thing is huge. I've tried sendmail and BLAT which are fine but WIN.MLSEND > >beats them all. > > > >Please keep the replies as Wintegrate. > > > >Thanks. > >Mark Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] Sarbanes-Oxley
Sorry Tony. It was a beautiful day in the Pacific Northwest and I couldn't help reminding us all of the generalized useless nature of Congressional edicts. :-) When the dust settles I suspect it'll be like the year 2000 problem; by 2004 noone can remember it. :-) (gota add those smileys) As always, Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno > Sent: Thursday, August 05, 2004 8:51 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] [OT] Sarbanes-Oxley > > > My friend, we rarely disagree, even on these points. I've made no such > assumptions about rationality, actual vs intended effects, nor the > competence of those sponsoring laws. I only stated the possible > effect the > new laws will have on people worldwide. Are you responding to someone > else's comments?? If my intent wasn't clear, please let me know. Nothing > worse than being admonished for thinking something that never occurred to > you. :) > > Tony > > Bill H. wrote: > > > Tony: > > You make large assumptions: > > 1) Congressional lawmaking is rational > > 2) Laws passed don't have the opposite effect from intended > > 3) Those sponsoring laws have a clue what they're doing. > > When it comes to Congress, the less they do the better. :-) > > Tony Gravagno wrote nothing of the sort: > [snip - go check] > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] Sarbanes-Oxley
Susan: > See the thing is, we're letting the auditors drive this thing. Auditors don't drive this. Auditing is basic procedures plus statistical sampling of transactions to validate these basic procedures. Politics drive this. As Thomas Sowell often notes: politics does what feels good at the moment and mostly has _NO_ connection to results. > Don't get me wrong, they have to, to a certain extent. > The Sarbanes-Oxley Act of 2002 (available in its entirety at > Sarbanes-oxley.com) isn't really very specific > about HOW the numbers are verified. Only, in a nutshell, > that the CFO and CEO sign off saying "I KNOW that the numbers > on our financial statement are correct." Now because they > can go to jail if it turns out they aren't they are in a > bit of a panic. And they haven't a clue what to do about it. It has always surprised me that corporate management could delegate their authority over corporate financial reporting to "outside auditors". But then Congress does it every day. Heck, they don't even know how much they spend and what they spend it on. :-) > But they want to make sure that its CLEAR AND OBVIOUS that > they've 'done diligence'. In step the auditors. Now the > auditors - for the most part, let's be fair - don't know all > that much about the inner workings of a large > company's IT department and the mechanics and shenanigans > that put that final number on the 10K. So they come up with > a lot of (sometimes unnecessary) hoops for us to jump through. I'd suggest there are other forces at work here. For instance, if IT knows so little about business reporting, just as Finance knows so little about IT, is it any wonder what gets reported can be suspect? My point is there are more powerful arguments for structural ineffectiveness rather than some surreptitious human behavior. Besides, one controls human behavior by instituting institutional structural controls. :-) > What can we do about it? Well, first, we have to realize > that we've got this powerful, flexible environment which has > nurtured a seat-of-the pants attitude. Not a bad thing, > I mean we can produce amazing results on the fly. We've > learned to depend on ourselves that way. But it might look > a little scary to an outsider contemplating jail time. So > we might have to suck it up just a little and say okay, > we're going to be slowed down a bit by this. Perhape a realization that strict financial controls shouldn't be ignored because: a) noone knows how, b) IT controls the systems and doesn't understand the problem, or c) Finance understands the problem and can't control the systems. > And then the next thing we do is realize that the slow-down > should truly be temporary. While we work out procedures > that work and get used to them its going to slow us down. > But believe it or not over time the fire-fighting will > slow down and we'll get time back. I promise. I suspect this is good for those companies who don't do this now. For those that implement proper controls there shouldn't be much change, except when the "lawyers" get involved. > Then - it would be a really powerful thing if we educated > ourselves a bit (see this months article in Spectrum on > CobIT) and took the reins. Make sure some if this gi-hyoogic > investment is going to give Us something WE want. If we > come to management with a clear picture of how we can comply > we can set aside some of the hoops. Kind of like the blind leading the blind. :-) > I have one colleague whose auditors are demanding a full > table/chart of all access to all files by all programs. > Hey that would be a cool thing to have. But trust me, > its not required for SOX compliance. Its just the > auditors trying to come up with ways that look nice and > "black-and-white" and "legitimate" and compliant. If > somebody over there had proposed the - realistic steps - > that needed to be taken first, this would never have > happened. If someone would do a little reading and then > stand up and say "here's a plan" the requirement in > question would be scrapped in a heartbeat. The management, who are putting their necks on the line, so to speak, should be able to do what they think is necessary. The real difficulty is management are being hired who don't know how to judge the quality their business operations and activities. This is a primary cause of what you are seeing. The consequences of this are far reaching, economincally speaking of course. [snipped] > What SOX really is? A giant budget-boost for IT and a > guaranteed tech-onomic recovery. And incidentally an > opportunity for us to raise the bar on our software > quality. Gosh, possibly even legitimize Multivalue once > and for all! > > Ever the optimist,. As Bill and Ted always saidexcellent! :-) Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT] Sarbanes-Oxley
Tony: You make large assumptions: 1) Congressional lawmaking is rational 2) Laws passed don't have the opposite effect from intended 3) Those sponsoring laws have a clue what they're doing. When it comes to Congress, the less they do the better. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno > Sent: Thursday, August 05, 2004 4:30 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] [OT] Sarbanes-Oxley > > > Gordon Glorfield wrote: > > BTW My apologies to our non-USA list members as this is only > > pertinent to US operations. Sometimes I forget we are not all in the > > USA. > > Actually Gordon, while the legal responsibilities of compliance with USA > regulations only apply to USA companies, I can easily see initiatives for > SOA compliance driving non-USA companies that do business with USA public > companies. > > I'm no expert on the matter, but it seems to me that change will be (or > should be) driven from the top-downward to ensure compliance, and > that means > vendors, partners, and even some customers of these public > companies may be > requested or mandated to make changes in IT and/or manual procedures. So > all of you foreigners and grinning private companies out there better look > out. ;) > > I've seen a couple comments here that tell me that some people have a > different understanding of SOA than I do - I have no idea who's > right. I'm > under the impression that SOA doesn't just mean approvals need to be > recorded, but that much stricter auditing need to be done of any physical > process or policy which affect the bottom line. That means > creating lots of > cross-index files, periodic balancing of summary to detail, and > some decent > drill-down/reporting into all of this data. When someone asks where that > bottom line came from, it's management's neck on the line if they can't > click a few times to show the detail. The terms data warehouse, > cube, ETL, > and BI come to mind. Which is what we/MV are very good at once > we write the > code. > > We'll see how far it goes when management types actually do their reading > and then get serious. I don't think we (consulting community and > IT staff) > have been asked by our clients/managers to make driving changes > yet, simply > because there are lot of CxO types still ignoring SOA or still trying to > figure out how deep it really goes. Perhaps the thing to do is to contact > the CxO's with whom you have influence and ask them if there is > anything you > can or should be doing to help them get through this. > > I hope our resident expert, Susan Joslyn, can provide some insight. > > Tony > Nebula R&D > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] combining licenses [ot]
Ross: AccuTerm 2K2 has a checkbox for "U2 device licensing". I suspect this works otherwise it wouldn't be there. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of bruce nichol > Sent: Thursday, July 29, 2004 8:33 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] combining licenses [ot] > > > Goo'day, Ross, > > AFAIK, "device licencing" is tied to Dynamic Connect, wIntegrate and, I > think, Redback, ie, all the IBM stuff... > > My understanding is that if anybody else wants to get on the bandwagon, > they've got to approach IBM > > But then again, I could be proven w..w..wrong... > > At 12:19 30/07/04, you wrote: > > >Does anyone know if the "device licencing" (aka enterprise licence I > >think) will work with "any" telnet client (eg: we use AccuTerm), > or if it > >is tied to wIntegrate > > > >If I understand the licencing model correctly, does this also mean/imply > >that with the "workgroup" sized sites, each of the "max 24" users in a > >workgroup operates with device licencing is that correct ? > > > > > >Ross Ferris > >Stamina Software > >Visage an Evolution in Software Development [snipped] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Longstanding aversion to CNAME?
Charles: Are you saying that copying 13350*ABC to 13351*ABC wouldn't properly update the indexes? Or is CNAME using some obscure method of updating which bypasses the normal I/O that indexing handles? Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, > Charles > Sent: Friday, July 23, 2004 6:57 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] Longstanding aversion to CNAME? > > > UV10 STILL DOES NOT UPDATE INDEXES if the index is part of the ID. > > > From: Norman, David (SAAS) > > > > In UV9.4 CNAME didn't update secondary indexes, which left a bit of > > a mess behind. This has now been fixed, probably from 9.6. > > > > Example. A 2-part id: [internal-date]*[something] indexed on date ( > @ID['*',1,1] or FIELD(@ID,'*',1) ) > > Changing a "0" to a "1" in a date in a particular id: > > CNAME file 13350*ABC,13351*ABC > > will leave old, nonexistant id "13350*ABC" indexed under date "13350" > and will not add the new id to "13351". > > > IBM knows this (probably forwarded from the Vmark days), but resolutely > will not fix it because the underlying i/o routines used by CNAME are > different from the norm and won't easily support the change. This > list's archives will support that claim. > > One could reasonably restate that as, "It's too hard to fix, so just > live with the inherent data integrity vulnerability." > Or even, "Help, help we're being oppressed. Come see the vulnerability > inherent in the system." > > Chuck Stevenson > > > P.S. As for speed, for type-1 & -19 CNAME is faster than other > read/write/delete schemes one could program. I *believe* it invokes a > unix "mv" command which simply repoints the inode without actually > moving any files. Similar on MS. > > P.P.S. I recall CNAME was originally a PRIMOS command similar to unix > mv. Information just borrowed the name and handled type-1 ( UFDs > (UserFileDirectories) ) with the primos mechanism, and used its own > mechanism for hashed records. > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] (UV) Analyze.shm -s (Unclassified)
Karl: Not to butt in and add something stupid, but I notice this happening a lot when "ftp" is executing on the same machine. Other services can have the same impact. Hope this helps, Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Karl L Pearson > Sent: Wednesday, July 21, 2004 9:15 AM > To: u2-users > Subject: Re: [U2] (UV) Analyze.shm -s (Unclassified) > > > On Wed, 2004-07-21 at 03:24, Martin Phillips wrote: > > > We may also be looking for the wrong thing here. A semaphore collision > > count of 6 really is nothing to get excited over, especially if > the system > > had been up for a while. Looking back to Karl's original > posting, I think > > we need to know a bit more about how the "performance hits" exhibit > > themsleves. > > I've done a bit of checking and came to the conclusion that IO was NOT > an issue, as both disks loads are very even and in the low teens to low > 20%-ile of use. > > I changed the uniVerse tunable FSEMNUM from 23 to 53. Today, so far, the > load average is in the low 2s instead of in the 3s and 4s. Of course we > only have 30 of 42 users, so time will tell... > > The symptoms of the performance problem is that users notice things > going very slowly, especially selects and sorts, but also when typing > text there are pauses of parts of a second to a couple seconds when the > system is very sluggish. > > -- > Karl L. Pearson > Director of IT, > ATS Industrial Supply > Direct: 801-978-4429 > Toll-free: 888-972-3182 x29 > Fax: 801-972-3888 > http://www.atsindustrial.com > [EMAIL PROTECTED] > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate keep-alives
Andy: Thanks. What I've been doing is using AccuTerm. It has keepalives both in it's telnet and ssh. In fact, if it wasn't for wIntegrate's query builder I'd never use it. :-) Thanks, Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Andy Moore > Sent: Friday, July 09, 2004 1:24 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] wIntegrate keep-alives > > > DISCLAIMER: > This email and any files transmitted with it are confidential and intended > solely for the use of the individual or entity to whom they are addressed. > If you have received this email in error, please delete it and notify > the sender immediately. Please note that there is no guarantee that > this email or any attachment is virus free or has not been intercepted > or amended. > > Bill, > > We use wintegrate and on some of our sites we too have the issue > of dropping connections (if no activity for 1 minute!). > > I normally get around this by either pinging the server in a loop > from the Dos command prompt while using wintegrate ( ping > xx.xx.xx.xx -t ). If this is no good, how about a small program > that does something daft like a listu every 30 seconds or something? > > -Original Message- > From: Bill H. [mailto:[EMAIL PROTECTED] > Sent: 08 July 2004 19:37 > To: [EMAIL PROTECTED] > Subject: [U2] wIntegrate keep-alives > > > Does wIntegrate have any facility to send keep-alives, like AccuTerm does, > in order to avoid the inevitible over the internet? > > Bill > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] wIntegrate keep-alives
Does wIntegrate have any facility to send keep-alives, like AccuTerm does, in order to avoid the inevitible over the internet? Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CREATE.FILE one liner and UVSH.EXE
Ahhh. What goes around comes around. The reason these notices appear is because some "wonderful" individual finds a pettifogger looking to increase their bottom line at someone elses expense. And don't think it can't happen to you because these people don't look out for you they look out for themselves! :-( Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Donald Kibbey > Sent: Wednesday, July 07, 2004 8:48 AM > To: [EMAIL PROTECTED] > Subject: Re: [U2] CREATE.FILE one liner and UVSH.EXE > > > worthless legal dribble top or bottom > > > Go easy on him/her. It's probably the idea of the local PHB > (pointy headed boss) or legal eagle. > > > > > > Don Kibbey > Financial Systems Manager > Finnegan, Henderson, Farabow, Garrett & Dunner LLP > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: Re[2]: [U2] problems with XP and PE
Dave: So, this must be a permissions thing? Was you XP Pro installed clean or an upgrade? What permissions did it have if it was an upgrade? What permissions did you set it as? Maybe you should open all permissions of the directory where UD is installed (assuming you installed it in its own directory). Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of David Tod > Sigafoos > Sent: Friday, July 02, 2004 6:50 PM > To: [EMAIL PROTECTED] > Subject: Re[2]: [U2] problems with XP and PE > > > Dennis, > > It appears to work on my XPHome machine. I am currently trying to get > it to work on my HP laptop with XPPro. It is the Pro box that is not > working. > > Friday, July 2, 2004, 2:05:01 AM, you wrote: > > DB> XPHome cannot run anything that requires you to login as > DB> administrator, > DB> as you cannot login as administrator unless you do so from > DB> safe mode, > DB> and safe mode won't allow you to do anything! > > DB> XP Pro is more lenient > > DB> In your first post you said XP Pro > DB> In the last one you said XP Home > > DB> which is it? > > > > -- > DSig ` > David Tod Sigafoos ( O O ) > ___oOOo__( )__oOOo___ > > > If patriotism has to precipitate us into dishonour, > if there is no precipice of inhumanity over which > nations and men will not throw themselves, then, > why in fact do we go to so much trouble to become, > or to remain, human? Jean-Paul Sartre > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Proc
Glen: If you fax it to me I'll type it up into an MS Word document and send it back to you. Bill mailto:[EMAIL PROTECTED] (360)923-4838 > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Glenn Herbert > Sent: Wednesday, June 23, 2004 10:20 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] Proc > > > At 12:31 PM 6/23/2004, you wrote: > >... Maybe it got that reputation for lack of a good tutorial. > > Funny thing is I still have in my possession an 18 page PROC tutorial I > wrote back in 1986-87 time frame that guides the reader through all the > various commands and features to build a functioning PROC. This was > originally published by Prime Computer, near the conclusion of my > involvement with their PROC processor implementation, so someone > with a set > of Prime Information manuals will probably have the primer. Too bad I > don't have this in an electronic format to share. > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] double postings
Not me, and I use Outlook too. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] > Sent: Tuesday, June 08, 2004 12:23 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] double postings > > > Scott: > You're not alone...so far this week, I too have been getting > duplicates and > in some cases triplicates of some messages (in Outlook). --Brad > > -Original Message- > From: Scott Ballinger [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 08, 2004 2:03 PM > To: [EMAIL PROTECTED] > Subject: [U2] double postings > > Is anyone else getting double posts? I started getting duplicate > messages on 6/1. Not on all messages, but about half of them show up > twice. Not necessarily always the same poster either. We are using > Exchange server, Outlook client. > > Scott Ballinger > Pareto Corporation > Edmonds WA USA > 425 670 0831 > [EMAIL PROTECTED] > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > ### > > This message has been scanned by F-Secure Anti-Virus for > Microsoft Exchange. > For more information, connect to http://www.F-Secure.com/ > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV/Windows] Authentication / encryption issues
LeRoy: Could you please tell me the procedure to get wIntegrate to access uniVerse (or anything for that matter) using SSL (or where to find it)? Am I required to request, pay for, and install an SSL certificate on my dbms server? One reason I like AccuTerm is they use SSH, which is normally installed with Linux. So, it's just: check the SSH box (instead of telnet) and proceed as I normally would. Bill P.S. I read a major league "futzing-around" procedure to connect to UV using wIntegrate via SSH. Not exactly point'n click. :-) > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Leroy Dreyfuss > Sent: Monday, June 07, 2004 8:57 AM > To: [EMAIL PROTECTED] > Subject: Re: [U2] [UV/Windows] Authentication / encryption issues > > > Both UniVerse 10.1 and UniData 6.0 have secure telnet servers, not secure > shells. > > Regards, > > LeRoy F. Dreyfuss > Advanced Technical Services - U2 Technology Analyst > IBM U2 Data Management Solutions > Tel: 303-672-1254 Fax: 303-294-4832 > Mobile: 720-341-4317 > External email: [EMAIL PROTECTED] > WWW: http://www.ibm.com/software/data/u2/support > > www.ibm.com/software/data/u2/support - Open, Query, Update, Search - > Online! > > > > David Beahm > <[EMAIL PROTECTED]> > Sent by: To > [EMAIL PROTECTED] [EMAIL PROTECTED] > stserver.u2ug.org cc > >Subject > 06/07/2004 08:55 Re: [U2] [UV/Windows] > AMAuthentication / encryption issues > > > Please respond to > u2-users > > > > > > > Are you sure UniData has SSH? When was it added? We're very interested > in using SSH w/ UniData and SB+, and have looked at the SBClient -> > putty method as a possibility, but it's more complicated than we'd like. > Hearing that "it's a bit fiddly" makes me think we were right not to > pursue it further. > > Thx, > David Beahm > > uniVerse mailing list wrote: > > > This was discussed a long time ago from what I remember and there are > > (freeware) ssh shells that you can put on the server and client that > > will therefore encrypt the data (using putty if memory serves me > > correct).You set sbclient to point to the local ssh client which > > connected to ssh on the server which connected to telnet on the server > > via local host. It did work but was a bit fiddly. > > SSH has been on the roadmap for a longtime - its in unidata and would be > > put in the next version of universe. I'm sure it was touted to be in > > version 10.1 but this was probably over a year ago and goalposts > > move. > > > > Andy > > -- > --- > This email is confidential and intended solely for the use of the > individual > to whom it is addressed. If you are not the intended recipient, be advised > that you have received this email in error and that any use, > dissemination, > > forwarding, printing, or copying of this email is strictly prohibited. If > you have received this email in error, please contact the sender. > --- > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ > > [demime 1.01d removed an attachment of type image/gif which had a > name of graycol.gif] > > [demime 1.01d removed an attachment of type image/gif which had a > name of pic17731.gif] > > [demime 1.01d removed an attachment of type image/gif which had a > name of ecblank.gif] > --- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse in VB .NET
Tony: I always think of the costs for PDP to be similar to that of wIntegrate. You buy a database license and a connection license (like wIntegrate) for the client end. If you build the application as a windows app then you pay like wIntegrate (25 users = 25 U2 licenses + 25 PDP.NET licenses). If, however, you build an ASP.NET application then you pay less (25 users = 5 U2 licenses + 5 PDP.NET licenses) because the dbms license is only consumed when used and connections are shared. This is strictly an internal 25 user analysis. FlashConnect, in a non-persistent mode, costs $1,500 but you don't pay any connection licenses (25 users = 5 D3 licenses + 0 FlashConnect licenses). In addition, the purchased Flashconnect component resides on the Web server. Although a dbms "account" is installed on each D3 dbms server, it's the web-server component that is paid for. FlashConnect can be installed on multiple D3 dbms servers with no additional costs (except for dbms licenses, if required). Redback costs $4,000, which includes a $1,000 Redback server and two webshares (connection licenses) at $1,500 each. In a non-persistent mode the two webshares can probably handle 25 users = 5 U2 licenses + 2 Webshares). I believe each webshare takes a single U2 license. Each U2 server needs to purchase the RBO server and webshares. I could be wrong about how many webshares are needed. All reports I've heard say webshares work very efficiently. In addition, there is an enterprise pricing model available for high-load sites. Anyway, these are three distince pricing models and all represent different approaches to "webizing" an MV application. FlashConnect is more of a BASIC oriented approach but it doesn't work for U2. Coyote Web (not previously mentioned) is very similar to FlashConnect and does work for both U2 and D3 (maybe jBase too). So if someone is looking for an MV BASIC solution they would do well to use FlashConnect for D3 or Coyote for U2. Redback is a stable solution that allows for standard web development with connectivity to a U2 database. It is much more costly than FlashConnect if the data is distributed amoung several dbms servers. PDP.NET is a new product but allows development via the standard Visual Studio .NET IDE with connectivity to a U2 or D3 database using the .NET toolset. You can write the code in .NET or in MV (as can be done with Redback). Just a few additional notes. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno > Sent: Friday, May 21, 2004 4:32 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] UniVerse in VB .NET > > Colin Alfke wrote: > > We did (somewhat) investigate the pdp.net route but cost > > considerations precluded it for us. > [snipped] > The pricing is actually pretty good whether using persistent > connections, or especially for non-persistent apps which > are permitted per recent RD marketing. A non-persistent app > can be written with a thicker middle-tier, thicker client, > and/or in combination with web services. The final cost is > really dependent on how you code. > > One-for-one coding as we do with green screens will probably > make cost an issue, but then the question becomes whether > end-users will pay more for apps that are developed > using brand-names like IBM and Microsoft .NET. I think > other recent threads here have proven that people are paying > outlandish prices for brand-name GUI apps, so is added cost > at this tier really prohibitive? --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Re: Once again and updated. Cheapest way to have Pick talk to Web ?
Will: Try the following: http://www.vex.net/~ross/uv/ Hope this helps. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] > Sent: Sunday, May 23, 2004 6:30 PM > To: [EMAIL PROTECTED] > Subject: Re: [U2] Re: Once again and updated. Cheapest way to have Pick > talk to Web ? [snipped] > Any example of exactly how you "run UV from CGI-BIN scripts" ? > > Thanks > > Will --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniVerse in VB .NET
Colin: Thanks for the info...sorry for providing the list with misinformation. :-( I noticed that UniObjects for .NET is under development and is due for release sometime in mid 2004. Also, the calls to U2 from .NET use SQL not the U2 query language or a READ-type extraction. There's been a lot of traffic here about the difficulties of setting up UniObjects and UniOleDB for use by .NET. I didn't really think it couldn't be done, just not by a challenged individual such as myself. :-) I've seen IBM presentations about their intent to link U2 to .NET and those products are expected to be available in mid to late 2004 (the current set of products were not sufficient). I don't believe that for an MV developer, building an SQL layer to access and update MV data is the optimal MV solution. The PDP.NET product seems to be in the right direction and I assume IBMs forthcoming .NET solution(s) for U2 will be similar. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of > [EMAIL PROTECTED] > Sent: Friday, May 21, 2004 9:11 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] UniVerse in VB .NET > > > Not true. > > See www.ibm.com/software/u2 there is a link to a White paper: Using > IBM U2 and Microsoft .NET. > or for those too lazy to look through the page: > ftp://ftp.software.ibm.com/software/data/u2/pubs/whitepapers/ibmu2-microsoft net.pdf > > hth > -- > Colin Alfke > Calgary, Alberta Canada > > >-Original Message- > >From: Bill H. [mailto:[EMAIL PROTECTED] > >Sent: Friday, May 21, 2004 9:54 AM > >To: [EMAIL PROTECTED] > >Subject: RE: [U2] UniVerse in VB .NET > > > > > >Trevor: > > > >I was under the impression the UniOleDB product was not .NET > >compatible. I > >have been under the impression that the only thing one could > >do to make U2 > >.NET compatible was use either ODBC, fiddle with UniObjects > >for Java, use > >Redback, or use the Pick .NET Data Provider. > > > >Bill --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniVerse on Linux
LeRoi: Try the following: http://members.aol.com/_ht_a/mbtraining/tidevsys.html http://www.jes.com/pubs.html I have a few books on the subject (they're old and out of print). They are: + The Pick Perspective + Programming w/IBM PC Basic & The Pick Database System + Pick for Professionals (Advanced methods & techniques) + Exploring the Pick Operating System I wonder why these books can't be pdf'd and posted somewhere and downloaded for $5.00 each (credit card only). :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of LeRoi Keiller > Sent: Thursday, May 20, 2004 8:18 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] UniVerse on Linux > > > You know what's weird though (unless I'm wrong) - it's near impossible to > find any tutorials on UniVerse. Documentation yes, tutuorials > no. But if I > am wrong, I would love for someone to give me a tutorial. :o) Ideally, it > would be good if U2 (or someone) posted downloadable tutorials on the NET. > > Cheers, > LeRoi > > -Original Message- > From: Piers Angliss [mailto:[EMAIL PROTECTED] > Sent: Thursday, 20 May 2004 21:23 > To: [EMAIL PROTECTED] > Subject: RE: [U2] UniVerse on Linux > Importance: Low > > > You can download Universe Personal Edition designed for exactly > that (ie not > a production system) > > See http://www-306.ibm.com/software/data/u2/universe/ > > You will find documentation in the same place. I don't know for certain > whether it runs Ok on fedora but others will post if not > > Good luck > > Piers > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users > > > Disclaimer Notice > This message contains privileged and confidential information > intended only > for the use of the addressee named above. If you are not the intended > recipient of this message you are hereby notified that you must not > disseminate, copy or take any action or place any reliance on it. If you > have received this message in error please notify Ultradata immediately on > +61 3 9291 1600. Any views expressed in this message are those of the > individual sender, except where the sender specifically states them to be > the views of Ultradata Australia Pty. Ltd. > > To unsubscribe from receiving commercial electronic messages > from Ultradata > Australia please email [EMAIL PROTECTED] with the > subject heading > "Unsubscribe". > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] A CHALLENGE!
Jeremy: Be nice. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > > sorry guy, but you sort of lost out when you said 'if we can get > 5% of the 4 > million". that's b.s. and you know it. You have no business plan, > a stupid > idea and one of the worst gimicks i have ever seen. stop trying to cheat > people and go make an honest living. Everyone on this list has > worked hard > for their knowledge and you are just trying to exploit it. > > > First, to the moderator. If this is not the place to do this, tell > > me now and I will cease immediately or direct me to where I am > > authorized to do this. > > [snipped] --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] UniVerse in VB .NET
Trevor: I was under the impression the UniOleDB product was not .NET compatible. I have been under the impression that the only thing one could do to make U2 .NET compatible was use either ODBC, fiddle with UniObjects for Java, use Redback, or use the Pick .NET Data Provider. Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Trevor McNamara > Sent: Thursday, May 20, 2004 9:12 PM > To: [EMAIL PROTECTED] > Subject: Re: [U2] UniVerse in VB .NET > > > Has anyone ever had the problem i am having? > > Surly im not the only one? Seems there are a few people out there with > UniOLEDB problems with connections. > > Thanks > Trev > > > >From: "Trevor McNamara" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: [EMAIL PROTECTED] > >Subject: Re: [U2] UniVerse in VB .NET > >Date: Fri, 21 May 2004 08:06:57 +1000 > > > >Hey I am still having thse problems. I have tried to tick/untick > and use no > >username and password as well as just use the username. still > nothing gives > >me the same error. and when i click the test connection button, it wont > >work either. but the test works fine when i use the username and > password. > > > >any ideas? > > > >Thanks > >Trev > > > > > >>From: "Trevor McNamara" <[EMAIL PROTECTED]> > >>Reply-To: [EMAIL PROTECTED] > >>To: [EMAIL PROTECTED] > >>Subject: Re: [U2] UniVerse in VB .NET > >>Date: Thu, 20 May 2004 19:42:20 +1000 > >> > >>Thanks heaps for that mate, I will give it a go when i am at work > >>tomorrow. > >> > >>Thanks > >> > >>Trev > >> > >> > >>>From: "Brian Leach" <[EMAIL PROTECTED]> > >>>Reply-To: [EMAIL PROTECTED] > >>>To: [EMAIL PROTECTED] > >>>Subject: Re: [U2] UniVerse in VB .NET > >>>Date: Thu, 20 May 2004 09:27:23 +0100 > >>> > >>>Trevor > >>> > >>>the OleDB connection property pages include two options: one > for allowing > >>>a blank > >>>password and one for saving the password. > >>> > >>>Neither of these work. > >>> > >>>You need to connect using a user name that is passworded, and > supply the > >>>password > >>>manually when you open your connection. > >>> > >>>Regards, > >>> > >>>Brian > >>> > >>>On Thu, 20 May 2004 15:58:47 +1000 > >>> "Trevor McNamara" <[EMAIL PROTECTED]> wrote: > >>> >Hey, I am having come probs with connecting to UniVerse 10 > DB with VB > >>>.NET (VS .NET) > >>> > > >>> >I I can setup the UCI.SONFIG file fine and the Test Connection works > >>>fine. But once i > >>> >click on Ok to add it i get an error: > >>> > > >>> >Unable to connect to database. > >>> >Died in UCI::SQLConnect() with SQLSTATE IM980, Native > error:0 [IBM][SQL > >>>Client]Remote > >>> >password is required. > >>> > > >>> >When i click ok it comes up again. Then i click ok again it > goes away. > >>> > > >>> >Any ideas on how to fix this? > >>> > > >>> >Thanks > >>> >Trev > >>> > > >>> >_ > >>> >Personalise your mobile chart ringtones and polyphonics. Go to > >>> > http://ringtones.com.au/ninemsn/control?page=/ninemsn/main.jsp > >>> >--- > >>> >u2-users mailing list > >>> >[EMAIL PROTECTED] > >>> >http://www.u2ug.org/listinfo/u2-users > >>> > > >>> > > > >>> >This email was checked by MessageLabs SkyScan before > entering Microgen. > >>> > >>> > >>>___ _ > >>>This email was checked on leaving Microgen for viruses, similar > >>>malicious code and inappropriate content by MessageLabs SkyScan. > >>> > >>>DISCLAIMER > >>> > >>>This email and any attachments are confidential and may also be > >>>privileged. > >>> > >>>If you are not the named recipient, please notify the sender > >>>immediately and do not disclose the contents to any other > >>>person, use it for any purpose, or store or copy the information. > >>> > >>>In the event of any technical difficulty with this email, please > >>>contact the sender or [EMAIL PROTECTED] > >>> > >>>Microgen Information Management Solutions > >>>http://www.microgen.co.uk > >>>--- > >>>u2-users mailing list > >>>[EMAIL PROTECTED] > >>>http://www.u2ug.org/listinfo/u2-users > >> > >>_ > >>SEEK: Now with over 50,000 dream jobs! Click here: > >>http://ninemsn.seek.com.au?hotmail > >>--- > >>u2-users mailing list > >>[EMAIL PROTECTED] > >>http://www.u2ug.org/listinfo/u2-users > > > >_ > >Personalise your mobile chart ringtones and polyphonics. Go to > >http://ringtones.com.au/ninemsn/control?page=/ninemsn/main.jsp > >--- > >u2-users mailing list > >[EMAIL PROTECTED] > >http://www.u2ug.org/listinfo/u2-users > > _ > FOXTEL Digital - Your ticket to cinema at home: > http://ad.au.doubleclick.net/clk;7718915;9123289;x?http://www.foxt el.com.au/Campaign/channelchoice.html --- u2-
RE: [U2] Cost of Oracle vs PICK
Jeff: > Don't get me wrong. I love our Pick database model, but in the > modern usage of the word "database" our database model is at best > very "light." I would hazard to say it is really a file base or a > record base. For as flexible as it is, it still lacks in many ways > that can be taken for granted in other database models. I would suggest the opposite: MV databases provide much MORE than relational databases. Most of the RDBMS products are thought of as simply "data stores" while an MVdbms is really a data store and an application server in one. What makes it "lite" is the fact that the applications programer is responsible for "optimization" and "consistency" rather than the dbms. Think about how much work it takes to blindly "optimize" all queries when nothing is known of the application or the use of the dbms. > As for companies going "belly up" when converting, well, to me > that is a reflection of the design of the original database, not how > the data is stored. A complex, convoluted multivalue style > database may be a tough nut to crack. Multivalued data can be corrupt. It has been suggested, and I would agree, the cause of companies going out of business is bad management (plus bad luck). The reason I add the luck factor is because a lot of companies survive for quite a while with bad management, although at some point management will have to improve. :-) > If the Pick model provided the same "uniform" level of security > that standard relational databases do then the rest of the world > might look at it differently. Truth be told, I want a black box > database. I do not care how the grand designers implemented the > internal structures, i.e., records composed of delimited strings, > hashed files... If I have to know that then I have to know to > much. Knowing it may have its advantages. Hacking the data being > one of them, i.e., with the editor. Every single Pick style app I > have used requires application level security. So if the app has > no bugs, and you can never leave the app, you're good to go. > Personally, I have never seen either of these cases with a Pick app. Considering that (1) most SMBs (small to meduim businesses) run Windows and (2) U2 dbms products don't really have their own security (yet are the mvDbms market leader) it doesn't appear security is a top priority. But you raise an important point: an mvDbms needs to have better access using standard RDBMS methods. I've been testing the Pick Data Provider .NET lately and it seems to provide a good method for data access via .NET. This is good. In addition, it is promising for adding a graphical UI to a standard mvDbms enterprise application. > If the multivalued platforms incorporated modern security, a > better native language(s), built in integrity, constraints, and other > features that can be taken for granted in other world class > databases then the throngs (probably) would not be abandoning ship. > Unidata (or Universe, maybe every Pick type) can not pass a > rigorous security audit. If you work with privileged information you > need a better platform. One of the reasons the mvDbms model produces a large number of enterprise class applications is it allows those who know the business to be involved in the development of the application. This is good! However, I believe you are correct in stating the mvDbms model needs to offer the applications developer more tools to provide access and security to their applications. > But when you have statements like the one below from a Gartner > Group review how will you "ride the wave?" I personally would love to > salvage multivalue... This is the usual, database-centric, comments that make little sense to business people (especially in the SMB market). ROI is important, as the Gartner comments suggest. Every SMB is scrambling to control climbing costs and the mvDbms model is particularly well suited for this. Yes, green-screens are out, but with your suggestions of increased access and security an mvDbms application can offer a lower cost and more stable enterprise solution. Bill --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Cost of Oracle vs PICK
Ross: As we know, mvDbms products (other than U2) have security built in (see D3). It was often not used, however. We can only hope the U2 products address this issue (not through SQL) since mvDbms development relys on the applications developer and the business expert. I guess that's sort of the origins of U2 - Unix, where security is accomplished via the O/S system administrator, which is not an advantage to the application developer. An mvDbms was designed to be used by an application, and be managed by that application, not the other way around. This is understandable since the development group usually has a better idea of who and how access is to be granted. Remember, an mvDbms is both a database and an application server in one and this is an advantage. Universe has provided transaction processing and triggers. Some internal security would be nice too. Bill --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] Companies going belly up converting from PICK/MV
I was personally working at another health insurer, using the same CSC software I presume, who was working on another Oracle conversion. There were double the IT staff working on the Oracle design. Management knew the Oxford management (not unusual since they're in the same business). The conversion never got that far as the company was sold and converted to other software. It was amazing how much work that CSC software did with the minimal programming resources applied to it. There weren't any unusual billing problems with the software and only the claims payment side had some unusual features, which were identified and corrected. It is true the Oracle developers weren't in contact with the MV staff running the CSC system. There were a whole wing of them (20-30) working hard, but the demos weren't going as well as hoped and the deadlines were being pushed back and back. Of course, software costs should be ROI driven and an Oracle rewrite of CSC software is not. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Debster > Sent: Monday, May 17, 2004 6:52 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] Companies going belly up converting from PICK/MV > > > No...it did not start off with just a contractor wondering when they were > getting billed. When practitioners were not being paid that is > when a whole > lot of scuttle-butt was stirred. The conversion WAS blamed and the MV > system was most often the target even though they continued to use it (and > may still) to perform the processing of claims. This has been > documented in > the press. Funny the legacy system was a system widely used by other > companies within the same market without such problems. The Oracle people > did not talk to the MV people and vice-versa. The Oracle people > had no clue > about an MV system and for the most part vice versa. This of course makes > it difficult to replicate an existing legacy system. The conversion to > Oracle was orchestrated by those who did not fully understand BOTH systems > and how they functioned. > > What should also be mentioned is that this undertaking by Oxford was a > nightmare in Project Management in that there was a steady stream of > consultants through their revolving doors on both the Oracle and MV side. > Bringing in consultants for a duration of a short contract period, burning > them out and quickly replacing them results in inconsistent code > and a lack > of vision of the complete project from beginning to implementation. > > This is also a prime example of when end-users let their ego take over and > believe that they can produce a software product far better than what they > are currently using. Software vendors generally have a broader vision of > the market than an end-user and incorporate it into their product. > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of KevinJ Jones > Sent: Monday, May 17, 2004 8:56 AM > To: [EMAIL PROTECTED] > Subject: RE: [U2] Companies going belly up converting from PICK/MV > > > Here we go again. The annual Oxford Health Plans Misconception. > > Let me start with a moment of heresy. The migration to Oracle did not > cause the companies financial difficulties. This is the same company > that long before it migrated to Oracle was not billing many of it's > Freedom Plan customers. The only reason this was brought to light was > one of the Pick contractors had bought a plan and after 3 months asked > "hey, when do we get billed?" > > Oracle and a myriad of Oracle consultants said in writing that the > database as designed would not work.(i.e no vendor file) Which of course > leads to the visual of management sitting around in a room one day and > someone says "I don't understand why this failed, we got rid of everyone > who said it wouldn't work." > > That said the there was some real bizarre PICK code. I saw one program > that updated a file one attribute at a time with 22 WRITEVU's in a row > occurring after every row was entered instead if one write after all of > the data was updated. > > I think what OXHP shows is that U2/PICK is a more forgiving data base. > Whether that is bad or good is probably the real debate. > > The real problem at OXHP was to many people had at worst been promoted > to their level of incompetence, or more likely one level to high for > their experience. > > That said, they were the hardest working group of people that I have > ever been with. I did not always agree with them, but they always showed > up. > > >>> [EMAIL PROTECTED] 5/16/2004 6:39:02 PM >>> > I found several hits when googling > > Oxford-Health Oracle fiasco > > Is there a particularly good write-up on this story that anyone can > recommend? > > I still thought I read about companies that ended up going under > (perhaps > VARs) when attempting to migrate from MV/PICK to SQL-based DBMS's. > > Thanks. --dawn > > Dawn M. Wolthuis > Tincat Group, Inc. >
RE: [U2] My company is complaining about the U2 emails
Ray: I'm stunned, reading such a comment. :-) Bill > -Original Message- > [mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod > Sent: Friday, May 14, 2004 11:16 PM > To: [EMAIL PROTECTED] > Subject: Re: [U2] My company is complaining about the U2 emails [snipped] > ...Given that Andra's company is in Texas, which is > notorious for conservative thinking, ... --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] SPACE character ignored
Charles: D3 behaves like: :bptest x = '1' ; y = '1 ' ; if x = y then crt "equals" else crt "doesn't equal" BpTest*845955170 . [820] Creating FlashBASIC Object ( Level 0 ) ... [241] Successful compile! 3 frame(s) used. doesn't equal Hope this helps Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, > Charles > Sent: Wednesday, May 12, 2004 9:55 PM > To: [EMAIL PROTECTED] > Subject: RE: [U2] SPACE character ignored > > > Do both UV & UD behave exactly the same in this regard? > How about D3 & the other MV-related systems? > > cds > > > -Original Message- > > X = '1' > > Y = '1 ';* note the trailing space character > > > > X = Y is true > > > > > --- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] D3 Master Dictionary
Mark: > 1. D3 supports PQ and PQN procs interchangably. I stand corrected. I've only used PQN procs for a day 20 years ago, so I don't know if the differences work in D3. > 2. LIST MD = "CUSTOMER" resulted in No Items Present. If it's not there then I'm guessing a lot has been changed from the default D3 installation. All D3 installations I've been familiar with use the MD and the M/DICT is a synonym. So, something major has been done with the environment you're working with. > 3. I don't plan to change either MD or M/DICT. I will change my > habit and store my MD stuff in M/DICT. Hmm. That means your MD verbs will only work in the ADMIN account, not the current account (unless the MD item in the ADMIN account points back to the MD in the current account). > 4. Typing LIST-FILES got me the files listed and when I edited > the process LIST-FILES, I saw the M/DICT. This means the "LIST-FILES" item was modified from what D3 installs. The D3 LIST-FILES item looks like: 001 VR 002 3]9 003 F 004 dm,bp, list-files I'd conclude a good number of things have been changed and I'd always be careful with this installation. If you want a custom verb to work in the current account and the ADMIN account you'll have to load it in both the MD of the current account and the MD of the ADMIN account. Hope this helps. Bill --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
RE: [U2] D3 Master Dictionary
Mark: > Pardon being a D3 question but someone may have run into this > before. > > My new client has D3 on W2K. I edited MD BOB and made > 001=PQN, > 002=HTIME and > 003=P, saved it and then type BOB at TCL and get [3] VERB?. There are no PQN procs in D3 (I don't believe). Change field 001 to PQ. > I type LIST CUSTOMER and get output but when I type LIST MD = > "CUSTOMER" I get nothing. I'm not sure what's up since "CUSTOMER" is a file (or q pointer) and should reside in the MD. When you say you "...get nothing" what do you mean (let's see the command and the result). > I've found out that there's 2 MD's. One called MD which points > to that accounts SYSTEM defined space and another called > M/DICT which points to another account that contains the > cataloged programs, filenames, verbs etc and lets BOB work. That's unusual. Usually the MD "MD" item is a q pointer to the current account and so is the MD "M/DICT" item. They're synonyms. There must be specific reasons to change that structure and I'm not going to guess. I'm not sure what you mean by the "...SYSTEM defined space" but I'd guess you mean it points to the current account like: MD 'MD' size = 116 01 q 02 03 04 05 06 07 08 09 l 10 17 11 12 13 14 15 16 17 the item.id of a dictionary item is the name of the language element being defined. > So my question is what would happen if I made MD point to that > other account? Would I mess anything up. Their system runs > 20/7 but I'm not there at 4am to try this. I'd suggest you NEVER mess with this as someone else has made the change for some reason. Normally the "M/DICT" item is a synonym to "MD" but is changed for some unknown reason. In D3, you can reference another accounts MD by simply referencing "ACCOUNT,," or "ACCOUNT,MD,". If the "M/DICT" item has changed I'd think there is a reference to "M/DICT" somewhere but won't guess where. I can't say for sure, but when you execute a verb the MD is searched first. I don't know if the M/DICT is searched next or at all. So, either the "M/DICT" MD item is inconsequential or it acts a little like a PATH. Maybe a posting to CDP would answer this. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
