Re: [U2] is this an INDEX ISSUE
Could you post the LIST.INDEX results for this? If only one field is affected, there might be something specific about that. Regards Brian On 15 April 2013 at 03:20 david yu d...@yahoo.com wrote: hello Tom, I wish I could just ignore it but as I previously mentioned, our patient are not getting their transportation appt which is not good service. I asked assistance to our software vendor and supposedly they open a case with Rocket but still no reply, I am hoping someone from this forum have a solution. like you mentioned, it works in all the files that we have index except for 1 and giving me a big headache since without index the report take more than 2 hours and by the time the report output is done it is not a valid report. -- Message: 1 Date: Sun, 14 Apr 2013 08:41:38 -0400 From: Tom Whitmore tewhitm...@ratex.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] is this an INDEX ISSUE? Message-ID: BA2E471C9317804EB8470750F458BD9801EC779E3DC4@public Content-Type: text/plain; charset=us-ascii Hi David, To your real problem and question. We are on UniVerse, using Linux and we have had problems like what was initially reported. I have not had time to play and figure out what is going on. We have moved from 10.x to 11.1.11 and I have not tried recently. Also, it seems to work fine on some files but other files have problems and we aren't doing anything special with the indexes that have problems (they are simple D or A type dictionaries) Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Jenkins Sent: Saturday, April 13, 2013 3:30 AM To: david yu; U2 Users List Cc: u2-users@listserver.u2ug.org Subject: Re: [U2] is this an INDEX ISSUE? Was the file open to a UniVerse session! Or we're you EXECUTING the RESIZE from a process that had the file open? The latter can cause issues -close the file first. If it's AIX and you are running multiple UniVerse shells from crown tab as foreground tasks (I.e. not as phantoms or by using executive) at the same time it could be relevant too. Regards JayJay On 13 Apr 2013, at 00:46, david yu d...@yahoo.com wrote: hello, We have a file that is updated almost every minute for transportation appointment, we index a field in a file to make the reporting much faster but recently we noticed when we ran the report not all the transportation appt shows up on the report, so customer doesnt get their transportation. We have been rebuilding the index every night but problem still exists. Anyone encounter this issue? we are on HP-UX b.11.23. thanks in advance. ___ 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] U2 Test Tools for system/unit regression testing w/integration with HP QualityCenter
David I'll keep you posted. It will be licenced per server - that's the easiest option. Best Regards Brian On 06 February 2013 at 08:39 Hona, David david.h...@cba.com.au wrote: Thanks Brian - that sounds great! I would be keen to get a trial version, once you have a SSH capable version. How is the product licensed? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, 5 February 2013 10:14 PM To: 'U2 Users List' Subject: Re: [U2] U2 Test Tools for system/unit regression testing w/integration with HP QualityCenter Hi David I've recently released a testing product called (predictably!) mvTest. This supports automated testing of U2 applications using a dedicated scripting language modelled after UniBasic for familiarity but with a number of key extensions to handle data validation, test data handling, UI scripting and assertions. You can use this to create unit tests, UI tests (currently TELNET and U2-compatible secure TELNET/SSL but with SSH to follow shortly), regression and volume tests. Here's a quick overview of how it works - - You create unit or UI tests using the scripting language. These can be run through either of a Windows client or through a server-side script runner e.g. if you want to perform CI testing through a phantom. There's a nice Windows based editor to create, organize and test these. - The tests return pass or fail information based on assertions, so you can see at a glance if anything has broken. You can save the information and run various reports against it. - The tests can run direct against the database through a UO.NET connection (e.g. for testing subroutine calls and parameters) or through a terminal-style UI. It embeds a complete terminal emulator with all the necessary functions, and this allows you to drive screens, perform spot checks, branch on different results (e.g. handling error messages raised from your screens), handle send/expect style scripting and more complex conditions (such as wait until the cursor is at this location and this message has appeared here). - It keeps a separate shared server connection open while the UI tests run so you can, for example, script an entry screen via the terminal UI that ends up saving some data like a sales order, and then immediately check what has been written to the database through the underlying connection as part of the same script. - Unit tests can be organized into batches in which the tests run in order, so you can set up sequences that match business operations. - Batches can be organized into runs, so you can test whole suites of your application. Each run can be customized, so you can feed in per-site or per-system information. Runs can optionally randomize the order in which batches are executed, and you can set up different run scenarios and iteration patterns. - You can feed in and randomize test data and from the client side runner, access local features as well as the database operations. - Volume testing can take place using the Windows client. This is a multithreaded client supporting multiple concurrent UI sessions - I've tested up to 250 concurrent connections from a single PC running against an SB+ system for one customer last year who needed to stress test their SB+ system performance coming up to the New Year sales. This first release is targeting U2 with other MVDBMS to follow. I'm also adding support for GUI testing using the Microsoft Automation APIs and WebUI testing going forward. Anyone interested can contact me for an evaluation version, or download the user guide from www.brianleach.co.uk. Regards Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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
Re: [U2] u2ug website down
Jeff Kicked, thanks! (Why do these things NEVER happen when I'm IN the office...) Brian On 03 November 2009 at 21:22 Jeff Butera jbut...@hampshire.edu wrote: Can anyone kick the tires on the u2ug website: mvScript Error The following error has been reported 1006þNo active connections available at this time 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
Re: [U2] [UV] List of hashed file types
Hi Jeff Not to hand, but here's the help from HASH.HELP and CREATE.FILE: CREATE.FILE: The valid types are: *TYPE* *USAGE* 1 Sub-UFD type file, for large records or source code. 2 Hashed. Keys end with numbers. 3 Hashed. Keys end mainly with numbers. 4 Hashed. Keys end with letters. 5 Hashed. Keys end with full range of ASCII characters. 6 Hashed. Keys begin with numbers. 7 Hashed. Keys begin mainly with numbers. 8 Hashed. Keys begin with letters. 9 Hashed. Keys begin with full range of ASCII characters. 10 Hashed. Keys are numbers. 11 Hashed. Keys are mainly numbers. 12 Hashed. Keys are letters. 13 Hashed. Keys are full range of ASCII characters. 14 Hashed. Entire keys are numbers. 15 Hashed. Entire keys are mainly numbers. 16 Hashed. Entire keys are letters. 17 Hashed. Entire keys are full range of ASCII characters. 18 Hashed. Entire keys are of arbitrary form. 19 Sub-UFD type file, for large records or source code. 25 B-tree. Best for large file with small static records. 30 Dynamic linear hashed. Modulo with change to fit file size. HASH.HELP: 0 keys were wholly numeric (digits 0 thru 9) (Use File Type 2, 6, 10 or 14 for wholly numeric keys) 9 keys were numeric with separators (as reproduced below) 0123456789#$%*+-./:;_ (Use File Type 3, 7, 11 or 15 for numeric keys with separators) 819 keys were from the 64-character ASCII set reproduced below !#$%'()*+,-./0123456789:;=?...@abcdefghijklmnopqrstuvwxyz[\]^_` (Use File Type 4, 8, 12 or 16 for 64-character ASCII keys) 98 keys were from the 256-character ASCII set (Use File Type 5, 9, 13 or 17 for 256-character ASCII keys) Of course, always remember to account for the key structure as well as composition i.e. what part varies the most.. otherwise you can really stuff up a file! Brian On 20 October 2009 at 16:42 Jeff Schasny jscha...@gmail.com wrote: Somehow, I have lost my list of Universe Hashed File Types and their recommended associated ID structures and I cant seem to find it in the Universe System Admin or System Description .pdf's Can someone point me to where its hiding in the documentation? -- 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] .Net Data Provider
Hi Mike I raised this with the U2 team when the announcement was first made, and with (then) IBM in a U2UG board meeting. At that time they weren't able to comment and even the engineers didn't know what would happen to it. I have been promised a response when the dust settles, so I'll post then if nobody gets to hear first. It is the only part of the product that I can think of that is not separated out from other IBM stuff. I hope it won't be frozen or made unavailable because it was shaping into a nice product. Brian On 01 October 2009 at 19:19 Mike Randall mike.rand...@comcast.net wrote: Anyone have any idea what happens to the .Net Data Provider for U2 in the Rocket Universe? The product was labeled as a DB2 data provider on the IBM site with U2 being part of the functionality. No mention of it anywhere on the Rocket site. Thanks, Mike Randall ___ 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] Indexing
Hey Ross Excellent article! Brian On 15 September 2009 at 17:55 Ross Morrissey u...@rossmorrissey.com wrote: It's not IBM technical documentation, but several years ago I published a number of push the envelope techniques for UniVerse Secondary Indexes in an article for the OSDA Newsletter. The prose is dated, but the techniques aren't. It's at: http://www.rossmorrissey.com/uv/rossmorrissey_indexes.pdf On Wed, Sep 9, 2009 at 2:24 PM, Bessel, Karen karen.bes...@tylertech.comwrote: I am not a UV newbie by any means, but I've never used indexing, and I need to know where to start, with reading to gain some knowledge on the documentation. Any particular area of the IBM technical documentation that might be particularly helpful to this noob to the wide world of indexing? Thanks! Karen Bessel Software Developer Tyler Technologies, Inc. 6500 International Parkway, Suite 2000 Plano, TX 75093 Phone: 972.713.3770 ext:6227 Fax: 972.713.3780 Email: karen.bes...@tylertech.com Web: http://www.tylertech.com Tyler is proud to be the Platinum Sponsor of The Court Technology Conference 2009 Sept. 22-24, 2009 | Denver, CO ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] .NET Developer
'plain please then what I did wrong here then: Basic error: you forgot to translate from client-speak. When a client says 'yes' they mean 'mostly'. When a client says 'no' they mean 'not usually/yet'. When a client says 'always' they mean 'sometimes'. When a client says 'never' they mean 'until..' Like We never have option margins in currencies other that the option currency means we forgot about this one guy who we always margin in USD regardless and he's our biggest client and We never manufacture taller than 4 metres because our build bays won't take it means except for that lot we sent off to Australia as kits and We never charge below cost means until we really want that leader.. Simple :) Brian 'always ready for remote working'.. On 11 September 2009 at 16:03 aelw...@socal.rr.com wrote: Me Did you test it? Them Yes we tested it, please install Four weeks later: Them Hey the commissions aren't comming out for RMA returns Me I thought you said you didn't want RMA returns customized because you didn't do those? Them We did them manually. We just started doing them 2 weeks ago This continued for 6 more applications they SPECIFICALLY asked to NOT CUSTOMIZE because they didn't want to spend the money. Then I had to create a commissions routine that would go backwards through time to re-do the commissions and come up with a delta. ___ 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
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] PICK Programmer Opportunity
Posted for a member: Looking for a career opportunity? Coburn Supply Company offers a competitive compensation package including wages based on experience, medical, dental, vision and life insurance programs, 401k, paid vacation and sick pay. Coburn Supply Company offers opportunities to advance based on performance and the training needed to succeed in those opportunities. We proudly maintain a drug-free workplace. For more information about Coburn Supply Company: http://www.coburns.com/locations.asp PICK Programmer The PICK Programmer is responsible for designing and testing program logic, coding programs, program documentation and preparation of programs for computer operations. Works within specifications provided to meet programming assignment goals and objectives in a timely and accurate manner. - Focus Areas for this job include: * Write Programs: Use coding methods for Multi-value PICK to enhance or initiate efficient program execution and performance and to reach optimum hardware utilization. *Test Audit Programs: Test, debug, and document new programs/technologies and changes to existing programs/ technologies that (1) improve operating efficiency and effectiveness of company operations and (2) provide timely and accurate reporting. * Train End-User: Train End-Users to ensure effective implementation of programs and hardware/software as reflected in reduced trouble calls and positive feedback from operations. * Knowledge Development: Knowledge is developed and maintained in order to ensure efficient operations of all Information Systems, as measured through decreased downtime of systems, and increased employee and customer satisfaction. - Full-Time permanent position - Two years experience as a computer programmer in Multi-Value PICK environment preferred. - Good general knowledge of data processing system design methods, techniques and standards. - Associates Degree in computer science or information systems or equivalent experience required. - While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools or controls; reach with hands and arms; stoop, kneel, or crouch; talk or hear. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, and the ability to adjust focus. While performing the duties of this job, the employee is not exposed to weather conditions. The noise level in the work environment is usually moderate. - Must pass company required drug screen, physical and background screening. - Some travel by car and plane may be required. Print application: http://www.coburns.com/EmpAppForms.pdf Mail resume and application to: Attn: Human Resources P.O. Box 2177 Beaumont, TX 77704-2177 Fax resume application to: Fax#: 409-833-0659 August 2009 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Booking U2U
Just a note for anyone planning on attending the U2U in the UK (U3K?): I just booked the hotel, but to get the special attendee rate you need to phone direct. The discount code wasn't recognized by their website. Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD equivalent of UV FILE.USAGE?
Adrian It tells UniVerse to start to collate usage stats for a selected file. Once enabled, Universe writes stats to the file header on the number of reads/writes/selects/overflow reads etc. Normally this is switched off since turning it on impacts performance, but it is a useful tool in determining which files are most critical to performance. Brian On 04 September 2009 at 01:16 Adrian Merrall pigeonra...@gmail.com wrote: On Thu, Sep 3, 2009 at 3:59 PM, Dan Fitzgerald dangf...@hotmail.com wrote: Anyone know if there is a Unidata equivalent to the UniVerse FILE.USAGE set of commands? Dan, If you could roughly describe what they do on UV, we UD only types might be able to help. Cheers, Adrian ___ 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] UniObjects Error 39207
Hi Jake 1. It is using named common or anything that would be normally set up on LOGIN? 2. Is there any message in your errlog file? (if you don't have an errlog, you can create it as a zero length file in the uv directory and uniVerse will start to populate it with errors). 3. Is is doing any printing? The error normally means that the back end application has died (cannot read from slave). You can get that e.g. if accessing a resource you don't have permission on, if trying to print with no printer defined, trying to access a file variable that is not opened ... Brian On 31 August 2009 at 20:15 Holt, Jake jh...@samsill.com wrote: It is compiled and cataloged. It runs fine when called from a UniVerse program. I deleted the object code, recompiled and de/cataloged the application just to make sure though. Still gives me this error. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Monday, August 31, 2009 12:07 PM To: 'U2 Users List' Subject: Re: [U2] UniObjects Error 39207 You might check your program. We get this error when the program is not cataloged or the object is not available. Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Monday, August 31, 2009 10:13 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects Error 39207 I am hoping that one of you more experienced UniObjects users can help me with this error I cannot seem to correct: We're running UniVerse 10.0.18. [IBM U2][UODOTNET - UNICLIENT][ErrorCode=39207] Error [39207] occurred on server. Possible server-side licensing failure. I have other applications that use Uniobjects and this application has dozens of other subroutines in it that work fine before and after this one. I have other subroutines that access the same data. I can move this up so it's the first sub called and it still gives me this error. The UniSession is active when it's called. There is only one arg and it's for returning the list (so it's not something with an arg being set wrong) The subroutine works perfectly if I run it in universe. I rewrote the subroutine on the server under a different name (desperation?). It's not a licensing issue (other subs work fine). Is there anything else that can cause this error? In addition, is there a way to get Uniobjects to not ignore my calls to close the session in my catch block? This error always leaves an opening connection. Jake Holt ___ 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