Re: [U2] insert data
On 30/07/12 00:58, unidata7 wrote: I'm trying to learn UniData and keep coming across 3rd party tools ie RocketSoftware. Can this be done without using a 3rd party tool? I don't know how to insert data to begin. Does the data need to be formatted in a certain way? Firstly, Rocket does not supply 3rd party tools - they are the first party - they own Unidata :-) Secondly, are you thinking like you could do in SQL and create a script? You could create a script and invoke UniData's ED to create the records. Or you could go to a site like pickwiki.com, and look at the sample code there. There are a bunch of load/dump routines that I wrote (and I'm sure others have written some too) that will transfer data between MV systems and csv or fixed-width text files. And PI always came with a data entry system called ENTRO iirc. I think it comes with UV, so it probably comes with UD, but it's well old ... but I always just use ED. If you've got ENTRO, I'd actually think that might be a good starting point! Shout for help by all means, but getting to grips with a new database system - especially a different paradigm of database system - is always tricky. I'll just give you a couple of play tips to get started ... CREATE.FILE MY.PLAY.FILE ENTRO DICT MY.PLAY.FILE ENTRO MY.PLAY.FILE Think up a bunch of columns that you want in your play file (like a SQL table) then use that above to try and enter it. Then play with the following commands to see what the database has actually done ... ED DICT MY.PLAY.FILE columnname ED MY.PLAY.FILE itemname That'll start getting you into understanding the MV database structure - of course it's a lot more complicated, but it's a first step :-) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] OT: A little life humor
Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OT: A little life humor
First, sorry about the breakup (that is, if you are) and second, that is great! I love it. Did you explain that walls were once physical but we could use them metaphorically? Now apparently they are virtual and we cannot. cheers! --dawn On Mon, Jul 30, 2012 at 10:08 AM, George Gallen ggal...@wyanokegroup.com wrote: Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Dawn M. Wolthuis Take and give some delight today ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OT: A little life humor
Sounds like a facebook post unto itself! Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, July 30, 2012 11:09 AM To: U2 Users Subject: [U2] OT: A little life humor Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ 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
Re: [U2] OT: A little life humor
I can't find the Like button for this post... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: July-30-12 8:09 AM To: U2 Users Subject: [U2] OT: A little life humor Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ 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
Re: [U2] OT: A little life humor
I don't think this generation will get the humor Laura Wright -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, July 30, 2012 11:40 AM To: U2 Users List Subject: Re: [U2] OT: A little life humor Sounds like a facebook post unto itself! Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, July 30, 2012 11:09 AM To: U2 Users Subject: [U2] OT: A little life humor Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] MATREAD vs MATPARSE
You don't need to do the matbuild/write, you could simply do a MATWRITE MATRECORD TO F.FILE,KEY Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, July 30, 2012 8:52 AM To: U2-Users@listserver.u2ug.org Subject: [U2] MATREAD vs MATPARSE I'm experimenting with dimension arrays in general and have a question. I have a file with variable length records. To take advantage of the performance of dimension arrays, is this the most effective logic? READ RECORD FROM F.FILE,KEY ELSE ... ATT.CNT = DCOUNT(RECORD,@AM) DIM MATRECORD(ATT.CNT) MATPARSE MATRECORD FROM RECORD,@AM update MATRECORD logic, which there is substantial MATBUILD RECORD FROM MATRECORD USING @AM WRITE RECORD TO F.FILE,KEY Sincerely, David Laansma IT Manager Hubbard Supply Co. ___ 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
Re: [U2] OT: A little life humor
I kinda got the feeling he didn't want it floating on facebook, otherwise, yes, that would be A post for sure! Since some of his friends parents are on my listbut I HIGHLY doubt any Of them are on this list!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, July 30, 2012 11:40 AM To: U2 Users List Subject: Re: [U2] OT: A little life humor Sounds like a facebook post unto itself! Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, July 30, 2012 11:09 AM To: U2 Users Subject: [U2] OT: A little life humor Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OT: A little life humor
Amusing! Trivia question: what did the original handwriting on the wall say? No googling! On Mon, 30 Jul 2012, George Gallen wrote: Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OT: A little life humor
Book of Daniel Chap 5 Mene, Mene, Tekel, Upharsin From: Bob Rasmussen r...@anzio.com To: U2 Users List u2-users@listserver.u2ug.org Date: 07/30/2012 11:04 AM Subject:Re: [U2] OT: A little life humor Sent by:u2-users-boun...@listserver.u2ug.org Amusing! Trivia question: what did the original handwriting on the wall say? No googling! On Mon, 30 Jul 2012, George Gallen wrote: Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users HCSC Company Disclaimer The information contained in this communication is confidential, private, proprietary, or otherwise privileged and is intended only for the use of the addressee. Unauthorized use, disclosure, distribution or copying is strictly prohibited and may be unlawful. If you have received this communication in error, please notify the sender immediately at (312) 653-6000 in Illinois; (800)835-8699 in New Mexico; (918)560-3500 in Oklahoma; or (972)766-6900 in Texas. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OT: A little life humor
Interesting trivia.had to google, temptation was just too great! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Monday, July 30, 2012 12:04 PM To: U2 Users List Subject: Re: [U2] OT: A little life humor Amusing! Trivia question: what did the original handwriting on the wall say? No googling! On Mon, 30 Jul 2012, George Gallen wrote: ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OT: A little life humor
Now that is funny!!! (Not the break up part!) - Original Message - From: George Gallen [mailto:ggal...@wyanokegroup.com] Sent: Monday, July 30, 2012 08:08 AM To: U2 Users u2-users@listserver.u2ug.org Subject: [U2] OT: A little life humor Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ 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
Re: [U2] OT: A little life humor
mene mene tekel upharsin -Original Message- From: Bob Rasmussen r...@anzio.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jul 30, 2012 9:31 am Subject: Re: [U2] OT: A little life humor Amusing! Trivia question: what did the original handwriting on the wall say? No googling! On Mon, 30 Jul 2012, George Gallen wrote: Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ 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
[U2] Downloads
Where on Rocket's site can I get my hands on downloads for VSG and the eclipse-based admin tool? I can't seem to login and find them... -- Jeffrey Butera Associate Director of Information Technology for Applications and Web Services Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Downloads
Jeff: Try: http://www.rocketsoftware.com/u2/resources/downloads HTH, Bill - Original Message - *From:* jbut...@hampshire.edu *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/30/2012 11:02 AM *Subject:* [U2] Downloads Where on Rocket's site can I get my hands on downloads for VSG and the eclipse-based admin tool? I can't seem to login and find them... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Downloads
http://www.rocketsoftware.com/u2/resources/downloads no login required. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, July 30, 2012 12:02 PM To: U2 Users List Subject: [U2] Downloads Where on Rocket's site can I get my hands on downloads for VSG and the eclipse-based admin tool? I can't seem to login and find them... -- Jeffrey Butera Associate Director of Information Technology for Applications and Web Services Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ 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
Re: [U2] Downloads
It's not this? https://www.rocketsoftware.com/u2/products/unidata/resources/manuals/unidata-7.3-documentation/using-vsg-and-the-schema-api/view You don't have to login there's a PDF at the top But my new IE pops under a download message instead of just loading it. You can to click to OPEN or SAVE I can't remember seeing that before this latest version of IE -Original Message- From: Jeffrey Butera jbut...@hampshire.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jul 30, 2012 11:28 am Subject: [U2] Downloads Where on Rocket's site can I get my hands on downloads for VSG and the eclipse-based admin tool? I can't seem to login and find them... -- Jeffrey Butera Associate Director of Information Technology for Applications and Web Services Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ 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
Re: [U2] Downloads
On 07/30/2012 02:32 PM, Wally Terhune wrote: http://www.rocketsoftware.com/u2/resources/downloads no login required. Thanks Wally. Is VSG under dbtools or something else (I can't seem to locate it)? -- Jeffrey Butera Associate Director of Information Technology for Applications and Web Services Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Downloads
Visual Schema Generator is on the U2 Clients CD image (NOV 2011 - on the download link) Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Monday, July 30, 2012 1:02 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Downloads On 07/30/2012 02:32 PM, Wally Terhune wrote: http://www.rocketsoftware.com/u2/resources/downloads no login required. Thanks Wally. Is VSG under dbtools or something else (I can't seem to locate it)? -- Jeffrey Butera Associate Director of Information Technology for Applications and Web Services Hampshire College 413-559-5556 http://www.hampshire.edu http://www.facebook.com/hampshirecollegeit ___ 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
Re: [U2] MATREAD vs MATPARSE
On 30/07/12 16:57, Larry Hiscock wrote: You don't need to do the matbuild/write, you could simply do a MATWRITE MATRECORD TO F.FILE,KEY Plus, do you know how many attributes you are going to access when updating? If you know before you read it the highest number attribute you are going to access, then just dimension the array BEFOREHAND and do a MATREAD. You're clearly using a PI or IDEAL account, so it'll stuff any excess attributes in (0), and put them back at the end. Your subject line implies you're aware of this. I'd guess the READ/MATPARSE combination is bound to be slower than a straight MATREAD, if only because you're ignoring the dedicated statement provided for you. Cheers, Wol Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, July 30, 2012 8:52 AM To: U2-Users@listserver.u2ug.org Subject: [U2] MATREAD vs MATPARSE I'm experimenting with dimension arrays in general and have a question. I have a file with variable length records. To take advantage of the performance of dimension arrays, is this the most effective logic? READ RECORD FROM F.FILE,KEY ELSE ... ATT.CNT = DCOUNT(RECORD,@AM) DIM MATRECORD(ATT.CNT) MATPARSE MATRECORD FROM RECORD,@AM update MATRECORD logic, which there is substantial MATBUILD RECORD FROM MATRECORD USING @AM WRITE RECORD TO F.FILE,KEY Sincerely, David Laansma IT Manager Hubbard Supply Co. ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users