[U2] UV Bug?
This came from the U2Ug website Better and Better Enhancement Forum, I tried it and they are correct. Is this a bug or is there something wrong with the way it is being done? rayg wrote at Apr 18, 2006 - 09:11 AM - UNIVERSE BUG: I found a bug where if a dictionary item is created for a multivalued field holding internal dates, and the dictionary item has a DM conversion (yielding the number of the month), and it is used to report on data known to exist, Retrieve reports that no items are present. I reported on a file that I knew had data for a certain month. MONTH is a dict item (D in attr 1) with the DM conversion. I used the statements: LIST FILE WHEN MONTH = 12 and SELECT FILE BY-EXP MONTH WHEN MONTH = 12 In both cases, no items or values were returned, and the appropriate message was issued. This worked fine when the conversion was 'D2/', but consistently failed with 'DM'. Investigation revealed that the dict item seemed to fail in some ways to do the conversion, and did selection and returned values based on the internal date, not the number of the month. At my office we are interested in and concerned about this. We appreciate any input on this, and feel that it is obviously important. Thank you. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] UniOLEDB
Bill; Hopefully, you've gotten past this by now - if not: This error usually means that you have the incorrect Data Source in your connection string. This is what is in your UCI.CONFIG file. Note that (like most things in UD) it is case-sensitive. In your case use asidevud. The Path/Location is the account. I usually like to use the full path E:\DataTrust\DtaDemo A common error is the timeout - error code = 81015. You can increase the timeout by changing the values in the unirpcservices file on the server. It defaults to 6 minutes (3600). One error that seems to get me every once in a while is error code = 81002. The first thing I do is check the NT permissions on the file privilege in the account you are trying to connect to. The user needs write access to this file in order to connect. This is all at the windows level. It seems that occasionally VSG will mess with the permissions on this file. We had one client that converted from D3 to UniData and was amazed at how much faster it ran in UD. Good luck Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett I tried to make a UniOLEDB connection from MS VS2005 to UniData and get the error Died in UCI::SQLConnect() with SQLSTATE IM976, Native error: 0 [IBM][SQL Client]UCI connections to non UniVerse databases is not allowed. I've read and followed the 155 page UniOLEDB manual. The following configurations exist: On the Client: Unirpcservices uvcs E:\IBM\UV\bin\uvapi_server.exe * TCP/IP 0 3600 defcs E:\IBM\UV\bin\uvapi_server.exe * TCP/IP 0 3600 uvserver E:\IBM\UV\bin\uvsrvd.exe * TCP/IP 0 3600 uvnet E:\IBM\UV\bin\uvnetd.exe * TCP/IP 0 3600 uvdrsrv E:\IBM\UV\bin\uvdrsrvd.exe * TCP/IP 0 3600 uvfilefix E:\IBM\UV\bin\uvfilefix_server.exe * TCP/IP 0 3600 I updated the uci.config file via the UCI Editor and it looks like: [ODBC DATA SOURCES] -- this has looked funny from the beginning localuv DBMSTYPE = UNIVERSE network = TCP/IP service = uvserver host = localhost localud DBMSTYPE = UNIDATA network = TCP/IP service = udserver host = localhost asidevud DBMSTYPE = UNIDATA NETWORK = TCP/IP SERVICE = udserver HOST = AsiOlyWaDev ACCOUNT = E:\DataTrust\DtaDemo USERNAME = MyUserName --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD - VSG
You should be able to add NT group names as Users in VSG. One word of caution. The user you are using when connecting with VSG will be the owner of the file with full privileges. We noticed that if that user was a member of the administrators group then ALL members of the administrators group were treated as owners. P.S. There are a couple of query tools at: http://gpoulose.home.att.net/ that I've found helpful to use to test connections and syntax. Hth Colin Alfke Calgary, Canada -Original Message- From: Bill Haskett I've been working with VSG and have a question regarding privileges. I have UD v7.1 installed in E:\IBM\ud71. I have several accounts installed in locations other than in @UDTHOME. The @UDHOME directory and the other accounts are restricted to users in the Administrators or UniData group. When creating VSG I have the ability to allow privileges to the PUBLIC, or to users, or, it seems, to Administrators if I type in an administrator user name. How do I restrict access to tables or views to users in the UniData group without having to add each user individually? How do I allow access to tables or views to those outside the Administrators or UniData group, say the SeniorMgmt group? Any help would be appreciated. Bill Haskett --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV Bug?
Jerry, You're saying that the DM is in 3 of the D-descriptor? I think the problem is that the real data is an internal date, the external data in your TCL statements is an integer month number, and there is no way for the DM conversion to make meta-data that would match. What would 12 be as an internal date? This would probably work if you put the DM code in 2 as an OCONV(~,DM). That would make it data which could be directly compared to the 12 in your TCL statement. Then you're not fooling with conversions meta-data. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, April 18, 2006 9:06 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV Bug? This came from the U2Ug website Better and Better Enhancement Forum, I tried it and they are correct. Is this a bug or is there something wrong with the way it is being done? rayg wrote at Apr 18, 2006 - 09:11 AM - UNIVERSE BUG: I found a bug where if a dictionary item is created for a multivalued field holding internal dates, and the dictionary item has a DM conversion (yielding the number of the month), and it is used to report on data known to exist, Retrieve reports that no items are present. I reported on a file that I knew had data for a certain month. MONTH is a dict item (D in attr 1) with the DM conversion. I used the statements: LIST FILE WHEN MONTH = 12 and SELECT FILE BY-EXP MONTH WHEN MONTH = 12 In both cases, no items or values were returned, and the appropriate message was issued. This worked fine when the conversion was 'D2/', but consistently failed with 'DM'. Investigation revealed that the dict item seemed to fail in some ways to do the conversion, and did selection and returned values based on the internal date, not the number of the month. At my office we are interested in and concerned about this. We appreciate any input on this, and feel that it is obviously important. Thank you. --- 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] Re: [U2C] Reminder - SB+ Technical Web cast is just days away!
Great webcast! On 4/16/06, Laura Hirsh [EMAIL PROTECTED] wrote: Hey all, If youre using SB+ you might be interested in learning about upcoming features and how to better use some of the existing ones. If so, please be sure to join us at this weeks SB+ Technical Webcast. If you havent signed up yet, theres still time, but not much the webcast is just days away! Below is the announcement from IBM, and if you are interested, please be sure to register! See you there! Laura Hirsh, U2UG Board Member and Special Interest Group Chair SB+ Technical Preview Webcast Please join us for a SB+ Technical Preview Webcast on Tuesday, April 18, 2006 at 11:00 AM Eastern Daylight Time. Find out about IBM's SB+ product direction and the updated SB+ roadmap, showing both the upcoming SB 5.4 release (now in Beta) and future projects including the upcoming, post-modern, graphical client for SB. Learn how to take advantage of new product features such as installation improvements, user interface updates, encrypted communication using SSL, initial SOX support, as well as generating PDF output. Participate in an interactive QA session with the IBM SystemBuilder Product Manager and Advanced Technical Support Engineer. Speakers: Thom Garcia, U2 Tools Product Manager Ehab AbuShmais, Advanced Client Support Engineer To Register: HYPERLINK http://w.on24.com/r.htm?e=21058s=1k=98375AEDF6833288D1D3F7C362508995http ://w.on24.com/r.htm?e=21058s=1k=98375AEDF6833288D1D3F7C362508995 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.2.5/284 - Release Date: 3/17/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.1/313 - Release Date: 4/15/2006 [demime 1.01d removed an attachment of type image/jpeg which had a name of image001.jpg] u2-community mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV Version
What is the command to see the current version of Universe a server is running? I forget. TIA -Ray --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV Version
.L RELLEVEL That will display the item RELLEVEL stored in the VOC of the account you're logged to. Or at least the version used to *create* that account, if the VOC hasn't been updated after subsequent updates/upgrades. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Buchner Sent: Tuesday, April 18, 2006 3:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Version What is the command to see the current version of Universe a server is running? I forget. TIA -Ray --- 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 Version
Morning Ray, At the command prompt in the uv account (or any for that matter, AFAIK) .L RELLEVEL Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Buchner Sent: Wednesday, 19 April 2006 5:59 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV Version What is the command to see the current version of Universe a server is running? I forget. TIA -Ray --- 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 Version
From TCL, enter .L RELLEVEL will return the UniVerse release. Also on a Windows server you can open the readme.txt file in folder \ibm\uv. Paul H. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Buchner Sent: Tuesday, April 18, 2006 4:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Version What is the command to see the current version of Universe a server is running? I forget. TIA -Ray --- 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 Version
There's a VOC item RELLEVEL, so CT VOC RELLEVEL Or .L RELLEVEL -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Buchner Sent: Tuesday, April 18, 2006 4:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Version What is the command to see the current version of Universe a server is running? I forget. TIA -Ray --- 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 Free Edition. Version: 7.1.385 / Virus Database: 268.4.3/317 - Release Date: 4/18/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.385 / Virus Database: 268.4.3/317 - Release Date: 4/18/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV Version
There is a SYSTEM()entry that will tell you what the release level. I believe it is SYSTEM(1001) but you should look at HELP SYSTEM() to be sure. HTH Tom Dodds [EMAIL PROTECTED] 513-563-2800 Cincinnati Office 708-234-9608 Chicago Office 630-235-2975 Anywhere Cell -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Buchner Sent: Tuesday, April 18, 2006 4:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Version What is the command to see the current version of Universe a server is running? I forget. TIA -Ray --- 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 Version
Hi Ray, If you use the command CT VOC RELLEVEL You will see the release level of the account, or to see what the version of UniVerse is installed, do the above command in the UV account. Hope this helps Chris Day Technical Pre-Sales Specialist Meier Business Systems Melbourne * Sydney * Kuala Lumpur * Singapore -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Buchner Sent: Wednesday, 19 April 2006 6:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV Version What is the command to see the current version of Universe a server is running? I forget. TIA -Ray --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CAUTION: This email and any attachments are confidential, may be privileged, and are intended for use solely by the addressee. The confidentiality and/or privilege in this email is not waived, lost or destroyed if it has been transmitted to you in error. If you receive this email in error, please notify MBS by reply email immediately, delete the email and destroy any printed copies. You must not disclose, disseminate, distribute, reproduce or use the information contained in this email if you are not the intended recipient. The content and opinions contained in this email are those of the individual sender and may not necessarily reflect the views and opinions of MBS. MBS does not guarantee that this email is free from viruses, errors, interception or interference. Use of this email and any attachments is at the sole risk of the user. MBS does not accept any liability for any loss or damage to your computer system or network (including any consequential damage) which may occ! ur directly or indirectly from the use of this email. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/