[U2] Job Vacancy - Sent to me , but of no use to me
I have an excellent new opportunity: My financial client based in Central London is urgently seeking two experienced Data-basic Programmers. Must have minimum 5 years Fiscal programming experience in a Universe Operating System. Minimum 6 month contract. Please contact me for further information. If this is not relevant to you, let me know and I will amend your details accordingly. I look forward to hearing from you. Regards, Stella Cronshey Progressive City phone 020 8971 email [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
Check out http://www.discoverycomputersystems.com/ I got my Universe training at Marcie's school. She now only does onsite training, but she is definitely one of the best instructors I have ever had. She has a lot of experience, and was one of the trainers at PICK. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter Vaughan Sent: Tuesday, January 31, 2006 5: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] UV910 - IBM UniVerse Theory and Practice - US course scheduled
test only... please ignore... having sending problems AGAIN. On 1/31/06, Martin Phillips [EMAIL PROTECTED] wrote: 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/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Newbies need love too
Well said Nick. And Marcie is a master at customizing a course to fit your in-house skill set and expertise. She excels at relating the material to the paradigm your people already have, given their IS background. We had her out more than once, years ago [I won't say how many ;-P ] and we were never disappointed. I was with a public safety agency then, and if she can teach cops and fire fighters computer stuff, hey, you know she's good ;-). R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. Check out http://www.discoverycomputersystems.com/ I got my Universe training at Marcie's school. She now only does onsite training, but she is definitely one of the best instructors I have ever had. She has a lot of experience, and was one of the trainers at PICK. Thanks, Nick Cipollina 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. 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
On 2/1/06, Nick Cipollina [EMAIL PROTECTED] wrote: Check out http://www.discoverycomputersystems.com/ I got my Universe training at Marcie's school. She now only does onsite training, but she is definitely one of the best instructors I have ever had. She has a lot of experience, and was one of the trainers at PICK. I've attempted to capture all of the links that were suggested on this Wiki page: http://www.pickwiki.com/cgi-bin/wiki.pl?UniVerse/GettingStarted Please feel free to add more! (To edit, click preferences, and the admin password is Mr. Pick's first name in lowercase.) -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Active Select list with UniXML
Thanks Ray Yes, I can definitely do it that way, and have been using UniObjects like that for a couple years now (without the XML step). I was hoping there was a way to combine all those steps into the UniXML class. I think, based on your response and the lack of any other suggestions, I'm going to assume it's not available at this time. Thanks again for the reply though. Victor St. Clair Jenkon Vancouver, WA 360.256.4400 [EMAIL PROTECTED] www.jenkon.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Tuesday, January 31, 2006 5:07 PM To: u2-users@listserver.u2ug.org Subject: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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Dynamic Files
On Tuesday 31 January 2006 22:27, Timothy Snyder wrote: For the large file in its dynamic form, is most of the space consumed by the dat* or the over* files? dat files - I know I'm wasting space. 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? The distribution is fairly consistent. What do your key lengths look like? Are they large or small? Do they vary greatly from one record to the next? They're all similar - about 20-22 characters in length, a mix of alphanumeric. 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. Thanks for your comments -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Hindsight alone is not wisdom. George W. Bush --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dynamic Files
I would recommend keeping your files static right up to the point that they hit 2 gig. A well sized static file will run faster and have less overhead in my opinion. Also, if you do go the dynamic route, I would recommend resizing them once a year as well. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 31, 2006 8:15 PM To: u2-users@listserver.u2ug.org Subject: [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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dynamic Files
Sorry if this is a bit thick, I'm a UV guy rather than a UD guy. But when you said I've tried changing split/merge loads from the default of 60/40 to 20/10 wouldn't that make the file much bigger? I don't know if UD works differently but in UV this would mean a new group was created every time the actual file load hit 20% so setting it to 20/10 in UV I'd expect the file to be about 5x bigger than the amount of data in it... How you've gone from 75MB to 4.3GB I can't explain though!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: 01 February 2006 02:15 To: u2-users@listserver.u2ug.org Subject: [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/ ** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Dynamic Files
- Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, January 31, 2006 9:15 PM Subject: [U2] Dynamic Files ... 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 Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] Jeff, A couple of questions: UD or UV? If UD, dynamic KEYDATA or dynamic KEYONLY? And what is your average record size in the STC.HIST file? Also, I am guessing that as a history file, it is going to continue to grow, so how about GROW as the minimum modulo? Susan Lynch F.W. Davison Company, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dynamic Files
My 2 Cents, Split load, and merge load are set to 60/40 by default for KEYONLY dynamic files. That is to say when 60% of the group is filled with keys, it can split. (Note that actual condition on when the spilt occurs takes more things into consideration). So splitting of groups will create more groups (and more frames that can have unused space). Yet for performance, you must consider the direct reads and writes. The more items per group the higher the potential for overflow groups. (And yes, dynamic file have overflow groups) In the case where we use the default 60/40 spilt, we have more items in a group then can fit in the first block of the group. (unless the ids of the item are much larger then the data in the item) Thus the majority of the data portion of the item is in another frame. You can minimize this by either lowering the split/merge factor for the KEYONLY items, or switch to the KEYDATA method. Note this will cause an interesting issue. Your selects may take longer. A Dynamic file with an improper split/merge loads will experience the same issue as a poorly sized static file. 'The simple select will run faster, but reads and writes will take longer.' This is due to the amount of reads required to gather all of the ids. If the ids are in fewer groups, the system will read through them quicker then if they were spread out in a properly sized file. It is better to properly size the file then add indexes then to have an improperly sized file. Note I can ramble on for hours more on the topic, but will stop it here, and see if anyone actually got this far in my message. As for the suggestion to change the hash type, a good way to check is to copy some items (I usually do 100) into a test file, and perform HASH.TEST twice on them, and pick the type that has the lesser amount of Empty Groups. Michael Rajkowski Senior Programmer/Analyst Bolo Systems Inc. (720) 212 - 0691 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Dynamic Files
This may help (or perhaps not) In teaching Unidata courses I have heard several comments over the last year or so about large dynamic files that have apparently stopped working correctly. The two that I have been able to examine in any detail both showed that the system appeared to be splitting groups when it did not need to, resulting in vast amounts of dead space and an average load a long way below the merge load value. Unfortunately, I do not still have the analysis as this was left with the customer to forward to IBM for further investigation. It looks to me as though there is a bug there somewhere but, because IBM do not publish any detailed internals information for Unidata, it might just be a problem with the underlying principles. In general, a dynamic file will never be as good as a perfectly tuned static file but it should be better than a static file that has been allowed to degrade through lack of retuning. Personally, I am a great believer in dynamic files and rarely use static files when working with UniVerse. We have a UniVerse client with an application that has over 100,000 dynamic files (honest!) and has never experienced a problem. Ok, most of these files are small and only a few are in use at any time. Because of the above mentioned issues, I am more wary of dynamic files in Unidata. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dynamic Files
Dynamic vs Hash Statistics UniData Version 6.0.600-PE Test Date: Wednesday, September 14, 2005 The following benchmarks are from a small SA file of 4,476 records. Process Dynamic Hash Under Hash Good Hash Over Deleting 357 304 327 761 Adding 430 471 414 901 Selecting 134 167 157 965 Processing 1676 1740 1733 2410 The times are given in CPU Milliseconds as an average after 3 runs. The runs were done on a stand alone machine running Windows XP Pro. A COUNT SA command was issued before each run. David A. Green DAG Consulting --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: RE: [U2] Newbies need love too
Walter, There is a real gap in information for newcomers at the moment, but it is something this user group is trying hard to repair. We have a number of projects going on to make this level of information (design, best practice, howto-type information) available to the public. I know this doesn't help you now, but please be sure that you can always post questions here and get a response. You're among friends... First step - download the personal edition from the IBM web site. Get the version for Windows - it's easier to set up. You can also download all of the UniVerse docs from the IBM website: they're all written with experienced developers in mind :-( but the system description guide gives a flavor of what is involved, though bear in mind that it was written a long time ago and has a very primitive outlook on what the technology can do. I would then go straight to the UniObjects manual to see how to use UniVerse in a client/server environment: that's much more fun AND the API used provides a nice abstraction of the database that is more approachable and quite helpful for newbies to learn. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Walter Vaughan Sent: Tuesday, January 31, 2006 5: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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Is a dynamic array empty or not?
I'm probably missing something obvious here... What can I use to evaluate the emptiness of these arrays, so that 1 and 2 are considered empty and 3 is not? TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM Thanks! Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dynamic Files
At 10:16 AM 2/1/2006, you wrote: How you've gone from 75MB to 4.3GB I can't explain though!! You don't say what version of UniData you are on but I am going to make an educated guess that it is an older release. I am also going to guess that you used the default hash type when you created the file. My last guess is that the file currently is a hash type of 1. Do a GROUP.STAT filename This will quickly tell you at the top what hash type it is. Years ago, when this was the default, people were getting horrible hashing when creating dynamic files. They end up with all these empty groups and huge files that continue to split. This was so much of a problem, that they (Ardent/Informix) then made hash type 0 the default. Remember, you can always specify the hashtype on file creation to override defaults. I would bet money this is your problem, Doug Miller [EMAIL PROTECTED] Manager of Technical Services Strategy 7Dallas TX --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dynamic Files
James Cowell wrote on 02/01/2006 11:16:36 AM: Sorry if this is a bit thick, I'm a UV guy rather than a UD guy. But when you said I've tried changing split/merge loads from the default of 60/40 to 20/10 wouldn't that make the file much bigger? I don't know if UD works differently but in UV this would mean a new group was created every time the actual file load hit 20% so setting it to 20/10 in UV I'd expect the file to be about 5x bigger than the amount of data in it... As you suspect, there is a difference between the way UDT and UV handle this. Or more specifically, UniData offers an option not available in UniVerse. When you create or configure a dynamic file, you can instruct it to use either KEYDATA or KEYONLY determination. KEYDATA acts the same way as UniVerse in that the size of both the key and the data are used in determining whether to split or merge. If you use KEYONLY, only the size of the keys is used to make the decision. UniData stores the keys and pointers at the beginning of a group, and the records are stored at the end. If you use KEYONLY with a high split load, you could end up with only keys in the physical block, with all of the records in other blocks. A low split load with KEYONLY will cause it to keep the records more local to their corresponding keys. 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/
[U2] Re: XML Issue
(Windows/UniVerse) I do have an '.xsd'. I can get either encoding (ISO-8850-1 or UTF-8) to work as long as I don't use the 'standalone=yes'. However it is different than the download I get with the heading that COMES WITH 'UTF-8'. That download has a better 'structure' when it comes with UTF-8 than with ISO-8850-1... (When I change the ISO.. to the UTF it doesn't help the structure) (partial snippets only). ?xml version=1.0 encoding=UTF-8? VEHICLEPOSITIONS ticket=a_x VEHICLE ID=555 LON-122.65788/LON LAT45.504333/LAT DATE2006-01-26 20:58:25.0/DATE SPEED0/SPEED DIRECTION1/DIRECTION NAME333/NAME ?xml version=1.0 encoding=ISO-8859-1? VEHICLEPOSITIONS ticket=a_x VEHICLE ID=222 LON-122.70442/LON LAT45.545563/LAT DATE2006-01-26 15:34:59.0/DATE SPEED0/SPEED DIRECTION36/DIRECTION NAME1100/NAME And in the 2nd download I have to remove linefeeds before writing to the file. (p.s. Is there a convention for changing the heading? I just replace and append...) thanks for your help, Nancy From: [EMAIL PROTECTED] Subject: 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? 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] Is a dynamic array empty or not?
CONVERT @VM TO '' IN TEST.1 CONVERT @AM TO '' IN TEST.1 IF TEST.1 NE THEN .. etc Wendy Smoak wrote: I'm probably missing something obvious here... What can I use to evaluate the emptiness of these arrays, so that 1 and 2 are considered empty and 3 is not? TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM Thanks! Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Richard A. Wilson Lakeside Systems --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Is a dynamic array empty or not?
What can I use to evaluate the emptiness of these arrays, so that 1 and 2 are considered empty and 3 is not? TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM Try something that removes all the ignored characters such as: IF CONVERT(@AM:@VM:' ', '', item) = '' THEN ... Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Is a dynamic array empty or not?
You didn't specify UD or UV, but this should work (in UD at least): IF TRIM(CONVERT(@AM:@VM:@SM,,TEST.x)) EQ THEN ... The array is empty Larry Hiscock Western Computer Sevices -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Wednesday, February 01, 2006 9:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] Is a dynamic array empty or not? I'm probably missing something obvious here... What can I use to evaluate the emptiness of these arrays, so that 1 and 2 are considered empty and 3 is not? TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM Thanks! Wendy Smoak --- 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] Is a dynamic array empty or not?
On Wed, Feb 01, 2006 at 10:19:00AM -0700, Wendy Smoak wrote: I'm probably missing something obvious here... What can I use to evaluate the emptiness of these arrays, so that 1 and 2 are considered empty and 3 is not? TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM Couldn't you do a convert(@FM:@VM:@SM:@AM:' ','') on them and see if they're null? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Newbies need love too [AD]
Clifton Oliver Associates is once again offering on site classes that can bring your staff up to speed quickly. If you (or anyone else reading) would like more information, please contact me at [EMAIL PROTECTED] or phone +1 619 460 5678. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Jan 31, 2006, at 2:33 PM, Walter Vaughan 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 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] Is a dynamic array empty or not?
How 'bout IF TRIM(CONVERT(@AM:@VM,'',TEST.1)) = '' THEN Bruce M Neylon Health Care Management Group Wendy Smoak [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/01/2006 12:19 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] Is a dynamic array empty or not? I'm probably missing something obvious here... What can I use to evaluate the emptiness of these arrays, so that 1 and 2 are considered empty and 3 is not? TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM Thanks! Wendy Smoak --- 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] Trouble starting logs on Win Server 2003
It generates code 2003 (0x7D3). The url it generates is of no use as it is to an ASP page which expects info passed from the machine in question. That machine is not permitted to go out to the Net. Another tech and I spent several hours combing the support.microsoft.com site, and we cannot find this code documented anywhere. -- Regards, Clif On Jan 30, 2006, at 12:38 PM, Kevin King wrote: Clif.. the System Event Log doesn't give any clues as to a fail reason? --- 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] Dynamic Files
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 A couple of questions: UD or UV? If UD, dynamic KEYDATA or dynamic KEYONLY? Unidata, Keyonly And what is your average record size in the STC.HIST file? Also, I am guessing that as a history file, it is going to continue to grow, so how about GROW as the minimum modulo? We purge records in the file after they're 1 year old (if nobody's asked or questioned student registrations in a year - well after a course has ended) then they can safely be purged. We do this regularly so the file will not continue to grow. -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Hindsight alone is not wisdom. George W. Bush --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Is a dynamic array empty or not?
On Wednesday 01 February 2006 12:19, Wendy Smoak wrote: I'm probably missing something obvious here... What can I use to evaluate the emptiness of these arrays, so that 1 and 2 are considered empty and 3 is not? TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM The brute force way: X = TEST.1 CONVERT @AM:@SM:@VM:@FM:@TM:' ' TO '' IN X IF LEN(X) 0 THEN ... -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 Hindsight alone is not wisdom. George W. Bush --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Trouble starting logs on Win Server 2003
We found the Performance... service set to Manual. So we changed that to Automatic. Same error. Compared all performance monitor settings to a machine that has no problem. Still no go. Tried writing the logs to D:\... Same error. Thanks for the suggestions, though! -- Regards, Clif On Jan 30, 2006, at 1:55 PM, Bill Haskett wrote: Clif: I wonder if the log service is started (or on automatic). What happens if you configure the logs to write to D:\... instead of C:\perflogs. Are you starting the logging properly. I just did a quick 5 minute log on our system and had no problems. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Is a dynamic array empty or not?
Me too, 'cause TEST.2 isnt empty I dont think. Unless blanks are not 'something' I always use EQS or NES functions for evaluation. Just make an array using the same delimiters, and say TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM XYZ=EQS(TEST.1,TEST.3) CRT XYZ 1}1~0}0}1~0~1 OR... am I missing something? j On 2/1/06, Wendy Smoak [EMAIL PROTECTED] wrote: I'm probably missing something obvious here... What can I use to evaluate the emptiness of these arrays, so that 1 and 2 are considered empty and 3 is not? TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM Thanks! Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Trouble starting logs on Win Server 2003
Logged in as the local administrator and got the same error. Good suggestion, though. Thanks! -- Regards, Clif On Jan 30, 2006, at 2:34 PM, David Jordan wrote: I am in the Administrators Group. I can watch the stats, I just cannot get a log to capture them. I have run into issues where the administrators group does not seem to have the same rights as the administrator login. Con you try logging on as the administrator. Regards David Jordan Managing Consultant [EMAIL PROTECTED] Mobile: 0428 669 730 DACONO Holdings Pty Ltd www.dacono.com.au PO Box 909 Lane Cove NSW 2066 Australia Phn: 61 2 9418 8320 Fax: 61 2 9427 2371 --- 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] Is a dynamic array empty or not?
Here's what we came up with, just for fun: IF SUM(NOTS(NOTS(TRIMS(REPORT.DATA2 THEN CRT 'Not empty!' The TRIM(CONVERT(...)) answer would work as well, I think. I don't want to change the value of the array-- if it's not empty, I need to print it. (UniData, BTW, sorry I didn't mention it. And the values that contain only spaces should be considered empty.) Thanks, -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Is a dynamic array empty or not?
Hmmm... That leads to an interesting idea. If you consider a space to be 'something', then test.1 is really the only 'empty' array, and the following would work, without doing any trims or conversions: IF SUM(SUM(NES(TEST.x,REUSE('' THEN (string is not empty) You could also make it work, considering spaces to be empty by amending it thusly: IF SUM(SUM(NES(CONVERT(' ','',TEST.x),REUSE('' THEN (string is not empty) Remember: eschew obfuscation ;-) Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john reid Sent: Wednesday, February 01, 2006 10:39 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Is a dynamic array empty or not? Me too, 'cause TEST.2 isnt empty I dont think. Unless blanks are not 'something' I always use EQS or NES functions for evaluation. Just make an array using the same delimiters, and say TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM XYZ=EQS(TEST.1,TEST.3) CRT XYZ 1}1~0}0}1~0~1 OR... am I missing something? j On 2/1/06, Wendy Smoak [EMAIL PROTECTED] wrote: I'm probably missing something obvious here... What can I use to evaluate the emptiness of these arrays, so that 1 and 2 are considered empty and 3 is not? TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM Thanks! Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- john --- 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
Wendy: Do you think it'd be a good idea to put a Getting Started link to this page on the main page, or did I miss it? :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Wednesday, February 01, 2006 6:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Newbies need love too On 2/1/06, Nick Cipollina [EMAIL PROTECTED] wrote: Check out http://www.discoverycomputersystems.com/ I got my Universe training at Marcie's school. She now only does onsite training, but she is definitely one of the best instructors I have ever had. She has a lot of experience, and was one of the trainers at PICK. I've attempted to capture all of the links that were suggested on this Wiki page: http://www.pickwiki.com/cgi-bin/wiki.pl?UniVerse/GettingStarted Please feel free to add more! (To edit, click preferences, and the admin password is Mr. Pick's first name in lowercase.) -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Newbies need love too
On 2/1/06, Wendy Smoak [EMAIL PROTECTED] wrote: On 2/1/06, Nick Cipollina [EMAIL PROTECTED] wrote: Check out http://www.discoverycomputersystems.com/ I got my Universe training at Marcie's school. She now only does onsite training, but she is definitely one of the best instructors I have ever had. She has a lot of experience, and was one of the trainers at PICK. I've attempted to capture all of the links that were suggested on this Wiki page: http://www.pickwiki.com/cgi-bin/wiki.pl?UniVerse/GettingStarted Please feel free to add more! (To edit, click preferences, and the admin password is Mr. Pick's first name in lowercase.) Thanks Wendy -- that's great! --dawn -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Dawn M. Wolthuis Tincat Group, Inc. Take and give some delight today! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [OT] Where's my voting instructions?
In a message yesterday, it was mentioned that we would be receiving our voting instructions today. Will that still be forthcoming? Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [AD] Job Posting - New Zealand Defence Force {Unclassified}
The NZ Defence Force is seeking to employ an additional UniVerse-experienced Applications Engineer. The position is fixed term to the end of June 2008 and is within the Personnel Training team, providing support and maintenance for our IBM UniVerse-based Payroll Personnel system. The position is based in Porirua, a northern suburb of Wellington. The ideal candidate will have experience creating software in an enterprise computing environment and have significant expertise in developing and supporting IBM UniVerse and/or UniData applications. Exposure to .NET, web applications and SQL Server is desirable. Essential attributes for this position are a proven record of producing results in similar roles, excellent interpersonal communication skills and a demonstrated ability to meet deadlines under pressure. Salary Band I14/15; $NZ41,000 to $NZ62,000 p.a. Applicants must be legally entitled to work in New Zealand and be able to obtain and maintain the required NZDF security clearance. This includes applicants being either a New Zealand citizen, or holding a permanent residence for a minimum of 5 years, or being citizens of the UK, Canada, Australia or the USA for 10 years or more. For an application pack visit www.nzdf.mil.nz/vacancies or contact Jo Bland, mailto:[EMAIL PROTECTED], phone +64-4-2371835 Please quote vacancy number CIS Br.09ATLAS SA/06 in all your correspondence. Applications close 24th February 2006. The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Is a dynamic array empty or not?
Len(Convert(@AM:@VM: , , DynamicArray)) = 0 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Telnet on Windows 2003 Server
On a fresh install of UV on Windows 2003 server, only admin users can telnet in. Any ideas? TIA Mike --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Is a dynamic array empty or not?
Hi Wendy, If you remove @AM, @VM, and spaces by changing them to null values with the CONVERT function, then if the variable has anything left in it, you have a non-empty value. JUNK=TEST.1 CONVERT @AM:@VM: TO IN JUNK IF LEN(JUNK) GT 0 THEN PRINT TEST.1 IS NOT 'EMPTY' END ELSE PRINT TEST.1 IS 'EMPTY' END Just be sure to use a junk variable and don't CONVERT the actual variable. HTH, BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: Wednesday, February 01, 2006 9:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] Is a dynamic array empty or not? I'm probably missing something obvious here... What can I use to evaluate the emptiness of these arrays, so that 1 and 2 are considered empty and 3 is not? TEST.1 = @VM:@AM:@VM:@VM:@AM:@AM TEST.2 = @VM:@AM:' ':@VM:' ':@VM:@AM:' ':@AM TEST.3 = @VM:@AM:' ':@VM:'zzz':@VM:@AM:'abc':@AM Thanks! Wendy Smoak --- 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] Is a dynamic array empty or not?
From: Ray Wurlod Len(Convert(@AM:@VM: , , DynamicArray)) = 0 Exactly. Len(X) is cheaper than (X=). Furthermore, since all parts of the double concatenation @AM:@VM: are constants, both those operations get evaluated by the compiler and the single hardcoded resultant string makes it into the object code. So there aren't runtime concatenation operations. This is true for UV Basic compiler, but not for I-descriptors. Don't know about UD. For that matter, the EQ operation in Len(...) = 0 may be unnecessary since Len(...) can be treated as either true or false all by iteslf. Sure, hardware is cheap, but you might as well be efficient when there's no downside. cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Identifying UD files
A year or so back, someone posted the /etc/magic settings for UV files, but no-one's come forward with UDT numbers yet .. -Chuck UniData has the udfile command. I played around with magic files before this command existed, but no longer see the need. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Telnet on Windows 2003 Server
It's a file permission issue. You need to allow non-admin users permission to write to the UV directory. Do not share this directory. Ross -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Wednesday, February 01, 2006 3:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] Telnet on Windows 2003 Server On a fresh install of UV on Windows 2003 server, only admin users can telnet in. Any ideas? TIA Mike --- 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] [UV] SOAP interface
I have the following program which I am testing to try and connect to a webservice to gain understanding about how this all works and what is and is not possible. I run and rerun the program over and over without logging off, and get a variety of results with the SoapSubmitRequest returing either a 0 or 2, mainly 2 which is a timeout. The Soap status, is either 200 (OK) or 100 (continue). As you can see the first run time outs, timeout set to 1000ms, but the response does get logged in the protocol log, with the following entry: 02/02/2006 13:50:22 readSocket 1: The virtual circuit was terminated due to a time-out or other failure. The application should close the socket as it is no longer usable. I believe readSocket is an underlying UV socket library call. One question I have is what is the application, is that UV, is that my basic program, and how can I close the socket with the SOAP api, or should I use the socket API, in which case do I use the SOAP api handle? Then without doing anything else, the second run works ok, but the third one does not. This is a basic webservice both on the same machine, and even when I set the timeout value to 3ms is still timesout more often than not. Once I have this webservice ticking over reliably, I will expand what is does, but this is just a proof of concept as to what sort of throughput I can expect. Has anyone found some better documentation or examples than the minimal amount in the BASIC extensions, about how this all works. Any input into or guidance as to what I may be doing wrong would be greatly appreciated. Cheers, Phil $Include UNIVERSE.INCLUDE XML.H LF = Char(10) Open 'XML' To XML.FileVar Else Return End Database.Table.XML.Name = 'Consumer' Database.Table.XML.SOAPFileName = Database.Table.XML.Name:'_Soap.xml' Default.HTTP.Version = '1.1' Default.SOAP.Version = '1.2' Default.XML.Version = '1.0' Default.XML.Encoding = 'UTF-8' Default.XML.Header = '?xml version=1.0 encoding=UTF-8?' Default.SOAPRequest.Timeout = 1000 Default.SOAPRequest.Content = Default.XML.Header:LF Default.SOAPRequest.Content := 'soap:Envelope' Default.SOAPRequest.Content := ' xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;' http://www.w3.org/2001/XMLSchema-instance;' Default.SOAPRequest.Content := ' xmlns:xsd=http://www.w3.org/2001/XMLSchema;' http://www.w3.org/2001/XMLSchema;' Default.SOAPRequest.Content := ' xmlns:soap=http://www.w3.org/2003/05/soap-envelope;' http://www.w3.org/2003/05/soap-envelope;' Default.SOAPRequest.Content := '':LF Default.SOAPRequest.Content := ' soap:Body':LF Default.SOAPRequest.Content := 'OPERATION_NAME xmlns=TARGET_NAMESPACE':LF Default.SOAPRequest.Content := ' inputstream':Timedate():'/inputstream':LF Default.SOAPRequest.Content := '/OPERATION_NAME':LF Default.SOAPRequest.Content := ' /soap:Body':LF Default.SOAPRequest.Content := '/soap:Envelope' WebService.AddressLocation = 'http://localhost/Exodus/Service.asmx' WebService.TargetNameSpace = 'http://localhost/Exodus' WebService.OperationName = 'Consumer' WebService.OperationSoapAction = WebService.TargetNameSpace:'/':WebService.OperationName Gosub CallWebService If CallWebService.Success Else Return Close XML.FileVar Return *** CallWebService: *** CallWebService.Success = @False intStatus = protocolLogging('Soap.log','ON',7) If intStatus XML.SUCCESS Then Crt 'Call to protocolLogging() returned (':intStatus:')' Return End intStatus = setHTTPDefault('VERSION',Default.HTTP.Version) If intStatus XML.SUCCESS Then Crt 'Call to setHTTPDefault() returned (':intStatus:')' Return End intStatus = SoapSetDefault('VERSION',Default.SOAP.Version) If intStatus XML.SUCCESS Then Crt 'Call to SoapSetDefault() returned (':intStatus:')' Return End intStatus = SOAPCreateRequest(WebService.AddressLocation,WebService.OperationSoapAction,SoapRequest.Handle) If intStatus XML.SUCCESS Then Crt 'Call to SOAPCreateRequest() returned (':intStatus:')' Return End SoapRequest.Content = Default.SOAPRequest.Content SoapRequest.Content = Change(SoapRequest.Content,'OPERATION_NAME',WebService.OperationName) SoapRequest.Content = Change(SoapRequest.Content,'TARGET_NAMESPACE',WebService.TargetNameSpace,1) intStatus = SOAPSetRequestContent(SoapRequest.Handle,SoapRequest.Content,1) If intStatus XML.SUCCESS Then Crt 'Call to SOAPSetRequestContent() returned
RE: [U2] [UV] SOAP interface
There is another example of a U2 BASIC SOAP client in the IBM U2 Developerworks website (not sure if this in the manual you refer to): http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0508kes ic/ It's good, as it keeps things simple and is pretty well easy to follow. Perhaps not exactly what's your after or of much help! Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of phil walker Sent: Thursday, February 02, 2006 12:55 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] SOAP interface [snip] Has anyone found some better documentation or examples than the minimal amount in the BASIC extensions, about how this all works. Any input into or guidance as to what I may be doing wrong would be greatly appreciated. [snip] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/