I have some heartburn with the words "optional" and "purely" below. To me, it is like saying that Daniel Webster was just a door-to-door encyclopedia salesman.
U2 data dictionaries are key tool. Why would someone climb on to a Rocket... to explore the UniVerse... without a map... of the data? --Bill -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Monday, July 15, 2013 8:40 PM To: U2 Users List Subject: Re: [U2] UML mapping tool for MV (UniVerse) Regardless of the toolset, the first hurdle would be to normalise your database to look like a relational one. Which is likely to be the greatest hurdle. Data dictionaries in U2/PICK are optional are a purely for reporting purposes - they can have duplicates and these can be conflicting. Even worse (as if you thought it could be) - data dictionaries can be incomplete or wrong. This added to the lack of enforcement of data integrity and constraints usually causes these toolsets to fail (indeed, even the UV/ODBC driver fails too!)... so good luck! Rocket released U2 Metadata Manager to assist in this respect and is designed to allow forward and backwards capability. Although, support for this in UV is limited to the latest official release... so your alternative is UV/ODBC... For UV/ODBC users - I have always recommended a separate UV account and data dictionary that is spotless. For some this is the best option - why go against the flow - when you create your own stream... -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lynette LeDoux Sent: Tuesday, 16 July 2013 5:45 AM To: u2-users@listserver.u2ug.org Subject: [U2] UML mapping tool for MV (UniVerse) Hello all. The call has come to locate possible data modelling tools (UML) that could potentially would connect to our UniVerse system. Ideas? L2 (Lynette LeDoux) -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2-users-requ...@listserver.u2ug.org Sent: Monday, July 15, 2013 2:00 PM To: u2-users@listserver.u2ug.org Subject: U2-Users Digest, Vol 51, Issue 13 Send U2-Users mailing list submissions to u2-users@listserver.u2ug.org To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to u2-users-requ...@listserver.u2ug.org You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org When replying, please edit your Subject line so it is more specific than "Re: Contents of U2-Users digest..." Today's Topics: 1. Re: Mobile phones (Symeon Breen) 2. Re: [ANN] FOSS4MV - Free & Open Source Software for the MVDB world (Daniel McGrath) 3. SORT reports line length, change right margin? (randyleesmith) 4. Re: SORT reports line length, change right margin? (Anthonys Lists) 5. Re: SORT reports line length, change right margin? (Don Robinson) 6. Re: Mobile phones (Bill Haskett) 7. Re: SORT reports line length, change right margin? (randyleesmith) 8. Re: SORT reports line length, change right margin? (Bill Haskett) 9. Re: SORT reports line length, change right margin? (Wols Lists) 10. Re: SORT reports line length, change right margin? (randyleesmith) 11. Re: SORT reports line length, change right margin? (Wols Lists) 12. Re: SORT reports line length, change right margin? (randyleesmith) 13. Re: SORT reports line length, change right margin? (Wols Lists) ---------------------------------------------------------------------- Message: 1 Date: Mon, 15 Jul 2013 13:20:14 +0100 From: "Symeon Breen" <syme...@gmail.com> To: "'U2 Users List'" <u2-users@listserver.u2ug.org> Subject: Re: [U2] Mobile phones Message-ID: <004d01ce8155$a9f67e30$fde37a90$@gmail.com> Content-Type: text/plain; charset="us-ascii" Thanks everyone for your information. ------------------------------ Message: 2 Date: Mon, 15 Jul 2013 14:25:42 +0000 From: Daniel McGrath <dmcgr...@rocketsoftware.com> To: U2 Users List <u2-users@listserver.u2ug.org> Subject: Re: [U2] [ANN] FOSS4MV - Free & Open Source Software for the MVDB world Message-ID: <61ef3a8534e14d709dffdc5bd2f27...@den-vm-mbx3.rocketsoftware.com> Content-Type: text/plain; charset="iso-8859-1" Thanks Tony & Kevin! Unhappy to see we both ended up on different platforms (GitHub & BitBucket) which means people would need to learn 2 different sites, but ecstatic to see we both ended up using Git which means people really only need to learn 1 tool chain to be able to work with both. Cheers, Dan McGrath Managing Director, U2 Servers Lab Rocket Software 4600 South Ulster Street? ?? Suite 1100? ??? Denver, CO 80237 ?? USA T: +1 720 475 8098 ? E: dmcgr...@rocketsoftware.com ? W: u2.rocketsoftware.com -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Saturday, July 13, 2013 5:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] [ANN] FOSS4MV - Free & Open Source Software for the MVDB world Posted for Kevin Powick =================================== Fellow developers, I'm happy to announce a new resource for MVDB developers. FOSS4MV! FOSS4MV is a community for people that use or develop Free and Open Source Software for MVDB platforms, such as D3, OpenQM, jBASE, U2, Reality, Cache, etc. As such, it has three major offerings to promote communication and collaboration. A Google+ Community, source code repositories at Bitbucket, and a Twitter account to keep you in-the-loop. Google+ is a surprisingly useful communications platform that makes it easy to share information with individuals, groups, or the public at large. Some G+ communities have memberships that number in the tens of thousands, and I know that many MV developers already have a G+ account. Bitbucket, from Atlassian, is a leading provider of source code repository hosting using today's two leading source code control platforms, Git and Mercurial (Hg). Not only does Bitbucket support the top two SCC platforms, but they also allow unlimited, free public and private** repositories. FOSS4MV is set up as a bitbucket "Team" allowing people to join the team and create repositories under the FOSS4MV banner, while still retaining complete control over the management of their repositories. However, there is no requirement to join the FOSS4MV team account to get your code on the site. If you're just looking for a good home to share your code, but do not wish to manage a repository, let us know via email (foss...@gmail.com) and we'll post it for you. Twitter Is a great way to keep-up with what's going on with individuals, companies and communities such as FOSS4MV. You don't actually have to tweet to follow a Twitter account, so if you're not already "on Twitter", sign-up and subscribe to FOSS4MV to keep an eye on what's happening. The traffic should be fairly low volume. == Final Remarks == Promoting software development and collaboration amongst MV developers is not a new idea but, until fairly recently, a standard set of tools for building communities wasn't readily available. Today, we have powerful and widely accepted tools that make collaboration not only easier, but enjoyable. Participation grows communities, and every little bit helps. With all the knowledge that we have amongst the veterans with 20 to 30+ years of MV experience, I'm sure we can build something useful to all MV developers, both old and new. So, at the very least, if you have any tips, tricks, or code that you wish to share, join the G+ community, get on the FOSS4MV Bitbucket team, or just send us your code and we will give it a good home. == Links == G+ Community: http://goo.gl/aLfKV Source Code: https://bitbucket.org/foss4mv Twitter: https://twitter.com/foss4mv Email: foss...@gmail.com Regards, Kevin Powick ** Private, free repositories are limited to 5 members. Once a private repository exceeds 5 members, you require a paid account. The nature of FOSS4MV makes this a moot point as its repositories will be public by default. _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 3 Date: Mon, 15 Jul 2013 07:32:55 -0700 (PDT) From: randyleesmith <randyleesm...@roadrunner.com> To: u2-users@listserver.u2ug.org Subject: [U2] SORT reports line length, change right margin? Message-ID: <1373898775662-41205.p...@n5.nabble.com> Content-Type: text/plain; charset=us-ascii It's been a while, nice to be back and working again. :) I'm on a Universe Database; I have a proc full of SORT reports. I needed to add new fields, but the size of the line is too small. I'm already using landscape mode and don't have enough space. I have been testing with PCL, but I was wondering if I could just make the line longer. Seems to be enough room if I could adjust the right margin. MARGIN /n/ only changes the left margin. I never had to deal much with SORT reports in the past, so I though you Guru's could help. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-length-ch ange-right-margin-tp41205.html Sent from the U2 - Users mailing list archive at Nabble.com. ------------------------------ Message: 4 Date: Mon, 15 Jul 2013 16:52:13 +0100 From: Anthonys Lists <antli...@youngman.org.uk> To: u2-users@listserver.u2ug.org Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <51e41aad.6070...@youngman.org.uk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed On 15/07/2013 15:32, randyleesmith wrote: > It's been a while, nice to be back and working again. :) > > > I'm on a Universe Database; > > I have a proc full of SORT reports. Bear in mind SORT and LIST are pretty much the same thing ... > > I needed to add new fields, but the size of the line is too small. I'm > already using landscape mode and don't have enough space. > > I have been testing with PCL, but I was wondering if I could just make > the line longer. Seems to be enough room if I could adjust the right margin. Could you shrink any field widths? Are there any text fields which often have wasted space? You can use the FORMAT or FMT (not sure which) modifier to adjust the field width just for that report rather than messing around cluttering up the dictionary. > > MARGIN /n/ only changes the left margin. What margins have been set in SETPTR? I can't remember whether the default is 0 or 3 (both left and right). > > I never had to deal much with SORT reports in the past, so I though > you Guru's could help. > > Cheers, Wol ------------------------------ Message: 5 Date: Mon, 15 Jul 2013 09:09:59 -0700 (PDT) From: Don Robinson <donr_w...@yahoo.com> To: U2 Users List <u2-users@listserver.u2ug.org> Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <1373904599.79580.yahoomail...@web120202.mail.ne1.yahoo.com> Content-Type: text/plain; charset=iso-8859-1 Randy, ? SETPTR can be used to set the line length/page width. ? SETPTR ,145,,,,,NODEFAULT,BRIEF ? Should set it to 145 characters. NODEFAULT says?do not changes anything else and BRIEF suppresses the "OK to set...." prompt. At the end you could/should reset it to 132. Of course, in a proc, put an H before SETPTR and a P on the next line. Good luck, Don Robinson ________________________________ From: Anthonys Lists <antli...@youngman.org.uk> To: u2-users@listserver.u2ug.org Sent: Monday, July 15, 2013 11:52 AM Subject: Re: [U2] SORT reports line length, change right margin? On 15/07/2013 15:32, randyleesmith wrote: > It's been a while, nice to be back and working again. :) > > > I'm on a Universe Database; >? > I have a proc full of SORT reports. Bear in mind SORT and LIST are pretty much the same thing ... > > I needed to add new fields, but the size of the line is too small. I'm > already using landscape mode and don't have enough space. > > I have been testing with PCL, but I was wondering if I could just make > the line longer. Seems to be enough room if I could adjust the right margin. Could you shrink any field widths? Are there any text fields which often have wasted space? You can use the FORMAT or FMT (not sure which) modifier to adjust the field width just for that report rather than messing around cluttering up the dictionary. > > MARGIN /n/ only changes the left margin. What margins have been set in SETPTR? I can't remember whether the default is 0 or 3 (both left and right). > > I never had to deal much with SORT reports in the past, so I though > you Guru's could help. > > Cheers, Wol _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 6 Date: Mon, 15 Jul 2013 09:09:48 -0700 From: Bill Haskett <wphask...@advantos.net> To: U2 Users List <u2-users@listserver.u2ug.org> Subject: Re: [U2] Mobile phones Message-ID: <51e41ecc.4070...@advantos.net> Content-Type: text/plain; charset=UTF-8; format=flowed Did it help, and what did you decide to do? :-) Bill ------------------------------------------------------------------------ ----- Original Message ----- *From:* syme...@gmail.com *To:* 'U2 Users List' <u2-users@listserver.u2ug.org> *Date:* 7/15/2013 5:20 AM *Subject:* Re: [U2] Mobile phones > Thanks everyone for your information. > > ------------------------------ Message: 7 Date: Mon, 15 Jul 2013 09:12:37 -0700 (PDT) From: randyleesmith <randyleesm...@roadrunner.com> To: u2-users@listserver.u2ug.org Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <1373904757298-41209.p...@n5.nabble.com> Content-Type: text/plain; charset=us-ascii I've tried to get the ok for moving items over, but it effected the headers too. I guess the customer didn't go for it. (I have a Customer Rep I work with.) The SORT did not like making PCL changes. It just ignored them. I'm sure its because of the default settings on the system. You can set MARGIN in the SORT command itself, but only the left. I set it to 0 and it printed way over to the left, but did not add any line length. Since there is more spacing on the page I thought I might be able to take advantage of it. SETPTR might be worth looking into as long as I can set it back. In the mean time I've been able to make changes with PCL and get everything to fit nicely, but I had to code the output in order to do so. It's simple enough to code so I might go with this unless I can find an easy way to do a similar thing with the SORT statement. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-length-ch ange-right-margin-tp41205p41209.html Sent from the U2 - Users mailing list archive at Nabble.com. ------------------------------ Message: 8 Date: Mon, 15 Jul 2013 09:18:19 -0700 From: Bill Haskett <wphask...@advantos.net> To: U2 Users List <u2-users@listserver.u2ug.org> Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <51e420cb.6050...@advantos.net> Content-Type: text/plain; charset=UTF-8; format=flowed The simplest solution is to change the print width in UV then alter the CPI in PCL. You may not have to alter the print width in UV if the original developer was prescient enough to plan for expansion. e.g. ^027E^027&l1e64F^027&a0l85M^027(s0p16.67h0s3b##DEFFONTNO##T ...where ##DEFFONTNO### is just a tag that is substituted by the actual font ID# at runtime. HTH, Bill ------------------------------------------------------------------------ ----- Original Message ----- *From:* randyleesm...@roadrunner.com *To:* u2-users@listserver.u2ug.org *Date:* 7/15/2013 7:32 AM *Subject:* [U2] SORT reports line length, change right margin? > It's been a while, nice to be back and working again. :) > > > I'm on a Universe Database; > > I have a proc full of SORT reports. > > I needed to add new fields, but the size of the line is too small. I'm > already using landscape mode and don't have enough space. > > I have been testing with PCL, but I was wondering if I could just make > the line longer. Seems to be enough room if I could adjust the right margin. > > MARGIN /n/ only changes the left margin. > > I never had to deal much with SORT reports in the past, so I though > you Guru's could help. > > > > -- > View this message in context: > http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-len > gth-change-right-margin-tp41205.html > Sent from the U2 - Users mailing list archive at Nabble.com. > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 9 Date: Mon, 15 Jul 2013 17:50:11 +0100 From: Wols Lists <antli...@youngman.org.uk> To: u2-users@listserver.u2ug.org Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <51e42843.90...@youngman.org.uk> Content-Type: text/plain; charset=ISO-8859-1 On 15/07/13 17:12, randyleesmith wrote: > SETPTR might be worth looking into as long as I can set it back. Investigate using a different channel ... I mentioned it recently but try SETPTR 1,... followed by SORT ... LPTR 1 That way, you don't touch whatever's on the user's default channel 0, and can muck about as much as you like without (in all likelihood) trampling over the settings for something else. I use that as a matter of course when I don't want to accidentally mess up something I don't know about. Cheers, Wol ------------------------------ Message: 10 Date: Mon, 15 Jul 2013 10:15:12 -0700 (PDT) From: randyleesmith <randyleesm...@roadrunner.com> To: u2-users@listserver.u2ug.org Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <1373908512856-41212.p...@n5.nabble.com> Content-Type: text/plain; charset=us-ascii You all have given me a lot to work with. Thank you. I forgot to mentioned that the report I'm changing is part of a number of other similar reports. They all need to be together in the same printer spool. They are printed together as one big report. Since I don't know, or remember, much about SETPTR I'm not sure if there is a way to keep everything in the same spooler. It looks like I need to make CIP and LPI changes too. I'll need to look up all the parameters for SETPTR. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-length-ch ange-right-margin-tp41205p41212.html Sent from the U2 - Users mailing list archive at Nabble.com. ------------------------------ Message: 11 Date: Mon, 15 Jul 2013 18:33:01 +0100 From: Wols Lists <antli...@youngman.org.uk> To: u2-users@listserver.u2ug.org Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <51e4324d.1000...@youngman.org.uk> Content-Type: text/plain; charset=ISO-8859-1 On 15/07/13 18:15, randyleesmith wrote: > You all have given me a lot to work with. Thank you. > > I forgot to mentioned that the report I'm changing is part of a number > of other similar reports. > > They all need to be together in the same printer spool. They are > printed together as one big report. > > Since I don't know, or remember, much about SETPTR I'm not sure if > there is a way to keep everything in the same spooler. > Ummm. If it's part of a bunch of reports, then changing the channel might well mess things up. I don't think it will if they're just run sequentially, though. > It looks like I need to make CIP and LPI changes too. > > I'll need to look up all the parameters for SETPTR. > I think there are options for holding a print channel open, so you can send several reports, then do a close and they all go to the OS spooler as a single job. I don't think that's what you want here. (off-topic - another useful trick for multiple channels is the summary report - okay you really need a BASIC program for this - but I've had a program print several independent reports, saving some data for each and dumping this to a separate channel, which finally gets closed and printed as a separate report. I've seen programmers print the individual reports, then go back and repeat the calculations to print the summary! That or store the data in some complex data structure ...) Cheers, Wol ------------------------------ Message: 12 Date: Mon, 15 Jul 2013 10:50:32 -0700 (PDT) From: randyleesmith <randyleesm...@roadrunner.com> To: u2-users@listserver.u2ug.org Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <1373910632580-41214.p...@n5.nabble.com> Content-Type: text/plain; charset=us-ascii There is a SP-ASSIGN OHS At the start of the Proc And a SP-ASSIGN At the end. All the report are meant to be held together. I really did miss this, even if you don't get the answer you wanted to your question, you sometimes get some great insight to the U2 environment. Knowledge that can be used somewhere else later. Or sometimes you get the "How to do it a better,other way". Thanks Wols for the off topic info. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/SORT-reports-line-length-ch ange-right-margin-tp41205p41214.html Sent from the U2 - Users mailing list archive at Nabble.com. ------------------------------ Message: 13 Date: Mon, 15 Jul 2013 19:11:12 +0100 From: Wols Lists <antli...@youngman.org.uk> To: u2-users@listserver.u2ug.org Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <51e43b40.7060...@youngman.org.uk> Content-Type: text/plain; charset=ISO-8859-1 On 15/07/13 18:50, randyleesmith wrote: > There is a > > SP-ASSIGN OHS > > At the start of the Proc > > And a > > SP-ASSIGN > > At the end. > > All the report are meant to be held together. In which case (If I remember my SP-ASSIGN correctly) changing this one report to a different print channel most definitely will bugger it up... That code does hold the print channel open, so all the Pick reports get lumped into one single OS level job. Using different channels will give different jobs end of. > > > I really did miss this, even if you don't get the answer you wanted to > your question, you sometimes get some great insight to the U2 environment. > Knowledge that can be used somewhere else later. Or sometimes you get > the "How to do it a better,other way". > > Thanks Wols for the off topic info. > Cheers, Wol ------------------------------ _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users End of U2-Users Digest, Vol 51, Issue 13 **************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
