Re: [U2] Associated MVs
No problem. Set up the 'D' dict records of ADATE ACTIONS OACTIONS and BYS to have the same assoc field say 'X' and keep your PH-records. The you may think of the 'X' as the 'Controlling association code' and the AS_4 and AS_4A as the 'Dependent association codes' The 'X' describes the 1-1 relation between the values in the fields and the PH entries are not much more than a shorthand notation for listings. HTH -- mats Bill_H wrote: Is it possible to assocate the same dictionary item (field definition) to more than one association phrase? I'm doing some conversion work and there are several associations that include some of the same dictionaries. For example, the following association phrases were created: Dict Name... Type # Col-Heading Field-Definition AS_10PH IMPDATE IMPVERSION AS_4 PH ADATE ACTIONS BYS AS_4APH ADATE OACTIONS BYS In a Pick style dictionary this is no problem with the [D]ependent and [C]ontrolling association codes. But I can't figure out how to do it here without creating two new synonym dictionaries for both 'ADATE' and 'BYS'. Thanks, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Associated MVs
Hi Bill, Is it possible to assocate the same dictionary item (field definition) to more than one association phrase? I'm doing some conversion work and there are several associations that include some of the same dictionaries. How can this ever be necessary? If item A has a value by value relationship with item B and item B is similarly related to item C, what situation can exist where the values of A and C are not related in this same way? Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] JDBC and OpenOffice on Linux
I've also taken a look at OOo, albeit in the context of supporting openqm as opposed to U2. There's lots of potential there for ANY MV database. I even dug down to see what might be involved in getting openqm recognized as a datasource. At that time, all the database specs were SQL oriented. But if the OpenOffice folks have open minds (sorry, couldn't resist), we'd be smart to jump on this opportunity. My $.02. Headed over there to vote now. Regards, -- Dave Walker Thanks to TV and for the convenience of TV, you can only be one of two kinds of human beings, either a liberal or a conservative. - Kurt Vonnegut -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ian Stuart Sent: Thursday, December 01, 2005 12:53 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] JDBC and OpenOffice on Linux Hi, thanks for that encouragement - BetterBetter will probably be the place to pursue the IBM angle. However Openoffice.org have also proven that they are willing and able to modify OOo specifically for U2 if there are enough requests from users for similar features/fixes - they have already done so in the past. So, the request is still for the U2 community to take 10 minutes each (in total that adds up to a lot of hours) and vote on the Openoffice.org issue. There are many opportunities to take advantage of OOo, not just as an office suite but as an integrated part of U2 applications, especially if you are looking for similar MSOffice functionality/API on Linux/UNIX. Thanks to those who have already voted. Apart from my own vote 5 other U2 users have used 2 of their votes on this issue. Regards Ian Stuart Results wrote: Ian, U2UG has established a committee that is charged with bringing fixes and enhancements to IBM's attention. The Committee, BetterBetter, is currently looking for a new chairman to continue that work. As soon as BB has a new head, it would be the best place for you to push forward with from this angle. - Chuck Ian Stuart wrote: An issue has been reported on the OpenOffice.org Bugzilla system. But to try and give some impetus to resolving this issue I am soliciting the support of this forum to vote on this issue on the OpenOffice.org site as well as to prevail on IBM to cooperate with OpenOffice.org to resolve the issues with JDBC/ODBC and OpenOffice. However, there are still a number of issues to be resolved, including being able to update tables via JDBC ie. although one can create UniVerse tables from within OOo you cannot insert, update or delete; there is a date format problem - see issue 49043, table names have to be aliased in the VOC etc. etc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Associated MVs
Thanks Mats. Actually I simply changed the association in the dictionaries to be: Dictionary List: DICT CHANGES Prepared on: 07:03:38am 01 Dec 2005 Dict Name.. Type # Col-Heading Field-Definition. Conversion.. Format Assoc... ADATE D4 ACTDATE D2 9R M AS_4 ACTIONS D7 ACTIONS TAKEN 63T M AS_4 BYS D8 ACTIONS BYTUSERS;C;;1 20L M AS_4 OACTIONSI ACTIONS TAKEN @RECORD7 30T M AS_4 (from AS_4A) and left the phrases alone. This is a bit counter-intuitive though. It's as though there's no fixed relationship between attribute 7 and the phrase. In fact, I changed the dictionaries to be: Dictionary List: DICT CHANGES Prepared on: 07:43:03am 01 Dec 2005 Dict Name.. Type # Col-Heading Field-Def Conversion.. Format Assoc. ADATE D4 ACTDATE D2 9R M X ACTIONS D7 ACTIONS TAKEN 63TM X BYS D8 ACTIONS BYTUSERS;C;;1 20LM X OACTIONSI ACTIONS TAKEN @RECORD7 30TM X and left the phrases alone as (no 'X' phrase) : Dictionary List: DICT CHANGES Prepared on: 07:38:30am 01 Dec 200 Dict Name.. Type # Col-Heading Field-Definition... AS_4PH ADATE ACTIONS BYS AS_4A PH ADATE OACTIONS BYS This is the result of the query: LIST CHANGES '131081' DESC AS_4 AS_4A CHANGES 131081 DESCRIPTION OF REQUEST. Allow moving an UNAPPLY amount from one unit to another within a client. Also allow the ability to refund any or all of the UNAPPLY amount. ACTDATE.. ACTIONS TAKEN.. ACTIONS BY.. 20 NOV 03 + Modified the T/R adjustment program to allow an UNAPPLY to wph be 'applied to--:' anywhere including another unit and refund. 24 NOV 03 + Modified the T/R adjustment program to allow an UNAPPLY to wph be refunded, using the new subroutines built for use by the T/R Invoice program. ACTDATE.. ACTIONS TAKEN. ACTIONS BY.. 20 NOV 03 + Modified the T/R adjustment wph program to allow an UNAPPLY to be 'applied to--:' anywhere including another unit and refund. 24 NOV 03 + Modified the T/R adjustment wph program to allow an UNAPPLY to be refunded, using the new subroutines built for use by the T/R Invoice program. Martin: The ACTIONS and OACTIONS are synonyms for the same field, so presently ADATE(4) would have a C;8;7 in it while ACTIONS(7), OACTIONS(7), and BYS(8) would have a D;4 in it. This is one of the painful (and oldest) nuisances with the U2 products, where multiple dictionaries need to be created for different output scenarios. Thanks again, Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Martin Phillips Sent: Thursday, December 01, 2005 2:19 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Associated MVs Hi Bill, Is it possible to assocate the same dictionary item (field definition) to more than one association phrase? I'm doing some conversion work and there are several associations that include some of the same dictionaries. How can this ever be necessary? If item A has a value by value relationship with item B and item B is similarly related to item C, what situation can exist where the values of A and C are not related in this same way? Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Alternate Indexes
Copying from DG/UX to W2k Universe version 10.1.1 using uvbackup and then restoring under UniAdmin restore function. Files and programs doing great. My problem is I_ Files do not restore (for whatever reason) so my Alternate indexes are locked so that I can't do a Create.index on a file that had indexes on the DG. I get a message Unable to open index map e:\filename for read/write . It will work fine on a file that did not have previous indexes. I have a work around by creating an index on another file then renaming it to the file I need then adding the indexes to it. But thought there may be and explanation from the group that could tell me why and how to make it work correctly. Wasn't there a way to edit the position of the indexes or something of that nature? I can't remember. I have searched the Help to no help. Thanks ahead for the assistance. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Alternate Indexes
Try SET.INDEX to update the file's header to point to where the I_ file is on the new W2K box. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: Thursday, December 01, 2005 10:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Alternate Indexes Copying from DG/UX to W2k Universe version 10.1.1 using uvbackup and then restoring under UniAdmin restore function. Files and programs doing great. My problem is I_ Files do not restore (for whatever reason) so my Alternate indexes are locked so that I can't do a Create.index on a file that had indexes on the DG. I get a message Unable to open index map e:\filename for read/write . It will work fine on a file that did not have previous indexes. I have a work around by creating an index on another file then renaming it to the file I need then adding the indexes to it. But thought there may be and explanation from the group that could tell me why and how to make it work correctly. Wasn't there a way to edit the position of the indexes or something of that nature? I can't remember. I have searched the Help to no help. Thanks ahead for the assistance. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Alternate Indexes
What I do when transferring accounts/files from system to system is to SET.INDEX MY.FILE TO NULL FORCE This clears the file header and will allow you to create and build index from scratch. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: Thursday, December 01, 2005 11:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Alternate Indexes Copying from DG/UX to W2k Universe version 10.1.1 using uvbackup and then restoring under UniAdmin restore function. Files and programs doing great. My problem is I_ Files do not restore (for whatever reason) so my Alternate indexes are locked so that I can't do a Create.index on a file that had indexes on the DG. I get a message Unable to open index map e:\filename for read/write . It will work fine on a file that did not have previous indexes. I have a work around by creating an index on another file then renaming it to the file I need then adding the indexes to it. But thought there may be and explanation from the group that could tell me why and how to make it work correctly. Wasn't there a way to edit the position of the indexes or something of that nature? I can't remember. I have searched the Help to no help. Thanks ahead for the assistance. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Alternate Indexes
HELP SET.INDEX -Keith Original Message From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Waldron Sent: Thursday, December 01, 2005 8:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] Alternate Indexes Copying from DG/UX to W2k Universe version 10.1.1 using uvbackup and then restoring under UniAdmin restore function. Files and programs doing great. My problem is I_ Files do not restore (for whatever reason) so my Alternate indexes are locked so that I can't do a Create.index on a file that had indexes on the DG. I get a message Unable to open index map e:\filename for read/write . It will work fine on a file that did not have previous indexes. I have a work around by creating an index on another file then renaming it to the file I need then adding the indexes to it. But thought there may be and explanation from the group that could tell me why and how to make it work correctly. Wasn't there a way to edit the position of the indexes or something of that nature? I can't remember. I have searched the Help to no help. Thanks ahead for the assistance. Mark Waldron City of Salem, Va Email [EMAIL PROTECTED] --- [This E-mail scanned for viruses by Declude Virus] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] SAPUG - Seattle Area Pick Users Group - U2 Meeting Thursday - Dec 8, 2005
Meet fellow U2-Users members in person! Find out the latest U2 developments directly from IBM! Please join SAPUG on December 8, 2005 for our annual Holiday meeting sponsored by IBM and featuring Jackie Burhans and Bill Winter. Even if you don't use one of the U2 products, you will want to hear what this major MulitValue player is doing. Don't forget, this is our Holiday meeting, so in addition to the IBM sponsorship of the networking hour, we will have prizes! For those who might want to stay over Thursday night, the hotel is offering a special rate of $69.00 per night. If you're interested in that option, call the Hotel event manager, John Wessel at (425) 450-4712 and tell him you'd like the SAPUG rate. The Seattle Area Pick Users Group still meets at the... Place that was Small Doubletree Inn, before that was Small Red Lion, etc. Then it was the Ramada Inn and now it is the Paragon but still at 818 112th Ave NE, Bellevue. The meeting costs $30.00 if you register in advance ($35.00 if you just show up). If you come to any part of the meeting, you need to pay since we will be charged whether you eat dinner or not. 3:00 - 5:00: Universe/UniData Integration with other IBM Technologies Bill Winter will conduct the afternoon session on Universe/UniData integration with other IBM technologies such as WebSphere. Bill Winter is a senior IT Specialist focused on the IBM U2 databases and tools. 5:30 - 6:45: Networking 6:45 - 8:00: Dinner 8:00 - 9:00: IBM/U2 Update by Jackie Burhans If you have already responded, Thank you... Otherwise, note the date and times and RSVP today to Connie Eaton [EMAIL PROTECTED] or call her at: (206) 298-0278 (can leave voice mail) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Periodic Reminder
All, Please watch the overquoting. When responding to a question, it would be appreciated if you would trim the quoted version of the previous e-mail, as the individual mails get quite long otherwise. This is even worse for the digest reader, who have to plow through five or six copies of the same mail, quoted in every response. We all appreciate the volume and quality of the responses on the list, we just ask that you trim the quotes. For those who are reading this list via indexfocus, gmane, naggle, or other repackagers, please consider joining the lists. Here's the details on how to join: Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. This will give you access to any and all of the following: U2-Users U2-Community RBSolutions SBSolutions -- - Charles Barouch, Moderator --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Resize
Original Message: Just noticed something strange...I RESIZE to these specs and run HASH.HELP. My response: I have noticed that HASH.HELP is strange like this on UV W2K. You can end up resizing the file over and over and over because the recommendations, including the file type, change as you resize the file. Best bet is to stop after one use of HASH.HELP. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Free Editor
For too many years in the U2 Community, we have been laboring with a single line editor. Whether it was ED or the improved AE we have been pretty much stuck in the 70's and 80's. Others have produced a lot of full-screen editors, but they take a telnet license for every session. We have a solution for those who need to edit from multiple accounts, machines and databases simultaneously in one editor environment. U2Editor works on workstations such as Windows, Linux, Hp-UX, AIX, Solaris, and Mac OS X. U2Editor is built on open source development tool called Eclipse as a plug-in. By using the Eclipse platform for the open source community, U2Editor can be updated automatically or manually via the web using Eclipse Update. Those using U2Editor will always have the most up-to-date copy of the software. U2Editor is available today for downloading at www.u2logic.com. Or send us an email [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Free Editor
I just downloaded the Eclipse software and the U2Editor plug-in. Everything went pretty fair during the installation with a few variances from the installation instructions and the actual options presented. I'm having a problem, though, getting to the Universe programs. The problem seems to be at the point of registering an account. The notes say that the path is not required for Universe but when I try to navigate to the account, I get no listing of directories or hashed files. I can't find a way to change the account registration so I have to delete the whole server registration and start over to try something else. If I DO put in a path, I get directories and files listed but I also get an error message The account name supplied is not a valid account Failed to establish connection to MYSERVER.NAME There are a number of other issues that lead me to believe this is not a ready for release version. It shows a LOT of promise, though. It may just be that the mirror site I used isn't up to the latest release, yet. The ABOUT screen says version 3.1.1, build M20050929-0840. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of D Averch Sent: Thursday, December 01, 2005 12:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Free Editor For too many years in the U2 Community, we have been laboring with a single line editor. Whether it was ED or the improved AE we have been pretty much stuck in the 70's and 80's. Others have produced a lot of full-screen editors, but they take a telnet license for every session. We have a solution for those who need to edit from multiple accounts, machines and databases simultaneously in one editor environment. U2Editor works on workstations such as Windows, Linux, Hp-UX, AIX, Solaris, and Mac OS X. U2Editor is built on open source development tool called Eclipse as a plug-in. By using the Eclipse platform for the open source community, U2Editor can be updated automatically or manually via the web using Eclipse Update. Those using U2Editor will always have the most up-to-date copy of the software. U2Editor is available today for downloading at www.u2logic.com. Or send us an email [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Free Editor
On 12/1/05, Bob Woodward [EMAIL PROTECTED] wrote: snip There are a number of other issues that lead me to believe this is not a ready for release version. It shows a LOT of promise, though. It may just be that the mirror site I used isn't up to the latest release, yet. The ABOUT screen says version 3.1.1, build M20050929-0840. snip I, too, had some problems getting the Eclipse U2Editor plug-in to open using the Linux version. When I try to open the U2Editor perspective, I get a Problems opening perspective 'U2Plugin.perspective' error. The installation seemed to go well and completed successfully without any errors. Any ideas? I do agree though that this tool has lots of potential as a replacement to ED or AE. :) Thanks, Andy -- The Linux philosophy is 'Laugh in the face of danger'. Oops. Wrong One. 'Do it yourself'. Yes, that's it. Linus Torvalds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
To all you UniVerse experts out there. A site I know is moving from UniData on VMS to UniVerse on UNIX. Don't ask why, they just decided that was the path they wanted to go down. Anyhow, they've got used to the ability in UniData to LIST filename ALL and see everything. They're a bit surprised that this doesn't work in UniVerse. Any ideas? Of course we could write them a BASIC program called LIST that scans the command for the keyword ALL and if it finds it, works out what ALL means in the context of that file before invoking the real UniVerse LIST with a modified command, but I'd like to exhaust other options first. Cheers, Ken ALL Syntax ... filename ALL Description The UniQuery ALL keyword displays every data (D-type) attribute defined in the dictionary of filename. ALL does not display virtual (V-type) attributes. Example In the following example, the ALL keyword lists every D-type attribute in the INVENTORY file: :LIST INVENTORY ALL LIST INVENTORY ALL 10:25:34 Mar 25 1999 1 Product Number 15001 Inventory Date 08/20/1995 Inventory Time 01:00PM Product Name Modem Features 14.4K Internal V34 Color Quantity Price Reorder N/A 7486 $119.00 40 Product Number 35000 Inventory Date 07/09/1995 Inventory Time 10:00AM Product Name Speaker Features 250W, Direct/reflecting Color Quantity Price Reorder Black 148 $198.93 50 Charcoal 125 $198.93 50 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Resize
Just write a program that loops until the resize matches the recommendations. See if it goes forever. *:)* -- Louie *Oh, sometimes programmers just want to have fun.* On 12/1/05, Kryka, Richard [EMAIL PROTECTED] wrote: Original Message: Just noticed something strange...I RESIZE to these specs and run HASH.HELP. My response: I have noticed that HASH.HELP is strange like this on UV W2K. You can end up resizing the file over and over and over because the recommendations, including the file type, change as you resize the file. Best bet is to stop after one use of HASH.HELP. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] JDBC and OpenOffice on Linux
Yes, Openqm has been on my mind as well, perhaps a JDBC driver could be developed. Especially with Linux in a thin-client implementation it becomes really feasible to distribute your database and application servers across multiple physical servers. Is there any merit in considering the possibility of starting a U2/OpenOffice interest group Regards Ian Stuart Dave Walker wrote: I've also taken a look at OOo, albeit in the context of supporting openqm as opposed to U2. There's lots of potential there for ANY MV database. I even dug down to see what might be involved in getting openqm recognized as a datasource. At that time, all the database specs were SQL oriented. But if the OpenOffice folks have open minds (sorry, couldn't resist), we'd be smart to jump on this opportunity. My $.02. Headed over there to vote now. Regards, -- Dave Walker Thanks to TV and for the convenience of TV, you can only be one of two kinds of human beings, either a liberal or a conservative. - Kurt Vonnegut -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ian Stuart Sent: Thursday, December 01, 2005 12:53 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] JDBC and OpenOffice on Linux Hi, thanks for that encouragement - BetterBetter will probably be the place to pursue the IBM angle. However Openoffice.org have also proven that they are willing and able to modify OOo specifically for U2 if there are enough requests from users for similar features/fixes - they have already done so in the past. So, the request is still for the U2 community to take 10 minutes each (in total that adds up to a lot of hours) and vote on the Openoffice.org issue. There are many opportunities to take advantage of OOo, not just as an office suite but as an integrated part of U2 applications, especially if you are looking for similar MSOffice functionality/API on Linux/UNIX. Thanks to those who have already voted. Apart from my own vote 5 other U2 users have used 2 of their votes on this issue. Regards Ian Stuart Results wrote: Ian, U2UG has established a committee that is charged with bringing fixes and enhancements to IBM's attention. The Committee, BetterBetter, is currently looking for a new chairman to continue that work. As soon as BB has a new head, it would be the best place for you to push forward with from this angle. - Chuck Ian Stuart wrote: An issue has been reported on the OpenOffice.org Bugzilla system. But to try and give some impetus to resolving this issue I am soliciting the support of this forum to vote on this issue on the OpenOffice.org site as well as to prevail on IBM to cooperate with OpenOffice.org to resolve the issues with JDBC/ODBC and OpenOffice. However, there are still a number of issues to be resolved, including being able to update tables via JDBC ie. although one can create UniVerse tables from within OOo you cannot insert, update or delete; there is a date format problem - see issue 49043, table names have to be aliased in the VOC etc. etc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If
Re: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
Create an @ phrase in the DICT of the file with all the field name. This will also honour any associations. You could also create an @ALL phrase if you already have an @ phrase in the DICT LIST filename @ALL ED DICT CM @ 0001= PH 0002 = COMPANY ADD1 ADD2 ADD3 PCODE PROV ORDER.DATES ORDER.VALUES Alternatively, if no @ phrase exists in the DICT, type REVISE filename and an @ phrase with the first 50 fields will be automatically created in the DICT - at least it does that in INFORMATION and PI/OPEN flavours. Regards Ian Stuart Ken Wallis wrote: To all you UniVerse experts out there. A site I know is moving from UniData on VMS to UniVerse on UNIX. Don't ask why, they just decided that was the path they wanted to go down. Anyhow, they've got used to the ability in UniData to LIST filename ALL and see everything. They're a bit surprised that this doesn't work in UniVerse. Any ideas? Of course we could write them a BASIC program called LIST that scans the command for the keyword ALL and if it finds it, works out what ALL means in the context of that file before invoking the real UniVerse LIST with a modified command, but I'd like to exhaust other options first. Cheers, Ken ALL Syntax ... filename ALL Description The UniQuery ALL keyword displays every data (D-type) attribute defined in the dictionary of filename. ALL does not display virtual (V-type) attributes. Example In the following example, the ALL keyword lists every D-type attribute in the INVENTORY file: :LIST INVENTORY ALL LIST INVENTORY ALL 10:25:34 Mar 25 1999 1 Product Number 15001 Inventory Date 08/20/1995 Inventory Time 01:00PM Product Name Modem Features 14.4K Internal V34 Color Quantity Price Reorder N/A 7486 $119.00 40 Product Number 35000 Inventory Date 07/09/1995 Inventory Time 10:00AM Product Name Speaker Features 250W, Direct/reflecting Color Quantity Price Reorder Black 148 $198.93 50 Charcoal 125 $198.93 50 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
Not for nothing but I've worked on both platforms and I prefer Ud to Uv. My 1 cent - Original Message - From: Ken Wallis [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, December 01, 2005 11:07 PM Subject: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword? To all you UniVerse experts out there. A site I know is moving from UniData on VMS to UniVerse on UNIX. Don't ask why, they just decided that was the path they wanted to go down. Anyhow, they've got used to the ability in UniData to LIST filename ALL and see everything. They're a bit surprised that this doesn't work in UniVerse. Any ideas? Of course we could write them a BASIC program called LIST that scans the command for the keyword ALL and if it finds it, works out what ALL means in the context of that file before invoking the real UniVerse LIST with a modified command, but I'd like to exhaust other options first. Cheers, Ken ALL Syntax ... filename ALL Description The UniQuery ALL keyword displays every data (D-type) attribute defined in the dictionary of filename. ALL does not display virtual (V-type) attributes. Example In the following example, the ALL keyword lists every D-type attribute in the INVENTORY file: :LIST INVENTORY ALL LIST INVENTORY ALL 10:25:34 Mar 25 1999 1 Product Number 15001 Inventory Date 08/20/1995 Inventory Time 01:00PM Product Name Modem Features 14.4K Internal V34 Color Quantity Price Reorder N/A 7486 $119.00 40 Product Number 35000 Inventory Date 07/09/1995 Inventory Time 10:00AM Product Name Speaker Features 250W, Direct/reflecting Color Quantity Price Reorder Black 148 $198.93 50 Charcoal 125 $198.93 50 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
How about just adding a phrase to each DICT called ALL that lists all of the D-type items? eg: DICT CUST.MST ALL 001: PH 002: CUST.NAME CUST.ADDR1 CUST.ADDR2 CUST.CITY ... etc You could even write a simple program to SELECT DICT filename WITH TYPE = 'D' BY LOC, and then loop through create the ALL phrases for that particular file. One time setup, then it's available for their use. Larry Hiscock Western Computer Service -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Thursday, December 01, 2005 8:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword? To all you UniVerse experts out there. A site I know is moving from UniData on VMS to UniVerse on UNIX. Don't ask why, they just decided that was the path they wanted to go down. Anyhow, they've got used to the ability in UniData to LIST filename ALL and see everything. They're a bit surprised that this doesn't work in UniVerse. Any ideas? Of course we could write them a BASIC program called LIST that scans the command for the keyword ALL and if it finds it, works out what ALL means in the context of that file before invoking the real UniVerse LIST with a modified command, but I'd like to exhaust other options first. Cheers, Ken ALL Syntax ... filename ALL Description The UniQuery ALL keyword displays every data (D-type) attribute defined in the dictionary of filename. ALL does not display virtual (V-type) attributes. Example In the following example, the ALL keyword lists every D-type attribute in the INVENTORY file: :LIST INVENTORY ALL LIST INVENTORY ALL 10:25:34 Mar 25 1999 1 Product Number 15001 Inventory Date 08/20/1995 Inventory Time 01:00PM Product Name Modem Features 14.4K Internal V34 Color Quantity Price Reorder N/A 7486 $119.00 40 Product Number 35000 Inventory Date 07/09/1995 Inventory Time 10:00AM Product Name Speaker Features 250W, Direct/reflecting Color Quantity Price Reorder Black 148 $198.93 50 Charcoal 125 $198.93 50 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
An alternative to using Larry's suggestion of writing a program to create a phrase of all the D types, you can use REVISE filename which will automatically create an @REVISE phrase in the dictionary containing all the D-types. You can then just rename @REVISE to ALL. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Friday, 2 December 2005 1:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword? How about just adding a phrase to each DICT called ALL that lists all of the D-type items? eg: DICT CUST.MST ALL 001: PH 002: CUST.NAME CUST.ADDR1 CUST.ADDR2 CUST.CITY ... etc You could even write a simple program to SELECT DICT filename WITH TYPE = 'D' BY LOC, and then loop through create the ALL phrases for that particular file. One time setup, then it's available for their use. Larry Hiscock Western Computer Service DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] is there an equivalent to the UD ALL UniQuery keyword?
Larry Hiscock wrote: How about just adding a phrase to each DICT called ALL that lists all of the D-type items? [snip] One time setup, then it's available for their use. And then they have to maintain it for ever? Or shall I put a trigger on the dictionary of every file that updates the ALL phrase whenever a D item is added or deleted? Thanks Larry, but I think I preferred the BASIC front end to LIST idea better. Cheers, Ken Ken Wallis wrote: A site I know is moving from UniData on VMS to UniVerse on UNIX. Don't ask why, they just decided that was the path they wanted to go down. Anyhow, they've got used to the ability in UniData to LIST filename ALL and see everything. They're a bit surprised that this doesn't work in UniVerse. Any ideas? Of course we could write them a BASIC program called LIST that scans the command for the keyword ALL and if it finds it, works out what ALL means in the context of that file before invoking the real UniVerse LIST with a modified command, but I'd like to exhaust other options first. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
