Re: [U2] RE: XML Issue
I use PREPAREXML and OPENXMLDATA on Unidata and have some UTF-8 and some ISO-8859-1 encoded XML files and they all work fine. Are you on NT or *nix ? On 1/27/06, Andy Pflueger [EMAIL PROTECTED] wrote: This resp header works: ?xml version=1.0 encoding=UTF-8? The resp header from this URL doesn't work: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? Could the problem be the difference of the type of encoding used in the first resp header versus the second? Does your system which UniVerse is running on support ISO-8859-1 character set? Just a thought... --- 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] capturing problem
Universe 10.1.6 running PICK.FORMAT. We still get this type of entry in the errlog: Jan 30 10:22:55 SPOOL.NUM: 17 Unable to create RedBack capture file. The EXECUTE item CAPTURING CAP.FIELD SETTING SETFIELD does not seem to find a problem, and therefore does not set the SETTING SETFIELD to a value less than zero. In addition, the CAP.FIELD becomes undefined as a result of the failed CAPTURING. This problem ALMOST solely occurs for user RedBack. However, it has occurred very infrequently when a field 4 security program for the RUN verb is executed. Apologies if this is a re-hash, but I was unable to recall if any resolution was found. -- john -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: XML Issue
I use PREPAREXML and OPENXMLDATA on Unidata and have some UTF-8 and some ISO-8859-1 encoded XML files and they all work fine. FYI ISO-8859-1 is the old standard which is now no longer developed as they have moved to UTF-8/16, but it should still work fine... Are you on NT or *nix ? On 1/27/06, Andy Pflueger [EMAIL PROTECTED] wrote: This resp header works: ?xml version=1.0 encoding=UTF-8? The resp header from this URL doesn't work: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? Could the problem be the difference of the type of encoding used in the first resp header versus the second? Does your system which UniVerse is running on support ISO-8859-1 character set? Just a thought... --- 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] Uv - Conversation from UltPlus
Tom Dodds said... Subject: Hi it's me again. We are still doing a conversion from an UltPlus to UniVerse. We have run across a user exit that I am not familiar with. U11AD is the culprit. Is anyone familiar with this exit and if so does anyone have a basic subroutine to emulate it's processes? Thanks in advance for the help. Tom Dodds --- Well, Tom... can't give you any code to handle this but this is the definition straight from my trusty JES(J.E. Sisk) - Pick Pocket Guide (well, as retyped by me... hopefully without any significant errors!). Bits in [] added by me to no great effect. quote U11AD Retrieves multiple values from an attribute of an item in a file. See U01AD for format. U01AD Retrieves a value from an attribute of an item in a file. Format: U01AD Filename itemname amcexp output-code Error-return line (continuation of PROC) Output Codes: A Outputs to alternate output buffer P Outputs to primary input buffer S Outputs to current output buffer T Outputs to terminal V Verifies that file exists. No output VA Verifies Non-null attribute Note: this function allows for indirect references to values from the input and output buffers by using the following special symbols. % Current Input buffer value # Current Output buffer value Example of Direct Reference PQ U01AD CONTROL-FILE CO.NAME 1 S XCant find CO.NAME or CONTROL-FILE [...continuation] This reads attribute 1 of the item called CO.NAME in the file called CONTROL-FILE and places it in the current output buffer. Example of Indirect Reference PQ U01AD %2 %3 %4 P Xsomething went wrong D0 [---that's Dzero - shows contents of whole buffer] This reads the attribute number as defined in the fourth location of the input buffer, using the item id from the third location and the file name from the second location. /quote Hope that helps in some way (and now that they see it, others may have go-arounds...)? Cheers Gary Gowans --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Uv - Conversation from UltPlus
To quote my Ultimate Pocket Guide, Version I (Was there a version II?): U11AD Retrieves multiple values from an attribute of an item in a file. See U01AD for format. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: XML Issue
When I replace 'ISO-8859-1 standalone = yes' with 'UTF-8' then I get a mostly successful download of the xml document. There is a problem with a line return in my file after parsing thru the XDOM. Is there something I can do with a map to resolve this? It downloads in a garbled way with the 'ISO-8859-1 standalone = yes' and won't parse at all Yet to look at at it with a browser it is a valid xml document. Sent: Friday, January 27, 2006 9:07 AM Subject: RE: XML Issue This resp header works: ?xml version=1.0 encoding=UTF-8? The resp header from the new URL doesn't work: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? I tried to look up what standalone means - but didn't really get it. I wondered if it meant it wasn't using mapping? Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV910 - IBM UniVerse Theory and Practice - US course scheduled
Folks: Based on a recent thread about UniVerse 'internals' class availability - I researched. The class is now named 'UniVerse Theory and Practice'. It has recently been added to the IBM US class schedule. June 6-9 in Denver. Wally Terhune Manager - U2 Advanced Client Support IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Active Select list with UniXML
Hello all Haven't had any response on this question. But I sent it out late on Friday afternoon so maybe missed it being seen by some one who know the answer. So I'm resending it now. Hopefully there will be some one who can shed some light on the topic, even if it's just to say nope, you can't do it. Does any one know of a way to use a select list with the UniXML class in UniObjects .Net? We have been using UniObjects.Net to retrieve data from UniData 7.1 using the UniXML class. A typical query would be something like... UniXML xml = Session.CreateUniXML(); xml.GenerateXML(list FileName with selection_criteria fieldName fieldName TOXML); Overall this has been working out very well. What I would like to be able to figure out is how to use this list command with an active select list. Has any one done this? (Am I missing something obvious?) thanks Victor St. Clair Jenkon Vancouver, WA 360.256.4400 [EMAIL PROTECTED] www.jenkon.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV910 - IBM UniVerse Theory and Practice - US course scheduled
Based on a recent thread about UniVerse 'internals' class availability - I researched. The class is now named 'UniVerse Theory and Practice'. It has recently been added to the IBM US class schedule. June 6-9 in Denver. ... and unfortunately the UK one got cancelled again due to lack of interest. 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] Newbies need love too
We are looking extremely hard at moving our company to an MRP/DM vertical solution written to run on the UniVerse platform. Our internal staff has dozens of years experience with filePro, mySQL, PHP, perl... yet we have no experience among the four of us working with UniVerse or any MultiValued/Pick DBMS. The whole concept doesn't scare us since it appears to be a mashing together of a lot of concepts that we already are familiar with. HOWEVER. What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. I have installed the personal editions and have the server running, but I have no clue as to really creating a database, defining a table, inserting data into a record, retrieving data from a record, and applying business logic to fields. Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. Thanks, Walter Vaughan Vice President Steele Rubber Products, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies need love too
Gee, I dunno...I learned it 20 years ago... snicker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Walter Vaughan Sent: Tuesday, January 31, 2006 14:34 To: u2-users@listserver.u2ug.org Subject: [U2] Newbies need love too We are looking extremely hard at moving our company to an MRP/DM vertical solution written to run on the UniVerse platform. Our internal staff has dozens of years experience with filePro, mySQL, PHP, perl... yet we have no experience among the four of us working with UniVerse or any MultiValued/Pick DBMS. The whole concept doesn't scare us since it appears to be a mashing together of a lot of concepts that we already are familiar with. HOWEVER. What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. I have installed the personal editions and have the server running, but I have no clue as to really creating a database, defining a table, inserting data into a record, retrieving data from a record, and applying business logic to fields. Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. Thanks, Walter Vaughan Vice President Steele Rubber Products, Inc. --- 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] RE: XML Issue
My email is currently blocking list mail for SOME reason... I just read your answer in the new feed at the website. Perhaps the standalone = yes is the issue? We are on Windows circa 2003... thanks, Nancy From: Symeon Breen symeonb at gmail.com Subject: Re: [U2] RE: XML Issue Newsgroups: gmane.comp.db.u2.general Date: 2006-01-31 11:04:23 GMT (11 hours and 58 minutes ago) I use PREPAREXML and OPENXMLDATA on Unidata and have some UTF-8 and some ISO-8859-1 encoded XML files and they all work fine. FYI ISO-8859-1 is the old standard which is now no longer developed as they have moved to UTF-8/16, but it should still work fine... Are you on NT or *nix ? On 1/27/06, Andy Pflueger andypflueger at gmail.com wrote: This resp header works: ?xml version=1.0 encoding=UTF-8? The resp header from this URL doesn't work: ?xml version=1.0 encoding=ISO-8859-1 standalone=yes? Could the problem be the difference of the type of encoding used in the first resp header versus the second? Does your system which UniVerse is running on support ISO-8859-1 character set? Just a thought... Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies need love too
Walter Team, I'm sure you're going to get flooded with posts now, because there is quite a lot of passion about the Multi-value database model, and you'll find this community extremely helpful. I am so glad y'all are considering an MV based app. Installing PE UV was an excellent start. For your staff to look around and start creating some files [read Tables] you ought to buy a copy of How To Access, by Harvey Rodstein. Talk to Monica at International Spectrum and she will send you the electronic version, just released. http://www.intl-spectrum.com Here is a link to some on-line publications: http://www.jes.com/olbooks.html Especially helpful to your programmers would be Jonathan Sisk's Programmer's Guide. This would be your starting point to understand the UV-Basic language, and how to play with multi-values (nested tables in Oracle [8 or later] lingo). If you want to see a pretty exhaustive list of all books ever written on the subject, go to: http://www.jes.com/picklist.html This list has not been updated in recent years, I don't think, so there may be additions. The best news about your initial steps, is that whatever you learn from Harv's book, or commands you pick up by even gleaning non-UniVerse publications - will work on UV. There are many nuances of the various 'flavors' of the MV db model, but only worry about that when you get alot deeper. Only when your programmers get seasoned and begin to leverage the UV nuances do you need to worry with that. If you can navigate one MV database, you can navigate them all. If you want to see something about the [sometimes spicey] history of the MV model, go to: http://www.tincat-group.com/mv/familytree.html BTW - [in somewhat hushed tone] this all started as something called Pick but everyone around here prefers to speak of either Multi-value industry or the U2 (standing for UniData and UniVerse, both now owned by IBM but have divergent genealogy). Pick is now D3 and well let some other folks check in now. Hope you have fun. MV is a blast. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. Walter Vaughan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies need love too
Try the IBM knowledgebase Sorry I couldn't resist ;-) Walter, you could try http://u2ug.org as a good place to start, there are quite a few knowledgeable people on this list as you may or may not know and people are generally willing to help. I assume as you are buying a package, that you will not have to define a table, insert a record, etc. The main thing you may want to do is to be able to explore the data in the application database and possibly display is using a web browser or the like. There are a couple of people on this list who could probably point you in the UV technologies to accomplish this. Good luck, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter Vaughan Sent: Wednesday, 1 February 2006 12:01 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] Newbies need love too We are looking extremely hard at moving our company to an MRP/DM vertical solution written to run on the UniVerse platform. Our internal staff has dozens of years experience with filePro, mySQL, PHP, perl... yet we have no experience among the four of us working with UniVerse or any MultiValued/Pick DBMS. The whole concept doesn't scare us since it appears to be a mashing together of a lot of concepts that we already are familiar with. HOWEVER. What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. I have installed the personal editions and have the server running, but I have no clue as to really creating a database, defining a table, inserting data into a record, retrieving data from a record, and applying business logic to fields. Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. Thanks, Walter Vaughan Vice President Steele Rubber Products, Inc. --- 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] Newbies need love too
On 1/31/06, Walter Vaughan [EMAIL PROTECTED] wrote: Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. I'm not aware of any introductory material... you just have to dive in. :) Have them install the Personal Edition on their development workstations, then go through the library of PDFs. * http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trials * http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_101.html It goes without saying that they should be subscribed to u2-users! -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies need love too
Try jes.com for Jonathan Sisk's books. Our newbies have used that book and others as a reference for learning. Both came from RPG programming to UniVerse. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter Vaughan Sent: Tuesday, January 31, 2006 4:34 PM To: u2-users@listserver.u2ug.org Subject: [U2] Newbies need love too We are looking extremely hard at moving our company to an MRP/DM vertical solution written to run on the UniVerse platform. Our internal staff has dozens of years experience with filePro, mySQL, PHP, perl... yet we have no experience among the four of us working with UniVerse or any MultiValued/Pick DBMS. The whole concept doesn't scare us since it appears to be a mashing together of a lot of concepts that we already are familiar with. HOWEVER. What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. I have installed the personal editions and have the server running, but I have no clue as to really creating a database, defining a table, inserting data into a record, retrieving data from a record, and applying business logic to fields. Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. Thanks, Walter Vaughan Vice President Steele Rubber Products, Inc. --- 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] Newbies need love too
You can look into getting documents and training materials from Malcolm Bull at: http://members.aol.com/_ht_a/mbtraining/ or John Sisk at: http://www.jes.com or documentation and training at IBM or Rainingdata's web sites. http://www-306.ibm.com/software/data/u2/pubs/library/ http://www.rainingdata.com/education/index.html and the Users group site at: http://www.u2ug.org/ - Original Message - From: Walter Vaughan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, January 31, 2006 4:33 PM Subject: [U2] Newbies need love too We are looking extremely hard at moving our company to an MRP/DM vertical solution written to run on the UniVerse platform. Our internal staff has dozens of years experience with filePro, mySQL, PHP, perl... yet we have no experience among the four of us working with UniVerse or any MultiValued/Pick DBMS. The whole concept doesn't scare us since it appears to be a mashing together of a lot of concepts that we already are familiar with. HOWEVER. What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. I have installed the personal editions and have the server running, but I have no clue as to really creating a database, defining a table, inserting data into a record, retrieving data from a record, and applying business logic to fields. Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. Thanks, Walter Vaughan Vice President Steele Rubber Products, Inc. --- 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] Newbies need love too
I went to a classes offered by my vendor. There are no UniVerse for Dummies books, but there are some really knowledgeable consultants out there. Ask your vendor for some names. Bring him/her in for a couple of days' introduction. Then let your people play for a month. Then bring the consultant back for a week of solid level 1, level 2 training. I think that, along with all the help and advice you will get from the kind folks here will get your people through. My $.02 worth of advice. Al DeWitt Stylmark, Inc. 763-574-8705 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter Vaughan Sent: Tuesday, January 31, 2006 4:34 PM To: u2-users@listserver.u2ug.org Subject: [U2] Newbies need love too We are looking extremely hard at moving our company to an MRP/DM vertical solution written to run on the UniVerse platform. Our internal staff has dozens of years experience with filePro, mySQL, PHP, perl... yet we have no experience among the four of us working with UniVerse or any MultiValued/Pick DBMS. The whole concept doesn't scare us since it appears to be a mashing together of a lot of concepts that we already are familiar with. HOWEVER. What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. I have installed the personal editions and have the server running, but I have no clue as to really creating a database, defining a table, inserting data into a record, retrieving data from a record, and applying business logic to fields. Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. Thanks, Walter Vaughan Vice President Steele Rubber Products, Inc. --- 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] Newbies need love too
Goo'day, Walter, At 17:33 31/01/06 -0500, you wrote: We are looking extremely hard at moving our company to an MRP/DM vertical solution written to run on the UniVerse platform. Our internal staff has dozens of years experience with filePro, mySQL, PHP, perl... yet we have no experience among the four of us working with UniVerse or any MultiValued/Pick DBMS. The whole concept doesn't scare us since it appears to be a mashing together of a lot of concepts that we already are familiar with. HOWEVER. What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. I have installed the personal editions and have the server running, but I have no clue as to really creating a database, defining a table, inserting data into a record, retrieving data from a record, and applying business logic to fields. Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I reckon you should enrol you and your people in the classes organised by IBM. Get a grounding in the Multi-Value and UniVerse concepts first, then look at your application from that grounding and get the provider/VAR to add specifics to the knowledge you have already acquired. You might have caught the posting earlier today: Folks: Based on a recent thread about UniVerse 'internals' class availability - I researched. The class is now named 'UniVerse Theory and Practice'. It has recently been added to the IBM US class schedule. June 6-9 in Denver. Wally Terhune Manager - U2 Advanced Client Support IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 Fax: 303.773.5915 [EMAIL PROTECTED] In point of fact, I'd hazard that's how most of us did it - no matter how many years ago it was... It probably wasn't via IBM, though Alternatively, I think there are still courses available from private sources Perhaps somebody can come up with a list or a local And, if it's not too soon, welcome to the club -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.25/247 - Release Date: 31/01/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.375 / Virus Database: 267.14.25/247 - Release Date: 31/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies Need Love Too
I was in a similar situation eight years ago. At a show, I spoke with an expert from Ardent, who made convincing arguments that U2 is a first-rate platform and especially well suited to MRP applications. At the time, we were also considering mainstream SQL solutions and the Progress database. The IBM U2 website has the complete list of documentation available for the products. Note that some of these books (like Java) may only be listed under UniData although these books there also apply equally to UniVerse. For both newbies and experienced users, the book that I have recommended many times on this forum is The Pick Programming Language, BASIC, by Malcolm Bull, Chapman Hall Computing, (c) 1994. This book is well worth having. I like the Dummies books. While this book was written before the Dummies era began, it is well-organized and easy to read. Professional U2 education is available from IBM, www.Epicor.com, and others. I have found that participants on this u2ug list have unparalleled enthusiasm for U2 products. This u2ug list is an outstanding resource for help for both newbies and mavens. Please do not take my word for it; try it out. Post away. Feel free to call me to discuss further... Regards, Bill Brutzman Manager, IT HK MetalCraft Mfg Corp PO Box 775 35 Industrial Road Lodi NJ 07644 973.471.7770 x145 .voice 973.471.9666 .fax [EMAIL PROTECTED] * We are looking extremely hard at moving our company to an MRP/DM vertical solution written to run on the UniVerse platform. Our internal staff has dozens of years experience with filePro, mySQL, PHP, perl... yet we have no experience among the four of us working with UniVerse or any MultiValued/Pick DBMS. The whole concept doesn't scare us since it appears to be a mashing together of a lot of concepts that we already are familiar with. HOWEVER. What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. I have installed the personal editions and have the server running, but I have no clue as to really creating a database, defining a table, inserting data into a record, retrieving data from a record, and applying business logic to fields. Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. Thanks, Walter Vaughan Vice President Steele Rubber Products, Inc. --- 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/ [demime 1.01d removed an attachment of type application/octet-stream which had a name of Brutzman, Bill.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Active Select list with UniXML
I think you'll need to use a SelectList object to manipulate the list of keys, a File object to use those keys to access records, possibly a DynamicArray object to receive the results of the File object's Read method, and then run this through the XML generator. - Original Message - From: Victor St Clair [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] Active Select list with UniXML Date: Tue, 31 Jan 2006 11:49:15 -0800 Hello all Haven't had any response on this question. But I sent it out late on Friday afternoon so maybe missed it being seen by some one who know the answer. So I'm resending it now. Hopefully there will be some one who can shed some light on the topic, even if it's just to say nope, you can't do it. Does any one know of a way to use a select list with the UniXML class in UniObjects .Net? We have been using UniObjects.Net to retrieve data from UniData 7.1 using the UniXML class. A typical query would be something like... UniXML xml = Session.CreateUniXML(); xml.GenerateXML(list FileName with selection_criteria fieldName fieldName TOXML); Overall this has been working out very well. What I would like to be able to figure out is how to use this list command with an active select list. Has any one done this? (Am I missing something obvious?) thanks Victor St. Clair Jenkon Vancouver, WA 360.256.4400 [EMAIL PROTECTED] www.jenkon.com --- 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] Newbies need love too
Walter Vaughan wrote: Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. Thanks, Walter Vaughan Vice President Steele Rubber Products, Inc. In addition to the excellent links already mentioned - the comp.databases.pick newsgroup is also a good resource for help - although this and the u2-community mailing list are more U2 specific. The good news is that all of these groups are very friendly, very professional and very willing to help. I myself am a U2 newcomer, and have received excellent advice here. As a side note, I'm really encouraged to hear that you have a couple of 20-somethings who are willing and able to get into MV! Good Luck Bob Little --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Newbies need love too
As someone who teaches them regularly, I'd recommend the IBM official classes. The UV900 (UniVerse Essentials) class is designed for newbies, who can then stream into UV903 (UniVerse Database Programming) or UV904 (Administering UniVerse). Sure there are others but these three (a) are scheduled - and run - on a regular basis and (b) will give your people a good grounding. Hound your sales rep for a good price for on-site training - you need only four or five students to make break-even even at published rates, and can arrange times to suit yourselves. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: XML Issue - 'ISO-8859-1'
The standalone attribute is unrelated to the encoding attribute and tells the parser that a DTD is required or not. The attribute is optional and if you aren't using a DTD, leave it out. If you don't know what a DTD is then you probably aren't using one - they're a way to validate the structure of an XML document but they're becoming less common these days and have largely been replaced by xml schemas (.xsd). Also, be aware that UniVerse without NLS uses an ISO-8859-1 based character set. For example, XML documents generated by UniVerse which included a character greater than char(128) (eg Cafi blend coffee) will be misinterpreted by most XML parsers if the encoding attribute is set to UTF-8. Try using the following header: ?xml version=1.0 encoding=iso-8859-1? __ From: Nancy Fisher I tried to look up what standalone means - but didn't really get it. I wondered if it meant it wasn't using mapping? * * This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. * * --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies need love too
You will probably find that it really isnt difficult to learn. I moved into my current job 12 years ago with absolutely no experience with Universe (actually it was PI/Open and then we moved to Universe). I learned it by just reading, playing on a test account, reading source code, and just getting thrown into the hot seat. I had about 10 yrs previous experience on other systems and databases before Universe. That makes it easier. You find that you are really doing the same thing using different commands. Once you are settled with things, you will find that Universe doesnt need a lot of baby sitting. The people on this list are a great help. There is lots of experience here and people are always glad to help. Dont be afraid to ask questions. Anthony -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.14.23/243 - Release Date: 1/27/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Newbies need love too
On 1/31/06, Walter Vaughan [EMAIL PROTECTED] wrote: We are looking extremely hard at moving our company to an MRP/DM vertical solution written to run on the UniVerse platform. Our internal staff has dozens of years experience with filePro, mySQL, PHP, perl... yet we have no experience among the four of us working with UniVerse or any MultiValued/Pick DBMS. The whole concept doesn't scare us since it appears to be a mashing together of a lot of concepts that we already are familiar with. HOWEVER. What about the newbies? Don't we get any love? I have went through every google term I could think of to come up with a simple This is how you get started with a UniVerse. I have installed the personal editions and have the server running, but I have no clue as to really creating a database, defining a table, inserting data into a record, retrieving data from a record, and applying business logic to fields. Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. Hi Walter -- this might not get as deep as you need, but it is a place to start. http://www.tincat-group.com/mv/trilogy.html It is a set of flashcards turned into web presentations (the javascript isn't quite right yet, so be sure to go through all three sets, perhaps returning to this url for each one). The first one is an Overview of MultiValue, the second is about MultiValue Data and the third is about the command environment. After these, take a look at either documentation on the U2 web site or possibly at http://jes.com/pb/index.html to get an overview of DataBASIC before diving in. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. Any website pointers will be appreciated. You and/or your programmers might also enjoy my blog. You could start with http://www.tincat-group.com/mewsings/2006/01/is-codd-dead.html and work forward. Enjoy. --dawn -- Dawn M. Wolthuis Tincat Group, Inc. www.tincat-group.com Take and give some delight today! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Dynamic Files
As someone who's not a newbie, but has some newbie questions from time to time... I need some decent info on Unidata dynamic files. I've got the IBM/U2 docs as well as a couple of Fitz Long PDFs on file hashing. In short, we use static hashing on most files and have no trouble, resize weekly (or more often) and keep great tabs on modulos, overflow and the like. However, we have a couple that are approaching 1Gig in size and I don't want to wait until I get any closer to the 2Gig limit before moving some of the large ones to dynamic hashing. However, the few files I have moved to dynamic hashing are rediculous in size. I'm obviously setting some file parameters wrong, but would like insight from anyone who has good luck... The file STC.HIST as a dynamic file takes up 4.3Gig of disk space. It has around 944,000 records, a blocksize of 1024 but a modulo of 4,000,000+ When I convert this to a static file, I can properly size it with a modulo of around 94,000 which takes up a mere 75Meg. I've tried changing split/merge loads from the default of 60/40 to 20/10. I've tried playing with the minimum modulo. I'm clueless on dynamic files and would love any insight. Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 We make moral decisions everyday even if we don't know it. Scott Simon (NPR) on the death of 20,000 coal miners annually in China. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Dynamic Files
[EMAIL PROTECTED] wrote on 01/31/2006 09:15:09 PM: The file STC.HIST as a dynamic file takes up 4.3Gig of disk space. It has around 944,000 records, a blocksize of 1024 but a modulo of 4,000,000+ When I convert this to a static file, I can properly size it with a modulo of around 94,000 which takes up a mere 75Meg. I've tried changing split/merge loads from the default of 60/40 to 20/10. I've tried playing with the minimum modulo. I'm clueless on dynamic files and would love any insight. For the large file in its dynamic form, is most of the space consumed by the dat* or the over* files? If the former, you may just be wasting space. If the latter, you have some file configuration issues to resolve. What does GROUP.STAT show you? Are the records distributed evenly in the groups or does it vary greatly? What do your key lengths look like? Are they large or small? Do they vary greatly from one record to the next? You may want to consider using the KEYDATA option. It doesn't usually work better than KEYONLY, but I have seen it make a huge positive difference on a small percentage of files. You might also want to play around with changing the hash type. 0 usually works best, but once in a while 1 will help you. Also, you may actually see things improve by increasing the split and merge loads. I've seen files that worked with 90/45, but that doesn't happen very often. So much depends on the characteristics of the data in the file. I recently posted the following [very verbose] information, which may give you some guidance. = COPY OF RECENT POSTING BEGINS HERE = The following is swiped from an old technical bulletin and is a good starting point. You should run guide with the -r option on the file and use its output for the variables below. However, there's nothing like getting a small sample of the records in the file - maybe 1 percent, and creating a small test file to play around with. You can play with CONFIGURE.FILE and memresize (AVOID REBUILD.FILE AT ALL COSTS) to find the best parameters, then use those, with an increased modulo to size the real file. For what it's worth, I generally find that smaller split and load numbers, such as 20/10, work better than larger ones. Of course, that varies from file to file, and there is no absolute rule. == Formula for determining base modulo, block size, SPLIT_LOAD, and MERGE_LOAD for UniData KEYONLY Dynamic Files Note that the variables used are the same as the DICT items in $UDTHOME/sys/D_UDT_GUIDE. Any calculated values which are not attributes in this dictionary appear in bold italic. Considerations: The following does not take into account the Unix disk record (frame) size so it is best to select a block size based on the number of items you?d like in a group. No one method will provide absolute results but these calculations will minimize level one overflow caused by a high SPLIT_LOAD value. Type 0 works best for most Dynamic Files but it is best to check a small sample via the GROUP.STAT command. Step 1: Determine the blocksize. (Use 4096 unless the Items per group is larger then 35 or less then 2) A) If the MAXSIZ 1K ITEMSIZE = 10 * MAXSIZ B) If 1 K MAXSIZ 3 K ITEMSIZE = 5 * MAXSIZ C) If MAXSIZ 3 K ITEMSIZE = 5 * (AVGSIZ + DEVSIZ ) Once you determine the item size, use it to determine the NEWBLOCKSIZE. A) ITEMSIZE 1024;NEWBLOCKSIZE = 1024 B) 1024 ITEMSIZE 2048; NEWBLOCKSIZE = 2048 C) 2048 ITEMSIZE 4096; NEWBLOCKSIZE = 4096 D) 4096 ITEMSIZE 8192; NEWBLOCKSIZE = 8192 8192 ITEMSIZE 16384;NEWBLOCKSIZE = 16384 Step 2: Determine the actual number of items per group. ITEMS_PER_GROUP = NEWBLOCKSIZE-32 / AVGSIZ Step 3: Determine the base modulo BASEMODULO = COUNT / ITEMS_PER_GROUP Step 4: Determine SPLIT_LOAD SPLIT_LOAD=INTAVGKEY + 9) * ITEMS_PER_GROUP ) / NEW_BLOCKSIZE)*100)+1 If the SPLIT_LOAD is less then ten then:SPLIT_LOAD = 10 Step 5: Determine MERGE_LOAD MERGE_LOAD = SPLIT_LOAD / 2 ( Rounded up ) Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: XML Issue - 'ISO-8859-1'
Hmmm, encoding problems... that should have been cafe with a char(233) (e-acute in courier font). S __ From: Stuart.Boydell Also, be aware that UniVerse without NLS uses an ISO-8859-1 based character set. For example, XML documents generated by UniVerse which included a character greater than char(128) (eg Cafi blend coffee) will be misinterpreted by most XML parsers if the encoding attribute is set to UTF-8. ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Vlist Header Information
Does anyone know another way to get the header information from the first 10 or so lines of a vlist? (other than by using a vlist). Cheers, Stuart ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Vlist Header Information
Does anyone know another way to get the header information from the first 10 or so lines of a vlist? (other than by using a vlist). Hello, Stuart. You can use the SRS.UV.HEADER subroutine to get at all the header information shown by VLIST and much more. The SRS.UV.HEADER source code may be downloaded from http://www.srs4uv.com/srs_uv_header.htm. Hope this helps. Best regards, Gyle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies need love too
-Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bob Little Sent: Wednesday, 1 February 2006 12:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Newbies need love too As a side note, I'm really encouraged to hear that you have a couple of 20-somethings who are willing and able to get into MV! Good Luck Bob Little --- Bob, Given this comment, you may be interested to know that we just started 2 new 21 year old graduates last week. They were producing their first multi-valued GUI programs (that IS a plural) by the end of the first day, and were producing nicely formatted reports by the second. OK, so we cheated because they are using our Visage environment, but by giving the young ones visual tools that they are familiar with, then you can easily generate enthusiasm for the UV/multi-value environment (especially when they compared development with the tools they had used studied at university) (BTW, my 11 year old son can also develop applications with Visage ... anyone looking for a system to track Poke Mtn Yu-Gi-Oh cards?) Ross Ferris Stamina Software Visage Better by Design! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Vlist Header Information
Thanks Gyle, very good stuff. Stuart __ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gyle Iverson [EMAIL PROTECTED] Sent: Wednesday, 1 February 2006 15:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Vlist Header Information Does anyone know another way to get the header information from the first 10 or so lines of a vlist? (other than by using a vlist). Hello, Stuart. You can use the SRS.UV.HEADER subroutine to get at all the header information shown by VLIST and much more. The SRS.UV.HEADER source code may be downloaded from http://www.srs4uv.com/srs_uv_header.htm. Hope this helps. Best regards, Gyle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Newbies need love too
[AD] Key Ally offers some excellent training, as do many others. I've just done classes for Adelphi University, NY Botanic Gardens, and I am negotiating to do two others this quarter. We will customize classes to your knowledge level. [/AD] - Charles Barouch [EMAIL PROTECTED] (718) 762-3884 x 1 P. O. Box 540957, Linden Hill, NY 11354-0957 www.KeyAlly.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/