Re: [U2] Why don't calendars show the pick date?
Simple if you have a calendar that shows the Julian date. Find out what the internal date for December 31st of the previous year is and write it somewhere on the calendar. Then all you have to do is add the Julian date to it. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, November 11, 2010 8:01 AM To: U2 Users List Subject: [U2] Why don't calendars show the pick date? Wouldn't it be so much easier if those desk calendars and wall calendars had the pick date on them, as well as the julian date.that would make them so much more useful! George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse On RedHat?
I've never moved UV from HP-Ux to Red Hat but I have worked on both. We went from a Sun Risc system to Red Hat on Intel and, like Drew said, you would have to do recompiling of programs and I-descriptors, and either uvbackup/uvrestore or fnuxi the files. If you use any operating system scripts or programs those will have to be checked for differences. The spooler should work pretty much the same. I did our conversion on a Saturday morning. Moving from a 'nix system to Windows was not as easy. Jerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, November 05, 2010 4:59 PM To: U2 Users List Subject: [U2] UniVerse On RedHat? 0. We are considering migrating from HP-Ux to RedHat. 1. How is RedHat? 2. Will I have to re-compile and re-catalog everything? 3. Did anyone migrate from HP-Ux to RedHat and then back to HP-Ux? 4. Is the RedHat Standard Edition Suitable? 5. Did anyone try running UV on RedHat on an HP Integritity (Itanium) server? 6. Are there any gotchas? 7. Insights and hind-sights would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I'm baaaack
There are discussion email groups like this one as well as forums. Go to the www.u2ug.org web site and sign up for all of that you want to belong to. Welcome home. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon Sent: Thursday, October 28, 2010 8:49 AM To: U2 Users Subject: [U2] I'm bck Greetings Group, I just started a new position with a company running a Unidata / SB+ shop after my hiatus from the multivalue market. It seems some things have changed since I left (Rocket instead of IBM) but many things seem the same. I look forward to the discussions on this group which I've missed. Gordon Gordon J Glorfield | Software Application Engineer | Vertis Communications 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664 | M 443-280-7093 gglorfi...@vertisinc.com | http://www.vertisinc.com Vertis Communications is a results-driven marketing communications company that delivers inventive advertising, direct marketing and interactive solutions to prominent brands across North America. Our deep industry knowledge and extensive range of offerings-including integrated data solutions, digital program management systems, creative services, world-class print and mail production, logistics, out-of-home and business process outsourcing-are used to deliver superior program performance that drives bottom line results for our clients. With 100 strategically positioned locations and more than 5,000 dedicated professionals, we deliver impeccable quality and fast turn-around to any market. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building XML using the UV XDOM API functions
I'll have to disagree with you on this one Tony. As a vendor yourself you would of course think this way. As an end user of the product we would like it all to come from one source. This is the reason that Microsoft has got such a jump on everyone else, they will provide you with all of the tools as well as the database. I'm talking about the harsh reality of things, at one time if you went IBM you went all the way, now it's Microsoft. Companies don't want to deal with several vendors they want one. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, October 25, 2010 11:35 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Building XML using the UV XDOM API functions Gregor, your comments serve as a testimonial to support my position against using many of these vendor-supplied toolkits. Some of them are OK, but many not. People insist on the DBMS vendors building stuff for them, but then we get the mess that you've described. For this reason I continue to recommend at least consideration for integration with tools that are outside of the DBMS. DBMS vendors should be focusing on making superior databases, not XML, web services, or a lot of this other fluff. People in the open source and commercial markets spend a great deal of time focused on these things, and because of this, their offerings are often much better. So take a look around and weigh other offerings against the built-in functionality. It would be nice to see people here comparing more toolkits - it might save others from feeling like they're stuck with whatever is provided by the DBMS vendors. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] too many values in sort
I don't think UniVerse has the same limits (SELBUF controls in memory size) but then UniVerse doesn't use the same structure as Unidata in their selects. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, October 25, 2010 11:52 AM To: U2 Users List Subject: Re: [U2] too many values in sort Of course, why would anyone need a BASIC program larger than 32K? I believe it's called progress. Non-configurable size limits are just __NOT__ acceptable in today's computing environment. The attendant work-arounds are just plain ugly, and inexcusable. The greatest aspect of PICK is the narrow gulf between the logical and the physical; database structure is logical, query syntax is logical, in fact, the entire machine is a logical machine. Twenty year old physical limitation should have been resolved at least ten years ago. :-( Bill Kevin King said the following on 10/25/2010 8:27 AM: Agreed on all points. Will check this on my customer's system. On Mon, Oct 25, 2010 at 9:11 AM, Dave Davisdda...@harriscomputer.comwrote: That's some shopping list. I haven't seen anything anywhere that lets you adjust this limit. Besides breaking the record up into separate tables, you may need to make a temp file that normalizes this for you, by doing something like stringing the value or row number into the key. I've never had anything approaching 10240 values in a multivalue. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, October 25, 2010 10:54 AM To: U2 Users List Subject: [U2] too many values in sort Unidata 6.1.15 on AIX. The following command: SSELECT SHOPPING.LIST BY.EXP PROD.NUM Yields the message too many values in sort. There is one record in this file with 36,457 product numbers but would that break the BY.EXP? If so, is there a config parameter somewhere that could be tweaked to make this work? -Kevin http://www.PrecisOnline.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Compiling 102
The usage of the CATALOG command depends on the flavor you are using. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, October 21, 2010 2:24 AM To: U2 Users List Subject: Re: [U2] Compiling 102 Bill, By default CATALOG will catalog programs globally. To catalog a program locally you have to use the LOCAL option. This will generate a VOC entry for the program name without the file name. So CATALOG BP CODE LOCAL will generate a VOC entry named CODE. To run the program you only need to type CODE at ECL and your program will run. Quite simple really. Mecki On 20/10/2010 17:06, Bill Brutzman wrote: I have been using Revision suffixes and VOC. In other words... LOGTO SANDBOX ED VOC SAMPLE.PROGRAM PA RUN BP SAMPLE.PROGRAM.R1 -- R2 save BASIC BP SAMPLE.PROGRAM.R2 After the program is found to be workable... LOGTO METAL ED VOC SAMPLE.PROGRAM PA RUN BP SAMPLE.PROGRAM.R1 -- R2 save I have only been using CATALOG to register global SUBs. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: Wednesday, October 20, 2010 11:44 AM To: U2 Users List Subject: Re: [U2] Compiling 102 You might want to consider having two BP files - Production and Test (Sandbox?) - e.g. BP and TEST.BP You then use the CATALOG command to control which version is running. Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, October 20, 2010 8:28 AM To: U2 Users List Subject: [U2] Compiling 102 1. It works. Thanks to Kat, Tom, Vance, and Drew. 2. I am wondering if others keep their source code in an UV account as such. 3. Prior to this thread, I had two accounts /u2/METAL /u2/SANDBOX 4. The source code was not in a UV account in /u2/SOFTWARE 5. An advantage that I seem to have now is that I can compile code when logged in to either METAL or SANDBOX and the compiled code works in both METAL and SANDBOX. In other words, I do not have to compile the same source code for each account. It is not clear to me how VOC and Q-Pointers are setup to handle this scheme. 6. Comments would be welcome. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CUPS printing and sequence of jobs
When we used cups on our Linux server I had to go directly to the IP address of the printer circumnavigating the Windows print server. Going through the print server created too many problems, especially for print jobs that we had imbedded pcl coding. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, October 05, 2010 1:21 PM To: U2 Users List Subject: Re: [U2] CUPS printing and sequence of jobs it's a Canon Imagerunner copier/printer with it's own pc acting as a server. I'm not really sure what OS it's running, I don't think it's windows. I'm submitting lpd protocol to it, directly to it's IP I switched our side so that cups sends to a Windows PC running RPM lpd server, and RPM then sends the raw data to a windows network printer (same copier/server) except it's getting it's jobs through the networks windows printer server, and the jobs print as expected. So, it's definitely in the Canons PC's lpd server specifically. This all sounds great..and solved, EXCEPT, we have found another little issue with cups, it seems when the lpd server is busy, cups triggers the printer queue to disable (ErrorPolicy stop-printer), which is extremely annoying to have to keep reenabling the queue when you send a flurry of jobs. So we changed it so the ErrorPolicy retry-job instead, now it doesn't take the queue offline, instead now it just doesn't send a job to the server, but still deletes it from it's queue. SoUntil I can get this lost job issue solved, looks like I have choices: 1. Look into changing from lpd protocol (port 515) to Ipp protocol (port 9100) (next attempt) 2. See if the server's admin can set something so the lpd server does FIFO 3. have fun sorting printed jobs back into their correct order! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Tuesday, October 05, 2010 1:50 PM To: U2 Users List Subject: Re: [U2] CUPS printing and sequence of jobs Is this with a standalone hardware printer server, or a PC acting as a printer server? If the latter, with what software on the PC? Our Print Wizard software for Windows can act as a printer server. We have *some* capabilities for job sequencing, and we could explore more options with you if this is critical. On Tue, 5 Oct 2010, George Gallen wrote: the debug info shows they were sent to the printer in the numerical unix job# order. I disabled the printer, sent the jobs again, and the unix job# order was the same as the order sent, I renabled the printer and when the jobs printed they were in random order, according to the cups log, they were sent in the correct order. So it looks like it's the receiving print server that is sending them in random order to the printer, of course the admin for that server swears it does FIFO... Thanks for the debug tip... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Saturday, October 02, 2010 12:51 PM To: U2 Users List Subject: Re: [U2] CUPS printing and sequence of jobs Maybe turn the logging up a notch and verify the order they are being submitted? It might not be considered submitted until it finishes spooling, where a large job can be surpassed by smaller jobs. We would not really want it to block on large print jobs. Take for instance you start spooling an invoice run that may take 5-6 minutes to spool, you do you not want to process any other jobs while this thing is transferring to the queue? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV index with duplicate nodes
Does the correlative have any special coding in it? I would suggest deleting the index for this field recreate the field as a D type then add the field to the index again. Some correlatives don't give you what you would expect. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Thursday, September 30, 2010 7:47 PM To: U2-Users@listserver.u2ug.org Subject: [U2] UV index with duplicate nodes We've just uncovered a rather unusual and unsettling situation. We have a file with a single index that has somehow gotten nodes with duplicate keys. A simple example would be having an index on ZIPCODE in a address database, and finding that there are _two_ nodes (records) in the index for ZIPCODE 12345, for example. The source records referred to in the nodes are not duplicated, but since most operations find the 'first' node, any source records referred to in the duplicate node appear to not exist in the index. LIST.INDEX fname ALL Alternate Key Index Summary for file fname File... fname Indices 1 (1 A-type, 0 C-type, 0 D-type, 0 I-type, 0 SQL, 0 S-type) Index Updates.. Enabled, No updates pending Index name Type BuildNulls In DICT S/M Just Unique Field num/I-type fieldnameANot Reqd YesYes ML N2 The file contains 6,539,233 records, with 574,547 unique values in fieldname (which is actually a single-valued field, and has been verified that each record's fieldname contains one and only one value). We found that 9 source records appear to have not been included in the index, but upon further research found the nodes with duplicate keys. We created an F-pointer to the index file itself (not normally recommended, but useful), then got the results like the following: LIST indexfile WITH @ID = 12345] F1 F2 fname. F1 F2 12345 987654 876543 12345-6789 765432 543219 12345 654321 We are having our UniVerse administrator ask our dealer for assistance, but were interested if any other users have had any recent similar experiences, or advice. Sincerely Best Regards, Richard Lewis IBM Certified Solutions Expert Nu Skin Enterprises ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UVRESTORE error
Look up the command in the documentation. You will notice that if you are going to restore to a lower revision you will need to back up with one of the -rev options. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, September 28, 2010 1:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] UVRESTORE error Hello, We have a new version of UniVerse on our new server and every night we make a backup image using UVBACKUP. Today I tried to do a UVRESTORE from last night's backup onto the old server which is running a slightly older version of UniVerse and received the following message: WARNING: Unable to restore image of revision level 10. This process is only capable of restoring backup images created with revisions between 2 and 9, inclusive. I'm assuming this message is due to the different versions of UniVerse but I was curious if there was a quick workaround that people have found? Thanks, Chris ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Does Reality Flavor have globally cataloged subroutines?
We are running in Reality flavor and have many globally cataloged programs. We have separate catalog commands for doing this just as others have mentioned. I have never seen a problem doing this. Jerry -- From: George Gallen ggal...@wyanokegroup.com Sent: Thursday, August 26, 2010 9:53 AM To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] Does Reality Flavor have globally cataloged subroutines? I'll have to play around this this then Thanks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Thursday, August 26, 2010 9:49 AM To: U2 Users List Subject: Re: [U2] Does Reality Flavor have globally cataloged subroutines? Hi George, If I do that, then I lose the features of the Reality Account correct? Or Do I change it, catalog the routine, then change it back? You could create an alternative named VOC entry that uses INFORMATION.FORMAT to save changing it back. However, it may not really be an issue. The Reality mode version of CATALOG behaves the same as the Information style one with no extra options (what Ideal/Information and PI/open call normal mode). By selecting the INFORMATION format you gain LOCAL and global modes. The problem is that those accounts were imported from a Reality system, and I wanted to use some of the subroutines that were written on another account imported from a Prime system. The mode of CATALOG has no effect on what you can call. It only determines how the cataloguing is done. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unix to SQLServer
Hear, hear, and as an end user I welcome knowing about new, and old, products that are available for my use. Jerry -- From: Larry Hiscock lar...@wcs-corp.com Sent: Friday, August 13, 2010 11:26 AM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] Unix to SQLServer At the risk of being roasted for mentioning my vendor product (see other threads - it seems to be unpopular) ... I'm not speaking for the U2UG officially, but as a moderator on this list, and as the list host. IMHO, there is nothing wrong with mentioning or endorsing a product, whether it's free or commercial. If it provides a solution to the problem in question, then it's germane to the discussion. What I personally find distasteful is when someone gives a product a glowing review without disclosing the fact that they stand to benefit from its sale. That's why we've simply asked that when endorsing a product with which one has a fiduciary relationship, that it be disclosed as such. Ok, back to the topic... Larry Hiscock Moderator ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] RetrieVe enhancements
Yes, all of the time. It's still a very good ad hoc reporting tool. Plus we have many reports that are generated using retrieve that we transform into PDF's. -- From: Symeon Breen syme...@gmail.com Sent: Friday, July 16, 2010 2:42 PM To: 'U2 Users List' u2-users@listserver.u2ug.org Subject: Re: [U2] RetrieVe enhancements This got me thinking - pardon the question, I have not used retrieve for such things for many years , but do people still use retrieve for print or screen reporting ? Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 16 July 2010 16:28 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RetrieVe enhancements With full agreement that C justification would be helpful if built-in, this function is easily accomplished with a correlative or even a call to a common subroutine. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Memory issues
Do you have or have you added any other applications running on the same server or is it dedicated to UV? I have seen where having another application running on the same server will conflict with UV. -- From: u2ug simpson-u...@gerzio.ca Sent: Tuesday, June 08, 2010 10:31 AM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] UV Memory issues We started running into a situation recently where a box running universe 10.2.11 on hpux 11.31 started to have severe performance problems, zero response, processes that normally take seconds to run taking hours etc. In Top we could see that the reported free memory was averaging about 28M at times dropping to less than 5M and that the vhand process was chewing up a most of the cpu. With the free memory that low, vhand hogging the system makes sense. Why the memory is that low is the question. The machine has 4G of memory, right after reboot before anyone but me gets on the system top shows us at 3G free. If we just let the system sit, free memory will sit happily at 3G. As soon as we start using universe, the free memory starts to fall. Logging out all universe processes and even bringing universe down has no effect on free memory - I would have expected the memory to be freed up once the universe processes and in particular universe itself was terminated but that's not what we are seeing. We were in the process of setting up a new box physically the same as the old box but running uv 10.3.6 on hpux 11.3.1. So I am looking at this problem now on that box in isolation. We were hoping that this would turn out to be a hardware issue but we are seeing the same problem on this new box as well. This is out of my realm of experience and I am stumped as to where to go next. I have the system guy checking with hp , my guess is they are going to point the finger at uv. I am going to check with our var - I'm not overly optimistic there either. Any suggestions ? - Hpux/uv tunables we should be looking at - can we tell universe to restrict the amount of physical memory that it uses ? - Or maybe this is a garbage collection issue ? - universe or hpux being overly aggressive about caching - any hpux utilities that we can use to see exactly where the memory is being used ? - ? Gerry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Scholl Sent: June 8, 2010 09:41 AM To: 'U2 Users List' Subject: [U2] [Unidata-Windows] Can login, but not execute any command Upfront: The problem was solved by re-installing UniData My client had UniData 7.2.3 on Windows within his domain. He rebooted all servers within his company over the weekend. Yesterday UniData suddenly didn't work anymore. I could log in to the database, but any command, whether Write, Select or catalogued subroutine would stop dead in its track. There was no error message, no indication what could have gone wrong. UniObjects had no time-out, the application hung for hours. I telneted into the database and many users got the unknown user error, I just found one user that allowed me to log in. I ran a few commands and that worked. My hunch is that a Windows update changed NT-Authentication and UniData didn't like it. Poking through the logs, I see in the Windows security log two entries for every UniData login, one success and one failure: The first a success audit: A trusted logon process has registered with the Local Security Authority. This logon process will be trusted to submit logon requests. Logon Process Name: \udapi_server.exe Then a failure audit: The logon to account: HHC-Unidata by: MICROSOFT_AUTHENTICATION_PACKAGE_V1_0 from workstation: HORIZONSERV4 failed. The error code was: 3221225572 The error code means: 32212255720The specified user does not exist. This behavior started already last year, and even now that everything works again. Does anyone have ideas or similar experiences? Martin Scholl 18910 New Hampshire Ave Brinklow, MD 20862 Phone: 301-924-5537 Cell: 301-613-9572 martin.sch...@hipaasuite.com www.HIPAAsuite.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OPENSEQ and Abnormal termination of UV
Let me see, can it be because you are trying to cram over 4 GB of data into a single cell. Unlike the OPEN statement that just puts the file variable into a variable, the OPENSEQ opens the whole file to the variable. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rajesh Menon Sent: Monday, May 17, 2010 1:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] OPENSEQ and Abnormal termination of UV Does anyone knows what is happening here: I am trying to open a text file (over 4Gb) using OPENSEQ and storing the file variable into a array as follows: COMMON /MYPROG/ FILEVARS(10) OPENSEQ /tmp/file.txt to FILEVARS(1) ELSE ... This operation results abnormal termination with fault type error 11. Fault occurred at address 1c (which is the OPENSEQ command.). If the file size is less than 2147483647 bytes (2Gb), it works. Opening the same file using a scalar file variable always work irrespective of the file size. OPENSEQ /tmp/file.txt TO FV.FILE ELSE ... Any reason why the first method failing for +2Gb files? Any workarounds? Universe: 10.2.7 AIX: 5.3 Thanks Rajesh Menon ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV on Windows
Anybody know what permissions a person needs to use all of the UniAdmin options on a Windows server running UniVerse. Right now I can bring up the UniAdmin when I rdp to the system but I can't see any of the users except myself. I can't kill a user because they don't show up on the users window. Same thing with the locks. I try to clean the licenses but that doesn't seem to do anything. I need to know what I need so I can tell the network administrator what he has to do. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert Administration and Development ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Looking for a Job.....
You do realize that you have more of a chance of finding a job in India than you do here, right. Most of the jobs here have been outsourced to your country or China. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed Sent: Monday, April 12, 2010 10:58 AM To: u2-users@listserver.u2ug.org Subject: [U2] Looking for a Job. Hi everyone, I have around 9yrs of experience on Unidata, Pick Basic, Unibasic, Redback and other technologies like ASP.Net, C# and XML. I am currently leading a offshore team in India and now looking for a change. I am looking a job near Dallas, Texas. Thanks Jaweed ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] import data to excel sheet...
This is a function of the operating system. On Unix systems only a linefeed character is added to the end of a line whereas on Windows both carriage return and linefeed characters are added to the end of a line. If you open a file created on a Unix system with the notepad app it will have one line with strange characters in it. A quick fix, if you open the same file with word pad it will be converted and you can save it. If you created a file on a Unix system for use on a Windows system you have to add a carriage return character to the end of the line. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, April 12, 2010 11:01 AM To: U2 Users List Subject: Re: [U2] import data to excel sheet... Hi Jaweed, I haven't looked too closely at your code, but I did notice on thing that I would consider the most likely candidate: CHAR(13) is a carriage return, not a line feed. Try using CHAR(10) instead for your LINE.FEED variable. You might have to use CHAR(13):CHAR(10), but I think CHAR(10) should do it. Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jaweed Sent: Monday, April 12, 2010 7:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] import data to excel sheet... Can anyone tell me what is wrong with the following code for importing data from txt file to an excel sheet, when its launch Excel it giving some error message, but when I open the downloaded file from my disc, all the data is in one line with some especial Chars. Any help will be appreciated. 034: ** 035: * OPEN FILES * 036: ** 037: ERRMSG = '' 038: OPEN TEXT.FILE.NAME TO TEXT.FILE ELSE 039: ERRMSG = 'CANNOT OPEN THE ' : TEXT.FILE.NAME : ' FILE!' 040: END 041: IF ERRMSG THEN 042: GOSUB 91000 043: RETURN 044: END *--: P 045: ** 046: * INITIALIZE * 047: ** 048: PAGE.FEED = CHAR(12) 049: LINE.FEED = CHAR(13) 050: ;* 051: ;* Read the text file to convert 052: ;* 053: READ TEXT.REC FROM TEXT.FILE, TEXT.REC.NAME ELSE 054: ERRMSG = ITEM : TEXT.REC.NAME : DOES NOT EXIST IN : TEXT.FILE.NA ME 055: GOSUB 91000 056: RETURN 057: END 058: ;* 059: ;* Set default values (none are used now) 060: ;* 061: VALUE = DEFAULT 062: LOCATE PROPERTY IN FORMATSTR1 SETTING PTR THEN 063: VALUE = FORMATSTR2,PTR 064: END 065: ;* 066: ;* Remove the first line if it contains a PAGE.FEED *--: P 067: ;* 068: LOOP WHILE TEXT.REC1 = PAGE.FEED DO 069: TEXT.REC = DELETE(TEXT.REC,1) 070: REPEAT 071: IF TEXT.REC1[1,1] = PAGE.FEED THEN 072: TEXT.REC1 = TEXT.REC1[2,LEN(TEXT.REC)] 073: END 074: ;* 075: ;* Find the header for each page 076: ;* 077: SLK.REC = '' 078: SLK.ROWS = 0 079: SLK.HEADER.LINES = 0 080: IF TEXT.REC1[1,10] = RUN D - T: THEN 081: SLK.REC-1 = F;SD;R3 082: SLK.REC-1 = F;SD;R4 083: SLK.REC-1 = C;Y1;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC1[1,30],';',';; '))) 084: SLK.REC-1 = C;Y2;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC2[1,30],';',';; '))) 085: SLK.REC-1 = C;Y3;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC1[31,90],';','; ;'))) 086: SLK.REC-1 = C;Y4;X1;K : QUOTE(TRIM(CHANGE(TEXT.REC2[31,90],';','; ;'))) 087: SLK.ROWS = 4 088: SLK.HEADER.LINES = 2 *--: P 089: END 090: ;* 091: ;* Find the number of lines in the header 092: ;* 093: LINES = DCOUNT(TEXT.REC,@AM) 094: SLK.HEADER.CNT = 0 095: FOR IDX = SLK.HEADER.LINES+1 TO LINES 096: IF INDEX(TEXT.RECIDX,---,1) THEN 097: SLK.HEADER.CNT = IDX 098: EXIT 099: END 100: NEXT IDX 101: ;* 102: ;* Find the column locations 103: ;* 104: COL.LIST = '' 105: IF SLK.HEADER.CNT THEN 106: DASHES.LINE = : TEXT.RECSLK.HEADER.CNT : 107: DASHES.LINE = TRIM(DASHES.LINE,'-') 108: DASHES.CNT = COUNT(DASHES.LINE,'-') 109: DASHES.LINE = TEXT.RECSLK.HEADER.CNT 110: FOR DASHES.IDX = 1 TO DASHES.CNT *--: P 111: COL.START = INDEX(DASHES.LINE,'-',1) 112: DASHES.REMAIN = LEN(DASHES.LINE) - COL.START + 1 113: COL.LEN = INDEX(DASHES.LINE[DASHES.REMAIN],' ',1)-1 114: IF COL.LEN 1 THEN COL.LEN = LEN(DASHES.LINE) 115: COL.LISTDASHES.IDX,1 = COL.START 116: COL.LISTDASHES.IDX,2 = COL.LEN 117: DASHES.LINE[COL.START,COL.LEN] = SPACE(COL.LEN) 118: NEXT DASHES.IDX 119: END 120: ;* 121: ;* Extract the column titles 122: ;* 123: COL.CNT = DCOUNT(COL.LIST,@AM) 124: FOR HDR.IDX = SLK.HEADER.LINES+1 TO SLK.HEADER.CNT-1 125: SLK.ROWS = SLK.ROWS + 1 126: SLK.Y = Y : SLK.ROWS : ; 127: ;* 128: ;* Make sure the header properly fits into the column 129: ;* If it does not, then add it to the spreadsheet's first column 130: ;* 131: CHECK.LINE =
Re: [U2] Regex searching UD files
I'm on UV and from the Unix command line I can do the following: cd /usr/ibm/uv uv port.status | grep j_banker It will list every line with my login. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, March 29, 2010 4:13 PM To: U2 Users List Subject: Re: [U2] Regex searching UD files Not even close... We run in ECLTYPE P and don't have access to EVAL and the like. ^[Cc][Hh][Qq].*[5-8][0-9][0-9][0-9]x Unless you can explain how to duplicate the above search with ESEARCH? @Stuart, that would be ideal, but unfortunately I can't go dumping out multi-gigabyte files. :( -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, 30 March 2010 5:22 AM To: U2 Users List Subject: Re: [U2] Regex searching UD files Does UniData ECL ESEARCH command not fill the bill already? Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Monday, March 29, 2010 12:22 AM To: U2 Users List Subject: Re: [U2] Regex searching UD files I think this should be one for Rocket to implement a RegexSearch in U2. However, if it's size non-impactive, what I would normally do is copy the file to a temporary directory then run grep across that. Stuart Boydell -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, 29 March 2010 17:08 To: U2 Users List Subject: [U2] Regex searching UD files I've written a small utility to be able to run egrep on a UD file (not UD directory), however its implementation is not ideal. Essentially, I select the file I'm searching, writing each record one at a time to a temp UNIX file and running egrep on it as follows !egrep -q -f MyTempRegexFile MyTempRecordFile ; echo $? Where MyTempRegexFile is a file containing the desired regex pattern stored earlier and MyTempRecordFile is a file name unique to each user. My problem with it is that I have to do a READ on each record, followed by a WRITE then have egrep read it in as well. That's a lot of seemingly unneeded disk IO if I could only stream the record to egrep without have to do a WRITE after the READ. Any ideas? I feel I'm missing something quite obvious. Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. 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 prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. 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 prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained
Re: [U2] Pick on Mac
I think I saw someone on this list that was using one of the U2 products on Mac OSX or on the Windows virtual emulator. Could be wrong. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Monday, March 29, 2010 2:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick on Mac Are there are native implementations of a Pick system on Macs? Or are all Mac connections just terminal emulators into a Windows/Unix system? I know there is or used to be an emulator by Carnation that rode on a Mac. But have all such implementations been to have it talk with a Pick system living on a Windows or Unix box? Does Universe have any sites where users are connecting using Macs as their PC? Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Microsoft SQL Server Driver Support
The U2 team at Rocket Software announces a renewed focus on improving SQL interfaces to the UniData and UniVerse data servers. Microsoft SQL Server Driver Support Starting with the November release of UniData on Windows, the Rocket U2 team will deliver and support the Microsoft SQL Server driver for External Database Access (EDA) on Windows platforms. The same driver is available now in the Early Adopter release of UniVerse 11. To obtain the SQL Server driver for EDA, contact u2as...@rs.com. Please tell us what database you're using when you do so. External Database Access (EDA) is required in order to use the SQL Server Driver. EDA is available for Workgroup and Server edition and is included with Enterprise edition of the databases. Common Mapping Tool and Schema Generator In addition, we are in the early planning stages for an improved, common mapping tool and schema generator for fully describing the U2 data model in order to generate SQL and EDA schemas. This new tool will provide a modern, extensible interface for both initial mapping as well as updating of schemas. This tool, with its associated APIs, will improve deployment of ISV solutions to end customer sites thereby saving time and speeding time to market. This tool will be available with UniVerse 11.1 and in a UniData 7.3 release to follow. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert Administration and Development ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Spooler for Windows
What products are out there that mimic the Unix UniVerse spooler in a Windows environment? From what I can see on Windows, UniVerse uses the Windows printer subsystem and in my estimation that was a mistake. There's no retention of print jobs, no form type, no ability to use scripts, it is the biggest stumbling block for conversion from a 'nix environment. I would only like to look at packages that are built to work with UniVerse and are like the Unix spooler with all the bells and whistles. We have moved from Unix V5, to Solaris, to RH Linux, and our spooler scripts only needed minor changes long the way. Now we are trying to go to Windows and the only stumbling block the we have encountered is the spooler. We did so much with it. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert Administration and Development ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] extraction conversion codes
I wonder the same thing. All he's doing is converting a D type to a correlative and in that case I would much rather have it an A or S type so you don't have to be misled by the type and not looking for the special coding in field 3. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Friday, February 05, 2010 1:33 PM To: U2 Users List Subject: Re: [U2] extraction conversion codes Hi Gerry, Out of curiosity, why are you against I-types? Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Resize Question
If you are starting out with trying to use SQL on a legacy database your best bet would be to create a separate account just for SQL. In the new account put in pointers to the main data files you will be using and create dictionaries to the files locally. In this way you can build the dictionaries to be SQL compliant and only have the fields that you will be using for your SQL apps. It's a little more work to set up but will save loads of time later. If you have files with the same data (current and history files) you can use the same dictionaries so that can cut down on the number of dictionaries used. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, February 03, 2010 2:57 AM To: 'U2 Users List' Subject: Re: [U2] Resize Question Hi Andrew Because UniVerse dictionaries contain not only solid column definitions, but also synonyms and virtual fields, you have to choose which of these will be exposed for ODBC or similar relational protocols. A typical dictionary for a mature system might have a thousand entries which makes navigating these in something like MS query or the .NET data set designer very difficult! So for this you need to do two things: First, create a phrase named @SELECT. This is a dictionary entry in the format: Key: @SELECT 1: PH 2: list of fields SPACE delimited. You can test this out by doing a SELECT * from file at TCL, which uses the same phrase. Then, you need to update the file information cache used by ODBC (prevents it having to scan every dictionary on connect). For this, run the HS.UPDATE.FILEINFO command after making your changes. However, you might also want to step back and consider whether ODBC is really your best choice. To use ODBC effectively you need to understand about dynamic normalizing and the differences between the UniVerse data model and the relational model expected by ODBC. Depending on what you wish to do, ODBC may tie you up in knots and you may be better off looking at one of the native protocols (the UniObjects family) or web services instead. Also, I don't know why you chose to copy your VOC across. That will contain pointers to all the files from the original system, which you don't have on yours, hence the large number of errors you are seeing. If you are brave, you can try a CLEAN.ACCOUNT command, but take a backup first! [AD] You might want to consider my latest book, 'IBM UniVerse Client Developer' (written when this was still an IBM product) which covers the various protocols in depth. You can find details on my website, www.brianleach.co.uk. [/AD] Regards Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E. Tegenkamp Sent: 02 February 2010 4:17 PM To: 'U2 Users List' Subject: Re: [U2] Resize Question Thank you very much! That has helped a lot and I can now see the data in the UV command line :) If possible, I am now hoping to be able to expose this imported data to ODBC so I can work with it in PHP, etc. But I am again finding problems I cannot find an answer for in the help docs or searching the list archive. First, I created a PICK account using the U2UG guide mentioned. I then used HS.ADMIN option 3 to Activate access to files in an account which went well and showed it as an activated account. I copied over the TEMP and VOC (D_VOC, D_VOCLIB, VOC, VOCLIB, etc) files from the live UniVerse server to my account as well as my test table ZIP (ZIP and D_ZIP). I fnuxi'd and SET.INDEX'd them and could see the data on the command line using SELECT COUNT(*) FROM ZIP and the like. However, when I went to ODBC I could only see 3 tables. AE_DOC, HELP_FILE, and HS_FILE_ACCESS (ODBC reported no rows in HS_FILE_ACCESS). I ran HS.ADMIN option 3 again on the account and for most things it said: Could not open file FILENAME. STATUS() = -2 FILENAME was not written into File Information Cache. For the file I copied over, ZIP, it said: ZIP's dictionary has no @ phrase or @SELECT phrase. ZIP was written into File Information Cache but may not behave as desired. This is a little confusing as I thought D_ZIP was the dictionary file and SELECT works on the command line. After this, I checked ODBC and saw the 3 above and one more table called UVMD. I am not sure what this was so I got it but it appears to be a system table of some sort. Thanks again for any tips on how to properly setup/expose this file/table to ODBC! Andrew -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, February 01, 2010 11:55 AM To: 'U2 Users List' Subject: Re: [U2] Resize Question Okay, a few things here... First the index issue. When UniVerse creates an index on a file, it puts the absolute pathname to the
[U2] Sharing files
I am very familiar with how to do things on Unix/Linux systems but my knowledge of the MS Windows Server environment is substantially lacking. So I am wondering if the group can give me some pointers. I have a folder on a RH Linux system that I would like to share on a Windows 2K8 server running UV 10.2. The share has been set up using Samba on the RH Linux as3 server and from a desktop or an RDP session to the Windows server I can map the share and us it. But, I would like to use the share from within our main UV account for multiple telnet sessions. On 'nix all I had to do was mount the folder from another system, put a pointer to it in the VOC, and I was up and running. From UV Windows I am at a loss to know where the mount is. I have tried to use a UNC path in the VOC pointer but it doesn't seem to work or possibly I didn't create it properly (\\IPaddress\smbshare\file file:///\\IPaddress\smbshare\file ). They are on two different subnets. Can anyone enlighten me on how they are doing it? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS
Is 5.2 still supported? That may convince them that it is time to upgrade. I can't seem to find an availability matrix on Rocket's site. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gerd Forthmann Sent: Wednesday, January 13, 2010 10:25 AM To: U2 Users List Subject: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS Thanks Bill, I don't think it is an ODBC problem since SSIS connection managers unlike DTS don't use ODBC. They use OLEDB and connect even without the IBM U2 ODBC driver installed. I maybe have to add that both SQL Server 2000 and 2008 run under Windows 2003, so I don't think this is an OS issue either. If anybody has any suggestions how to use UniObjects with SSIS I would give that a try immediately. Easiest would of course be to upgrade to UD 7.2 but unfortunately I haven't been able to convince management to approve that. Mecki Original-Nachricht Datum: Wed, 13 Jan 2010 10:36:27 -0500 Von: Brutzman, Bill bi...@hkmetalcraft.com An: U2 Users List u2-users@listserver.u2ug.org Betreff: Re: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS This problem resembles my recent problem with ODBC between HP-Ux and MS-SQL. Tech Support at Rocket indicated that I would probably have to buy special (ODBC) drivers from companies that specialize in data integration because... ODBC is a Microsoft thing and this sort of connectivity is not bundled with most (maybe any) flavors of Unix. Rocket agreed that using UniObjects would be an easier alternative. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, January 13, 2010 7:39 AM To: U2 Users List Subject: [U2] Error connecting to UD 5.2 from SQL Server 2008 SSIS Hi I am trying to use SSIS to load UniData tables to SQL Server 2008. I already have been using DTS with SQL Server 2000 successfully for a while and I set up everything (System DSN and UCI Editor) the same on the 2008 server. The connection test works fine, but when I try to go further I get this error message. Cannot get string literals from the database connection Provider=Informix.UniOLEDB.1;Password=;Persist Security Info=True;User ID=admin;Data Source=LIVE_DATA;Location=LIVE_DATA;Mode=Read We are running Unidata 5.2 on Solaris. And I am using UniDK for that release on both SQL Server boxes. I had tried using a later version of UniDK before, but that didn't seem to want to connect to the older version of UD at all. Any ideas? Thanks Mecki ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] An interesting find....
Instead of CASE -1 use CASE 1 -- From: George Gallen ggal...@wyanokegroup.com Sent: Tuesday, December 15, 2009 1:23 PM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] An interesting find Here is an interesting tidbit I happened to run across. PROGRAM A: OPEN ,FILE1 TO F.FILE1 ELSE STOP NO FILE1 OPEN ,FILE2 TO F.FILE2 ELSE STOP NO FILE2 * F.FILETOUSE = F.FILE1 (Adding this here will get rid of the compile warning) BEGIN CASE CASE X=1 F.FILETOUSE = F.FILE1 CASE X=2 F.FILETOUSE = F.FILE2 CASE -1 F.FILETOUSE = F.FILE1 END CASE READ XDATA FROM F.FILETOUSE,TEST ELSE XDATA= The above program when compiled says F.FILETOUSE never assigned a value and when it executes, gives an improper file type error HOWEVER: PROGRAM B: OPEN ,FILE1 TO F.FILE1 ELSE STOP NO FILE1 OPEN ,FILE2 TO F.FILE2 ELSE STOP NO FILE2 F.FILETOUSE=F.FILE1 IF X=1 THEN F.FILETOUSE = F.FILE1 IF X=2 THEN F.FILETOUSE = F.FILE2 READ XDATA FROM F.FILETOUSE,TEST ELSE XDATA= Compiles and run just fine, no errors. This is using UV 10.0.2 under the Prime Information flavor George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SELECTs on FILEs
While you are on the subject I have discovered another little annoyance from Windows as opposed to Unix. On Unix, Linux, Solaris, et al you can do a select on an account and get the same results every time, however, on windows you may not. At least with Universe. For a simple test do a select on your current account: SELECT UFD Then do it a second time: SELECT UFD On 'nix systems you will get no difference, but, on windows you will get a list of entries that it says do not exist and the selection count is lower. What I have found is that on the first pass it will select all entries but on the second pass none of the folder type files can be found. An account is usually made up of a variety of file types; including segmented hash and types 1, 19, 25, and 30. What an annoyance when you're trying to create lists for backing up or moving to a test location. -- From: Dan McGrath dmc...@imb.com.au Sent: Sunday, December 13, 2009 6:15 PM To: U2 Users List u2-users@listserver.u2ug.org Subject: [U2] SELECTs on FILEs Hi all, Just a quick question on SELECTs for UD. I was under the impression that performing a wildcard SELECT with @ID would only result the key section of a FILE been read. Eg, SELECT MYFILE WITH @ID = prefix] Is this incorrect? Does it actually result in the entire FILE being read into memory to complete this SELECT? Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. 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 prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Uniobjects and login paragraph
Did I see that someone said Uniobjects bypasses the login paragraph? What else bypasses the login paragraph? Is this on both 'nix and Windows? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV Transaction logging
If you have transaction logging turned on in UniVerse do all changes get logged even those that don't have the code in the programs to start the transaction and commit it? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mapping files.
You also have to have Allownfs set to 1 in your configuration and permissions set on the other server so you can use the file. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Paul Parkinson Sent: Monday, November 30, 2009 9:58 AM To: 'U2 Users List' Subject: Re: [U2] Mapping files. Thanks Mas, tried that didn't work Kind Regards Paul Parkinson Director, Ideal Business Services Ltd mob: +1 758 721 4487 (Caribbean) skype: 0161 408 2098 eml: pparkin...@idealnet.co.uk -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mats Carlid Sent: 30 November 2009 11:46 To: U2 Users List Subject: Re: [U2] Mapping files. Mount \\serverB\unidata as disk Z say and make the voc entry: F Z:filenamn Z:D_filename BUT there is a real gotcha: Don't even think about updating that file from server A as there's no common lock mechanism. -- mats Paul Parkinson skrev: I have 2 servers both running Unidata 7.1 on Windows 2003. In an application on server A I want to access data held in an application on server B I have tried the voc entry in the application on serverA 001: F 002: \\serverB\unidata\filename file:///\\serverB\unidata\filename 003: \\serverB\unidata\D_filename file:///\\serverB\unidata\D_filename I have also tried replacing serverB in the above with the IP address But I get the error open file error no such file. Anyone know what I should be doing? Paul Parkinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code Coverage Project
It won't be used by programmers but would by QC/QA types to check and see if the code is being used or is just a bunch of fluff. One good example would be if your company is using outsourcing to do your programming and the outsource is getting paid on the amount of code they produce, instead of the correct way of getting paid on the quality of their code. You can check to see if all paths through the code are being used or not. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, November 27, 2009 10:47 AM To: 'U2 Users List' Subject: Re: [U2] Code Coverage Project Dan, Although I missed code coverage in programming school, I'm not sure how much UniBasic programmers would or could use code coverage. That being said, why not take an existing program that is fully developed and change the syntax to handle basic syntax. This way you do not have to develop the entire infastracture to run this tool. My suggestion is there are several open source plug-in for Eclipse that can be modified to handle code coverage. There are several examples like jcoverage or gcov that could be used for this type of project. Regards, Doug www.u2logic.com Native U2 drivers for PHP -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Thursday, November 26, 2009 2:35 PM To: U2 Users List Subject: [U2] Code Coverage Project Hi all, For those that are interested, I have setup a project on SourceForge for a Statement Level Code Coverage Tool for UniBasic. It is based on the prototype for a similar tool we now use at my current employer. Although this version is incomplete, it still enables statement level coverage for multiple programs/subroutine with html output. The parser (I really shouldn't use that term) is still quite primitive in this version and may not work with how some programs are coded. http://sourceforge.net/projects/ucov/ For a screen shot of the output and a short post about it, visit: http://u2tech.wordpress.com/ Regards, Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Where is the COMMON block reserved ?
In the first example the common is declared in program 1 and can be used in both program 1 and the called subroutine program 2. In the second example the common is declared only when the second program is called and can only be used by the second program, and any programs called from it. In this case program 1 doesn't know of the common at all. It doesn't matter if you are using connection pooling. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Thursday, November 19, 2009 2:02 PM To: U2 Users List Subject: Re: [U2] [UV] Where is the COMMON block reserved ? Hello, I have a question pertaining to how the shell used by the connection pooling works as it relates to memory allocation. In the following cases: Case 1: Program 1 has a number of variables and matrixes declared in a common section it calls Program 2 which has the same common matrixes and variables declared. Ex: Program 1: COM ABC(100), D,E,F ARG = BLAH CALL PGM2(ARG) Program 2: SUBROUTINE PGM2(ARG) COM ABC(100), D, E,F CRT ARG RETURN Case 2: Program1 doesn't have any common variables declared it calls Program2 which does have common matrixes and variables declared: Program 1: ARG = BLAH CALL PGM2(ARG) Program 2: SUBROUTINE PGM2(ARG) COM ABC(100), D, E,F CRT ARG RETURN In Case 2, is the common block declared in the stack segment or will the common be declared in the same place in both cases ? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata odd error
I can't speak for Unidata but with UniVerse there was no problem going from Solaris to Red Hat. We went to it 4 years ago and I did it on a Saturday. I set up the printers and themaster account ahead of time. 99% of the commands are identical, I think the only problems I had were with the cp and rm commands having an extra switch. If you don't use any of the operating system commands you won't have any problems. Unlike going to Windows the spooler is the same and cups is easy to use. If you are moving from a RISC system to INTEL you have to run fnuxi on the accounts if you don't use backup and restore utilities. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor Sent: Monday, November 16, 2009 8:10 AM To: Jeff Butera; U2 Users List Subject: Re: [U2] Unidata odd error We will be doing the same move next year. Please let us know how the process went, any gotcha's, etc. I've already tested once and did not have any problems with compiling and running the application. Didn't test printing, so I'm a little worried about that. Jeff Butera jbut...@hampshire.edu 11/14/2009 6:47 PM I have a question for you. Why are you moving to RedHat from Solaris? Do you think that Redhat is a better o/s? We run everything else on linux here, the Solaris boxes for unidata are the oddballs. Also, when you compare hardware costs (even with .EDU pricing from Sun) it's a no brainer to move. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] printing html documents
If your html files are in a type 19 file and the location on your network is reachable from your pc, you can kick off the IE browser from Accuterm sending the path of the file and it will pop up like the wed editor. Then you can print it or view it. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Friday, November 13, 2009 12:56 PM To: U2 Users List Subject: Re: [U2] [UV] printing html documents Thanks everyone for your suggestions, I will try them all out! BTW, I'm using Accuterm on linux. -Dianne Dianne Ackerman wrote: I have some documents that were created by users using html editors (different kinds) which then were saved into uv files. I want to read in these documents from within a basic program and send them to the printer, all nicely formatted. Any ideas? The reason I'm doing it from basic is because I have a lot of other data that I'm working with also, the html files are just a small part of it. Thanks. -Dianne ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Agile and Scrum
http://www.agilegamedevelopment.com/2007/12/pair-programming.html XP Development Jerry Banker ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program - to extract data from Table
Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 22:54 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table If you are going to go that far with the minutia then why not just type it in and get done with it? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 2:09 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Actually for many it is mass produced. Specification is being done to the absolute minutia, for example in the Unified Rational process, when generating use cases these get transmitted down to the architectural specifications and become the actual classes in the code (there is even software to build such skeleton code), with each method and property defined, again this is then used by the test plan to test each class/method/property etc. The coder kind of just fills in the gaps. In my previous employment we had whole teams of BA's, DBA's, System Architects, UI Designers, UX analysts etc, Then a bunch of people in the Philipines to do exactly as was written down in front of them. This kind of scenario happens a lot in larger projects. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 18:00 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer
Re: [U2] Unibasic: Sample program - to extract data from Table
Documenting the program or application is always a good idea, it also helps if changes to the programs are documented, but having to write the specs to the smallest minutia is overkill. Unless, you are writing the specs for someone else that doesn't know your business or the next person in line shouldn't be in the position to start with. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Wednesday, October 14, 2009 11:35 AM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table John, I agree that listening to the super users is critical. However, writing a detailed spec will give those super users the ability to review the spec, add their 'second thoughts' (and the wow, this is really cool - could it also do this? ideas before the files are designed and the code written, and really does not take a lot of time. It ensures that the coding team all understand all the aspects of the project the same way. So even with super users, I always waited for a sign-off on the detailed spec before laying out the files and writing the code. I had clients that I worked with for years, and knew their business very well, but taking the time to write a detailed spec was never a waste of my time. I am glad for you that your system works well, but I hope I never have to come in after you all retire! ;-) Susan Lynch - Original Message - From: Israel, John R. johnisr...@daytonsuperior.com To: U2 Users List u2-users@listserver.u2ug.org Sent: 10/14/2009 12:14 PM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table You cannot buy knowledge of a business. Experience with a technology: yes. Knowledge of how a specific company works: no. That only comes with time working at that site. A key to our success is having super-users that really know how the business works, how the software works, and the ability to clearly describe how they want things enhanced. The other half of this coin is having programmer/analysts that understand what the user wants, where the data is stored (or will need to be stored), who ask the right questions, and can work with those super-users. Our users are very happy with what we produce. We have a small U2 team, but a well seasoned team. I rarely have specs and never very detailed. It is all screen shots with hand written notes that come from a meeting or two with the super-users. Requests from non-super-users must go through the super-users. It is my job to understand what they want (which is usually, but not always what they ask for). However, not every business will have these conditions. Contractors have it even tougher since they may have little knowledge of the business they are trying to help. Just my experience... John Israel -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Wednesday, October 14, 2009 12:00 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table As a programmer who has had to maintain and enhance systems that were written apparently based on a one-page spec that everyone on the team understood, when the team members are no longer there, and the documentation was all between their ears (and left with them), I am a big believer in detailed written specs that get turned into test plans and then into documentation. Eventually the lack of specs turns around and bites the organization that allowed it to happen (unless the application was a one-time quick-and-dirty project that will never have to be resurrected). Susan Lynch - Original Message - From: jpb-u2ug jpb-u...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: 10/14/2009 8:18 AM Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Alleluia! Brother! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, October 14, 2009 5:00 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Exactly - i still stick to the belief that a small team of highly skilled programmers will code quicker from a single page spec than a thousand low quality coders using a high detail spec. Many an institution disagrees, or rather has been stung by smaller teams giving promises that they can then not deliver, I suppose this is what bureaucracy is all about, something simple runs perfectly until someone slips up, then all hell breaks loose and 15 procedures are put into place and before you know it you have a team of 20 doing what one guy did all on his own. ___ U2-Users mailing list
Re: [U2] Unibasic: Sample program - to extract data from Table
I don't think anyone was questioning Jay's intelligence. He is probably a very intelligent person or he would not have been hired. What is in question is the intelligence of the individuals that hired the firm he works for and the intelligence of the people that gave him the work to do without first of having him trained on it. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Rubeor Sent: Tuesday, October 13, 2009 8:26 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Excellent points. In my personal experience, I've had terrible dealings with overseas firms. On the flip side, the sharpest person I've ever worked with was from New Delhi. Getting back to the point at hand, I believe that Pick Systems had some development work done in Russia, during the early 90's. I remember their work as being very good and remarkably bug-free. (Of course, I also drank a lot during those days, so my memory may not be that good.) Now,all of a sudden, at the same time that Rocket Software picks up U2, we start getting questions from rsystems in India. Naturally, I wondered if Rocket Software was the company that hired them. Probably not, but I'm still curious. Larry Hiscock lar...@wcs-corp.com 10/12/2009 5:09 PM Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program - to extract data from Table
I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program - to extract data from Table
If you are going to go that far with the minutia then why not just type it in and get done with it? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 2:09 PM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Actually for many it is mass produced. Specification is being done to the absolute minutia, for example in the Unified Rational process, when generating use cases these get transmitted down to the architectural specifications and become the actual classes in the code (there is even software to build such skeleton code), with each method and property defined, again this is then used by the test plan to test each class/method/property etc. The coder kind of just fills in the gaps. In my previous employment we had whole teams of BA's, DBA's, System Architects, UI Designers, UX analysts etc, Then a bunch of people in the Philipines to do exactly as was written down in front of them. This kind of scenario happens a lot in larger projects. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: 13 October 2009 18:00 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table I don't see where you are coming from here. Every program I ever produce is for a specific purpose. We don't create one program and then have an assembly line that types it in several times over and over again. We just make copies of it. Programming takes skill, intelligence, and imagination. It is not a massed produced product like linen or towels where they have to have a body to recreate the product over and over. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, October 13, 2009 9:43 AM To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms are pretty much the same as any other - if you get a small highly focused team of experts they will achieve a lot. The problem is when you get large pools of programmers of various skill levels, and so need more management time than it would take to program it in the first place. But then this is in theory more scalable. I live in the north west of England, just outside Manchester, the Industrial revolution started here, It was once very big in the textile industry- However no textiles are made here anymore, the old Victorian buildings that used to produce these are now trendy apartments, or business parks. There are a few specialist providers, I can kind of see software going the same way. Much of software is grinding out work, that can be done very cheaply in India/China/and Africa soon. All we in the western world will be doing is niche specialist development. Perhaps -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 October 2009 22:09 To: 'U2 Users List' Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Indian development firms aren't all they're cracked up to be, especially in anything other than Microsoft technologies. I've seen exactly this progression in other language lists to which I belong. Indian firm gets contract based on price and claim to know the language. Indian firm tries to get free help from mailing lists, newsgroups, etc, because they don't understand the technology. Indian firm loses contract or is not renewed. We've got personal experience in taking development contracts away from this type of firm. Larry Hiscock Western Computer Services -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bney...@hcmg.net Sent: Monday, October 12, 2009 1:47 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample program - to extract data from Table Doesn't matter which. We are the next group that will be asked to work for reduced pay or our work will go to India. Bruce M Neylon Health Care Management Group Phone: (301) 608-8633 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2
Re: [U2] U2 is now Rocket U2
Prime Information Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dawn Wolthuis Sent: Monday, October 12, 2009 3:32 PM To: U2 Users List Subject: Re: [U2] U2 is now Rocket U2 Love the U2-rocket story, Dominic. I don't know if there is any U2 in Russia or related countries, but I understand that some PICK or PICK-a-like system was used to track Russian spies in the US, perhaps all the way to the end of the cold war. If anyone has details on that, such as which MV flavor it was (something I might have known at one time), I'd be interested. [And, yes, I know, I know, I shouldn't be on this list--it should move over to U2C, but ...] Cheers! --dawn -- Dawn M. Wolthuis Take and give some delight today On Mon, Oct 12, 2009 at 2:36 PM, Dominic Baron dominic.ba...@publictrust.co.nz wrote: Yes, I also like U2. It has interesting historical associations, for those of us of a certain age. It was a U2 spy-plane that was shot down by a rocket over the USSR in 1960 that led to quite a frosty first meeting between Khruschev and Kennedy in Geneva that year. Which leads me to ask if anyone knows whether any U2 (DB's of course) installations exist in Russia or in any of the former Soviet Republics? Dominic Baron. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2
This all depends, if I am reading it correctly, their other products are being advertised until their original names and Rocket is more in the background. So they may advertise the U2 products under a completely different name. What would you like the name to be? Maybe Rocket would like some input on this point. After all we created the term U2 and IBM adopted it. Now, I think we should drop the U2 brand, since a lot of people think we are talking about the rock group, for a more 21st century name. Also we have got to stop calling them Pick databases. Multi-dimensional, multi-valued and extended relational are okay but maybe we can come up with a more futuristic name than that. How about Rocket or the users group starting up a contest to name the new division? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Smith, Robert Sent: Friday, October 09, 2009 8:24 AM To: U2 Users List Subject: Re: [U2] U2 is now Rocket U2 At some point, we will hopefully evolve beyond the old = undesirable mentality that is pervasive in our society, and once again appreciate the imagery that old things can evoke. As a technician with over thirty years experience, I have thoroughly enjoyed the journey I have witnessed since the days of the LP Player...to the iPod of today. What we largely lack today is a sense of history relative to what it has taken for us to progress to this point...and the imagination to achieve even more phenomenal accomplishments in the future. Where once our thoughts were expansive and limitless, they are now reserved and pedestrian. If someone with a sense of history and a determination to use Rocket as a means to evoke the imagery of a time when we thought in grander scales...then they were sadly mistaken. The company should seriously consider changing its name, otherwise they will be the butt of many a jokes. My two cents Rob -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of inquieti Sent: Friday, October 09, 2009 5:03 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2 is now Rocket U2 IBM is very sixties also. Have you ever been to the Apollo space centre? All the computers were IBM and the IBM logo is splashed all around the control room. So I think if you're thinking retro then IBM sits there right along side Sputnik et al. Jacques G. wrote: I wonder what is the marketing idea behind the name Rocket ? To me it invokes late 1950 - 1960's Sputnik/Apollo technology to an epoch when cars designs were made to look like rockets, when there was a hockey player nicknamed Maurice The Rocket Richard and people watched Flash Gordon on a black and white television. When I hear Rocket I think retro like a LP Player, a typewriter, a PDP-1. Wouldn't one want a software product to sound more state of the art ? Sci-fi hasn't used the term Rocketship in decades. Jacques ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://www.nabble.com/U2-is-now-Rocket-U2-tp25693358p25817827.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] hpux to linux; Solaris 2.6 to Solaris 10
A company decision to make everything Microsoft. -- From: Jeff Powell j...@powellclan.com Sent: Wednesday, October 07, 2009 1:25 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] hpux to linux; Solaris 2.6 to Solaris 10 Just out of curiosity, why are you moving to windows? Are there specific benefits? Thanks. On 10/07/2009 10:55 AM, jpb-u2ug wrote: We have moved from Unix V5 on Motorola, to Solaris 2.6, to Solaris 8, to RH Linux AS3, and are now in the process of moving to Windows 2008. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [U2C] what's in a (rocket) name?
Yes, but it may not be all that bad for Universe, you can Take a Rocket to the Universe! But, that doesn't work for Unidata. Jerry Banker -Original Message- From: u2-community-boun...@listserver.u2ug.org [mailto:u2-community-boun...@listserver.u2ug.org] On Behalf Of Results Sent: Saturday, September 19, 2009 11:45 AM To: U2 Users Community Subject: Re: [U2C] what's in a (rocket) name? Allen, I love it... I have it on good authority that the U2 brand (however it is branded) will probably not have Rocket anywhere in then name. So, all, the field is wide open: What would you name the U2 company if you were in charge? - Chuck I Would Name It Chuck Barouch Allen E. Elwood wrote: A LOT! Lets just hope nobody gets acronym crazy and decides to call U2 programs Software Hardware Intelligence Packet Streams Because then we'd have ROCKETSHIPS instead of programs Although, to compete with SQL U2 needs a name boost. Studies show that audiences respond more favorably to names with Q's and X's So, perhaps 'Rocket X2' or 'Rocket XQL' would be a better name than U2??? And of course 'Rocket Extreme' might make it more appealing to youngsters entering college. :-) ___ U2-Community mailing list u2-commun...@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-community No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.409 / Virus Database: 270.13.107/2382 - Release Date: 09/19/09 06:03:00 ___ U2-Community mailing list u2-commun...@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-community ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Indexing
I just tried it on 10.2.4 or UV and it works! Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: Monday, September 14, 2009 8:55 PM To: 'U2 Users List' Subject: Re: [U2] Indexing Yes indeed, however it was removed. Hopefully, it will reappear. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Monday, September 14, 2009 4:26 PM To: U2 Users List Subject: Re: [U2] Indexing I seem to recall that they added the CONCURRENT option to BUILD.INDEX several years back but didn't document it except in the patch file for that release. Does anyone else remember this? Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Sep 9, 2009, at 2:43 , Dan Fitzgerald wrote: Building indices means exclusive locks on the file, i.e., downtime. The good news is that the builds are usually very quick. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] FW: Running a test program and getting an error
Forwarding for one of our .NET developers. Have you got an answer? Jerry Banker Running the test program below and getting an error. Any idea's? C:\Program Files\IBM\SQLLIB\BINtestconn20.exe Database=AACSQL;UserID=swd;Server =linux2;Pooling=False;ServerType=UniVerse Step 1: Printing version info .NET Framework version: 2.0.50727.4016 DB2 .NET provider version: 9.0.0.2 DB2 .NET file version: 9.5.4.2 Capability bits: ALLDEFINED Build: 20090430 Factory for invariant name IBM.Data.DB2 verified Factory for invariant name IBM.Data.Informix verified IDS.NET from DbFactory is Common IDS.NET VSAI assembly version: 9.1.0.0 VSAI file version: 9.5.2.157 ERROR - VSAI file version different from DB2 .NET provider Elapsed: 0.2028169 Step 2: Connecting using Database=AACSQL;UserID=swd;Server=linux2;Pooling=False ;ServerType=UniVerse ERROR [Env_CreateConnection] [IBM U2][UCINET][UNIVERSE]:Failure to logi n as remote user. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Running a test program and getting an error
Hum, oh yeah, that's the ticket, removed it from the line. :-) I've got to start reading what they send me. Good thing that system is our development system on a separate network. I think you were right. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of br...@brianleach.co.uk Sent: Thursday, September 10, 2009 8:39 AM To: U2 Users List Subject: Re: [U2] FW: Running a test program and getting an error Jerry Well, let's deal with the obvious one first - I assume they did also specify the password and you've removed it for the reason of not dumping passwords on to the list? Brian On 10 September 2009 at 15:25 jpb-u2ug jpb-u...@hotmail.com wrote: Forwarding for one of our .NET developers. Have you got an answer? Jerry Banker Running the test program below and getting an error. Any idea's? C:\Program Files\IBM\SQLLIB\BINtestconn20.exe Database=AACSQL;UserID=swd;Server =linux2;Pooling=False;ServerType=UniVerse Step 1: Printing version info .NET Framework version: 2.0.50727.4016 DB2 .NET provider version: 9.0.0.2 DB2 .NET file version: 9.5.4.2 Capability bits: ALLDEFINED Build: 20090430 Factory for invariant name IBM.Data.DB2 verified Factory for invariant name IBM.Data.Informix verified IDS.NET from DbFactory is Common IDS.NET VSAI assembly version: 9.1.0.0 VSAI file version: 9.5.2.157 ERROR - VSAI file version different from DB2 .NET provider Elapsed: 0.2028169 Step 2: Connecting using Database=AACSQL;UserID=swd;Server=linux2;Pooling=False ;ServerType=UniVerse ERROR [Env_CreateConnection] [IBM U2][UCINET][UNIVERSE]:Failure to logi n as remote user. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Hmmmm...Learn something new every day!
You can tell it's Friday :-) Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steven M Wagner Sent: Friday, September 04, 2009 3:56 PM To: U2 Users List Subject: Re: [U2] H...Learn something new every day! And a fine PERFORMance you are providing us. . . . . -- Sent from my Palm Pre George Gallen wrote: I wonder if you use EXECUTE without any CLAUSES, the compiler converts it to a PERFORM? sounds like I'm anti-Santa hereEXECUTING CLAUSES! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, September 04, 2009 4:33 PM To: U2 Users List Subject: Re: [U2] H...Learn something new every day! But the question is, why does removing the CAPTURING CLAUSE fix the problem (allow passing the data). with the CAPTURING, user0 won't pass without the CAPTURING, user0 passes fine I thought PERFORM and EXECUTE were the same? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Friday, September 04, 2009 4:30 PM To: U2 Users List Subject: Re: [U2] H...Learn something new every day! EXECUTE creates a new environment, try PERFORM. From BASIC Help: EXECUTE creates a new environment for the executed command. This new environment is initialized with the values of the current prompt, current printer state, Break key counter, the values of in-line prompts, KEYEDITs, KEYTRAPs, and KEYEXITs. If any of these values change in the new environment, the changes are not passed back to the calling environment. In the new environment, stacked @variables are either initialized to 0 or set to reflect the new environment. Nonstacked @variables are shared between the EXECUTE and calling environments. Tom ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] What ever happened...
Whatever happened to the Toucan? Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Error UV 10.2.4 Reality flavor
I was wondering if any of you have an answer for this problem. We are trying to connect to our test box using ado.net and getting errors. In visual studio we are getting the messages: An error occurred while connecting to the database. The database might be unavailable, An exception of type 'System.Data.ProviderlncompatibleException occurred. The error message is: 'The Provider Manifest is incorrect. File Unknown(399,6): error 0019: Function 'DB2.LEFT with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(427,6): error 0019: Function 'DB2.LOwER' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(441,6): error 0019: Function 'DB2.LTRIM' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(484,6): error 0019: Function 'DB2.REPLACE with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown (501,6): error 0019: Function 'DB2.REPUCATE' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(515,6): error 0019: Function 'D82.REVERSE' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown (530,6): error 0019: Function 'DB2.RIGHT' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown (544,6): error 0019: Function 'D82.RTRIM' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(603,6): error 0019: Function 'D82.STUFF with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous. File Unknown(647,6): error 0019: Function 'DB2.UpPER' with the same Storage space type parameters already exists. Make sure that function overloads are not ambiguous.. On the Universe side I am getting the following in the runtime errlog: Wed Aug 26 12:00:25 -11765 root Program *HS.OLEDBINFO: Line 431, Message[0400 24] Wed Aug 26 12:04:06 -11769 root Program *HS.OLEDBINFO: Line 652, Message[0400 36] Wed Aug 26 12:04:06 -11769 root Program *HS.OLEDBINFO: Line 653, Message[0400 36] Wed Aug 26 12:04:06 -11769 root Program *HS.OLEDBINFO: Line 653, Message[0400 36] Wed Aug 26 12:04:06 -11769 root Program *HS.OLEDBINFO: Line 654, Message[0400 36] Wed Aug 26 12:04:06 -11769 root Program *HS.OLEDBINFO: Line 662, Message[0400 36] And repeats from there. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SBClient 5.3.8 on 64 bit vista
Accuterm has device licensing too. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Friday, August 21, 2009 10:34 AM To: U2 Users List Subject: Re: [U2] SBClient 5.3.8 on 64 bit vista Thanks Steve. I tried running Accuterm and a few other wyse60 emulators but I was getting errors from system builder. I forgot to mention that we have device licensing which is one of the reasons I need to use sbclient. Thanks again. Jeff Steve Romanow wrote: Jeff Powell wrote: I have a user who needs to work from home with his Vista PC. We are having trouble installing sbclient on this machine it is saying this program is not compatible with 64 bit. Has anyone made sbclient 5.3.8 work on a 64 bit vista machine? If not what can I do for this user. We are running Unidata 7.1 with SystemBuilder 5.3.8. We only use character mode. Thanks. Jeff ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Does he use smart query or any dde transfer capability? If not, you can use other clients with SB+. I personally use Putty (on windows and linux) but pretty much any terminal emulator will work (with enough tweaking.) I have TERM.DEFN records for VT100, VT220, and wy60 if you want to tinker. It is a pretty painstaking process, most times you will find that for each offering, almost everything works, but different things broken with each one. Things to check are F1-F4, F11 and F12 for insert and delete. Backspace and Delete compatibility. All of this is easier if you do not require 16-color. I have color working with mine, but it takes out half the work if monochrome is satisfactory. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV on Windows
We are setting up a networked UniVerse Windows 2008 server for future use and coming from a long line of 'Nix processing systems I have some questions about how database administration is handled from those that use a Windows system. The users will all be entered through the network so I know I won't have to worry about doing that any more but what about the other things like file administration? I already know that there is no spooler anymore. Do you use the UniAdmin much or is everything done from the command line? Do you use a separate database administrator login to do database administration or do you have to be the system administrator? The network administrator wants to, understandably, lock the system down as tightly as possible without shutting down the business so how far do you go? When resizing files do they carry the same properties over or do they have to be reset? For those that have moved from Linux to Windows, did you have to change any configuration settings? I tested a short program that was recently bench marked by several people on this list, building a dynamic array, and I was really surprised by the difference in the speed between the various times reported and also my own testing of our current Linux server and the new Windows server (0.6 seconds as opposed to 35 minutes). I reported the difference to my VAR and they sent the results on the IBM. I'm thinking, hoping, that we will just need to change some of the environment variables. I know I can ask my VAR these questions but I want to get more of a consensus from the list. Please let's not get caught up in the 'Nix/Windows battle J. Jerry Banker UV Project Leader Senior Programmer Analyst IBM Certified Solutions Expert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Universe just quits
It also cleans the session up and leaves a system message (050005) in the errlog file of the uv folder so you can track who has been leaving their sessions active. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, July 22, 2009 7:20 PM To: 'U2 Users List' Subject: Re: [U2] FW: Universe just quits Harold, Is there any reason you don't use the UV command AUTOLOGOUT to time out idle sessions? It does what you want already from within UV already (and can be setup individually or globally for all UV sessions) and doesn't have the problem of just looking at terminal keyboard input idle time like the UNIX who command does. Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Thursday, 23 July 2009 7:01 AM To: U2 Users List Subject: Re: [U2] FW: Universe just quits Thanks to all who made suggestions. I'm definitely going to use some of them to improve processing. Good news: Universe is not at fault! So why did the process just end? Because a background process we run logs out processes idle for more than 3 hours. To determine idle time we check the 7th column of the output from the unix command who -HTR. Here was the surprise for me: even though the process was furiously performing I/O, as far as that unix command was concerned, it was idle. Oops! Easy to fix that, of course. The best parts of this were that UniVerse came through as more robust than I had worried it wasn't, and that contributors gave me some great advice. Thanks again to all. Harold Oaks ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe just quits
Sounds like a job for indexing. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 4:54 PM To: U2 Users List Subject: Re: [U2] Universe just quits Barry: Thanks for resonding. The main activity is running thru text files (narratives), identifying the next word then updating a file (DEXNAR) used to cross-reference all the words. For example, in record ABC123 in the narrative field the next identified word is DECOMPOSING. I read the record DECOMPOSING from the DEXNAR file. The record DECOMPOSING has 10 lines in it, because 10 other prior narratives had the word DECOMPOSING. The program seeks the current record key (ABC123) in the fields using the LOCATE command. If not found, the key ABC123 is appended to the end of the DECOMPOSING record and DECOMPOSING it is written out, now with 11 fields. Some of the records in DEXNAR get long as they are for fairly common words, like ALIAS. (The most common words I do not bother to cross-reference, of course, like the word THE). Thus, the LOCATE is looking thru an ever increasing number of fields as we go along. Some records currently have over 11000 fields. Is that the problem? Maybe the sytem tries to 'fit' the next very long record in memory to do the LOCATE and it overflows something? The dropping out, however, occurs normally after updating 25000+ records. Shorter runs seem to 'hold out'. What might be building up in memory space? These are also overnight runs, typically, so there are fewer users to contend with making it unlikely that it's exceeded limits for all users, I would think. The point of the cross-reference file is to allow users to quickly search thru all the 700,000 available (crime) narratives for the ones that match a set of entered search words. Searching that many narratives using brute force would probably take 5+ minutes for each search on our system, which would really stifle the crime analysts. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Tuesday, July 21, 2009 1:03 PM To: U2 Users List Subject: Re: [U2] Universe just quits Can you elaborate a little on these tasks Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner P Before printing please think about your environmental responsibility -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 2:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe just quits I am having a very disconcerting problem. A long job I have been running, processing a large text file and then loading a Universe file, is simply quitting sometimes. No error message of any kind, Universe just quits, the session drops into unix. We have Universe 10.2 running over HPux 11.1. I have reduced the job to smaller pieces to get thru it and indicate data values so that I restart at about the dropout point. So I'll be able to finish but I would like to understand what's going on. Anybody seen this kind of thing before? Is there a Universe parameter I should look at? A unix kernal parameter? Any ideas appreciated. Thanks- Harold Oaks Sr. Analyst/Programmer Clark County Information Systems Clark County, Washington ph: (360) 397-6121 x4132 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 21/7/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review,
Re: [U2] UniBasic - Multiple Accounts
I haven't been following this thread so excuse me if 'm off in left field, but, wouldn't it be better just to set up a file pointer in the VOC that points to where you want to write rather than setting up an entire account and logging to it before you write? Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Tuesday, July 21, 2009 1:52 PM To: U2 Users List Subject: [U2] UniBasic - Multiple Accounts Does it make any sense to . execute LOGTO UPS open 'UPS' to F.UPS else null . write R.UPS to F.UPS... . . execute LOGTO METAL open 'PACK.SLIPS' to F.PS else null . write R.PackSlip to F.PS... Our visiting UPS tech support rep (Ralph Sorrano) suggested creating a new account with a single file in it. Thus, the UPS WorldShip desktop software would not be overwhelmed with hundred of files upon launch. I have not tried it yet. Perhaps there is a better way. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
Is the SP-ASSIGN command that different in UV or is this just flavor dependant? We have an SP-ASSIGN and we are in Reality flavor. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Monday, July 20, 2009 9:23 AM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you do with any other Universe file. In our EDI translator, we use the U-statements in mvBase extensively in reading/writing EDI documents to/from the database to OS-level files for automatic transfer to/from other computers and all the U-statements have been stripped out and replaced with normal OPEN, READ, WRITE statements to/from type 19 files in the Universe version of the product. The only significant difference between mvBase (and all other generic Pick databases for that matter) and Universe is that Universe does not support the generic Pick print spooler for assigning user print output to a queue and assigning a printer to the same queue to enable the printing of the print job to the printer, and all the other features of holding and spooling print jobs to selected printers. None of the generic Pick print spooler commands are available to perform those functions - eg STARTSPOOLER, STARTPTR, SP-ASSIGN, LISTPEQS, SP-EDIT, etc. So all embedded SP-ASSIGN commands have to be converted to SETPTR commands, new print procedures have to be developed and all users have to be retrained in using a much less robust print architecture than they're used to using. AD To bridge this gap in functionality, we developed SpoolerPlus, a generic Pick print spooler, that runs on Universe, Unidata and QM, to provide the generic Pick print spooler commands and functionality built into software migrated from generic Pick databases. I will be pleased to send you some infomation about SpoolerPlus if you wish./AD. Also, please feel free to ask any specific questions about minor differences between mvBase and Universe and I'll be glad to answer them if I can. Best wishes for a successful conversion, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 2:43 PM Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org
Re: [U2] Converting from mvBase to Universe
I'm sorry if I wasn't clear. After looking at what I wrote I can see why but I think you answered my question. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Taylor Sent: Monday, July 20, 2009 12:10 PM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe I'm not sure what you're asking, Jerry, but this may help. The SP-ASSIGN commands differ in syntax between the generic Pick print spooler and the Reality spooler, as follows: Ex. (PickR syntax): SP-ASSIGN (options) (copies) F(queuenumber), R(printfilenumber) Ex. (RealityR syntax): SP-ASSIGN = (queuename) (options) (copies) AD SpoolerPlusR supports both of these forms of the SP-ASSIGN command./AD Universe has its own form of SP.ASSIGN (SP-ASSIGN works also) command, and their syntax is slightly different for Universe/nix vs Universe/doz platforms and is unlike both the generic Pick and Reality syntax above. I don't know if there is a difference between the syntax of the Universe SP-ASSIGN command in a Pick-flavor account vs in a Reality-flavor account on the same operating system. There is no indication in the IBM documentation of such difference based on the flavor of the account. In Universe/nix: the documentation states Use SP.ASSIGN to set the line printer spooler options for each of the 256 logical print channels. In Universes/doz: the documentation states Use SP.ASSIGN to set the line printer spooler options for Windows platform. These differences are due to the fact that Universe/nix does have a spooler that provides some ability to manage and control print jobs other than just print them to the printer, where as Universe/doz has no spooler whatsoever and prints directly to the doz printer, after which ofcourse you lose all control over the print job from Universe. In both cases, regardless of the platform, Universe prints to printers, not to queues, and does not support the print architecture used in both Reality and in other generic Pick databases (which afterall began with Reality) of printing to queues and then printing from queues to printers, including all the flexibilty of holding/suppressing/both any print job, redirecting a print job from one printer to another, using the same printer for multiple print jobs with time to change paper before changing queues, listing and managing all print jobs on hold, etc. AD Changing the printing practices of an entire organization, including rewriting printing procecedures, retraining personnel, expanding the number of printers and serial/network connections and network support necessary to implement a far less powerful and flexible print architecture is usually far more costly than the license fee for a complete generic Pick print spooler solution like SpoolerPlus./AD If I didn't anwer your question, please rephrase it so maybe I'll understand it. hth, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: jpb-u2ug jpb-u...@hotmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Monday, July 20, 2009 9:23 AM Subject: Re: [U2] Converting from mvBase to Universe Is the SP-ASSIGN command that different in UV or is this just flavor dependant? We have an SP-ASSIGN and we are in Reality flavor. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Monday, July 20, 2009 9:23 AM To: U2 Users List Subject: Re: [U2] Converting from mvBase to Universe We actually wrote our own subroutine SP-ASSIGN so that all embedded SP-ASSIGN commands within basic programs don't need to change - they just use our subroutine which calls SETPTR with appropriate commands. -Dianne Dave Taylor wrote: Hi Curt, We have migrated the software on a number of systems from mvBase to Universe running on both Windows and Linux. The good news is that the Pick-flavored account on Universe is very close to mvBase. Also good news is that Universe has two file types - type 1 and type 19 - that are both directory-type files: ie. the Universe file is a Linux directory/Windows folder and each item in the Universe file is a Linux/Windows file in that directory/folder. When a record is written to the Universe file, all the Attr. marks are converted to CRLF sequences and then converted back when it is read by Universe, so the records can even be edited with Notepad from ouside Universe if you wish. This means that you can strip out all the U-statements in mvBase code, define your OS-level file as a type 19 file in Universe (supports long file name compared with the type 1 file) and OPEN, READ, WRITE, etc. directly to/from it just like you
Re: [U2] UV and triggers
If I remember correctly in Prime Information if you used a return in a subroutine it returned to the calling program but if you used a stop it stopped. I have also seen it happen in UV when running a program from Proc. I don't remember how it happened but after converting the program from stop to return I didn't have a problem with it anymore. After that happened I just started using returns all of the time when I built a new program. Jerry -- From: Anthony W. Youngman u...@thewolery.demon.co.uk Sent: Sunday, July 19, 2009 10:29 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV and triggers In message 4a63297f.2030...@comcast.net, Charlie Noah cwn...@comcast.net writes John, I can't believe you're recommending this. The only reason Universe treats a RETURN as a STOP in a top-level program is that Universe tries to be everything to everyone, forgiving mistakes and blunders, and trying to determine what the user really wanted, no matter how badly the code is written. In 1998, we converted from Universe to Jbase, and you can't imagine all the problems we had fixing bad Universe code that worked (sort of) so that it would work in a system that requires you to do things correctly. When coding and breaking rules, you have to consider that the code may be migrated someday. This is a case of just because you can, doesn't mean you should. I doubt that's the case ... STOP may mean stop, but RETURN means go back one level. So RETURN makes perfect logical sense even in an outer program... I'm not talking about using the strengths of your particular implementation even though they are unique to your implementation, just doing dumb things that will bite you (or your predecessor) down the road. I put program in quotes in my last paragraph, because I'm not even sure all variants of BASIC accept the PROGRAM keyword! Certainly in my early days programming PI I never used it, and I *think* the reason I didn't was because it didn't exist in INFOBASIC. iirc it was added at the same time as the FUNCTION keyword. So I wouldn't say John is recommending you use return, I'd say RETURN *always* works because subroutines should always end in a return, and at one time everything BASIC was a subroutine. Oh - and I think PROGRAM and SUBROUTINE are actually synonyms as far as the compiler is concerned :-) Just my 2 cents worth. And my tuppence. Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk '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 http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] which files have triggers
All this talk about triggers and I just received the following from IBM. 7. UniVerse: Flashes Using fixtool to repair UniVerse dynamic file header corruption may result in data loss at 10.3.0 http://www.ibm.com/support/docview.wss?uid=swg21376672myns=swgimgmtmynp=OC SSCRY4mync=E At UniVerse 10.3, modifications made to the new.record contents in a trigger subroutine are not applied when the WRITE completes. http://www.ibm.com/support/docview.wss?uid=swg21392473myns=swgimgmtmynp=OC SSCRY4mync=E Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, July 13, 2009 3:43 PM To: U2 Users List Subject: Re: [U2] which files have triggers Thanks, I found the article. That would make tracking triggers easier. One thing however, in the routine, you have notriggers = dcount(triggers,@fm) for trigno = 1 to notriggers trigger = triggers(trigno) call @trigger(...,newid,newrec,oldid,oldrec,...) next trigno Just curious, since with this routine, you effectively can have a trigger run as many triggers as needed, but, what I see as a problem, is if the 2nd trigger routine modifies NewREC, it will overwrite any modifications that the first trigger may have made to NewREC (assuming a BEFORE trigger). I guess you could assign a temp varible to oldrec, then for each iteration make oldrec = newrec, but then each successive trigger wouldn't have the original data to go by. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, July 13, 2009 3:24 PM To: 'U2 Users List' Subject: Re: [U2] which files have triggers Hi George I wrote about this in one of the back issues of Spectrum (you can download these from www.intl-spectrum.com). I use a master trigger that reads a list of sub-triggers based on the file name. Okay it's an extra read, but it's worth it: the list of sub- triggers (which have the same calling arguments) are all called using regular Call @ syntax; and it allows you to swap in and out sub-triggers without having to drop the main trigger, log everyone off, and recreate it. Since I first wrote that for a 24x7x365 site, that wasn't an option. Also, because UniVerse caches subroutines in memory, it means that when you recompile any changes you want to change the name e.g. MySubTrigger.1, MySubTrigger.2 and so forth. Then change the name in the sub-trigger list(s) when you are sure you've tested it. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] General guidelines on indexing
I have 2 RH Linux AS3 64bit servers one on a Dell 6800 with 4 processors and 16GB memory with UV 10.1.12 and 117 users. The other is a Dell 2500 with 2 processors and 16GB memory with UV 10.2.4 and 6 users. The first takes 0.1876 seconds and the second is 0.1106 seconds. The time varies with the amount of activity and if I run them consecutively but I haven't had any trouble with memory or going over 1 second. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, July 10, 2009 4:15 AM To: 'U2 Users List' Subject: Re: [U2] General guidelines on indexing Ok I am very jealous now of all these quick times, when my one crashed out Can someone remind me (its been years since i did any udt config stuff) what should i be looking at to fix this error Thanks PS - i like this thread i think this can be of benefit to people to fine tune both code and their os and u2 configuration ! -Original Message- From: Symeon Breen [mailto:syme...@gmail.com] Sent: 09 July 2009 14:04 To: 'U2 Users List' Subject: RE: [U2] General guidelines on indexing Unidata 7.1 (32bit) on redhat EL 3 64bit, on XEON E5335 with 4 gig ram. Error when creating a shared memory segment (size=35682416), errno=22 Lol Hmmm ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings Sent: 09 July 2009 13:40 To: u2-users@listserver.u2ug.org Subject: Re: [U2] General guidelines on indexing IBM BOX (OLDER) PICK.FORMAT 10.0.11 6.9377 seconds Linux box PICK.FORMAT 10.2.0 0.3522 seconds Date: Thu, 9 Jul 2009 11:20:25 +0800 From: adrian.wom...@rac.com.au To: u2-users@listserver.u2ug.org Subject: Re: [U2] General guidelines on indexing I just tried this example on Universe 10.2.6 - it took 0.0665 seconds - basically instant, can't complain about that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Thursday, 9 July 2009 12:59 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing By way of a simple expample, I just tried the following program... s = '' z = str('*', 1000) t1 = time() for i = 1 to 10 s-1 = z next i t2 = time() crt t2 - t1 This took six seconds on QM but 32 minutes on UniVerse. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ HotmailR has ever-growing storage! Don't worry about storage limits. http://windowslive.com/Tutorial/Hotmail/Storage?ocid=TXT_TAGLM_WL_HM_Tutoria l_Storage_062009 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] General guidelines on indexing
I tried it on my system UV 10.1.12 on Linux AS3 0.643 seconds. -- From: Martin Phillips martinphill...@ladybridge.com Sent: Thursday, July 09, 2009 3:38 AM To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] General guidelines on indexing Hi Adrian, I just tried this example on Universe 10.2.6 - it took 0.0665 seconds basically instant, can't complain about that. I am sure that something must have been wrong with your test. This probably isn't long enough to do even the empty loop with no string copy. I have just repeated my test on a different system running UV 10.2.8 and the test took 38 minutes. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] General guidelines on indexing
It's been a long time since I've been in hardware so I may be all off on this, but, this could be possible because after it sends the WRITESEQ it's basically up to the disk subsystem to actually do the writing. The written sequential record get's put in the queue and the subsystem sends back a signal that it's been done and to continue. However that doesn't necessarily mean it has completed the write. By the time the process is done the sequential file may not have completed writing all of the records in the queue but the process will think it has. I know I have noticed this happen when writing to a networked file system and it makes the file unusable until the writing has completed. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Manyevere Sent: Wednesday, July 08, 2009 10:44 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing In one test I did a couple of months back, I found that appending IDs to the end of a dynamic array perfomed _much_ _much_ slower than a WRITESEQ to the end of a disk file and the dynamic array wasnt even a 100 000 records long. We were able to reduce the time required to produce a report from over 30 minutes to less than 2 minutes by removing the dynamic array operations and replacing them with WRITESEQs. We tried all the different syntaxes of appending to the array with no noticeable difference in poor performance once the array got large. - Original Message From: Baakkonen, Rodney A (Rod) 46K rodney.baakko...@cigna.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wednesday, 8 July, 2009 17:15:57 Subject: Re: [U2] General guidelines on indexing In theory, I would have to agree with you. Who knows how all this stuff really works under the hood. You have Unidata Shared memory management and shared basic code server. We also have a huge SAN with a lots of cache. Measuring performance and impacting it is different these days. There are so many layers and events, finding the bottleneck can be tricky. All I can tell you is that we did extensive testing and we would not be doing what we are unless it worked. Maybe on you site, on your server and your database, these techniques don't enhance performance. I'm telling you what we found, your mileage may vary. We have been told to use concatenate with a @AM to build our arrays, as Unidata has a pointer to the end of a variable. We have been told to use REMOVE when pulling data out of the array. We know that. We still had performance gains that went from days to hours when we changed to a well sized work file. There are many reasons why we use the work file. Typically this is used in the selection part of the process. The sorting and reporting is after. Sometimes the work file contains more than keys ( vs. having multiple dynamic arrays). Sometimes multiple reports are generated from the same work file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Wednesday, July 08, 2009 6:47 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing I don't agree. Disk access is inherently slower than RAM access. Therefore a process that makes efficient use of RAM will be faster than an equivalent algorithm making efficient use of disk. In your case, it's just a matter of scale: 50 million records at (lets say) 14 bytes per ID plus the multivalue marker needed to build up the dynamic array. 15 * 50,000,000 = 750,000,000 bytes. That's 732,422KB, 715MB If your process is running on a modern server then this kind of op becomes practical. Assumptions: - that the dynamic array isn't using Unicode. If it is then memory reqirements double. - That you select every record - normally (presumably) it would be just a fraction? In fact isn't all of this theoretical? Using the index select / readfwd / own tests method, there's no need to build workfiles or dynamic arrays at all - simply do the tests as each record is retrieved with readfwd and then create the report / do the processing all within the same loop? Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: 08 July 2009 12:30 To: U2 Users List Subject: Re: [U2] General guidelines on indexing When you have a file with 50 million records, it does not matter how you build the or parse the dynamic array. A well sized work file will run circles around the dynamic array. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Edward Brown Sent: Wednesday, July 08, 2009 6:12 AM To: U2 Users List Subject: Re: [U2] General guidelines on indexing After indexing, we made a lot more use of the SETINDEX and READFWD logic in our programs. I find this curious
Re: [U2] Mixed Case UV Basic Programming Standards.
Code in uppercase and mixed case for Comments, displayed messages/queries, and error messages. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Wednesday, June 24, 2009 1:39 PM To: U2 Users List Subject: [U2] Mixed Case UV Basic Programming Standards. I don't like the way I use mixed case, so it tends to evolve. Not good, because consistency in programming style throughout an application makes for easier maintenance, maintainability is the god of software quality. So I am wondering how others use mixed case. Do you capitalize/lower/mix case for commands? Operators? Variables? Equates? etc. How do you use/not use special characters in variable names? For example: readu OrderMaster from ORDER.MASTER, OrderMasterId locked ... readU OE_rec from OE_f, OE_id locked ... ReadVU OE_Date From ORDER.MASTER, OE$Id, OE$Date Locked ... READU order.master.rec( oe$date ) FROM order.master.file, order.master.id LOCKED ... That sort of thing. I hesitate to even ask this for fear of starting a war. So ground rules for this thread: 1. NOT about MERITS of Uppercase only vs. Mixed Case programming. I am only interested in answers from people who actually use mixed case. 2. NOT about GOTO. Take it outside. 3. This is about PREFERENCE, NOT SUBSTANCE. By substantive I mean rules like: - Only open a file once. - Readu should always have a locked clause. By preference I mean stuff like my example. They are all functionally equivalent. 4. NO ARGUMENTS about whether someone's style is good or bad, or yours is better. Explaining why you do it a certain way is helpful, though. Just remember, when it comes to preferences, no two programmers will agree, yet consistent style, whate'er it be, increases maintainability. Thanks, Chuck Stevenson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I Descriptor for long filename in type 1 file
Create a type 19 file and redirect the logs to the new file. UFD is a bad place to store these types of files anyway because it is the account directory. When yo go to clean up the file you may accidently remove part of your account. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Tuesday, June 23, 2009 8:55 AM To: U2 Users List Subject: Re: [U2] I Descriptor for long filename in type 1 file Why not just resize UFD to a type 19? Norman, David (Health) wrote: UV 10.2.16 HP-UX 11i UFD is a type 1 file by default. I have some files in UFD with long filenames that go down 1 level. I have created an I-type to extract delimited fields within the @ID which either spans the 2 levels, or is wholly in the 2nd level. Using this I-type to display in a LIST works perfectly. However, as soon as a WITH references this field, nothing is returned. E.g.: LIST UFD WITH @ID LIKE ...as... SAMPLE 5 DATE2 11:10:14 23-06-09 PAGE 1 OS filename...DATE LOG.as13713_15125_49176 29.05.09 LOG.as13713_15125_58659 29.05.09 LOG.as13713_15125_59104 29.05.09 LOG.as13713_15125_59132 29.05.09 LOG.as13713_15125_60631 29.05.09 Sample of 5 records listed. ::LIST UFD WITH DATE2 = 29.5.09 0 records listed. The DICT of DATE2 is: 0001: I 0002: FIELD(@ID,'_',2) 0003: D2. 0004: DATE 0005: 8R 0006: S I don't want to resize UFD to type 19 on this mission-critical 24x7 system - how else can I get WITH to use these fields ??? David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.aumailto:norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Currently preferred Linux distro
This won't be a problem if you use uvbackup and uvrestore. Otherwise you will have to do a fnuxi. If you've been testing with fedora then your best bet would be RH Linux. It's supported and a fairly good track record. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, June 16, 2009 7:46 AM To: U2 Users List Subject: Re: [U2] [UV] Currently preferred Linux distro When you convert your data, be aware of the endian-ness of the two platforms. AIX to x86 will require a conversion. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse Unit Testing
Doug and Brian, Could you give me some numbers on how long and how many people (man hours) it took to do the changes? Approximately how many programs did you have to convert to the new way and what did you end up with? Jerry Banker From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Thursday, June 11, 2009 7:55 AM To: U2 Users List Subject: Re: [U2] UniVerse Unit Testing Brian, You say that you designed all our server code as subroutines such that all of our subroutines had one of two calling interfaces. This would seem to mean that you built and maintained two different versions of every external subroutine/function. Is this correct or am I just missing something? Thanks. Perry _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, June 11, 2009 3:19 AM To: 'U2 Users List' Subject: Re: [U2] UniVerse Unit Testing Hi At my last company, we spent a lot of effort on building an automated test rig for our software, because we had to support multiple platforms and all our code required full regression testing. It may be a slightly different scenario to yours, since we were primarily building tools, and also this was complicated by the fact that all of our software was client/server in some way, and usually involved several languages .. but here is our experience for what it's worth: The bad news is that you really need to design these in from the start. We designed all our server code as subroutines such that all of our subroutines had one of two calling interfaces, either: Subroutine name(InData, OutData, ErrText) or Subroutine name(Action, InData, OutData, ErrText) That meant that we could generate a test rig that could feed the InData (and Action) and then test for the OutData and log any ErrText values. For reports, we would capture the report text and do 'spot checks' on the expected results. We also version stamped our routines, so we were certain we were testing the right versions, and had build scripts to recompile everything. Nothing left to manual operation since that opens up the opportunity for something to get forgotten: there is no point testing stuff to QA and then doing something different when you come to release! Incidentally, since this was client/server, these involved VBScript scripts for the client end calling cutting paragraphs on the server along the line. Because Universe code doesn't break down into simple blocks, unless you want to instrument your code and capture all your file I/O - which is possible - and test for that, your only sensible option is to unit test at the subroutine/external function level. The good news is that because UniVerse caches subroutines in memory, the overheads to breaking out code are not as high as on systems that do not. it also means you end up with a more manageable system, better options for reuse and if you adopt different client front ends, easier to migrate. You may also find out that your code mass reduces as you split these out, because there is less duplication (sorry if I'm stating the obvious here) and so your testing domain is reduced also. If you want clean-room regression testing, I highly recommend Virtual PC is it will support your OS. We kept clean images of all the platforms we supported, which was a huge time saver. One nice thing about VPC is that it supports 'undo disks' which means that you can snapshot the image at a particular point, and then any changes e.g. brought on by software loads for testing are physically and transparently stored outside the virtual disk and you choose at the end whether to commit those changes or not, making it very easy to go back if that version didn't pass. Finallly, having a predictable way to load routines from dev to QA and from QA to live is a must - so I'll put in a very small [AD] for mvInstaller... Regards Brian _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: 10 June 2009 20:33 To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse Unit Testing The powers that be have been discussing the possibility of going to a unit test model for QA. As I understand the concept, portions of code are broken down into smaller manageable chunks against which a dedicated unit test for each may be run. This seems like a good idea in an object oriented world where methods of object can be easily invoked. This would seem less practical in with a procedural language like BASIC. It feels like we would end up breaking out thousands of lines of code into external subroutines which could then be run through a dedicated unit test. This would introduce significant overhead with all the CALLs to hundreds (thousands) of external subroutines. Then there are
Re: [U2] [u2u] UV on Windows question
Let's see now. I have been working on Unix type systems for 30 years and never had an anti-virus program running on any of them. Can you say the same about Windows? In that time only one of them got hacked. Can you say the same about Windows? I can go on if you wish. Jerry Banker From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, June 02, 2009 3:07 AM To: 'U2 Users List' Subject: Re: [U2] [u2u] UV on Windows question It is the rated by the experts as the best of the systems, What experts ? The first reason is that Unix systems are not susceptible by Windows viruses. A protected windows server would not be either - we are not talking desktops here with users surfing the internet all day. From: Dave R [mailto:dave.ra...@juno.com] Sent: Monday, June 01, 2009 3:54 PM To: jpb-u...@hotmail.com Subject: Re: [u2u] UV on Windows question Unix has it's own set of administration tools different the windows administration tools, I don't believe they require about the same knowledge to use, if you are a windows engineer you would like a windows platform and if you are a Unix engineer you would prefer Unix. Even thought I use a Windows platform I prefer Unix systems as a platform for a Multi-Value system. If you want to purchase a new system then I would go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the rated by the experts as the best of the systems, Unidata would be next, and UniVerse would be 3rd. The first reason is that Unix systems are not susceptible by Windows viruses. The second reason is security, Most windows hackers are complete lost in UNIX. The Unix systems are more robust. The file management is improved in Unix and The Unix OS was designed for multi users and by mainframe software engineers who have a far more knowledge of multi user environments. Most companies hire windows network engineers and they don't like the idea of Unix platforms. However most large companies run Unix or Aix or Hpux for the platform for Reality or U2. Some other considerations would be if you are coming from a different Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have switches to creating an environment to run that flavor of Multi-Value, requiring little to no conversion of the software and database. A big cost factor in the conversion. Dave R. 949 757 8519 (work) eFax (815)4259364 -- Original Message -- From: JPB-U2UG jpb-u...@hotmail.com To: u2-users@listserver.u2ug.org Subject: [u2u] UV on Windows question Date: Sat, 30 May 2009 16:00:37 -0500 I've never worked with UV on Windows so I would like to know, apart from the obvious differences of the operating system, is there much difference in administering the database in Windows as compared to Linux/Unix. Criminal Lawyers - Click here. http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2jcygQ1UHaGxeSYz U7qCu4EnncAfGU1lK5Ikr5JJDuhy/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2u] UV on Windows question
I really didn't want the question of the differences in administration of Universe to turn into a Unix vs Windows battle. Jerry Banker Ps: However if you want to then bring it on.:-) On the community list. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, June 02, 2009 3:07 AM To: 'U2 Users List' Subject: Re: [U2] [u2u] UV on Windows question It is the rated by the experts as the best of the systems, What experts ? The first reason is that Unix systems are not susceptible by Windows viruses. A protected windows server would not be either - we are not talking desktops here with users surfing the internet all day. From: Dave R [mailto:dave.ra...@juno.com] Sent: Monday, June 01, 2009 3:54 PM To: jpb-u...@hotmail.com Subject: Re: [u2u] UV on Windows question Unix has it's own set of administration tools different the windows administration tools, I don't believe they require about the same knowledge to use, if you are a windows engineer you would like a windows platform and if you are a Unix engineer you would prefer Unix. Even thought I use a Windows platform I prefer Unix systems as a platform for a Multi-Value system. If you want to purchase a new system then I would go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the rated by the experts as the best of the systems, Unidata would be next, and UniVerse would be 3rd. The first reason is that Unix systems are not susceptible by Windows viruses. The second reason is security, Most windows hackers are complete lost in UNIX. The Unix systems are more robust. The file management is improved in Unix and The Unix OS was designed for multi users and by mainframe software engineers who have a far more knowledge of multi user environments. Most companies hire windows network engineers and they don't like the idea of Unix platforms. However most large companies run Unix or Aix or Hpux for the platform for Reality or U2. Some other considerations would be if you are coming from a different Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have switches to creating an environment to run that flavor of Multi-Value, requiring little to no conversion of the software and database. A big cost factor in the conversion. Dave R. 949 757 8519 (work) eFax (815)4259364 -- Original Message -- From: JPB-U2UG jpb-u...@hotmail.com To: u2-users@listserver.u2ug.org Subject: [u2u] UV on Windows question Date: Sat, 30 May 2009 16:00:37 -0500 I've never worked with UV on Windows so I would like to know, apart from the obvious differences of the operating system, is there much difference in administering the database in Windows as compared to Linux/Unix. Criminal Lawyers - Click here. http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2jcygQ1UHaGxeSYz U7qCu4EnncAfGU1lK5Ikr5JJDuhy/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2u] UV on Windows question
I just rebooted my Linux systems last week the first time in about 6 months. The reason, because the windows servers on our network have been changed so many times that they were finally starting to affect Samba on the Linux server. I couldn't just change the IP addresses anymore and restart Samba, I actually had to reboot the system. I have had the system up so long that I got a message like Lee's but I try to reboot at least once a year just so the heads don't weld themselves to the disk surface if I do have to bring them down for some reason. I don't think we have ever had a windows server stay up more than a week so I think you are either lucky or you very seldom install a patch on your server. Jerry Banker From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, June 02, 2009 9:04 AM To: 'Lee Bacall'; 'U2 Users List' Subject: Re: [U2] [u2u] UV on Windows question My main web server running windows server 2003 was last rebooted Feb 2008 ! I think people when you say windows think about their own experience of their desktop whereas when it is on a server the whole usage is very different, that is what i am trying to get across ! Having said all this yes i would prefer linux just because of its ease of tuning using the shell and text based config files is much easier than say a gui and the registry. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lee Bacall Sent: 02 June 2009 14:14 To: U2 Users List Subject: Re: [U2] [u2u] UV on Windows question Right on Jerry. We recently experienced a violent lightning storm here in South Florida. While we have a backup generator and multiple UPS systems, transient protection, etc., we thought it prudent to bring down some systems, do some spring-cleaning and vacuum out the dust bunnies and cat fur from the fans and filters. When bringing up one of the SUSE Linux servers, running uniVerse, I was greeted with the message: System has gone 220 days without a shutdown. To quote Jerry, Can you say the same about Windows? Lee Bacall http://www.binarystar.com - Original Message - From: jpb-u2ug mailto:jpb-u...@hotmail.com To: 'U2 mailto:u2-users@listserver.u2ug.org Users List' Sent: Tuesday, June 02, 2009 8:58 AM Subject: Re: [U2] [u2u] UV on Windows question Let's see now. I have been working on Unix type systems for 30 years and never had an anti-virus program running on any of them. Can you say the same about Windows? In that time only one of them got hacked. Can you say the same about Windows? I can go on if you wish. Jerry Banker ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2u] UV on Windows question
How interesting, you can't just reply to the email anymore, you have to change the to address. Jerry Banker From: Dave R [mailto:dave.ra...@juno.com] Sent: Monday, June 01, 2009 3:54 PM To: jpb-u...@hotmail.com Subject: Re: [u2u] UV on Windows question Unix has it's own set of administration tools different the windows administration tools, I don't believe they require about the same knowledge to use, if you are a windows engineer you would like a windows platform and if you are a Unix engineer you would prefer Unix. Even thought I use a Windows platform I prefer Unix systems as a platform for a Multi-Value system. If you want to purchase a new system then I would go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the rated by the experts as the best of the systems, Unidata would be next, and UniVerse would be 3rd. The first reason is that Unix systems are not susceptible by Windows viruses. The second reason is security, Most windows hackers are complete lost in UNIX. The Unix systems are more robust. The file management is improved in Unix and The Unix OS was designed for multi users and by mainframe software engineers who have a far more knowledge of multi user environments. Most companies hire windows network engineers and they don't like the idea of Unix platforms. However most large companies run Unix or Aix or Hpux for the platform for Reality or U2. Some other considerations would be if you are coming from a different Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have switches to creating an environment to run that flavor of Multi-Value, requiring little to no conversion of the software and database. A big cost factor in the conversion. Dave R. 949 757 8519 (work) eFax (815)4259364 -- Original Message -- From: JPB-U2UG jpb-u...@hotmail.com To: u2-users@listserver.u2ug.org Subject: [u2u] UV on Windows question Date: Sat, 30 May 2009 16:00:37 -0500 I've never worked with UV on Windows so I would like to know, apart from the obvious differences of the operating system, is there much difference in administering the database in Windows as compared to Linux/Unix. Criminal Lawyers - Click here. http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2jcygQ1UHaGxeSYz U7qCu4EnncAfGU1lK5Ikr5JJDuhy/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[u2u] UV on Windows question
I've never worked with UV on Windows so I would like to know, apart from the obvious differences of the operating system, is there much difference in administering the database in Windows as compared to Linux/Unix. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Best algorithm for UV part files
We use one part file made up of 13 different files. The record key makes it easy for us because they are all numeric. We just made the algorithm MOD(key,13) + 1. The reason for 13, it's a prime number and the number of records per file seem to come out about equal. Of course we don't have a special purpose for each part file it's just to reduce the size of the file. The set of files contains 2.3 million records but each part has less than 180 thousand. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, May 28, 2009 11:16 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best algorithm for UV part files Hi Baker Unless I misunderstand the question - it don't work like that :) UniVerse uses the partitioning algorithm to determine which part file the record goes into, based on some operation performed on the key that must yield as its result a valid part file number. So you could, for example, perform a hashing algorithm on the key by multiplying the seq() of each character together and divide the whole lot by the number of parts to get a modulus - just like the addressing inside a hashed file... Once that algorithm is in place, every time you request a key it will perform the same operation to determine in which part file it will find the record. So you don't need to specify the part file number along with the key - the key determines the part file. Regards Brian -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 28 May 2009 16:06 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best algorithm for UV part files Very helpful Stuart (and Brian) thanks. 1 follow-up question: given your algorithm below, when you edit or copy those records over, what does the key look like. E.g. do you have to prefix the key generated by your algorithm, with the part file number or name? To edit the record would you simply: AE HAIRY.PF.NAME B123456 Or AE HAIRY.PF.NAME 23-B123456 ? 74 Clear regards from Ft Worth, -Baker --- 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 from PHANTOM
I don't know about Unidata but Universe phantoms run as the person that kicked them off. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Friday, May 15, 2009 8:19 AM To: u2-users@listserver.u2ug.org Subject: [U2] SELECT from PHANTOM We are using Unidata 7.1 on RedHat and are testing a new system. A barcoding system drops transactions into a UNIX directory and a batch processor running in background (PHANTOM) periodically checks the directory to see if there are any transactions to process. Transactions are making it to the directory OK. And when you select the file at ECL it selects the transactions, but when the batch processor selects the file, it selects no records. I guess I suspect an issue with the user that the PHANTOM process is running as. Who is that? The user that started the PHANTOM? Or the system? Charles Shaffer Senior Analyst NTN-Bower Corporation --- 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] Help with encryption
Charles, If you have Outlook you have to use the out of office assistant on the tools menu. You can make it so no message goes to the list. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Tuesday, May 12, 2009 3:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help with encryption Hello, This is to the moderator. I will be going on vacation next week for two weeks and will set my out of office message before I go. How do I stop from sending these messages to the list and how do I reenable the list when I get back. Charles Shaffer Senior Analyst NTN-Bower Corporation --- 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] Employment disaster
I wouldn't say that too loudly there's a lot of potential employers on this list. Most smart companies like to have someone that is willing to stick around long enough to learn their business logic. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, April 22, 2009 5:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster jpb-u2ug wrote: snip Oh and one of these days you are going to be sitting in the same seat talking about the good old days too, and someone is going to be telling you that you're a dinosaur. It's not easy trying to keep up with the technology and if your company isn't using it you tend to gravitate toward what they do use. Jerry Banker Not me Jerry, I usually don't stay long enough for that to happen. If there's nothing new to learn I move on. --- 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 to SAP migration disaster
I resemble that remark. Actually what I was trying to get at was the education and marketing factors. I'm not trying to slam MS or any other operating system. I think that all technology should be used for what it is good at. The right technology for the right task. I just think that the education these new programmers are getting has no depth. They're not being told that what they are being taught may not be what they will encounter in the business world. A case in point is the new thread that just started with the subject: [U2] Getting a graphical view of my data in UniVerse Oh and one of these days you are going to be sitting in the same seat talking about the good old days too, and someone is going to be telling you that you're a dinosaur. It's not easy trying to keep up with the technology and if your company isn't using it you tend to gravitate toward what they do use. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Monday, April 20, 2009 2:23 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster I second that. And don't forget those people who have been in the same company and the same office for over 20 years and still reminisce about the 'good old mainframe days'. The first thing a new guy hears is, 'We don't like change here!' Upgrading? Don't fix it if it ain't broke! If you get a request, tell the requester that this is very difficult to do and could have all sorts of implications for the rest of the system. Or even better, 'we can't make any changes because then we can't upgrade the software later, and therefore only the software vendor can make changes to the code.' And of course at #1000 a day for their consultants it better be important. If he or she still wants it, ignore it until they ask again. If they don't, it obviously wasn't important enough anyway. Users will find a way to solve their problems without IT, and in no time the whole business runs on spreadsheets because the stupid 'legacy' software is useless anyway. And who's fault is that? And then you get stupid software vendors who want to sell only their latest web-based, platform independent software product and tell management they will stop support for that old product soon and therefore they should rather not upgrade and buy their latest toy. Or of course the old IT-manager retires and they hire a follower of the Church of Codd as replacement. I've been around and seen it all. It isn't always a PHB. Symeon Breen wrote: There can also be blame at the coalface as well - I know many pick guys who really are dinosaurs and who bury their head in the sand if xml, web services, web access etc are mentioned ... -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Glenn Sallis Sent: 20 April 2009 14:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV to SAP migration disaster It's yet another story that makes people who know and understand the multivalue database model cringe. Often one of the reasons for migrating seems to be due to decisions being made upstairs by people who have not bothered to consult the people with the knowledge to inform of the technical realities and work involved in such a major change. I have noticed over the years that SAP has been very heavily marketed. There is usually a reason for a product needing to be advertised ;-). Just because a product has massive marketing muscle behind it doesn't mean it's the bee's knees. I'm sure this story won't be the last expensive disaster! Glenn Sallis Software Developer Flextronics Logistics B.V --- 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 to SAP migration disaster
In our particular case the IS Manager, who was a Pick programmer retired. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Rex Gozar Sent: Monday, April 20, 2009 9:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster I guess the basic premise of your argument is that the PHB's are listening to 90-day-wonder windows programmers, and they encouraged said PHB's that they needed to replace the UV database. I don't buy it. Even PHB's don't go spending millions of dollars on SAP just because their 25 year old windows programmers don't think UV is productive. In the case of Shane Co. the PHB's decided to spend millions of dollars -- and no one bothered to do an ROI study? Or it was fabricated by a bunch of idiots without any concept of reality? At some point, Shane Co. must have been doing good. They were expanding. It seems a short time ago I heard they opened a new store here in Orlando, FL. (Or maybe they weren't doing that good after all and the expansion was a feeble attempt at opening new markets to generate revenue.) During this expansion, one of the PHB's must have said we AREN'T getting what we need from IT; let's look into other solutions. Or maybe they said, we CAN'T get what we need. (The former speaking to an unwillingness to address needs; the latter, lacking capability to do so.) And this brings me back to my original question: what was Shane Co.'s REAL reason for deciding to migrate away from UV? If Universe is supposed to be a superior environment for building and deploying business solutions, why couldn't their existing IT staff deliver? Why? It's too easy to characterize management decisions like this as frivolous or political. But it's irresponsible to ignore the true business reasons behind these decisions, dooming ourselves to repeat history's mistakes. rex JPB-U2UG wrote: I can't speak for everyone but if it's anything like at our place, it's due to lack of education. UniVerse is contains all of our business logic and Microsoft is used for our presentation layer, desktop and web. We have 3 programmers working on UniVerse with an average age of 55. In our windows area we have 10 programmers with an average age of 25. Most of the people coming out of the colleges and universities only know one platform Microsoft. They are taught nothing... --- 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 to SAP migration disaster
I can't speak for everyone but if it's anything like at our place, it's due to lack of education. UniVerse is contains all of our business logic and Microsoft is used for our presentation layer, desktop and web. We have 3 programmers working on UniVerse with an average age of 55. In our windows area we have 10 programmers with an average age of 25. Most of the people coming out of the colleges and universities only know one platform Microsoft. They are taught nothing about processing data, database structure, proper logic, or problem solving. They are not even being taught Unix anymore. I think the colleges are doing their students a disservice because most businesses are still running other platforms for their business logic and only have windows as the presentation layer. This causes a problem because when the business wants to hire someone they don't have anything except these 90 day wonders to choose from. The candidate has problems because they have never been taught how to use anything other than the windows tools. This isn't exclusive to U2, it's a problem with any of the proprietary operating systems/products and anything on Unix/Linux. This gives the PHB's the mistaken impression that anything not windows is obsolete and they should scrap what they have and go towards all MS or anything else that looks pretty. The new programmers are more than happy to get on board with the idea because most of them want to be working in what they are taught. They don't know what business logic is and they think it would be a walk in the park to switch. After all they were able to build that web page, right? They, of course, forget that the data had to be there before they could present it. The PHB's find that there is a bigger pool of willing low cost employees to choose from and force all of their people that actually know the business logic off the payroll. Then the nail is in the coffin. The new programmers all of a sudden discover that there is something happening in the background that they were not aware of, they try to reproduce it but nothing seems to work the same as it use to. Pride takes over and nobody wants to admit that they may have made a mistake. They don't notify the PHB's that there is a problem, they start panicking, they don't want to rehire the employees they got rid of, so they hire some consultants that don't know the business logic any more than the people that are there. It's not the consultants fault they were expecting that someone at the company knew something about how the company operates. By the time all of the problems come to light the company is on the brink of bankruptcy. Where does the blame go, the people that left were at fault for not giving the youngsters all of the information they needed. -- From: Rex Gozar rgo...@autopower.com Sent: Friday, April 17, 2009 4:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster I've been wondering why the Shane Co. felt the need to migrate away from UV. * Was their IT staff unable to meet business requirements due to the limitations of UV? * Was their IT staff to blame, rather than the UV database environment? (i.e. understaffed, lack of skills, etc.) At any rate, it appears that either (or both) caused Shane Co. management to look for a different solution. Under the assumption if it ain't broke, don't fix it I would think that management thought something was broken, and they needed to spend money to fix it. Does anyone have any first-hand knowledge of the specifics? Anyone care to share their insights? rex John Hester wrote: There were a few posts back in January about Denver jewelry retailer Shane Co. and their disastrous migration from UV to SAP. Today they're starring in an eWeek slideshow about I.T. disasters: --- 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 Problem
It's using it like matching. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, April 14, 2009 11:07 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Select Problem I have just encountered an inconsistency between the native UniData select and the PICK flavored select. From a PICK flavored account, it I use the lower case sselect to force native UniData syntax, I get: sselect ITMMST WITH F2 LIKE ...J1A... (6,213 keys - wrong) If I immediately follow this with the PICK select: SELECT ITMMST WITH F2 = [J1A] (No keys - correct) These two statements SHOULD return the same results. Interestingly, if I use a less restrictive select (search for J1 instead of J1A), I get the following: sselect ITMMST WITH F2 LIKE ...J1... (188 keys which is correct) I am guessing that the UniData flavor is treating the J1A as something else, but until I can figure out what it is doing, I can not come up with a work-around. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 --- 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] HP, Cron, Como, Execute, Capturing . Not
We do it all of the time with no problem. UV 10.1.12 on RH Linux AS 3. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tony G Sent: Monday, February 23, 2009 9:37 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not We have a client on UV/HP-UX running a BASIC routine from a Cron job. The BASIC code shells out from EXECUTE and Captures data from the OS. The Capture is failing and it looks like COMO gets the StdOut that should be directed into a variable. I'm not sure yet if Como plays any part or if all Execute/Capturing instructions will fail when executed from Cron. The code works fine from TCL. I'm also checking to see if there are any other options or middleware, and exactly what's being executed in the Cron line. Until I get more info though, I'd like to know if this is a recognized issue. Under what conditions can we expect something like this to fail?: Execute sh -c ... Capturing result Thanks. Tony Gravagno Nebula Research and Development Info@ removeNebula-RnD.com (Various other email addresses are currently down ... it's Monday...) --- 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] Unidata to Oracle
I'm sure we would all like to see how that turns out as well. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Ritchie Sent: Thursday, February 19, 2009 4:21 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Leaving U2 World to the Dark Side (SQL) Good luck Don, actually finding MSSQL pretty easy to use in a web application I am helping to develop. Excellent integration with MS's Visual Web Developer. If it makes you feel any better I am currently involved in a project to move a long term Unidata db to Oracle. Cheers, Jeff -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Don Verhagen Sent: Thursday, 19 February 2009 10:04 PM To: u2-users@listserver.u2ug.org Subject: [U2] Leaving U2 World to the Dark Side (SQL) To those that know me on this group. I have been using the Unidata databases since 1998 when introduced to it by my former CIO. Over the years and throughout my IT career, it has served me well. Decreasing software production and maintenance costs, while at the same time increasing the value of the software I (we) developed to solve complex business solutions. I have accepted an Application Development management position with a company here in the Philadelphia area. However, they are not a U2 shop. I view this opportunity as a chance to build my skills in and around the .NET platform and evaluate the use MSSQL in a true business application that I myself have built on a U2 platform in a previous time. While this doesn't exclusively rule out U2 in the future, for now, I'll be in SQL-land. Just wanted give a heads up to those that know me here. Don Verhagen Application Development Manager People 2.0 www.people20.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] POSTED ON BEHALF OF NONMEMBER: SB+ Error Message
My first guess would be, since you are printing to the HOLD file (which is a directory type) is that your disk is getting full of temporary files. The second is that there is a record already in the file and the permissions are such that you can't write over it. -- From: Kevin King precisonl...@gmail.com Sent: Friday, January 16, 2009 10:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] POSTED ON BEHALF OF NONMEMBER: SB+ Error Message We are running a weekly batch process that runs multiple streams via phantoms simultaneously. The process consists of a mixture of SB+ processes, paragraphs, report writer reports BASIC programs. No changes have been made to the particular area of the process for quite some time, all of a sudden, we have started having it crash with the following error message:- Program SH.PRINT.MANAGER: Line 846, Queuing disabled for requested printer. Once the stream is manually restarted (by rerunning the process that crashes), it continues through to the end without any problems, never crashes a second time. The same weekly batch process is run on 2 other live, several other test systems with no problems. Can anyone tell us exactly what this line is trying to do, what the problem could be? - Could it be anything to do with DMSECURITY, as the phantom logs on to a specific SB+ Account to perform its tasks ? None of the reports in the area where the crash occurs actually print - they all go to HOLD. We are running on SB+ 5.4 UV 10.2 on Solaris (all systems). No changes have been made to any printers or setups recently either. None of the programs actually call SH.PRINT.MANAGER, so it must be being called from 1 of our SB+ report writer reports. Any ideas anyone ??? MARY --- 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] Batch conversion of 32bit files to 64bit
I believe you can do this by using the uvbackup and uvrestore utilities. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Arnold Bosch Sent: Tuesday, December 23, 2008 3:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] Batch conversion of 32bit files to 64bit Hi Does anyone know of an easy way to convert a lot (+/- 100) 32 bit UV files to 64 bit ? Doing them one-at-a-time is a pain, and I'd like to convert all of our files, as we regularly run into the 32bit filesize limits. Is it possible to RESIZE.FILE on a 32 bit file to convert it to 64 bit? My System: UV 10.2.10 on W2K3 Server. Regards Arnold Bosch IT Administrator Taeuber Corssen SWA (Pty) Ltd Tel +264 (0)61 293 2106 Cell +264 (0)81 124 8625 Fax +264 (0)61 293 2104 Email: arno...@tc.com.na -- --- 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: {Blocked Content} RE: [U2] Need help with GCI system
Are you doing this as the administrator or as a common user? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Little Sent: Friday, November 07, 2008 7:54 AM To: u2-users@listserver.u2ug.org Subject: RE: {Blocked Content} RE: [U2] Need help with GCI system Hi David, Yeah - I've done make, install, make, install, make install so many times in the last few days, I think I can do it in my sleep. :) Luckily I am not on a production box. You mention the registry entry, but that gets updated when you do the install, and currently says UvGciLibraries bin\magci.dll;bin\gci.dll. I've done the environment variable thingie too, and it didn't seem to make a difference. So... I don' know. I'm waiting on a reply from the VAR but I aint holding my breath their gonna be of any help. -bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: Friday, November 07, 2008 3:14 AM To: u2-users@listserver.u2ug.org Subject: RE: {Blocked Content} RE: [U2] Need help with GCI system Hi Bob, Ah, forgot to ask the obvious, does this file exist: e:\IBM\UV\bin\magci.dll As Windows error 126 means missing file or registry entry is invalid. I see you said you ran Make a GCI Library from a GCI Definition File from the GCI Admin menu. I don't see you saying you ran Install a GCI Library from the GCI Admin menu. Quote: This option does the following: - Copies the DLL file from the gcidir directory to the bin directory in the UV account directory - Adds the name of the copied file to the GCI library list held in the Windows Registry The DLL is now ready for use. Note it also states you can use the UVGCIDLLS variable to test your DLL, before committing to updating your UV GCI configuration. Probably a wise thing to do in a production or live environment! :) Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Little Sent: Friday, 7 November 2008 1:41 PM To: u2-users@listserver.u2ug.org Subject: {Blocked Content} RE: [U2] Need help with GCI system 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. From: [EMAIL PROTECTED] on behalf of Hona, David S Sent: Thu 11/6/2008 7:53 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Need help with GCI system Isn't your module called magci and not test? As your error indicates it's looking for TEST in your GCI library. From the GCI documentation: Hi Davd, Thanks for the reply. The library is indeed called test.lib built from test.c/test.obj. In it is the function getSum() I am trying to integrate. The GCI definition file I've created on UV is called MAGCI. UniVerse creates all the magci.* items in the gcidir when I take GCI.ADMIN menu option 5. Make a GCI Library from a GCI Definition File. The way I thought it worked was: The subroutine visible to UV would be getSum and the external subroutine name is the same and the module (.lib) is test because the function is in test.lib. What's odd is that the *hello example and it's accompanying BP GCI1 calling program don't run either. I'm using straight out of the box IBM examples and using the default GCI definition file: GCI. -bob 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 Thu Nov 6 18:40:48 2008 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/20081106 (message mA72ejno008182). -- Postmaster --- 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] [UD HP-UX] I need to track user logins
The problem with last is that the file it uses for logging the users wtmp is usually cleared every month, at least on Red Hat. What I do is create a text file from the output of the last command at the end of each month and import the results into the database. That way I have the start and stop time and day for every user that has logged onto the system during the month. This had made it easy to show when a user has been at work and for how long. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Lunt, Bruce Sent: Wednesday, November 05, 2008 11:50 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD HP-UX] I need to track user logins Hi All, I need to provide a report that shows what users have not been on the system for the last 90 days. I don't know how to do this and was hoping that someone out there could help me. Thanks in advance, Bruce Lunt --- 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] Antivirus and UV
Does anyone know if we would have a problem with antivirus software, specifically Symantec EndPoint 11, running UniVerse 10.1.12 on Red Hat Linux AS3? Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV 10.2
Anybody know what it means when your program goes into a break condition and it says: Printer memory out of space Or something like that, and not doing anything with a printer. We are processing several hundred thousand records but not any print files. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: spaces in file names
That could be the answer to my question. Tony, you've got to slow down. We all enjoy your posts on this list and you would be missed, but, life is too short, smell some roses. You and I don't know each other personally but I can tell by your writing that you should probably take a vacation instead of paying for a doctor to take one. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Saturday, October 04, 2008 3:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: spaces in file names I enjoy Tonys insights, what I dont understand is how he ever finds the time to post such long responses not only in here but in cdp and on his own blog as well -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 04 October 2008 16:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: spaces in file names Nah, Tony's solid. A bit stressed out - aren't we all? - and amazingly comprehensive in his explanations, but SOLID overall. Then again, not like he needs my endorsement... On Fri, Oct 3, 2008 at 7:59 PM, JPB-U2UG [EMAIL PROTECTED] wrote: Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.7.5/1702 - Release Date: 01/10/2008 09:05 --- 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 UV data
SUSPEND ON Copy SUSPEND OFF Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Friday, October 03, 2008 3:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] Copying UV data Re: UV 10.1 on Linux Is there any tricks to picking up a data account from one system and porting it over to another? Do we have to stop UV before the move, or can it be paused like with Unidata? -Kevin http://www.PrecisOnline.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] RE: spaces in file names
Do you wake up on the wrong side of the bed every morning? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Friday, October 03, 2008 3:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: spaces in file names For reference, Windows still stores path/file names internally in short 8.3 format. Support for long names and additional characters was added in Windows 95 as an abstraction (a view) over that for common usage where non-technical people want to use file names like: J. Jones Budget, 2007-2008 (revised).doc Chelsea smashed! at homecoming '07.jpg Windows was designed to be an operating system for home users and later became a server. (Most people forget that PC stands for Personal Computer.) Macintosh supported long, friendly filenames back in 1984 for the same reasons. Unix is a system for engineers, not intended to be used by people creating OS-level filenames for their docs or pictures. Now, just to be clear, I didn't suggest that DBMS files should be allowed to have spaces in them, like CUSTOMER MASTER. I was giving IBM a little grief for not making use of a file system enhancement which was added to Windows 13 years ago so that we can put IBM programs under Program Files. There's no need for *nix compatibility at this level, commands like uv, udt, UniAdmin, and the UniSDK tools are all platform-specific, OS-level programs, and have nothing to do with the data in the DBMS. It's almost understandable that paths to data may give the DBMS grief if they contain spaces, like: D:\Data Sources\ABC Company\UV\Accounts\WAREHOUSE But even in this case, if ported to *nix anyone would know to move that to something more appropriate like: /home/data/abc_company/uv/acccounts/WAREHOUSE In either case, the DBMS-level file system should abstract the MV DBA from OS-level issues. For example, we should be allowed to create files like the following without OS-related issues: .TEMP OPEN-A/R CUSTMAST*DEPT That said, the CREATE.FILE verb should also prevent the creation of filenames that are commonly agreed as being a bad idea, like CUSTOMER MASTER. As always (like case sensitivity) this whole situation is just another case of engineers who decide not to make changes because they speak Unix and they expect the rest of the world to do so as well. The burden is not on them to make software work for the target OS but on developers to have to know how another OS works so that they understand why their own platform isn't working. That's just lazy and backwards thinking. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-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/
FW: [U2] Copying UV data
Sorry it should be SUSPEND.FILES ON and SUSPEND.FILES OFF Jerry Banker -Original Message- From: jpb-u2ug [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2008 4:23 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] Copying UV data SUSPEND ON Copy SUSPEND OFF Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Friday, October 03, 2008 3:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] Copying UV data Re: UV 10.1 on Linux Is there any tricks to picking up a data account from one system and porting it over to another? Do we have to stop UV before the move, or can it be paused like with Unidata? -Kevin http://www.PrecisOnline.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] RE: spaces in file names
Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. -- From: Allen Egerton [EMAIL PROTECTED] Sent: Friday, October 03, 2008 5:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: spaces in file names jpb-u2ug wrote: Do you wake up on the wrong side of the bed every morning? snip Um, I'm not sure why you found what Tony wrote offensive. I thought it was a reasonable presentation of his point of view. -- Allen Egerton [EMAIL PROTECTED] 860-912-8067 --- 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] Updating UV/UD PE
This may be true but it really isn't a smart move even in windows, almost everything in programming is delimited by spaces. Personally I think it was one of the dumbest things implemented by MS. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Thursday, October 02, 2008 5:04 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Updating UV/UD PE CREATE.FILE FILE WITH SPACES IN'T 30 Creating file FILE WITH SPACES IN'T as Type 30. Creating file D_FILE WITH SPACES IN'T as Type 3, Modulo 1, Separation 2. Added @ID, the default record for RetrieVe, to D_FILE WITH SPACES IN'T. -Original Message- I'm not quite sure what you're getting at here, but never mind ... Don't forget UV comes from a heritage where space was an illegal character in file names. (And it still is, for quite a lot of other programs that run under Windows, too. Spaces cause me grief, even in Windows itself!) ** 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] [UD] Crystal Reports and UniData
David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- 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] Crystal Reports and UniData
Hu, IBM doesn't have market power? Maybe someone should tell them. On the Fortune 500 IBM is 15 and Microsoft is 44. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Friday, September 19, 2008 9:14 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UD] Crystal Reports and UniData There is, unfortunately, a question of market power here. If Access and SQL-Server talk to each other, even if they use a *broken* version of SQL to do so, the market place will expect other databases and clients to talk the same - BROKEN - dialect of SQL. It's all very well a vendor (like IBM, for example) saying we comply with the standard, but if the official and the de-facto standards don't agree, then the smaller vendors (and here I include U2) are likely to get trampled. Like it or not, IBM should treat any problems with a market-influential tool like CR as high priority, even if it is CR that's at fault. In an ideal world, if IBM said CR is broken, and here's how, it would result in CR getting fixed. In the world we live in, CR can probably get away with saying tough, on yer bike, mate. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: 19 September 2008 14:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Crystal Reports and UniData David, I think you have the emphasis on the wrong party here. IBM U2 is the database not the reporting tool. I don't think it is IBM's responsibility to try and comply with a tool, any tool, it is the other way around. Since CR is suppose to talk to a database and get the information from a database it is their responsibility to try and comply with it. If they don't want to, then they are not the tool you want to use. Find one that will. It is IBM U2's responsibility to comply with the operating systems that are available and to provide standardized access to the database. Do you think Microsoft tries to make SQL Server compliant with CR? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Thursday, September 18, 2008 11:37 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Crystal Reports and UniData Yup - I received your email -- And I'm glad this is moving up the chain. The bigger question to the User Group -- Are there 3rd party products that we as vendors and users **need** IBM to ensure work at some base level? Are there 'natural use' products that IBM really does need to test and assure a base-level of compliance with?? Today, IBM certifies that UniData works on Windows, and several versions of Unix and Linux -- and that if U2 does not work with those products, it would be a 'tier one' issue to resolve. In a very short period of time, it appears any new client we get will be expecting that same 'Tier one' support for Crystal Reports, and we don't have a mechanism to ensure that support. Are there products like these that are 'add ons', but essentially 'core' or 'natural use' extensions that need to be tested in the same way the O/Ss are tested?? David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Peters Sent: Thursday, September 18, 2008 5:39 PM To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED] Subject: Re: [U2] [UD] Crystal Reports and UniData I wanted to send a note on this much earlier, but have been tied up until now. We can't certify that other solutions, such as C.R., will work with our products, but we really do want them to work. It sort of makes sense that we would, because if our customers can't succeed with their solutions, neither will we. --- 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] U2UG Board
I want to thank you for the offer to join the Board of Directors of U2UG. It was an honor to be chosen. Unfortunately, with a recent shortage of programmers and increased work load here at work, I will have to respectfully decline the offer at this time. I would not have the time to give the job the attention it deserves. Sincerely, Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Tab characters in output
If the command is like the one in UV then it actually comes from the operating system (who), at least in the Unix world. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, September 12, 2008 8:43 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Tab characters in output Is it just me or does anyone else think this is confounding - the output of the list users command in UniData contains tab characters, which is just another obstacle the engineers give us to program around! 011: Licensed(UDT+CP)/Effective ^009Udt^009Sql^009iPhtm^009Pooled^009^009Total^25 3( 61 + 0 ) / 61 ^0099^0090^0090^0090^009^0099 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] Universe trigger errors - log daemon issue
Could you send what you did to set up the trigger, maybe then we could come up with an answer? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jayones0317 Sent: Tuesday, September 09, 2008 8:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe trigger errors - log daemon issue Hi guys... I have been setting up some test file triggers on our system.. Very simple test and getting the following error.. If you guys could point me in correct direction to resolve error message below, it would be greatly appreciated... thx, Jay Jones Careplus Inc Tampa, FL Universe version- 10.1.8 SB+ version - 3.04 Unix version- HP-UX 11.11 Error messages when attempting to file a change to the file with trigger.. Program ED: pc = 7408, FATAL: Timeout waiting for log daemon to accept new ent ries. Program ED: pc = 7408, Error performing trigger for PHP_PHP.F000. Failed to file 457310 in file PHP_PHP.FTP.LOG. STATUS = 909025 -- View this message in context: http://www.nabble.com/Universe-trigger-errors---log-daemon-issue-tp19391955p 19391955.html 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] UNIVERSE on Red Hat?
Actually when I moved the data over from the Solaris system I used uvbackup to a file. Copied the file to the Linux server through an NFS mount and used uvrestore to restore the accounts. So I didn't have to do an fnuxi on the data files. I did have to compile all of the programs and I-descriptors in the dictionaries. Any operating system command that was used in our procs or programs had to be checked to see if they needed changing. Most of these had only an option that was available but not being used on the Solaris system but was needed on Linux so I made the changes before the move. I had a little bit of practice doing the move during a month of testing our apps on the new system so I had the procedure down pat. The UV was loaded on the Linux system and I set up all of the printers ahead of time and named them the same as the printers on the Solaris system so I didn't have much to do with that when we moved the data. All of our spooler scripts had no problem. The mail program had some slightly different options as did the 'cp' and 'rm' commands. The uv account was in a different location but updating the account after it was moved took care of that. I started to move our data accounts on a Friday night, just to be safe, I was able to move all of our database over in one night and it was ready the next morning. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Friday, September 05, 2008 10:02 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UNIVERSE on Red Hat? We switched from Solaris to Redhat about 3-4 years ago. Some unix commands were a little different that we had in scripts and some programs, those had to be changed. It is on a Dell box and it was like comparing a Jet to a prop plane in terms of performance. I remember it being an easy switch over. Hardest part was porting the data over, for us we had to funxi the data. I can't think of anything negative about the switch at all. It has been a very stable environment, we have 117 user license, and most of those get used. We use uniobjects for several applications. Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO -Original Message- From: Doug Chanco [mailto:[EMAIL PROTECTED] Sent: Friday, September 05, 2008 8:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] UNIVERSE on Red Hat? Hey all, Does anyone have any experience running universe on red hat in an enterprise environment? I have run UV PE on centos and red hat just fine BUT I am talking about 400+ users, uniobjects, tons of printers, etc .. I would LOVE to hear about enterprise experiences running universe on a red hat system in particular; 1. any gotchas? 2. any praises? 3. any performance issues? 4. any universe/OS issues? 5. any printing issues? 6. any issues with terminals or termdefs/termcaps? 7. uniobject problems? 8. anything else anyone may have run across that I did not mention This is really a question for fitzgerlad/long but what about running FAST on linux? (a wonderful chance for a plug here) :-) Any and ALL experiences/thoughts/whatever are welcomed! IF we move it would be from aix 5.2/universe 10.1 to red hat enterprise server/universe 10.2 on a beefed up dell server Our current setup is about @400 users @40 printers @250 uniobjects connections (from a windows app) Connections from datastage throughout the day @3000 pick databases The biggest being @ 5 gig in size Also while this is not really pick related does anyone have any experience with flash copy on linux/red hat? It allows us to unmount file systems and 'flash copy the data to another area and the remount the file system and then make a backup from the flash copy area. Thanks! Dougc --- 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] port.status
My mistake, thanks Ken. It's just that when you don't do it too often the names get jumbled together. Beside the fact that '+s' sounds like it should be sticky. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Wednesday, September 03, 2008 10:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] port.status OK, I ignored it the first time, but if this is going to keep rolling then I need to jump in with a correction before people assume it must be correct. This is not the 'sticky' bit. The purpose of the sticky bit on some (older) unix implementations is to keep the text segment of an executable loaded in memory once it has been executed rather than unloading it at completion. This was designed to make commonly used programs load faster, but is now pretty much irrelevant in that context and is ignored by some unix implementations such as Linux. The sticky bit is most often used now on directories such as /tmp where it requires the actual owner of a file to delete or modify that file, even though other users might have write permission on the directory. The sticky bit gets set with chmod +t. If you want a program to run with the credentials of another user (such as root) when it is executed, then you set the 'setuid' bit with chmod +s and make sure the file is owned by the appropriate user and executable by relevant people. I won't get into arguments about how good an idea it is to set the setuid bit on random bits of the operating system. Cheers, Ken -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of JPB-U2UG Sent: Thursday, 4 September 2008 11:24 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] port.status Yes, but it should have already been set. If you want it to work with everyone then set the sticky bit in the /usr/bin/ipcs. -- From: Lloyd Cottrell [EMAIL PROTECTED] Sent: Wednesday, September 03, 2008 12:19 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] port.status i've found that you need to flip on the sticky bit on the list_readu program to fix this problem, which makes it run as root On Tue, Sep 2, 2008 at 2:49 PM, [EMAIL PROTECTED] wrote: New install of Universe 10.2.4 PORT.STATUS There are no uniVerse sessions that match the specified conditions. But one user is logged on as root and then starting /usr/ibm/uv/bin/uv. And is running a multple program jobstream, so something Universe should have been detected. And we get the same results if a user logins with a unique login, is then pointed to the /bin/ksh and starting uv. Thanks. Roger --- 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/