[U2] RE: [U2C] Religious Wars
Well said. Do you realize that this thread is actually being talked about on both lists now! :-) Jerry -Original Message- From: Jeff Fitzgerald [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 11, 2007 3:01 PM To: [EMAIL PROTECTED] Subject: RE: [U2C] Religious Wars Chill, Chuck! ;-) As Bruce Neylon pointed out, your emotions are leading you to distort things a tad. But, this is such a nice group that no one is going to attack you for venting or suggest that you not do that. Even if tomorrow you wish you'd waited to hit SEND no one here will jump down your throat for expressing yourself. I don't believe anyone wants an un-moderated group -- I know I don't. And I think everyone would agree that the moderators have been doing a fine job and have contributed value to the list far in excess of their pay. So I vote to keep the list moderated. However there have been some valid questions raised, including these: * [AD] tagging - What are the rules? Who decides when a post is an ad? What is the punishment? [MY OPINION] If the sole purpose of a post is clearly to advertise a product it should be tagged in the subject line. Otherwise, we should allow a lot of slack and not worry about it. [/MY OPINION] [DISCLAIMER] I am a software vendor and was recently cyber spanked for a post which Charles (erroneously) categorized as touting a product. [/DISCLAIMER] * u2-community list - Should there be two lists? Who decides when a post should be moved or killed? [MY OPINION] There should only be one list and we should allow a lot of slack before killing a thread. If there are a lot of MP posts I guess that means that quite a few list members are enjoying that thread and I have no problem with it continuing a bit as long as I can identify related posts by subject line. Maybe the list should decide when enough's enough - perhaps five votes from list members to kill a thread? [/MY OPINION] * serious issues - What should cause a moderator to step in, kill a thread, reject a post, revoke list membership or take other serious action? [MY OPINION] Posting of pornography, obscene language, personal attacks against other members, racist or sexist comments, spamming the list, harvesting member addresses for spamming purposes or other posts that offend the list membership. Perhaps feedback from five members ought to be enough to revoke membership; I like the idea of the moderator assisting in the administration of a list that is actually run by the membership. [/MY OPINION] Jeff Fitzgerald --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Get a grip - was ads - was U2 University Last
-Original Message- From: Dawn Wolthuis [mailto:[EMAIL PROTECTED] Sent: Friday, September 07, 2007 4:33 PM To: Brian Leach Cc: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Get a grip - was ads - was U2 University Last snip 3. The REAL problem as I see it, is not the fact that topics are sent across to u2-community, but the fact that they die when they get there. No, I am absolutely certain that is not the real problem ;-) snip/ I am also certain, there are some companies, educational institutions, etc that have a problem allowing their users access to any email lists thinking that it may be an abuse of their email or jobs. Real or imagined, they will only allow access to the one u2-users list, some going as far as to only allowing them access to the digest, viewing it through their own portal, or distributing it to the blessed few. It's true they could access it at home or in their dorm but with so many road blocks put up and with so little traffic on the list, it isn't worth the hassle. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Get a grip
Man, I didn't realize that posting my opinion about the U2U would have ended up in a cyber war. Being a user, sometimes contributor, U2UG Presidential candidate, and someone that does influence buying products for the company I work for, I don't care what the subject line contains because most of the information on this list is helpful in some way. I think that if the subject is a full blown ad for a product it should be posted in the subject line just so those that don't want to be tainted by the possibility of learning when new products are available. But if the information is an answer to a problem and just happens to be a product that is sold or provided by the individual trying to help, I see no reason to post it as an ad. For those people that think this list is purely technical, I've got news for you, it's not. This is the main list for the U2 Users Group. This means that sometimes things discussed on this list are not technical but information provided to the community as a whole. To help us stay with the game. Yes, there is an u2-community list but, to be frank, it is hardly ever used. All forms of multi-value product users and vendors are welcome to participate but it is still the only way of getting free, practically instantaneous, information to U2 users. -Original Message- From: Clifton Oliver [mailto:[EMAIL PROTECTED] Sent: Thursday, September 06, 2007 1:05 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Get a grip - was ads - was U2 University Last Week In Denver Chuck, please forgive me if it looks like I'm jumping into a Moderator issue; that is not my intent! As a private citizen and consultant and ex-list-host, I'd like to address this current discussion. I think that list members like Tony G and Susan J are being unfairly castigated (no R in there, so chill) for their postings. First, a brief summary of history: I hosted the u2-users list for 9+ years. It was a growing experience for all of us. We eventually hit the point where the Geeks didn't want to have their list defiled with anything non-technical. About the same time, the IBM contributors were dropping out because of the noise-to-signal ratio. That's when we split the non-technical discussions off to a different list, u2-community--much to the verbal dismay of some people yet unto this day. At the same time, the [ad] tagging was introduced to allow the purist geeks to avoid anything smelling like Real World Marketing. The usage of the tags has changed slightly since I turned the reins over to U2UG, but the intent seems to be the same. Now for the Cyber-Spanking (yes; I'm the one who coined the term): Tagging is a voluntary thing. Some people will do it, some won't. Most will try, but forget, or be inconsistent. For heaven's sake, people are human. They forget. They don't think in terms of, how can I write this in order to pussyfoot around the greatest number of underpaid geek's raw nerve endings? Yes, I've noted that Tony and Susan and others mention their services and products in their postings. So what? If you don't like it, hit the delete key. Set up a spam filter to trash their postings. Ignore their suggestions that usually proceed mention of their products (thus willfully ignoring free advice in the process). If you hate their postings, filter them. If you don't know how to do that, you really, really shouldn't be allowed access to the Internet. Let me rain on your sanctimonious parade a little bit more: In the almost ten years I hosted the list, I was asked many times, what do you get out of this? I had calls from IBM wondering what financial or marketing advantage this gave me. The answer? NONE. To my colleagues on the list who run their own businesses--don't worry about it. In 9+ years of running the list, do you know how many sales/projects I got from the effort? ZERO! (It was a work of payback to the community.) My analysis was that 95% or more of the (mostly non-posting lurkers) of the list not only do not have the authority to sign a check, their opinions are not taken into account by management when purchasing decisions are made. So to the whiners about sales pitches on The List, want us to do a statistical analysis of your postings to see how much content or technical knowledge you contribute compared to what non-AD postings you receive? To the (very few) who do mention their services and products on the list, I ask a simple question: Are you getting enough (any) leads that make putting up with this abuse from the non-check-writing members worth your harassment? Just think about it. Are you more interested in free information exchange, or coercing people to post things YOUR way? -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ --- u2-users
RE: [U2] RE: Get a grip
I did both, on purpose. I didn't trim so, if they missed your post, they would have the opportunity to read it. And, as far as posting at the top, I was trying to make an overall point and not responding to any individual point you were making. Personally I would much rather read a person's thoughts at the top of the message and not have to parse down through something that I may have already read. If I have to rehash what was said before, I can always use the page down key. Jerry -Original Message- From: Clifton Oliver [mailto:[EMAIL PROTECTED] Sent: Thursday, September 06, 2007 10:45 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Get a grip (In an effort to introduce a little humor to cool things down:) Oh, oh, Jerry. You forgot to trim. And you top posted. Thank heavens you didn't use html, or there would be an armed militia headed your way. :-) -- Clif On Sep 6, 2007, at 6:31 AM, Jerry Banker wrote: Man, I didn't realize that posting my opinion about the U2U would have ended up in a cyber war. --- 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] RE: Get a grip - was ads - was U2 University Last
Dawn, I fully agree with you. I do belong to the u2-community list and from experience I can say that if a discussion is sent to community you may as well just say end of discussion. And, I have seen some discussions that should have been continued but died in this way. Jerry -Original Message- From: Dawn Wolthuis [mailto:[EMAIL PROTECTED] Sent: Thursday, September 06, 2007 11:23 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: Get a grip - was ads - was U2 University Last I agree, Jeff. That is my point with the suggestion that we eliminate u2-community and permit discussions like this one, even if not of interest to all. Let's move back/forward to a list where we permit discussions on all related topics and let people filter it themselves. Does anyone else agree with that or is this u2-community as a way to kill discussions and moderators needing to jump in too often due to all the rules (the moderators are just doing their jobs as defined), the way we want to run it? If I hear only silence, I will figure that I am in the minority with this opinion. Cheers! --dawn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 University feedback requested
Wally, Over all I think most of the discussions were great and very informative. The geeky classes were definitely geared toward geeks. The information about future developments was also great. The only class I attended that was a disappointment, to me, was DS2009 Basic Extensions: Your Key to Expanded Application Success. It didn't match what was listed in the brochure. It was not a discussion on the practical use of technologies like sockets, callhttp, xml, soap, and web services. It was more a discussion of what you could learn about these things if you attended the regular course offered by IBM. Most of the other events I attended showed what to do with the products they were covering. Jerry -Original Message- From: Wally Terhune [mailto:[EMAIL PROTECTED] Sent: Thursday, September 06, 2007 8:26 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 University feedback requested As a presenter and 'interested party', I'd love to hear feedback from anyone on the list who attended U2U in Denver (in addition to the comments from recent posters). (I didn't get a chance to review the written evaluations before Janet spirited them away with her to Sydney. :-( ) Thanks Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] Register today for the premier U2 technical event! [demime 1.01d removed an attachment of type image/jpeg which had a name of 2A913336.jpg] [demime 1.01d removed an attachment of type image/jpeg which had a name of 2A292787.jpg] --- 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] U2 University Last Week In Denver
I'd also like to add that everyone better start looking into Eclipse because some great things are going to be built on that platform. They are also looking to recruit developers and users for an advisory group. So, if you have some things you would like to see added to the products this is your chance. Jerry -Original Message- From: Kate Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 04, 2007 6:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 University Last Week In Denver Thanks for the feedback, Brenda. We are trying to decide which sessions to go to - any advice? Cheers, Kate - Original Message - From: Brenda Price [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, September 05, 2007 9:38 AM Subject: [U2] U2 University Last Week In Denver Just wanted to say it was a good event. Wish everything was ready now. Great stuff on the way. Anyone that can attend the rest of the events really should do so. Brenda Price Affiliated Acceptance Corp Sunrise Beach, MO --- 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] U2 University Last Week In Denver
Kate, Just about every course I took was outstanding. The tuning courses are great, the introductions to new advances let's you know that U2 is here to stay, and you also get the opportunity to get certified in programming and administration. Even if you were certified previously you can get certified on administration of the newer revisions of UniVerse and Unidata, as well as other IBM products. All-in-all I would say it was a great start to what I hope will be an ongoing thing. Jerry Banker -Original Message- From: Kate Stanton [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 04, 2007 6:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 University Last Week In Denver Thanks for the feedback, Brenda. We are trying to decide which sessions to go to - any advice? Cheers, Kate - Original Message - From: Brenda Price [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, September 05, 2007 9:38 AM Subject: [U2] U2 University Last Week In Denver Just wanted to say it was a good event. Wish everything was ready now. Great stuff on the way. Anyone that can attend the rest of the events really should do so. Brenda Price Affiliated Acceptance Corp Sunrise Beach, MO --- 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] U2 University Last Week In Denver
Did I say anything about an editor? They are building more than an editor using Eclipse. I don't want to steal their thunder but it appears that their whole front end will be built on Eclipse and we will have the ability to create our own plug-ins to add to it. I haven't tried your editor because I haven't needed to, I am happy with WED. -Original Message- From: D [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 05, 2007 10:21 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver Jerry, I'm confused. If you are so hot on Eclipse based tools why have you not tried our free U2 editor? It has been out for over year and half. That U2 Editor you saw at the U2 University will not be out until first quarter 2008 for Unidata and later for Universe. Here are the questions you should be asking. Is it backward compatible to Universe 9.6 or Unidata 6.1? We doubt it! Has it been tested by over 700 users? We doubt it! Has it been test on Mac, Windows, Linux and Fedora? We doubt it! Can you update the product using Eclipse's Update Manager? We doubt it! Does it work on Eclipse 3.3 and Eclipse 3.2? We doubt it! Does it run on Java 1.5 or 1.6? We doubt it! Can we test that Editor today in a real world environment? We doubt it! We are the only company in the U2 market that has the programming expertise and the years of experience that has been producing and selling Eclipse based tools. We are updating our U2 editor and other tools on a daily basis and giving them away. What are you waiting for? Regards, Doug -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, September 05, 2007 6:25 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] U2 University Last Week In Denver I'd also like to add that everyone better start looking into Eclipse because some great things are going to be built on that platform. They are also looking to recruit developers and users for an advisory group. So, if you have some things you would like to see added to the products this is your chance. Jerry --- 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] Spam to forum addresses - Endorsement for a solution
Well, let's see now, I get approximately 150 over the weekend and they end up in my junk folder. About 99% are filtered out. That's the number that got through our network filter. -Original Message- From: Allen E. Elwood [mailto:[EMAIL PROTECTED] Sent: Saturday, August 25, 2007 10:33 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Spam to forum addresses - Endorsement for a solution I get about 10 a day, but 95% of those end up in my ZoneAlarm junk mail or challenged mail folders. -Original Message- [mailto:[EMAIL PROTECTED] Behalf Of Ray Wurlod Nice idea, though I believe my heavy-duty spam filters must be working - I get very few. --- 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] ODBC drivers on RedHat Linux
We are trying to set up UniVerse 10.2 to talk directly to a SQL Server system. After following all of the directions in the UV manuals and the DataDirect docs we can talk to the SQL Server from Linux using the demo program that comes with DataDirect but are unable to connect using UV. As a matter of fact when we relink the library as it says in the UV BCI doc 1-8 we can no longer access the UV accounts and have to relink back to the uvdlls. Jerry -Original Message- From: Andy Pflueger [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 8:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC drivers on RedHat Linux Sorry to reply with a question, but... What specific database are you looking to connect to/from through ODBC under Linux? On 8/21/07, Brenda Price [EMAIL PROTECTED] wrote: Does anyone know of an ODBC driver that plays nice with Linux. We currently have an evaluation copy of DataDirect 5.3 and are struggling to get it to work with RedHat Linux Release 3 x86.64 2.4 21-32.EL. --- 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] ODBC drivers on RedHat Linux [ad]
We want UniVerse to be the client, is that what your product will do? We don't seem to have any problem getting the data from UniVerse, just getting the data from SQL Server using UniVerse. Jerry -Original Message- From: Janet Bond [mailto:[EMAIL PROTECTED] Sent: Thursday, August 23, 2007 11:38 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC drivers on RedHat Linux [ad] Hi Jerry, FusionWare has a bridge product that will run right on Linux. You can call UV/BASIC subroutines to do the equivalent of READ, WRITE, SELECT, COPY(to and from SQL) and SQL Passthru to a SQL Server table as though it were a (single-valued) PICK file. If this would be of interest to you, please let me know and I can provide further information. Best Regards, Janet Bond FusionWare Corporation Sales Operation Manager 1.866.266.2326 x159 [ad] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Thursday, August 23, 2007 5:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC drivers on RedHat Linux We are trying to set up UniVerse 10.2 to talk directly to a SQL Server system. After following all of the directions in the UV manuals and the DataDirect docs we can talk to the SQL Server from Linux using the demo program that comes with DataDirect but are unable to connect using UV. As a matter of fact when we relink the library as it says in the UV BCI doc 1-8 we can no longer access the UV accounts and have to relink back to the uvdlls. Jerry -Original Message- From: Andy Pflueger [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 8:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ODBC drivers on RedHat Linux Sorry to reply with a question, but... What specific database are you looking to connect to/from through ODBC under Linux? On 8/21/07, Brenda Price [EMAIL PROTECTED] wrote: Does anyone know of an ODBC driver that plays nice with Linux. We currently have an evaluation copy of DataDirect 5.3 and are struggling to get it to work with RedHat Linux Release 3 x86.64 2.4 21-32.EL. --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Binary data corruption on copy
Universe doesn't have the noconvert command. -Original Message- From: David A. Green [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 22, 2007 8:06 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Binary data corruption on copy Harold, In UniData you would store your binary files in a DIR type file. When you need to read the data you would first issue the NOCONVERT ON Command to keep the auto conversion of Nulls to CHAR(128) from happening. Thanks, David A. Green DAG Consulting 480-813-1725 --- 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] Sacred Licence Seat - A Challenge
With device licensing do you use a different SYSTEM field than you do with non-device licensing. Jerry -Original Message- From: Dianne Ackerman [mailto:[EMAIL PROTECTED] Sent: Friday, August 17, 2007 8:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Sacred Licence Seat - A Challenge We put a program in the UV.LOGIN paragraph which checks the number of users logged on and if it's too many (we set a number a little lower than the number of licenses we have), we give a message to try again later. However, if the user logging in is our special user, we let them login anyway. -Dianne Jef Lee wrote: Does anyone have a way to set one licence seat as sacred? There are 15 users in the organization and 20 licences for UniVerse. But users will open more than one session if they can. We need one licence always available for when an internet connection is made. How do we keep one unused? Is there a UniVerse setting that prevents a seat from being taken locally? Has someone out there done this? Would you like to share the technique? Any suggestions? Jeffrey Lee Senior Analyst/Programmer --- 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] Sacred License Seat - A Challenge
Do you know that SYSTEM(35) doesn't change on the Red Hat Linux version? Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD Corrupt data
A quick way is to create a temporary hashed file large enough to hold all of the records. Next copy the records from the damaged file to the new file. The records with a bad ID will not copy. Then clear the original file or delete it and recreate it if you feel better about it. Lastly copy the records back from the temporary file. Jerry -Original Message- From: Burwell, Ed [mailto:[EMAIL PROTECTED] Sent: Monday, August 13, 2007 6:01 PM To: u2-users@listserver.u2ug.org Subject: [U2] UD Corrupt data I'm getting the following when I sort a file: sort: warning: first character of the record is '\0' discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! sort: warning: the record contain '\0' character, discard it! I know that there are some screwed up keys (maybe containing @FM's) but I can't figure out how to select them and delete them. I tried guide and it was no help. Thanks. Ed Burwell 973-361-5400 ext. 1512 973-615-9880 cell [EMAIL PROTECTED] __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.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] IBM - Windows Vista Support with U2 products
I heard on the radio this morning that Microsoft is going to announce a whole slew of security breaches on the new operating system today. -Original Message- From: Ross Ferris [mailto:[EMAIL PROTECTED] Sent: Monday, August 13, 2007 6:09 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] IBM - Windows Vista Support with U2 products G'day Chuck! Yes, I am successfully running Universe on a Windows Vista box :-) For a small consulting fee ... Ahhh, what the heck -- C H E A T ! Load up a copy of Virtual PC with Windows XP you are in business - will also let you run the 70% of other Windows programs that don't work with Vista (I even have to use it to access Outlook! Vista doesn't like something in my 3Gb profile, and I'm not inclined to find out what) It is interesting that even products like IE7 behave differently under Vista than XP - some of it is esoteric, but you know how we like to push the boundary. HTH Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Charles Barouch Sent: Monday, 13 August 2007 3:51 AM To: u2-users@listserver.u2ug.org Subject: [U2] IBM - Windows Vista Support with U2 products All, Is anyone running UniVerse PE successfully on Vista? I just bought (against my will) a Vista Home Premium system. PE installs and the shell works, but I don't seem to be able to create accounts or telnet to it. All help appreciated. http://www- 1.ibm.com/support/docview.wss?rs=629context=SSCRY4dc=D600uid=swg2125 4 814loc=en_UScs=UTF- 8?=enrss=ct629db2_DARGS=/template_parts/template_U2.jhtml_A_DAV= http://www- 1.ibm.com/support/docview.wss?rs=629context=SSCRY4dc=D600uid=swg2125 4 814loc=en_UScs=UTF- 8lang=enrss=ct629db2_DARGS=/template_parts/template_U2.jhtml_A_DAV= - Charles Barouch [EMAIL PROTECTED] Consulting --- 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/
{Blocked Content} RE: [U2] Format Issue with AE
Warning: This message has had one or more attachments removed Warning: (not named). Warning: Please read the AngelicHost-Attachment-Warning.txt attachment(s) for more information. That doesn't happen with the UV version. -Original Message- From: Ron Hutchings [mailto:[EMAIL PROTECTED] Sent: Tue 8/14/2007 8:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Format Issue with AE rellevel 10.0.11 PICK PICK.FORMAT One of the developers using AE noticed a strange result. After making some modifications and Formatting the result, the subroutine labels that were previously mixed case were converted to all upper case. Is this just a feature of AE or is there some configuration setting that can be changed? Ron Hutchings _ See what youre getting intobefore you go there --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This is a message from the MailScanner E-Mail Virus Protection Service -- The original e-mail attachment winmail.dat was believed to be infected by a virus and has been replaced by this warning message. If you wish to receive a copy of the *infected* attachment, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Tue Aug 14 06:58:38 2007 the virus scanner said: Could not parse Outlook Rich Text attachment Note to Help Desk: Look on the AngelicHost MailScanner in /home/virtual/site2/fst/var/spool/mail.quarantine/20070814 (message l7EDwbNM022020). -- Postmaster MailScanner thanks transtec Computers for their support --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Speeding up a big BY.EXP select
But then it wouldn't be as much fun. :-) -Original Message- From: Clifton Oliver [mailto:[EMAIL PROTECTED] Sent: Saturday, August 11, 2007 1:13 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Speeding up a big BY.EXP select GEEZ people. Why don't you just ask the computer rather than debating it? And recognize that the U2 platforms differ depending on the flavor the account is in. Us old timers (33 years in MultiValue) need to remember that everything you think you know is wrong. On Aug 10, 2007, at 8:41 PM, MAJ Programming wrote: My premise was that SSELECT FILE BY @ID BY FIELDNAME SSELECT TEST_FILE BY @ID BY FIELDNAME EXPLAIN Optimizing query block 0 Driver source: TEST_FILE Access method: file scan Sorted by: @[EMAIL PROTECTED] UniVerse/SQL: Press any key to continue or 'Q' to quit is not the same as SSELECT FILE BY FIELDNAME. SSELECT TEST_FILE BY FIELDNAME EXPLAIN Optimizing query block 0 Driver source: TEST_FILE Access method: file scan Sorted by: [EMAIL PROTECTED] UniVerse/SQL: Press any key to continue or 'Q' to quit 0 record(s) selected to SELECT list #0. --- 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] UVTSORT config parameter
I'll answer part of this. We were having trouble with creating pipes and they asked us to turn off multi-threading as a possibility that it may have been a problem on our Linux server. The selects may have been taxing our resources. Most modern systems can handle multi-threading but some of the older systems may not. Since UV defaults to multi-threading you may have to turn it off. Jerry -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: Friday, August 10, 2007 9:52 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UVTSORT config parameter Dear Messrs. Dreyfuss, Oliver, Wurlod, gurus all, My original request was for words of wisdom. History lessons count. The older I get, the more I value them. Thank-you. But I was more interested in the future (my own): - Why would I enable multi-threading? (UVTSORT 1) - Why would I disable multi-threading? (UVTSORT 0) - If 1 is always right, why did IBM make it configurable by the user? - What symptoms would make me suspect I have it wrong? - How would one test it? - Is there any documentation? Cherishing your every word, Chuck P.S. I'm anticipating upgrade to HP Itanium, HPUX11.23, UV 10.2.5. I assume multi-threading sorting applies there, although it wasn't stated. -Original Message- From: LeRoy Dreyfuss Thx Mr. Oliver. I recall our pal Pete Simonson telling me that some years ago. Just didn't want to stick my neck too far out without some caution :-) -Original Message- From: Clifton Oliver Yes. According to my conversations with DG, the project was referred to as Firestorm and had DG's affinity throughout. Not sure, but I believe VMark had DG do the actual development for affinity. --- 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] Speeding up a big BY.EXP select
I'm not exactly sure how the programming is done on this but from the outside it is all relative to how you look at it. Let's take the statement: SSELECT CUSTOMERS BY NAME BY CITY In one way it can be seen as: Sort by name with each name sort by city with each city sort by key. In another way of looking at it: Sort by key go through the list pulling out, but retaining the key order, sorting the cities then, retaining that order, sort by name. Either way if you throw a BY @ID in there the SSELECT becomes redundant and the SSELECT is done for no reason. Jerry -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 6:24 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Speeding up a big BY.EXP select Jerry: Are you sure. Please make sure that what you are saying is correct. The SSELECT statement has traditionally sorted on the @ID last for the last 30 years. It would be news to me to learn that it sorts BY @ID automatically first because of the double S in SSELECT. Thus SSELECT FILE BY CITY should be different than SSELECT FILE BY @ID BY CITY as the first would gather all the records BY CITY then within each CITY, they would be sorted by @ID (the default). Using @ID anywhere but the last sort field (or implied) would not make sense as they are guaranteed to be unique and not need a tie breaker. Please check again. Thanks Mark Johnson - Original Message - From: Jerry Banker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, August 09, 2007 9:39 AM Subject: RE: [U2] [UV] Speeding up a big BY.EXP select The way I see it the first one will take longer than the second, although it would have to be a large file you are selecting on. The reason would be that the first one sorts the ID's, redundantly, twice before it gets to the BY.EXP whereas the second one sorts by the ID only once. -Original Message- From: Boydell, Stuart [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 2:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Speeding up a big BY.EXP select I have a large file with an MV set I need to do an exploding sort against (about 2 million records, about 20 MVs per record). I'm not actually after any particular sort order but it's taking hours. I'm wondering if there is any efficiency advantage by telling it to use a primary sort on the ID or just to sort on the MV attribute? My (probably flawed) reasoning is that if the primary sort is on the id then the sort process wouldn't have to build up one big explode - as it would have a primary sort by record, it then only needs to explode each record at a time. Eg. SSELECT BIGFILE BY @ID BY.EXP MV.ATTRIBUTE Or SSELECT BIGFILE BY.EXP MV.ATTRIBUTE Anyone know the answer to that one? Stuart Boydell ** 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 communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Speeding up a big BY.EXP select
The way I see it the first one will take longer than the second, although it would have to be a large file you are selecting on. The reason would be that the first one sorts the ID's, redundantly, twice before it gets to the BY.EXP whereas the second one sorts by the ID only once. -Original Message- From: Boydell, Stuart [mailto:[EMAIL PROTECTED] Sent: Thursday, August 09, 2007 2:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Speeding up a big BY.EXP select I have a large file with an MV set I need to do an exploding sort against (about 2 million records, about 20 MVs per record). I'm not actually after any particular sort order but it's taking hours. I'm wondering if there is any efficiency advantage by telling it to use a primary sort on the ID or just to sort on the MV attribute? My (probably flawed) reasoning is that if the primary sort is on the id then the sort process wouldn't have to build up one big explode - as it would have a primary sort by record, it then only needs to explode each record at a time. Eg. SSELECT BIGFILE BY @ID BY.EXP MV.ATTRIBUTE Or SSELECT BIGFILE BY.EXP MV.ATTRIBUTE Anyone know the answer to that one? Stuart Boydell ** 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 communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- 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] U2 University
I'm going to the U2 University in Denver the last week of this month, any others attending? Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Credit Card Processing
PCI compliance is the bugger here. If your company doesn't have the resources (money) to become compliant you won't get your credit cards processed. The best bet for a company that doesn't have the resources is to send the cards through one of the available credit card processing companies that have become compliant or soon to be compliant. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 06, 2007 2:42 PM To: u2-Users Subject: [U2] Credit Card Processing Hi all, Does anyone have any good recommendations for credit card processing companies? Currently our company does not accept credit cards but will be doing so in the near future as we open a new store front. It would be nice to come up with a solution that I could easily interface to our Universe 10.1 business application. Thanks much, Scott Thompson Lead Programmer Southern Wine Spirits of Illinois --- 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] UniData 7.1 vs. MS SQL 2005 performance
So what you are saying is that relational theory, since it is not proven, in essence does not exist. :-) Jerry -Original Message- From: Dawn Wolthuis [mailto:[EMAIL PROTECTED] Sent: Friday, July 20, 2007 9:56 PM To: u2-users@listserver.u2ug.org So, when Date or Codd uses the term relational theory they do not mean that it is something that is not yet proven, they are referring to doing pure mathematics. --dawn --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
AMEN!! -Original Message- From: Smith, Robert [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 8:14 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Good Morning, I really enjoyed reading this thread. I can honestly say that the diversity of experiences and people who comprise this listserv is amazing. And I've found the shared knowledge to be invaluable. As one who has not been immersed in the U2 environment for an extended period of time, there is one item that serves as a continued source of frustration. And it's exactly what Phil mentions below...sparse documentation. Not only for new stuff, but also for what I consider to be general items. More than once I have had a problem and through research, found that a PDF containing possibly pertinent information could be obtained from the IBM web site. Knowing it was there did me absolutely no good at all. Because my connection to the U2 world is through our software vendor, IBM has consistently refused to acknowledge/honor any request that I've made for information. And based upon the feedback I have gotten at times from the vendors support center, they (the support center) has a equ! ally difficult time extracting U2 information from IBM. And it's not like there are selves full of books on U2 that I could turn to for research...at least not that I've seen. I can go to any major book store and find two or three selves of books on MS SQL and NONE on U2. This was particularly frustrating when I was first getting started with U2 four years ago. How could there be no books? Regardless of the bookstores I've visited over the years, the results has always been the same. I have since learned that, outside of spending thousands of dollars to go to vendor sponsored training classes (and receiving their training books), the best way to learn about things in this environment is through the listservs...word of mouth...trial and error. For one who has spent a considerable amount of time (with past systems I've supported) over the years plowing through technical manuals learning the nuances of how to best work with a product, being denied that information is very ! frustrating. The only consolation are listserves such as this one. The U2 industry is ill served by what I perceive to be an informational void relative to the product. And the tragedy is that this is a really good family of products. Very worthy of recognition along with the other major players in the RDBMS arena. Something should be done to free up this log-jam. And the first thing that would be really helpful is if IBM allowed both their direct customers AND the clients of those customers (such as myself), direct access to all aspects of the critical information contained upon their web site. Maybe then people will start writing books about U2. My two cents, Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of phil walker Sent: Tuesday, July 17, 2007 4:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Nick, Here, here to your following statements To me, this is part of the problem that we have in the MV world. We look at how things are being done elsewhere and say, Pick does it better, we aren't going to do that. The problem with this approach is that everyone else is adopting these standards and using them. We are going to be left further behind if we don't start using some of the technologies available to us. . And this is where this list breaks down in that a lot of the new features IBM are building into the product are not used/discussed and the documentation is VERY, VERY sparse. So people like myself and a few others are left to trial and error techniques to implement these new technologies because we HAVE to talk to the outside world and people expect some sort of standard method to do this. Because of this approach we take a lot longer to do something which I am sure is reasonably easy if one was to have good quality examples available like most other dbms/development environments have on the web Phil (my 2c) Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dawn Wolthuis Sent: Monday, July 16, 2007 11:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance I do understand the advantages to that approach, Nick. But that was also the thinking of those who prepared the current industry benchmarks by locking in on SQL. My concern was that if you specify technologies, you can make it difficult for solutions that are outside the box. --dawn On 7/16/07, Nick Cipollina [EMAIL PROTECTED] wrote: If the consumer of this data is going to be external, then I would definitely use web services. Using a standard format (SOAP) will make it possible for anyone to consume the data. Thanks, Nick Cipollina -Original
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
I was looking at our bookshelf, we have the old series of soft cover manuals from V-Mark on UniVerse and then we have several books on PICK, none of which is new. Our PICK books are from 1985 to 1990 mostly published by TAB Professional and Reference Books, one is from Hayden Book Company; Exploring the PICK Operating System by Jonathan E. Sisk and Steve VanArsdale. The TAB books are: PICK for the IBM PC and Compatibles by John W. Winters, PH.D and Dale E. Winters; Programming with IBM PC Basic and the PICK Database System by David L. Clark; PICK Basic A Programmers Guide by Jonathan E. Sisk; The PICK Perspective by Ian Jeffery Sandler; PICK for Professionals Advanced Methods and Techniques by Harvey E. Rodstein and lastly, The PICK Pocket Guide by Jonathan E. Sisk. This last one I think has stopped many people at the airport luggage check. Although they are old they still come in handy especially when training new people. It would be nice to have newer books to choose from with more updated programming techniques, applications, and languages. As Alice's Restaurant says, With circles and arrows and a paragraph on the back of each one saying what they was all about. Jerry -Original Message- From: Charles Barouch [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 8:58 AM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Robert, There is a firmly held belief that if books were available, that we, as a group, are too cheap to buy them. Clif Oliver (who ran this list for 9 years) used to edit a Pick series of O'Reilly. When I contacted Tim O'Reilly about a year ago, proposing new MV books, he said that he'd love to, but he can't afford to lose that kind of money. If you want books, we need to commit to publishers. I'm sure Brian would be willing to put up a sign-up sheet on U2UG.org, so we can submit a list of people who promise to buy at least one copy if a publisher will print a new book. I think a pre-order of 1K copies would get us some traction. Are we willing to spend $15 to $50 a piece for a new U2 book? I don't think they'll have trouble finding willing writers. -- Charles Barouch [EMAIL PROTECTED] - Consulting (718) 762-3884x1 --- 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] RE: books
Doesn't Malcolm Bull still publish books? -Original Message- From: Tony Gravagno [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 11:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: books Charles Barouch wrote: If you want books, we need to commit to publishers. I'm about to self-publish a book called Using DesignBais. Printing the 300 page book with good quality paper, images, nice binding, etc, costs about $50 per copy. I have to pay for many books to be shipped to me, and I will ship to anyone who orders so my cost of business goes up a little there. The end-user cost of the book will be $200 per copy, which is further weighted to account for the lack of volume in our community. I originally apologized for the price but given the specialized content I've not heard a single complaint about the price. In fact I'm pleasantly overwhelmed at the excitement this offering has generated and I'm encouraged to do more. So, we don't really need publishers who need guarantees of much larger volumes. I share this experience in the hope that some other author might be interested in following the same path to write and self-publish user-friendly books or booklets on U2-related topics. This is specialized info we're after and I don't think there are many people here who would see this as anything other than a normal and necessary business expense, so from my recent experience I think such an effort would be rewarded. Getting advance orders should (arguably) be a standard operating procedure for some, maybe with some third-party taking orders/cash in escrow so to speak. With so many people saying they want something and then not ordering after extended development (been there, done that), the trust but verify strategy is hardly unjustified. Writing material like this takes months out of someone's life, and if material doesn't sell after that much effort, it's doubtful that this community will get many more chances to dangle the same carrot. HTH TG@ scribblescribblescribbleNebula-RnD.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] UniData 7.1 vs. MS SQL 2005 performance
I think what he is asking for are tips and tricks, example programs, troubleshooting guides with real world scenarios, how to get data in and out of other database from the U2 side as well as from the other side with examples. Books written in a conversational manner not in techno geek I'm leaving out the stuff you should already know because I do. -Original Message- From: Brutzman, Bill [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 12:07 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance The following eMail is not clear to me. IBM has comprehensive documentation on U2 available for free. What (specifically) is being sought that is not now available? --BIll -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Smith, Robert Sent: Wednesday, July 18, 2007 9:14 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Good Morning, I really enjoyed reading this thread. I can honestly say that the diversity of experiences and people who comprise this listserv is amazing. And I've found the shared knowledge to be invaluable. As one who has not been immersed in the U2 environment for an extended period of time, there is one item that serves as a continued source of frustration. And it's exactly what Phil mentions below...sparse documentation. Not only for new stuff, but also for what I consider to be general items. More than once I have had a problem and through research, found that a PDF containing possibly pertinent information could be obtained from the IBM web site. Knowing it was there did me absolutely no good at all. Because my connection to the U2 world is through our software vendor, IBM has consistently refused to acknowledge/honor any request that I've made for information. And based upon the feedback I have gotten at times from the vendors support center, they (the support center) has a equ! ally difficult time extracting U2 information from IBM. And it's not like there are selves full of books on U2 that I could turn to for research...at least not that I've seen. I can go to any major book store and find two or three selves of books on MS SQL and NONE on U2. This was particularly frustrating when I was first getting started with U2 four years ago. How could there be no books? Regardless of the bookstores I've visited over the years, the results has always been the same. I have since learned that, outside of spending thousands of dollars to go to vendor sponsored training classes (and receiving their training books), the best way to learn about things in this environment is through the listservs...word of mouth...trial and error. For one who has spent a considerable amount of time (with past systems I've supported) over the years plowing through technical manuals learning the nuances of how to best work with a product, being denied that information is very ! frustrating. The only consolation are listserves such as this one. The U2 industry is ill served by what I perceive to be an informational void relative to the product. And the tragedy is that this is a really good family of products. Very worthy of recognition along with the other major players in the RDBMS arena. Something should be done to free up this log-jam. And the first thing that would be really helpful is if IBM allowed both their direct customers AND the clients of those customers (such as myself), direct access to all aspects of the critical information contained upon their web site. Maybe then people will start writing books about U2. My two cents, Rob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of phil walker Sent: Tuesday, July 17, 2007 4:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Nick, Here, here to your following statements To me, this is part of the problem that we have in the MV world. We look at how things are being done elsewhere and say, Pick does it better, we aren't going to do that. The problem with this approach is that everyone else is adopting these standards and using them. We are going to be left further behind if we don't start using some of the technologies available to us. . And this is where this list breaks down in that a lot of the new features IBM are building into the product are not used/discussed and the documentation is VERY, VERY sparse. So people like myself and a few others are left to trial and error techniques to implement these new technologies because we HAVE to talk to the outside world and people expect some sort of standard method to do this. Because of this approach we take a lot longer to do something which I am sure is reasonably easy if one was to have good quality examples available like most other dbms/development environments have on the web Phil (my 2c) Nick Cipollina -Original Message- From: [EMAIL PROTECTED]
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
Over the last few years I have tried on several occasions to get access to the knowledgebase through my var and have been told that they would see about getting it for me. Last time was about 6 months ago, I'm still waiting. Which tells me either they haven't tried to get it for me or there is a problem getting it through IBM. -Original Message- From: Nancy Fisher [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 12:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance My var retrieved some info on setting up PDF from SB+ report writer for me one time. It was barely legible and not helpful. I was still glad to get it. VAR said they could try and get access for me but hadn't any success in the past... I never heard back. Still can't use HTML or PDF from (character based) SB+. I do recall hearing the VAR angle but my experience with our VAR didn't really support that. Nancy Fisher Peninsula Truck Lines, Inc Auburn, Washington 253/929-2040 [EMAIL PROTECTED] - Original Message - From: Brian Leach [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 18, 2007 9:42 AM Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance Nancy this was discussed in the past at great length! To summarize: When the U2UG was formed, we petitioned for IBM to open up their knowledge sources. The problem is their vars, some of whom do not want their users to get access (and presumably show up how p*ss p**r their support may be). So a compromise was reached - if the var agrees, you can get access. Of course, some vars won't - but then you could always buy a single user UV from a sensible and capable var who will. that's probably worth the cost of the material anyway. it's also one of the reasons we started the U2UG knowledge base - and we're about to launch a Wiki on the same site. Brian Why doesn't IBM allow access to all information that would help users - we've already bought the product? 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-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] UniData 7.1 vs. MS SQL 2005 performance
So what you are saying is that a shop like ours that has over the years developed everything in-house and the applications are specifically geared to our business and can be changed as our business changes is out of luck when it comes to getting into the knowledgebase. Just because we don't buy an application from anyone we are excluded from something that might help us build it better and faster. -Original Message- From: David Murray [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 1:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance And it is the reason that I would never recommend in-house software development with any U2 products. You will always be flying blind. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData 7.1 vs. MS SQL 2005 performance
Yes and no, yes to anything without a key next to it, which is usually nothing technical or helpful. The frustration comes from getting emails directly from IBM saying there is a white paper or tech bulletin that pertains to U2 with some pretty useful information, but when I follow the link to the paper, it is restricted and has that little key next to it. No matter how many different ways I log in I can't get to it. And, of course, I get an email from IBM that says I just tried to access something I'm not allowed to look at. It's not like I am depriving my var from anything. We buy the licenses to UV from them, have them set up our systems, and if there is a system problem we usually call them but that is the extent of our relationship. They don't sell a software product we can use. As a matter-of-fact we are a Linux/Unix shop and they deal mostly with Windows. -Original Message- From: David Murray [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 3:09 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance Jerry, Do you have currently have access to the knowledgebase? It is possible (as I have had access before), but access by an end-user seems to be the exception rather the norm. Is anyone from IBM in this mail list want to comment? Cheers, David Murray .learn and do .excel and share -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, July 18, 2007 2:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance So what you are saying is that a shop like ours that has over the years developed everything in-house and the applications are specifically geared to our business and can be changed as our business changes is out of luck when it comes to getting into the knowledgebase. Just because we don't buy an application from anyone we are excluded from something that might help us build it better and faster. -Original Message- From: David Murray [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 18, 2007 1:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniData 7.1 vs. MS SQL 2005 performance And it is the reason that I would never recommend in-house software development with any U2 products. You will always be flying blind. --- 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] UniData 7.1 vs. MS SQL 2005 performance
To me that is foolish. As a programmer you need to know how that database functions so you can program to its strengths and try to avoid its weaknesses. -Original Message- From: Geoffrey Mitchell [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 17, 2007 9:58 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniData 7.1 vs. MS SQL 2005 performance I don't have any idea what you are trying to say. A database should be a black box. You put data in and pull data out. The less you have to know about the details of what goes on inside, the better. You can easily benchmark two black box systems that perform the same function (with unknown implementations), and the results are totally relevant as a comparison of those two systems. Anthony Youngman wrote: Because the results are not (scientifically) reproducible. (Well, they are for that one implementation...) Because data storage is part of the Pick data model, we can be confident that benchmark results are valid across all (similar?) implementations. Because relational forbids knowing anything about the implementation, any benchmark is valid for that one configuration only. -- Geoffrey Mitchell Programmer/Analyst Home Decorator's Collection 314-684-1062 --- 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 Command Stack
Someone was asking about the command stack, on Universe there is the @COMMAND.STACK variable that has a dynamic array of the last 99 commands. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Unidata Printing Question
The Windows print driver would be used in this case. If you are sending control codes to the printer from Unidata then you will probably have to set the print driver up for RAW mode. Jerry -Original Message- From: Dave [mailto:[EMAIL PROTECTED] Sent: Saturday, July 14, 2007 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: Unidata Printing Question Unidata on Windows 2003. Jerry Banker [EMAIL PROTECTED] wrote: What are you running? -Original Message- From: KidFromBrooklyn [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 3:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Unidata Printing Question We tried different settings. Do you have any other ideas ? Jerry Banker wrote: Either your printers internal setup is different or the driver/script you are using on your system is different from the others. All I can say is, you have to do some changes to one or the other. -Original Message- From: Dave [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata Printing Question We have one HP printer here that is acting weird. When I enter SORT CUSTOMERS LPTR at TCL all of the printers here format the report properly. The font is compressed. One HP printer does not print compressed and page breaks prematurely. We are also running SB + here. - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --- 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/ -- View this message in context: http://www.nabble.com/Unidata-Printing-Question-tf4075390.html#a11586905 Sent from the U2 - Users mailing list archive at Nabble.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/ - Pinpoint customers who are looking for what you sell. --- 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 - Available memory exceeded
Is this some kind of virus? -Original Message- From: mark.hennessey [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 12:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - Available memory exceeded You have received an important delivery from mark.hennessey Please pick up the package at the following Web address: https://smail.ct.gov/ime?x=4-271240-178878-SS932YZF The package will expire on Wednesday August 15, 2007 at 13:22:42 EDT4 .. Need help picking up your package? * If the Web address above is highlighted, click on it to open a browser window. You will automatically be taken to the package. * If the Web address above is not highlighted, follow these steps: - Open a Web browser window. - Copy and paste the entire Web address into the location or address bar of the browser. - Press enter. ___ Delivered with IME(TM) http://www.tumbleweed.com IME is a trademark of Tumbleweed Communications Corp. --- 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] Stacker commands
It's only in the SAVEDLISTS file after you log out. While you are processing it is in one of the SYSTEM() fields. -Original Message- From: David Ward [mailto:[EMAIL PROTECTED] Sent: Monday, July 16, 2007 2:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Stacker commands SAVEDLISTS -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: Monday, July 16, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Stacker commands Hello, When the .L command is done at the TCL level, the last executed commands are shown. Anyone here know where those commands are stored ? Jacques G. Pinpoint customers who are looking for what you sell. http://searchmarketing.yahoo.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] Error code 2
The 'o' option is not available on Red Hat Linux 3. Is there a problem report that I can look at. And, yes any system administrator worth their salt is not going to use commands in the cron that will potentially cause the s..t to hit the fan. -Original Message- From: John Jenkins [mailto:[EMAIL PROTECTED] Sent: Thursday, July 12, 2007 3:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error code 2 Jerry It relates to the UniVerse user number (which is now DERIVED from the PID by a means of information reduction to cater for long PIDs). There are a maximum of 32K foreground processes and 32K PHANTOM processes. So you launch from crontab (a starting PID) and it generates a UV user number and attempts to attach to shared memory at that point (as root). The answer is (of course) sir - certainly - right on - love you root. Whether you see a problem is moot - it depends, but it's not a good idea (and root is not a good idea for other reasons as Doug mentioned). You MAY see a peripheral symptom of this: ipcs -mop|grep 0x Do you get these building up? Are they attached to the UV shared memory segment? (compare ipcs -mop output for aceb, acec and ). I'll try and force it tomorrow time permitting, but the system I have is not heavily loaded and replication is not guaranteed. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: 12 July 2007 13:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error code 2 John, You've said this before. Could you elaborate a little more on this? We run many tasks on cron as root and have never had any problems both with Solaris and Linux. Jerry -Original Message- From: John Jenkins [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 6:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error code 2 Karl I can't see enough from your posting, but if you are running UniVerse foreground processes from crontab as root then please don't especially AIX. Change to a non-root crontab Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 11 July 2007 15:07 To: u2-users@listserver.u2ug.org Subject: [U2] Error code 2 The following cron response came to me at 2:30pm in the day. We have programs that run at various times, but this is the first time I've seen this. What are the probable causes? TIA, Karl * BEGIN CRON EMAIL 1537 record(s) selected to SELECT list #0. A fatal error has occurred in UniVerse. Unable to re-open operating system file Error code 2 * cron: The previous message is the standard output and standard error of one of the cron commands. END CRON EMAIL --- 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-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] FW: HP Disaster Recovery video on YouTube
This is an excellent video getting lots of coverage (almost 5,000 hits/day) - showing failover from one datacenter to another, using HP Linux Clusters w/ServiceGuard, HP-UX Clusters w/ServiceGuard, NonStop clusters, VMSclusters, and Windows clusters - using StorageEssentials to easily show the storage topology before after. It starts out with a previous video showing a bullet shot through an XP12000 Storage Array that keeps running. http://youtube.com/watch?v=qMCHpUtJnEI http://youtube.com/watch?v=qMCHpUtJnEI --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata Printing Question
Either your printers internal setup is different or the driver/script you are using on your system is different from the others. All I can say is, you have to do some changes to one or the other. -Original Message- From: Dave [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata Printing Question We have one HP printer here that is acting weird. When I enter SORT CUSTOMERS LPTR at TCL all of the printers here format the report properly. The font is compressed. One HP printer does not print compressed and page breaks prematurely. We are also running SB + here. - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --- 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] RE: Unidata Printing Question
What are you running? -Original Message- From: KidFromBrooklyn [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 3:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Unidata Printing Question We tried different settings. Do you have any other ideas ? Jerry Banker wrote: Either your printers internal setup is different or the driver/script you are using on your system is different from the others. All I can say is, you have to do some changes to one or the other. -Original Message- From: Dave [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 10:32 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata Printing Question We have one HP printer here that is acting weird. When I enter SORT CUSTOMERS LPTR at TCL all of the printers here format the report properly. The font is compressed. One HP printer does not print compressed and page breaks prematurely. We are also running SB + here. - Get the Yahoo! toolbar and be alerted to new email wherever you're surfing. --- 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/ -- View this message in context: http://www.nabble.com/Unidata-Printing-Question-tf4075390.html#a11586905 Sent from the U2 - Users mailing list archive at Nabble.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] Error code 2
John, You've said this before. Could you elaborate a little more on this? We run many tasks on cron as root and have never had any problems both with Solaris and Linux. Jerry -Original Message- From: John Jenkins [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 6:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error code 2 Karl I can't see enough from your posting, but if you are running UniVerse foreground processes from crontab as root then please don't especially AIX. Change to a non-root crontab Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 11 July 2007 15:07 To: u2-users@listserver.u2ug.org Subject: [U2] Error code 2 The following cron response came to me at 2:30pm in the day. We have programs that run at various times, but this is the first time I've seen this. What are the probable causes? TIA, Karl * BEGIN CRON EMAIL 1537 record(s) selected to SELECT list #0. A fatal error has occurred in UniVerse. Unable to re-open operating system file Error code 2 * cron: The previous message is the standard output and standard error of one of the cron commands. END CRON EMAIL --- 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] [UV] Conversion code for week number
Fairly simple; The iconv opens up a worm hole sends the date information through to a super computer in the future which cranks out an answer and sends it back to the iconv a fraction of a second later. -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 8:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Conversion code for week number So we're guessing. I gotta believe that there's something to it instead of simply counting days, dividing by 365.25, carrying the 3, square root of October etc. How does 1/1/68 mean 'divide by 365.25'? Also, divide 'what' by 365.25 ? Considering how incredibly often the function is used and how blazingly fast it does its ICONVs and OCONVs, there must be something more to it. Thanks - Original Message - From: Timothy Snyder [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, July 11, 2007 12:06 PM Subject: RE: [U2] [UV] Conversion code for week number I know you said don't tell me it's the base date, but the date 1/1/68 was chosen for a reason - it means divide by 365.25 actually gives the right answer... Anybody that relies on that in code is bound to get a nasty surprise. There are dates for which that doesn't work. Try it with July 7, 2006. Today's date is 14437, a year ago was 14072. The difference is 365. Divide that by 365.25 and you get less than one year. The argument could be made that you could round it after the division, but that will throw other dates off. The bottom line is that this is not a safe way to accurately calculate an age - it's *almost* always right, but when that's not good enough, it shouldn't be used. Tim Snyder Consulting I/T Specialist U2 Lab Services Information Management, IBM Software Group --- 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] Copying from AIX box to Linux box
I'm sure you would unless you move them using uvbackup and uvrestore. Jerry -Original Message- From: Boydell, Stuart [mailto:[EMAIL PROTECTED] Sent: Thursday, July 12, 2007 8:18 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Copying from AIX box to Linux box Won't you still need to fnuxi the files when moving from RISC architecture to x86? Would doing a cpio to a file, compress the file, then burn the file to a cd, and using that cd on the linux box work for you? ** 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 communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- 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] Conversion code for week number
Zeller's Congruence finds the day of the week and, at least on UV, isn't the same as what we use. It is 0 - 6, 0 is Saturday, and UV is 1 - 7, 1 is Monday. -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 11, 2007 8:17 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Conversion code for week number SNIP Finally, what is the calculation that MV uses for its internal dates? (Don't bother telling me the base date, what's the calculation? I don't think it's Thirty days hath September...) I've heard it called Zeller's Congruence and I've looked it up but didn't get the direct connection to how our dates are incredibly fastly derived/converted. Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Disappearing Indexes on UniVerse
I have seen where the system automatically creates a new index when it encounters an error. I have two sets of indices right now on my system. We didn't create them so the system must have. I_CUST.HIST.XR00 I_CUST.HIST.XREF I_CUST.MS00 I_CUST.MSTR I've checked the SET.INDEX and the 00 files are the ones being used, the others were the ones we created. We do batch rebuilds of our indices at night so I guess they could have been created then. Resize may do it also. Jerry -Original Message- From: Bernard Lubin [mailto:[EMAIL PROTECTED] Sent: Sunday, July 08, 2007 6:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] Disappearing Indexes on UniVerse I have several instances of indexes disappearing. The symptom is as follows: The index file is still present at unix, but it looks like it has been re-initialised (It looks like someone has manually deleted the index, then re-issued the CREATE-INDEX without running the BUILD.INDEX) This seems to happen after we have run a RESIZE on the system. We do not disable the index prior to running the RESIZE command. But there have been instances of the index just disappearing when no RESIZE was done on the system. Our normal users do not have access to TCL, and no programs issues the DELETE-INDEX command. The indexing of a file can only be done by the system administrator. Has anyone experienced similar situation? If so, how did you resolve it? Any help/suggestion would be greatly appreciated. Bernard Lubin Development Department Reynolds and Reynolds --- 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] UD Backups - DBPAUSE for UniVerse?
This is one of many reasons to do all reading and writing to the database by using subroutines built on the database. -Original Message- From: Hona, David S [mailto:[EMAIL PROTECTED] Sent: Thursday, July 05, 2007 8:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Backups - DBPAUSE for UniVerse? If you want incomplete updates in your database backup, then continue without pausing your database updates... :) Since BASIC applications don't timeout in database read/write operations, it's not really an issue. As for being a 'feature' it is sort of like the scenairo you get with a record update lock contention issue, except with no clause to handle the 'pause'.. Therefore you application would just wait until it's update is serviced...external applications using APIs are a different kettle of fish. So the 'feature' bit being it's transparent to your application. It is what you want with legacy applications of all sorts of vintage. Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, July 06, 2007 10:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD Backups - DBPAUSE for UniVerse? Stephen: Is this kind of bogus or kind of a feature. Considering all the different ways connections can be made to the dbms, all kinds of software would/could be failing if backups are done during a dbpause timeframe. :-( So it really does mean backups have to be very complex with RAID configurations and implementations. Bill --- 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] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop.
No, it looks like he is trying to assign a name to a variable and then using that variable to hold the opened file which is illegal in the language. It may be possible with literal equates but I doubt it. The reason for the data type error is because the variable F.NAME was already defined as the variable F.:INV.FILES1,F and then he tries opening a file using that variable to hold the file variable: OPEN FILENAME TO F.NAME ELSE STOP 201, FILENAME -Original Message- From: Anthony W. Youngman [mailto:[EMAIL PROTECTED] Sent: Friday, July 06, 2007 1:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop. In message [EMAIL PROTECTED], Cliff Bennett [EMAIL PROTECTED] writes Hi Dave, I'm not sure what is the purpose of lines 9 and 10 (assigning values to FILE.NAME and F.NAME). F.NAME can be undefined until the OPEN statement places the file descriptor into it. I know you cannot have a MV list of file descriptors. Each must be a full variable. If you really want a list, you can use a subscripted array instead of a dynamic array. You could then use MATREAD to load the INV.FILES() array, place the -INV suffix on each element and then open the files to a subscripted F.NAME() array. This looks to me like it's just a test that the files can be opened ... The OPEN statement is reusing the same variable every time, so in order to open file 2 it's closing file 1, etc etc etc. Cheers, Wol Regards, Cliff - Original Message - From: Dave R To: u2-users@listserver.u2ug.org Sent: Thursday, July 05, 2007 1:47 PM Subject: [U2] OPEN FILENAME TO F.FILENAME ELSE STOP problem in a loop. I am trying to open a group of files from a list of files in the table file. Does anyone know how to make the constant in the open file statement work. I get the good old IMPROPER DATA TYPE error message when I try to read the file I opened with the code. In the mean time I will open each file separately . Thanks Dave. OPEN 'TABLE'TO F.TABLE ELSE STOP 201,'TABLE' READV INV.FILES FROM F.TABLE ,INVENTORY-FILES,1 ELSE CRT; CRT CANT FIND TABLE 'INVENTORY-FILES'; RETURN END CONVERT ',' TO @VM IN INV.FILES FDC = DCOUNT(INV.FILES,@VM) FOR F = 1 TO FDC FILENAME = INV.FILES1,F:-INV FILE.NAME = INV.FILES1,F F.NAME = 'F.':FILE.NAME OPEN FILENAME TO F.NAME ELSE STOP 201, FILENAME NEXT F * -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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 CREATE.FILE
Susan, The command is flavor dependent. Pick, Reality, and IN2 use: CREATE.FILE DATA filename mod,sep,type Prime and Ideal use: CREATE.FILE DATA filename type mod sep Jerry -Original Message- From: Susan Joslyn [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 12:36 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV CREATE.FILE Hello Group, Anybody know the syntax to create a DIR type file from a single command line execute on Universe? The helps says it's type, then modulo and sep - then gives the specific example CREATE.FILE DATA TEST 4 3 2 saying that this will create type 4 file with a modulo of 3 and a separate of 4, but when I type that exact command at TCL I get: CREATE.FILE DICT SJTEST7 4 3 2 Creating file D_SJTEST7 as Type 18, Modulo 4, Separation 1. Added @ID, the default record for RetrieVe, to D_SJTEST7. I've always just done it CREATE.FILE filename - then hit return and it prompts me. It does, by the way prompt for modulo first. But if I try to do THAT on the command line, as in CREATE.FILE SJTEST8 1 2 19 . I still don't get what I'm after: CREATE.FILE SJTEST8 1 2 19 Creating file SJTEST8 as Type 18, Modulo 2, Separation 1. Creating file D_SJTEST8 as Type 18, Modulo 1, Separation 1 Added @ID, the default record for RetrieVe, to D_SJTEST8 --- 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] Error Message
Is there any problem running processes on other operating system, Red Hat in particular? We have several cron jobs that run UV processes. -Original Message- From: John Jenkins [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 03, 2007 3:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error Message By any chance are you running on AIX and launching UniVerse foreground processes from root crontab? If so - please don't.. you can get oddities at best. There were some changes associated with PHANTOMs - which version are you on? Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Karen Bessel Sent: 03 July 2007 16:56 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error Message Hmmm, I don't think that's the case here, but thanks for your reply. I had several phantom threads running concurrently - all were running the same program and all produced an identical error message. The spooler entry# would not be the same on different phantom ports/threads, and I don't think that the program was generating printed output. Normally, with a spooler entry# (even with a phantom), I'll see: Spooler Entry # -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: Tuesday, July 03, 2007 11:37 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Error Message Karen It's normally a spooler entry number. Brian UniVerse Rel 10.1 I received the following error message: Message[001467] with no associated error text. I cannot find any references to it in the ERRMSG file. Is there anyone out there who can shed some light on this? --- 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-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] [AD] UniVerse Programmer needed in New Jersey
No, they're looking for a woman :-) -Original Message- From: john reid [mailto:[EMAIL PROTECTED] Sent: Friday, June 29, 2007 7:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] UniVerse Programmer needed in New Jersey 'Must be able to mutitask' Is that like having the capability to alter the biocharacteristics of a task, sort've on the fly?' Just kidding john On 6/28/07, Barry Rogen [EMAIL PROTECTED] wrote: Position: Full time, permanent U2 programmer Environment: UniVerse, residing on HP systems Location:Northern New Jersey Experience Level: 1 - 5 years Type Business: Manufacturing Requirements/Expectations: Must be able to mutitask and work in a challenging, fast paced environment. EDI knowledge is necessary. Terrific opportunities for technical growth and training. Solid programming skills expected. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt --- 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] [AD] UniVerse Programmer needed in New Jersey
1-5 years experience with UV, yes. We have trained a few here. But usually they have experience with other languages. I have also worked in colleges that have work study programs for students; they work with it, and learn it, in most cases it's Unidata. -Original Message- From: Charles Barouch [mailto:[EMAIL PROTECTED] Sent: Friday, June 29, 2007 12:03 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] UniVerse Programmer needed in New Jersey Ron, Actually, I train new programmers. The problem is that most new people don;t know there's a community, so we don't meet them. There's actually a lot of new blood. We just have to find them and invite them inside. - Chuck Ron Hutchings wrote: Has anyone actually run across someone with only 1-5 years experience? __ From: Jerry Banker [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] [AD] UniVerse Programmer needed in New Jersey Date: Fri, 29 Jun 2007 08:28:22 -0500 No, they're looking for a woman :-) -Original Message- From: john reid [mailto:[EMAIL PROTECTED] Sent: Friday, June 29, 2007 7:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [AD] UniVerse Programmer needed in New Jersey 'Must be able to mutitask' Is that like having the capability to alter the biocharacteristics of a task, sort've on the fly?' Just kidding john On 6/28/07, Barry Rogen [EMAIL PROTECTED] wrote: Position: Full time, permanent U2 programmer Environment: UniVerse, residing on HP systems Location:Northern New Jersey Experience Level: 1 - 5 years Type Business: Manufacturing Requirements/Expectations: Must be able to mutitask and work in a challenging, fast paced environment. EDI knowledge is necessary. Terrific opportunities for technical growth and training. Solid programming skills expected. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat.t. roosevelt --- 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/ _ Need a break? Find your escape route with Live Search Maps. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Charles Barouch ([EMAIL PROTECTED]) www.KeyAlly.com (718) 762-3884 x 1 P. O. Box 540957, Queens, NY 11354 --- 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] Device Licensing
Does it work with ssh? -Original Message- From: John Jenkins [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 3:46 PM To: u2-users@listserver.u2ug.org Subject: [U2] Device Licensing As others have posted: Device Licensing works for both U2 databases as long as you have a license which is one of: * Workgroup * Enterprise * Server with device licensing (a recent offering) In order that this will work you need a TELNET client that supports Device Licensing, and as there have been some changes in DL internals over time they should also concurrent in release - ideally (of course) the latest releases or fairly close. IBM supply SBClient, wIntegrate and Dynamic as Telnet clients that work with DL - on wIntegrate and DC you need to remember to check the Use Device Licensing on Unix check box if that is you server platform. DL will also work with UniObjects and ODBC (for example) thought you should read up on the use of subkeys for UO. Some 3rd parties have arrangements with IBM to use the DL software libraries with their software, and they offer DL compatibility with their TELNET clients. It is worth noting the point above though, DL internals have changed over time. You might find that older versions of the TELNET clients may not work correctly froma DL viewpoint with more recent copies of the databases. That being the case then an upgrade from your friendly local TELNET client provider to a current build with updated software should resolve it. Issues which got in the way in the past related mostly to combinations of stty settings in Unix, all (even vaguely) recent versions got the code modified so that's not an issue. There was also an issue more recent) where ODBC sessions (for example) used a different DL user pool to TELNET sessions. So ODBC would allow up to 10 sessions as one license, and TELNET would do the same - but each connection would use a separate slot. In those circumstances (for example) one UO and one TELNET would take 2 licenses (fixed). Always a useful test - try using Dynamic Connect from the current client softwarethat should work fine and act as a check on any 3rd party software. Hoping this answers any queries - please post if any follow-ups. Regards JayJay --- 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] The best way to access SQLServer from UV
I know this question has come up before but there have been many new developments in Universe including a whole new release so I'm going to ask it anyway. Also I know that it sometimes it's a matter of what you have been taught. What is the best way to get information to and from a SQLServer database using Universe Basic? I would prefer to hear about built in features and not outside sources. Not that I don't appreciate that you guys have some wonderful products but we have a fully qualified staff of programmers here and other than the operating systems we have pretty much developed everything we have in-house. We are running Red Hat Enterprise Linux AS release 3 with uniVerse 10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server and most likely the latest version of SQLServer. We are not opposed to upgrading the Linux or uniVerse if that would give us more to work with. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV [not-secure]
Basically it has to do with PCI. We are putting all of our card data on a secure encrypted SQLServer so we can access the data from all of our applications. The records will most likely be in one table and we will want to read the data, record by record, or write it, record by record, using UV. Or, get/put, whatever the term being used. It has to be real time and as fast as possible, up to 5,000 cards a minute, as we do now. -Original Message- From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables? --- 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] Basic developments reverse engineering tool ?
Something like PRC? Contact Susan through http://www.sjplus.com/ -Original Message- From: Herve Balestrieri [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 10:23 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Basic developments reverse engineering tool ? To clarify the inquiry : I am seeking for a tool reading Basic source code modules and producing a technical documentation of an application automatically. This is not the purpose of an object code decompiler. Thanks Herve' Balestrieri There was UN-Basic that took compiled code and reverted it back to source code. My 1 cent Mark Johnson - Original Message - From: Herve Balestrieri [EMAIL PROTECTED] Does it exists a (marketed?) tool for MV databases (i.e UniVerse) that would allow to make the reverse engineering of an application, based on automated Basic source code analysis ? Thanks for any information. --- 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] The best way to access SQLServer from UV
Yes, I'm told it will be SQL Server 2005 on Windows 2003. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:55 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV The best way - I cannot answer that... Sorry. I think somebody will suggest ODBC... So I should let him/her explain it. :) I assume when you said Latest version, you mean SQL Server 2005. http://technet.microsoft.com/en-us/library/ms191274.aspx Microsoft SQL Server 2005 provides native XML Web Services through the SQL Server 2005 Database Engine by using the following open standards: HTTP, SOAP, WSDL, blah, blah, blah... So maybe you can use Universe's callHTTP. Good Luck! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Wednesday, June 27, 2007 9:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] The best way to access SQLServer from UV I know this question has come up before but there have been many new developments in Universe including a whole new release so I'm going to ask it anyway. Also I know that it sometimes it's a matter of what you have been taught. What is the best way to get information to and from a SQLServer database using Universe Basic? I would prefer to hear about built in features and not outside sources. Not that I don't appreciate that you guys have some wonderful products but we have a fully qualified staff of programmers here and other than the operating systems we have pretty much developed everything we have in-house. We are running Red Hat Enterprise Linux AS release 3 with uniVerse 10.1.12 Reality flavor. The SQLServer will be on a Windows 2003 Server and most likely the latest version of SQLServer. We are not opposed to upgrading the Linux or uniVerse if that would give us more to work with. Jerry --- 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] The best way to access SQLServer from UV [not-secure]
Strange, I never received a reply from you. -Original Message- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 11:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] Jerry Sorry I send my previous reply before seeing this post. I was thinking of the bulk update side. Brian Basically it has to do with PCI. We are putting all of our card data on a secure encrypted SQLServer so we can access the data from all of our applications. The records will most likely be in one table and we will want to read the data, record by record, or write it, record by record, using UV. Or, get/put, whatever the term being used. It has to be real time and as fast as possible, up to 5,000 cards a minute, as we do now. -Original Message- From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables? --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The best way to access SQLServer from UV [not-secure]
Our universe system is accessed too directly from the web for us to qualify for PCI compliance. We also have other places that contain card data, like contract images, and we access the data from more than just UV. So we have to put all of this data on a more secure system in only one place. Lock it down and encrypt all of it. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 11:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] Any reason you're not putting it on a secure encrypted UV server? (I believe the latest version of UV does native encryption ... :-) If it's not a 1-1 record-row match, then SQL-Server will be unlikely to match UV for speed. Cheers, Wol -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: 27 June 2007 16:20 To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] Basically it has to do with PCI. We are putting all of our card data on a secure encrypted SQLServer so we can access the data from all of our applications. The records will most likely be in one table and we will want to read the data, record by record, or write it, record by record, using UV. Or, get/put, whatever the term being used. It has to be real time and as fast as possible, up to 5,000 cards a minute, as we do now. -Original Message- From: Hennessey, Mark F. [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] The best way to access SQLServer from UV [not-secure] snip What is the best way to get information to and from a SQLServer database using Universe Basic? /snip What do you plan on doing? Are you pushing small records to SQLServer, retrieving small records or pushing/getting large tables? --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly
Does the same thing happen when you use SELECT filename SAVING [UNIQUE] field NO.NULLS? I'm not on Unidata so I can't try it. Universe doesn't have the BSELECT command. @SYSTEM.RETURN.CODE only returns 0 on a select so we use @SELECTED which does return the full amount in the select list. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 25, 2007 4:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly My apologies for the poor job I did posting this. I sent it before I had completed the subscribe procedures. I blame it on my vacation. :-) Because of my mistake, I didn't get the replies. I had to get them from the list archive. Here are my replies to the replies: To Dave Davis, who said, If you were curious about the number of customers queried couldn't you just do a SELECT CUSTOMER first? I agree. Or, if you had done a previous select to whittle down the list, you'd already know how many records would be queried for the BSELECT. To David A. Green, who said, SYSTEM(11) returns number of items in the active select list. I think we should leave the @SYSTEM.RETURN.CODE as the number of records selected. @SYSTEM.RETURN.CODE is NOT the number of records selected. That is the problem. It is the number of records queried/polled, not the number of items returned in the select list. Those numbers will not be the same for a multivalued attribute or if the attribute is null and UDT.OPTION 59 is ON. Try this and see if you feel the same way about @SYSTEM.RETURN.CODE: EXECUTE 'UDT.OPTIONS 59 ON' CMD1 = 'BSELECT CUSTOMER WITH @ID GE 200 TAPES_RENTED' CRT CMD1 EXECUTE CMD1 IF @SYSTEM.RETURN.CODE GT 0 THEN CMD2 = 'DELETE TAPES' CRT ; CRT CMD2 EXECUTE CMD2 END SYSTEM(11) is our workaround. But it is a pain because: A) It is non-standard, i.e. not necessary for other SELECTs. B) It is not what the documentation says. BASR.pdf states that @SYSTEM.RETURN.CODE will contain the number of items in the select list. C) If the program reports errors, it must first check @SYSTEM.RETURN.CODE, and if okay then check SYSTEM(11). -Original Message- From: Moderator [mailto:[EMAIL PROTECTED] Sent: Friday, June 22, 2007 6:15 PM To: u2-users@listserver.u2ug.org; Dean Armbruster - 0018 HQ Subject: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly REPOSTED FOR NON-MEMBER ADDRESS: [EMAIL PROTECTED] I'd looking for feedback on @SYSTEM.RETURN.CODE as returned from BSELECT of a multivalue attribute. Run the following basic code in the UniData demo account: CMD = 'BSELECT CUSTOMER TAPES_RENTED' CRT CMD EXECUTE CMD CRT '@SYSTEM.RETURN.CODE = ':@SYSTEM.RETURN.CODE CLEARSELECT When I run it, I get: BSELECT CUSTOMER TAPES_RENTED 36 records selected to list 0. @SYSTEM.RETURN.CODE = 29 Note that 29 is the number of records in CUSTOMER; 36 is then number of items in the returned active select list. The questions: Is there any way a program could depend on @SYSTEM.RETURN.CODE being incorrect some of the time? Would anyone want @SYSTEM.RETURN.CODE to be the number records polled and not number of items in the returned list, even if the number of items returned is 0? IBM case #423086*USA UniData 6.1.18 HP-UX 11.11 ECLTYPE P UDT.OPTIONS 59 ON Dean Armbruster System Analyst Wolseley North American Division * 12500 Jefferson Avenue * Newport News * VA * 23602-4314 T: +1(757) 989-2839 * F: +1(757)989-2801 --- 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] UD Backups
I admit I don't know anything about NTBackup but over the years I have seen enough backups to wonder if your data is of a different type. Any backup will run slower if it has to open and close a lot of small files as opposed to large files. Is it possible that the UD server as several type 19 files with many small records and the other has large files. Are you using the PE version for this test because you don't seem to have much data if you aren't? -Original Message- From: Bill Haskett [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 11:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] UD Backups I've been testing NTBackup recently. There are some significant time delays in backuping up a UD system vs a plain Windows system. All servers run Windows 2003 Server Standard, updated several weeks ago. One server is an IIS web server using .NET while the other is a UniData server. There's not a lot of data so the time differences are pretty significant. Here's some info: ..now pausing the UniData dbms on Mon 06/25/2007 at 23:30:00.53 DBpause successful. ..now starting Windows NTBackup on Mon 06/25/2007 at 23:30:00.56 ..now resuming the UniData dbms on Mon 06/25/2007 at 23:52:02.06 DBresume successful. ..zipping (RAR) is now starting on Mon 06/25/2007 at 23:52:02.13 ..now ftp'ing files to storage server on Tue 06/26/2007 at 0:32:58.08 sftp put *.rar - remote /AsiAsp2/Asp2_20070625.rar OK Uploaded 160247944 bytes, 16 seconds, 9751593 bytes/second sftp quit The non-UD server shows: ..now starting Windows NTBackup on Mon 06/25/2007 at 22:55:01.28 ..zipping (RAR) is now starting on Mon 06/25/2007 at 22:59:34.23 ..now sftp'ing backup to ASI web server on Mon 06/25/2007 at 23:37:07.40 sftp put *.rar - remote /netdrive/archive/Ht1_20070625.rar OK Uploaded 989484797 bytes, 118 seconds, 8360665 bytes/second sftp quit As can be seen, the 160MB NTBackup is taking 22 minutes on the UD machine and only 4 minutes for the 990MB backup on the IIS/.NET machine. I'm guessing it has something to do with files in use. We really don't want UD shutdown for 22 minutes. When it starts growing we're going to have a real problem. Can anyone recommend a fast backup/compression product for a reasonable price? Thanks, Bill --- 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] Phantom from DOS
The best way to do that is to build a paragraph or sentence that kicks off the phantom then run it from the dos prompt. Example: The paragraph in the VOC file would be: TEST.PARA 0001: PA 0002: PHANTOM TEST.PROGRAM 0003: Q From the DOS prompt change to the Universe account and start the phantom: cd \testaccount \ibm\uv\bin\uv test.para -Original Message- From: David Ward [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 12:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] Phantom from DOS Is it possible to start a phantom from the DOS prompt? I'm running Universe/10.2 Thanks --- 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] Universe Phantom
That would use up the license for the length of the process. The only way to not use an additional license is to run a phantom from a process that is already using a license. If your business is this tight on licenses I would suggest you buy more. If your processes aren't running you're out of business. What's that worth to you? -Original Message- From: Kryka, Richard [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 1:57 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe Phantom Is it possible to issue a phantom from OS? I have several jobs that are run through the Windows scheduler. Simply set up a batch file, and schedule the job to execute the batch file. Sample batch file: echo start UniVerse End Of Day job cd IBM\uv bin\uvsh.exe RUN UVSOURCE END.OF.DAY echo finished with End Of Day Dick Kryka Director of Applications Paragon Financial Services a Division of Money Management International 303-632-2226 [EMAIL PROTECTED] --- 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] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly
The @SYSTEM.RETURN.CODE you describe is the same as it was on PI which also didn't have an @SELECTED. At least I don't remember one. Of course they didn't have a BSELECT either. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 26, 2007 2:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly SELECT with the SAVING keyword, with or without NO.NULLS, returned the correct value in @SYSTEM.RETURN.CODE, in my tests. I don't know or have Universe, so I could be wrong, but it appears you have an implied BSELECT, as demonstrated with the SAVING keyword. A BSELECT is, as quoted from the UniData UniQuery doc: BSELECT filename ['record_IDs'][selection_criteria] attribute [attribute...] The UniQuery BSELECT command retrieves data from a file into an active select list. Unlike the SELECT command, which retrieves only record IDs, BSELECT builds a list of the attributes you name in the UniQuery statement. You must name at least one attribute in the statement. In UniData, you can also do an implied BSELECT by following the same syntax as BSELECT in a SELECT command. UniData does not have @SELECTED. @SYSTEM.RETURN.CODE is normally an error code (if negative) or the number of items in the select list (if non-negative) for any executed UniQuery commands dealing with select lists. It is misbehaving for BSELECT. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, June 26, 2007 9:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly Does the same thing happen when you use SELECT filename SAVING [UNIQUE] field NO.NULLS? I'm not on Unidata so I can't try it. Universe doesn't have the BSELECT command. @SYSTEM.RETURN.CODE only returns 0 on a select so we use @SELECTED which does return the full amount in the select list. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, June 25, 2007 4:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: [UD] BSELECT @SYSTEM.RETURN.CODE anomaly My apologies for the poor job I did posting this. I sent it before I had completed the subscribe procedures. I blame it on my vacation. :-) Because of my mistake, I didn't get the replies. I had to get them from the list archive. Here are my replies to the replies: To Dave Davis, who said, If you were curious about the number of customers queried couldn't you just do a SELECT CUSTOMER first? I agree. Or, if you had done a previous select to whittle down the list, you'd already know how many records would be queried for the BSELECT. To David A. Green, who said, SYSTEM(11) returns number of items in the active select list. I think we should leave the @SYSTEM.RETURN.CODE as the number of records selected. @SYSTEM.RETURN.CODE is NOT the number of records selected. That is the problem. It is the number of records queried/polled, not the number of items returned in the select list. Those numbers will not be the same for a multivalued attribute or if the attribute is null and UDT.OPTION 59 is ON. Try this and see if you feel the same way about @SYSTEM.RETURN.CODE: EXECUTE 'UDT.OPTIONS 59 ON' CMD1 = 'BSELECT CUSTOMER WITH @ID GE 200 TAPES_RENTED' CRT CMD1 EXECUTE CMD1 IF @SYSTEM.RETURN.CODE GT 0 THEN CMD2 = 'DELETE TAPES' CRT ; CRT CMD2 EXECUTE CMD2 END SYSTEM(11) is our workaround. But it is a pain because: A) It is non-standard, i.e. not necessary for other SELECTs. B) It is not what the documentation says. BASR.pdf states that @SYSTEM.RETURN.CODE will contain the number of items in the select list. C) If the program reports errors, it must first check @SYSTEM.RETURN.CODE, and if okay then check SYSTEM(11). --- 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] Trigger(s) on distributed file
No, the DEFINE.DF command creates a data file and a dictionary. They are actual files on the disk. However you cannot access the type 27 data file. You can only list or add records if you have at least one part file added. The type 27 file has a modulus of 1. -Original Message- From: Anthony W. Youngman [mailto:[EMAIL PROTECTED] Sent: Saturday, June 23, 2007 4:32 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Trigger(s) on distributed file In message [EMAIL PROTECTED], Jerry Banker [EMAIL PROTECTED] writes We use distributed files and yes a master file is created. The DEFINE.DF command creates a type 27 file and a dictionary file is created that is a type 30 file. As a matter of fact we use the one dictionary for all of the part files. Ah. This gives me an idea. Did you explicitly create a master distributed file? I used to create them with the following sequence: CREATE.FILE DICT MASTER. CREATE.FILE DATA MASTER.1 DEFINE.DF MASTER. ADDING MASTER.1 PART 1 (or whatever the correct syntax is). I'm guessing that because I explicitly didn't create the data portion, it didn't get created ... :-) It still worked fine... Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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] Trigger(s) on distributed file
We use distributed files and yes a master file is created. The DEFINE.DF command creates a type 27 file and a dictionary file is created that is a type 30 file. As a matter of fact we use the one dictionary for all of the part files. -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Friday, June 22, 2007 6:02 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Trigger(s) on distributed file Odder and odder. I don't ever remember seeing a file at OS level with the name of a distributed master file. PI *or* UV. As implemented by Prime, iirc, any partfile could be used as a master to get the algorithm definition etc, and you were warned that a VERY QUICK way to corrupt your distributed file was to use FORCE with DESIGN.DF unless you knew exactly what you were doing - precisely because a part file could belong to multiple masters and if the masters weren't in sync the result was a terrible mess... Cheers, Wol -Original Message- From: phil walker [mailto:[EMAIL PROTECTED] Sent: 22 June 2007 11:20 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Trigger(s) on distributed file Sorry Wol, Yes, I did think you meant the Pick style multi-part, sorry about that. But as far as the distributed files as managed by DF they have always had a master file of type (27 or 41 - cannot remember which ) which was basically just a header and I think had the algorithms etc in them. Dave Meeks or Glenn Herbert could probably confirm if they are still around. Palmer Chapelle was the engineer who had most input in implementing them in UV from PI. Cheers, Phil -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, 22 June 2007 10:16 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Trigger(s) on distributed file Then things really are confusing ... I'm talking about the file-type introduced by Prime, and officially managed using the DEFINE.DF command. By multi-part, do you mean the Pick style NEW.ACCOUNT,PIOPEN type file? I'm certainly not thinking of those - they were never in PI and I've never had cause to use them. I wouldn't presume to know anything about them. Distributed files, as known on Prime, never to my knowledge had any physical existence other than as individual part-files. As far as I was aware, the UV implementation had similar characteristics ... Cheers, Wol --- 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] _PH_ ID
UV doesn't have the name on SYSTEM(48). The phantom ID on our system is a combination of the program name, the time, and the date. You could build the ID in the program using SYSTEM(12) and DATE(). PH.ID = 'programname_':FIELD(SYSTEM(12),'.',1):'_':DATE() Or PH.ID = 'programname_'@TIME:'_':@DATE -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, June 21, 2007 10:46 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] _PH_ ID If the HI program has been cataloged, though, you can do PHANTOM HI And the first _ field of the id would then be HI instead of RUN. You can then use the program name to find the ID in the PH file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of john reid Sent: Thursday, June 21, 2007 9:01 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] _PH_ ID Universe 10.x PHANTOM SQUAWK RUN JMRBP HI RUN_36022_14417 record has been created in the 'PH' file. Phantom process started with process ID 7408. On 6/21/07, Kevin King [EMAIL PROTECTED] wrote: Is there a way for a phantom to know the _PH_ item that it's output is being redirected to? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com http://www.precisonline.com/ ** Check out our FREE support forum at http://www.precisonline.com/forum/ http://www.PrecisOnline.com/forum/. --- 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/ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. --- 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] Unix cat help
Why not just use unibasic? Just copy the files to a type 19 file accessible from u2 and do what you want to do. -Original Message- From: Adrian Merrall [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 5:10 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unix cat help On 6/20/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi all, Hopefully there is a way to do this... I have 2 unix flat files that I want to merge into 1 file. I know that I can do something like cat file1 file2 | sort -o newfile. The problem is that once I have newfile loaded, I need to know where each line in newfile came from. I am hoping that unix has something similar to the REUSE() function so I can prefix each line with the filename. Here is an example of what I would like to get done. Scott, There is probably a shorter way to do this using awk or sed but that awk man page is still stuck on my things I should learn list. A couple of simple bash shell only solutions would be as below. infile=file1 outfile=/tmp/mynewfile for i in `cat $infile` ; do echo $infile*$i $outfile done or while read i ; do echo $infile*$i $outfile done $infile HTH Adrian --- 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/
[no subject]
I just came across what may be a bug in HASH.HELP. I ran HASH.HELP on a static hash file and it told me the smallest modulus should be 80015 (yes, not a prime number), smallest separation or 4, and the best type of 10. I then ran HASH.HELP.DETAIL on the same file and got 80021, 4, and 18 respectively. In this second case the modulus is a prime number. No changes were being made on the system because it is our test system and I was the only one on it at the time. This was on Solaris 8 running Universe 10.1.12 in Reality flavor. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV HASH.HELP error
Sorry I forgot the subject line the first time. I've also tested this on our Linux system running the same revision with the same results. Jerry -Original Message- From: Jerry Banker [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 20, 2007 8:58 AM To: u2-users@listserver.u2ug.org Subject: I just came across what may be a bug in HASH.HELP. I ran HASH.HELP on a static hash file and it told me the smallest modulus should be 80015 (yes, not a prime number), smallest separation or 4, and the best type of 10. I then ran HASH.HELP.DETAIL on the same file and got 80021, 4, and 18 respectively. In this second case the modulus is a prime number. No changes were being made on the system because it is our test system and I was the only one on it at the time. This was on Solaris 8 running Universe 10.1.12 in Reality flavor. --- 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] - Distributed Files
The DF header file doesn't contain any data. You can resize each of the part files individually. However if your algorithm is correct the files will probably be close to the same size. -Original Message- From: Moderator [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 7:50 AM To: u2-users@listserver.u2ug.org Cc: Dominion Subject: [U2] [UV] - Distributed Files REPOSTED FOR NON-MEMBER ADDRESS: Dominion [EMAIL PROTECTED] Hi, I'm looking at implementing Universe distributed files. We are moving a UV app from TRU64 to LINUX on Intel, and unfortunately that means we will lose the luxury of 64bit files. I've got the files converted to distributed files no problem, but I'm trying to get my head round file sizing. Do I need to maintain the file sizing against the DF header file, or against each of the part files defined within the DEFINE.DF ommand? Thanks BOUNCE NOTICE: Your recent post to our lists bounced because either you are not a member or because you are not signed up using the e-mail address which you used to post. To subscribe or resubscribe please visit http://listserver.u2ug.org/. - Charles Barouch, Moderator U2-Users, U2-Community, SBSolutions, RBSolutions --- 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] - Distributed Files
Who told you that you couldn't use 64 bit files? -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 19, 2007 8:14 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] - Distributed Files Maintain it against the part files (mind you, I'd just declare them DYNAMIC and let UV sort it out). In a distributed file, each individual part file is just an ordinary file, with a little bit of extra logic that hashes the ID to say is this record permitted in this file. You can treat the partfile exactly as if it were a normal file, except that any record that doesn't pass this test will suffer a write failure if you try to save it. If you open the header file, as you call it, then another extra bit of logic gets invoked that works out which partfile to write it to. Cheers, Wol -Original Message- From: Moderator [mailto:[EMAIL PROTECTED] Sent: 19 June 2007 13:50 To: u2-users@listserver.u2ug.org Cc: Dominion Subject: [U2] [UV] - Distributed Files REPOSTED FOR NON-MEMBER ADDRESS: Dominion [EMAIL PROTECTED] Hi, I'm looking at implementing Universe distributed files. We are moving a UV app from TRU64 to LINUX on Intel, and unfortunately that means we will lose the luxury of 64bit files. I've got the files converted to distributed files no problem, but I'm trying to get my head round file sizing. Do I need to maintain the file sizing against the DF header file, or against each of the part files defined within the DEFINE.DF ommand? Thanks BOUNCE NOTICE: Your recent post to our lists bounced because either you are not a member or because you are not signed up using the e-mail address which you used to post. To subscribe or resubscribe please visit http://listserver.u2ug.org/. - Charles Barouch, Moderator U2-Users, U2-Community, SBSolutions, RBSolutions --- 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] Index Problem
If I remember correctly, and tell me if things have changed, indexed I-descriptors and correlatives that do translates from other files do not update indexes. This is one reason for building indexes periodically. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: Tuesday, February 06, 2007 3:59 PM To: u2-users@listserver.u2ug.org Subject: Spam:RE: [U2] Index Problem Hi Brenda, 1. It is probably only necessary to rebuild the index(es) when you have a known corruption issue. I think all indexed fields (I-type or not) are (re-)evaluated with every write; U2 indexes are self-updating. 2. If BAD.ADDR is just used to identify bad addresses, consider changing the I-type to return either 1 or null, and create the index using the NO.NULLS option? 3. However, does the BAD.ADDR field exist for selecting and totaling? Else why not just index the BAD.ADD field itself? It's probably marginally faster to build/maintain an index on a real field than on an I-type field. OT question for the list: is the practice of rebuilding indexes (nightly?) common? Why? I use a lot of indexes on large and active files, and very rarely have to rebuild them. Rebuilding indexes on a periodic basis looks like a little too much of the belt AND suspenders mindset. Are the U2 databases really so un-reliable that we have to resort to these sorts of hacks? (Actually, IMO they are very reliable and no you don't.) /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Tuesday, February 06, 2007 10:38 AM To: u2-users@listserver.u2ug.org Subject: [U2] Index Problem Last night a process that sleeps until around 2-3 am, then wakes up and does a BUILD.INDEX CUST.MSTR ALL failed. One of the indices BAD.ADDR was locked and failed which stopped all the other indices from building. So when we came in this morning nothing had been done from that point on. I've changed the process to build each index one at a time instead of the ALL option, so if one fails the rest continues, which will slow it down somewhat but is safer. Plus only the indices that are correctives will be rebuilt. This happened before in May 2006 and I am pretty sure that it was the exact index (BAD.ADDR) that hung us. The dict is this: BAD.ADDR 1 I 2 IF BAD.ADD = Y THEN 1 ELSE 0 3 4 51R 6S BAD.ADD 1A 244 3Bad^253Add 4 5 6 7 8 9L 101 On our test system, I've changed BAD.ADDR, deleted the index, created the index, and built it again as I was wondering if it was having problems from using another dictionary item. Once a window of opportunity happens I'll do the same on our live system. 1I 2 IF @RECORD44 = Y THEN 1 ELSE 0 3 4 51R 6S No one really thinks that is going to matter but I'm grasping at straws. Any ideas? Brenda Price Affiliated Acceptance Corporation Sunrise Beach, Missouri --- 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] Inability to send to list
The other address I was using was an hotmail account. Because of the amount of spam that is generated from spammers phishing gmane (I believe) I didn't want my work email swamped. Unfortunately the list would send to the address but it wouldn't allow me to respond. I've had better luck with the hotmail account not getting spam than my personal or work accounts probably because most spammers know that we use those accounts to divert spam. Jerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony W. Youngman Sent: Monday, February 05, 2007 5:26 AM To: u2-users@listserver.u2ug.org Subject: Spam:Re: [U2] Inability to send to list In message [EMAIL PROTECTED], Tony G [EMAIL PROTECTED] writes Jerry wrote in a test: Just testing because the other address I was using wouldn't allow me to send replies to the list. Jerry This list went down in December and since then I have been unable to post using my normal address. Our mail server says the u2ug.org server is disconnecting unexpectedly. I tried subscribing with other addresses but the mail was similarly rejected. It seems that server specifically rejects inbound mail from some servers, maybe due to some new block list that was activated. I've sent a few notes to the mods and I believe they're looking into it, but in the mean time, based on this recent note from Jerry I suspect there are others who have been unable to post to the forum, and perhaps unsure about how to report the problem. To make this post I subscribed using a yahoo address that have only used for one other purpose. I am certain that now that this address is exposed I will be getting a lot of new spam, which is why I use sneakemail.com for forums rather than real email addresses. You might have noticed that, when Clif stopped hosting the list, I stopped posting from my work address. My office email server was on a vpn, with a 192.168/16 address. Any attempt to post was rejected because listserver.u2ug thought I was on its local lan, and it couldn't validate me as a to it local poster. That problem has been there for yonks. Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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] Saving daylight.
Seems kind of silly to me considering we will have to keep our lights on in the morning for a longer period of time and this is suppose to save energy?? People will be driving in the dark that normally don't which will cause more accidents. We will all have to buy new appliances that automatically change with the previous standard. That is the real reason for the change, new cash flow. Just like the change to HDTV, everyone needs to get a new TV by 2009 because that is when the switch is turn on to broadcast everything in HDTV and bye-bye old TV. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Monday, February 05, 2007 4:49 PM To: u2-users@listserver.u2ug.org Subject: Spam:RE: [U2] Saving daylight. The fact that they've changed when daylight savings starts and ends shouldn't have any different impact on U2 apps than they already would. Only time it would is if an app has been written specifically to compensate for the extra hour. It should have been written to use GMT, instead, but that's a whole different can of worms. The reason is exactly what you said. Time is a function of the OS, not the DB. But I've been told I was wrong before. I didn't believe them, but I've been told :-) BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Monday, February 05, 2007 1:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] Saving daylight. Worried management is asking verification that UV RedBack will be ok with the upcoming savings time change to the start end dates. But I don't see any statement to that effect. I don't think see how it would be a problem inherent in U2, since dates and times are resolved by the OS. The only place I think they'd possibly have a chance to screw it up would be under transaction log restores or data replication. Maybe RedBack, when figuring out how old a request from a web client is. IBM's main support page, www-306.ibm.com/software/data/u2/support/ , has this: Flash 14 Nov, 2006: Impact of Changes to Daylight Savings Time (DST) in U.S. and Canada ( www.ibm.com/support/docview.wss?rs=686context=SSKJMPdc=D600uid=swg212 49374loc=en_UScs=UTF-8lang=en ) which says that u2 web de clients should be ok, even though the java behind it has time zone issues. IBM U2 Web DE and IBM U2 data server Clients currently ship with older versions of the JRE . No issues exist with the U2 Clients or U2 Web DE as they do not call time functions. One might think silence on the subject of the servers, RedBack, etc. implies that the rest are ok. It doesn't. Unless the title Impact of Changes to Daylight Savings Time (DST) in U.S. and Canada is taken to mean ALL impact. Does anyone else have nervous managers to appease? Has anyone figured out where they are going to put all that daylight that they'll be saving for those extra few weeks. I am going to put it in with the whales that my wife has been saving. cds --- 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] Index files
You're setting NO.NULLS on that field, could this be your problem. By the way, what are you using for your email? You can hardly read the message with all of the =0D=0A codes in it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Franklin Sent: Wednesday, August 02, 2006 3:49 AM To: u2-users@listserver.u2ug.org Subject: [U2] Index files We are running UniVerse 10.1.7 and use indexing on a number of files.=0D=0A Randomly on one of the files we keep loosing the index on the same=0D=0A field, PHYS.PALLET.ID.=0D=0A =0D=0A =0D=0A =0D=0A Index name Type BuildNulls In DICT S/M Just Unique Field=0D=0A num/I-type=0D=0A =0D=0A =0D=0A =0D=0A PHYS.PALLET.ID DNot Reqd No Yes SL N6=0D=0A =0D=0A TRUCK.ID DNot Reqd No Yes SL N8=0D=0A =0D=0A ORDER.NO DNot Reqd No Yes MR N1=0D=0A =0D=0A WAYBILL.UMC DNot Reqd No Yes SR N9=0D=0A =0D=0A WAYBILL DNot Reqd No Yes SL N14=0D=0A =0D=0A =0D=0A =0D=0A So SELECTINDEX fails, has anyone experienced similar problems. The data=0D= =0A in the fields is always of the form 4A4N and there is a one to one=0D=0A relationship between the field and the primary key.=0D=0A =0D=0A =0D=0A =0D=0A Regards,=0D=0A =0D=0A Tim=0D=0A =0D=0A =0D=0A Legal Disclaimer:=0A The information contained in this message may be privileged and confident= ial. It is intended to be read only by the individual or entity to whom i= t is addressed or by their designee. If the reader of this message is not= the intended recipient, you are on notice that any distribution of this = message, in any form, is strictly prohibited. If you have received this m= essage in error, please immediately notify the sender and delete or destr= oy any copy of this message=0D=0A --- 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] [u2][uv]HTTPS requests with createSecureRequest
Why not ask Wendy at [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Donnie Jacobs Sent: Friday, July 28, 2006 4:31 PM To: u2-users@listserver.u2ug.org Subject: [U2] [u2][uv]HTTPS requests with createSecureRequest Hi all, I'm trying to do web requests with https and the createSecureRequest functions un UniVerse. Below is a sample that I copied from the PICKWIKI, which I believe was originally posted by Wendy Smoak. Once I get this example working, I need use the secure functions to do credit card processing. We've tried everything we know of to try and get this to work on our servers. When we set the VerificationStrength to generous, everything is fine. But if we set it to strict, we can get it to complete. I'd prefer to use the strict setting and know that things are being verified the way that they should be. We've tried with no certificates. We tried saving the IBM certificate onto the unix box by itself and passing the absolute path name to the .cer file into the addCertificate function. We tried saving both the IBM and the Equifax certificates onto the unix box and then passing just the directory name containing both into the addCertificate function. It's latest complaint is that there's a self-signed certificate in the chain. (See below for the log file) Universe 10.1.12, PICK Flavor, UNIX (Sun O/S) If anyone has any experience with this or could offer any insight / thoughts, I'd sure appreciate it. EQUATE CRLF TO CHAR(013):CHAR(010) EXECUTE SH -c 'rm DLJ.HTTP.LOG' X.LOG.FILE = 'DLJ.HTTP.LOG' X.LOG.ACTION = 'ON' X.LOG.LEVEL = '10' X.RTN.CODE = protocolLogging(X.LOG.FILE, X.LOG.ACTION, X.LOG.LEVEL) CRT 'protocolLogging: ':X.RTN.CODE X.RTN.CODE = setHTTPDefault(VERSION, 1.1) CRT 'setting VERSION to 1.1 : ':X.RTN.CODE X.RTN.CODE = createSecurityContext(X.CONTEXT, '') CRT 'createSecurityContext: ':X.RTN.CODE URL = https://www-927.ibm.com/software/data/u2/support/u2techconnect/; POST.DATA = X.CERT.PATH=/cubs/winxfer/Certificates/IBMTechSupport.cer * changed next 2 lines from 1 to 2 per IBM X.USED.AS=2 ; * Used as an issuer certificate X.FORMAT=2 ; * DER format X.ALGORITHM=1; * RSA key X.RTN.CODE = addCertificate(X.CERT.PATH, X.USED.AS, X.FORMAT, X.ALGORITHM, X.CONTEXT) CRT 'addCertificate: ':X.RTN.CODE *X = addAuthenticationRule(X.CONTEXT,2, VerificationStrength, generous) *CRT 'VerificationStrength addAuthenticationRule = ':X X.DEPTH = 2 X.SERVER.OR.CLIENT = 2 ; * CLIENT X.RTN.CODE = setAuthenticationDepth(X.CONTEXT, X.DEPTH, X.SERVER.OR.CLIENT) CRT 'setAuthenticationDepth: ':X.RTN.CODE HTTP.METHOD=POST X.RTN.CODE = createSecureRequest(URL,HTTP.METHOD,X.HANDLE,X.CONTEXT) CRT 'createSecureRequest: ':X.RTN.CODE X.RTN.CODE = submitRequest(X.HANDLE,'',POST.DATA,X.RESPONSE.HEADERS,X.RESPONSE.DATA,X .HTTP.STATUS) CRT 'submitRequest: ':X.RTN.CODE CRT 'X.RESPONSE.HEADERS = ':X.RESPONSE.HEADERS CRT 'X.RESPONSE.DATA = ':X.RESPONSE.DATA CRT 'X.HTTP.STATUS = ':X.HTTP.STATUS X.LOG.ACTION = 'OFF' X.RTN.CODE = protocolLogging(X.LOG.FILE, X.LOG.ACTION, X.LOG.LEVEL) CRT 'protocolLogging: ':X.RTN.CODE LOG FILE 07/28/2006 16:06:58 setHTTPDefault ... name=VERSION, value=1.1 07/28/2006 16:06:58 set default HTTP version: 1.1 07/28/2006 16:06:58 createSecurityContext ... version= 07/28/2006 16:06:58 security context 46d8d0 allocated 07/28/2006 16:06:58 addCertificate ... certPath=/cubs/winxfer/Certificates/IBMTechSupport.cer,usedAs=2,format=2 ,algorithm=1 07/28/2006 16:06:58 loading CA-cert file: /cubs/winxfer/Certificates/IBMTechSupport.cer 07/28/2006 16:06:58 setAuthenticationDepth ... depth=2,s_or_c=2 07/28/2006 16:06:58 createSecureRequest ... 504cb0: URL=https://www-927.ibm.com/software/data/u2/support/u2techconnect/,meth od=POST 07/28/2006 16:06:58 setRequestHeader: standard header Content-Type=application/x-www-form-urlencoded 07/28/2006 16:06:58 new header Content-Type added with value application/x-www-form-urlencoded 07/28/2006 16:06:58 current Request date: Fri, 28 Jul 2006 21:06:58 GMT 07/28/2006 16:06:58 submitRequest ... Var 504cb0: host=www-927.ibm.com,timeout=0 07/28/2006 16:06:58 Assembled Request: POST /software/data/u2/support/u2techconnect/ HTTP/1.1 Date: Fri, 28 Jul 2006 21:06:58 GMT Host: www-927.ibm.com User-Agent: IBM UniVerse 10.x Content-Length: 0 07/28/2006 16:06:58 HTTP_START 07/28/2006 16:06:58 HTTP_CONNECT 07/28/2006 16:06:58 new host 509950:www-927.ibm.com:443 allocated (proxy:no) 07/28/2006 16:06:58 host www-927.ibm.com:443 not found in hostList 07/28/2006 16:06:58 socket 466640 allocated 07/28/2006 16:06:58 start SSLbinding ...
RE: [U2] [UV] Read Error, Improper Data Type
I spotted at least 2 errors in your program. One is the locate where you are locating on the first field but inserting into fields. It should be: locate Part in Part.Arrayby 'AL' setting posn else null insPart before Part.Arrayposn If you want to insert into a field array and locate Part in Part.Array1by 'AL' setting posn else null insPart before Part.Array1,posn if you want to insert into a multi-value array. The second is the for next loop where you are doing: for Part.Count and a next This.Part This.Part is a variable defined as This.Part = Part.ArrayPart.Count This may actually be what is giving you the error. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: Thursday, July 27, 2006 11:12 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] [UV] Read Error, Improper Data Type I am having a problem with a straightforward read statement that is driving me crazy... Suggestions would be appreciated. --Bill ____ \_ SLANG _/ Common Names for HK.Parts _Slang.Name___ 6 record(s) selected to SELECT list #0. 101312 0 101485 0 101859 0 103468 0 103469 0 103543 0 101312?101485?101859?103468?103469?103543 ***101312*** Program SLANG.R0: Line 77, Improper data type. Variable previously undefined. Zero length string used. *=== === *R0 Bill Brutzman Jul.2006 prompt '' open 'IM' to F.Item else null *--- -- crt @(-1) crt crt crt crt crt crt crt crt ' _ ' crt ' / \ ' crt ' \ SLANG / Common Names for HK Parts ' crt ' \___/ ' : @(-5) crt crt ' ~ 10 sec' : @(-6) crt crt '' : *--- --- clear equate true to 1, false to 0 equate AM to char(254) done = false print Part.Array = '' gosub Print.Header *--- -- clearselect ALL execute SELECT IM WITH SLANG.NAME # '' loop readnext Part else done = true until done do Print.Line =' ' Print.Line := Part 'L#6' : ' ' Print.Line := Slang.Name crt Print.Line locate Part in Part.Array1by 'AL' setting posn else null insPart before Part.Arrayposn Next.Step: repeat crt crt Part.Array crt All.Parts = dcount(Part.Array, AM) for Part.Count = 1 to All.Parts This.Part = Part.ArrayPart.Count crt '***' : This.Part : '***' read R.Item from F.Item, This.Part else R.Item = '' Slang.Name = R.Item11 if Slang.Name = '' then go Next.Step next This.Part *--- --- Exit.Prompt: crt @(0,22) : @(-4) : ' [X] ' : input Ans, 1 Ans = upcase(Ans) begin case case Ans = 'X' ; go The.End case 1 ; go Exit.Prompt end case go The.End: *--- -- Print.Header: crt @(-1) crt ' ____ ' crt ' \_ SLANG _/ Common Names for HK.Parts ' crt Print.Line = ' _HK.PN' Print.Line = '_Slang.Name___' print Print.Line print return *--- -- The.End: crt @(-1) END --- 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] Printqueue question
If they are HP printers or can be seen by the WebJetAdmin then you can use the Web JetAdmin software from HP. It will notify you when you are set up as one of the printer administrators. It's also free. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Tuesday, July 25, 2006 2:18 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: [U2] Printqueue question I am looking for some suggestions on how to get an email notification from AIX when a print queue goes down rather than splashing an error message all over the user's SB+ screen. Has anyone done this before? I have an elaborate cron job set up to check the queues, parse the output and send a message if there is a problem. This just isn't fast enough anymore, I don't want too many crons sucking down system resources and it confuses the users when their SB+ screen looks strange. Any suggestions would be greatly appreciated Thanks, Jeff --- 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] Select Lists in Proverb
Look at the REQUIRE.SELECT or SELECT.ONLY keywords. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carl Sadlier Sent: Thursday, July 20, 2006 10:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Select Lists in Proverb I need to be able to see if a select returns any ids before doing another select list in a proc. Here is the code I am using: O SELECTING OPEN ORDERS TO PROCESS HSSELECT ORDERS.ON.HOLD WITH HOLD.TYPE = MRAHL AND CURRENT.HOLD # OK IF A3=ALL G 75 H AND WITH HOLD.DATE GE A3 H AND WITH HOLD.DATE LE A4 75 H SAVING OWID P C HSSELECT OW WITH CO = A2 C The problem is if the ORDERS.ON.HOLD file doesn't return any ids the OW file returns all of its ids. If there are no records in the ORDERS.ON.HOLD file then I just want to stop processing the proc. Thanks, Carl --- 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] RE: CPU Hi-Jackers
I meant it in the technical term mentioned by the others not in the derogatory sense. I assure you that I am not of that ilk. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, July 19, 2006 2:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: CPU Hi-Jackers really now cracker is a derogatory term for a WASP or white person. -Original Message- From: Wendy Smoak [SMTP:[EMAIL PROTECTED] Sent: Wednesday, July 19, 2006 10:40 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SOX question (United States only, I believe) On 7/19/06, Horn, John [EMAIL PROTECTED] wrote: To distinguish from hacker who is someone who breaks into systems for fun and the challenge of it. A cracker does it for malicious purposes. Nope. Hacker is not a pejorative term... it's properly applied to people who make stuff work often for fun. * http://en.wikipedia.org/wiki/Hacker See also: Care and Feeding of your Hacker http://web.demigod.org/~zak/geek/hack.shtml 0.0: Won't my hacker break into my computer and steal my trade secrets? No. Hackers aren't, contrary to media reporting, the people who break into computers. Those are crackers. Hackers are people who enjoy playing with computers. Your hacker may occasionally circumvent security measures, but this is not malicious; she just does it when the security is in her way, or because she's curious. The Cathedral and the Bazaar http://www.catb.org/esr/writings/cathedral-bazaar/ -- Wendy --- 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] SOX question (United States only, I believe)
But doesn't this leave the information readily available to the friendly neighborhood cracker? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon J Glorfield Sent: Tuesday, July 18, 2006 10:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SOX question (United States only, I believe) Document everything! Make no changes without a written request from the users. Have them test and approve the changes, in writing, after completion. Store your documentation in a format that is readily accessible to the auditors. Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 07/18/2006 10:18:48 AM: Hi, I have been reading this thread and others with interest, but no one has managed to answer how you can be SOX compliant when you have only one guy who programmes, administers, upgrades the software and makes the tea! Any suggestions anyone? Cheers, Ray Dawes Manufacturing Systems Manager CarnaudMetalbox Engineering plc, Dockfield Road, Shipley, BD17 7AY, UK Email: [EMAIL PROTECTED] Tel: 0 (+44) 1274 846283 Fax: 0 (+44) 1274 846201 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the confidential use of the above named recipient. If you are not the intended recipient or person responsible for delivering it to the intended recipient, you have received this communication in error and must not distribute or copy it. Please accept the sender's apologies, notify the sender immediately by return e-mail and delete this communication. Thank you. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SOX question (United States only, I believe)
Exactly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Walker Sent: Tuesday, July 18, 2006 1:48 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] SOX question (United States only, I believe) The friendly neighborhood cracker isn't a threat. It's only the employees that can't be trusted. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jerry Banker Sent: Tuesday, July 18, 2006 1:51 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SOX question (United States only, I believe) But doesn't this leave the information readily available to the friendly neighborhood cracker? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon J Glorfield Sent: Tuesday, July 18, 2006 10:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] SOX question (United States only, I believe) Document everything! Make no changes without a written request from the users. Have them test and approve the changes, in writing, after completion. Store your documentation in a format that is readily accessible to the auditors. Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 07/18/2006 10:18:48 AM: Hi, I have been reading this thread and others with interest, but no one has managed to answer how you can be SOX compliant when you have only one guy who programmes, administers, upgrades the software and makes the tea! Any suggestions anyone? Cheers, Ray Dawes Manufacturing Systems Manager CarnaudMetalbox Engineering plc, Dockfield Road, Shipley, BD17 7AY, UK Email: [EMAIL PROTECTED] Tel: 0 (+44) 1274 846283 Fax: 0 (+44) 1274 846201 CONFIDENTIALITY NOTICE The information contained in this e-mail is intended only for the confidential use of the above named recipient. If you are not the intended recipient or person responsible for delivering it to the intended recipient, you have received this communication in error and must not distribute or copy it. Please accept the sender's apologies, notify the sender immediately by return e-mail and delete this communication. Thank you. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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-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] UV - tech support
Why does IBM send me alerts that document information is available but after I get on their site they won't let me read it. I have a couple of different logins on their site and I never know which one is necessary to get to where. Why not have one login that allows you to get to what they want to let you get to and have done with it? One way I log in it's my email address and a special IBM assigned user ID, another is a user name created by me with a password created by me, and then there is another screen that asks for a user ID and password but it isn't any that I have already mentioned. Yes I have a support contract with IBM but the contact letter/number combination seems to change yearly and the IBM site keeps telling me that the contract number is not valid. When I do get logged in the sites display my name and company name correctly so what is the problem. Jerry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - tech support
Here, here! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Results Sent: Friday, July 07, 2006 1:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV - tech support A few notes: The problem with IBm is that IBM isn't IBM. It is a series of IBM-lets with separate management, budgets, constraints and objectives. The IBMers on this list won't likely take up this challenge because it is out of their jurisdiction. The only people who could address this are levels above our fellow community members. Here's what I would do: Get a petition to people who are going to the IOD (IBM Information On Demand) conference. Make it clear, clean, and non venomous. Get a lot of signatures, especially from people who are related to IBM. I'll suggest the text: === As active customers, VARs, consultants, and Partners of IBM, we are frustrated by the lack of a single login for accessing information from the IBM website. We having such a single login would decrease phone support calls and would speed resolution of customer issues, resulting in more satisfied customers at a lower cost per incident to IBM. We the undersigned see an obvious value to us in this approach and hope that you will see it, too. _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ === Oh, and I'm going to the IOD conference and I would be honored to carry forward a clear, clean, *polite* petition. I can't assure you that I will find the right person to receive it, but I can commit to trying. How about it, people? - 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 Web Product
That's the new name for Redback. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 27, 2006 8:47 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 Web Product Apologies, but never heard of it. What is it? Karl quote who=Cooper, Rudy Hello List, I was curious if anyone was using IBM's U2 Web DE 4.3 product ? If so I wanted to know what you thought about the product. I know I could read about it on IBM's page, but I want to get someone's opinion who is using it. Thx, Rudy Rudy Cooper Technical Project Lead Sage Publications Information Technology Development (805) 410-7724 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- 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] MICR fonts with UniData
I thought you wanted it printed from Unidata? -Original Message- From: John Varney [mailto:[EMAIL PROTECTED] Sent: Monday, June 26, 2006 9:29 AM To: Jerry Banker Subject: RE: [U2] MICR fonts with UniData I wish I could do it that way, but the checks are coming directly from a unix box via a routine that uses PCL5 to format blank stock. As far as I can tell I have to either use a laser printer with the MICR font permanently installed or use an MICR soft type font that is loaded to the printer via PCL5 commands each time a check run is done. I was wondering if anyone else has done anything like this and if they would share HOW they did it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Login Paragraphs
I've found that if a login paragraph starts getting too complicated it's best to start using a program. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul Sohn Sent: Tuesday, June 20, 2006 4:01 PM To: u2-users@listserver.u2ug.org Subject: [U2] Login Paragraphs I'm trying to set the TIMEOUT value for a user in the LOGIN paragraph based on the first few characters of the user ID but I don't know how to check for partial matches. I'm doing: PA TIMEOUT 600 IF @LOGNAME = jsmith THEN TIMEOUT 1200 IF @LOGNAME = psohn THEN TIMEOUT 3600 I would like to add something like the below but I'm not sure of the syntax: IF @LOGNAME[1,2] = rf THEN TIMEOUT 2400 Paul --- 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 PORT.STATUS...
Try this in the /bin directory: -r-sr-sr-x 37 root bin 5256 Jan 5 2000 ipcs -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: Friday, June 09, 2006 12:50 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV PORT.STATUS... Solaris 8, UV 10.0.8 We have restored after a disk crash. Since the restore PORT.STATUS only works for the user invoking it, not for the others on system. I immediately checked /.uvhome/bin for list_readu... only to find the setuid bit is still set: -rwSr-xr-x 3 root other2923468 Sep 24 2002 list_readu What else could be wrong? Mark Hennessey State of Connecticut DSS/MIS Child Support Systems Voice: 860-424-5261 Fax: 860-424-4956 --- 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] Transfer Files from UNIX to NT
I have found that the easiest way is to do a UVBackup to a file, copy it to the new server with ftp or better yet if you can mount the file system do a cp or copy, then UVRestore the file. The restore does the conversion so fnuxi is not necessary. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Haas, John Sent: Monday, June 05, 2006 2:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Transfer Files from UNIX to NT Does anyone have any advice on the easiest route to copy files from Universe 9.6.1 (HP-UX) to Universe 10 on Windows 2000. 1. T-Dump/T-Load 2. FTP and fnuxi 3. Uvbackup/uvrestore 4. or any other options. Thanks, John. This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. --- 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] FOLD can mutilate {Unclassified}
And UNIVAC had a 90 column binary coded card, it was not Hollerith coded. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Wednesday, May 31, 2006 8:04 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] FOLD can mutilate {Unclassified} Ding, Ding, Ding, Ding. We have a winner. - Original Message - From: Derek M. Falkner [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, May 31, 2006 12:39 AM Subject: RE: [U2] FOLD can mutilate {Unclassified} We used to use the Hollerith code. That was after we changed from 7-track paper tape - I was quite good at making corrections to that. Derek Falkner Kingston, Ontario, Canada -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: May 30, 2006 11:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] FOLD can mutilate {Unclassified} Trivia Question: What's the name of the pattern (language) used for the traditional 80 column IBM punch cards. My 2 cents. --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Closed
Your server was down and it bounced a couple of times before delivery. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV - Build.Index problem
Has anyone heard of this problem? Over the weekend we build the indices for all of our indexed files. One of the builds hung up this past weekend which stopped any further processing because the file being indexed was one of our most used files. The process started normally by locking the file to be indexed then starting all of the phantoms for each index. There are about 24 indexes on this file and one of them apparently was locked for some unknown reason. Because the phantom couldn't lock the index file (INDEX.012) it errored out and the rest of the processing just hung. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] FW: UV - Build.Index problem
I forgot to mention we are on UV 10.1.12 and Red Hat Enterprise Linux AS release 3 (Taroon Update 5) Kernel 2.4.21-32.EL on an x86_64 From: Jerry Banker Sent: Tuesday, May 30, 2006 3:01 PM To: 'u2-users@listserver.u2ug.org' Subject: UV - Build.Index problem Has anyone heard of this problem? Over the weekend we build the indices for all of our indexed files. One of the builds hung up this past weekend which stopped any further processing because the file being indexed was one of our most used files. The process started normally by locking the file to be indexed then starting all of the phantoms for each index. There are about 24 indexes on this file and one of them apparently was locked for some unknown reason. Because the phantom couldn't lock the index file (INDEX.012) it errored out and the rest of the processing just hung. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV - USING keyword
What is the proper way to use the USING keyword in a list? It doesn't seem to work as stated in the manual unless I am using (no pun intended) wrong. According to the manual this is how the command is used. LIST [DICT | USING [DICT] dictname] filename [records | FROM n] [selection] [output.limiter] [sort] [output] [report.qualifiers] When I try LIST USING DICT TEMP.DICT CUSTOMER.FILE CUST.NAME I get the error RetrieVe: syntax error. Unexpected symbol. Token was DICT. Scanned command was LIST USING DICT Now I've tried moving the using part to different places on the line but none seem to work. Any help would be appreciated. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OK...Is there a way....UV
If you have an index on the file the index is already sorted so all you have to do is use the index when you select. The only criteria would be that the index is on the key or a field that will include all of the records or NO.NULLS is off. Example: SELECT CUST.MSTR BY CLIENT.6 SAMPLE 2 Will give you the first two sorted entries. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, May 25, 2006 2:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] OK...Is there a wayUV I want to sort a file by @ID and only take the first two items... SELECT FILE BY @ID SAMPLE 2 doesn't work, it first takes the sample of 2, then sorts it. SELECT FILE BY @ID SELECT FILE SAMPLE 2 works, but takes two lines How can I phrase my SELECT so it will sort first, then sample later, instead of sample first, sort later? I'm running UV. George George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.1000 Ext 220 SLACK Incorporated - Delivering the best in health care information and education worldwide. http://www.slackinc.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] Phantom job started from another phantom job
Don't chain to off. Just stop the program and it will release. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott, Dave Sent: Friday, May 19, 2006 9:56 AM To: u2-users@listserver.u2ug.org Subject: [U2] Phantom job started from another phantom job A colleague of mine ask me to post this on his behalf. I have a Phantom job that runs continuously. The job performs a select, executes some processing on the records returned from the select, and then goes to sleep for a few minutes. After sleeping, the process repeats itself. I recently added an additional step after the processing. This step starts another Phantom process which launches a program that does a select and processes the results of the select and then stops (using CHAIN OFF). The problem is that our system admins have noticed that the child Phantom processes launched by the parent Phantom process go into a state of defunct from a Unix process perspective. $ ps -ef | grep defunct fhooven 23180 986 18 16:33:12 ? 0:00 defunct dscott 23302 23199 1 16:33:32 pts/tW0:00 grep defunct The child Phantom process runs successfully and the defunct process eventually goes away. Any idea what causes this? System is Universe 10.0 running on HPUX B.11.11 A Thanks for you help. ...Frank Hooven --- 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 - Distributed files
Since you seem to know a little about distributed (as opposed to multi-data files), I have a question. What do you do with year 2000? I've recently gotten into distributed files and was wondering how others treat year 0 records. Can there be a part number 0? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, May 17, 2006 5:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Multiple Data Files I suspect that the Ron is talking about distributed files.. a whole lot snipped --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV LOGON question
Tom, Maybe this is what you are looking for. @TTY will equal a lower case 'phantom' for phantom jobs. We use this to keep phantoms from going through our login program. All of the output from the commands in a phantom can be found in the PH file with the program name with date and time as the key. As far as finding the command itself this sounds like the LOGON program you are talking about was a wrapper program for a batch or phantom process that knew where to get the commands. Jerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: Wednesday, May 17, 2006 12:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV LOGON question We are migrating a company from an UltPlus system to UniVerse. We are running UniVerse 10.1.11 on AIX 5.3.3. The UniVerse is running Pick flavor. The legacy application relays heavily on the use of LOGON port [command] processes. So if you say LOGON 92 EOD.REPORT.25, the system will start the EOD.REPORT.25 running on port 92. It functions kind of like a PHANTOM process in that it really starts another session from the same account that the PHANTOM/LOGON was executed. It runs the login paragraph of that account. One of the problems is that the LOGON does not populate the @tty variable with PHANTOM or LOGON or anything else that we can find. The second problem is that we can not find where the system is storing the [command] that is passed into the new session. We have displayed all of the @ variables that we can find in the basic manual and none of them contain the proper data. I know the port number is strange, but we have figured a way to deal with that, we just can't skip the logon paragraph or find what process we are supposed to be running. Thanks for the help in advance. Tom Dodds mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] 513-563-2800 Cincinnati Office 708-234-9608 Chicago Office 630-235-2975 Anywhere Cell --- 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] xls to text
Leave the Nebula- on the address. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Armstrong Sent: Friday, May 12, 2006 11:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] xls to text I removed removethisNebula- but still couldn't find it. Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 714.995.7012 fax -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, May 12, 2006 8:14 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] xls to text quote who=Dave S This web site does not work. What's the purpose of this : removethis It's a trick so sniffers can't harvest email addresses and web addresses from TCP/IP packet transmissions. Do what it says: removethis then use the rest. Simple. Of course, I say that after having to figure it out once, too. Karl Tony Gravagno [EMAIL PROTECTED] wrote: Craig Bennett wrote: Does anyone know where I can get FREE software that will convert Excel files to text files in command line mode ? Have you considered a perl script? The Spreadsheet::ParseExcel::Simple module is very easy to use. I just wrote a routine to satisfy the request and posted it to our freeware site. It's pretty much the same thing that Craig provided, but is written in C# and provided as a ready-to-run executable. It also saves worksheets as individual .CSV files, and gets the source/target file info from the command-line. See ExcelExport.exe and the related ExcelExport_README.txt: http://removethisNebula-RnD.com/freeware/ HTH Tony Gravagno Nebula Research and Development [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - Get amazing travel prices for air and hotel in one click on Yahoo! FareChase --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- 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/