Bill, In my example 'uvdbsizes' is the account. Now that you mentioned it I did give passing thought to put that account name in caps on the notion it may be expected. I will try that.
The file in the account I am going after is UV.DB.SIZES and contains some 10,000 odd records which are not necessarily complex but the file is dynamic, which I neglected to include in previous detail. So, I could try a different and trimmed down non-dynamic file. Thank you for the comments from Gary Smith. I have plenty of new things to try and I do hope to be claiming victory soon. Gary Chambers UniVerse Systems Omnicare Information Solutions 4936 Blazer Parkway Dublin, Ohio 43017 (614) 652-3123 [email protected] [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, December 01, 2010 3:00 PM To: [email protected] Subject: U2-Users Digest, Vol 20, Issue 1 Send U2-Users mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of U2-Users digest..." Today's Topics: 1. Re: UVODBC Connection Problem (Bill Brutzman) 2. Re: UVODBC Connection Problem (Bill Brutzman) 3. Mac Connection to UniVerse (Don P. Nagai) 4. Re: Mac Connection to UniVerse (Rob Sobers) 5. Re: Mac Connection to UniVerse (Don P. Nagai) 6. Re: Mac Connection to UniVerse (Brawn, Cameron) 7. Re: Mac Connection to UniVerse (Glorfield, Gordon) 8. Re: Mac Connection to UniVerse (Don P. Nagai) ---------------------------------------------------------------------- Message: 1 Date: Tue, 30 Nov 2010 15:23:57 -0500 From: Bill Brutzman <[email protected]> To: U2 Users List <[email protected]> Subject: Re: [U2] UVODBC Connection Problem Message-ID: <4741aa93a2522549a72c9b6cc36c8e61076763d...@arnold.hkmetalcraft.local> Content-Type: text/plain; charset="iso-8859-1" Gary: It looks like we are close to victory. The two keys are UCI and Win-ODBC. What data are we trying to connect to? Is it /data/uvdbisizes? I do not know if lower-case is allowed for an account. There is a scrub option in HSADMIN which I believe exposes and massages the MV data into a format that ODBC-SQL can handle. I would run the HSADMIN-Scrub option on the data file. Also, I have found that if the UV data file is too big, UV-ODBC gags. We copy some lighter weight data to another account for integration with FedEx and UPS. For trouble shooting, consider creating a small file with some example data and try to connect to it. --Bill -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Chambers, Gary Sent: Tuesday, November 30, 2010 2:57 PM To: [email protected] Subject: [U2] UVODBC Connection Problem The short story on this trouble is, as a test, I cannot get a connection between my PC and one of our uv servers nor can I get a successful test of a connection to a data source in the ODBC admin client. Details: After configuring UniVerseODBC version 4.0.2 build 7149 on a Windows XP SP3 machine I am not able to make a successful connection to files in a UniVerse account running in UniVerse 10.1.20 on HP/UX B.11.23. This work was done according to steps described IBM's January 2002 Version 10.0 ODBC Guide with some reference to Rocket's uvodbc-v10r3.pdf as well. I have configured uvodbc.config via UCI Editor as well as manually. My data source is listed in the Windows' "ODBC Data Source Administrator" under User DSN the same as the samples. In seeking some measure of confidence I did circle back and try to get one of the samples to work with no luck as well. Both samples as well as my source list as 'active' via HS.ADMIN: HS.SALES /u1/uv/HS.SALES YES HS.SERVICE /u1/uv/HS.SERVICE YES uvdbsizes /data/uvdbsizes YES 3 records listed. At present via the ODBC Data Source Administration when I invoke a "Test Connection" for any of the three data sources I get this result that I can't get beyond: "[IBM][UVODBC][0301928]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLConnect[]; State: IM976; universe code: 0; Msg: [IBM][SQL Client]UCI Connections to non UniVerse databases is not allowed. If nothing else, if anyone could point me to the Rocket manual or Brian Leach's write-up on this subject has helpfully suggested by Bill Brutzman that may be helpful. I found this information in a message dated Tue Oct 26 Subject: [U2] PC setup for to use ODBC. Thank you for reading and considering. Gary Chambers UniVerse Systems Omnicare Information Solutions 4936 Blazer Parkway Dublin, Ohio 43017 (614) 652-3123 [email protected] [email protected] ? ? -- NOTICE -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material, the disclosure of which is governed by applicable law. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error please contact the sender and destroy the materials contained in this message. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 2 Date: Tue, 30 Nov 2010 15:29:02 -0500 From: Bill Brutzman <[email protected]> To: U2 Users List <[email protected]> Subject: Re: [U2] UVODBC Connection Problem Message-ID: <4741aa93a2522549a72c9b6cc36c8e61076763d...@arnold.hkmetalcraft.local> Content-Type: text/plain; charset="iso-8859-1" Some key notes from a Gary Smith eMail from some time ago... UniVerse Server Administration 1. List activated accounts 2. Show UniVerse ODBC Config configuration for an account 3. Activate access to files in an account 4. Deactivate access to files in an account 5. Run HS.SCRUB on a File/Table 6. Update File Information Cache in an account Which would you like? ( 1 - 6 ) ? 1) ODBC needs the Dict Items in the @SELECT dictionary item a. Create @SELECT dictionary item to contain the fields you want to report on. i. ED DICT PRODUCT @SELECT I - to Insert Line 1 : PH Line 2 : BR.HITS MAX.DAYS BUYPKG COMM.CODE PRICE.LINE BUY.LINE Line 3 : Hit enter to exit add lines FI to save to file 2) Setup the file for ODBC access so that the system knows about the new file( or change has been made) a. LOGTO HS.ADMIN b. HS.ADMIN c. Enter 6 to update d. Enter ECLIPSE.ODBC when asked for account name e. When complete hit enter to return to the menu f. Hit enter to exit to the menu Even though HS.SCRUB is important the most important is to do #6 reset cache. Also you said no field name were showing in the @SELECT variable? You will need to add those manually to that @SELECT dictionary item. Garry L. Smith Dir Info Systems Charles McMurray Company V# 559-292-5782 F# 559-346-6169 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Chambers, Gary Sent: Tuesday, November 30, 2010 2:57 PM To: [email protected] Subject: [U2] UVODBC Connection Problem The short story on this trouble is, as a test, I cannot get a connection between my PC and one of our uv servers nor can I get a successful test of a connection to a data source in the ODBC admin client. Details: After configuring UniVerseODBC version 4.0.2 build 7149 on a Windows XP SP3 machine I am not able to make a successful connection to files in a UniVerse account running in UniVerse 10.1.20 on HP/UX B.11.23. This work was done according to steps described IBM's January 2002 Version 10.0 ODBC Guide with some reference to Rocket's uvodbc-v10r3.pdf as well. I have configured uvodbc.config via UCI Editor as well as manually. My data source is listed in the Windows' "ODBC Data Source Administrator" under User DSN the same as the samples. In seeking some measure of confidence I did circle back and try to get one of the samples to work with no luck as well. Both samples as well as my source list as 'active' via HS.ADMIN: HS.SALES /u1/uv/HS.SALES YES HS.SERVICE /u1/uv/HS.SERVICE YES uvdbsizes /data/uvdbsizes YES 3 records listed. At present via the ODBC Data Source Administration when I invoke a "Test Connection" for any of the three data sources I get this result that I can't get beyond: "[IBM][UVODBC][0301928]Error ID: 46 Severity: ERROR Facility: DBCAPERR - UCI Error. Func: SQLConnect[]; State: IM976; universe code: 0; Msg: [IBM][SQL Client]UCI Connections to non UniVerse databases is not allowed. If nothing else, if anyone could point me to the Rocket manual or Brian Leach's write-up on this subject has helpfully suggested by Bill Brutzman that may be helpful. I found this information in a message dated Tue Oct 26 Subject: [U2] PC setup for to use ODBC. Thank you for reading and considering. Gary Chambers UniVerse Systems Omnicare Information Solutions 4936 Blazer Parkway Dublin, Ohio 43017 (614) 652-3123 [email protected] [email protected] ? ? -- NOTICE -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material, the disclosure of which is governed by applicable law. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error please contact the sender and destroy the materials contained in this message. _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 3 Date: Tue, 30 Nov 2010 17:36:06 -0800 From: "Don P. Nagai" <[email protected]> To: "'U2 Users List'" <[email protected]> Subject: [U2] Mac Connection to UniVerse Message-ID: <[email protected]> Content-Type: text/plain; charset="US-ASCII" Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse server via telnet? Thanks. Don ------------------------------ Message: 4 Date: Tue, 30 Nov 2010 21:02:43 -0500 From: Rob Sobers <[email protected]> To: U2 Users List <[email protected]> Subject: Re: [U2] Mac Connection to UniVerse Message-ID: <[email protected]> Content-Type: text/plain; charset=ISO-8859-1 Hey Don, I believe Dynamic Connect, wIntegrate, and the other client tools that Rocket makes are Windows only. Can you just use Mac's built in terminal to telnet or ssh to your UniVerse server? What type of terminal emulation does your server expect? Here are some resources that might help: http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS <http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS> http://www.macwise.com/ Regards, <http://superuser.com/questions/105009/most-efficient-terminal-emulator-for-unidata-universe-or-other-mv-based-systems>Rob Sobers http://accidentalhacker.com On Tue, Nov 30, 2010 at 8:36 PM, Don P. Nagai <[email protected]>wrote: > Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse > server via telnet? > > > > Thanks. > > > > Don > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > ------------------------------ Message: 5 Date: Tue, 30 Nov 2010 21:48:29 -0800 From: "Don P. Nagai" <[email protected]> To: "'U2 Users List'" <[email protected]> Subject: Re: [U2] Mac Connection to UniVerse Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" Actually I've never used a Mac so the "built in terminal" is news to me! We have a client that may decide to deploy a Mac or two so we'll give it a go. Thanks for the terminal emulator info as well. _____ From: [email protected] [mailto:[email protected]] On Behalf Of Rob Sobers Sent: Tuesday, November 30, 2010 6:03 PM To: U2 Users List Subject: Re: [U2] Mac Connection to UniVerse Hey Don, I believe Dynamic Connect, wIntegrate, and the other client tools that Rocket makes are Windows only. Can you just use Mac's built in terminal to telnet or ssh to your UniVerse server? What type of terminal emulation does your server expect? Here are some resources that might help: http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS <http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS> http://www.macwise.com/ Regards, <http://superuser.com/questions/105009/most-efficient-terminal-emulator-for- unidata-universe-or-other-mv-based-systems>Rob Sobers http://accidentalhacker.com On Tue, Nov 30, 2010 at 8:36 PM, Don P. Nagai <[email protected]>wrote: > Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse > server via telnet? > > > > Thanks. > > > > Don > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _____ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1170 / Virus Database: 426/3288 - Release Date: 11/29/10 ------------------------------ Message: 6 Date: Wed, 1 Dec 2010 17:57:25 +1100 From: "Brawn, Cameron" <[email protected]> To: "U2 Users List" <[email protected]> Subject: Re: [U2] Mac Connection to UniVerse Message-ID: <ffc62b9ab6db1c409fc8620c63ecc53209104...@celbonmx01.cellarmasters.local> Content-Type: text/plain; charset="us-ascii" We quite successfully use Apple's free, built in "Terminal" to access UniVerse and SB+ Current "Snow Leopard" (10.6) version of OSX is best, as it's far easier to program the function keys to suit. Cameron -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Don P. Nagai Sent: Wednesday, 1 December 2010 16:48 To: 'U2 Users List' Subject: Re: [U2] Mac Connection to UniVerse Actually I've never used a Mac so the "built in terminal" is news to me! We have a client that may decide to deploy a Mac or two so we'll give it a go. Thanks for the terminal emulator info as well. _____ From: [email protected] [mailto:[email protected]] On Behalf Of Rob Sobers Sent: Tuesday, November 30, 2010 6:03 PM To: U2 Users List Subject: Re: [U2] Mac Connection to UniVerse Hey Don, I believe Dynamic Connect, wIntegrate, and the other client tools that Rocket makes are Windows only. Can you just use Mac's built in terminal to telnet or ssh to your UniVerse server? What type of terminal emulation does your server expect? Here are some resources that might help: http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS <http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS> http://www.macwise.com/ Regards, <http://superuser.com/questions/105009/most-efficient-terminal-emulator- for- unidata-universe-or-other-mv-based-systems>Rob Sobers http://accidentalhacker.com On Tue, Nov 30, 2010 at 8:36 PM, Don P. Nagai <[email protected]>wrote: > Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse > server via telnet? > > > > Thanks. > > > > Don > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _____ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1170 / Virus Database: 426/3288 - Release Date: 11/29/10 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ ************************************************************************************** This email and any attachments may be confidential and legally privileged. Please notify the sender immediately if you received this message in error. Please do not delete or alter this notice. ************************************************************************************** ------------------------------ Message: 7 Date: Wed, 1 Dec 2010 10:36:27 -0500 From: "Glorfield, Gordon" <[email protected]> To: 'U2 Users List' <[email protected]> Subject: Re: [U2] Mac Connection to UniVerse Message-ID: <3f43c0819210b948846ae3f9931a0ef222ce01c...@ent-msg-cms1.vertisinc.net> Content-Type: text/plain; charset="us-ascii" Don, Carnation Software makes MacWise terminal emulator specifically designed for connecting to multi-dimensional databases such as U2. They provide emulations for a wide variety of terminals. See http://www.carnationsoftware.com/ for more information. Gordon Gordon J Glorfield | Software Application Developer | Vertis Communications 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664 | M 443-280-7093 [email protected] | http://www.vertisinc.com -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Don P. Nagai Sent: Wednesday, December 01, 2010 12:48 AM To: 'U2 Users List' Subject: Re: [U2] Mac Connection to UniVerse Actually I've never used a Mac so the "built in terminal" is news to me! We have a client that may decide to deploy a Mac or two so we'll give it a go. Thanks for the terminal emulator info as well. _____ From: [email protected] [mailto:[email protected]] On Behalf Of Rob Sobers Sent: Tuesday, November 30, 2010 6:03 PM To: U2 Users List Subject: Re: [U2] Mac Connection to UniVerse Hey Don, I believe Dynamic Connect, wIntegrate, and the other client tools that Rocket makes are Windows only. Can you just use Mac's built in terminal to telnet or ssh to your UniVerse server? What type of terminal emulation does your server expect? Here are some resources that might help: http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS <http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS> http://www.macwise.com/ Regards, <http://superuser.com/questions/105009/most-efficient-terminal-emulator-for- unidata-universe-or-other-mv-based-systems>Rob Sobers http://accidentalhacker.com On Tue, Nov 30, 2010 at 8:36 PM, Don P. Nagai <[email protected]>wrote: > Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse > server via telnet? > > > > Thanks. > > > > Don > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _____ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1170 / Virus Database: 426/3288 - Release Date: 11/29/10 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users ------------------------------ Message: 8 Date: Wed, 1 Dec 2010 08:25:36 -0800 From: "Don P. Nagai" <[email protected]> To: "'U2 Users List'" <[email protected]> Subject: Re: [U2] Mac Connection to UniVerse Message-ID: <[email protected]> Content-Type: text/plain; charset="US-ASCII" Thanks for all the suggestions for connecting a Mac to UniVerse. 'Much appreciated! ------------------------------ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users End of U2-Users Digest, Vol 20, Issue 1 *************************************** _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
