But with programmers able to create new DICT entries as they will, how do you *keep* it spotless?
-----Original Message----- From: Hona, David <[email protected]> To: U2 Users List <[email protected]> Sent: Mon, Jul 15, 2013 5:40 pm 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: [email protected] [mailto:[email protected]] On Behalf Of Lynette LeDoux Sent: Tuesday, 16 July 2013 5:45 AM To: [email protected] 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: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, July 15, 2013 2:00 PM To: [email protected] Subject: U2-Users Digest, Vol 51, Issue 13 Send U2-Users mailing list submissions to [email protected] 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 [email protected] You can reach the person managing the list at [email protected] 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" <[email protected]> To: "'U2 Users List'" <[email protected]> Subject: Re: [U2] Mobile phones Message-ID: <[email protected]> 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 <[email protected]> To: U2 Users List <[email protected]> Subject: Re: [U2] [ANN] FOSS4MV - Free & Open Source Software for the MVDB world Message-ID: <[email protected]> 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: [email protected] ? W: u2.rocketsoftware.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tony Gravagno Sent: Saturday, July 13, 2013 5:47 PM To: [email protected] 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 ([email protected]) 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: [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 3 Date: Mon, 15 Jul 2013 07:32:55 -0700 (PDT) From: randyleesmith <[email protected]> To: [email protected] Subject: [U2] SORT reports line length, change right margin? Message-ID: <[email protected]> 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-change-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 <[email protected]> To: [email protected] Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <[email protected]> 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 <[email protected]> To: U2 Users List <[email protected]> Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <[email protected]> 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 <[email protected]> To: [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 6 Date: Mon, 15 Jul 2013 09:09:48 -0700 From: Bill Haskett <[email protected]> To: U2 Users List <[email protected]> Subject: Re: [U2] Mobile phones Message-ID: <[email protected]> Content-Type: text/plain; charset=UTF-8; format=flowed Did it help, and what did you decide to do? :-) Bill ------------------------------------------------------------------------ ----- Original Message ----- *From:* [email protected] *To:* 'U2 Users List' <[email protected]> *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 <[email protected]> To: [email protected] Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <[email protected]> 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-change-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 <[email protected]> To: U2 Users List <[email protected]> Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <[email protected]> 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:* [email protected] *To:* [email protected] *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 > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 9 Date: Mon, 15 Jul 2013 17:50:11 +0100 From: Wols Lists <[email protected]> To: [email protected] Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <[email protected]> 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 <[email protected]> To: [email protected] Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <[email protected]> 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-change-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 <[email protected]> To: [email protected] Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <[email protected]> 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 <[email protected]> To: [email protected] Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <[email protected]> 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-change-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 <[email protected]> To: [email protected] Subject: Re: [U2] SORT reports line length, change right margin? Message-ID: <[email protected]> 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users End of U2-Users Digest, Vol 51, Issue 13 **************************************** _______________________________________________ U2-Users mailing list [email protected] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
