RE: XML and U2
Havving played with XML (and not very deeply) I got the impression that one can join FILEs to give you effective sub-sub-sub style nesting . However, seeing as my testing was limited to exporting a nearly-flat file into MS's Infopath, I didnt' try digging very deeply. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn M. Wolthuis Sent: 27 April 2004 23:08 To: 'Ronald Bourret' Cc: [EMAIL PROTECTED] Subject: RE: XML and U2 You are correct that the built-in XML -- U2 utilities go to sub-values and I think it makes sense to ignore the text values information at this point. Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: Ronald Bourret [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 27, 2004 4:01 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: XML and U2 Thanks. That clarifies things and I'll modify the entry for UniVerse to account for this. You do raise a new question when you say: The database comes pre-loaded with functions on multi-values and multi-valued sub-values and users write similar functions to lower levels if needed. Does this mean that you can have sub-sub-values, sub-sub-sub-values, and so on, ad infinitum? If so, do the XML tools handle this, adding more sub-elements as needed? The XML = DB mapping languages for UniData and UniVerse don't seem to handle this, except that the documentation for UniData seems to allow one level beneath sub-values, saying something about adding another sub-element in the case of text marks. (I dutifully ignored this, having spent too much time on the entries already :) -- Ron Dawn M. Wolthuis wrote: Hi Rob -- It is the rare table, indeed, that is created with a sql CREATE TABLE statement in a U2 database. U2 has SQL as a second language. It is not really an RDBMS, but uses a data model very similar to the one used by XML (a tree or di-graph structure). With the CREATE-FILE command a file gets created and then when a dictionary is populated, it is descriptive of the data (so not quite the same as an RDBMS that way) and can include sub-fields. The database comes pre-loaded with functions on multi-values and multi-valued sub-values and users write similar functions to lower levels if needed. Let me know if that doesn't quite answer the question. Thanks. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, April 27, 2004 11:30 AM To: U2-Users Subject: Fw: XML and U2 I finally got an answer back from Ron Bourret and he has added the U2 products to his XML enabled list of databases. Anybody want to answer his question? I could do it but I'm kind of busy right now. Jerry - Original Message - From: Ronald Bourret [EMAIL PROTECTED] To: Jerry Banker [EMAIL PROTECTED] Sent: Monday, April 26, 2004 6:32 PM Subject: Re: XML and U2 This is to let you know that I've finally added UniVerse and UniData to the list. You can see the entries at: http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#unidata http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#universe Comments / corrections welcome. (One question I had was whether UniVerse supports multi-subvalued columns as well as multi-valued columns. There are a number of references to subvalues in the documents, but the UniVerse CREATE TABLE command does not seem to support them...) Thanks for you patience, -- Ron Jerry Banker wrote: Ronald Bourret, Looking over your list of XML enabled databases I was impressed however I noticed that you included IBM's DB2 product but excluded IBM's most XML like databases referred to as their U2 product line (uniVerse and Unidata). Both U2 products are post-relational and use a nested file architecture very much similar to XML design and do have XML transformation tools (uniVerse more so than Unidata at the latest revision). XML documents can be output through their query language and imported into the database through simple commands. Another advantage is that the database can be accessed through it's native query language or with SQL. You should look into these products if you have not already. http://www-3.ibm.com/software/data/u2/ Jerry Banker Member U2UG -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy
RE: GUI as nice as character-based
Depends on your local system. If it's a winterm or xterm, where's the hard disk for you to have locally installed GUI apps? What you've just defined is a fat client, not a thin one. By definition, a thin client *doesn't* *have* a disk attached to the local workstation... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 22 April 2004 09:46 To: 'U2 Users Discussion List' Subject: RE: GUI as nice as character-based Schalk, you don't have to send the screen layout up and down the lines - have locally installed GUI apps, pointing to remote site data. When the program loads up, it gets all it's programming power from the local workstation, and data transfer is at a minimum. I know this is a nirvana, and a real drag to implement on legacy systems, but it can be done. One solution I saw was to have every possible screen display / prompt string stored in files (this app was a library system, and different language interfaces were stored). These storage files were stored locally on LAN drives, with the data stored at one central place. It worked a bomb. This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UD] Known ODBC Linux or 6.0 issues?
You'll need to search the archives for this (I don't have any of the stuff you mention :-) but there was discussion about calling virtual fields from ODBC a little while ago. I think at least one of the points was does it rely on environment variables or stuff set up by LOGIN? It appears that ODBC has a different login setup to a normal user - maybe even that UD needs a correct $PATH to find the executable for SUBR? I dunno. Or do the SUBRoutines rely on an initialised COMMON? I think it should work (that was the consensus of the previous thread iirc) but tracking down the exact problem might be a pain. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: 21 April 2004 10:51 To: 'U2 Users Discussion List' Subject: [UD] Known ODBC Linux or 6.0 issues? Sorry to have to throw this out without fully researching it first, but I've got a client with a pressing problem. They are in the final stages of preparing to switch over from their current DG-UX Intel platform running UniData 5.2 to a new Linux based system running 6.0 and ODBC doesn't appear to be working correctly when they access virtual fields that call SUBRoutines. There is one critical process that requires ODBC to be up and running and this makes use of a number of SUBR virtual fields. Needless to say, everything works fine against the DG. The new system is RH 2.1 ES (kernel build 2.4.9-e34smp) running UniData 6.0.5. Is anyone aware of any known issues with ODBC on this platform, or of any gotchas they may have forgotten to set up properly regarding calling SUBRs via dictionary fields accessed through ODBC. The queries apparently run fine if cut and pasted in at the sql prompt (other than a few warnings about missing associations), but blow up with a variety of errors (fetch errors, 81002 and 81001s) when run through MS Query. Ramping the logging level at the server up to 9 seems to show the server log just stopping in mid flow at about the time that the queries blow up and die. Queries which only access data fields run OK, but if they call a SUBR it gets nasty. I'm at a bit of a loss on this one and working only on info gained from a long telephone call at present so I'm afraid the details are sketchy. I'm hoping someone in a different timezone has seen this before and solved it (or knows it can't be solved) so we can short-circuit things a bit tomorrow as I try to track down and resolve this before cutover on the weekend! Cheers, Ken -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: GUI as nice as character-based
That's a LITTLE unfair :-) Yes Miguel is a publicist, but the war is fought mainly by clueless lusers who don't understand the real issues :-( KDE is C++ and Free, Gnome is C and Open. There are fundamentally deep issues with regard to all four choices, and the developers mostly respect each others' viewpoints. It's a shame the lusers can't too. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Colquhoun Sent: 21 April 2004 11:46 To: U2 Users Discussion List Subject: RE: GUI as nice as character-based Hello Tony, At 03:56 PM 21/04/2004, Tony Gravagno wrote: I'm just trying to find the time to get into Mono. I believe it has a bright future and will be great for all of us wanting cross-platform access into our MV apps. Maybe also have a look at dotgnu: http://www.gnu.org/projects/dotgnu/ The mono project gets way more publicity, the project leader is renowned for deliberately stirring to promote his projects(...i think he started an open source 100 year war with the gnome-kde stuff). - Robert -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: RE: We need a web based Forum!
Except you've only addressed one minor point of mine. The fact is, most activity seems to happen stateside. Email means I can actually hold a conversation with someone stateside. A forum means any conversation is likely to go like a satellite phone - with a TWELVE HOUR delay (on average) between each side speaking :-( It's bad enough with the 3 second delay you typically get on the phone as the signal goes via outer space, without it being twelve hours as it goes via timezones. For me, the practicalities are that fora turn into passive entertainment. I can't join in, even if I want to. So don't expect me to bother ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey Mitchell Sent: 21 April 2004 15:18 To: U2 Users Discussion List Subject: OT: RE: We need a web based Forum! OK, I hate to keep perpetuating this thread, which has nothing to do with U2, but... That has not been my experience with web forums. Most forum software I have seen brings topics with recent replies to the top, and highlights threads with new activity. I have seen long dormant threads become active again weeks or months later because someone happened to read them and reply. As for the lack of immediacy, good email integration seems to me to solve that. The argument that, for some people, access to email is more acceptable in their environment than access to email, however, is a very valid one. On Wed, 2004-04-21 at 02:03, Anthony Youngman wrote: But it is far less immediate. I sometimes have conversations with people stateside. I'll find an email when I get to work at 8am BST (British Summer Time, not Bering Straights Time :-). I'll respond. Then the person it was aimed at will get to work at, say, 9am New York Time, respond, and we bounce ideas around for an hour or so before I go home. A forum relies on me (a) noticing their message at 8am my time - and forum scanning puts me off - I miss loads. Then (b) they've got to notice early morning their time that I responded, and (c) I've got to catch them at it! That just won't happen, in the normal course of events. One of the reasons I've abandoned many fora is that I keep coming across plenty of conversations that happened while I was away, but could easily have contributed to. And I get p*ssed off that my (I fool myself they are relevant) comments get ignored because the subject has now gone stale. Cheers, Wol. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey Mitchell Sent: 21 April 2004 00:10 To: U2 Users Discussion List Subject: Re: We need a web based Forum! Why is that an argument? A forum is not the same as a chatroom. It is just as persistent as email. On Tue, 2004-04-20 at 16:38, Kate Stanton wrote: From New Zealand, the main argument against a forum is that we sleep while you work and vice versa. It is 9:30am here now, and 7:30am in Sydney - expect to hear similar story from Australians in about 2 hours. This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- Geoffrey Mitchell 314-684-1062 Programmer/Analyst [EMAIL PROTECTED] Knights Direct -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] ODBC Account Flavor
All our accounts (including ODBC) are either PI or PI/Open flavour. However, as this is very close to IDEAL, it's no surprise that we don't have any (serious) problems. (If you exclude the fact that HS.UPDATE.FILEINFO seems to close the wIntegrate connection rather too often for comfort :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Firl Sent: 20 April 2004 01:05 To: U2-Users Distribution List (E-mail) Subject: [UV] ODBC Account Flavor I'm plowing through a project to setup a standard UV-ODBC table and column definition for our application. Our application database accounts are setup as PICK flavored accounts. For ODBC, we're going to setup a separate account for each application account with file pointers to the DATA portion of files and cleaned-up local dictionary files. I've been told by IBM that the ODBC account must be IDEAL flavor. I know that isn't totally true as I have a proof-of-concept system setup where the ODBC account is setup as PICK flavor. Like application accounts, is the flavor of the ODBC account simply a matter of preference? Or are there limitations with ODBC and PICK flavored accounts that I should be aware of? Tom Firl Columbia Ultimate -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: We need a web based Forum!
I think forums may be available (again) soon on the u2ug site - I'm not sure. But one of the reasons behind the muddle at u2ug was that a lot of people DON'T like forums - they find them a pig to use even if they have access. I don't take the digest, for precisely the reason you've discovered. I find google a pain because it makes news look like a forum - but I use it if I have to. I use news or email from choice. So, if and when the fora reappear, don't expect to find me (or a lot of the other experts) there. TNSTAASB (tnstaa silver bullet) :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hogan, James Sent: 20 April 2004 10:06 To: '[EMAIL PROTECTED]' Subject: We need a web based Forum! Trying to follow a thread in the digest today I had to wade through pointless re-inclusions of previous posts where people had just hit the reply-to option without doing any editing. We have been here before I know. But a forum would sort all this. It is user friendly and you are able to follow just the threads you want to. You can also easily pick up a thread and follow it's history. The main argument against the forum is that some of you out their can not access the web. How can anyone in a development role do their job properly nowadays without being able to access the web. I am sure that if all we had was a forum on the web, admin departments would be told that X needs web access and they would get it. James Hogan Sungard -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: GUI as nice as character-based
And if they show any sign of regaining their old market share on Windows, expect the and work to cease to be true ... Actually - isn't that one of the aims of Longhorn - to totally break all legacy doze apps? Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol Sent: 20 April 2004 06:56 To: U2 Users Discussion List Subject: Re: GUI as nice as character-based At 15:12 20/04/04, you wrote: just ask WordPerfect and Lotus (or DOS devotees or dumb terminal vendors or Eudora users or Netscape shareholders or vb6 developers). And, just what's wrong with these things?They're still available. And work And are used. This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PI Open is going away
I'm planning (when I get the chance) to resurrect the EXL7330 in my garage. And the reason I salvaged it from work is that it has PI/Open on it ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fitzgerald Sent: 15 April 2004 21:34 To: 'U2 Users Discussion List' Subject: RE: PI Open is going away Clif, We're using PI/Open on our HP for a subset of our accounting data. We also have a copy of PI/Open 3.2 running on an old Prime/EXL - the MIPS based box that Prime used to sell! We may even have a copy of PI/PC around somewhere. Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Clifton Oliver Sent: Thursday, April 15, 2004 1:08 PM To: U2 Users Discussion List Subject: Re: PI Open is going away As one of the engineers of the original Prime INFORMATION, I am curious how many people on the list are still using PI Open. Anyone care to sound off? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Apr 15, 2004, at 12:10, Jerry Banker wrote: The DB2 IMS Today newsletter has the following announcement. U2 Product Lifecycle Announcement Effective October 1, 2004, IBM will withdraw from marketing the programs noted below. If available, their replacement products are listed in the second column: PI/Open -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PI Open is going away
Ummm... My wife will murder me for this ... but I'd love to have a copy (we've lost a lot of ours). Scan them or whatever. If I'm up your way for some reason (I go up the M1 regularly, but have my wife with me ...) I'd relieve you of them. Cheers, Wol -Original Message- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: 16 April 2004 09:54 To: U2 Users Discussion List Subject: Re: PI Open is going away I was one of the two technical managers for the development of PI/open. It's always sad watching a product that you worked on be put into retirement. Perhaps I can now throw out my collection of PI/open manuals. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users 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 have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: U2 Personal Editions
For SuSE, I had to remove all the options to cpio. Note also, that when it tries to set up the daemon to autostart on boot, that fails also because SuSE uses a different /etc/rc.d setup. That needs manually fixing, because you can't run uv as a user unless uvd is running. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 07 April 2004 22:28 To: U2 Users Discussion List Subject: RE: U2 Personal Editions For Debian, i had to remove the c option from the taperead='cpio -ivc... line. Somewhere along the way, i must have installed compress/uncompress, so that wasn't an issue. Now, if i can figure out why my xterm gets clobbered when i start uv as root. Something wrong with the emulation somewhere. Seems to work ok as a normal user. There must be something in the admin menu that messes it up. Charles Hawkins -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2
Okay, it's AIX not linux, but I've just noticed that RAM = swap. You are an ABSOLUTE FOOL if you do that on linux. Maybe (or maybe not) the same applies to AIX - quite likely since they are both nixen and probably manage memory similiarly. Double swap space to 8Gb and see if that improves matters. Oh - and if you don't believe me, a swap = ram configuration will CRASH the early vanilla 2.4 kernels and that's 2002 vintage. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Richardson Sent: 16 April 2004 14:06 To: U2 Users Discussion List Subject: Re: Performance Degraded running u10.0.0 in Aix 5.2 ML 2 Performance of UV applications on various Operating Systems is not rocket science. Perhaps better described as large, nasty tight onions that need peeling, one layer at a time, and understanding what each peeled layer is doing and why. Once this knowledge is acquired and understood, a plan can be built and executed to attack/resolve the problem. Are users logging out/off when they're done using the system, or when they've completed some large tasks or operations? How often is the system rebooted? RAID 5 file systems can slow down IO. We'll need specifics on file system setup and parameters. How many users? What are these users doing? Have you got everyone and their siblings all running SELECT and SORT operations all the time? Data Entry out the wazoo? How big are the files, and how are they sized? How frequently does data change in the files, (grow, shrink, etc...) How big is your /tmp file system, and what kind of file system, and where is it physically located?? Provide it it's own file system, on it's own disk or disk set, (i.e. not the same disks where other activity is going on). 4GB of RAM, yet only 4 GB paging/swap space? Where is this swap paging space, (i.e. what disks?) topas may be fine for quick and dirty analysis and understanding, but using it extensively can help contribute to performance problems. You need to configure and tune the platform, the OS, the UV DB, the IO sub-system, the applications, the users, and the administration/operations, and thenensure they're all coordinated with each other, to maximize platform performance. To find, (and therefore address resolve), the root causes of what is happening here, you need to profile the platform using something such as the DPMonitor, (extremely low-overhead monitoring Agent) and display/crunch the performance metrics on another platform, (i..e. a Windows Performance Explorer Console). Using this method, you'll be able completely profile the entire platform, (OS and applications), around the clock, and then easily dial into specific timeframes where problems are occurring, and fully understand exactly what is happening and learn why it is happening, so it can be addressed and resolved, and measure the progress along the entire way. The DPMonitor is available with a free 10 day evaluation license where it will track system-wide performance metrics. Fully licensed version will track individual processes that you select, or all processes if you so desire. When you monitor all of the processes, you can quickly and easily identify processes deserving further analysis, and stop tracking processes that are not casuing any problems. More information on the DPMonitor can be found at http://www.deltek.us and the DPMonitor can be downloaded right off the website. If you're short on memory, DPMonitor will allow you to see how much memory you will need to allow the system to run as fast as it can, given how you're running it. If you need tuning of OS or UV parameters, or other things that ay be playing contributing factor/roles, the DPMonitor will clearly point this out, grahically, so that anyone can plainly see what is happening. Once you make any changes, you'll be able to monitor, and measure, any differences, consistently, and prove whether or not you have improved, or detrimented, your cause. Best of all, you'll be able to show, prove, and justify to management what you're doing, and why, and show them what it will take to get the problems addressed and resolved, positively, without question. Hope this helps. I know the DPMonitor can will help. I have used it personally, numerous times, to peel many a complex onion, understand what is exactly going on, find out why, and then put together and executed plans that have successfully addressed and resolved similar problems and streamlined operations moving forward saving many a business significant time, frustration, and money, and then ensured that any all operations moving forward were done from a pro-active, knowing ahead of time manner, rather than fire-fighting problems on a continual basis. If you want something done, why not do it right, once? Stop beating your head against the onion wall! Work smarter! Let the DPMonitor be your detailed, EKG-like instrument to cut to the heart of your complex application server
RE: DATA statement Clearing?
We have programs that make extensive use of data statements. And they regularly screwed up because people asked us to change the prompt sequence (adding new requests or whatever...) So I've been steadily rewriting them all to use arguments on the command line, retrieving it all from @SENTENCE. One little tip - I always add the option BATCH, which is set by looking for the word on the command line as the program starts. My input code then knows, if this flag is set, that there is no user to ask the information from. And if I'm asked to add more user input, seeing this option in other inputs reminds me that I need to add it here, and provide a default because I'm not allowed to prompt. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karl L Pearson Sent: 01 April 2004 18:39 To: U2 Users Discussion List Subject: RE: DATA statement Clearing? You bring up a good point. Design-time decisions seemed to make sense that this would be the easiest way to do this project with the greatest amount of 'after the fact' support freedom, so, reading the data from a file wasn't considered. However, we just had a discussion and decided it wouldn't be that tough to make the change over. CLEARDATA works on uniVerse, too. Thanks. Darn Manuals. Why can't they just talk to me? Karl This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: PDF Manual [Data typing in MV Basic]
Acrobat 6, certainly initially, had, well, issues. Something to do with compatibility, and not liking files created by earlier versions. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart Boydell Sent: 02 April 2004 00:24 To: U2 Users Discussion List Subject: RE: PDF Manual [Data typing in MV Basic] -Original Message- Behalf Of Robert Stearns found) unified search facility. The online manuals are great for those times you want an indepth discussion of a topic, or to first learn a subject, but are abysmal (IMNSHO) as a quick reference for a syntax question or a summary. While it has not been updated in a few versions, Get Adobe Reader 6. It is FREE. It has a very _good_ search facility (Ctrl-F). As long as you have installed the manuals with the indexes you can search across all the manuals with a variety of options. the data is sufficient in day to day programming. BTW the current PDF is set up for larger pages (8.5x11 IIRC) so that ehe Kinko solution is not a particlaraly good one, especially since the PDF contains page images (not text) for some down level version (9.? I believe). That is not particularly conducive to reformatting. Poppycock Regards, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Data typing in MV Basic
And seeing as I'm playing around with a p-code compiler ... It's very simple for the compiler to do it that way. All the compiler cares about is is it a string or literal?. And if it's a literal, it processes it as unquoted ascii text. So, as far as I'm concerned, as it comes from the lexer into the parser I have already lost the distinction between '1' and '1', and can't tell them apart... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Lewington Sent: 01 April 2004 09:32 To: [EMAIL PROTECTED] Subject: Re: Data typing in MV Basic Anthony Youngman... 'A = 1' and 'A = 1' both result in IDENTICAL p-code. This is certainly how the UD compiler works. I say its a bug, because 'A=1.1' and 'A=1,1' *don't* result in the same p-code - and it doesn't just differ by the comma - one is stored as a string the other as a number. This then causes problems running with 'SET.DEC ,' (which changes the decimal separator to a comma) since the 1.1 which was meant to be a literal gets changed to 1,1, eg... VERSION=1.1 READ VERSION.INFO FROM VFP,VERSION ELSE VERSION.INFO='' The version file is keyed on strings which happen to be numbers. The version code is hard-coded into a program as a string - ie it has qoutes round it. With 'SET.DEC ,' to please some Europeans, the s/w converts VERSION to 1,1 before doing the read since it is a number not a string - and so fails to read the item. I'd want this to happen with 'VERSION=1.1' which is specifying a number. As with everything, this can be worked around, but what a pita. Simon -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: XML or WORD Format???
In one word - it's IMPOSSIBLE. Okay, you may be able to achieve what you want, though. The thing is, the output of pdf and pcl is an image, Word and xml are structured text. You can't go automatically from a structure-free format to a structured format. I'd investigate ghostscript, and see if you can get it to throw out a text document rather than postscript (or feed the postscript through a ps2txt filter), but if your original pdf or pcl was of a graphic, then you're stuffed without an ocr filter in place. So, basically, what you're after can be achieved, but without knowing what is IN your input files, it's impossible to recommend (or even guess) what might or might not work. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: 01 April 2004 14:33 To: U2 Users Discussion List Subject: XML or WORD Format??? Does Anyone know of a way to convert either .pdf or PCL formats to XML and/or WORD format that will run under HP-UX. Thanks in advance. John. *** THIS MESSAGE IS INTENDED ONLY FOR THE USE OF THE INDIVIDUAL OR ENTITY TO WHICH IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, forwarding, or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail or telephone, and delete the original message immediately. For more information, please visit http://www.bakerlaw.com. Thank you. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to launch remote browser from UniVerse server?
If WIN.PCRUN requires 2 parameters, then I guess the second parameter should be null. And which way of doing things is best? To throw up the url in the USER's choice of browser, or the PROGRAMMER's choice of browser? I'm afraid I come from the old school - give the user what they want, if it's easily done. I get well pissed off when my computer starts displaying things using the wrong app. And I don't see why I should impose such disfunctional behaviour on my users. (Plus it's a neat thing to know that windows will execute a document using its default app - it may be that IE is the default app for .html in 99% of cases, but what's the default for .jpg? - how do you know the app you're about to ask for even exists on the client?) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 01 April 2004 14:38 To: U2 Users Discussion List Subject: Re: How to launch remote browser from UniVerse server? I believe WIN.PCRUN requires 2 parameters. Please provide the other. Thanks. You could provide your desired browser in the first parameter and the URL in the second. Just because a small fraction doesn't use IEXPLORE doesn't mean that 99.9 percent don't either. Everyone can figure this out for themselves. - Original Message - From: Anthony Youngman [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Thursday, April 01, 2004 4:46 AM Subject: RE: How to launch remote browser from UniVerse server? Except that it assumes that IE is the default browser. And at home, where my firewall is configured to BLOCK IE, it would probably get you nowhere. I'm not sure of the syntax, but something like CALL WIN.PCRUN(URL) should fire up the url in the default browser. There were reports on u2-users a couple of weeks back that this sort of thing (executing a document) does work fine. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 01 April 2004 04:53 To: U2 Users Discussion List Subject: Re: How to launch remote browser from UniVerse server? If running Wintegrate this databasic command works: CALL WIN.PCRUN(IEXPLORE.EXE, URL) where URL could be any web address. I use it often to retrieve shipping from UPS.com or hooking map sites to dispatching screens. my 1 cent. can't help you on topic 2 unless you post the report as HTML to a PC file and have the URL be the file reference. In fact, here's a sub to hook to any cust maint. 001 SUBROUTINE MAP01(ADDR, ZIP) 002 *** 003 * TO INSTANTIATE THE BROWSER FOR INTERNET FOR THIS URL 004 * MAJ 121002 005 *** 006 CONVERT TO + IN ADDR 007 CONVERT TO + IN ZIP 008 PROG=C:\Program Files\Internet Explorer\IEXPLORE.EXE 009 URL=http://maps.yahoo.com/py/maps.py?BFCat=Pyt=TmapnewFL=Use+Address +Belowaddr=:ADDR:csz=:ZIP:Country=usGet%A0Map=Get+Map 010 CALL WIN.PCRUN(PROG, URL) 011 RETURN 012 END I see that you are in AU so adjust the URL in this example for the appropriate country. I just go to the yahoo map page with an address and cut/paste that url into MV and fixup. Happy April 1. It's still yesterday here. - Original Message - From: LeRoi Keiller [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 10:39 PM Subject: How to launch remote browser from UniVerse server? Hi I have a client (customer) who wishes to launch users' desktop browsers from a UniVerse server. 1/ How can this be done (actual instructions, if possible) So far, UniObjects has been mentioned and DDE - but, any other ideas. Or, what are the instructions to actually do this? 2/ Once the above is possible, how could a UniVerse report be displayed in the user's browser, for example? Thanks, LeRoi ___ LeRoi Keiller Client Support - Technical UltraData - Vision to Reality Ph +61 3 9291 1700 www.ultradata.com.au 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. 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. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify
RE: Data typing in MV Basic
Thanks. (For those who were wondering, I never saw the debug post :-( I guess our antispam ate it :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell, Stewart Sent: 31 March 2004 21:31 To: 'U2 Users Discussion List' Subject: RE: Data typing in MV Basic Wol, It is not how the compiler deals with the information but how the runtime engine deals with the data. I have demonstrated the runtime engine types the data based on how it is entered in the source code. A = 1 is typed as a numeric by the runtime engine and A = 1 is typed as a string. In an earlier post I provided the following proof. TST 0001 DEBUG 0002 A = 1 0003 A = 1 0004 STOP RUN XP TST TST: 2: A = 1 :: S TST: 3: A = 1 :: A/ INTEGER: 1 :: S TST: 4: STOP :: A/ STRING: T r L=1 `1' :: The program simply sets the variable A to 1 or 1 and when run it goes in to debug mode. I then stepped through each line and displayed the contents of the variable A by typing A/ as you can see the runtime engine reports each line as INTEGER or STRING depending on how the data was entered in the source code. Regards, Stewart -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, 31 March 2004 19:15 To: U2 Users Discussion List Subject: RE: Data typing in MV Basic Why? Let's work on the basic principal of coercion occurs when necessary, and not before. The compiler detects 1 as a string literal. It stores it as a literal. The compiler detects 1 as a numeric literal. It stores it as a literal. (The compiler doesn't give a damn about strings or numerics - a literal is a literal is a literal) Therefore 'A = 1' and 'A = 1' both result in IDENTICAL p-code. Therefore, unless you know how the compiler works, your conclusion is demonstrably flawed. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell, Stewart Sent: 31 March 2004 08:31 To: 'U2 Users Discussion List' Subject: RE: Data typing in MV Basic A = 1 is held as an integer A = 1 is held as a string A = 1 + 0 is held as an integer Cheers, Stewart -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, 31 March 2004 17:00 To: U2 Users Discussion List Subject: RE: Data typing in MV Basic You've missed the point! :-) These two statements apparently have exactly the same effect - the question is do they? A = 1 A = 1 (In the stuff I'm writing, they'd be the same - everything is a string until it is forced into numeric.) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Garratt Sent: 31 March 2004 07:39 To: U2 Users Discussion List Subject: Re: Data typing in MV Basic Would this not be set by your initialisation of the variable A. eg A = '';*Alpha/Numeric or String A = 0 ; Numeric - Original Message - From: Trevor Ockenden [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 2:25 PM Subject: Re: Data typing in MV Basic Will, I stand corrected on that one. So far in 20 odd years of programming in MV I haven't needed to worry about it. Now Will raises a terrific question. If A = 1 assigns 1 as numeric. How would you determine if A contained a numeric or a string in this case? My short answer is - why would I need to know? BUT I'm sure somebody has a good answer to that one. Cheers Trevor Ockenden Open Systems Professionals - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 4:10 PM Subject: Re: Data typing in MV Basic In a message dated 3/30/2004 8:19:18 PM Pacific Standard Time, [EMAIL PROTECTED] writes: A = 1 assigns a numeric integer. The expression need not contain operators (+,-,etc) to be numeric. A = 1 assigns a string however, as you have explicitly declared it to be string. A = 1 + 2 assigns a numeric integer value (3) as the result is numeric. A = one + 2 assigns a zero - according to the error message. yes no yes yes they all assign numerics imho 1 is cast as a numeric because the system is smart enough to realize its a numeric string and has no purpose casting it as a string Any idea how to test which it is? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.642 / Virus Database: 410 - Release Date: 25/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
What do we do? It looks like the answer may well be wait and your prayers will be answered :-) I'm getting vibes (so no promises here!) that there may well soon be a forum to email gateway. How usable it will be I don't know, but other people have the same problem on other sites, and it sounds like something is being done ... Just a pain the lists are set to disappear well before this thing is likely to become reality :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 30 March 2004 11:19 To: 'U2 Users Discussion List' Subject: RE: The lists are closing Listen, Will the blind, deaf and possibly dumb Johnson Are you hearing nothing? There are those of us who don't live in the land of the mighty dollar. We have to pay for our traffic, we have employment contracts that forbid us from internet access during the day, yet we still need access to U2 info. What do _you_ suggest we do? I've subscribed to your glorious forum, I get wee posties saying there are people talking about juicy thangs, but I cannot get to see these. What do _you_ suggest I do? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 29 March 2004 09:03 To: U2 Users Discussion List Subject: Re: The lists are closing 1) We DO want to leave the archives at indexinfocus. 2) We DONT want to replicate the archives onto u2ug 3) We DONT want the lists to continue Go to the web site, and enter each forum you are interested in and click on SUBSCRIBE this will make all responses come to your email box just as they do now. You can register, but if you dont SUBSCRIBE you wont be seeing nothing Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
Except that IBM has precious little to do with U2UG. Okay, they want to help us, but there's that little matter of being beholden to your sponsor, which we are not and we most definitely do not want to become. U2UG is OF the users, BY the users, and FOR the users. It has nothing to do with IBM apart from the fact that we see it as our mutual self-interest to work together. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 30 March 2004 14:06 To: U2 Users Discussion List Subject: Re: The lists are closing Perhaps if IBM or whomever is sponsoring the U2UG.org site is listening to the feedback of the current members of this list that they will respond in a 'customer-oriented' kinda way. That's why it's called SOFTware. It can change to meet the needs of its customers. I agree with the reduction of efficiency that the new method will cause. Hopefully IBM can cause a change to accomodate the high level of service the oliver list provided. my 1 cent. *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
I think the fora were meant to be in addition to the lists. A lot of people apparently DO want the fora. The problem is that a *different* lot of people seem also to want the mailing list. And bear in mind that the lists are actually run by an organisation that is a commercial concern, and neither IBM nor u2ug. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron White Sent: 30 March 2004 16:14 To: U2 Users Discussion List Subject: Re: The lists are closing - Original Message - From: Anthony Youngman [EMAIL PROTECTED] [snip] U2UG is OF the users, BY the users, and FOR the users. [snip] Cheers, Wol If this statement is true it sounds like someone wasn't listening or asking the users if they were even interested in this forum idea. It seems to have been done without the input of the very people it is supposed to serve. For the record, I have unlimited internet access both at work and at home but I think the forum idea sucks. I want my list info via email so I can filter it and read it offline at a time that is convenient for me and my employer. I have subscribed to U2UG but I don't expect to spend much time there. Ron White --- [ Eckel certifies this E-mail to be virus free. ] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [ADMIN] Re: Modern Universe - was: The lists are closing
He's doing a SCO ... when you give him any facts he just repeats his baseless assertions :-) Yes we know a screwdriver is far better and newer technology, but that still doesn't mean it beats a hammer for driving nails :-) (Well, it does if you're too dumb to learn how to use a hammer, but that's another topic ...) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Schasny Sent: 30 March 2004 23:37 To: U2 Users Discussion List Subject: RE: [ADMIN] Re: Modern Universe - was: The lists are closing Then perhaps you should take your own advice and HIT DELETE -Original Message- From: Joe Eugene [mailto:[EMAIL PROTECTED] [unsightly rubbish snipped] IF you feel my comments are without SUBSTANCE... WHY NOT ARGUE BACK with some Valid Proof... Instead of start Calling People Names... like school kids! Yes, it is only Normal when People Fail or Run out of Arguments... they start making Personal Remarks... This Denotes their FAILURE! Joe Eugene -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Data typing in MV Basic
You've missed the point! :-) These two statements apparently have exactly the same effect - the question is do they? A = 1 A = 1 (In the stuff I'm writing, they'd be the same - everything is a string until it is forced into numeric.) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jim Garratt Sent: 31 March 2004 07:39 To: U2 Users Discussion List Subject: Re: Data typing in MV Basic Would this not be set by your initialisation of the variable A. eg A = '';*Alpha/Numeric or String A = 0 ; Numeric - Original Message - From: Trevor Ockenden [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 2:25 PM Subject: Re: Data typing in MV Basic Will, I stand corrected on that one. So far in 20 odd years of programming in MV I haven't needed to worry about it. Now Will raises a terrific question. If A = 1 assigns 1 as numeric. How would you determine if A contained a numeric or a string in this case? My short answer is - why would I need to know? BUT I'm sure somebody has a good answer to that one. Cheers Trevor Ockenden Open Systems Professionals - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 31, 2004 4:10 PM Subject: Re: Data typing in MV Basic In a message dated 3/30/2004 8:19:18 PM Pacific Standard Time, [EMAIL PROTECTED] writes: A = 1 assigns a numeric integer. The expression need not contain operators (+,-,etc) to be numeric. A = 1 assigns a string however, as you have explicitly declared it to be string. A = 1 + 2 assigns a numeric integer value (3) as the result is numeric. A = one + 2 assigns a zero - according to the error message. yes no yes yes they all assign numerics imho 1 is cast as a numeric because the system is smart enough to realize its a numeric string and has no purpose casting it as a string Any idea how to test which it is? Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.642 / Virus Database: 410 - Release Date: 25/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: U2UG Contract
My other, !!!MAJOR!!! concern with this is the loss of the medium of mail. This is actually probably quite a serious loss for non-USians :-( (Plus it's the only practical medium at work :-( Forum software assumes easy access to a fast, cheap internet pipe. None of the fora I have seen is conducive (to my mind) to a good, in-depth conversation. And, to put it bluntly, I PREFER to work off-line. I know I'm often sloppy :-) but working in fora means I'm also rushed. And I get put off by pages that grow and start to crawl (or get chopped up so I can't find what I'm looking for...). Plus, there's the time difference. How do I help someone stateside or down-under if our access times only overlap by an hour? With the list, it just happens that we notice the other person is around. With a forum, it's chance that mostly never happens :-( Obviously, as part of the u2ug board :-) I look at the fora, but I think it's a pretty safe bet that losing the oliver lists means I will migrate back to cdp for the most part, not to u2ug.org. Not that I think that would be a bad thing - consolidating the MV world back to cdp is something I'm very pro. I don't mean to sound ungrateful, Clif has done us a wonderful service, and this is really meant as a back-handed compliment :-) the lists WILL be sorely missed. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Phillips Sent: 29 March 2004 10:01 To: [EMAIL PROTECTED] Subject: U2UG Contract Hi all, Firstly, thanks to Cliff for all his work over the years. I guess that most of us are looking to move to the U2UG site. I started off down that path this morning but, being a careful sort of person, I read the terms and conditions. Clause 7a worries me. I have discussed this briefly with our legal advisors who said that we shouldn't agree to it without clarification. So what is clause 7a?... 7. Submission of Content on this Web Site. By providing any Content to our web site: (a) you agree to grant to us a worldwide, royalty-free, perpetual, non-exclusive right and license (including any moral rights or other necessary rights) to use, display, reproduce, modify, adapt, publish, distribute, perform, promote, archive, translate, and to create derivative works and compilations, in whole or in part. Such license will apply with respect to any form, media, technology known or later developed; My non-legal mind looks at this and reads into it that once I have submitted a posting to the site, I give away all rights to everything I have done and all my future work that may have any connection with what I have posted. I'm not even certain that the connection is necessary! Any views out there before we all (possibly) donate our life's work to IBM? Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: U2UG Contract
news:comp.databases.pick Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rainer Gromansperg Sent: 29 March 2004 10:38 To: 'U2 Users Discussion List' Subject: RE: U2UG Contract -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Monday, 29 March 2004 19:16 To: U2 Users Discussion List Subject: RE: U2UG Contract SNIP - consolidating the MV world back to cdp is something I'm very pro. SNIP As a relative new list-user could you please let us know what 'cdp' is? Thanks Rainer -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
Ye'll tak the high road and I'll tak the low road ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: 29 March 2004 15:35 To: 'U2 Users Discussion List' Subject: RE: The lists are closing ..Yes I'll see you, I'll see you on the other side... - Ozzy Osbourne -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 5:36 AM To: 'U2 Users Discussion List' Subject: RE: The lists are closing Cliff, We whose lists are about to die, salute you. It's been a great service - you should be held up as a shining example to moderators everywhere in promoting the best blend of discussion, humour and debate amongst a very informative list. More than that, you have made us all into a (not always united, but what the hell) community. I'll miss picking through the 700+ emails when I get back from holidays, and I'm sure my productivity will increase as a result ! but what I will mostly miss is the feeling of being part of an immediate, entertaining and switch-on online community. Brian -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: The lists are closing
Simple! He's saying Don't mix web and email. And I couldn't agree more. If I get a forum post sent to me by email, I don't want the grief and hassle of firing up a browser, and a web connection, and and and ... Oh - and I've just recently upgraded my email client at home. The assumption when the previous version was written was that mail got read OFF line. So web links in email didn't work because it assumed there wouldn't be a web accessible to get at. I suspect there are still a lot of clients like that around ... And how many people know to click on subscribe? I didn't ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 29 March 2004 20:54 To: U2 Users Discussion List Subject: Re: The lists are closing Could you explain what you are referring to more clearly? In a message dated 3/29/2004 2:09:37 PM Eastern Standard Time, [EMAIL PROTECTED] writes: Not to be obnoxious but why not keep data in one place? How would it benefit someone to start a question in one medium and then be referred to another? That sound counter-intuitive to me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 2:03 PM To: U2 Users Discussion List Subject: Re: The lists are closing 1) We DO want to leave the archives at indexinfocus. 2) We DONT want to replicate the archives onto u2ug 3) We DONT want the lists to continue Go to the web site, and enter each forum you are interested in and click on SUBSCRIBE this will make all responses come to your email box just as they do now. You can register, but if you dont SUBSCRIBE you wont be seeing nothing Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Optimisation ?
Did you know the Americans weren't even the first to build a successful aeroplane? The first aircraft built that flew successfully (note my strange word order :-) was built in 1896, in England. Unfortunately, it had to be rebuilt, and the first successful flight was (iirc) 1912. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: 26 March 2004 01:17 To: 'U2 Users Discussion List' Subject: RE: Optimisation ? PS. Why do you think the Americans on this list felt the need to change the spelling of Optimisation from the original English (Scots?). The rest of us put up with enough centers and realizes from you yanks! Did anyone else get the monthly jBASE Did you know? email from Kerri Duffy? In it she says: Did you know...? Charles Lindbergh was not the first man to fly nonstop across the Atlantic Ocean. Two men had achieved the same goal eight years earlier! Flying for sixteen and a half hours from June 14-15, 1919, Captain John Alcock and Lieutenant Arthur Whitten-Brown had copiloted a Vichers-Vimy twin-engine plane nonstop from Newfoundland across the Atlantic to Ireland. Lindbergh was just the first person to do it alone. She could just as easily have said Lindbergh was just the first American to do it. I think most non-yanks would have known that Alcock and Brown's was the first crossing of the Atlantic by air. /grrr -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to sort a file by multivalue field?
Look at BY.EXP. It returns a select list of keys separated by @FMs, each key being @ID @VM FIELD.VALUE. You'll need to manipulate it yourself converting @VMs to *s if that's the way you want it. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 26 March 2004 06:33 To: [EMAIL PROTECTED] Subject: How to sort a file by multivalue field? How can I SELECT a file by a multivalue field and return a list of @ID:*:FIELD.VALUE in sorted order of FIELD.VALUE? E.g: record A = 800:@VM:600:@VM:700 record B = 400:@VM:900:@VM:1000:@VM:300 record C = 650:@VM:200 I want the output as follows: C*200 B*300 B*400 A*600 C*650 A*700 A*800 B*900 B*1000 Thanks for any help. Marco - Yahoo! Messenger - Communicate instantly...Ping your friends today! Download Messenger Now -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on W2K3 - trying to add to path
There IS some way of setting the environment. Don't ask me how :-( Probably control panel and then somewhere deep in the bowels of system management. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of djordan Sent: 25 March 2004 06:17 To: 'U2 Users Discussion List' Subject: RE: UV on W2K3 - trying to add to path Hi Sara I assume you mean when you do a dos command from universe over telnet. If that is the case every time you do the dos cammand it launches another DOS command execute, like launching another shell. I am not sure if there is a way of copying the variables from the base as you can with unix. I would run a bat that initialises those variables each time you launch dos, or the other hand consider unix services for windows, which gives unix people a more comfortable interface to windows. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Thursday, 25 March 2004 4:59 PM To: '[EMAIL PROTECTED]' Subject: UV on W2K3 - trying to add to path We are starting our evaluation of running UniVerse on W2K3. To get a feel of what it will be like and to scope the learning we need to do we have set up a totally isolated W2K3 server (PDC) and have installed the personal version of UniVerse while we wait for an NT version from IBM. I added to the System Environment variables an extension to the PATH = c:\IBM\UV\BIN Problem - we do not get this in our telnet session. It is fine in a cmd session from the server but is missing from the telnet session. Can anyone explain how we add this on an NT platform. Universe was installed as Administrator and we have even tried using Administrator as the user in the telnet session but that did not show the extra path. Our personal user accounts are in the Admin group. I can add this within my session as PATH=%path%;c:\ibm\uv\bin and it works. However this is lost next time. I can see this is going to be an interesting learning curve for our DBAs (Oracle and UniVerse) who have UNIX skills but little exposure to NT apart from using a desktop. I will be on leave tomorrow (Friday) so I will see if I can get the digest sent to me at home. Thank you in anticipation Sara Burns Sara Burns (SEB) Development Team Leader Public Trust Phone: +64 (04) 474-3841 (DDI) Mobile: 027 457 5974 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Information contained in this communication is confidential. If you are not the intended recipient the information should not be used, disclosed, copied or commercialised. The information is not necessarily the views nor the official communication of Public Trust. No guarantee or representation is made that the communication is free of errors, virus or interference. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ANTIVIRUS
We use sophos. www.sophos.com Just a dedicated AV company, and does nothing else. Plus you can get bulk licences (or could last I checked) so it is MANDATORY for all personal pcs that they be running sophos if the owner wishes to connect them to the company net. We just give them a cd and tell them they MUST install it. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Nichol Sent: 25 March 2004 02:54 To: U2 Users Discussion List Subject: RE: ANTIVIRUS At 10:35 25/03/04, you wrote: snip Can we have a straw poll on AV software? Just post a subject of ANTIVIRUS - (name) - (version) *GOOD* or *BAD* as necessary - let's hear it. AVG vers 7.0 from Grisoft *VERY GOOD* Even Grisoft's freebie vers 6 of AVG is also *GOOD* http//:www.grisoft.com Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of uniVerse mailing list Sent: 24 March 2004 14:24 To: U2 Users Discussion List Subject: RE: UniVerse 10 on Win2k3 Incoming mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.229 / Virus Database: 262.5.8 - Release Date: 22/03/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.229 / Virus Database: 262.5.8 - Release Date: 22/03/04 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Optimisation ?
After you decrement LOP, you need to decrement MAX. Otherwise the loop will be unable to get beyond 4. Think about it - as soon as you delete a null value, you are guaranteeing that if null will be true on your last pass, thereby decrementing LOP and requiring another pass, which will do the same, which will do the same ... That's why I ALWAYS do a FOR I = MAX TO 1 STEP -1 style loop when coding this sort of stuff ... Bit slower, but far harder to mess up ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Olson Sent: 25 March 2004 12:41 To: 'U2 Users Discussion List' Subject: RE: Optimisation ? LOL... I can't get this to get out of the loop!!! the trim crt'ed pretty quick... neat! : L23 0001: PETE = 'THIS}IS }}}A TEST}}}' 0002: CRT TRIM( PETE , @VM ) 0003: REC = PETE 0004: MAX = DCOUNT( REC 1 , @VM ) 0005: FOR LOP=1 TO MAX 0006: IF REC1,LOP = '' THEN 0007: REC=DELETE(REC,1,LOP,0) 0008: IF LOP = MAX THEN GO 300 0009: LOP=LOP-1 0010: END 0011: NEXT LOP 0012: 300: 0013: CRT REC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jonathan Leckie Sent: Thursday, March 25, 2004 7:29 AM To: [EMAIL PROTECTED] Subject: Optimisation ? I have the following piece of code : IF REC1 £ '' THEN MAX=DCOUNT(REC1,VM) FOR LOP=1 TO MAX IF REC1,LOP = '' THEN REC=DELETE(REC,1,LOP,0) IF LOP = MAX THEN GO 300 LOP=LOP-1 END NEXT LOP END I wonder could this simply be replaced with : IF REC1 £ '' THEN REC1=TRIM(REC1,@VM) GO 300 END Can anyone see any problems with using TRIM to remove trailing, repeated and initial value markers and therefore achieving the same effect without looping through each multi-value? This is on Unidata 3.3.2 incidentally. -- * This message has been scanned for viruses and dangerous content by * Blairs of Scotland MailScanner, and is believed to be clean.* * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to which they * are addressed. * * If you have received this email in error please notify us at Blairs * of Scotland via email at [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Optimization ?
This is the preferred version. It's also a bit slower. The point is, you can GUARANTEE that LOP will decrement on every pass, and the loop will terminate. With the other version, you need all sorts of extra code and crap to make sure you don't do what your original version is doing - ie counting from 1 to 8, and getting stuck on 4. If you kill the currently running infinite loop, then rerun it with a PRINT statement after the FOR, you will see that it successfully trims your string to 'THIS}IS}A TEST', but LOP is now 4, value 4 is the empty string, so LOP is decremented every pass, is stuck at 4, and will never reach the 8 needed to terminate the loop ... The decrement is less efficient at string handling. It is also far easier to code without screwing up - there's only one way to do it (tm), while the increment method has many ways of getting it wrong, and only one (complicated) way of getting it right. After you THINK you've got it right, try feeding it the string '}' :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Olson Sent: 25 March 2004 12:57 To: 'U2 Users Discussion List' Subject: RE: Optimization ? ok... now what's quicker / preferred... PETE = 'THIS}IS }}}A TEST}}}' CRT TRIM( PETE , @VM ) REC = PETE MAX = DCOUNT( REC 1 , @VM ) FOR LOP = MAX TO 1 STEP -1 IF REC1,LOP = '' THEN REC=DELETE(REC,1,LOP) END NEXT LOP 300: CRT REC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: Thursday, March 25, 2004 7:47 AM To: U2 Users Discussion List Subject: RE: Optimisation ? After you decrement LOP, you need to decrement MAX. Otherwise the loop will be unable to get beyond 4. Think about it - as soon as you delete a null value, you are guaranteeing that if null will be true on your last pass, thereby decrementing LOP and requiring another pass, which will do the same, which will do the same ... That's why I ALWAYS do a FOR I = MAX TO 1 STEP -1 style loop when coding this sort of stuff ... Bit slower, but far harder to mess up ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Olson Sent: 25 March 2004 12:41 To: 'U2 Users Discussion List' Subject: RE: Optimisation ? LOL... I can't get this to get out of the loop!!! the trim crt'ed pretty quick... neat! : L23 0001: PETE = 'THIS}IS }}}A TEST}}}' 0002: CRT TRIM( PETE , @VM ) 0003: REC = PETE 0004: MAX = DCOUNT( REC 1 , @VM ) 0005: FOR LOP=1 TO MAX 0006: IF REC1,LOP = '' THEN 0007: REC=DELETE(REC,1,LOP,0) 0008: IF LOP = MAX THEN GO 300 0009: LOP=LOP-1 0010: END 0011: NEXT LOP 0012: 300: 0013: CRT REC -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jonathan Leckie Sent: Thursday, March 25, 2004 7:29 AM To: [EMAIL PROTECTED] Subject: Optimisation ? I have the following piece of code : IF REC1 £ '' THEN MAX=DCOUNT(REC1,VM) FOR LOP=1 TO MAX IF REC1,LOP = '' THEN REC=DELETE(REC,1,LOP,0) IF LOP = MAX THEN GO 300 LOP=LOP-1 END NEXT LOP END I wonder could this simply be replaced with : IF REC1 £ '' THEN REC1=TRIM(REC1,@VM) GO 300 END Can anyone see any problems with using TRIM to remove trailing, repeated and initial value markers and therefore achieving the same effect without looping through each multi-value? This is on Unidata 3.3.2 incidentally. -- * This message has been scanned for viruses and dangerous content by * Blairs of Scotland MailScanner, and is believed to be clean.* * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to which they * are addressed. * * If you have received this email in error please notify us at Blairs * of Scotland via email at [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo
RE: UniVerse 10 on Win2k3
AARRGGHH!! NEVER EVER run antivirus on a server. You should firewall your server. You should scan it for viruses. You should NEVER have background antivirus stuff running on it! You keep the server infection-free by strictly controlling what you allow to run on it. If a client stuffs infected files on it then that's the client's problem, and/or it gets picked up by the server's regular scan, but DON'T run background antivirus. On a properly-run and properly-secured server, it's totally unnecessary, and causes rather than prevents grief. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greesh Dhir Sent: 23 March 2004 23:31 To: [EMAIL PROTECTED] Subject: RE: UniVerse 10 on Win2k3 Not sure if this helps, but I found that McAfee VirusScan prevented the RPC from starting. I end up removing it and installing Norton. This seemed to do the trick. From: Glenn W. Paschal [EMAIL PROTECTED] Reply-To: U2 Users Discussion List [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Subject: RE: UniVerse 10 on Win2k3 Date: Tue, 23 Mar 2004 16:15:37 -0600 I have to agree, we are running UV 10.1.0 on Windows 2003 Small Business Edition. No problems at all. Not even a hiccup. Even checked the logs for RPC errors, and found none. Thanks, --Glenn. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Dallaire Sent: Tuesday, March 23, 2004 6:47 AM To: 'U2 Users Discussion List' Subject: RE: UniVerse 10 on Win2k3 Augusto, Turning on Interact with desktop is what is causing these command boxes to appear. If you turn it off, they will go away. Of course that will bring you back to your original problem. I don't really have any good ideas on that one. We have many customers running on Win 2k3 and have never seen this. There may be a service in Windows you need to stop or start. (RPC services may be the place to start). HTH, Mike Dallaire Mortgage Builder Software Inc. (248) 208-3223 ext. 103 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Augusto Alonso Sent: Monday, March 22, 2004 10:17 PM To: U2 Users Discussion List Subject: UniVerse 10 on Win2k3 Hi all. We have installed UV 10 in a win2003 box and it works well. The only problem i've found is that UV-RPC service hangs after the very first rpc connecttion. After win2k3 restart, I can connect once again, and again all the next connections are rejected. I've found that, if I modifiy the Interact with desktop tab, inside the service properties, it seems to works fine. The new problem now, is that every UV-RPC conetcion opens a command window in the server's desktop. Any guess? Regards, __ Augusto Alonso Alonso I.T.Manager Quiter Servicios Informáticos S.L. Tel: +34 902 23 33 23 Fax: +34 902 23 42 80 [EMAIL PROTECTED] www.quiter.com __ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users _ Stay in touch with absent friends - get MSN Messenger http://www.msn.co.uk/messenger -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UDT] Use of PCPERFORM and the PHANTOM command
FYI, colon works fine in winders ... it's the standard command-line command separator ... Don't forget - a lot of windows was copied from nix - the only reason the '/' wasn't copied (and in a way it was, it tends to work) is that DOS was designed to be compatible with CP/M - and '/' was legal in a CP/M file name. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Snyder Sent: 22 March 2004 21:08 To: U2 Users Discussion List Subject: Re: [UDT] Use of PCPERFORM and the PHANTOM command Graham, David wrote on 03/22/2004 03:27:08 PM: snip I have a UniBasic program that executes the following line of code: PCPERFORM cd \folder\folder\U2Account; udt PHANTOM ProgramName snip the process that executed the PCPERFORM command will wait until ProgramName has completed and *then* will return to the original process. Actually, if you change into the directory and type udt PHANTOM ProgramName from the DOS prompt, you'll see the same thing. It's not an issue with PCPERFORM. Also, I'm a bit confused by the command itself. The backslashes indicate you're in Windows, but the command separator of a semicolon indicates UNIX. Try replacing your command with the following: PCPERFORM cd \folder\folder\U2Account echo PHANTOM ProgramName | udt for windows or PCPERFORM cd /folder/folder/U2Account ; echo PHANTOM ProgramName | udt for UNIX. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Program dying
FYI, this sounds very similar to the problem I have with HS.UPDATE.FILEINFO, so it isn't necessarily your code ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Eastwood Sent: 22 March 2004 16:23 To: 'U2 Users Discussion List' Subject: RE: [UV] Program dying Tried that...the PH entry just stops - no messages. It has a Record Counter display but 'where' it stops (if it stops) is random. There could very well be a problem with the program, but I can't see it, I was hoping the Event Entry would point-out the problem. FYI - Here is some sudo-code...the odd piece of logic (to me) this program does is process Lists within Lists (three deep). EXECUTE SELECT FILE1 WITH blah... RTNLIST LIST1 LOOP READNEXT ID1 FROM LIST1 ELSE EXIT CLEARSELECT LIST2 EXECUTE 'SELECT FILE2 WITH xxx = ':ID1:'' RTNLIST LIST2 LOOP READNEXT ID2 FROM LIST2 ELSE EXIT CLEARSELECT LIST3 EXECUTE 'SELECT FILE3 WITH xxx = ':ID2:'' RTNLIST LIST3 LOOP READNEXT ID3 FROM LIST3 ELSE EXIT ...do stuff... REPEAT REPEAT REPEAT END Thanks again, Mark. -Original Message- From: Jeff Schasny [mailto:[EMAIL PROTECTED] Sent: Monday, March 22, 2004 10:53 AM To: U2 Users Discussion List Subject: RE: [UV] Program dying You might try running it as a phantom and then checking the entry in the PH file to trap any Universe level errors -Original Message- From: Mark Eastwood [mailto:[EMAIL PROTECTED] [snip] -__ This e-mail, including any attachments, may contain information that is protected by law as privileged and confidential, and is transmitted for the sole use of the intended recipient. If you are not the intended recipient, you are hereby notified that any use, dissemination, copying or retention of this e-mail or the information contained herein is strictly prohibited. If you have received this e-mail in error, please immediately notify the sender by telephone or reply e-mail, and permanently delete this e-mail from your computer system. Thank you. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Runaway user
Reboot? Probably not okay. Can you do a ps -ef at unix level and identify the process there? LISTU may well tell you this number too. Then do a kill -15 on the process. That'll tell it to shut itself down cleanly. If that fails, then try a kill -9. If that fails, it's a problem with Unix, and a reboot is definitely one of the few solutions (although it should be safe just to ignore it in that case, as it's probably stuck waiting on a signal and using no resources). Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of TELRIS MAN Sent: 18 March 2004 02:14 To: [EMAIL PROTECTED] Subject: Runaway user Our system is running on UV 9.4.1.3B on SCO Unix 5.0.5 and using Wintegrate. I found that the uv process is still exist and the uv port is still occupied under the following situation: (I can see the user in LISTU command) 1. The client machine is hanged. 2. The client machine is unplugged. Anybody over there can advice me how to fix it? Rgds Man -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Setting up SQL step 1
Well, 9.5 is a VMark product ... I'm not surprised IBM said the documentation doesn't exist. As we know from the licencing fiasco, the chain of control somewhere there went down the pan ... it's changed hands three times since then and somebody probably mislaid it somewhere ... I've probably got 9.5 docu somewhere if you know what you want - but it'll be the CD version, and I know for a fact that the electronic docu at the time was incomplete... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 17 March 2004 19:40 To: U2 Users Discussion List Subject: Re: Setting up SQL step 1 Good news (I think) From what I learned - the admin user is set up when you load the operating system . I was told that if I re-installed my latest upgrade tape that I could update the user at that time. I never was able to find any of this documentation on this - and when I asked IBM, since I was running 9.5 they conveniently told me that this documentation no longer existed - go figure. *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help Needed regarding performance improvement of delete query
And replying to Scott's post to say thanks for the compliment, but I've just had another idea ... How many fields are you using for your select on the master file? ESPECIALLY if it's just the date, trans that across to your secondary file, and index it! If it's more than one field, try and work out a usable trans that will pull all the fields across in one index that you can run a select over. Don't forget, declaring an index means that that data is stored in the file, whether it was calculated, trans'd, or was in the file anyway. So now you can do a select and purge on your secondary file without ever having to go near the primary, and the database will take care of making sure all the required information is available as it's needed ... :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Richardson Sent: 15 March 2004 13:08 To: U2 Users Discussion List Subject: Re: Help Needed regarding performance improvement of delete query Great points from Wol, as always. What kind of /tmp disk space do you have on this system? (Assuming that /tmp is where UV does some of it's SELECT scratch pad intermediate writing when processing large queries, consult your sites actual uvconfig for all of your actual values...). If this /tmp is small, single physical disk, or heavily fragmented, this would also contribute to poor query runtime performance. Ditto on your system's swap space, which should be at least 2X physical memory. Wol's approach of breaking down the query into selecting smaller groups of data is a great one. Chip away at the stone, methodically, consistently, and constantly. What platform is this on? What OS version? What UV Version? How much memory disk space? How much /tmp and swap space? Are you running this query with other users on the system, who may be also trying to access the files this query is working with? Are you runing this at night when it might conflict with a backup operation? More food for thought. Regards, Scott - Original Message - From: Anthony Youngman [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, March 15, 2004 4:02 AM Subject: RE: Help Needed regarding performance improvement of delete query This might help speed things up a bit ... Firstly, of course, is your file properly sized? Secondly, (and in this case you will need to run the SELECT / DELETE sequence several times) try putting a SAMPLE 1000 (or whatever number makes sense) at the end of your select. Basically, this will mean that the SELECT runs until it finds that number of records and then stops. So each sequence won't load the system so badly. Creating a huge select list will stress your ram badly ... looping through this sequence won't stress the system so badly, though you really do need to use indices to reduce the stress even more ... Create an index on various fields that you're using as your select criteria. If you're selecting old records, then you need to select on date, and this really will make life both easy and fast. The more closely you can guarantee that a select, acting on a single index, will pick up only or mostly records that you are going to delete, the better. That will SERIOUSLY reduce the time taken and the performance hit. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ashish ratna Sent: 15 March 2004 08:25 To: [EMAIL PROTECTED] Subject: Help Needed regarding performance improvement of delete query Hi All, We are working for purging of old data from the database. But we are facing performance problems in this. We are using select query which is created dynamically on the basis of number of records. We want to know if there is any limit for size of query in Universe. Although in universe help pdf it is mentioned that there is no limit for the length of select query. But when we run the program on the file with records more than 0.5 million it gave the error- Pid 14433 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. Memory fault(coredump) If there is no limitation on the size of query then please suggest some other possible solution which can help us reducing the time of query and completing the process successfully without giving the error. Thanks in advance. Regards, Ashish. *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International
RE: Suppressing detail in UniObjects command
But doesn't DEP.SUP have two Ps in it? :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell Sent: 16 March 2004 10:40 To: U2 Users Discussion List Subject: RE: Suppressing detail in UniObjects command Thanks go to Tony and Stuart who both figured it out. DEP.SUP with one P did the trick, ID.SUPP with the two P's seems to work fine too. Many thanks to everyone who pointed me in the right direction. Until next time Cheers Nick -Original Message- From: Tony Wood [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 22:46 To: U2 Users Discussion List Subject: Re: Suppressing detail in UniObjects command Hey Nick, What you NEED to use is DET.SUP and not DET.SUPP (please notice only one P). The error is trying to tell it does not understand DET.SUPP I think. Lembit Pirn was on the right track! Regards, T. - Original Message - From: Nick Southwell [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 4:18 AM Subject: RE: Suppressing detail in UniObjects command Cheers, I'll give that a try! Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 17:16 To: [EMAIL PROTECTED] Subject: RE: Suppressing detail in UniObjects command Yes, it sounds like you use the Pick style by either turning UDT.OPTIONS 2 ON or with ECLTYPE P for your regular sessions. I believe UniObjects defaults to ECLTYPE U. I haven't tried in a UniObjects session to change the ECLTYPE - you just need to learn the U type syntax which is somewhat different but has much more power. Check the online help for list and sort for the basic syntax. If you want to test your commands at TCL you can simply use the lower case list or sort to force UniData to use the U type command parser. hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Nick Southwell [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 9:38 AM To: U2 Users Discussion List Subject: RE: Suppressing detail in UniObjects command Sooo.. Coming from a very small Unidata background sounds like you're saying I need to set my ECL type within the Uniobjects session? Thanks Nick -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us
RE: Terminology
Not really. MTBF means it'll run for 10 minutes without falling over. SLA can mean anything. If I was an office manager, I might well say (indeed, it's pretty much our internal SLA) that our systems will be guaranteed available between 8am and 6pm. So I can have 14 hours downtime a day, and still meet my 100% availability guarantee to my end users :-) Doesn't quite work that way of course :-) with offices in New York and Hong Kong, that available between 8 and 6 guarantee means that I only have a few hours when I can take the system out ... :-) But basically, all an SLA is, is a statement that service will be available within certain (acceptable to both sides) constraints. Whether time when it's available, or possibly response times (eg we can't run heavy maintenance tasks at certain times because the users will curse us etc etc). Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 16 March 2004 14:10 To: U2 Users Discussion List Subject: Re: Terminology So what does Service Level Agreement Metrics or Operational Level Agreement Metrics mean. Is this the new MTBF, ie Mean Time Between Failures. thanks. - Original Message - From: Ross Ferris [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, March 15, 2004 10:47 PM Subject: RE: Terminology I'm on the wrong side of the world, but IIRC DataFlo is a product, like InfoFlo - these days out of the Epicore stable I'd imagine SLA would be a Service Level Agreement and OLA would be an Operational Level Agreement, both relating (more or less) to the uptime availability of a system Ross Ferris Stamina Software Visage - an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Tuesday, 16 March 2004 12:56 PM To: [EMAIL PROTECTED] Subject: Terminology Dear all: I'm not familiar with the following as referred to by MV: SLA and OLA metrics. Also, what is Dataflo. My guess is it may be a 4GL or it could be a 3.5GL like Eclipse. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.622 / Virus Database: 400 - Release Date: 13/03/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.622 / Virus Database: 400 - Release Date: 13/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Linux kernel params
Minor nitpick ... In linux, I think you'll find more is a link to less. Either that, or you'll find the behaviour of the program changes depending which name it is called by, and less has the better set of options :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stu Glancy Sent: 11 March 2004 21:11 To: U2 Users Discussion List Subject: Re: Linux kernel params We are doing similar from HP-UX to Linux 9 (kernel 2.4.20-28.9bigmem) and UV 10.0.O to UV 10.1 and found that APP.PROGS LIST.SP.CONF uses unix command pg which does not exist in linux Red Hat. We did a work around by creating a link from pg to more. This has been reported to IBM and is in engineering as ECase 6621. Stu Glancy Asset Management Outsourcing, Inc. Senior Analyst/DBA 770-792-3907 We are in the process of migrating our Universe app from an HP-UX system to a RedHat Linux (8.0) system. There did not appear to be any recommended o/s changes in the docs (although I did change the max number of open files). Does anyone have any suggested changes? Thanks, Drew -- -- Drew Henderson There are two types of people - Dir. for Computer Center Operations those who do the work and those [EMAIL PROTECTED] who take the credit. Try to be in the first group, there is 110 Ginger Hall less competition. Morehead State University Indira Ghandi Morehead, KY 40351 Phone: 606/783-2445 Fax: 606/783-5078 -- -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Memory Utilization
And look in Windows Task Manager on the server. It may have been fixed by now (NT4/UV9.5 here), but we find the major cause of programs here is a rouge telnet process. If it happens, it'll grab 100% of one cpu - get two of them and our twin-cpu server starts running in treacle ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Harkin Sent: 11 March 2004 22:52 To: '[EMAIL PROTECTED]' Subject: Memory Utilization How does UniVerse take advantage of RAM on a server (Win2K). I have a poorly performing database with only 7 users. I am currently resizing files, but I have noticed that the server is using only about 192 MB of RAM, when there is 1 GB installed. Regards, Timothy Harkin -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Common DICT
IME (and I could easily be wrong here), DELETE.FILE doesn't like absolute pathnames in F-pointers. That may, however, be a hangover from my Prime days. It will also, most definitely, warn you that this DICT filename does not match FILENAME, warning you that something is wrong. Just hope any user is not stupid enough to press Yes when it prompts to ask if you want to delete it. That said, what you describe is what we do all the time. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schalk van Zyl Sent: 12 March 2004 16:49 To: U2 Users Discussion List Subject: Common DICT U2-ers, UNIVERSE. PICK flavour. AIX If you have 40 branches, each in a UVaccount, each with an INVENTORY-FILE, and a master inventory in HO, would there be any problem to let all the branch inventory files' DICTs point to the DICT of HO's master inventory?. Normally, one would not delete an entire inventory file, so the danger of getting the 'master' dict wiped is not a real one. Schalk - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO Müller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A Müller, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Common DICT
I've done that. Call the X-item X_FILENAME, and provided you make the filename reflect the account it's in (or what it's used for) then that's not a problem. I *never* assume that a DICT will be unique to one DATA file. That's one of the strengths of MV :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: 12 March 2004 10:44 To: U2 Users Discussion List Subject: Re: Common DICT Schalk van Zyl wrote: U2-ers, UNIVERSE. PICK flavour. AIX If you have 40 branches, each in a UVaccount, each with an INVENTORY-FILE, and a master inventory in HO, would there be any problem to let all the branch inventory files' DICTs point to the DICT of HO's master inventory?. Normally, one would not delete an entire inventory file, so the danger of getting the 'master' dict wiped is not a real one. Sounds fine but You'd better check those X-type entries in the dict first. I've seen apps using them for storing things like next available sequence number wich may be better left as separate for each instance of the file. -- Mats -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: EVAL
I think you mean LIST FILE WHEN EVAL F16 * 0.9 LT F17 Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Witney Sent: 11 March 2004 12:40 To: 'U2 Users Discussion List' Subject: RE: EVAL LIST FILE WHEN EVAL F16 * 0.9 LT F16 -Original Message- From: Schalk van Zyl [mailto:[EMAIL PROTECTED] Sent: 11 March 2004 19:21 To: U2 Users Discussion List Subject: EVAL U2-ers, UNIVERSE. Can somebody help me with the syntax of EVAL. I want to execute a SELECT on a file to get all records where (field 16)*0.9 field(17). Thanks. Schalk - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO Müller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A Müller, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on Itanium
Or go for a new IBM servr running on Power G5. There was an interesting article on the Inquirer or the Register (can't remember which) asking whether the purpose of Itanium has been achieved, and whether it is likely to be ditched in the near future. The gist of it, basically, was that the Alpha and R4000 (and other similar chips) seriously outclassed Intel. So by bringing a 64-bit chip to market, Intel has pretty much hampered the market, killed Alpha and mips, and seriously crippled Sparc. Their two threats in the 64-bit space are now primarily the AMD Opteron, and the IBM G5. There's not a lot they can do about IBM, but their top-end Xeons or whatever have actually been 64-bit capable for quite a while now. So by delaying 64-bit x86, Intel now have more to lose than to gain. They also won't want competition between Itanium and x86-64. So guess what - Itanium will be reclassified as a research product and scrapped. Add in the fact that AMD is apparently selling more Opterons a quarter than Intel has ever sold in total, and Opteron really does look like the iceberg that sank the Itanic (as Itanium is irreverently called :-) While I don't doubt we'll never see it happen, if we had fair competition between chips, the Itanic would already have sunk without trace. It *still* can't compete effectively with old EV7 alphas, and the new Power will flatten it. Sparc should flatten it too, but the realities of the world mean that Sparc cheetah has already been flattened between the elephants of IBM and Intel :-( Maybe linux will, once more, succeed in decoupling software from hardware and lead to true competition in the hardware market ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: 09 March 2004 21:09 To: U2 Users Discussion List Subject: Re: UV on Itanium Glenn Herbert wrote: So does this mean it's still a 32-bit app that now runs on RH itanium? Or does this mean its a real 64-bit app At 03:17 PM 03/09/2004, you wrote: I'm sure UV is still a 32-bit app. I doubt there's currently enough interest in a 64-bit version of UV for IBM to invest the money in porting it. Performance of 32-bit apps was notoriously bad on Itanium until Intel and Microsoft released a new 32-bit driver in January. Of course this only helps with 32-bit Windows apps. I would hope they're working on a similar fix for linux. It didn't occur to me before, but I guess you could also run UV 10.1 on Windows Server 2003 on Itanium. Personally I'd wait to see if Intel comes up with a 32-bit Itanium driver enhancement for linux, or consider Opteron or Intel's new 64-bit version of Xeon as has already been suggested. -John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Brower based terminal emulator
Well, if MS can't do it ... Don't forget - it was ME that wrote the pt250 emulation that ships with wIntegrate. And though I say it myself, it's good ... :-) (VMark screwed it up a bit with improvements :-) And I moved all our wIntegrate over to pt250 because I couldn't get vt100 to work ... Yup. I'm well aware vt100 emulation is a nightmare. However, I think you will find that some of the more obscure features are not implemented in genuine DEC vt100 terminals ... what do you think THAT does to any attempt to get good definitive emulation :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 07 March 2004 03:55 To: [EMAIL PROTECTED] Subject: Re: Brower based terminal emulator In a message dated 3/5/2004 5:58:24 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Fire up an xterm, or konsole, or whatever you fancy, on the client desktop. Telnet into the uv server, SET.TERM.TYPE VT100, and off you go. And you're confident that any old xterm, konsole, or whatever will ACCURATELY emulate every feature of vt100 ? I think you will find that some of the more obscure features are not really implemented that well in most emulators. At least I did. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to safely kill a runaway unidata process
My experience is that the standard techniques don't work! The way I kill rogue processes like this is, on the server, go into task manager. Right-click the process. Do NOT select kill process, it won't work. Instead, select the other, attach debugger, option. The process will promptly do a Dr Watson and die. We occasionally get rogue processes hog cpu and the machine grinds to a halt. Being a twin processor, we don't notice if there's only one rogue, but two is nasty ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert Paterson Sent: 05 March 2004 09:55 To: 'U2 Users Discussion List' Subject: RE: How to safely kill a runaway unidata process Running deleteuser from the command prompt as an administrator should suffice. Run it without arguments to get the syntax. Robert Paterson Technology Support Manager IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: 04 March 2004 22:55 To: [EMAIL PROTECTED] Subject: How to safely kill a runaway unidata process One of our users decided to run a report this morning at 9:30 and it still running. They lost the connection to the server, the process id is still out there and we are unable to kill it. We tried the DELETUSER PID command and it did not go away. The process is using 200 megs of memory. We are running Unidata 6.06 on Windows 2000. - Do you Yahoo!? Yahoo! Search - Find what you're looking for faster. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV - Database backup
Given your stated requirements, the ONLY safe way for you is uvbackup. This runs within the database, and as such will not have trouble (much) with people accessing files. Any os-level backup will hiccup on files the db may have open. Running UV/NT, for us the problem is so severe that we always reboot the server after backing up (there are ways round the problems we've hit, but a reboot is simple, practical and works ...) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Armon Group Sent: 08 March 2004 12:20 To: [EMAIL PROTECTED] Subject: UV - Database backup What are the suggested means of backing up a UV system without taking it down ?? Is there a document anywhere with the benifits / drawbacks of the following methods (or any other methods) uvbackup T.DUMP tar mirror disk system + tar etc _ It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Printing to local printer
Look into pipes and smbprint (comes with samba). Sorry I can't be more specific than that, but I believe you can tie a program to a pipe (opening the pipe will invoke the program), and I've used smbprint (from within WP/SCO) to print from nix to a print queue on a windows server. That didn't have a print queue on the nix server, but don't forget WP had all its printer capability, drivers, the works, all built in. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: 04 March 2004 18:54 To: U2 Users Discussion List Subject: RE: Printing to local printer Wol, Thanks for the idea. Looks promising but we're on a Unix server. Is there a way to refer to the local printers across operating systems? My SETPTR documentation refers to mode 2 and the DEVICE setting as sending output to the Unix special file. Can the shared printer be defined as a unix special file without setting up a network print queue? Dana Baron System Manager Smugglers' Notch Resort -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: Thursday, March 04, 2004 7:02 AM To: U2 Users Discussion List Subject: RE: Printing to local printer What I'd do ... This is UV, but I got the impression that UD might well work the same way ... A lot of our printers, rather than saying AT DEVICE in the SETPTR statement, say AT \\windows\sharename. So each printer is set up on the local pc to which it is attached, and the UV server knows nothing about it at the Windows level (we have UV/NT). Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dana Baron Sent: 26 February 2004 19:07 To: [EMAIL PROTECTED] Subject: Printing to local printer Hi, We use Unidata (v5.2) on a DEC/Compaq/HP Alpha under Tru64 Unix (v5.0a). Most of our users connect to our Unidata system via terminal emulation software (SmartTerm) from Windows-based PCs. Some of those users function as point-of-sale terminals. We're now trying to integrate credit card validation via the internet directly from those work stations. We're still in test mode, but most of this seems to working OK. One remaining issue is printing the CC receipt. We would like the receipts to print on CC receipt printers attached to the workstation as either parallel or serial printers. We'd rather not set up print queues for all of these. Any ideas on how to accomplish this? Dana Baron System Manager Smugglers' Notch Resort -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Pick AP-Pro Discs
How about UVPE/linux? Especially if it's initially a proof of concept, that would be a legit use of UVPE. And while the system might be slow, it'll run on outdated hardware no problem, so when they go live, the only cost they've got is the UV licence. The only thing I would say about the hardware is, as always, stuff it full to the gills with RAM if you can (and remember that the swap = twice ram rule is *NOT*!!! obsolete). Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 29 February 2004 19:43 To: U2 Users Discussion List Subject: Re: Pick AP-Pro Discs I had considered this option as well as the MV-Lite environments already out there. This is really a low-key client (private club membership) that i am making a good deal on developing the app from scratch. Once they get their original system duplicated (dbase) to Pick, I can enhance their application with many desired features and they will have a greater appreciation for what the system can do for them. Perhaps, they can even grow. As it is, I'm searching my office for the red-box set of AP-Pro install discs from a converted client to install on an older P1-133 box. I'll steal an Arnet board from one of my other AP boxes (I don't need 24 users anymore) and 'build' them a good starting system. That's why I also solicited any older AP-Pro systems. thanks. - Original Message - From: Tony Gravagno [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Sunday, February 29, 2004 2:10 PM Subject: RE: Pick AP-Pro Discs If you had more of these deals you could setup a hosted environment (your choice of DBMS including U2 and D3). You use your own licenses on that system and do your development there. End-users can SSH into their own production accounts and pay you some monthly rate for using your app and resources until they're ready to move up. Voila', your own ASP. The initial cost of getting a licensed DBMS and ports may be prohibitive, but the advantage is that the system still belongs to you when the end-user has moved on to their own environment or even to a hosted solution of their own. If you already have a licensed environment then it should cost nothing to move the license to a hosted box, so the cost of getting this going is trivial. Note that (to my knowledge) it violates license agreements to run live end-users on development software provided by any of the MV DBMS vendors. You might be able to get a free temporary license to let users run for a couple months on a try before they buy basis. If you can manage that then they can host a DBMS locally and still pay you for your app. Couple ways to cut this cookie... Let me know if any of this is of interest. Tony Nebula RD [EMAIL PROTECTED] -Original Message- I would like to acquire... an older Pick AP-Pro system... I only need 3-5 users. I have a new client that I want to break into the Pick world with an inexpensive application to start. I can develop their new app on my own AP-Pro yet in 2 months they will want their own system. We've explored the concepts of a W2K/D3 or U2 box and its cost would kill the deal. I want to get my foot in the door and as they grow, we can convert later. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Brower based terminal emulator
Not this old chestnut again !!! Fire up an xterm, or konsole, or whatever you fancy, on the client desktop. Telnet into the uv server, SET.TERM.TYPE VT100, and off you go. End of story. *ANY* linux command shell will almost certainly emulate a vt100 as its default setting. And if you have multiple emulators with multiple emulations, it's not that difficult to write a program that goes into LOGIN, fires off the answerback sequence to the terminal, and sets up the correct terminal type. Here we had a mix of wyse85s, pt200s and pt250s, and wIntegrate (we're now down to wIntegrate running pt250 emulation and the odd wyse in vt100 mode). Barring screw-ups the user never enters terminal type because it's all sorted out automatically. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vance Dailey Sent: 04 March 2004 20:43 To: [EMAIL PROTECTED] Subject: Brower based terminal emulator We are considering running Linux on our user desktops and I am looking for a recommendation for a terminal emulation solution. One possibility is to find a terminal emulation program which runs locally on each desktop under Linux. A second possibility is to setup a server and use a web browser (such as Mozilla or FireFox) on the user desktops to access the applications. Ideally the solution will work on both Windows and Linux desktops given that some desktops will likely have to remain Windows based. We run Universe 9.6 and currently use a mix of Dynamic Connect and Wintegrate 4. Our current emulation is Wyse 60. I look forward to hearing about any good or bad experiences anyone has had. Thanks, Vance -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: How to Add Triggers on Dicts
When you specify DICT FILENAME, UV treats it internally as if there existed a VOC entry 0001: F 0002: D_FILENAME 0003: \uv_account\DICT.DICT There is no reason whatsoever why you shouldn't create an explicit VOC entry of exactly this form. After all, as far as UV is concerned, the D_FILENAME file is a data file, just like any other ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daly, Mark Sent: 02 March 2004 14:28 To: 'U2 Users Discussion List' Subject: RE: How to Add Triggers on Dicts Well.. It wouldn't surprise me if the CREATE TRIGGER command doesn't recognize the 'DICT' keyword. Triggers generally deal with data updates. I guess you could create a dummy file pointer that points to the dictionary as though it were a data file. Then reference that pointer when creating the trigger. BUT - I haven't tried it. Not sure I would try it. Good luck! -Original Message- From: Dennis Bartlett [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 02, 2004 9:20 AM To: 'U2 Users Discussion List' Subject: RE: How to Add Triggers on Dicts The trigger is currently working fine on DATA files. It's just the adding of it to DICT files that's boggling me at present. Once I've got that right, I'll have to think of some way to monitor Type 1/19 files, but that's another day. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse 10 :Network writes not allowed within a transacton.
The whole point of using transactions is to ensure data integrity. Writing across a network is a pretty sure-fire way of inviting integrity problems. The only way to guarantee that you don't have problems is to ban mixing the two. If you investigate the NFS protocol (which I guess your remote system is using?) you will find that it explicitly guarantees that the integrity of the link CANNOT be trusted. Now I think you see why transactions forbid its use ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ang Suan Yong Sent: 04 March 2004 03:08 To: U2-users Subject: UniVerse 10 :Network writes not allowed within a transacton. Dear U2 Users, Is anyone having idea regarding the uniVerse 10 when apply the Begin/End Transaction, it do not allow to write to the remote file. Once execute the program , it prompt the belowing messages Network writes not allowed within a transacton. Is it the security of the Database ? For eg , From Server A , having a program as below to access the remote file of Server B ( ie ASY.FV ) which is code within the Begin / End Transaction ... READU REC FROM ASY.FV , ID ELSE CRT ERROR READ FILE EXIT BEGIN TRANSACTION REC1 = TEST : X WRITE REC TO ASY.FV,ID ELSE CRT FAIL WRITE REC END IF ( P.ERROR ) THEN ROLLBACK END COMMIT END TRANSACTION RELEASE ASY.FV Error message is as follow FATAL: Network writes not allowed within a transacton. rolling back uncommitted transactions begun within this execution environment. Thanks and Regards DISCLAIMER:- This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Does anyone know how to
Do you need to modify a document created by someone else? Or can you just spit out a Word document from UV? Some of our report programs generate rtf documents from scratch. It can be fun getting the format right (we make extensive use of tables to put stuff in the right place), and Word is not the most forgiving of formats to use, but you might find this a better approach than faffing about with replacing text (or not as the case may be). I'll have to put my stuff up on Pickwiki at some point ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 03 March 2004 21:09 To: [EMAIL PROTECTED] Subject: [UV] Does anyone know how to I am running UV 9.5.1... on windows NT (PICK flavor). I want to be able to read in a .doc file created in Word 2000, do a string replace, and then write out the file as a new .doc file. I have tried using the standard READ and READSEQ. I use the CHANGE command [REC = CHANGE(REC,txta,txtb)] and then WRITE (or WRITESEQ). In each case I get the anticipated results but when I attempt to launch the document in Word 2000 I get THE unknown file format error. I have to figure that some characters imbedded in the original document are being stripped by the limitations of the uniVerse READ and READSEQ commands thus making this method not practical. I did this in the past - in another life maybe - but this is my first attempt with WORD 2000. All practical suggestions appreciated. dan Note: Effective February 2, 2004, Arnold Porter became a limited liability partnership with the name Arnold Porter LLP. Please change your records accordingly. The addresses, telephone and fax numbers, and e-mail addresses of the firm and attorneys have not changed. -- This communication may contain information that is legally privileged, confidential or exempt from disclosure. If you are not the intended recipient, please note that any dissemination, distribution, or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete it from his or her computer. -- Daniel Plocinik [EMAIL PROTECTED] Arnold Porter LLP Telephone: 202-274-7639 555 Twelfth Street, NW Fax:202-942-5999 Washington, DC 20004-1202 For more information about Arnold Porter LLP, click here: http://www.arnoldporter.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: ODBC problem - biggie and technical
And you've completely missed the point ... Yes it is a local file. But it's created as part of the bigger process of enabling access to the account. Just creating the file is useless. Once it's created, getting HS.UPDATE.FILEINFO to run isn't enough. It's all the other things that prepare this account for odbc access does that aren't getting done. What's the point of creating the file, if the odbc daemon doesn't know the account exists to look for it? etc etc. I don't know what's going on under the bonnet, and if the car splutters to a halt half way down the road EVERY time I try, I'm not going to get very far, am I? Anyway - this problem was caused (I presume) because I kept *deleting* the file to try and give each subsequent attempt another clear shot at eanbling access. So it's clear that just creating it is going to do nothing. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Olson Sent: 26 February 2004 12:48 To: 'U2 Users Discussion List' Subject: RE: ODBC problem - biggie and technical isn't hs_file_access a local file in the account you want to export tables from ? if not create it ? then see if you can see table from client -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: Thursday, February 26, 2004 4:30 AM To: [EMAIL PROTECTED] Subject: ODBC problem - biggie and technical I'm trying to enable odbc access to an account. odbc is working fine for other accounts, so it SEEMS to be a problem with just this one account. However, I suspect I may have damaged the HS.ADMIN account in my efforts to get this to work :-( Okay. What's caused the problem is wIntegrate. As you may know (various people have moaned) it will occasionally terminate a session for no apparent reason whatsoever. The only program that does this to us is HS.UPDATE.FILEINFO. You can guess what's coming ... The enable odbc access option in HS.ADMIN calls HS.UPDATE.FILEINFO as part of its workings. It killed the session half way through ... After several attempts to get it to behave itself, I am now getting errors where it is unable to initialise the HS_FILE_ACCESS file. I'm not sure whether there is supposed to be an HS_FILE_ACCESS file in the HS.ADMIN account, but if there is, I've accidentally deleted it. It doesn't appear to be there on my other server, though. So I'm now stuffed. How do I get HS.ADMIN working again, or alternatively bypass it completely to enable ODBC access. If anybody knows what *HS.ACTIVATE does (in detail), or can slip me the source or tell me where to find it, or can help me some other way, thanks very much. Cheers, Wol *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [OT] Making Linux bootable CD
Actually, iirc, it's even easier than that. Roxio takes over the .iso extension so double-click the iso, and up will fire Roxio all ready to burn ... :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Logan, David (SST - Adelaide) Sent: 24 February 2004 20:27 To: U2 Users Discussion List Subject: RE: [OT] Making Linux bootable CD Hi Martin, Having finished this exact task less than 24hrs ago 8-0 go into Roxio CD, Create a Data CD and then goto File menu, Create a CD from an image, browse to the directory where your iso files are (don't forget to change the file mask in the drop down box from cif to iso) and click on the file you wish to create. I've just done slackware, suse and redhat so I am fairly sure it will work 8-) I'm trying to get another database running that doesn't like something Red Hat has done. Contact me offline if you have any more problems. HTH Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Phillips Sent: Wednesday, 25 February 2004 3:42 AM To: [EMAIL PROTECTED] Subject: [OT] Making Linux bootable CD OK, I give up. Someone out there must have done this and have the answer I need to set up a new Linux system. I have downloaded the five RedHat 8.0 .iso CD image files. I now need to make a set of bootable CDs. Everything on the RedHat web site starts from the assumption that your CD writer is on a running Linux system. Mine isn't. It's on a Windows 2000 system. I have Roxio Easy CD Creator 5 which has an option to write bootable CDs. RedHat suggest using cdrecord. This in turn requires CygWin. I downloaded this but the instructions don't work because the commands they use aren't there. I want to do the job with my existing Easy CD software. I have spent the entire day trying to do this. I will be forever grateful to anyone who can email me the steps to make these CDs. Unless you think it is worth publishing to the whole group, please email it to [EMAIL PROTECTED] to reduce off topic mailings. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniCommand via UniObjects (Java)
I would actually try sending PA @FM QSELECT @FM SSELECT Dunno whether it would work, but if sending an @FM-delimited list of commands screws up by giving all the rest of the string to the first command, maybe making the first command PA (to invoke the paragraph processor) would achieve exactly what he wants? I never realised before I started reading cdp/oliver that you didn't need PA at the start of an @FM list called by EXECUTE, so that's the way I've always done things. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil Walker Sent: 24 February 2004 21:25 To: U2 Users Discussion List Subject: RE: UniCommand via UniObjects (Java) I believe he can just call a paragraph such PARAGRAPH 12345 Where PARAGRAPH is the following VOC entry PA * C2,ARG1 QSELECT CLIENT.XREF ARG1 SSELECT AR.TR BY MATTER WITH INVOICE = ARG1 Phil Walker +64 21 336294 [EMAIL PROTECTED] infocusp limited \\ PO Box 77032, Auckland New Zealand -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dawn M. Wolthuis Sent: Wednesday, February 25, 2004 10:16 AM To: 'U2 Users Discussion List' Subject: RE: UniCommand via UniObjects (Java) I think you can put the commands in a single paragraph and run that from UniObjects. You'll have to pass in the DATA to the paragraph (since I figure that 12345 is the value of a variable) and I haven't tried that with UOJ, but I suspect others have. Good luck. --dawn Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Donald Kibbey Sent: Tuesday, February 24, 2004 1:55 PM To: [EMAIL PROTECTED] Subject: UniCommand via UniObjects (Java) I'm attempting to send a compound command with the UniCommand object and have hit what looks like a documented limitation. Before I go off and rethink how I'm doing this, I thought I'd ask to make sure this really won't work. What I'm attempting is to run something like this under UniObjects. QSELECT CLIENT.XREF 12345 :@FM: SSELECT AR.TR BY MATTER WITH INVOICE = 12345 On this system, doing this results in a very quick selection of a couple hundred records out of the AR.TR file. But, the docs for UniObjects say only one command at a time. Does this mean that sticking a couple commands together like this is just not possible? I've tried it and it looks like the QSELECT is being attempted with all parts of the command string. If it won't work, I suppose I'll be reduced to writing up a stub of a program to do the same thing and just call it from the UniObjects side of things. But, if there's a better way, I'm all ears. Thanks, -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [OT] Pr1me Hardware question
If it's an AMLC ... I'm sure an engineer on (I think) news:comp.sys.prime could tell us, but I'm guessing it must have been one of the big boxes. We had AMLCs on our 25/30, But by the time of the 850 an 950 I think they were using ICS boards. So - we got our first rabbit mid-83? that was post-AMLC I would guess. Of course, the old machines were still around so AMLCs would still have been around, but they would have been disappearing by then. I'd love to get my hands on an old rabbit, but I doubt there are many about :-( Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Richardson Sent: 23 February 2004 04:39 To: U2 Users Discussion List Subject: Re: [OT] Pr1me Hardware question Wow. I appreciate the OT, Dawn! I used to work at Pr1me, started in manufacturing in 1979, doing incoming quality control on their multi-layered printed circuit boards. This board may even have a stamp on it, showing who actually tested the board through the process. I moved up to Marketing Technical Support at the Corporate Marketing Support Center from manufacturing in 1981, and was there until 1983 - when I went off to join Pr1me VAR MADIC, (manufacturing applications package), written in Pr1me INFORMATION. I ended up coming back to Prime in 1986, after MADIC had business difficulties, and was a founding technical member of the PICK to Pr1me INFORMATION Conversion Reseller Support Center. I would dare to say that you are looking a an AMLC - Asynchronous Multi Line Controller card. Serial tty I/O board, four connectors of four Asynch ports per, yeilding 16, (0-15), total ports. I think 9600 baud maximum, (maybe 19.2K?). If I remember correctly, these are four layer, maybe 6 layers, of substrate/circuitry. The 0-3, 4-7, 8-11, 12-15 side would be sticking out the back, where cable assemblies would connect up to them. The opposite side of the board - with two longer gold tipped fingers connectors are, would be plugged into the backplane, which is how all the boards would talk to each other; Memory at the top,CPU board sets next, disk controllers communications controllers next, and asynchronous termial controllers next. Of course, power supplies at the base. These backplanes were basicially printed circuit boards, yet some of them still had wire-wrapped connections on them. These would be the boards that handled serial tty RS232 ports to dumb terminals, BeeHives (PT-45), Perkin Elmer OWL, PT200's in the later years. Do you recall what model of Pr1me 50 Series it came from? What company were you working at that was using it? I hope this helps provide you with some historical technical tidbits to share with the young whippa-snappers! Regards, Scott Richardson Senior Systems Engineer / Consultant Marlborough, MA 01752 Email: [EMAIL PROTECTED] Web: http://home.comcast.net/~CheetahFTL/CC eFax: 208-445-1259 *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Wintegrate xterm or Linux emulation
Doesn't an xterm by default emulate vt? And what are you trying to do? I don't understand the question ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jonathan Brock Sent: 23 February 2004 04:22 To: U2 Users Discussion List Subject: RE: Wintegrate xterm or Linux emulation -Original Message- Subject: Wintegrate xterm or Linux emulation Dear All, Has anyone managed to get winteg 4.2 to emulate xterm or linux terminal types or does anyone know if winteg 5 emulates either of these? Looking at wintegrate if I put together a .wit and put it in wintsys/wit directory it might work but I thought I'd ask in case anyone has been there. Thanks, Adrian -- Hi Adrian, We're running wIntegrate 5.1.0 to get to UniData 5.2.15. In checking the terminal setup dialogue, wIntegrate supports the following types of terminal emulations: addsvp adm11 amp230 ansi at386 cifer d413ibm3151 in4407 in9400 in9400b Monitor Nonepcmon prism prism9 pt200 qvt119 regent scoansi tvi950 tvi955 tvi965 viewdata vt100 vt220 vt420 vt52 w50vp wyse50 wyse60 Hope that helps... Jonathan H. Brock 911 Systems/Database Administrator Josephine County 911 Agency 500 NW Sixth Street - Courthouse Grants Pass, OR 97526 Office: 541-472-1911 Cell: 541-218-4981 Pager: 541-955-2298 Office Email: mailto:[EMAIL PROTECTED] Home Email: mailto:[EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.592 / Virus Database: 375 - Release Date: 2/18/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: @SPAM+++++++++
Doesn't time fly! I can (just about) remember when 1c == 1d. That really DOES go back! Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neil Charrington Sent: 20 February 2004 10:25 To: U2 Users Discussion List Subject: RE: @SPAM+ Wol, that would be awfully long time ago - an exchange rate of 1.20 to the pound (maybe around 1983ish). For a long time it was at around 1.50 to the pound ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Youngman Sent: 20 February 2004 09:32 To: U2 Users Discussion List Subject: @SPAM+ $72 per user? That's CHEAP! We pay IBM direct £60 per user. At current exchange rates, that's about $110. In mitigation, though, sterling has been rising markedly of late - not that long ago £60 would have been about $72. Cheers, Wol *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UniVerse and Backup Exec
Are you backing up just a user-accounts partition, or are you backing up the UV account itself, too? We had an issue with backup software (I think it was BackupExec) and backing up the UV account. If the NT client code is the same as the nix code (ported from nix) that could be your problem ... When our backup software built up a list of files to be copied to tape, among other directories, it picked up the global catalog, which has loads of files whose name begins with * ... OOPS !!! This list got reglobbed ... and the asterisks were treated as wildcards ... I can't remember what happened, but I can well imagine a recursive file expansion causing the system to OOMplode ... (Out Of Memory). And don't say this is NT - there are more than enough cases of nix software being modified just enough to run on NT and suffering the same problems as running native nix. I'm not saying this definitely IS such an instance, but it could well be ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dennis Bartlett Sent: 19 February 2004 14:29 To: 'U2 Users Discussion List' Subject: RE: UniVerse and Backup Exec Hi Gwen We're running UniVerse 10.0.4 (a known baddie as it is) and Backup Exec, tho' which I don't know off hand. We also get plenty app errors We've had 47 system crashes sinces Aug '03, which IBM have first blamed on Backup Exec, then told us that 10.1 would fix it thereby admitting the problem lay in UV. When pressed to supply us 10.1 to fix the problem, the answer was that we'd have to wait for 10.1.1 as that was specific for our platform We originally thought the problem might lie in the way the system (incl W2K) had been loaded, and so re-installed W2K Server, then Backup Exec, then used that to restore the system. Didn't work. We're still running B/E on the UV server, the system crashed twice yesterday, and once today, and management still doesn't see the need to change servers / UV's just yet. One thing tho' we did do when tweaking the reloaded UniVerse - we modified a registry key that some bright spark had discovered helped B/E and UV to co-exist. What that tweak is I don't remember - but I know that the guy who does is also on this list - Kurt, please supply! Something else that IBM said might fix the problem was if we installed B/E on a different server and backed up over the network... dennis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of At 09:18 AM 2/17/04 -0500, you wrote: I am running: UniVerse 10.0.17 Windows 2000 SP 4 Veritas Backup Exec: Media Server Admin. Console: Ver 9.00 Rev 4454 snip much of message Thanks in advance for any help you can offer! Gwen Buck Gaska Tape Inc. [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: WinteGrate
But what if IE is not the default viewer for jpegs or pdfs? (admittedly
this is a home setup, but I've barred IE from accessing the network!).
As I said, I think invoking the document will fire up the default
viewer, but although I know it can be done I'm not certain whether that
is the way or not.
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Hennessey, Mark F.
Sent: 19 February 2004 15:25
To: U2 Users Discussion List
Subject: RE: WinteGrate
snip
Use the wIntegrate execute command on pc function to display the file.
sender by reply e-mail and destroy all copies of the original message.
/snip
We do something similar using rsh (wrshdnt runs on each pc)... I think
the pc command you'd want (assumine internet explorer in a default
instal):
/progra~1/intern~1/iexplore {url to where the jpg is located}
We pass a url that leads to a small *nix machine running apache that
mounts a directory from our production machine. Just like that, our old
character based application reaches out, opens IE and sends the user
to the exact pdf they want...
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
***
This transmission is intended for the named recipient only. It may contain private and
confidential information. If this has come to you in error you must not act on
anything disclosed in it, nor must you copy it, modify it, disseminate it in any way,
or show it to anyone. Please e-mail the sender to inform us of the transmission error
or telephone ECA International immediately and delete the e-mail from your information
system.
Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong
Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.
***
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: WinteGrate
Good to know. So if I need to, I can do that too :-)
I just wonder who sent the original posting recommending IE (and when)?
I'm convinced our anti-spam is dropping some mail, as I regularly see
replies to emails I've never seen ... (coupled with the tendency now on
this list to oversnip - deleting attributions and all :-)
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Barry Rogen
Sent: 19 February 2004 15:48
To: U2 Users Discussion List
Subject: RE: WinteGrate
I did it your way Anthony. It did in fact fire up the default
viewer, whether I was testing with jpg, bmp or tif. Seems to allow
just what I wanted.
Barry Rogen
Senior Programmer
PNY Technologies
(973) 515 - 9700 ext 5327
[EMAIL PROTECTED]
_
The quality of a person's life is in direct
proportion to their commitment to excellence
regardless of their chosen field of endeavor
vince lombardi
_
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Anthony Youngman
Sent: Thursday, February 19, 2004 10:45 AM
To: U2 Users Discussion List
Subject: RE: WinteGrate
But what if IE is not the default viewer for jpegs or pdfs? (admittedly
this is a home setup, but I've barred IE from accessing the network!).
As I said, I think invoking the document will fire up the default
viewer, but although I know it can be done I'm not certain whether that
is the way or not.
Cheers,
Wol
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Hennessey, Mark F.
Sent: 19 February 2004 15:25
To: U2 Users Discussion List
Subject: RE: WinteGrate
snip
Use the wIntegrate execute command on pc function to display the file.
sender by reply e-mail and destroy all copies of the original message.
/snip
We do something similar using rsh (wrshdnt runs on each pc)... I think
the pc command you'd want (assumine internet explorer in a default
instal):
/progra~1/intern~1/iexplore {url to where the jpg is located}
We pass a url that leads to a small *nix machine running apache that
mounts a directory from our production machine. Just like that, our old
character based application reaches out, opens IE and sends the user
to the exact pdf they want...
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
***
This transmission is intended for the named recipient only. It may
contain private and confidential information. If this has come to you in
error you must not act on anything disclosed in it, nor must you copy
it, modify it, disseminate it in any way, or show it to anyone. Please
e-mail the sender to inform us of the transmission error or telephone
ECA International immediately and delete the e-mail from your
information system.
Telephone numbers for ECA International offices are: Sydney +61 (0)2
9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New
York +1 212 582 2333.
***
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
RE: [UV] Pass by value [was:Need/Want/Would like to know]
Maybe passing a matrix in parentheses DOES pass by value - it passes the value of the matrix reference! Which still contains pointers to the matrix elements ... :-) With respect to the docu, I suspect it's meaningless when talking about matrices because it's not talking about what you think it is. For the same reason that C actively discourages passing structs by value (it's a HORRENDOUS performance hit on anything beyond the trivial), I suspect UV doesn't pass matrix CONTENTS by value for the same reason. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart Boydell Sent: 17 February 2004 23:10 To: U2 Users Discussion List Subject: [UV] Pass by value [was:Need/Want/Would like to know] I know that UDT passes by reference Interesting. The UV documentation for the CALL statement says: All scalar and matrix variables are passed to subroutines by reference. If you want to pass variables by value, enclose them in parentheses. Enclosing a matrix in parentheses apparently does not actually work. (UV10.0.7 aix) Vlisting the difference between a scalar and a vector (1D matrix) variable surrounded by parentheses shows in the first example, using a scalar variable, passes by value using a new internal variable _T. In the second example, surrounding a vector in parentheses does nothing and the vector is passed by reference, the same as if there were no parentheses. --- 1 5: CALL P2((A), MAT X) 5 00022 : 0F8 move A = _T 5 00028 : 01E call P2 _T X --- 2 5: CALL P2((X(100)), MAT X) 5 00018 : 01E call P2 X(100(1(X Seems like a bug in the documentation. Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: [ADMIN] The aforementioned and promised NAG about OVERQUOTING
Except - the most important thing is COURTESY. To OTHER PEOPLE. I'm amazed I've stayed out of this as long as I have :-) The problem is that top-posting encourages people to not trim. That leads to, typically, maybe 90% of the average post being junk that's been seen before? Add to that, it is still probably normal that most people do not have flat fee net access (that's not true for the US I expect, but it's probably still true overall). How would you like to be downloading all that crap, at a cost of say 50c/min, where your 14,400 modem is running at half-speed due to the phone line being crap! LookOut is designed for people on a LAN running at gigglebit(sic) speeds. Think of those people who are still on old technology ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: 18 February 2004 13:47 To: 'U2 Users Discussion List' Subject: RE: [ADMIN] The aforementioned and promised NAG about OVERQUOTING I have to say, I just loaded Outlook 2003, and sort EVERYTHING by conversation... I'm kinda sorry people are now making efforts to complying with 'netiquette', because 'top posts' are SO much easier to use in this venue - it is awesome to be able to run through the whole set of topics in the preview pane without having to so much as scroll I suspect we'll see Netiquette change over time for this reason - as posts become more 'real time' and interactive, it would make sense the rules would evolve as well... More and more we're *not* typically reading a response a week later or out of context - the world is changing! Evolve! ;-) -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: set.term.type,Redhat 8.0, UV 10.0.9
Check your UV terminfo files ... (and possibly your unix/linux ones too). There's almost certainly a setup string in their you need to tweak. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Richmond Sent: 16 February 2004 20:29 To: u2 Subject: set.term.type,Redhat 8.0, UV 10.0.9 Hi All, We are in the process of migrating fron HPUX 10.20, UV 9.4.1.1 to Redhat 8.0, UV 10.0.9. We are having a problem with Universe SET.TERM.TYPE command. When we do 'SET.TERM.TYPE VT320 the terminal emulator (QVT 5.2) switches the number pad from numeric to application' mode. This does not happen on our current system. Has anyone else experienced this problem? If so, What did you do to remedy this? Thanks, Steve -- Steve Richmond Associate Director of Computer Applications Morehead State University 606-783-5236 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Enabling ODBC for non-SQL file
Did you run HS.UPDATE.FILEINFO? Have you put the correct SQL type definitions in fields 8? Did HS.UPDATE.FILEINFO actually work correctly! THAT'S A BIGGIE! I've shoved a little article on pickwiki you might want to look at - multivaluedatabasesuniverseodbcaccess Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Hester Sent: 17 February 2004 01:11 To: U2 Users Discussion List Subject: Re: Enabling ODBC for non-SQL file Thanks, I went through the options on the HS.ADMIN menu, including HS.SCRUB and the HS_FILE_ACCESS file was created. For some reason it excluded the file I need from HS_FILE_ACCESS though, even though I added an @SELECT dictionary item. If I run CONVERT.SQL against the file (not using my live data file), I can then see it via ODBC in Excel, but the dict items don't work correctly. Is it safe to manually add a record for the non-SQL file to HS_FILE_ACCESS? Thanks, John Jeff Schasny wrote: First create an @SELECT item in the dictionarys of the files you are aiming at. Then logto HS.ADMIN and issue the HS.ADMIN command from TCL. Select Option #3 to activate access to files in an account. Whenever you change an @SELECT Item or want to add access to another file you can run HS.UPDATE.FILEINFO in the account rather than going back to the HS.ADMIN account and running option #4 (Update File Information Cache in an account). -Original Message- From: John Hester [mailto:[EMAIL PROTECTED] Sent: Monday, February 16, 2004 3:34 PM To: U2 Users Discussion List Subject: UV: Enabling ODBC for non-SQL file I'm trying to enable ODBC access to a standard UV non-SQL file and have found the following in the ODBC manual: To make UniVerse files accessible to ODBC applications, you must run the ODBC file access utility in the account. However, they don't bother to say what this ODBC file access utility is called. I've tried listing the VOC LIKE ...HS... and ...MENU... but can't find anything relevant. Are they referring to HS.UPDATE.FILEINFO? TIA, John -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: COMO: Help on How to use COMO?
If you type HELP COMO at TCL, it'll tell you ... Or I'll tell you :-) From within your program (or wherever) do an EXECUTE COMO ON PROGOUTPUT HUSH This will create a PROGOUTPUT record in the COMO file that you can then access with the editor or whatever you want. To turn off the como, just do EXECUTE COMO OFF Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amit Bhutani Sent: 17 February 2004 13:07 To: U2 Users Discussion List Subject: COMO: Help on How to use COMO? I want to log all errors in a record of COMO without displaying them on screen? How should I intiallize como and how can I pass this error message to that record, E.g. WRITEU D.FILE TO F.FILE,K.ID LOCKED PRINT ERROR::K.ID: record locked by user :STATUS():, please stand-by ELSE PRINT ERROR:Failed to write in :FILE: with ID=:K.ID I want to store this error message in a record of COMO file regards Amit Bhutani -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Hashing Algorithm
If it's classed as a trade secret, then IBM will have to prove they took all reasonable measures to keep it secret. If it was taught to people on the internals course and those people weren't asked to sign an NDA, then bang goes its secret status. And that includes all the people who went on courses run by Informix, Ardent, VMARK et al... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 February 2004 15:46 To: [EMAIL PROTECTED] Subject: Re: Hashing Algorithm In a message dated 2/13/2004 6:18:30 AM Pacific Standard Time, [EMAIL PROTECTED] writes: I have the algorithms (from a legal source long before IBM acquired the product) but because they are now secret I cannot divulge the details. They are, however, extremely simple except for the dynamic algortihms which are rather more exciting. That's a interesting question. I have to say that in general IMHO a company cannot retroactively seize control of something that at one time was freely available. Something in the US about seizure without a warrant? Bill of rights or something? Will I'm not a lawyer, but I play one on the Internet Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV on SCO Unix
I'm following the court case. I don't expect there'll be much left of SCO once the court case explodes in their face. Which might well be a lot sooner than they expect - the motions for summary dismissal on merit are likely to start flying soon! As for is linux unix, well, as the court case has shown, there's UNIX(R) and no linux isn't, there's Unix as in it contains ATT code and no linux isn't, and unix as in folowing the unix philosophy which linux definitely is. And don't forget, most UNIX(R) is now GNU, seeing as most of them either ship with GNU installed or administrators add it as almost their first act of ownership :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Logan, David (SST - Adelaide) Sent: 11 February 2004 22:51 To: U2 Users Discussion List Subject: RE: UV on SCO Unix I can only agree to placing option 7 where it is, I would seriously look at an X86 server running a couple of Xeon processors at 2.4Ghz or quicker. If you have good Unix skills, take a long look at Linux, the price is right and there haven't been too many complaints on the list about the Universe product on Linux. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: 2 gig limits
On the version of Unix we're running (SCO 3.2), you can't even create a FILESYSTEM over 2Gb - we had to partition our 4Gb drives in two ... (that dates the system :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Logan, David (SST - Adelaide) Sent: 10 February 2004 20:52 To: U2 Users Discussion List Subject: RE: 2 gig limits It would have to be a 64bit file, there are no exceptions as this is a limitation brought on by the size of a number. (I think a couple of earlier posters had the numbers involved) therefore you literally cannot create a file larger than 2Gb with 32 bit addressing. *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Secondary Indices on Distributed Files
Except it's not a strange reason. The whole point of a distributed file is that any part of the file can be treated as a file in its own right, so it needs its own dictionary. And given that MV makes no distinction between data and dict portions at the structural level (and all that jazz), there's no reason why you can't have one dict portion serving every data portion. Beats most SQL databases I know of, where you can't point one definition table at several data tables, despite CoddDate saying that relational (like MV) isn't allowed to draw any fundamental distinction between data and the definition of that data. Index handling in distributed files is funny, but it makes perfect sense once you understand how DATA/DICT and distribution all fit logically together. Jump in with a superficial overview and you'll be well puzzled, look at it in depth and you'll understand how neat it actually is, and where it seems messy (as indeed it is) the alternatives are actually ten times worse ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 February 2004 20:37 To: [EMAIL PROTECTED] Subject: Re: Secondary Indices on Distributed Files For some strange reason, the DICT of each Part File needed to contain copies of the I-Types from the Distributed File's DICT in order for CREATE.INDEX to work correctly. Next question... To avoid having to copy DICT items to all the Part Files each time a change is made, I updated the VOC pointer of each Part File to look at the DICT for the Distributed File. This seemed to work fine for the CREATE.INDEX, and each INDEX.000 record within each of the I_files (one for each Part File) has correct index information for the records within it's part file. From a Distributed File perspective, does anyone see a problem with changing the DICT pointers for each Part File to look at the DICT of the Distributed File? Each Part File belongs to only this one Distributed File. If not, then how about the Indices themselves when combined with Distributed Files? Would each Part File not using it's own DICT cause a problem? Thanks! [EMAIL PROTECTED] group.comTo: U2 Users Discussion List [EMAIL PROTECTED] Sent by: cc: u2-users-bounces@Subject: Secondary Indices on Distributed Files oliver.com 02/09/2004 12:08 PM Please respond to U2 Users Discussion List I've got a Distributed File that I'm trying to create indices on. Four of the fields are D-Types, and CREATE.INDEX runs fine for them. Three fields though, are I-Types (that are compiled and working), where CREATE.INDEX gives the following error: I-descriptor must be compiled before execution. I-descriptor must be compiled before execution. I-descriptor must be compiled before execution. Program *UVPRINTMSG: pc = 34, Variable previously undefined. Zero length string used. [00] All seven fields are working just fine as indices on the original file that was a Static Hashed file. I'm setting up the Distributed File to get around the 2GB limit issues. Does anyone know of any limitations putting secondary indices onto distributed files? Thanks! Gary Canedy --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not
RE: Formatting a Negative
But if you're doing it for accounting reasons, that's the convention. You use parentheses INSTEAD OF as negative sign. It makes it stick out because on the rhs the parens stands out in a column of its own. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Olson Sent: 10 February 2004 15:10 To: 'U2 Users Discussion List' Subject: RE: Formatting a Negative parens ??? theres the qoute() function or an conversion code oconv( negnum , 'MD' ) but you loose the - sign ex. negnum -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Baruch Salamander Sent: Tuesday, February 10, 2004 10:01 AM To: [EMAIL PROTECTED] Subject: Formatting a Negative What's the exact command that places parenthesis around a negative number? -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users Notice of Confidentiality: The information included and/or attached in this electronic mail transmission may contain confidential or privileged information and is intended for the addressee. Any unauthorized disclosure, reproduction, distribution or the taking of action in reliance on the contents of the information is prohibited. If you believe that you have received the message in error, please notify the sender by reply transmission and delete the message without copying or disclosing it. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UV secondary index
Two tricks to speed things up ... Firstly, would the NO.NULLS keyword speed things up? I'm guessing your fields can often be blank, and in this case you will have a single huge record knocking your index for six! Secondly, would the pause and resume indexing commands work? During the day, while the users are working, you pause index updates. At the end of the day (or whenever you need to run the reports) you resume indexing. Okay, it'll knacker the system while it sorts out the indices, but it'll be one short, concentrated hit. The you run your reports, disable indexing again, and let the users at it ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 February 2004 09:23 To: [EMAIL PROTECTED] Subject: UV secondary index Hello, I have distributed UV file with total size about 2.5Gb. I made secondary index CREATE. INDEX file field1 ... field6 BUILD.INDEX file field1 ... field6 After that, rows inserting takes very long time. (4000 rows. Server so busy, that other users can't do anything. If I removed index then inserting process is OK, but I need this index for reporting) Is it normal in UniVerse? How to avoid this problem? I use UniVerse 9.5.2 on AIX 5.2 Thanks, Margus Kandelin -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Proc or Para
Old history now, but as a Pr1mate (as in used, not worked for), I never learnt (or even MET!) procs until extremely late in the day. Official support for procs appeared with INFORMATION 8.1, released probably about 1991 just before they went bust :-( It just WASN'T THERE on any system I ever worked with ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 05 February 2004 04:41 To: U2 Users Discussion List Subject: Re: Proc or Para Here, Here!! I agree with Chuck on the value of procs. Being a 25 year proctologist myself allows me to support a wide variety of platforms. Many of my UD/UV/D3 clients, while having paragraphs and other newer additions available, still function with a lot of code that was inherited from earlier conversions. Oftentimes management many not be able to justify a re-write of code just because the language isn't today's flavor. Coming from Microdata since the 70's, you only had procs with procread/procwrite as a way to get fancy with PQ procs. PQN in 1979 offered more read/write and direct variable features but the other licenses were developing EXECUTE which, looking back, was the better tact. Still, i keep my proc skills sharpened as I still have to support it. Proc does have some pretty nifty features for such a simple command set. Earlier PQ proc didn't have read/write so they developed a sideline language called BATCH which did these tasks. BATCH is officially removed from the direct decendancy of R80/83 as D3 doesn't recognize it and i haven't seen it on any U2 systems. RPL, which predates this further never made it past the mid 1970's. Isn't it great to have choices. my 1 cent. - Original Message - From: Results [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Wednesday, February 04, 2004 1:18 PM Subject: Re: Proc or Para L, Proc predates Pick BASIC as a programming language. The short answer (to my mind) is that Paragraph is an add-on to Access/English/AQL/Retrieve, but Proc is really a scripting language. If you need to automate procedures, tie complex programs into a batch, or do other heavy lifting, Proc is great. The problem that gets all these Proc haters on their soapbox isn't Proc, its when people use Proc for the wrong tasks (like Proc menus instead of parametric menus). Proc really is incredibily powerful and well worth knowing, but it shouldn't be used for 9-% of the tasks it is normally associated with in the Pick world. Personally, I rtarely use Paragraph because I need to port software. - Charles 'Proc is JCL on Steroids' Barouch -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) To nitpick - but it catches out a LOT of people - SAMBA is NOT NOT NOT the appropriate software here. It will NOT do what you claim. Samba allows Windows boxes to access a unix server (and allows that server to join a Windows domain). If you want to use a unix *client* to access a Windows server, you need smbmount and friends, which are not not not samba. If you want to what you suggest, using samba, you need to get the pcs to save directly into a nix directory which samba has exported to the network, rather than getting a nix box to monitor a windows directory. Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George GallenSent: 03 February 2004 21:49To: 'U2 Users Discussion List'Subject: RE: Document scan and retrieval (looking for software) Could also have the PC that is scanning save to a specific directory. then have a program monitor that directory for new entries, read them, encode them and save them somehow then the saved filename would have be linked into the system. I'm just using pcpaint as an example of a program that might be able to read directly from a scanner and save in .jpg/.bmp format. If volume is high, and a number of scanners are being used, then have one central PC share it's directory and each scanner saves to that directory. Since the directory is shared, you could even have unix system running SAMBA monitor the directory (thus bringing unix into the picture). The only drawback to having unix in the setup is that it is more difficult to have unix bring up IE on a PC. But that could be gotten around if you run a lpr/lpd daemon on the PC which can then take a print job and pass it to a program (ie. RPM www.brooksnet.com). or use a PC with rsh daemon that would allow the unix system to send the launch command to the PC. or even a small custom PERL socketed program on the PC which could listen for a command and launch IE. Depending on the $$ wanted to be spent. I don't think a having the image be a type 1/19 file would be good, unless it's base64 or mimeencoded, as you could have char(255)'s imbedded in the image. George *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help wanted creating an efficient SELECT statement
This is a bit messy ... Firstly create an i-descriptor as follows 0002: FIELD( @ID, ",", 1, 1); FIELD( @ID, ",", 2, 1)+1; TRANS( @FILENAME, @1:".":@2, 0, "X") (I think I've got that right...) What it's doing is adding 1 to the X bit, and doing a trans to see if the record exists. If I've got it right, this i-descriptor should return the next id if it exists, and null if it doesn't. So just select with this thing equal to null. Of course, it'll be fooled if you have a non-sequential X list. Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco ManyevereSent: 04 February 2004 08:20To: [EMAIL PROTECTED]Subject: Help wanted creating an efficient SELECT statement Hi All, I have a file with IDs like this: 1.2, 1.2 1.3, 2.1, 2.2, 2.3, 2.4, 3.1, 4.1, 5.1, 5.2, ... Each ID is N.X where X is a numeric secondary ID number from 1 going upwardsand N is the primary ID number which may or may not be numeric.Different primary IDs have a different number of secondary IDs. For a certain report, I want to select only the records with the highest numerical value of X for each of N. For the above example, I want to end up with 1.3, 2.4, 3.1, 4.1, 5.2, Can aSELECT statement(s) be composed without having to write a program? If not what would be the best approach. Thanks for any help. Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) "Included with" and "part of" aren't the same thing. That's why the samba teamdumped smbclientfrom the samba package! (but put it back when too many people moaned.) By the way - "smb" is an IBM acronym for "Server Message Block" so even the fact that the names are similar is no evidence that they are part and parcel of the same thing. They just happen to have the same ancestor way back, like a load of your cousins share the same surname as you ... Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff SchasnySent: 04 February 2004 15:32To: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) Actualy smbclient is part of samba and works quite nicely in reading and writing to windows shares. smbmount is only available on linux samba installs.If someone would like a couple UVBasic programs to "put" and "get" via smbclient I'd be glad to send them along. -Original Message-From: Anthony Youngman [mailto:[EMAIL PROTECTED] If you want to use a unix *client* to access a Windows server, you need smbmount and friends, which are not not not samba. If you want to what you suggest, using samba, you need to get the pcs to save directly into a nix directory which samba has exported to the network, rather than getting a nix box to monitor a windows directory. Cheers, Wol *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Document scan and retrieval (looking for software)
Title: RE: Document scan and retrieval (looking for software) Could be. Whatever it is, it's ancient history :-) You know Tridge originally wrote samba to communicate with DecNET, and was surprised to discover that it could be used to communicate with MS too? When his company retired the PDPs or Vaxen (can't remember...) he was going to drop it and was surprised when users said not to! Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George GallenSent: 04 February 2004 16:06To: 'U2 Users Discussion List'Subject: RE: Document scan and retrieval (looking for software) I thought smb was simple message block? I haven't googled it, just from memory... George -Original Message-From: Anthony Youngman [mailto:[EMAIL PROTECTED]Sent: Wednesday, February 04, 2004 11:04 AMTo: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) "Included with" and "part of" aren't the same thing. That's why the samba teamdumped smbclientfrom the samba package! (but put it back when too many people moaned.) By the way - "smb" is an IBM acronym for "Server Message Block" so even the fact that the names are similar is no evidence that they are part and parcel of the same thing. They just happen to have the same ancestor way back, like a load of your cousins share the same surname as you ... Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff SchasnySent: 04 February 2004 15:32To: U2 Users Discussion ListSubject: RE: Document scan and retrieval (looking for software) Actualy smbclient is part of samba and works quite nicely in reading and writing to windows shares. smbmount is only available on linux samba installs.If someone would like a couple UVBasic programs to "put" and "get" via smbclient I'd be glad to send them along. -Original Message-From: Anthony Youngman [mailto:[EMAIL PROTECTED] If you want to use a unix *client* to access a Windows server, you need smbmount and friends, which are not not not samba. If you want to what you suggest, using samba, you need to get the pcs to save directly into a nix directory which samba has exported to the network, rather than getting a nix box to monitor a windows directory. Cheers, Wol***This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system.Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333.*** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: SELECT NOT WORKING [uv 10 - unix]
Title: RE: SELECT NOT WORKING [uv 10 - unix] I was about to ask if TYPE was indexed? That's also an obvious one ... if the index has somehow gotten out of sync. Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George GallenSent: 02 February 2004 22:08To: 'U2 Users Discussion List'Subject: RE: SELECT NOT WORKING [uv 10 - unix] YES. That worked. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, February 02, 2004 5:06 PM To: U2 Users Discussion List Subject: RE: SELECT NOT WORKING [uv 10 - unix] Try SELECT FILE WITH EVERY TYPE # "CREDIT" Harman Armstrong [EMAIL PROTECTED] ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: VARIABLE-1 = '' Inconsistent behaviour
It was this way on PI as well. Bear in mind that the-1 syntax was an "accident" - as originally implemented the search mechanism simply decremented to zero or the end of the string, and some bright spark realised that if you started with a negative number then it would always hit the end of the string rather than zero. So the counter-intuitive result that appending null to null gives null isn't so strange. This behaviour isprobably copied from "original Pick". We get round it by initialising the variable to "*", and then doing a DEL 1 when we've finished. Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louis WindsorSent: 03 February 2004 06:17To: U2 Users Discussion ListSubject: Re: VARIABLE-1 = '' Inconsistent behaviour I think this is a "feature". Universe does NOT insert non-significant nulls. In other words your first two (A-1 = '') do not do anything! It is consistent in its' behaviour as you can count on it to do the above. It has done this as long as I remember. I found this out through bitter experience. Louis - Original Message - From: Marco Manyevere To: [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 12:55 PM Subject: VARIABLE-1 = '' Inconsistent behaviour Hi All, Consider the program: A = '' A-1 = '' A-1 = '' A-1 = 3 A-1 = '' A-1 = 4 PRINT A3 I expect it output '3' but it outputs '4'. Whats the explanation? I'm on UV 9.6 [NT] running information flavour. Regards, Marco BT Yahoo! Broadband - Free modem offer, sign up online today and save £80 ___u2-users mailing list[EMAIL PROTECTED]http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** ___ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Distributed multipart files [as RE: [UV] Resize - Dynamicor64 bit?]
Title: Message To give you an example of how we used a distributed file ... We created several "normal" files, called "ENQUIRIES.YY" where YY was the year. Because our first year was 86, we created a partfile-definitioni-descriptor of "YY-85". Now, YY *MUST* be a part of the @ID.Partfile 1 was ENQUIRIES.86, partfile 2 was ENQUIRIES.87, etc etc. All of these files are just *NORMAL* files except, when you try to write to them, the file write evaluates the i-descriptor based on the record key, and if the result doesn't match partfile number, the write will fail. You can now create *AS* *MANY* F VOC entries as you wish, containing in field 2 a multi-value list of os-level-file-names. And you can access these just like any normal file. What I think happens is that, for ALL opens, the OPEN looks for a mv list in field 2, then opens the first file in the list. If this file has a part algorithm, it flags the file as distributed, and checks the part number for all files in the FILE. Then when you try to read or write, it evaluates the algorithm and goes to whichever partfile matches. If the partfile doesn't exist (there's no obligation for it to), then the read or write fails. So, when we were producing "calendar year" reports, we'd just report on the (apparently) normal file ENQUIRIES.87. If we wanted the 87 financial year, we would again just report on the (apparently) normal file ENQUIRIES.8687, which just happened to have a VOC entry 1: F 2: ENQUIRIES.86 @vm ENQUIRIES.87 3: D_ENQUIRIES. And should we need it, we had a super-file called ENQUIRIES. which had a mv list of all the files, so we could report on that if we needed a list of every transaction by a given customer. This actually is a very good use of distributed files, where data is time sensitive, rapidly obsolete, but occasionally wanted for reports back to the year dot. Especially if data is generated like there's no tomorrow ... Oh - and watch out if you use indices - once you've got your brain round it it's quite intuitive :-) Good Prime design again :-) Cheers, Wol From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark JohnsonSent: 29 January 2004 23:40To: U2 Users Discussion ListSubject: Re: Distributed multipart files [as RE: [UV] Resize - Dynamicor64 bit?] Just curious. Are Distributed files handled by the OS or the programmer. One client of mine had 12 monthly files (2-3 million records each) and the software combined the data into work files for cross-month queries. thanks. - Original Message - From: Logan, David (SST - Adelaide) To: U2 Users Discussion List Sent: Thursday, January 29, 2004 5:53 PM Subject: RE: Distributed multipart files [as RE: [UV] Resize - Dynamic or64 bit?] Hi Stuart, One large advantage (from my perspective) is the ability to address the file as one large file or as an single part individually. The open statement in the program is the same, only the name changes. The ability to put the parts on different file systems, balancing the load is another that springs to mind. The ability to split a file into manageable chunks is another. Some of our tables are starting to stretch toward the 20Gb mark and to split these into manageable chunks makes for reasonable resizing times etc. The individual parts can be resized at different times. The ability to split your data according to your own algorithm is especially useful. With multi-data part files, I don't believe you could address the complete file as one, other than that, the other points I have made are still applicable. I suppose distributed files are easier to deal with from the application point of view. If your distribution algorithm is reasonably well balanced the records will be placed evenly over the individual parts. Even if they are not, eg. you use say, a branch code as thekey, you don't have to worry about opening up the correct multi-part, the system will automatically do that for you. Regards David Logan Database Administrator HP Managed Services 139 Frome Street, Adelaide 5000 Australia +61 8 8408 4273 +61 417 268 665 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stuart BoydellSent: Friday, 30 January 2004 8:57 AMTo: U2 Users Discussion ListSubject: Distributed multipart files [as RE: [UV] Resize - Dynamic or 64 bit?] I have never come across distributed files in a system and they sound a lot like multiple part files (like SYS.HELP,XXX). What is the difference / advantages / disadvantages between usingdistributed files andmultiple data-part files? Can a distributed file also be a multiple part file? Cheers, Stuart -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of David T. MeeksSent: Friday,
RE: ODBC Set Up Universe
Okay ... HS.FILE.ACCESS is the file used to define ODBC access rights to a non-sql account. It should be created automatically when you convert an account to ODBC access. And HS.UPDATE.FILEINFO is that program that processes the HS.FILE.ACCCESS file. It creates some hidden file used by the odbc software so that it knows which files and fields it is supposed to make visible to an odbc client. So if you make any changes to the account from within UV, they are invisible to odbc until you update HS.FILE.ACCESS (if relevant) and rerun HS.UPDATE.FILEINFO Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Reid Sent: 27 January 2004 19:14 To: '[EMAIL PROTECTED]' Subject: RE: ODBC Set Up Universe Group, I had the trigger on a table on a development system until it got overwritten on the week-end. However, we never had a file named HS_FILE_ACCESS. I had created it, but I don't feel that its presence had much to do with whatever success I had. Is it supposed to 'MATERIALIZE'? My objective is to create a trigger on an existing file. Try as I might, I am unable to re-create what I did before. Could someone go over the steps one more time? And possibly, could someone state the function of the HS.UPDATE.FILEINFO? I'm not against reading what ever I need to read, but it seems that at least some people have had negative rewards for their reading efforts. thanks. john reid -Original Message- From: Tony Wood [mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004 5:57 PM To: [EMAIL PROTECTED] Subject: Re: ODBC Set Up Universe Anthony, Do you have NLS turned on? Does anyone have NLS turned on with ODBC on UniVerse? Regards, T. - Original Message - From: Anthony Dzikiewicz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 23, 2004 1:58 AM Subject: RE: ODBC Set Up Universe Thanks for the replys on this issue. The problem was that I did a CREATE SCHEMA in the account I was connecting to. I must have done this because I was reading thru the ODBC guide and the SQL docs and merged the two in my brain. Anyway, I guess if the account is a schema, then the files must be present in the UV_TABLES file. So, my fix was to DROP SCHEMA in the account. I then 'undid' the ODBC access and started from scratch without the CREATE SCHEMA. Now, I can see the files. Now it is just a matter of the HS_FILE_ACCESS and @SELECT that was mentioned. I placed a piece of red tape over the CREATE SCHEMA button so this wont happen again. Thanks Anthony -Original Message- From: Anthony Dzikiewicz [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 4:52 PM To: [EMAIL PROTECTED] Subject: RE: ODBC Set Up Universe OK I just got back to messing with the ODBC problem. There was one file in particular that I was trying to make accessible called 'CR.TRANS'. I did everything by the book and I still cant access it. As I mentioned, I didn't see this file listed in UV_TABLES. There was a HS_FILE_ACCESS created in the account. Anyway, I thought to just create a new file. So I did. I did it thru the SQL command 'CREATE TABLE ANTHONY (MY_KEY PRIMARY KEY); I did a HS.UPDATE.FILEINFO. I tried again via Microsoft query and I was able to see ANTHONY with MY_KEY as a field. It worked ! I also noticed that UV_TABLES has a new entry for this file. So, it looks like what I missed is the fact that files that need to be accessible via ODBC should have entries in the UV_TABLES file. Is this true ? If so, is there a utility that can get an existing file added as a table ? Obviously, I cant CREATE TABLE to do this. The file(s) already exist. Id rather not have to do REVISE UV_TABLES and have to type everything manually. So, what did I miss in the part about converting existing accounts into schemas ? Does any one know the magic word to get existing files into the ODBC arena ? Thanks Anthony Dzikiewicz -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 5:39 AM To: [EMAIL PROTECTED] Subject: RE: ODBC Set Up Universe And make sure that you don't have more files than you need in the account. HS.SCRUB has a habit of abending without any errors (UV 9.6), which can be a real pig when you're wondering why a certain file does not appear to be exported ... there's a system multi-level file that seems always to cause us grief. Can't remember what it's called - we delete the voc pointer every time we see it - something to do with pterm iirc. -Original Message- From: Jeff Schasny [mailto:[EMAIL PROTECTED] Sent: 20 January 2004 21:56 To: [EMAIL PROTECTED] Subject: RE: ODBC Set Up Universe Dictionarys of the files you wish to access must have an @SELECT PH item listing the fields that will be accessable in attribute 2 seperated by spaces. Like this: DICT ENAMES02:52:08pm 20 Jan 2004 Page1
