RE: [U2] Questions about addRequestParameter
Theres a good example of this on www.pickwiki.com We use a similiar system for address verification and debit/credit card payments. Performance is more than adequate. From: [EMAIL PROTECTED] on behalf of Bruce Lunt Sent: Mon 16/05/2005 23:19 To: u2-users@listserver.u2ug.org Subject: [U2] Questions about addRequestParameter Hi All Esteemed Ones, I have been investigating using callhttp to send addresses to the web for address verification and the documentation is leaving me a little unfulfilled. If I am understanding things correctly, I first do: createRequest(URL, http_method, request_handle) Then, I would add the address fields one by one to this by issuing: addRequestParameter(request_handle, parameter_name, parameter_value, content_handling) for as many fields as I have to validate. Finally, I would do: submitRequest(request_handle, time_out, post_data, response_headers, response_data, http_status). The response_headers and response_data vars would have my reply. In this case it is XML. I am assuming that the request_handle is used by all three processes but I cannot see what is being done with it. I don't know whether it is correct or not. And finally, can anyone tell me if this is even worth pursuing? Is it fast enough to use with data-entry? Or should I be looking into another method? Thanks, R. Bruce Lunt HP/UX v. 11 Unidata v. 6.0 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Access Violation
We tend to get that error when there is a corrupted file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Moore Sent: 16 May 2005 11:40 To: u2-users@listserver.u2ug.org Subject: [U2] Access Violation DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. Hi, We have an application running on a Windows machine that telnets to a Universe server (running on Windows), calls a Universe program that changes a flag value in one of our files and then logs off. It does this about 900 times in one night, once a month. This worked fine until recently where the Universe program appears to fall over and cause the whole thing to stop. The only error we are getting is in the Windows event manager and is as follows: Unhandled Exception raised at address 0x00405455 : Access violation. Attempted to read from address 0x009BF000. Binary data is processor CONTEXT structure Unfortunately support say this is a general error and could be caused by many problems. Anyone here seen this before or have any ideas on how we could fix this? Thanks Andy Moore Selima Software Ltd Tel: 0114 2815000 Fax: 0114 281 email: [EMAIL PROTECTED] Support: http://tracker.selima.co.uk http://tracker.selima.co.uk/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Access Violation
That would seem point to some sort of group error in the file that is being updated. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Moore Sent: 16 May 2005 14:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Access Violation DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. I could try this, but the process doesn't seem to fail until about an hour or two in to the run, so that's a lot of commands. The first however many flag changes in the first couple of hours are fine, after that it fails. Thanks Andy Moore Selima Software Ltd. -Original Message- From: Chuck Mongiovi [mailto:[EMAIL PROTECTED] Sent: 16 May 2005 14:04 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Access Violation We have an application running on a Windows machine that telnets to a Universe server (running on Windows), calls a Universe program that If you run the process from a console window, sometimes you can get more messages about why it's failing .. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Access Violation
I use fixtool rather than uvfixfile on Windows as that seems to find more errors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Moore Sent: 16 May 2005 14:36 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Access Violation DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. I ran UVFIXFILE on the files used, but it didn't state that any had an error. Is there anything else I should try with this to check for it being corrupt? Thanks Andy Moore Selima Software Ltd. -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: 16 May 2005 13:13 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Access Violation We tend to get that error when there is a corrupted file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Moore Sent: 16 May 2005 11:40 To: u2-users@listserver.u2ug.org Subject: [U2] Access Violation DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. Hi, We have an application running on a Windows machine that telnets to a Universe server (running on Windows), calls a Universe program that changes a flag value in one of our files and then logs off. It does this about 900 times in one night, once a month. This worked fine until recently where the Universe program appears to fall over and cause the whole thing to stop. The only error we are getting is in the Windows event manager and is as follows: Unhandled Exception raised at address 0x00405455 : Access violation. Attempted to read from address 0x009BF000. Binary data is processor CONTEXT structure Unfortunately support say this is a general error and could be caused by many problems. Anyone here seen this before or have any ideas on how we could fix this? Thanks Andy Moore Selima Software Ltd Tel: 0114 2815000 Fax: 0114 281 email: [EMAIL PROTECTED] Support: http://tracker.selima.co.uk http://tracker.selima.co.uk/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV][SB+] foreign character-set support
Ross, How are you storing the Chinese characters if you're not using NLS? We use NLS and wIntegrate with Chinese characters and found the reverse problem that without NLS we couldn't get the characters in and out of Universe without lots of custom encoding and decoding. Adrian Matthews IG Index -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: 28 April 2005 09:48 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV][SB+] foreign character-set support Mike, what are you looking to do here ? Are you looking at storing data with these extended character sets ? and/or simply displaying screens/reports with tags appropriate for the language/country (eg: a Brit would probably prefer to see an English screen, rather than French or German) I can't speak for SB+ (never used it), though I thought it did have some language translation features - at the DBMS level you MIGHT need NLS as well (though we actually found it got in the way when dealing with multi-byte (Chinese) character sets) The problem you point out with the mailer underscores the nee to ensure you have the right codepages loaded on the client, but I assume that will b the case 4U Ross Ferris Stamina Software Visage - an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Mike Farrant Sent: Wednesday, 27 April 2005 11:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV][SB+] foreign character-set support Clearly the engine for this mail-list is re-interpreting the characters I am trying to send. This kind of epitomizes the problem I am having! Mike Farrant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Farrant Sent: 27 April 2005 13:13 To: u2-users@listserver.u2ug.org Subject: [U2] [UV][SB+] foreign character-set support Has anyone any experience in setting up users in places where the language involves the use of extend characters such as i m a } x h h 9 l? I am currently using: Hostaccess terminal emulator or SB Client v4.5 HP-UX B.11.11 Universe 9.6.1.6 SB+ 3.4.0/7 Unix, Universe and SB+ is shared with other sites across Europe so we need some way of having a localized login/configuration for our people in the countries that use these extended character sets. If anyone can offer any help I'd greatly appreciate it. Thanks, Mike Farrant --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC text field
If you're using ODBC won't the multivalue be normalised into a separate table? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 27 April 2005 10:24 To: u2-users@listserver.u2ug.org Subject: [U2] ODBC text field I am having trouble importing a multivalued field into SQL via odbc. I would like to remove all control characters (including value marks) from the string. I have tried using an I-Type with OCONV but this failed. I would be grateful if anyone could share how they have done this. Thanks Graham --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Logon Banner
As far as I know it's stored in the registry on WIN2K. Doesn't help with the linefeed though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: 14 April 2005 23:21 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Logon Banner Update: Still no joy. I've tried everything that has been suggested and the only one that works is the padding of the message on a single line with lots of white space to simulate starting on the next line. I imagine there is a line length limit in doing this and this won't work for a mixed environment where some users are 80 characters wide and others are 132 wide. Each change attempted, I stopped telnet service, saved the change, then restarted telnet. I then started a new telnet session through Dynamic Connect and see the modifications, just not the desired results. The \ commands are just displayed as normal characters and modifying msg.text did not have any effect. I guess I'm going to make a call to IBM. Thanks everyone for your suggestions and ideas. I'll post what I end up with by going directly to IBM on this. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Chuck Mongiovi Sent: Thursday, April 14, 2005 2:23 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Logon Banner I'm on UV 9.6/NT .. I found a file in the UV root directory called msg.txt with a message at the bottom numbered TLS001 .. Try using notepad to change the text there to: Welcome to my system.\r\n\r\nBe sure to read your email.\r\n -Chuck -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ed Clark Sent: Thursday, April 14, 2005 4:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Logon Banner looks like it's printing a line feed, but not a carriage return. Try putting in a \r -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Woodward Sent: Thursday, April 14, 2005 12:17 PM To: U2-Users List Subject: [U2] Logon Banner I hope this is a simple question. When going into Uniadmin, in the Network Services/Telnet window, the Logon banner at the bottom. I'm wanting to put in multiple lines. When I do, and I log into the server, I'm getting what looks like a line-feed only, and not the associated carriage return. What I want is something like: Welcome to my system. Be sure to read your email. What I'm getting, instead, is: Welcome to my system. Be sure to read your mail. (I hope the font show up correctly.) I've tried things like /n, ^L, double returns, but so far nothing is any better. The help screen is totally useless and I've not been able to come up with any kind of Google search that gets me any further. TIA Bob W --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Select returning mv'd list
Try QSELECT file key SAVING fieldno -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 13 April 2005 13:46 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Select returning mv'd list Tried that. No dice. What I got was the key to the record and extraneous multivalue information (pointers). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Lakeland Sent: Tuesday, April 12, 2005 11:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Select returning mv'd list Try exploding the attribute SELECT FILE.A 'Key' BY.EXP F1 SAVING F1 RE ANDY -Original Message- From: Kevin King [mailto:[EMAIL PROTECTED] Sent: 13 April 2005 01:02 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Select returning mv'd list Universe 9.6, I want to select a record from a file and return a mv'd list of information in attribute 1, each attribute as a separate list element. On Unidata, I can: SELECT FILE.A 'key' F1 ...and it'll return all the values in F1 as individual items in the active select list. On Universe, this does not work. So I tried: SELECT FILE.A 'key' SAVING UNIQUE F1 ...and I get all the items, but they come in one attribute, mv'd, not split out on each line like Unidata would. I've also tried QSELECT, but apparently the option to QSELECT a single attribute from a file is not supported here here. How do you select a record from a file and return a mv'd list from an attribute in that record? -Kevin HYPERLINK mailto:[EMAIL PROTECTED][EMAIL PROTECTED] http://www.PrecisOnline.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.6 - Release Date: 4/11/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.6 - Release Date: 4/11/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.6 - Release Date: 4/11/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] NLS - To Display Non English Character at TCL level
We're using Chinese support in wIntegrate/Universe and it works very nicely. When using NLS ensure that the correct map (if not set as default) is specified in the SET.TERM.TYPE line. Also any programs that were compiled prior to installing NLS have to be recompiled. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Robertshaw Sent: 29 March 2005 11:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] NLS - To Display Non English Character at TCL level IBM's terminal emulator wIntegrate version 6 supports Simplified Chinese and is certified as GB18030 compliant. (GB18030 is the mandatory standard for all new software sold in China.) It is also localized with Simplified Chinese menus, dialogs and messages, and a Chinese user manual. When the standard wIntegrate 6 CD from IBM is loaded into a PC running Simplified Chinese Windows, it shows the menus and product installer in Chinese. www.ibm.com/software/data/u2/wintegrate/ David Robertshaw -Original Message- From: Ang Suan Yong [mailto:[EMAIL PROTECTED] Sent: 28 March 2005 03:45 To: U2-Users New Lists Subject: [U2] NLS - To Display Non English Character at TCL level Dear All, Is anyone hv experience to display other language character on the backend tcl level. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.4 - Release Date: 27/03/2005 This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Distributed SELECTs for distributed (Type27) files
Certainly on windows running a select on a large file can take out an entire CPU for the duration. Running multiple selections using partfiles *may* be quicker from the single user perspective but would tie up more CPU's. I suppose it's down to what the system is doing at the time. For most systems using half the CPU's for a query overnight is going to hurt but would be a major problem in the middle of a busy day. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: 23 March 2005 04:30 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Distributed SELECTs for distributed (Type27) files From: Maresh, Mel Subject: RE: [U2] [UV] Distributed SELECTs for distributed (Type30) files ^^ Type27 I colleague wrote and used the following code to select from a specific distributed file, the GL.DETAIL file. He loved it, but the system administrator has forbidden him from using it because it's such a resources hog. a resource hog, huh? Hmmm. Thanks for the code example. I think I'd write it as a self-contained verb rather than writing temporary procs. The verb would have 2 modes, one for controlling the distributed select, the other mode for doing the individual selects on partfiles. In other words: [S]SELDIST GL.DETAIL WITH POST.DATE = 3/22 Program would notice GL.DETAIL was distributed and spawn the multiple phantoms: PHANTOM [S]SELDIST GL.DETAIL_[partno] WITH POST.DATE = 3/22 then collect the results when phantoms are done. (JOBS and NOTIFY commands will probably prove useful.) When SELDIST executes as a phantom, it would notice that it is dealing with a partfile, do the [s]select and save the list for its parent pid. I think I'd use the parent pid to control uniqueness. Assuming I do it at all. cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects Login Problem
Anyone upgraded/changed the password security levels on the server since your last password change? -Original Message- From: [EMAIL PROTECTED] on behalf of Don Kibbey Sent: Mon 3/21/2005 5:36 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects Login Problem For years now I have been using UniObjects (Java, vb and .Net) versions on an HP-UX server running UniVerse 10.0.6. In the past couple of weeks I have noticed that my login no longer works. I can still connect to the very same machine via telnet with the same login info. UniObjects however won't let me connect unless I use a different login. This all started after I changed my password. Does UniObjects cache login credentials somewhere on the system? I've tried restarting the system and have looked over the pam files for any changes (none found). Anyone have any thoughts or hints on this? Thanks, --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10 para Suse 9.2
Universe (PE version) works on just about every distro of Linux I've tried seemingly without problems. However I would never dream of using it commercially unless it was on a certified platform. Just imagine if it looks ok in testing and then starts having major problems under Live load. IBM would probably (quite rightly) have nothing to do with it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Hilbert Sent: 19 March 2005 22:10 To: u2-users@listserver.u2ug.org Subject: [U2] UV 10 para Suse 9.2 Good afternoon to all. My client wishes to use Suse Linux 9.2. IBM does not officially support this (perhaps will be certified during the second half of this year). Can anybody out there attest one way or another as to if there would be problems. I've seen some comments on this list of users using Suse with the UV-PE but as this would be a 20 user installation I wouldn't want to lead them down the wrong road. Thanks in advance, Marc Hilbert Tech. Manager Pick Professional Center Buenos Aires Argentina [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10 para Suse 9.2
I didn't mean use the PE version. I was stating that I've used the PE version on other distros of Linux. What I meant was it would be foolish to run a commercial version of Universe on an unsupported platform. Sorry for the obvious confusion. From: [EMAIL PROTECTED] on behalf of Clifton Oliver Sent: Sun 20/03/2005 18:10 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV 10 para Suse 9.2 Using the PE version commercially is a violation of the license, ie. against the law. IBM might choose to have quite a bit to do with it--via their Legal Department. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ Adrian Matthews wrote: Universe (PE version) works on just about every distro of Linux I've tried seemingly without problems. However I would never dream of using it commercially unless it was on a certified platform. Just imagine if it looks ok in testing and then starts having major problems under Live load. IBM would probably (quite rightly) have nothing to do with it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Hilbert Sent: 19 March 2005 22:10 To: u2-users@listserver.u2ug.org Subject: [U2] UV 10 para Suse 9.2 Good afternoon to all. My client wishes to use Suse Linux 9.2. IBM does not officially support this (perhaps will be certified during the second half of this year). Can anybody out there attest one way or another as to if there would be problems. I've seen some comments on this list of users using Suse with the UV-PE but as this would be a 20 user installation I wouldn't want to lead them down the wrong road. Thanks in advance, Marc Hilbert Tech. Manager Pick Professional Center Buenos Aires Argentina [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE:
Also don't forget that Universe is a programming language as well as a database. In these sorts of cases a lot of people cost the movement of the data itself and forget all about the cost of developing an application that can actually do something with it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wong, Howard Sent: 16 March 2005 13:52 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] RE: Trevor, Indeed your suggestion reflects the views of many who have replied to my post. It is the least painful and most-certain way for us to make the data available for a few more years when the app will eventually be retired. Since we don't have any knowledge on UV, invariably we'd have to pay for outside help if we choose to extract the data instead of installing a new version of UV. Therefore I suspect the costs for both cases may come out to be pretty close. In any case, it will be the manager's call. Thanks for your thoughts. Regards, Howard Wong Asset Management 416-784-8728 [EMAIL PROTECTED] -Original Message- From: Trevor Ockenden [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 16, 2005 5:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Dear Howard VMark was the company that developed the UniVerse Data Base product for which I have had much to do with for many years. VMark acquired Unidata and renamed itself to Ardent Software. Ardent was purchased by Informix and Informix was purchased by IBM. IBM now sell and support UniVerse. Now on another point. You say your boss may not want to spend good money keeping old data alive. Well it seems to me that if this old data is still useful and necessary then it must surely be considered current and active data. The fact that it resided in an old application is besides the point. I suggest purchasing the minimum UniVerse licences possible as this data probably only needs one or two uses accessing it at any point in time and this would keep the cost to a minimum. Hope this suggestion is useful. Cheers Trevor Ockenden Open Systems Professionals Sydney Australia m: 0414 731 634 e: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wong, Howard Sent: Wednesday, 16 March 2005 1:46 AM To: 'u2-users@listserver.u2ug.org' Subject: To all, I posted to the Chatter forum but was advise that the mail list would have wider audience for my question. My original post. In a nutshell, we know nothing about UniVerse, but need to keep the data and move them to a newer server, Unix or otherwise. Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- 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 Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005 __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message.
RE: [U2]: Epicor
Shouldn't this be on community by now? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: 17 March 2005 05:15 To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor We have seen a couple of cases where the CFO has gone to jail for carrying out an illegal action. The CFO gained no financial advantage, whilst the CEO who gained the financial advantage actually never went to jail. In the UK a programmer got into serious trouble when programming who got university places. After exhausting a variety of priority issues such as marks to decide who would get a position, he then made a decision based on skin colour. Programmers are regarded as professional/educated people by the courts and the courts view is that a programmer should no better when programming improper code. (Ignorance is no excuse) If a programmer modifies the code so the CFO does not pay the correct tax, then the court regards the programmer as an accomplice to the crime. The court's view is that a threat of sacking is not an excuse to commit a crime. Bill is right some IT people will be in for a horrific shock as they could be caught up in fraud, privacy issues, spam and other areas and most have not considered their legal implications. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill H. Sent: Thursday, 17 March 2005 5:00 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2]: Epicor Don: There are a number or current laws and regulations that attempt to rid public corporations of this kind of mismanagement. The result of these new regulations may not so much be the reduction of corporate financial and IT mismanagement, but the transfer of responsibility to lower level staff. :-( It may come to pass that you'll be held personally liable for someone else's indiscriminate business requirements. For those of us who think it is our role to provide others with the ability to trash the integrity of the organization's financial information; a rude awakening awaits! Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Wednesday, March 16, 2005 9:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2]: Epicor Our resident Bean Counters have asked for and received several tools from me that will allow them to do the same thing to our system. It's our job to provide the sharp knives, the CPA types have to be carefull not to remove appendages with said tools. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Include Equate record Errors Compiler
Make sure that the record SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV (or whatever the last include in your program is) has a correct end-of-marker. Editing and putting a blank line on the end will do it. Might not be your problem but I've had this several times in the past and the description you give fits exactly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2005 16:25 To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ? 49if not(assigned(odbcName)) then odbcName = '' ^ End of Line unexpected, Was expecting: '!', '=', AND, OR, LT, LE, GT, GE, NE, EQ, MATCH, ELSE 1 Errors detected, No Object Code Produced. *-- In the program you will see 2 equates .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV If these two equates are commented out and their associated lines (immediently below them) are uncommented .. it works. Note that the ODBC.H include works. Also the SQL_COMMON_INCLUDE is ok (simple label common common /sql_common/ comBaseEnv,comConnEnv,comSqlEnv,comErrorCheckEnv) Once again .. if either of these two equates are 'included' the program fails compile. I really cant see what could be causing this. The 'equ' below the includes are cut and paste of the include files Anyone see what could be going on here? *** function SQL_INITENV(odbcName, odbcUser, odbcPass) * $INCLUDE DAVES.BP SQL_COMMON_INCLUDE EQU TRUE$ to 1 EQU FALSE$ to 0 EQU NULL$ to '' * UNIVERSES INCLUDE FOR DEALING WITH ODBC $INCLUDE UNIVERSE.INCLUDE ODBC.H * LOCAL INCLUDES .. $INCLUDE DAVES.BP SQL_ERRORS_EQUATES.MV ** ** Errors returned from the function (sql_write, sql_Read etc) will return ** with MV list of errors. mv1 will contain one of these codes ** ** NOTE: return will be NULL if ok .. else .. ** *EQU CONNECTION_ERROR$ TO -99 *EQU UNABLE_TO_BIND_PARAMETERS$ TO -98 *EQU UNABLE_TO_BIND_COLUMNS$ TO -97 *EQU UNABLE_TO_PREPARE$ TO -96 *EQU UNABLE_TO_READ$ TO -95 *EQU UNABLE_TO_WRITE$ TO -94 *EQU UNABLE_TO_FETCH$ TO -93 *EQU UNABLE_TO_FREE_ENV$ TO -92 *EQU INVALID_PARAMETER_PASSED$ TO -91 *EQU CRITICAL_ERROR_CHECK$ TO -90 $include DAVES.BP SQL_DEFAULT_CONNECTION_INFO_INCLUDE.MV ** **abstract: Simply holds the default login connection through ** odbc. ** **author: dsig (David Tod Sigafoos) **date: 03mar05 ** ** *DEFAULTODBCNAME$ = 'FOOBAR' *DEFAULTODBCUSER$ = 'FOOBAR' *DEFAULTODBCPASS$ = 'FOOBAR' * make sure it is assigned something .. if not(assigned(odbcName)) then odbcName = NULL$ if not(assigned(odbcUser)) then odbcUser = NULL$ if not(assigned(odbcPass)) then odbcPass = NULL$ * set to default if necessary (see SQL_DEFAULT_CONNECTION_INFO_INCLUDE) if odbcName = NULL$ then odbcName = DEFAULTODBCNAME$ if odbcUser = NULL$ then odbcUser = DEFAULTODBCUSER$ if odbcPass = NULL$ then odbcPass = DEFAULTODBCPASS$ initErrors = NULL$ * * return (initErrors) DSig David Tod Sigafoos SigsSolutions, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Include Equate record Errors Compiler
It's the BASIC process itself that hangs if the end-of-file marker is incorrect. IF you kill those off it will release the session. We used to get it all the time when we first switched to using non-U2 editors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2005 18:12 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Include Equate record Errors Compiler It is possible .. I use TextPad and have for years .. but this is a new client .. who knows. I have noticed that since this problem started ... if I don't leave a blank at the end of equates the compiler will simply stop at the include. It just locks up the session and there is no way to kill the process/user/port. I now have 7 sessions (6 hung) from this mornings tracking .. I have never seen anything like this. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: RE: [U2] Include Equate record Errors Compiler From: Brian Leach [EMAIL PROTECTED] Date: Mon, March 14, 2005 9:09 am To: u2-users@listserver.u2ug.org Dave, Just a thought - what are you using to edit the INCLUDE source? It is possible that the last line of the file does not end in a CRLF or LF (depending on the OS). I've seen that cause similar problems. If that is the case, go into each include in ED and FILE it. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2005 16:25 To: U2 Users List Subject: [U2] Include Equate record Errors Compiler Okay .. this one has got me .. The program below will not compile. It compiler responds with .. *-- 01 basic DAVES.BP DEMO.MV Compiling: Source = 'DAVES.BP/DEMO.MV', Object = 'DAVES.BP.O/DEMO.MV' ** **? --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Indexing issue
Try quoting it as 'A12'... instead. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen Egerton Sent: 11 March 2005 20:08 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Indexing issue From: Dan Knutson [EMAIL PROTECTED] Sent: Friday, March 11, 2005 2:23 PM Subject: [U2] Indexing issue I have a file that has thousands of keys that start with an A. There is an index on the key. When I try and do a search for any items that start with say A12 and I type in A12... the search does not return what I expect and takes a long time because Unidata thinks it is doing a Alphanumeric search. Is there a way to get the results I expect? If the primary key is indexed, that's pretty much a waste of time. Indexing PART of the primary key on the other hand would be useful. You might consider creating an I-Type dictionary item that's @ID[1,3], and then indexing that field. That would work rather quickly. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
How do you track a record being deleted from the file though? The real trigger mechanism fires with INSERT, UPDATE or DELETE. If memory serves this type of pseudo-trigger can't differentiate between a delete and an insert/update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 20:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? Here is link that might be helpful: (works for both UV UD) http://www.mindspring.com/~tpackert/unidata_tricks.htm I have used the index-trigger method to track and record all changes to a file. It seems to work well; the performance hit has been negligible. If anyone is interested I will post the code. The only gotcha was figuring out how many times the TRIGGER subroutine was called, and what my RECord variable contained each time. Here is the note at the top of the subroutine regarding this: SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID) * This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE. * A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when a MYFILE record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the MYFILE record is new, this subroutine is called only once). Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Web Services for Dummies
This one has come up again and again over the last few weeks. You'll find lots of posting about it on www.indexinfocus.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy Sent: 11 March 2005 21:00 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Web Services for Dummies Has anyone developed a web service for Universe ? I'm trying to gather as much info as I can about the technology used. I realize UV 10.1 has many of the tools that I'll need for the backend, but what is normally used on the frontend, what communications protocal is normally used ? I've read alot of theory about how it should work, but I haven't come across anything that gives me some concrete examples. Can someone direct me to some information or maybe explain to me in practical terms on how an xml request would come into UV then a response sent back to the requestor from UV using xml. If you've done web services using ASP.NET and UV I would appreciate hearing from you. thx. rudy Rudy Cooper Sage Publications I.T Development Thousand Oaks, California (805) 499-0721 #7724 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
Must be a Unidata thing. It only gets called once on Universe. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 22:29 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? The trigger is normally called twice: the first time you get the original @RECORD, the second time the new @RECORD. If an item is new or being deleted, then the trigger is called only once. I use named common to track of where I am and to save old @RECORD, so that I can test: if this is not a new item, and old @RECORD is null, then this must be a delete. Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, March 11, 2005 1:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? How do you track a record being deleted from the file though? The real trigger mechanism fires with INSERT, UPDATE or DELETE. If memory serves this type of pseudo-trigger can't differentiate between a delete and an insert/update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 20:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? Here is link that might be helpful: (works for both UV UD) http://www.mindspring.com/~tpackert/unidata_tricks.htm I have used the index-trigger method to track and record all changes to a file. It seems to work well; the performance hit has been negligible. If anyone is interested I will post the code. The only gotcha was figuring out how many times the TRIGGER subroutine was called, and what my RECord variable contained each time. Here is the note at the top of the subroutine regarding this: SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID) * This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE. * A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when a MYFILE record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the MYFILE record is new, this subroutine is called only once). Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Triggers docs?
I think this must be something to do with why proper triggers impose such a load on a universe system. It has to check for deletes using some internal mechanism. Mind you the replication in Universe imposes very little load and that track deletes as well -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 22:55 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? I should think a little longer before pressing send... It's not that easy to catch a delete using this kind of trigger. You can test for a new record by trying to read it, if it's not there then this is a new update. But since the trigger is called only once for a delete, it gets pretty ugly to trap for this condition. The best answer I can come up with on a Friday afternoon is treat every first pass as a delete, then un-do whatever you did to track the delete on the second pass (if there is one). That is a particularly heinous solution, however. There must be a better way to do this. Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, March 11, 2005 1:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? How do you track a record being deleted from the file though? The real trigger mechanism fires with INSERT, UPDATE or DELETE. If memory serves this type of pseudo-trigger can't differentiate between a delete and an insert/update. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Ballinger Sent: 11 March 2005 20:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Triggers docs? Here is link that might be helpful: (works for both UV UD) http://www.mindspring.com/~tpackert/unidata_tricks.htm I have used the index-trigger method to track and record all changes to a file. It seems to work well; the performance hit has been negligible. If anyone is interested I will post the code. The only gotcha was figuring out how many times the TRIGGER subroutine was called, and what my RECord variable contained each time. Here is the note at the top of the subroutine regarding this: SUBROUTINE SAVE.CHANGES.MYFILE(ANS,REC,ID) * This subroutine is called from the 'TRIGGER' I-Type in dict MYFILE. * A secondary index on MYFILE is defined on 'TRIGGER' using the NO.NULLS option. * That forces this subroutine to be called twice when a MYFILE record is updated: * the first time with REC = the original record, then again with REC = the new * record (however, if the MYFILE record is new, this subroutine is called only once). Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Friday, March 11, 2005 10:15 AM To: u2-users@listserver.u2ug.org Subject: [U2] Triggers docs? The manual is a bit skimpy on triggers. Any supplemetal docs around? We're trying to track updates to a file; individual items have gone missing lately. No SQL involvement at all. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority
RE: [U2] Universe objects licence
If the users were running multiple VB sessions then it might worth looking at device (enterprise) licensing but as Universe doesn't allow the pool of ten connections per license to be shared amongst processes (ie telnet programs) it probably won't work for you. At the end of the day if you're planning on running 100 users then you should have a 100 user license. After all why should an objects license be any cheaper as you have access to the full functionality of universe? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 04 March 2005 11:47 To: u2-users@listserver.u2ug.org Subject: [U2] Universe objects licence We have Universe 10.0.10 running on a Windows 2000 server with a 50 user licence. We have about 40 users using telnet sessions and about 20 using a VB6.0 program to enter data. We are having problems where the session drops because users are not logging out of the VB program, I have increased the NETTIME but we still get the odd session dropping and then users cant login as we have hit the maximum licences. I thought there was no limit in the objects licence, or was this only in earlier versions. Can someone tell me if I can buy a licence just for objects as I want to increase this to 100 users. Has anyone resolved similar problems with this. Many thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe objects licence
Unfortunately the Universe device licensing doesn't work like that. Not sure about Unidata but the question related to Universe. The 10 connection pool cannot be shared between the terminal emulator and uniobjects. I asked (via my VAR) if IBM had any plans to allow that and apparently they don't. Even more annoyingly the new licensing model doesn't allow Phantoms to use the device license pool. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Renfrew Sent: 04 March 2005 13:31 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe objects licence If the VB6 users are also Telnet users that utilize Dynamic Connect, wIntegrate or AccuTerm with device licensing, then you should only need 40 UniData device licenses. Regards, Ian Renfrew - Original Message - From: David Jordan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, March 04, 2005 7:57 AM Subject: RE: [U2] Universe objects licence UniObjects does not have licenses, the licenses are related to the access to the UniVerse database. With a 50 user license only 50 concurrent users can access the database at a time. If you have 40 telnet users and 20 VB6 user then you need 60 concurrent licenses and the last 10 users to login would be denied access. The solution might be just to purchase 10 more universe licenses. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 4 March 2005 10:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe objects licence We have Universe 10.0.10 running on a Windows 2000 server with a 50 user licence. We have about 40 users using telnet sessions and about 20 using a VB6.0 program to enter data. We are having problems where the session drops because users are not logging out of the VB program, I have increased the NETTIME but we still get the odd session dropping and then users cant login as we have hit the maximum licences. I thought there was no limit in the objects licence, or was this only in earlier versions. Can someone tell me if I can buy a licence just for objects as I want to increase this to 100 users. Has anyone resolved similar problems with this. Many thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Is replication across versions a possibility?
Replication was incredibly slow before version 10 and had a large impact on file updates. We have replication running between Windows and Linux versions in test without problems. Due to limited downtime windows we are planning to switch systems over two weekends with replication running in between. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Ivanick Sent: 04 March 2005 13:38 To: u2-users@listserver.u2ug.org Subject: [U2] Is replication across versions a possibility? Hola - We've got a 9.5 system running on Irix that we're going to be upgrading to 10.1.4 running on Linux on new hardware, and it strikes me that replication might be a good way to minimize system downtime while we do the upgrade. Any idea whether there would be any additional hitches in doing replication across platforms versions? We would of course have fnuxied and otherwise modified the files prior to the replication being set to go. Any thoughts (or alternative strategies to minimize system downtime during an upgrade) would be greatly appreciated. -- Peter Ivanick Sr. Programmer/Analyst School of Veterinary Medicine, University of Pennsylvania Email: [EMAIL PROTECTED] Phone: 215.573.2306Fax: 215.573.8777 http://www.vet.upenn.edu/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe objects licence
Maybe it's just the Windows version that doesn't work like that then. IBM support themselves confirmed to me that the scenario you state doesn't work and we can see it on out servers. We have several running enterprise licenses that can handle 10 connections from wIntegrate but without access to the device key the UniObjects sessions can't use the same pool. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sunny Matharoo Sent: 04 March 2005 15:01 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe objects licence Device Licensing does work and if you have the Enterprise Edition of UV then it works very well. We have a VB app as well as wIntegrate including Dynamic Connect and Viaduct that quite happliy share the 10 connection pool. This is in UV 10.1.4 and AIX 5 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: 04 March 2005 14:16 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe objects licence Unfortunately the Universe device licensing doesn't work like that. Not sure about Unidata but the question related to Universe. The 10 connection pool cannot be shared between the terminal emulator and uniobjects. I asked (via my VAR) if IBM had any plans to allow that and apparently they don't. Even more annoyingly the new licensing model doesn't allow Phantoms to use the device license pool. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Renfrew Sent: 04 March 2005 13:31 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe objects licence If the VB6 users are also Telnet users that utilize Dynamic Connect, wIntegrate or AccuTerm with device licensing, then you should only need 40 UniData device licenses. Regards, Ian Renfrew - Original Message - From: David Jordan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, March 04, 2005 7:57 AM Subject: RE: [U2] Universe objects licence UniObjects does not have licenses, the licenses are related to the access to the UniVerse database. With a 50 user license only 50 concurrent users can access the database at a time. If you have 40 telnet users and 20 VB6 user then you need 60 concurrent licenses and the last 10 users to login would be denied access. The solution might be just to purchase 10 more universe licenses. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 4 March 2005 10:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe objects licence We have Universe 10.0.10 running on a Windows 2000 server with a 50 user licence. We have about 40 users using telnet sessions and about 20 using a VB6.0 program to enter data. We are having problems where the session drops because users are not logging out of the VB program, I have increased the NETTIME but we still get the odd session dropping and then users cant login as we have hit the maximum licences. I thought there was no limit in the objects licence, or was this only in earlier versions. Can someone tell me if I can buy a licence just for objects as I want to increase this to 100 users. Has anyone resolved similar problems with this. Many thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email
RE: [U2] Universe objects licence
We run Wintegrate 5.2 which fully supports device licensing. What I wanted to do was to run 5 sessions with wintegrate and 5 sessions with uniobjects and only take 1 license. IBM said that this will not work and they have no intention of making it work. The problem is that you need to know the subkey that wintegrate is using to pass over with the uniobjects call apparently. Are you sure it's working on your setup? It looks like it does on ours until you do a cross comparison of the user count against uvlictool. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: 04 March 2005 20:45 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe objects licence That is a bug, IBM sold it on the basic that you can run 10 sessions on any combination of ODBC, OLE-DB, Telnet, UniObjects. I have it working on Windows. What version of Wintegrate are you running, if it is to early it may not handle device licensing. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Saturday, 5 March 2005 2:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe objects licence Maybe it's just the Windows version that doesn't work like that then. IBM support themselves confirmed to me that the scenario you state doesn't work and we can see it on out servers. We have several running enterprise licenses that can handle 10 connections from wIntegrate but without access to the device key the UniObjects sessions can't use the same pool. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sunny Matharoo Sent: 04 March 2005 15:01 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe objects licence Device Licensing does work and if you have the Enterprise Edition of UV then it works very well. We have a VB app as well as wIntegrate including Dynamic Connect and Viaduct that quite happliy share the 10 connection pool. This is in UV 10.1.4 and AIX 5 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: 04 March 2005 14:16 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe objects licence Unfortunately the Universe device licensing doesn't work like that. Not sure about Unidata but the question related to Universe. The 10 connection pool cannot be shared between the terminal emulator and uniobjects. I asked (via my VAR) if IBM had any plans to allow that and apparently they don't. Even more annoyingly the new licensing model doesn't allow Phantoms to use the device license pool. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ian Renfrew Sent: 04 March 2005 13:31 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe objects licence If the VB6 users are also Telnet users that utilize Dynamic Connect, wIntegrate or AccuTerm with device licensing, then you should only need 40 UniData device licenses. Regards, Ian Renfrew - Original Message - From: David Jordan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, March 04, 2005 7:57 AM Subject: RE: [U2] Universe objects licence UniObjects does not have licenses, the licenses are related to the access to the UniVerse database. With a 50 user license only 50 concurrent users can access the database at a time. If you have 40 telnet users and 20 VB6 user then you need 60 concurrent licenses and the last 10 users to login would be denied access. The solution might be just to purchase 10 more universe licenses. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, 4 March 2005 10:47 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe objects licence We have Universe 10.0.10 running on a Windows 2000 server with a 50 user licence. We have about 40 users using telnet sessions and about 20 using a VB6.0 program to enter data. We are having problems where the session drops because users are not logging out of the VB program, I have increased the NETTIME but we still get the odd session dropping and then users cant login as we have hit the maximum licences. I thought there was no limit in the objects licence, or was this only in earlier versions. Can someone tell me if I can buy a licence just for objects as I want to increase this to 100 users. Has anyone resolved similar problems with this. Many thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly
RE: [U2][UV] COMMON question
That would mean passing common across sessions. Something that I wish was possible but unfortunately is not as far as I know. Any routines that your phantom calls can see the common. But if you telnet in or start another phantom that can't see it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: 04 March 2005 21:51 To: u2-users@listserver.u2ug.org Subject: [U2][UV] COMMON question Hello All, Question on COMMON. Is there a way to use COMMON so that any subroutine can use the COMMON variables for that account. I'm thinking I could write a program that will set some COMMON variables and run as a phantom job. I would then have other processes call subroutines that would use the variables that are set by this program in the COMMON area. Is this possible? Thanks. Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Size Limit in a Dynamic Array
Pretty sure the limit on any argument to a UniObjects call is 16k. Been a while since I used it though so that limitation may have gone by now. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sunny Matharoo Sent: 03 March 2005 10:21 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Size Limit in a Dynamic Array Hi, I wonder if anyone would know what the size limit of data that can be handled within a dynamic array from within UniObjects. We came across a limit whereby a customer had just over 14000 items in an array that was being returned from UV. The application threw an error when it came back with the data and tried to assign it too a variable in the application. We use Universe 10.1.4, on AIX Ver 5.0 and using UniObjects ver 3.1 Any help much appreciated. Thanks Sunny Matharoo Development Team Leader Tristar Worldwide Chauffeur Services Tel:+44 (0) 1895 432072 Fax:+44 (0) 1895 432098 E-mail: [EMAIL PROTECTED] www.tristarworldwide.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] making 00001 our of 1
Personally I find well spaced and structured code easier to read. Consider the following: BEGIN CASE CASE V=5 TOTAL = AMT*RATE CASE V=6 TOTAL = AMT*RATE2 CASE 1 ERR = 14 END CASE Is much better as: Begin Case Case RateIndicator = 5 TotalAmt = Amount * MainRate Case RateIndicator = 6 TotaAmt = Amount * SecondaryRate Case ELSE ErrorCode = INVALID_RATE_ERROR_CODE End Case Obviously ELSE and INVALID... are equates. Humans can read mixed case a great deal easier than all uppercase and the spacing helps the logic. Sensible variable naming negates the need for comments. All above IMHO and how long will this thread survive before going to community!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 03 March 2005 13:53 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] making 1 our of 1 IMHO I use the term 'overly grand' when i review existing prior code on my current and new clients and there is a very large verbose nature to it. Not being conclusive, but often times the code looks nice but there's way too much 'air' in the program at the expense of being better in the logic area. Certainly I've not read everyone's code. But what I've seen over the years has taught me that when I see grandness, that grandness takes a 200 line program and makes it 700. Case in point: *** * * OPEN MD FILE * *** OPEN ,MD TO F.MD ELSE ERRMSG=CANNOT OPEN THE MD FILE. PLEASE CONTACT YOUR PROGRAMMER GOSUB 9 STOP END * * * OPEN PRODUCT FILE * * OPEN ,PRODUCT TO F.PRODUCT ELSE ERRMSG=CANNOT OPEN THE PRODUCT FILE. PLEASE CONTACT YOUR PROGRAMMER GOSUB 9 STOP END * * END OF OPENING FILES * What gets me is the time spent to make the asterisks match the length of the comments. I see your variable assignment style a lot yet if a new variable were needed, say CUSTOMER.LAST.SALE.DATE = would you re-indent all of the other variables just to look pretty? (I don't mean pretty in a derogatory way, I mean to spend your time and the client's $ for something that really doesn't matter) I know that there are some system-generated source code 4GL's that may create the comments for you. But I can see past that with the inconsistent content of the actual code. There is a command which escapes me now that formats source code (not necessarily databasic) in the editor to match old-school BAL programming. I've tripped over it by accident and then lose my changes as I EXit and then re-edit to not have all the 'air'. Some could argue that a 200 line program becoming 700 could fall under the concept of standardized programming or making it easier for the next guy. Well, I'm that 'next guy' plenty of times and since it's very inconsistent, it's certainly not a standard. I could write a book on the wide variety of programming 'standards' I've inherited and the ineffeciencies found. It's unfortunate that in my travels the grandness happens to have a related brother of reduced logic and a more brute force approach. It's just harder to research with all of that clutter. My 2 cents. Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 03, 2005 6:56 AM Subject: Re: [U2] [UV] making 1 our of 1 Mark, I'm one of those programmers who use the overly grand way of spacing you describe. I believe that ASDTFY = '' AS = '' DRT = 0 is much more readable than ASDTFY='' AS='' DRT=0 especially when there is a lot more code than in this example, and everything else around it is crammed together as tightly as it can be as well. Code is written for the human as much as the compiler, and I like it to be as easy to read (and spot errors) as possible. This spacing won't bother a find program if you wrote it or have the source, and teach it better. My 4 cents. Regards, Charlie Noah [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) writes: [snip] P.S. If you use my concept, you may want to have your search strings contain no spaces and convert to the spaces in each reviewed line. There is a overly grand way people program with spaces between operators and even though the complier doesn't care, FIND programs or the editor will miss them if they don't match exactly. My 3 cents. - Original Message - From: Barry Brevik [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) I have always used R%5 but I may miss programs that use other techniques to arrive at the same result. Can someone give me examples that they have seen for changing 1 to 1? I don't want to start a religious war, but I think it
RE: [U2] unsubscribe
Look at the bottom of the email! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Stearns Sent: 02 March 2005 19:08 To: u2-users@listserver.u2ug.org Subject: [U2] unsubscribe Sorry for addressing the whole list, I need the address to send an unsubscribe request to. It should, perhaps, be a repeating message, maybe monthly? We get the information when we subscribe, then years later when we want to unsubscribe, searching our email archives (if we have any that old) become a formidable task. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] UO.NET beginner question
What have you declared us1 as? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Cipollina Sent: 01 March 2005 13:42 To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] UO.NET beginner question Here is the code I am trying to use: us1 = null ; us1.HostPort = 7200; try { us1 = UniObjects.OpenSession(Server,LoginName,Password,uvAccount,uvcs ); It is compiling just fine, I am getting an error when I run it though. Any suggestions? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 7:11 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question (this won't compile and is not meant to) Have a look in the UniObjects .Net pdf file for more info on this, but here's how you can change the port number used for the connection. public UniSession uSession; uSession.HostPort = 12345; uSession = UniObjects.OpenSession(Server, LoginName, PassWord, uvAccount, uvcs); On Mon, 28 Feb 2005 16:35:35 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: How exactly can I do this?. (I'm new to .NET). Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 3:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Check the UniSession property HostPort. I believe that if you set it to match your host settings you should be OK. On Mon, 28 Feb 2005 14:46:52 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: Our rpc port is set to 7200. Is there something I need to change within .NET to tell it to look for that port? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Monday, February 28, 2005 2:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Make sure the remote machine has the uniobjects port enabled and there are no firewalls between you and it that also block this port. On an HP-UX machine this is port 31438. Have a look at the services file in /etc and make sure this line is in there somewhere. uvrpc 31438/tcp # uvNet rpc port On Mon, 28 Feb 2005 12:49:04 -0500, Nick Cipollina [EMAIL PROTECTED] wrote: Hello all, I've got a dumb UO.NET question to ask. I am trying to write a simple UO.NET program to connect to one of our UniVerse servers and I am getting the following error: No connection could be made because the target machine actively refused it. Any ideas what I am missing? Thanks. Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Replication
We use it on Universe on Windows and it works very well. Sync can be very slow though. I expect it's all different in UD though From: [EMAIL PROTECTED] on behalf of David Wolverton Sent: Mon 28/02/2005 15:40 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Replication I had actually seen your email in a U2 log - it's what prompted me to write the user group to see if things had changed... And so far, I've heard no one say 'we ARE using Replication on Windows'... David W. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, February 28, 2005 5:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] Replication Hi We have been testing Unidata Replication for a number of months now and at the moment are unable to recommend it to our users. One of the main reasons, is that you can not be certain that the system is actually replicating. You should note that ud_repadmin -report only reports from local shared memory , it does NOT enquire of the remote servers status, so only reports on the local systems replication status. The only way to get a remote status is by doing a 'sync' and seeing if it works. Replication is obviously an important product for IBM and they have been working with us to get reproducable cases. They are now looking at what can be done to improve the system. Regards James Hogan Sungard -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Wolverton Sent: 27 February 2005 23:52 To: u2-users@listserver.u2ug.org Subject: [U2] [UD] Replcation I'd like to find out those of you using the UniData replication features and your experience. I'm on Windows, UD 6.0.12 on both sides of the Replication. I've got a site that is driving me MAD - Replication suddenly halted running two months ago after running for 4 months without issue. I've stood on my head trying to get things back and up and running... I've got IBM assisting, but is there anything that anyone ran across along the way that was a gotcha? In my case, the Repmanager.exe will just die on the publisher. Not every 'group' is coming up, and I am scratching my head as to why. IBM is sort of at the same place, as there appears not to be anything 'obvious', other than I'm trying to replicate an account's worth of files (hundreds), but it did (appear) to work for months before just stopping. (It's an end-user site, so I don't think they have the skill or desire to change anything -- at this point, I've changed just about EVERYTHING trying to find why it's not running!) Any thoughts would be good - and knowing if it's 'just me' -- if it is, then I've got more incentive to keep digging on my side - however, if no one has a production level install running, or have issues keeping it running, then maybe I need more IBM assist!! I read somewhere that there was an issue 'knowing' it was running - that was our case - I only know when it stopped based on modification dates in Windows! The end user was blissfully unaware Thanks for any thoughts - David W. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] MASTER OFF port
On our windows Universe system we used to have a phantom process that ran under with administrative rights. This used to check a file every 15 seconds for instructions to MASTER OFF a port. The users had a program they could run that wrote the record to the file. That way they had the ability to log off users without needing admin access. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Farrant Sent: 23 February 2005 13:57 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] MASTER OFF port Yes we're in the process of rolling out sudo to our IT staff and removing root access but we have not been able to get MASTER OFF to work. I was always led to believe that MASTER OFF is a cleaner way to drop Universe sessions rather than killing the sessions at unix level. Mike Farrant IT Manager, Premdor UK -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Lakeland Sent: 23 February 2005 12:53 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] MASTER OFF port Not sure about doing it from Universe as it's the unix permissions which come into effect. You could use the sudo utility and then allow them to kill the process from Unix or a universe shell executing a unix command. Sudo (superuser do) allows a system administrator to give certain users (or groups of users) the ability to run some (or all) commands as root while logging all commands and arguments. Sudo operates on a per-command basis, it is not a replacement for the shell. andy -Original Message- From: Mike Farrant [mailto:[EMAIL PROTECTED] Sent: 23 February 2005 13:02 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] MASTER OFF port Hi, Can anyone tell me if there is a way to allow non root access users to access the universe MASTER OFF command? We are on version 9.6.1.6 of Universe. Thanks Mike Farrant --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Default Catalog?
Perhaps it's set to load into shared memory at Uv startup? Although I think that requires it to be in global catalog as well. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jacques G. Sent: 23 February 2005 06:28 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Default Catalog? I've been working on a Universe 10.xx on an Dec Alpha machine, I found an account where a subroutine was being called and the routine wasn't catalogued in that account. It wasn't catalogued globally as well. There seems to be some default at work where if the subroutine isn't catalogued, it checks in the library of the calling program ? (Like the include statement ?). I've previously worked on versions 6.xx to 9.xx on a HP-UX and I don't remember it doing this. (But then, most of the routines I used were usually in a different library there) Is this something new ? __ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uv pe
Yes but how much does it cost to license Oracle and Access for a Live environment? From: [EMAIL PROTECTED] on behalf of Phil Walker Sent: Thu 17/02/2005 01:17 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Hi, Microsoft and Oracle both GIVE away, yes I said give away versions of their database products, and they both interact easily with modern gui/web based development environments, and you can search HUGE knowledge bases of information about how to do something. I know people in this group think U2 is the greatest, but that does not make it necessary to lock it up like the crown jewels. Questions: Why can't end users access the knowledgebase? Why isn't their developer versions of the U2 products, as it is the developers you generate UV license sales, not IBM? I can pay $900.00 NZD per year, and get a copy of MS Sql Server 2000, MS Exchange, MS SBS, 10 CALS for MS Professional XP, 10 CALS for MS Office 2003, Sharepoint Portal, MS 2003 Server, MS 2003 Web Edition all to use for demos or in house to run my business. Some people may wonder why you would develop something in U2? Cheers, Phil Walker +64 27 5336294 +64 3 3120352 [EMAIL PROTECTED] Gnosys Consulting Limited 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury 8252, NEW ZEALAND DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Gnosys Consulting Limited is not responsible for any changes made to this message and / or any attachments after sending by Gnosys Consulting Limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Thursday, February 17, 2005 12:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe I never thought I'd see grown people complaining that they hadn't gotten their free stuff soon enough. As in *free* *No charge* As in if you complain *TOO MUCH* maybe they'll start charging $100.00 for it.PER YEAR. You wanna know how much software I give away for free? Ok, maybe one little SUBR dict program using an index to retrieve data from a file with a different id, but that was it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Kent Sent: Wednesday, February 16, 2005 14:19 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv pe What a joke Leroy I cant get access to Tech connect as we get our universe licenses through a master var This annoys us plus our client sites with inhouse programmers Its hard to defend IBM when they treat you like this jak - Original Message - From: Leroy Dreyfuss [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 16, 2005 4:05 PM Subject: RE: [U2] uv pe They are coming. We haven't broken any promises. The quarter is only half over. I would have thought a fair number of you folks would have downloaded earlier versions by now as they were on the U2TechConnect Website for a couple of years. We know you all want the latest and greatest features we have to experiment with, and you'll have them with just a little patience. Because they are free evaluation copies, we are required to package them a bit differently, and the U2 group was not the only group involved in the process. We, too, had to wait. They are nearly ready to be placed on the Web again, and we do regret the time it has taken to get this far. We will be sure to announce their arrival as soon as they are ready. Thanks again for waiting. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Marc Harbeson [EMAIL PROTECTED] .com To Sent by: u2-users@listserver.u2ug.org, [EMAIL PROTECTED] u2-users@listserver.u2ug.org stserver.u2ug.org cc Subject 02/15/2005 09:28 RE: [U2] uv pe PM Please respond to [EMAIL PROTECTED] er.u2ug.org :-) I was so mad. I had just sent the email to IBM asking them where PE was just a few days ago and got put off again... till march. This crap is beyond silly... I can download all kinds of PE versions of Oracle poke
RE: [U2] uv pe
To license Oracle for our production hardware would cost GBP250,000 or FIVE times what Universe costs us. And thats just for a database, I'd have to get more licenses to actually develop an equivalent system. I may have to pay for dev/test licenses on Universe whereas on Oracle I don't but it would still cost at least three times more to use Oracle. From: [EMAIL PROTECTED] on behalf of Phil Walker Sent: Thu 17/02/2005 01:17 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Hi, Microsoft and Oracle both GIVE away, yes I said give away versions of their database products, and they both interact easily with modern gui/web based development environments, and you can search HUGE knowledge bases of information about how to do something. I know people in this group think U2 is the greatest, but that does not make it necessary to lock it up like the crown jewels. Questions: Why can't end users access the knowledgebase? Why isn't their developer versions of the U2 products, as it is the developers you generate UV license sales, not IBM? I can pay $900.00 NZD per year, and get a copy of MS Sql Server 2000, MS Exchange, MS SBS, 10 CALS for MS Professional XP, 10 CALS for MS Office 2003, Sharepoint Portal, MS 2003 Server, MS 2003 Web Edition all to use for demos or in house to run my business. Some people may wonder why you would develop something in U2? Cheers, Phil Walker +64 27 5336294 +64 3 3120352 [EMAIL PROTECTED] Gnosys Consulting Limited 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury 8252, NEW ZEALAND DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Gnosys Consulting Limited is not responsible for any changes made to this message and / or any attachments after sending by Gnosys Consulting Limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Thursday, February 17, 2005 12:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe I never thought I'd see grown people complaining that they hadn't gotten their free stuff soon enough. As in *free* *No charge* As in if you complain *TOO MUCH* maybe they'll start charging $100.00 for it.PER YEAR. You wanna know how much software I give away for free? Ok, maybe one little SUBR dict program using an index to retrieve data from a file with a different id, but that was it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Kent Sent: Wednesday, February 16, 2005 14:19 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv pe What a joke Leroy I cant get access to Tech connect as we get our universe licenses through a master var This annoys us plus our client sites with inhouse programmers Its hard to defend IBM when they treat you like this jak - Original Message - From: Leroy Dreyfuss [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 16, 2005 4:05 PM Subject: RE: [U2] uv pe They are coming. We haven't broken any promises. The quarter is only half over. I would have thought a fair number of you folks would have downloaded earlier versions by now as they were on the U2TechConnect Website for a couple of years. We know you all want the latest and greatest features we have to experiment with, and you'll have them with just a little patience. Because they are free evaluation copies, we are required to package them a bit differently, and the U2 group was not the only group involved in the process. We, too, had to wait. They are nearly ready to be placed on the Web again, and we do regret the time it has taken to get this far. We will be sure to announce their arrival as soon as they are ready. Thanks again for waiting. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] WWW: http://www.ibm.com/software/data/u2 Marc Harbeson [EMAIL PROTECTED] .com To Sent by: u2-users@listserver.u2ug.org, [EMAIL PROTECTED] u2-users@listserver.u2ug.org stserver.u2ug.org cc Subject 02/15/2005 09:28 RE: [U2] uv pe PM Please respond to [EMAIL PROTECTED]
RE: [U2] uv pe
But in that environment (as an embedded database) U2 is already far bigger than Oracle. From: [EMAIL PROTECTED] on behalf of Simon Carter Sent: Thu 17/02/2005 11:35 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: 17 February 2005 10:26 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Yes but how much does it cost to license Oracle and Access for a Live environment? Adrian, Fair point, but by the time that *that* question needs to be raised in seriousness, the user/developer/software house has had a dabble and decided whether or not Oracle/Access is a viable technology for their needs. Give away limited duration/limited user versions of U2, with full GUI admin and a GUI only version of SB+, and I wonder how many people would be converted/influenced? Perhaps not that many, but more, I'd guess, that those likely to be impressed by a command line environment, databasic and proc. My 2d worth. Simon --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uv pe
For us we would have to use the Oracle enterprise licenses due to the number of cpu's we use. A lot, lot more than $150 per cpu. From: [EMAIL PROTECTED] on behalf of Bill H. Sent: Thu 17/02/2005 16:13 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Adrian: I recently saw a Dell add where they partner with Oracle and one can purchase an Oracle license for about $150/license. Don't know how that works out in a web environment or a device licensing scenario but that's not anywhere near as expensive as it used to be. Also, Microsoft SQL Server can be had for about $5,000 (or less) for an unlimited license on a single processor. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: Thursday, February 17, 2005 2:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Yes but how much does it cost to license Oracle and Access for a Live environment? From: [EMAIL PROTECTED] on behalf of Phil Walker Sent: Thu 17/02/2005 01:17 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Hi, Microsoft and Oracle both GIVE away, yes I said give away versions of their database products, and they both interact easily with modern gui/web based development environments, and you can search HUGE knowledge bases of information about how to do something. I know people in this group think U2 is the greatest, but that does not make it necessary to lock it up like the crown jewels. Questions: Why can't end users access the knowledgebase? Why isn't their developer versions of the U2 products, as it is the developers you generate UV license sales, not IBM? I can pay $900.00 NZD per year, and get a copy of MS Sql Server 2000, MS Exchange, MS SBS, 10 CALS for MS Professional XP, 10 CALS for MS Office 2003, Sharepoint Portal, MS 2003 Server, MS 2003 Web Edition all to use for demos or in house to run my business. Some people may wonder why you would develop something in U2? Cheers, Phil Walker +64 27 5336294 +64 3 3120352 [EMAIL PROTECTED] Gnosys Consulting Limited 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury 8252, NEW ZEALAND DISCLAIMER: This electronic message together with any attachments is confidential. If you are not the intended recipient, do not copy, disclose or use the contents in any way. Please also advise us by return e-mail that you have received the message and then please destroy. Gnosys Consulting Limited is not responsible for any changes made to this message and / or any attachments after sending by Gnosys Consulting Limited. We use virus scanning software but exclude all liability for viruses or anything similar in this email or any attachment. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allen E. Elwood Sent: Thursday, February 17, 2005 12:20 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe I never thought I'd see grown people complaining that they hadn't gotten their free stuff soon enough. As in *free* *No charge* As in if you complain *TOO MUCH* maybe they'll start charging $100.00 for it.PER YEAR. You wanna know how much software I give away for free? Ok, maybe one little SUBR dict program using an index to retrieve data from a file with a different id, but that was it! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Kent Sent: Wednesday, February 16, 2005 14:19 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv pe What a joke Leroy I cant get access to Tech connect as we get our universe licenses through a master var This annoys us plus our client sites with inhouse programmers Its hard to defend IBM when they treat you like this jak - Original Message - From: Leroy Dreyfuss [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 16, 2005 4:05 PM Subject: RE: [U2] uv pe They are coming. We haven't broken any promises. The quarter is only half over. I would have thought a fair number of you folks would have downloaded earlier versions by now as they were on the U2TechConnect Website for a couple of years. We know you all want the latest and greatest features we have to experiment with, and you'll have them with just a little patience. Because they are free evaluation copies, we are required to package them a bit differently, and the U2 group was not the only group involved in the process. We, too, had to wait. They are nearly ready to be placed on the Web again, and we do regret the time it has taken to get this far. We will be sure to announce their arrival as soon as they are ready. Thanks again for waiting. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management
RE: [U2] uv pe
It might be an Urban Myth but what I heard was that it was very easy to remove the licensing/modulo restrictions on PE and give yourself a free unlimited used version of Universe. Given the lengths that some people seem to go to avoid paying license fees (hundreds of phantoms etc etc) I wouldn't be suprised and that would explain why they won't repost the older versions. From: [EMAIL PROTECTED] on behalf of Craig Bennett Sent: Wed 16/02/2005 05:52 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv pe Leroy, They are nearly ready to be placed on the Web again, and we do regret the time it has taken to get this far. We will be sure to announce their arrival as soon as they are ready. would it be possible to leave the older versions up? That way if someone quickly want to test something on an older U2 version than the current release, there might be a chance that they could download it. It would also mean there was always a version available to download even if it wasn't the very latest :) Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uv pe
But as IBM posted earlier you're not allowed to give that to anyone. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Lakeland Sent: 16 February 2005 13:30 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe If someone needs a copy of PE, I have version 10.01, it's a 13mb files. andy -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: 16 February 2005 11:37 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe It might be an Urban Myth but what I heard was that it was very easy to remove the licensing/modulo restrictions on PE and give yourself a free unlimited used version of Universe. Given the lengths that some people seem to go to avoid paying license fees (hundreds of phantoms etc etc) I wouldn't be suprised and that would explain why they won't repost the older versions. From: [EMAIL PROTECTED] on behalf of Craig Bennett Sent: Wed 16/02/2005 05:52 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv pe Leroy, They are nearly ready to be placed on the Web again, and we do regret the time it has taken to get this far. We will be sure to announce their arrival as soon as they are ready. would it be possible to leave the older versions up? That way if someone quickly want to test something on an older U2 version than the current release, there might be a chance that they could download it. It would also mean there was always a version available to download even if it wasn't the very latest :) Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- 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] Has anyone played with/tested UniVerse 10+ under Solaris 10
Yes but if everything else is equal then clock speed does play a part. Love to use an Opteron but they're not supported so a non-starter. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: 11 February 2005 18:17 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: Friday, February 11, 2005 8:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 We've been through a very similar exercise recently (as you've probably guessed) and we came down to using IBMx445 servers with RHEL AS 3. As the clock speed of the SPARC is relatively low compared to a Xeon MP we found that combination outperformed the Sun (and was a lot cheaper once a large disk array was added in). There was nothing that Sun could do to improve the performance due to Universe being compiled against a very old solaris (7) version. Core clock speed, alone, is an irrelevant factor in the overall performance. It typically only makes a difference based on chip architecture, bus speed, memory access, and chipset performance. The Sun box is a RISC platform, right? I'd be interested in your comparison specs, if you can dig 'em up. I'd bet a few bucks that a dual Opteron(2.0Ghz-2.4Ghz) would smoke a Dual Xeon-MP of any current speed. I've never put them side by side with exactly the same peripheral hardware. A Xeon is basically just a Pentium on steroids. Have you looked at the Opteron whitepaper and architecture specs? The potential bandwidth those things have, as n-way configs, is totally awesome. I'm sure even a single 100 series, on a dual-board, will smoke a single Xeon. Check out the 800 series - if you've got a bottomless wallet, you can run an 8-way Opteron. *drool* You can probably imagine what the Sun engineers reaction to that was! He wasn't very complimentary about IBM. Interestingly Solaris 10 is supposed to be able to run any Linux application. Hrm.. I find that hard to believe. ANY Linux binary? Glen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] PH Phantom process IDs
Yeh, we get loads of those when we restart. Seems a strange way of making the record ID's unique and is worrying when you first see it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 February 2005 07:21 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] PH Phantom process IDs Just wondering if anyone else has come across weird PH entries when they start multiple phantoms off? After the normal: RUN_61985_13557 the following entries are like: SVO`72:86_13557 RUN`72:85_13557 RUO`72:85_13557 RVO`72:85_13557 etc I can see that the phantom process is incrementing the id parts but without a standard separator (_) it seems more difficult to successfully purge the file by date than it needs to be. -- Regards, Stuart Boydell ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10
What I meant was it won't run as a supported platform. I spoke to IBM last week and they said they only support Solaris on a SPARC. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: 10 February 2005 23:54 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 It will as a 32-bit application. You can run a single Opteron on a dual-board and you still get the benefit of 64-bit hardware. I have Win2K Pro running on that setup right now serving huge files. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: Thursday, February 10, 2005 5:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 Yes (v490). Problem is that Universe is compiled against Solaris 7 so you get absolutely no benefit of later versions. Also as far as I know Universe does not run on Opteron. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Ivanick Sent: 10 February 2005 21:04 To: u2-users@listserver.u2ug.org Subject: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 Hola all - We've suddenly had some resources freed up from another project and are looking to rapidly replace the 12-14 year old SGI Challenge Ls (which, truly, are still performing magnificently in most respects) we have our UniVerse 9.6 installation on. We've so far primarily tested on U2 10.1.x running on redHat AS 3.2 and we're starting to get quotes for hardware, and we've concentrated on x86 so far; the Sun guys came by today pitched a very nice price for 4 way Opteron based 40Zs, but they also made a fairly strong case for the virtualization/compartmentalization features of Solaris 10. I know it's kind of early yet, but has anyone tried running U2 in these containers? I'm fascinated by the idea (as we could dual-purpose the box and not have to worry so much about our high-availability needs), but it will take a while before I can actually get to trying it out on the SunBlade 100 here, so I'm interested if anyone's tried this, perhaps from the Solaris 10 betas. Thanks very much for any input. -- Peter Ivanick Sr. Programmer/Analyst School of Veterinary Medicine, University of Pennsylvania Email: [EMAIL PROTECTED] Phone: 215.573.2306Fax: 215.573.8777 http://www.vet.upenn.edu/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Windows 2003 password
That should only work if your users have administrator rights.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Gouws Sent: 11 February 2005 05:25 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Windows 2003 password Thanks everybody. It worked - DOS /C NET USER user_id new_password Louie -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 11 February 2005 03:19 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Windows 2003 password Try this from the UV command prompt. You may need to qualify the domain if you are using domain based security. DOS /C NET USER user_id new_passwd [/domain] See C:\NET HELP USER for all the other net user options -Original Message- I want to change the Windows 2003 password via my UV application (thru Telnet). Is it possible? ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (61 3 9269 7555) immediately who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer viruses. ** --- 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/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10
We've been through a very similar exercise recently (as you've probably guessed) and we came down to using IBMx445 servers with RHEL AS 3. As the clock speed of the SPARC is relatively low compared to a Xeon MP we found that combination outperformed the Sun (and was a lot cheaper once a large disk array was added in). There was nothing that Sun could do to improve the performance due to Universe being compiled against a very old solaris (7) version. You can probably imagine what the Sun engineers reaction to that was! He wasn't very complimentary about IBM. Interestingly Solaris 10 is supposed to be able to run any Linux application. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Ivanick Sent: 11 February 2005 12:34 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 Right, the two would be separate, either we'd be running Linux on Xeons or Opterons, or we'd be running Solaris on Sparc, not Solaris on Opteron or Intel. I've got the Solaris 10 CDs down and will try to do an install on a SunBlade we have here, with any luck I can get a copy of the U2 Solaris binaries from IBM in relatively short order to test this out, at least in a proof of concept stage. Adrian Matthews wrote: What I meant was it won't run as a supported platform. I spoke to IBM last week and they said they only support Solaris on a SPARC. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: 10 February 2005 23:54 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 It will as a 32-bit application. You can run a single Opteron on a dual-board and you still get the benefit of 64-bit hardware. I have Win2K Pro running on that setup right now serving huge files. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: Thursday, February 10, 2005 5:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 Yes (v490). Problem is that Universe is compiled against Solaris 7 so you get absolutely no benefit of later versions. Also as far as I know Universe does not run on Opteron. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Ivanick Sent: 10 February 2005 21:04 To: u2-users@listserver.u2ug.org Subject: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 Hola all - We've suddenly had some resources freed up from another project and are looking to rapidly replace the 12-14 year old SGI Challenge Ls (which, truly, are still performing magnificently in most respects) we have our UniVerse 9.6 installation on. We've so far primarily tested on U2 10.1.x running on redHat AS 3.2 and we're starting to get quotes for hardware, and we've concentrated on x86 so far; the Sun guys came by today pitched a very nice price for 4 way Opteron based 40Zs, but they also made a fairly strong case for the virtualization/compartmentalization features of Solaris 10. I know it's kind of early yet, but has anyone tried running U2 in these containers? I'm fascinated by the idea (as we could dual-purpose the box and not have to worry so much about our high-availability needs), but it will take a while before I can actually get to trying it out on the SunBlade 100 here, so I'm interested if anyone's tried this, perhaps from the Solaris 10 betas. Thanks very much for any input. -- Peter Ivanick Sr. Programmer/Analyst School of Veterinary Medicine, University of Pennsylvania Email: [EMAIL PROTECTED] Phone: 215.573.2306Fax: 215.573.8777 http://www.vet.upenn.edu/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- 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/ The information contained in this email
RE: [U2] [UV] Windows 2003 password
When the passwords on our domain expire the next time the user logs in they have to use the new password. Are you letting your users stayed logged-on for days? Universe won't look at the password again until it needs it to access a resource or start a session. We autologout our users after 59 minutes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Louie Gouws Sent: 10 February 2005 12:59 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Windows 2003 password Hi All, Universe 10.0.4 Windows 2003 Server I want to change the Windows 2003 password via my UV application (thru Telnet). The application is totally dependant on the Windows user + password for security, and I want the users to change their own passwords say every 30 days. Is it possible? Note: If the Windows 2003 password setup says every 30 days you must change our password - you can work for longer thru UV + telnet, without Windows 2003 forcing you to change your password. Is this a short-coming of UV ? Louie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10
Yes (v490). Problem is that Universe is compiled against Solaris 7 so you get absolutely no benefit of later versions. Also as far as I know Universe does not run on Opteron. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Ivanick Sent: 10 February 2005 21:04 To: u2-users@listserver.u2ug.org Subject: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 Hola all - We've suddenly had some resources freed up from another project and are looking to rapidly replace the 12-14 year old SGI Challenge Ls (which, truly, are still performing magnificently in most respects) we have our UniVerse 9.6 installation on. We've so far primarily tested on U2 10.1.x running on redHat AS 3.2 and we're starting to get quotes for hardware, and we've concentrated on x86 so far; the Sun guys came by today pitched a very nice price for 4 way Opteron based 40Zs, but they also made a fairly strong case for the virtualization/compartmentalization features of Solaris 10. I know it's kind of early yet, but has anyone tried running U2 in these containers? I'm fascinated by the idea (as we could dual-purpose the box and not have to worry so much about our high-availability needs), but it will take a while before I can actually get to trying it out on the SunBlade 100 here, so I'm interested if anyone's tried this, perhaps from the Solaris 10 betas. Thanks very much for any input. -- Peter Ivanick Sr. Programmer/Analyst School of Veterinary Medicine, University of Pennsylvania Email: [EMAIL PROTECTED] Phone: 215.573.2306Fax: 215.573.8777 http://www.vet.upenn.edu/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate Editor question
Try putting a blank line at the end. Sounds daft but we have the same problem and that fixes it for us. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Plummer Sent: 08 February 2005 17:22 To: u2-users@listserver.u2ug.org Subject: [U2] wIntegrate Editor question We recently switched out Unidata server from Tru64 Unix to Solaris. Since the switch we have a peculiar thing happening when using the wIntegrate Editor. It works normally if you are modifying a paragraph that already exists but gives an error if you write a new paragraph and try to upload it. I have checked Unix permissions and there is write access to the file. Anyone seen this one before? Tim Plummer, MBA Director of Administrative Computing Grand Canyon University --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe to Web interface
Works fine for me. Are you sure you don't have anything in the LOGIN of the account that might be kicking a non-telnet session out? Try doing this. C:\ibm\uv\bin\uvsh LIST VOC output.txt Output.txt should contain a listing of your VOC file. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 February 2005 02:49 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe to Web interface Vance wrote: @REM Assuming this is a folder with a uv account @cd \ibm\uv @REM Execute the uv command @c:\ibm\uv\bin\uvsh LIST VOC I don't know what the @ signs do, but when I try this fromthe DOS command prompt window c:\something\uvsh LIST VOC it just kinda blinks and returns to the DOS Command Prompt window. I don't see any kind of output. I don't know why. Where did my output go? Thanks Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe to Web interface
How would you pass a socket handle to a new process though? I can see ways of doing it by calling subroutines, but how for a completely new process? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 10 February 2005 00:35 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe to Web interface Glen, I have'nt done extensive research on it, but from the samples provided by IBM using a dimensioned array, I believe UV would manage the forking off the sockets itself. Don't quote me on this though. I'll dig out the sample I have and send it on to ya... If you want you can test it out on my system and play since you don't have access to a UV box. For you no problem. Vance - Original Message - From: Glen B [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 09, 2005 5:21 PM Subject: RE: [U2] Universe to Web interface Kevin, I read through the PDF. However, it is not clear on how the handles can be used. A lot of the API's I've seen have the same level of functionality, but they all lack the ability to pass handles from the acceptor process to a totally separate user process. This isn't really an issue of the API, it's more of a user environment issue. You can pass the handle value itself, but the other process loses the 'meaning' of the handle and it just becomes a worthless string. An example would be launching a new phantom and passing it the handle variable, after accepting an incoming connection. The same situation occurs when you pass any kind of memory reference(or offset) to anything outside the current user heap. Unix fork()ing generates a mapped/duplicate user heap, so all file/handle references still work properly without having to munge underlying memory addresses. If you can truly pass a UV socket handle to another UV process, then there's no reason why anyone can't write a stable multi-threaded socket server directly in UV BASIC. Is this true? If so, I want a developer copy so I can try to blow it up. :P eg -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin P Lynch Sent: Wednesday, February 09, 2005 3:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface you manage the connections from basic, the whole interface is a set of basic extensions. basically you open a socket on a port , accept a connection on that socket and write to the socket. here is the appropriate manual : http://publibfi.boulder.ibm.com/epubs/pdf/25119080.pdf -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: Wednesday, February 09, 2005 2:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Must be nice. I wish that capacity existed in every flavor. It would make the integration world a breeze. Well my real question would be; is the service external or internal? I'd be interested in knowing how the socket service is laid out. Do you have to manage connections yourself? How are socket handles passed to children under multiple listening conditions? Or, do you tell the UV service to listen 4-at-a-time, on port , and then call MYAPP when a connection is accepted? -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin P Lynch Sent: Wednesday, February 09, 2005 1:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Glen, The UV socket server interface works the same in Unix and Windows, I have server programs running in both environments with no changes. Kevin Lynch The Systems House -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: Wednesday, February 09, 2005 12:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Stewart, Socket implementations don't work across flavors. I've written many socket apps for D3, but even the small differences in the socket designs between Win and *nix causes problems. Sockets are easy to implement, but only if you want to maintain separate code-sets for Win and *nix under each flavor you want to support. I won't get into the details here, since I'm not familiar with the UV socket API. Service sockets are meant for the O/S, not Pick. Doug Dumitru bit the bullet and wrote his own TCP stack in Pick ASM. That is about the only way I would recommend even contemplating Pick server sockets. For clients, the socket APIs are fine. The calls are nearly identical between Win and *nix. The only issue there is blocking control, which unfortunately most of MV socket developers are unknowledgeable of. OK...I'm not going to get into that... meditating The SELECT can be handled several ways, but it
RE: [U2] Unidebugger
And also make them work for replicated files as well -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Simon Lewington Sent: 02 February 2005 13:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidebugger Susan Joslyn wrote... You're right, triggers cannot be used on directory type files. We did ask IBM for that at the U2UG meeting in Las Vegas last September. Their chief argument against them was that you can get to those directory files from outside U2 anyway. I would imagine that that's more of a sales-and-marketing argument. There's also the engineering problem of directory files having no header block to store the trigger definition in. I hope that IBM is listening -- and if anyone agrees with me that triggers are critical in today's IT, please put your two cents in. (For all file types, with an efficiency that makes them usable.) But I agree wholeheartedly with this - consider my two cents added. Simon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidebugger
There are other ways of accessing with Unidebugger apart from UniObjects. FTP, shares etc. These methods do not respect Universe record locks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon J Glorfield Sent: 01 February 2005 14:00 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidebugger Now I'm confused. You are now the second person to claim that the UniDebugger doesn't use locking when it reads/writes host Basic programs. This is definitely not the case here. We use the UniObjects connect method and it does use and honor record locks. I was hoping that someone could suggest a method utilizing triggers or something to get it to honor our check-in/check-out database. I'm not really interested in investigating alternatives to UniDebugger. I just want to explore making it work. Perhaps I need to look at the read/write permissions, as hinted at earlier, as a possible solution. Cheers, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 02/01/2005 07:40:55 AM: The UniDebugger doesn't use locking when it reads/writes host Basic programs as this would not fit the home-grown check-in/out systems many people use. In the wIntegrate Editor we added the ability to call a custom subroutine at the usual points which give 100% control, in the same way as the service subroutine which is optionally called by the Query Builder to filter what the users sees and does. However today the UniDebugger does not support custom host subroutines. -Original Message- From: Gordon J Glorfield [mailto:[EMAIL PROTECTED] Sent: 31 January 2005 21:13 To: u2-users@listserver.u2ug.org Subject: [U2] Unidebugger Speaking of the Unidebugger and Sarbaines/Oxley, we are having some issues here with them. Currently our green-screen editors are front-ended by a subroutine that checks a database to make sure you have the program checked out. If you don't have it checked out the editors die with an error message alluding to a security violation. Unidebugger does not honor the checked out status of programs in our library. Is there a way to add this check to Unidebugger? Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.3 - Release Date: 31/01/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidebugger
We use EditPlus with SourceSafe which works well as no-one can change a program from within Universe or without unless it's been checked out first. We developed an add-in (as have others) to make the links to SourceSafe an integral part of EditPlus so checking status, checking in/out, promoting to test/pre-prod/prod is all done via a menu/single keystroke. Before we started using EditPlus we used the command line facilities of SourceSafe to link into the Universe shell. Of course, maintaining version control over dictionaries and property records is a bit trickier as SourceSafe will only work for type 1/19. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: 02 February 2005 03:36 To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: RE: [U2] Unidebugger We're using the word 'locking' in two different ways, here. Lock as in 'read lock' is indeed done by the unidebugger. Locking as in -- calling a host subroutine to validate the available status in a source library system (such as PRC (hah! You knew I'd plug!) is something that the Unieditor (with Wintegrate, but not Dynamic Connect) can do, but the Unidebugger (presently) cannot. Everyone whine and beg and maybe they can put that in for us. In the meantime, Gordon, I would think that you could address it with file triggers... any reason why you can't? Susan From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gordon J Glorfield Sent: 01 February 2005 14:00 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidebugger Now I'm confused. You are now the second person to claim that the UniDebugger doesn't use locking when it reads/writes host Basic programs. This is definitely not the case here. We use the UniObjects connect method and it does use and honor record locks. I was hoping that someone could suggest a method utilizing triggers or something to get it to honor our check-in/check-out database. I'm not really interested in investigating alternatives to UniDebugger. I just want to explore making it work. Perhaps I need to look at the read/write permissions, as hinted at earlier, as a possible solution. Cheers, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 02/01/2005 07:40:55 AM: The UniDebugger doesn't use locking when it reads/writes host Basic programs as this would not fit the home-grown check-in/out systems many people use. In the wIntegrate Editor we added the ability to call a custom subroutine at the usual points which give 100% control, in the same way as the service subroutine which is optionally called by the Query Builder to filter what the users sees and does. However today the UniDebugger does not support custom host subroutines. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Resize problems
Don't try it on a large system though. It takes for ever to traverse all the open handles and hogs a whole cpu while doing it. Very useful for SMB though. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gyle Iverson Sent: 28 January 2005 22:42 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Resize problems Hello, Clif. Try OH.exe from Microsoft at http://www.microsoft.com/windows2000/techinfo/reskit/tools/existing/oh-o .asp . OH is great at answering the question, Who or what has this file open?. Best regards, Gyle --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Unclassified RE: [U2] [UV] Run phantom as another user
Or even adding it to the HELP PHANTOM output would be nice -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of HENDERSON MIKE, MR Sent: 30 January 2005 19:23 To: u2-users@listserver.u2ug.org Subject: RE: Unclassified RE: [U2] [UV] Run phantom as another user Thanks, LeRoy, I _knew_ I'd seen it somewhere. Pity this 10.0 improvement isn't mentioned in the 10.1 documentation. Any chance of it being in the 10.1A docco, or will we have to wait for 11.x? Or can it be at least mentioned in the 10.1 patch list / release notes for the time being? Regards Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leroy Dreyfuss Sent: Thursday, 27 January 2005 17:41 To: u2-users@listserver.u2ug.org Subject: Re: Unclassified RE: [U2] [UV] Run phantom as another user From the UV 10.0.19 patchlist file: Issue Short Description - - 3766 In order to run a phantom process as a different user, an enhancement has been made to the PHANTOM command. The syntax is as follows: PHANTOM [BRIEF] [SQUAWK] command -U username [password] When you are logged in as root, you can specify -U and the username to run the phantom process as a different user. On Windows platforms, you must also specify the password for the username. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM DB2 Information Management Software Tel: 303-672-1254 Fax: 303-294-4832 Mobile: 720-341-4317 Tie-line: 770-1254 External email: [EMAIL PROTECTED] The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData Replication and File Resizing...
The replication happens at a record level so I wouldn't have thought that resizing the file would make any difference. You can, after all, replicate between different file types. We use Universe but I would think it would be pretty much the same on UD. From: [EMAIL PROTECTED] on behalf of David Wolverton Sent: Thu 27/01/2005 20:34 To: u2-users@listserver.u2ug.org Subject: [U2] UniData Replication and File Resizing... How does the subscribing machine act when you resize a published file? Just curious what we have to do, or if it is magically rezied on the subscriber as well (Which is actually logical, but seems like it would have been a lot of work for IBM to implement!!) David WOlverton --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Run phantom as another user
I can't seem to find it now but I'm sure I read in the release notes for one of the new releases that a user name can be specified at the command line when launching a phantom now. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: 25 January 2005 02:20 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Run phantom as another user Is there a way to run a phantom process as another user using the PHANTOM command? We have a situation where we have a background phantom process periodically monitoring a directory on another server. But, when the user that launched the phantom processor changes their password, the file open fails (due to expired credentials). We would like to have the phantom process 'run as' another user account that has the minimum access it needs where the password does not ever expire and create the failed open file problem. We are simply opening the file as a F voc pointer with line 2 \\server\sharename\directory. The universe config parameter ALLOWNFS is set to 1. Thanks! -Troy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe 10 fnuxi problem
Use the -notags option. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: 24 January 2005 20:13 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe 10 fnuxi problem Thanks to all who have responded. Although I am not hearing what I wanted at least I know why it's not working. My next question then becomes: how can I use uvbackup to backup the files I need without marking each record as backed up? I have some files that a couple of million records and don't want to wait through the time it takes to mark each record as backed up. Is there an option that will just do the backup without setting the flag? Thanks again, Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin P Lynch Sent: Saturday, January 22, 2005 9:37 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe 10 fnuxi problem Jay, try using uvbackup and uvrestore to move the files, it handles the conversions itself, it usually works like a charm. if they are on very different universe releases you may need to back them up using the release options (check the doc on the release options for uvbackup, it's fairly clear) Kevin Lynch -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: Friday, January 21, 2005 6:53 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10 fnuxi problem I need to move some regular Universe files from a Unix platform (HPUX) to Windows. These files have triggers and fnuxi by itself will not work. I've tried FORMAT.CONV -export on the HPUX box but it indicates the file is not a SQL table. If I just ftp the file to my Windows platform and try fnuxi -convert it reports the file already exists. I have tried following the instructions in migrating from one schema to another but it doesn't appear to work for regular Universe files. Can anyone shed some light on how I can get these files moved over without creating new files and copying the data into them and then copying? Thanks in advance, Jay Jay Falck, CISSP, CHSS MHC Specialist Verilet, Inc 858-617-6324 512-301-2583 512-563-4132 (cell) THIS MESSAGE, TOGETHER WITH ANY ATTACHMENTS, IS INTENDED ONLY FOR THE USE OF THOSE TO WHOM IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED RECIPIENT, EMPLOYEE OR AGENT RESPONSIBLE FOR DELIVERING THE MESSAGE, YOU ARE HEREBY NOTIFIED THAT ANY DISSEMINATION, DISTRIBUTION, OR COPYING OF THIS TRANSMISSION IS STRICTLY PROHIBITED. IF YOU RECEIVED THIS MESSAGE IN ERROR, PLEASE NOTIFY THE ORIGINAL SENDER IMMEDIATELY BY TELEPHONE OR E-MAIL AND DELETE THIS MESSAGE, ALONG WITH ANY ATTACHMENTS, FROM YOUR COMPUTER. THANK YOU. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the Inbound TSH Mail Filter Please Report any issues to [EMAIL PROTECTED] __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe 10 fnuxi problem
You cannot move files with triggers between platforms that require a fnuxi. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: 21 January 2005 23:53 To: u2-users@listserver.u2ug.org Subject: [U2] Universe 10 fnuxi problem I need to move some regular Universe files from a Unix platform (HPUX) to Windows. These files have triggers and fnuxi by itself will not work. I've tried FORMAT.CONV -export on the HPUX box but it indicates the file is not a SQL table. If I just ftp the file to my Windows platform and try fnuxi -convert it reports the file already exists. I have tried following the instructions in migrating from one schema to another but it doesn't appear to work for regular Universe files. Can anyone shed some light on how I can get these files moved over without creating new files and copying the data into them and then copying? Thanks in advance, Jay Jay Falck, CISSP, CHSS MHC Specialist Verilet, Inc 858-617-6324 512-301-2583 512-563-4132 (cell) THIS MESSAGE, TOGETHER WITH ANY ATTACHMENTS, IS INTENDED ONLY FOR THE USE OF THOSE TO WHOM IT IS ADDRESSED AND MAY CONTAIN INFORMATION THAT IS PRIVILEGED, CONFIDENTIAL, AND EXEMPT FROM DISCLOSURE UNDER APPLICABLE LAW. IF THE READER OF THIS MESSAGE IS NOT THE INTENDED RECIPIENT, EMPLOYEE OR AGENT RESPONSIBLE FOR DELIVERING THE MESSAGE, YOU ARE HEREBY NOTIFIED THAT ANY DISSEMINATION, DISTRIBUTION, OR COPYING OF THIS TRANSMISSION IS STRICTLY PROHIBITED. IF YOU RECEIVED THIS MESSAGE IN ERROR, PLEASE NOTIFY THE ORIGINAL SENDER IMMEDIATELY BY TELEPHONE OR E-MAIL AND DELETE THIS MESSAGE, ALONG WITH ANY ATTACHMENTS, FROM YOUR COMPUTER. THANK YOU. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Error with PAGE statement.
That's the default setting and I'd say is far too low for most systems (ours is currently 750). As a first rough setting you need to work out how many files the average session will have open and set MFILES to that (look at T30FILES as well if you have dynamic files). Search on www.indexinfocus.com to see previous postings regarding this. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carolina Lizama Sent: 21 January 2005 12:03 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - Error with PAGE statement. It's set to 12. From: Adrian Matthews [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - Error with PAGE statement. Date: Fri, 21 Jan 2005 10:55:43 - What is your MFILES set to? The last time this problem came up on the forum the general consensus was that the MFILES was set far too low. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carolina Lizama Sent: 21 January 2005 10:07 To: u2-users@listserver.u2ug.org Subject: [U2] UV - Error with PAGE statement. I have the following error when running a Program on UV 9.6 / AIX 5.1 Program PRINT.CLI.DET: Line 322, Read operation failure. [EBADF] Bad file number A fatal error has occurred in UniVerse. Unable to re-open operating system file TEMP/PRINT.CLI.DET Error code 0 On line line 322, I have the PAGE statement. The PAGE statement is inside the PRINTER ON and OFF, and instead of directly printing to a Printer, I am diverting the output to TEMP which is a Type 19 file. One page of data is printed and when it tries to print the next page, the above-mentioned error appears. I have tried RESIZING the file to 1, back to 19. Deleted the File completely and created a new file. But still no luck! Carol. _ FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/ --- 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: Select statement problem
Are the DATE.FORMAT settings the same on both machines? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Schalk van Zyl Sent: 13 January 2005 07:13 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV: Select statement problem Any active Index? Indices up to date on both boxes? Schalk van Zyl On Wed, 12 Jan 2005 13:45:13 -0500, Dianne Ackerman [EMAIL PROTECTED] wrote: Is it possible that the UV accounts you're running on are different flavors? SELECTs in different flavors definitely work differently. -Dianne [EMAIL PROTECTED] wrote: I have come across a problem with select statements behaving differently between my two RISC boxes. I have two RS6000 machines : one for production and the other for development. Both UV 10.0.14 and AIX 5.2 While testing a program change on the development box, I came across a situation where a SELECT statement gave me different results when compared to production. To get around this, I had to break up the SELECT statement into two parts. My question is: Is there a setting somewhere that is not in synch between production and development machines that could cause this. If so, what? Please accept the fact that the contents of the SELECT statement are good (I'd rather not explain the definitions of the dictionary items or the contents of the phrase PHRASE 0117: STATEMENT = 'SELECT DB.PSES WITH SUB.ID = ':ACTUAL.ID:' AND WITH TRANS.DT = AND WITH ISSUE.DT = ':ISSUE.DT:' AND WITH ACCOUNT # 600 AND WITH ACCOUNT # 506 AND WITH @ID UNLIKE DEL... ':PHRASE 0118: STATEMENT:[EMAIL PROTECTED]:SAVE.LIST PSES.TAPE.:ISSUE.DT:.:SUB.ID 0119: EXECUTE STATEMENT 0 record(s) selected to SELECT list #0. 0 record(s) SAVEd to SELECT list PSES.TAPE.03/31/02.M. This does work: 0117: STATEMENT = 'SELECT DB.PSES WITH SUB.ID = ':ACTUAL.ID:' AND WITH TRANS.DT = AND WITH ISSUE.DT = ':ISSUE.DT:'' 0118: STATEMENT:[EMAIL PROTECTED]:'SELECT DB.PSES WITH ACCOUNT # 600 AND WITH ACCOUNT # 506 AND WITH @ID UNLIKE DEL... ':PHRASE:' SELECT.ONLY' 0119: STATEMENT:[EMAIL PROTECTED]:SAVE.LIST PSES.TAPE.:ISSUE.DT:.:SUB.ID 0120: EXECUTE STATEMENT 265 record(s) selected to SELECT list #0. 265 record(s) selected to SELECT list #0. 265 record(s) SAVEd to SELECT list PSES.TAPE.03/31/02.M. On my production machine, the first statement works and yields the same results as the second statement from development Thanks Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Schalk van Zyl - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Where are the Archives Now?
Try www.indexinfocus.com From: [EMAIL PROTECTED] on behalf of David Wolverton Sent: Fri 24/12/2004 16:27 To: u2-users@listserver.u2ug.org Subject: [U2] Where are the Archives Now? I need to find some info that was presented here about a year ago -- where are the archives kept now? Used to be a link on oliver.com, but it's not linked there, and I don't see anything obvious on the U2ug.org web site... Thanks! David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Windows XP
We use a Function Key for this We tell users to, say, F12 at the login prompt... with F12 set for usually, user, password and login account... Ouch, obviously your company's auditors aren't as strict (good?) as ours. We'd get strung up for allowing that. The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] wIntegrate (on Universe) Question
Try re-intalling the wIntegrate host programs. You should not be getting problems right out of the box sounds like you might have the wrong flavour of host programs installed. Also have you checked your case invert settings as wIntegrate gets confused if pasted text gets it case changed. Especially in the WIN.SERVER routines. As a matter of interest, we don't use any of the standard programs anymore, as they are so generic they perform quite badly. For instance our grid load program is well over a 100 times faster than the standard method for over 50 rows. From: [EMAIL PROTECTED] on behalf of Anthony Dzikiewicz Sent: Thu 16/12/2004 15:27 To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate (on Universe) Question I gave that a try and here are the results; 17. RECEIVING CALENDAR 18. RECEIVING CALENDAR SMITHFIELD 19. START WINTEGRATE Which would you like? ( 1 - 19 ) ?19 Enter ? for help wIntegrate Command SCRIPT 'QUERY\QUERY.WIS' wIntegrate Command IS' Press any key to return to the menu... By the way the WIN.COMLINE compiles with warnings right 'out of the box' - missing final end statement. I applied the changes as you suggested and it didn't compile at all. So, I just did this; 0159: 3000 IF CMND = WIN.SERVER THEN 0160: CALL @EXECSUB(WIN.SERVER,'','') 0161: END ELSE Just to make it easy to check it out. No such luck Thanks Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ian Renfrew Sent: Wednesday, December 15, 2004 2:55 PM To: [EMAIL PROTECTED] Subject: RE: [U2] wIntegrate (on Universe) Question You can try this: Create a test program and insert the following three lines: DATA SCRIPT 'QUERY\QUERY.WIS': @AM EXECUTE WIN.COMLINE STOP Compile and catalog test program. Modify program WIN.COMLINE (usually found in WIN.PROGS file). Locate and modify the lines: * Run a script * At this point, we are assuming that the user input was either a * script statement, such as: Set Title This is a window title * a script ID, as held in the file WIN.SCRIPT. * or WIN.TRANSFER sent from the PC as a file transfer has been run. * 3000 IF CMND = WIN.TRANSFER THEN CALL @EXECSUB(WIN.TRANSFER,'','') END ELSE IF SCRIPT.FILE AND LEN(CMND) 100 THEN READ DUM FROM F.SCRIPT, CMND THEN ;* Did the user enter a script ID? CMND = DUM ;* Yes and its now in variable CMND END END * IF COUNT(CMND,AM) THEN CALL WIN.HSCRIPTC(CMND) END ELSE CALL WIN.COMSUB(CMND) END * END RETURN * Run a script * At this point, we are assuming that the user input was either a * script statement, such as: Set Title This is a window title * a script ID, as held in the file WIN.SCRIPT. * or WIN.TRANSFER sent from the PC as a file transfer has been run. * 3000 IF CMND = WIN.TRANSFER THEN CALL @EXECSUB(WIN.TRANSFER,'','') END ELSE IF CMND = WIN.SERVER THEN CALL @EXECSUB(WIN.SERVER,'','') END ELSE IF SCRIPT.FILE AND LEN(CMND) 100 THEN READ DUM FROM F.SCRIPT, CMND THEN ;* Did the user enter a script ID? CMND = DUM ;* Yes and its now in variable CMND END END * IF COUNT(CMND,AM) THEN CALL WIN.HSCRIPTC(CMND) END ELSE CALL WIN.COMSUB(CMND) END * END END RETURN Essentially you're adding the ability to call the routine WIN.SERVER. From your menu, you should be able to execute the test program. Regards, Ian Renfrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Dzikiewicz Sent: Wednesday, December 15, 2004 12:06 PM To: [EMAIL PROTECTED] Subject: [U2] wIntegrate (on Universe) Question I forget if there is a separate group for this product. If so, sorry. However, my problem is this; I am evaluating the wIntegrate product. One of the uses that we have for this is the query builder/report viewer. We have a person who used to tinker at the command line. We have long since pulled the plug on this kind of thing, because they did some 'bad things'. However, it is nice to let them have the ability to query the data (after all it is theirs). So, it seems wIntegrate can do this for us. My problem is that you need to be at a command line to allow wIntegrate to operate. So, we're back to square one - user at the command line. Our system is based on standard Universe menus. Is there a way to add a menu option (or create a VOC) that will allow the user to 'mess' with query builder, etc ? I have tried adding WIN.SERVER as a menu option. However, this half works. I created a simple query and tried to put it to the report writer and it times out, because the WIN.SERVER closes. If I send it to the screen, it works ok. Any workarounds to this ? Anthony --- u2-users mailing list [EMAIL PROTECTED] To
RE: [U2] [UV / UNIX] - Automatically retrieving Exchange Rate from the Internet
We source ours directly from Reuters but that is likely to be a bit expensive for your needs. www.xe.com provides a free daily email of currency exchange rates, you could write an app to load that or parse it from their web-site. As long as you don't redistribute the data you should be legal as far as I can tell from their website, but you should check with them first. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Farrant Sent: 13 December 2004 12:37 To: [EMAIL PROTECTED] Subject: [U2] [UV / UNIX] - Automatically retrieving Exchange Rate from the Internet All, I have HP-UX B.11.11 and Universe 9.6.1.6 I need to update my app. with live (daily) currency exchange rate information. I used to do this by extracting information from a text base file posted to the internet by the IMF but it appears that they have now stopped doing this?? It struck me at the time that this was a little precarious in any case. Is there a proper / accepted way to do this? Thanks in advance... Mike Farrant --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: Unclassified RE: [U2] UniVerse Backup/Resizing Questions
From: [EMAIL PROTECTED] on behalf of HENDERSON MIKE, MR Sent: Fri 10/12/2004 20:35 To: [EMAIL PROTECTED] Subject: Unclassified RE: [U2] UniVerse Backup/Resizing Questions We keep our Production databases on mirror sets*. To backup, we quiesce the system, break the mirror, then start running again (total time ~2 minutes). Now backup from the 'broken' half of the mirror (use anything you like, no files are open), then re-sync the mirror sets. If you can't even afford a couple of minutes outage, then I think I'd do it like this: SUSPEND.FILES ON, mirror split, SUSPEND.FILES OFF, backup from the 'broken' half of the mirror using uvbackup, now re-sync the mirror sets. And you really need to be using transactions in this scenario, otherwise you risk not being able to restore to a consistent state. HTH Mike * Actually, they're on an EMC array with a three-way mirror, so when we do a mirror-split, we've still got a mirrored pair set of disks for our production data and no one-disk failure vulnerability. Disks are REALLY CHEAP these days! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Saturday, 11 December 2004 07:18 To: [EMAIL PROTECTED] Subject: RE: [U2] UniVerse Backup/Resizing Questions Yet the problem with NT backup, or any non-universe oriented utility, that saves ACTIVE files, is that it/they have no universe concurrency control; you run a great risk of saving corrupted (pointers in transition) images of files, UNLESS you make certain no users are WRITING (updating). That was the reason I was tasked with writing uvbackup/ uvrestore back in '91: to create a utility that mimicked cpio (albeit loosely) that understood the universe file structure and implemented concurrency control. I spent many long nights fixing broken customer files because of exactly this... -Original Message- From: Anthony Caufield [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 12:38 PM To: [EMAIL PROTECTED] Subject: RE: [U2] UniVerse Backup/Resizing Questions I have found that uvbackup is not the answer NT backup works but is not very good on compression. No matter what you use I highly recommend St Bernard's Open File Manager it makes sure you can backup all files. Tony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Schexnayder Sent: Friday, December 10, 2004 9:13 AM To: [EMAIL PROTECTED] Subject: [U2] UniVerse Backup/Resizing Questions Hello, We are rolling out our product on UniVerse 10.1/NT, currently we are running on D3, and we have a couple UniVerse questions. 1) Resizing. When we asked IBM about resizing, their answer was FAST. However, I am not impressed with the product nor the expense, are there any alternatives? 2) Backups. I read another thread where the user indicated that they used UVBackup to create a file, and then the O/S backed up that file. Is that the general consensus? Others I have spoken with have indicated that they use only an O/S backup. In that case, what about locks and users on the system? Is there a best way to do backups? Thanks so much for your help, Dave Schexnayder Cheetah Advanced Technologies, Inc. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please
RE: [U2] UniVerse Backup/Resizing Questions
Wouldn't it be nice to be in a 9-5 environment again, I remember those days! 5 and 9 meaning something different to us these days; 99.999% uptime, which equates to 5 minutes downtime a year. Before we started using replication we use to do a UVBackup to a disk that was then moved to a NAS server to keep a months worth of disk images on-line. This happened every hour on the hour. Obviously we could never be sure of the referential integrity of the database but we have programs that report on missing transactions etc and I can't remember the last time we had to use a backup anyway (apart from testing them every two days). From: [EMAIL PROTECTED] on behalf of John Hester Sent: Fri 10/12/2004 23:18 To: [EMAIL PROTECTED] Subject: Re: [U2] UniVerse Backup/Resizing Questions Dave Schexnayder wrote: 2) Backups. I read another thread where the user indicated that they used UVBackup to create a file, and then the O/S backed up that file. Is that the general consensus? Others I have spoken with have indicated that they use only an O/S backup. In that case, what about locks and users on the system? Is there a best way to do backups? I've only done OS level backups, so I can't objectively compare them to uvbackup, but this has worked fine for us since migrating to UV in '96. We do frequent restores of various archived files for accounting report requests. Fortunately we're a 9-5 operation, so I have a window at the end of the day where I can be sure no updates are happening on the filesystem. If you can't prevent writes during your backup, and you don't have a mirrored filesystem you can break apart, there are a number of backup solutions that can handle open files. St. Bernard and Unitrends Backup Professional are a couple. St. Bernard works in conjunction with the backup software of your choice, and Backup Professional has built-in open file management. It's my understanding that all files are saved in a consistent state by monitoring the filesystem at the OS level and caching any disk writes until the particular file is backed up. This gives you a backup of your filesystem as it was at a specific point in time. Of course you still have to start your backup at a point in time when no transactions are in mid-stream if you want to be able to restore everyting to a consistent state. -John -- John Hester System Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Do we need to put a value in UniObject SubKeys
There is no way to get wIntegrate to share the device license key that is used by another UniObjects application. I recently raised this with IBM and they confirmed that it is not possible so if you have a client PC running a Uniobjects program and a wInegrate session then they are going to consume 2 normal licenses but you will be able to get 20 device sessions (10 each). From: [EMAIL PROTECTED] on behalf of David Jordan Sent: Thu 09/12/2004 20:19 To: [EMAIL PROTECTED] Subject: RE: [U2] Do we need to put a value in UniObject SubKeys I have been investigating this further, whether we need to actually apply a value to subkey in a uniobject client as the IBM documentation explains what it is, but does not say that anything should be done. My concern is, if we feed a value into subkey that this would then be different to the ODBC and wintegrate/dynamic connect subkeys, how does this then allow the server to recognise that these calls all came from the same desktop. I ran a test with a VB program without entering a subkey value and then ran it multiple times from the desktop. Running uvlictool this multiple sessions but they only used one licensed seat which is correct. I then ran dynamic connect and a session of the VB program and again uvlictool showed multiple sessions that only took one licensed seat. However when I ran dynamic connect and multiple VB sessions, the uvlictool showed 2 seats was consumed. The curly was that the last line said only one seat was used. (This may be to do with a bug in the uvlictool that is supposed to be fixed in the latest release) Packages in use: UVCS 2 license seats are in use. 3 license seats are available. Packages in use: UVCS has 5 licensed seats and 1 in use. At the moment I assume we do not need to enter a subkey value. Can anyone else confirm this? Regards David Jordan --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject SubKeys
The subkey only works if you are connecting to a Universe server that is running device licensing rather than server licensing. The subkey needs to be the same for each ten sessions otherwise each one will be treated as an individual session. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of UmFooFoo Murphy Sent: 07 December 2004 21:38 To: [EMAIL PROTECTED] Subject: [U2] UniObject SubKeys Hello All, I have an application that needs to be able to connect multiple times to a Universe Session. When I run this application on my local PC I am unable to connect to my local Universe while the application is running. Likewise, I am unable to run the application while connected to a local Universe session. I was told to use SubKeys to solve this problem and even though I read and obeyed the blurb about SubKeys in the UniObjects documentation, it still does not work. I have a TheSubKey as Long variable that I increment each time I connect to UniObjects, like this: TheSubKey = TheSubKey + 1: ObjSession.SubKey = Str(TheSubKey) ObjSession.Connect I used the Str() because results from a google search suggested that the subkey needs to be a string value. I have also tried it without using the Str() like this: TheSubKey = TheSubKey + 1: ObjSession.SubKey = TheSubKey ObjSession.Connect Can anyone point me in the right direction please? thanks --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UD] How to access a particular ID in a select list
Take off the FIRST.SELECTED.ID from the DELETE line. Add a DATA Y before the REPEAT and it should do what you want. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chauhan, Savita Sent: 08 December 2004 14:54 To: [EMAIL PROTECTED] Subject: [U2][UD] How to access a particular ID in a select list Hi, Is there a way to access a particular ID in a select list? I want to write a para to do the following: Select a file with certain Ids and delete these selected records. I was thinking of writing something like the following (to delete all the records whose ID is greater than 5, say), but don't know what to replace FIRST.SELECTED.ID with in the following: LOOP SELECT XCF.SAV.TEST WITH @ID 5 IF @SYSTEM.RETURN.CODE = 0 THEN GO DONE DELETE XCF.SAV.TEST FIRST.SELECTED.ID REPEAT DONE: Is there a system variable that stores all the IDs in the select list? Thanks Savita. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Windows firewall and UVODBC
IF you go to Control Panel, select Windows firewall, then choose the Exceptions tab then you will be able to allow the program or unblock the port. Bit trickier if your settings are controlled from the domain though -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andy Moore Sent: 07 December 2004 12:33 To: [EMAIL PROTECTED] Subject: [U2] Windows firewall and UVODBC DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. Hello, We have Universe running on Windows with the Windows firewall installed, but the firewall is stopping access to the UVODBC. Normally I can configure firewalls to let the UVODBC through, but the Windows one is not one that I am familiar with. Has anyone got any experience with this and if so do you have the settings required or any advice? Thanks Andy Moore Selima Software Ltd Tel: 0114 2815000 Fax: 0114 281 email: [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe on Windows - How to determine inode
This builds a file that contains cross references inodes and works fine on Windows. You could obviously modify it to query on a file rather than building an xref file but I use this file to drive a modified list.readu that shows real file names rather than inodes. 0001: OPEN 'INODE.XREF' TO INODE.XREF ELSE STOP 'OE INODE.XREF' 0002: PERFORM 'SELECTF TO 1' 0003: LOOP 0004: READNEXT FILE.NAME FROM 1 ELSE EXIT 0005: CRT FILE.NAME 0006: OPEN FILE.NAME TO F.FILE THEN 0007: STATUS STAT.ARR FROM F.FILE THEN 0008:WRITE STAT.ARR27 ON INODE.XREF,STAT.ARR10 0009: END 0010: END 0011: CLOSE F.FILE 0012: NAP 1 0013: REPEAT -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: 06 December 2004 07:27 To: [EMAIL PROTECTED] Subject: Re: [U2] Universe on Windows - How to determine inode Try find . -inum nn -print after cd-ing to the mount place of the file system where the file is ( or above it ). If You have no clue use '/' but it will quite some time. nn should be the inode You're searching for. This should work for solaris at least. HTH -- mats [EMAIL PROTECTED] wrote: I have a client who is running Universe 10 on Windows. If I know a file name, I can determine the inode fairly quickly. However, what if I know the inode but do NOT know the filename? How can I determine the filename from knowing the inode only? Thanks Will Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV/NT resize failed - any way to put this file back together?
If you kill a telnet session that is running a resize on NT then you need to kill the resize.exe process that it spawned as well. Otherwise it just keeps on going as you found it. There are quite a few processes on the NT version that work like that. From: [EMAIL PROTECTED] on behalf of Joe Walter Sent: Mon 06/12/2004 18:22 To: [EMAIL PROTECTED] Subject: RE: [U2] UV/NT resize failed - any way to put this file back together? unbelievable - i just felt i had to post a follow up to this. the resize process that we thought was dead and we closed the telnet client that initiated the session and all - gave up on it - thought it was a dead process. we would have expected it to run in less than 1/2 hour. well, anyway, low and behold when I got back onto that customers system today to start restoring files - it turns out that the resize actually finished up and the date/time stamp makes it appear as if the resize ran for about 30+ hours - but the point is it did actually finish - even after we killed the telnet client that started the session - unbelievable. the mystery still is - why did it take so long. yes, the new file sizing parameters where dead on and the old file size wasn't all that far off either. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Joe Walter Sent: Thursday, December 02, 2004 11:25 AM To: [EMAIL PROTECTED] Subject: [U2] UV/NT resize failed - any way to put this file back together? was trying to resize a file on universe/NT and the process obviously got hosed up. it ran for upwards of three hours before we gave up on it. it is one of those blasted files with multiple data sections. so, we have the files AR and AR,HIST i was trying to resize AR,HIST. active users where accessing only the AR file itself, so i thought i could get by with resizing AR,HIST while others where online. it looks like it started to work, but should have completed in a matter of minutes based on past experience, so it did get hung up for some reason. if i display the files in the directory - i see the following: 11/30/04 03:10pDIR . 11/30/04 03:10pDIR .. 11/30/04 03:05p 2,569,728 AR 11/30/04 03:05p 5,343,232 HIST 11/30/04 03:10p 4,093,440 resizea00355 5 File(s) 12,006,400 bytes 619,339,264 bytes free so, it looks like *maybe* the data for the HIST section and this temp resizea00355 file might actually have the data, but when you try to access the file AR,HIST from TCL your session just locks up. can still access just the live AR file - no problem there. anyone know how to piece this thing back together without restoring from backups? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Scanner Connection
We do something similar in wIntegrate with an ActiveX control (which we wrote in VB6 using ImagXpress controls). Not sure if that's possible in Accuterm but I would expect it would be. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 01 December 2004 08:26 To: [EMAIL PROTECTED] Subject: [U2] Scanner Connection I have a client using Accuterm with telnet sessions for all the users. One user has a Bell Howell multi-page scanner that gets around 100 pages per day of work orders etc. That user's emulator is Ve-Client from Visual Pick and they want to re-write the app with Accuterm and some VB scripting if necessary. My question is where would someone go to find out how this can be done. It presently is done in VE with a 9,500 line program (4GL generated code) that has oodles of includes and gets very busy. It still doesn't do what I would like and that is for the scanner to write the scanned docs to a temp folder, I would use Accuterm to load in those filenames and offer them to the user for proper pc-filenaming to attach to the application. I would appreciate any insight on this. Thanks in advance. Mark Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Scanner Connection
We evaluated several off the shelf packages before writing our own. The main issues were that no single package had all the mandatory features that our users and regulators required. With 30 years worth of documents plus emails, PDFs, faxes etc etc most vendors ran for the hills when asked to store that amount of information. Universe doesn't even blink at it. I agree that it makes sense to buy off the shelf in most cases but it can be much cheaper in certain circumstances to do it yourself. At #600 (for the scanning ActiveX control) plus a month of my time it was a bargain as we could re-use the existing Universe device licenses. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Les Hewkin Sent: 01 December 2004 09:48 To: [EMAIL PROTECTED] Subject: RE: [U2] Scanner Connection Hi, We scan about 5000 documents a day. These are then feed into an optical system for storage. We have written apps that use these images. We would never think about trying to write a scanning app. There are so many good ones on the market, why try to reinvent the wheel? A good pakage should be able to do OCR. Les. -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: 01 December 2004 08:26 To: [EMAIL PROTECTED] Subject: [U2] Scanner Connection I have a client using Accuterm with telnet sessions for all the users. One user has a Bell Howell multi-page scanner that gets around 100 pages per day of work orders etc. That user's emulator is Ve-Client from Visual Pick and they want to re-write the app with Accuterm and some VB scripting if necessary. My question is where would someone go to find out how this can be done. It presently is done in VE with a 9,500 line program (4GL generated code) that has oodles of includes and gets very busy. It still doesn't do what I would like and that is for the scanner to write the scanned docs to a temp folder, I would use Accuterm to load in those filenames and offer them to the user for proper pc-filenaming to attach to the application. I would appreciate any insight on this. Thanks in advance. Mark Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to setup MALLOCTRACING?
What are you running within Universe? Seems like quite a lot of memory to be using, none of our processes (on Windows or Unix) ever go over 15mb of physical memory. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 30 November 2004 07:42 To: [EMAIL PROTECTED] Subject: [U2] How to setup MALLOCTRACING? Hi Everyone, I'm still battling with the 'Available memory exceeded' problem on Sco Unixware. I haven't been able to receive feedback from anyone on the list running UV on Unixware on how they have configured their system and how much memory they can be mallocated in one big chuck. I can only get 30Mb max before the memory exceeded error is thrown even though I have 8 Gig RAM and am the only user on the system. The system runs nothing else but UV and all possible Unixware parameters must be optimised for UV. I want to turn on MALLOCTRACING to 1 in the hope that I will be able to find out the exact nature of the failure. I have tried but then UV fails to start with a missing parameter message. Does anyone know how to setup the malloctracing? Where does the tracing information get written to and how to interpret it? Thanks for any help. Regards, Marco. - Win a castle for NYE with your mates and Yahoo! Messenger --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to setup MALLOCTRACING?
I can understand an edit of a 30mb file failing but the delete is a bit strange. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 30 November 2004 13:46 To: [EMAIL PROTECTED] Subject: RE: [U2] How to setup MALLOCTRACING? The problem shows itself up in 2 ways: 1) DELETEing or EDiting a record from COMO, SAVEDLISTS, or HOLD thats more than 30Mb fails with 'Available memory exceeded' 2) A number of reports on the system use the TEMP.LIST-1 = TEMP.STR construct and these are failing for big files. Unfortunately I cant change this because I have no access to the source code and it would be a major major exercise based on the size of the system. Regards, Marco. Adrian Matthews [EMAIL PROTECTED] wrote: What are you running within Universe? Seems like quite a lot of memory to be using, none of our processes (on Windows or Unix) ever go over 15mb of physical memory. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 30 November 2004 07:42 To: [EMAIL PROTECTED] Subject: [U2] How to setup MALLOCTRACING? Hi Everyone, I'm still battling with the 'Available memory exceeded' problem on Sco Unixware. I haven't been able to receive feedback from anyone on the list running UV on Unixware on how they have configured their system and how much memory they can be mallocated in one big chuck. I can only get 30Mb max before the memory exceeded error is thrown even though I have 8 Gig RAM and am the only user on the system. The system runs nothing else but UV and all possible Unixware parameters must be optimised for UV. I want to turn on MALLOCTRACING to 1 in the hope that I will be able to find out the exact nature of the failure. I have tried but then UV fails to start with a missing parameter message. Does anyone know how to setup the malloctracing? Where does the tracing information get written to and how to interpret it? Thanks for any help. Regards, Marco. - Win a castle for NYE with your mates and Yahoo! Messenger --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ - ALL-NEW Yahoo! Messenger - all new features - even more fun! --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV Citrix Accuterm
Version of Wintegrate prior to 5 used to have this problem. We run 5.2 which works fine with device licensing on terminal server. Looks like Accuterm need a new licensing DLL from IBM. From: [EMAIL PROTECTED] on behalf of John Jenkins Sent: Sun 28/11/2004 11:46 To: [EMAIL PROTECTED] Subject: RE: [U2] UV Citrix Accuterm The problem may be that AccuTerm seems to be using the IP address of the Citrix server to identify when it should be using the IP address of the client PC. You should check with AccuTerm that they are using the appropriate Windows system calls and librarikes - different calls are used to get the client IP address and the terminal server IP address. Could be a library version issue (i.e. 10 sessions per server rather than 10 sessions per client - yes?) Seen this before.. wIntegrate, SBClient and Dynamic Connect use the client IP address Regards JayJay snip I'm not certain of the ramifications of Citrix, but my understanding is you get 10 concurrent login sessions per licenced AccuTerm user.So if you licence Accuterm on a single-user basis, that user can login concurrently 10 times... IIRC site licences covering 50 and 250 users are obtainable, thereby giving *each* logged-in user 10 concurrent sessions At least, that's my understanding of Dynamic Connect and wIntegrate device licencing Any ideas will be most appreciated... We need to get off these old antique --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Help with fnuxi
I had the same problem recently. IBM told me you can't; once a file has been SQL'ised (which adding triggers does) you can't move it between OS's. Even dropping the triggers won't work. All you can do is to create a new file on the source machine and copy the data to it and then port that one over instead. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: 18 November 2004 21:20 To: [EMAIL PROTECTED] Subject: [U2] [UV] Help with fnuxi I have some data files that I can't run fnuxi on because they have triggers. How do I successfully move these files between *NIX and Windows without having to drop the triggers? Jay Falck, CISSP, CHSS Unicorn Computing 512-563-4132 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: Unclassified RE: [U2] SSH and wIntegrate
There is also an article in the same place that explains how to set wIntegrate to use SSH via the dialer menu (using PuTTY). It's a bit clunky at first but it does work. I also raised the lack of SSH support with IBM and their attitude is that SSL is a much better solution than SSH. Not what the rest of the industry would seem to think, I would like to see a 6.1 release with SSH support (anyone listening!!) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 19 November 2004 03:08 To: [EMAIL PROTECTED] Subject: Re: Unclassified RE: [U2] SSH and wIntegrate Ken wants SSH, but wIntegrate and the U2 server products support SSL. Almost every other telnet client available - even free ones like TeraTerm - supports SSH, but wIntegrate Dynamic Connect don't. Also the U2 Windows telnet servers are not SSH-capable, so you can't use an SSH telnet client at all on a Windows / U2 solution. I have raised this before (with IBM, too) and cannot understand why they have chosen the SSL approach rather than the more industry-standard SSH for telnet connections. Thanks Mike, Indeed, that is how it is. My client would like to use SSH. Indeed, they currently have telnetd switched off on their new boxes and they don't want to start it up unless absolutely necessary. I found an article ( http://www-1.ibm.com/support/docview.wss?rs=686context=SSKJMPq1=SSHui d=swg21081430loc=en_UScs=utf-8lang=en )on the IBM web site which included the following info: - wIntegrate version 5.1.0 and later supports the SSL (Secure Sockets Layer) protocol for secure connections to the host. There are no plans to officially support SSH (Secure SHell or Secure Socket Shell) which is another way to secure communications. SSH is incompatible with SSL. SSL is a protocol implemented in the communications layer so most TCP/IP processes can support it. For example, HTTPS and FTPS are SSL-secured implementations of HTTP and FTP. In wIntegrate we use SSL with the Telnet process. SSL is a much better solution than SSH and will be used by the U2 databases for secure connections. - I'm particularly interested in the line In wIntegrate we use SSL with the Telnet process. does anyone know what that relly means? How does one configure telnetd on a UNIX box (Solaris 9 to be specific) to accept SSL connections and talk to wIntegrate. Further, if this can be done, can we make sure that ONLY SSL connections are accepted? Best Regards, Ken --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Help with EVAL in SELECT statement
Shouldn't really have a decimal point in it. You should always store data in internal rather than external format. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: 19 November 2004 10:11 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with EVAL in SELECT statement Tom, Here is a CT of the item. The field we are interested in is 25. Press any key to continue... 0022 0023 0.000225 0024 0.000225 0025 0.000225 0026 0.000225 0027 0.000225 Tom Dodds [EMAIL PROTECTED] wrote: What does the real data look like. CT that item, 0048108, and lets see how the data is really stored. Tom Dodds [EMAIL PROTECTED] 630-235-2975 Cell 708-482-4510 Office -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Marco Manyevere Sent: Wednesday, November 17, 2004 12:57 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with EVAL in SELECT statement Thanks for the suggestion but I want to know is why this doesnt work. What looks broken? Allen E. Elwood wrote:Looks broken. Why not make a dict to round it up to MD2 and then just select everything with a balance not equal to zero? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marco Manyevere Sent: Wednesday, November 17, 2004 08:10 To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] Help with EVAL in SELECT statement Martin, Here again: SELECT F.ACCOUNT WITH EVAL ABS(BALANCE) GT 0.01 15480 record(s) selected to SELECT list #0. LIST F.ACCOUNT EVAL ABS(BALANCE) 0955485 1972.55 0971405 114629.25 0987328 45803.12 0048108 0.0002 2006146 54125.35 SELECT F.ACCOUNT WITH EVAL ABS(BALANCE) GT 0.01 15480 record(s) selected to SELECT list #0. LIST F.ACCOUNT EVAL QUOTE(BALANCE) 0955485 1972.55 0971405 114629.25 0987328 45803.12 0048108 0.000225 2006146 54125.35 Here is the DICT record for BALANCE 0001: D 0002: 25 0003: 0004: BALANCE 0005: 19R 0006: S Bottom at line 6. Martin Phillips wrote: Hi Brian, I can see that this will run on a bit I think Mats is correct. The 'field' in question is an EVAL expression, so doesn't have its own conversion code unless you explicitly state it using the CONV keyword. Hence the confusion over the result. EVAL takes on the properties of the first item in the expression, in this case BALANCE. Regardless of what it is doing, the output of displaying BALANCE should be equivalent to the value used in the comparison. It would be interesting to see the results of EVAL QUOTE(BALANCE) as I thing this is going to show that the field is faulty in some way. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ - Moving house? Beach bar in Thailand? New Wardrobe? Win #10k with Yahoo! Mail to make your dream a reality. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ - Moving house? Beach bar in Thailand? New Wardrobe? Win #10k with Yahoo! Mail to make your dream a reality. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ - Moving house? Beach bar in Thailand? New Wardrobe? Win #10k with Yahoo! Mail to make your dream a reality. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Help with fnuxi
Two machines running the same OS is fine. It's just Windows to Unix and vice-versa (and any other combo that requires fnuxi to be run). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: 19 November 2004 14:00 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi Is everything still OK for copying files between two like machines for purposes of replicating for a test system then? I can get around the issue of between OS's but now I'm worried about recreating the test environment. Thanks, Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, November 19, 2004 2:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi I had the same problem recently. IBM told me you can't; once a file has been SQL'ised (which adding triggers does) you can't move it between OS's. Even dropping the triggers won't work. All you can do is to create a new file on the source machine and copy the data to it and then port that one over instead. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: 18 November 2004 21:20 To: [EMAIL PROTECTED] Subject: [U2] [UV] Help with fnuxi I have some data files that I can't run fnuxi on because they have triggers. How do I successfully move these files between *NIX and Windows without having to drop the triggers? Jay Falck, CISSP, CHSS Unicorn Computing 512-563-4132 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Help with fnuxi
The original question was about file triggers. If you move files between systems that require fnuxi to be run on them then it will not work even if the triggers are removed. If you don't need to run fnuxi then they work fine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 19 November 2004 15:23 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi This is correct... It's purely an issue with byte-ordering of the systems. In fact, there's nothing to say that if you could run windows on a big-endian based architecture that you wouldn't have to run fnuxi when transferring files between Windows accounts. In fact, we had this issue years ago on some Unix platform, where the vendor (don't remember which one off hand) had two processor architectures, with different endian-ness. Some customers found it odd that transferring files amongst same machines caused them to have to run fnuxi. In reality, while they had the same Company logo, they weren't the same... Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 19, 2004 10:08 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi [EMAIL PROTECTED] wrote: Two machines running the same OS is fine. It's just Windows to Unix and vice-versa (and any other combo that requires fnuxi to be run). WRONG WRONG WRONG. I've transferred type 30 files between three different machines - SCO, linux and Windows - and the files are *BINARY* *COMPATIBLE*. The thing is, they *all* run on x86 boxen. Most nix boxen are big-endian, all doze boxen are little-endian, hence the assumption it's a doze/nix thing. But it isn't - it's an endian thing. Some systems (SPARC?) can be either big or little endian, so you could find yourself having to run fnuxi to transfer files from a machine to itself, should you have a dual-boot system ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: 19 November 2004 14:00 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi Is everything still OK for copying files between two like machines for purposes of replicating for a test system then? I can get around the issue of between OS's but now I'm worried about recreating the test environment. Thanks, Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, November 19, 2004 2:09 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi I had the same problem recently. IBM told me you can't; once a file has been SQL'ised (which adding triggers does) you can't move it between OS's. Even dropping the triggers won't work. All you can do is to create a new file on the source machine and copy the data to it and then port that one over instead. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: 18 November 2004 21:20 To: [EMAIL PROTECTED] Subject: [U2] [UV] Help with fnuxi I have some data files that I can't run fnuxi on because they have triggers. How do I successfully move these files between *NIX and Windows without having to drop the triggers? Jay Falck, CISSP, CHSS Unicorn Computing 512-563-4132 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Errors
The 81002 error relates to the unirpcservices file. Either the data source is not present or the service name is missing. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tim Harkin Sent: 19 November 2004 15:38 To: [EMAIL PROTECTED] Subject: [U2] ODBC Errors Some developers I work with have a daily processing batch that queries a UniVerse DB (10.0.3) and then writes the result set to an Oracle instance. The code is written in java. We use a product called JDataConnect as an ODBC/JDBC bridge. Last night the job failled. I have a lot of error code data that the app logs returned, but I do not know where to research the error codes. I do not have a support account either (the database is used for a commercial applciation, and that vendor actually has the support account for our licenses. ANd the vendor will take a while to figure this out). Any advice on how to troubleshoot this is appreciated. Here is a snippet from the logs: RetrieveTRvimHoldings.loadTRvimHoldings(): Begin process at Fri Nov 19 09:12:51 EST 2004 RetrieveTRvimHoldings.loadTRvimHoldings(): Querying TR Date at Fri Nov 19 09:12:52 EST 2004 RetrieveTRvimHoldings.loadTRvimHoldings(): TR Date = 2004-11-18 RetrieveTRvimHoldings.loadTRvimHoldings(): Starting TR Query at Fri Nov 19 09:12:55 EST 2004 RetrieveTRvimHoldings.loadTRvimHoldings(): Ending TR Query at Fri Nov 19 09:13:02 EST 2004 RetrieveTRvimHoldings.populateTRvimHOLDINGS(): ITERATING through TR Data at Fri Nov 19 09:13:03 EST 2004 RetrieveTRvimHoldings.populateTRvimHOLDINGS(): Insertion failed! Trying to roll back db transactions. -++-Regular Exception-++- RetrieveTRvimHoldings.loadTRvimHoldings(): ServerException: [ODBC Error], SQLFetchScroll DBVendorCode:81002:, DBState:S1000:. [IBM][UVODBC][27004 16]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: IM985; uniVerse code: 81002; Msg: [IBM][SQL Client] [RPC] error code = 81002. java.sql.SQLException: ServerException: [ODBC Error], SQLFetchScroll DBVendorCode:81002:, DBState:S1000:. [IBM][UVODBC][2700416]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: IM985; uniVerse code: 81002; Msg: [IBM][SQL Client][RPC] error code = 81002. at JData2_0.sql.$Connection.FromServer($Connection.java:954) at JData2_0.sql.$Connection.ToServer($Connection.java:1016) at JData2_0.sql.$Connection.ToServer($Connection.java(Inlined Compiled Code)) at JData2_0.sql.$ResultSet.getRowset($ResultSet.java(Compiled Code)) at JData2_0.sql.$ResultSet.Move($ResultSet.java(Compiled Code)) at JData2_0.sql.$ResultSet.next($ResultSet.java(Compiled Code)) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.populateTRvimHO LDINGS(Unknown Source) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.loadTRvimHoldin gs(Unknown Source) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.main(Unknown Source) java.sql.SQLException: ServerException:[ODBC Error], SQLFetchScroll DBVendorCode:81002:, DBState:S1000:. [IBM][UVODBC][2700416]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLFetch(XIO); State: IM985; uniVerse code: 81002; Msg: [IBM][SQL Client][RPC] error code = 81 002. at JData2_0.sql.$Connection.FromServer($Connection.java:954) at JData2_0.sql.$Connection.ToServer($Connection.java:1016) at JData2_0.sql.$Connection.ToServer($Connection.java(Inlined Compiled Code)) at JData2_0.sql.$ResultSet.getRowset($ResultSet.java(Compiled Code)) at JData2_0.sql.$ResultSet.Move($ResultSet.java(Compiled Code)) at JData2_0.sql.$ResultSet.next($ResultSet.java(Compiled Code)) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.populateTRvimHO LDINGS(Unknown Source) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.loadTRvimHoldin gs(Unknown Source) at com.ohis.operations.reconciliation.RetrieveTRvimHoldings.main(Unknown Source) RetrieveTRvimHoldings: ERROR - RetrieveTRvimHoldings FAIL --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian
RE: [U2] [UV] Initialization Error
Unix or Windows? We had a similar problem recently and it turned out to be the memory allocation for Windows processes. We had to change a registry setting. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bryan Haglund Sent: 19 November 2004 15:40 To: U2 Users Subject: [U2] [UV] Initialization Error I am receiving an error when trying to run a phantom: An error has occurred during uniVerse initialization Please contact the system administrator Error code: 1 25 I have not been able to find a listing of what the error codes translate to. Does anyone have an idea? Thanks, Bryan Haglund Haglund Consulting Inc. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Help with fnuxi
I couldn't move files from our Windows to Solaris system if they had previous triggers on them. We no longer use triggers on our files but something stays set in the header as LIST.SICA works on the files. IBM support themselves said it was not possible to move files with triggers (either current or past) from Windows to Solaris and they would have to be re-created on Windows, copied over and then Fnuxi'ed, which is what I did in the end. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 19 November 2004 16:43 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi Interesting question... If you are referring truly to file triggers (ie, not triggers on SQL tables), then it depends on how Denver implemented it. The usage of triggers was previously relegated to purely being allowed against SQL tables, due to the SICA that all SQL tables contained. We outlined to the Denver team a means to implement file triggers, but it depends on how they implemented it. With normal SQL files, due to the SICA and SQL information needed, you couldn't do a straight fnuxi on the file, as this only deals with byte-ordering. For normal files, any given file can be copied over to a new system and made live by adding a VOC pointer and fnuxi'ing the file. But, SQL tables require additional paperwork to make it happen, including the schema and definition defined at the system level (UV_TABLES, etc...). So, to facilitate this, fnuxi has an option ( -export | -import ) to allow you to export/import SQL tables. When you do so, it creates a sequence of actual export scripts that can then be transferred to the new system, along with the file, to facilitate a proper fnuxi/transfer. If the implementation of the file triggers includes this SICA information, in a similar fashion to a normal SQL table, it's likely you need to run this (or similar) fnuxi option to ensure the export of the Trigger information, so when you run the corresponding '-import' on the target system, it will properly set up the Triggers. But, ultimately, one of the Denver folks would have to answer the question... But, it's worth a try... if you run fnuxi -export FILE, do you see the corresponding EXPORTxxx.yyy files being created? Dave -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, November 19, 2004 11:01 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi The original question was about file triggers. If you move files between systems that require fnuxi to be run on them then it will not work even if the triggers are removed. If you don't need to run fnuxi then they work fine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 19 November 2004 15:23 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi This is correct... It's purely an issue with byte-ordering of the systems. In fact, there's nothing to say that if you could run windows on a big-endian based architecture that you wouldn't have to run fnuxi when transferring files between Windows accounts. In fact, we had this issue years ago on some Unix platform, where the vendor (don't remember which one off hand) had two processor architectures, with different endian-ness. Some customers found it odd that transferring files amongst same machines caused them to have to run fnuxi. In reality, while they had the same Company logo, they weren't the same... Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, November 19, 2004 10:08 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi [EMAIL PROTECTED] wrote: Two machines running the same OS is fine. It's just Windows to Unix and vice-versa (and any other combo that requires fnuxi to be run). WRONG WRONG WRONG. I've transferred type 30 files between three different machines - SCO, linux and Windows - and the files are *BINARY* *COMPATIBLE*. The thing is, they *all* run on x86 boxen. Most nix boxen are big-endian, all doze boxen are little-endian, hence the assumption it's a doze/nix thing. But it isn't - it's an endian thing. Some systems (SPARC?) can be either big or little endian, so you could find yourself having to run fnuxi to transfer files from a machine to itself, should you have a dual-boot system ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jay Falck Sent: 19 November 2004 14:00 To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Help with fnuxi Is everything still OK for copying files between two like machines for purposes of replicating for a test system then? I can get around the issue of between OS's but now I'm worried about recreating the test environment. Thanks, Jay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: Friday, November 19
RE: [U2] Monitoring file changes
You could add a security subroutine to the ED (and others like DELETE if you wanted) voc item. If you put a subroutine name into field 4 of a remote dict item then it will get called whenever that command is executed. We have one of these on the MASTER command. MASTER 0001 R 0002 UV.VOCLIB 0003 MASTER 0004 *ITAudit UV.VOCLIB MASTER 0001 Verb - Used by System Administrator only! 0002 master 0003 E -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Pflugfelder Sent: 17 November 2004 15:12 To: u2-users Subject: [U2] Monitoring file changes Universe 9.6.2.1 Dec OSF1 V4.0F In our payroll application, we've got a file, EMPMAST which is indexed (Blacksmith Index for those that are curious). Occasionally, records are disappearing from the file, but not from the index. The only way that this should happen is from TCL. I've checked the file for corruption and it doesn't seem to be corrupt. It's a dynamic file, but so are most of our other files and we don't have any problems with those. Is there some way that I could monitor the file to see who deletes or changes records? Is there something else that I should be concerned about? I'm not sure if it will help, but I'm including an ANALYZE.FILE EMPMAST STATS: File name .. EMPMAST Pathname ... EMPMAST File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 4501 current ( minimum 1, 93 empty, 1441 overflowed, 46 badly ) Number of records .. 18625 Large record size .. 1628 bytes Number of large records 0 Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 12236800 bytes Total size of record data .. 7385520 bytes Total size of record IDs ... 82020 bytes Unused space ... 4765164 bytes Total space for records 12232704 bytes -Mike Pflugfelder --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] LIST.INDEX Build info
Once the index has been setup then there is no reason why it should ever need to be rebuilt as long as the conditions it was setup under don't change. So they really are that low maintenance. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 17 November 2004 15:29 To: [EMAIL PROTECTED] Subject: [U2] LIST.INDEX Build info I have a report I run every week that prints the output of LIST.INDEX on all files that have indexes. These are I_X files in Unix where I 'field' off the I_ and do LIST.INDEX X and send the output to the printer. I see the under the Build column, it always says Not Reqd (except for new indexes that really do need to be built) and I'm wondering if that message can be trusted. In other words, are these UniVerse indexes really that low maintenance? -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] [u2] remote paragraphs
I seem to remember that there is a way of executing a Paragraph stored in a file other than VOC without creating a pointer in the VOC to reference it. I may well be wrong though! Anyone know if this is possible or not? The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] broken up SELECTS
It's something I've always done over the last twenty years. The select processor in theory should apply optimisiation but I always break my statements down to reduce the working record set and to increase readability. Makes very little difference on smaller amount of records but makes a huge difference when record counts get into the millions, especially on distributed files or selects which work on a mixture of non-indexed and indexed fields. From: [EMAIL PROTECTED] on behalf of Mark Johnson Sent: Thu 11/11/2004 13:58 To: [EMAIL PROTECTED] Subject: Re: [U2] PICK Assembler Language In all of my travels of code before me at my clients, I have never seen a convoluted SELECT statement broken up into 2 or more pieces for effeciency reasons. I stumbled on the idea around 9 years ago trying to squeeze a few more drops of speed from a 386-based system running InfoQuest. I saw the 95% wasted translates based on my original example and got a 50% increase in speed running a process that had to run about 15 times per user per day. Almost won the Nobel Prize with that client. Not that I've seen everything or more than all, but in my 25+ years of pick covering about 40 different platforms and environments I have never seen a SELECT statement broken up. Thanks. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 11, 2004 6:13 AM Subject: Re: [U2] PICK Assembler Language Just because we have a quadrillion microseconds to play with, instead of a 50 millisecond timeslice, doesn't mean we have to waste them. A few moments to consider performance, done once in the development cycle, will pay benefits every time a more efficient program is run. I have to believe that Adm Grace Hopper is smiling down on you both. Regards, Charlie Noah [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) writes: -Original Message- snip I can't imagine anyone on this forum having to break up this sentence likewise on the current platforms. On this client's older MCD, it truly makes a difference. /snip - Ah, Mark..I do this all the time for the performance reasons mentioned :) Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis is the premier provider of targeted advertising, media, and marketing services that drive consumers to marketers more effectively. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] Nasty error in Universe on Windows
We got the following message in the event log of our windows 2000 server (Universe 10.1.0): UniVerse error: Failed to release process table lock. Win32 error: 6. The handle is invalid.. This seemed to hang the Universe Resource process and no-one could log on or do LISTU etc etc. People already logged on were fine. We rebooted the server and it seems fine now but obviously we're concerned it will happen again. We've reported it to our VAR but I thought I'd see if anyone here could point me in the direction of what might have caused it. Thanks Adrian The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UVODBC conflict
U2licn.dll is/was the name if that helps. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Alfke, Colin Sent: 08 November 2004 21:05 To: [EMAIL PROTECTED] Subject: RE: [U2] UVODBC conflict I think the problem is with the u2*.* programs. I seem to recall there was an issue with SBClient as the licensing DLL started with U2 and conflicted with Crystal as it assumed that all programs that start with U2 belong to Crystal. (Or something silly like that). IBM renamed the DLL that was causing the issue. Hth Colin Alfke Back in LA Current celebrity sighting count: 1 -Original Message- From: Andy Moore [mailto:[EMAIL PROTECTED] snip Hello usergroup, Just submitted this to IBM support, but I thought I'd see if anyone on here had seen this. One of our customer sites has just had the UVODBC client driver installed and noticed that when this is installed software from another supplier stops working. The removal of the UVODBC driver means the other software works perfectly fine again, without reinstalling it. I have contacted the supplier of the software conflicting with the UVODBC and they have stated that they use the Seagate Crystal Report Writer Version 7 (32 bit) ocx within their class application that's having the problem. They have sent me a list of all the system files installed with their application, which I have listed below, in case there are any conflicts between the UVODBC driver and their system files. snip u2ddisk.dll u2dmapi.dll u2fcr.dll u2fdif.dll u2fhtml.dll u2frec.dll u2frtf.dll u2fsepv.dll u2ftext.dll u2fwks.dll u2fwordw.dll u2fxls.dll snip Looking at some of the files above, it would seem that their software is written in VB6, but other than that there's nothing obvious to me. (the U2 dll's look suspicious, but not sure) If anyone's able to advise on this I would be grateful. We have installed the UVODBC on many sites and this is the first time we have had a problem of this nature. The Universe version is 10.1.3 and the client driver is the version that's supplied with 10.1.3 Their server is a Windows server. Thanks Andy Moore --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects.NET speed/performance - PERFORMANCE SURVEY
Slow as the proverbial in my case; went back to VB6. Majority of our stuff is in Java so it was no great problem to us. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Tabor Sent: 05 November 2004 19:05 To: [EMAIL PROTECTED] Subject: RE: [U2] UniObjects.NET speed/performance - PERFORMANCE SURVEY *** Now you've got me wondering... *** We're considering moving from UO to UO.NET due to a considerable amount of our non-MV programming is in VB.NET anyway. I'm getting the feeling that UO.NET is generally slow, but then remembered, this conversation is one-sided so far. On the flip side of this conversation, can we get a feel for how many people are experiencing performance issues, and how many are finding it's working just fine? Simple SLOW/FINE answers are fine, but feel free to explain answers or comment further if you'd like. Thanks, for the help Dave -Original Message- snip I find .net to be slow and cludgy in virtually all situations - even with a fast processor and 512MB RAM. /snip -Original Message- snip Yes! We found it so slow /snip - Original Message - snip Is anyone else experiencing speed problems with Uniobjects.net? I've just upgraded our core application from Uniobjects to UONET (a non-trivial exercise as I'm sure you're aware) but the response times are atrocious. Opening a file has gone from being a virtually instant response to taking well over a quarter of a second. /snip --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV]telnet
Interesting attitude. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stu Glancy Sent: 02 November 2004 18:04 To: [EMAIL PROTECTED] Subject: Re: [U2][UV]telnet Au contrair. Tom Firl was able to give me exactly what I needed. I was able to build a PAragraph with inputs that executed a sh -c script passing the inputs to allow login and execution of a shell script. I was after concept and Tom gave me concept. (See below.) I used echo to pass my inputs and all worked just fine. If you were frustrated with my posting then perhaps you didn't have the answer. SH -c '(sleep 1; echo username; sleep 1; echo password; sleep 5; echo ls -l; sleep 3; echo exit) | telnet hostname' Adrian Matthews wrote: I must admit that the original post is a good example of one of the things I find really frustrating about this list. People just don't give enough info to get any real help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar Sent: 29 October 2004 13:23 To: [EMAIL PROTECTED] Subject: RE: [U2][UV]telnet Bob: I think Stu is trying to run another data entry application via telnet, without the user realizing it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Witney Sent: Friday, October 29, 2004 3:05 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UV]telnet Stu: I think that you are attempting to so something akin to this; ftp -iv servername EOF cd /account cd ramis_archive cd /account/CRG.VENDOR get filename quit EOF Where the login would be a line in .netrc on your home account i.e machine servername login loginid password passwordone I don't think that you can invoke a telnet session the same way Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stu Glancy Sent: 28 October 2004 19:54 To: [EMAIL PROTECTED] Subject: [U2][UV]telnet I want to create a telnet script from a program and execute it. Can it be done? If it can, what would the EXECUTE look like? What would the script look like? I'm looking for concept and a little detail. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV]telnet
What I was getting at is that it easier to help people if they explain the issue they are trying to solve rather than a problem with a particular solution. For example, if you wanted to run a remote telnet session to another U2 server just to execute another program then I might have suggested an RPC call. It still might be the case that a telnet script is not the best solution to what you are doing, but without knowing why you want to do it... Besides I only made the comment after postings from other people saying perhaps he's doing this or maybe he's doing that so obviously a lot of people wanted more detail. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stu Glancy Sent: 02 November 2004 18:04 To: [EMAIL PROTECTED] Subject: Re: [U2][UV]telnet Au contrair. Tom Firl was able to give me exactly what I needed. I was able to build a PAragraph with inputs that executed a sh -c script passing the inputs to allow login and execution of a shell script. I was after concept and Tom gave me concept. (See below.) I used echo to pass my inputs and all worked just fine. If you were frustrated with my posting then perhaps you didn't have the answer. SH -c '(sleep 1; echo username; sleep 1; echo password; sleep 5; echo ls -l; sleep 3; echo exit) | telnet hostname' Adrian Matthews wrote: I must admit that the original post is a good example of one of the things I find really frustrating about this list. People just don't give enough info to get any real help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rex Gozar Sent: 29 October 2004 13:23 To: [EMAIL PROTECTED] Subject: RE: [U2][UV]telnet Bob: I think Stu is trying to run another data entry application via telnet, without the user realizing it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bob Witney Sent: Friday, October 29, 2004 3:05 AM To: [EMAIL PROTECTED] Subject: RE: [U2][UV]telnet Stu: I think that you are attempting to so something akin to this; ftp -iv servername EOF cd /account cd ramis_archive cd /account/CRG.VENDOR get filename quit EOF Where the login would be a line in .netrc on your home account i.e machine servername login loginid password passwordone I don't think that you can invoke a telnet session the same way Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stu Glancy Sent: 28 October 2004 19:54 To: [EMAIL PROTECTED] Subject: [U2][UV]telnet I want to create a telnet script from a program and execute it. Can it be done? If it can, what would the EXECUTE look like? What would the script look like? I'm looking for concept and a little detail. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies
RE: [U2] Index problem
Perhaps its to do with the processing order, Unidata might be updating the index on the previous contents? This would seem to fit in with the rebuild putting the item into the index. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kafsat taiyus Sent: 03 November 2004 03:00 To: '[EMAIL PROTECTED]' Subject: [U2] Index problem We have one Unidata 5.1 data file with a virtual attribute. The virtual dictionary calls a Unibasic subroutine and returns a single value data from a multi value attribute from within the same file. We have an index on the virtual attribute. When new records are added to the file Unidata does not update the index on the virtual attribute. After adding new records that returns XXX for the virtual attribute the command LIST FILE_NAME WITH VIRTUAL_ATT = XXX does not return any record. But the command LIST FILE_NAME NO.INDEX WITH VIRTUAL_ATT = XXX finds the record. The command LIST FILE_NAME WITH VIRTUAL_ATT = XXX works only after rebuilding the index using REBUILD.INDEX command. Do you know why is it happening and how to fix it? Thank you in anticipation. Regards Kafsat This email and any attachments are confidential and intended solely for the use of the person or entity to whom they are addressed. If you are not the intended recipient, please do not disclose, store, copy or take any action in reliance on it or them. If you have received this message in error, please tell us by reply email (or telephone + 61 (0) 3 9274 9100) and delete all copies on your system. Any opinion, advice or information in this email is not necessarily that of the owners or officers of this company. Please advise us immediately if you or your employer do not consent to email for messages of this type. Retail Decisions has taken reasonable precautions to ensure that any attachment to this email has been swept for viruses. However, we cannot accept any liability for any damage sustained as a result of software viruses, and would advise that you carry out your own virus checks before opening any attachment. Please note that communications sent by or to any person through our computer system may be viewed by other Retail Decisions employees or officers strictly in accordance with law. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Index problem
Depends on how you're referring to the field in the subroutine. If its being read from the file then I can see that would never work. If its being passed as an argument then maybe. As some other posters have said, we really need to see the subroutine to help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Fred Finken Sent: 03 November 2004 15:59 To: [EMAIL PROTECTED] Subject: RE: [U2] Index problem Logically, if field2 runs a subroutine that looks at field3, and field3 gets changed... I don't see how the system can be expected to know that the index on field2 needs to be updated. Whoa... Sounds like you're saying that no virtual indices should work (whether or not a subroutine is involved). I can see where a virtual referring to another item (in the same file or another file) couldn't be expected to stay up-to-date with changes, but if the references are to the same item, they should work. -- ___ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] UniObjects and Time zones
Hven't you asked IBM, presumably they would know as both systems are theirs? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: 28 October 2004 21:26 To: '[EMAIL PROTECTED]' Subject: RE: [U2] [UD] UniObjects and Time zones When we boot our AIX system, it shows the current date and time as GMT (UTC?) and our time zone is EST, therefore when I do a date at the Unix prompt, I get: Thu Oct 28 16:25:44 EST 2004 And when I do a DATE at our UniData prompt, I get: Thu Oct 28 16:26:00 EST 2004 These are giving me the correct time and date. When I do echo $TZ at a Unix prompt, I get: EST5EDT1:00,M4.1.0/2:00:00,M10.4.0/2:00:00 Therefore, our time zone is correct as far as Unix and UniData goes. However, when I run the command: LIST WORK.ORDER DT TM SAMPLE 10 through a UniObjects program (see below), It gives me the raw date and time - with no time zone offset applied. So my question is, where does UniObjects get the time zone when a dictionary containing @TIME, TIME(), @DATE or DATE() is run? btw, I don't see anything in my .profile that has anything to do with time zone. Thanks. Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 2:35 PM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] UniObjects and Time zones You haven't got something in your account login that is setting timezone stuff perhaps? Uniobjects bypasses the login. Also are you running the uo session under the same user as the telnet session that is giving you the correct date? Might be set in profile. From: [EMAIL PROTECTED] on behalf of Burwell, Edward Sent: Thu 28/10/2004 15:08 To: '[EMAIL PROTECTED]' Subject: [U2] [UD] UniObjects and Time zones Yes, I am on Unix (AIX) and it would seem to be a time zone issue. Any dictionary containing @DATE, DATE(), @TIME or TIME(), that is run by UniObjects is giving me GMT. How can I tell UniObjects to apply our time zone? Thanks Ed Burwell [EMAIL PROTECTED] 973.361.5400 x1512 -Original Message- From: Mark Eastwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 11:40 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from? Assuming you're on Unix - there is an environmental setting tz for timezone. Try man on tz or timezone. -Original Message- From: Burwell, Edward [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 10:06 AM To: [EMAIL PROTECTED] Subject: Spam:RE: [U2] [UD] Where does UniObjects get @DATE and @TIME from? Regardless, the @DATE and @TIME are different by about 5 hours. Is there a setting in UniObjects that determines or sets the time zone that I'm in? -Original Message- From: Bob Witney [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 6:52 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? Yes @TIME on Universe is the proces start time as an intiger (regardless of what the book says) and TIME() is the actual time with decimals i.e 42716 42716.8421 42716 42717.8422 42716 42718.8424 Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brian Leach Sent: 27 October 2004 11:15 To: [EMAIL PROTECTED] Subject: RE: [U2] [UD] Where does UniObject get @DATE and @TIME from? @DATE and @TIME are not necessarily the current date and time, they are the date and time the current command/program started. I've seen this as differences in a program between @TIME and TIME(), which always returns the current time. I'm away from my server at the moment and can't verify this, but I suspect that @TIME might be the time that your UniObjects session began. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Burwell, Edward Sent: 27 October 2004 01:49 To: '[EMAIL PROTECTED]' Subject: [U2] [UD] Where does UniObject get @DATE and @TIME from? Hello all, I have a file with 2 dictionaries. One called DT and the other TM: DT 001 V 002 @DATE I also tried DATE() and got the same thing 003 004 005 5R 006 S TM 001 V 002 @TIME I also tried TIME() and got the same thing 003 004 005 6R 006 S When I run a simple UniQuery statement, I get exactly what you'd expect LIST WORK.ORDER DT TM SAMPLE 5 WORK ORDER. DT... TM 584367 13449 74797 59 13449 74797 628402 13449 74797 663471 13449 74797 698540 13449 74797 5 records listed HOWEVER... When I run this through UniOjects, I get: LIST WORK.ORDER DT TM SAMPLE 5 01:48:20 Oct 27 2004 1 WORK ORDER. DT... TM 584367 13450 6500 59 13450 6500 628402 13450 6500 663471 13450 6500 698540 13450 6500 5 records listed I am running UniData 5.2 on AIX 4.3.2. It's around 20:48 on 10/26/2004 as I write this. The time and date is right on our Unix box and it's correct on my XP
RE: [U2] wIntegrate Editor indenting problem
Do you mean UniDebugger? There's no format facility in the wIntegrate editor. If so then that's not the only format bug in it, there's lot of modern constructs that it gets confused with. Proper format within Universe works fine. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wendy Smoak Sent: 29 October 2004 01:51 To: [EMAIL PROTECTED] Subject: [U2] wIntegrate Editor indenting problem Our VAR likes to pretend that the wIntegrate Editor does not exist, so if anyone here can get this to the people who might actually fix it, I would appreciate it! When I write the following and do Edit-Format All, I get... WRITE R.XBEN.WEB.USER TO F.XBEN.WEB.USER, K.XBEN.WEB.USER ON ERROR ;*CRT 'STATUS = ':STATUS() IF STATUS() = 10 THEN RTN.MSG = X.DUPLICATE.IN.INDEX END RELEASE END It doesn't recognize the 'ON ERROR' clause of 'WRITE' as something that needs an END. Actually I asked about this on the list a couple of weeks ago, because the documentation doesn't say that END is part of the syntax, it looks like you only get one line after the WRITE to do what you need to do. It seems to be working, but I use the autoindent to check my code, and this looks wrong. -- Wendy Smoak Applications Systems Analyst, Sr. Arizona State University, PA, IRM ...at 5:52, is it fixed yet, or still taking an hour to post? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/