Re: [U2] Rgarding ED editor
the full Rocket Software documentation library is available at http://docs.rocketsoftware.com On Thu, Apr 17, 2014 at 2:47 AM, Shanmukh Nandha shanmukhnan...@gmail.comwrote: Hello Friends, Can any one help with ED editor docs in Unibasic Programming language Thank you, Shanmukh ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Debugging UNIX Segmentation Violations and Core Dumps (UV)
Robert, If you have a current maintenance contract with Rocket U2 you will be able to access this and many more resources from the Rocket Customer Portal. Neil Richards Sales Engineer Rocket Software On Thu, Feb 13, 2014 at 11:12 PM, Robert i...@keyway.net wrote: I received a copy of a CD, that has a lot of good information on it. It is labeled U2 Tech Support Survival Kit. It has some good documents and diagnostic utilities on it. Here is an example: IBM-U2 Data Management Solutions,Technical Support White Paper,Subject: Debugging UNIX Segmentation Violations and Core Dumps (UV) Anyone have a link to the latest equivalent of this CD on the Rocket Website? When I searched there was no mention on the Rocket website about SURVIVAL KIT. Thanks, Robert Norman ROBERT NORMAN AND ASSOCIATES 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 (323) 285-7272, (951) 541-1668 http://universe-basic-programming.webstarts.com http://users.keyway.net/~ice/index.html http://www.affordablemultivalueprogramming.i8.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Is anyone storing multi-byte names or addresses
Symeon, How are you storing unicode in your regular files? I thought to go multibyte you need to turn on NLS? From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen [syme...@gmail.com] Sent: Monday, September 13, 2010 8:50 AM To: 'U2 Users List' Subject: Re: [U2] [UV] Is anyone storing multi-byte names or addresses We do store multi byte stuff, the biggest issues we have are not in the storing but in its identification so that you can then transport and display it correctly, we often get the data in xml files so we need to know that the file has the correct character set definition, similarly the data is displayed in a browser via html so again we need to know that the correct character set is used, and certainly not mix character sets on one output, ascii/utf8 combination is fine, but you can get in knots if you start to combine iso8859-1 with utf8 as the characters 127-255 are single byte in iso8859-1 but double byte in utf8. In some ways utf8 is better than is08859-1 as you don't get the u umlout issue as character 253. You can of course mix character sets in your data, so long as you know what is what. -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: 13 September 2010 16:38 To: 'U2 Users List' Subject: [U2] [UV] Is anyone storing multi-byte names or addresses Hey, Just wondering how others have approached this - storing multi-byte names and addresses for non-English languages. I don't think we're approaching the demarcation line where an NLS implementation would be warranted, with the Administrative overhead that incurs. We are doing a lot more other language business though since we are opening more and more off-shore call centers, and have deployed multiple non English language websites. Our immediate need just relates to Name, and ship to / bill to addresses, such words as Mosiężno-Żelaznych. Thanks in advance for the always enlightening insights. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata - Hardware sizing for 550 telnet users
Manu, we have a similar system running Universe on AIX. I carved out the following LPAR from one our P560 frames. Ram 64GB, (48GB and 16GB Ramdisk) CPU 8 dual core cpus Disk 1TB (600GB in use) performance is stellar compared to our Oracle ERP systems which run on even more hardware. Neil From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes [...@infodata.lu] Sent: Friday, September 03, 2010 3:06 AM To: U2 Users List Subject: [U2] Unidata - Hardware sizing for 550 telnet users Hi group, This post to ask your opinion about the hardware sizing to serve this type of usage, within a IBM / AIX system : - Unidata unix - 550 telnet users - 100gb datafiles Any advise is welcome. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata - Hardware sizing for 550 telnet users
We use our ramdisk for special jobs that require some crunching of sales numbers. We basically copy our monthly sales files (which are distributed by month) into the ramdisk, run the jobs and recreate the partfiles for the month, re-index etc then copy the partfiles and indexes back. We took a weekly job that was taking about 16 hours down to less than 3 hours by doing the work on the ramdisk. btw our SAN is really fast, but the ramdisk is much faster. From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso [aalo...@quiter.com] Sent: Friday, September 03, 2010 10:23 AM To: U2 Users List Subject: Re: [U2] Unidata - Hardware sizing for 550 telnet users Hi Neil. May I ask you: how do you use the Ramdisk? As a temp directory? I'm very interested in improving performance this way... Thanks -- Augusto Alonso IT Manager QUITER SERVICIOS CENTRALES Zoco Gran Santander, 1ª planta - 39011 Santander - España Telf: +34 902233323 - Fax: +34 902234280 AVISO LEGAL: Este mensaje contiene información destinada exclusivamente al usuario de destino, pudiendo contener información confidencial o protegida legalmente. Si, por un error de envío o transmisión, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique de este hecho al remitente y no use, informe, distribuya, imprima, copie o difunda este mensaje bajo ningún medio . Cualquier opinión en él contenida, es exclusiva de su autor y no representa necesariamente la opinión de Quiter Servicios Centrales. LEGAL WARNING: This e-mail and any attachment, contain information intended solely for the addressee and may contain confidential information or legally protected data. If you are not the intended recipient, please notify the sender and do not use, disclose, distribute, copy, print or rely on this e-mail under any circumstances. The views and opinions expressed are the author´s own and do not necessarily reflect those of Quiter Servicios Centrales. 2010/9/3 Neil Richards n...@switp.commailto:n...@switp.com Manu, we have a similar system running Universe on AIX. I carved out the following LPAR from one our P560 frames. Ram 64GB, (48GB and 16GB Ramdisk) CPU 8 dual core cpus Disk 1TB (600GB in use) performance is stellar compared to our Oracle ERP systems which run on even more hardware. Neil From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [ u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes [ e...@infodata.lumailto:e...@infodata.lu] Sent: Friday, September 03, 2010 3:06 AM To: U2 Users List Subject: [U2] Unidata - Hardware sizing for 550 telnet users Hi group, This post to ask your opinion about the hardware sizing to serve this type of usage, within a IBM / AIX system : - Unidata unix - 550 telnet users - 100gb datafiles Any advise is welcome. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata - Hardware sizing for 550 telnet users
Yes that's the plus side of going Oracle for ERP. Now hardware looks cheap to run U2 From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald Sent: Friday, September 03, 2010 10:33 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata - Hardware sizing for 550 telnet users And even that is a lot of hardware for a U2 system. Look at the new p750 express boxes. They're at a pretty good price point (once you get those discounts from the vendor), and not a lot of hardware goes a long way with the new p7 chips. From: n...@switp.commailto:n...@switp.com To: u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org Date: Fri, 3 Sep 2010 10:10:06 -0700 Subject: Re: [U2] Unidata - Hardware sizing for 550 telnet users Manu, we have a similar system running Universe on AIX. I carved out the following LPAR from one our P560 frames. Ram 64GB, (48GB and 16GB Ramdisk) CPU 8 dual core cpus Disk 1TB (600GB in use) performance is stellar compared to our Oracle ERP systems which run on even more hardware. Neil From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes [...@infodata.lumailto:e...@infodata.lu] Sent: Friday, September 03, 2010 3:06 AM To: U2 Users List Subject: [U2] Unidata - Hardware sizing for 550 telnet users Hi group, This post to ask your opinion about the hardware sizing to serve this type of usage, within a IBM / AIX system : - Unidata unix - 550 telnet users - 100gb datafiles Any advise is welcome. Manu ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.orgmailto:u2-us...@listserver.u2ug.org%3e http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Strange...Not sure what it means.
looks like a NLS and unicode translation From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen [ggal...@wyanokegroup.com] Sent: Friday, August 13, 2010 9:01 AM To: U2 Users List Subject: [U2] Strange...Not sure what it means. ok. This is in UV 10 on Linux. Type at the ED VOC TESTXX1 TESTXX1 (yes, there is only one double quote on the second entry - I found this by forgetting the first) ED VOC TESTXX1 TESTXX1 SELECTed record name = TESTXX1. New record. : N SELECTed record name = TESTXX1^00311. New record. : N How does a () equate to ^00311 and what exactly is ^00311 ? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.commailto:ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
dont forget that if the file is distributed that it requires a trigger on each file part. From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny [jscha...@gmail.com] Sent: Friday, July 30, 2010 10:12 AM To: U2 Users List Subject: Re: [U2] Universe Triggers Thank You. Now I need to drop the trigger and re create it. What is the drop trigger syntax? Is all this actually documented somewhere? Barry Rutherford wrote: Your subroutine has to be globally cataloged - nothing else will work. The syntax of the create trigger that works for me is this: CREATE TRIGGER BEFORE_INSERT BEFORE INSERT ON (FILE NAME) FOR EACH ROW CALLING *(subroutine name) BEFORE_INSERT - name I gave my trigger - can be anything you want (FILE NAME) - File trigger is attached to *(subroutine name) - globally cataloged subroutine that you want called Your sample subroutine below has 15 passed-in parameters and my programs only have 14 - I think you repeated the last one twice. Do I need to open the file to the SQLTRIG variable in the program? - No Do I need to open the dictionary to SCHEMA? - No Barry Rutherford Programmer / Analyst MobilexUSA 930 Ridgebrook Rd, 3rd Floor Sparks, MD 21152 Local: 443-662-4101 x 6162 Toll Free: 800-786-8015 x 6162 Fax: 443-662-4225 http://www.mobilexusa.com -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, July 30, 2010 11:47 AM To: U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org Subject: [U2] Universe Triggers AIX 5.3 UV 10.2Universe I want to put a trigger on a file to send an email message then a new item is written. I have read the (very non-helpful) section on triggers in the Universe System Description documentation but I'm still a bit confused. I have a program (subroutine) written with the arguments as established in the manual: 0001: SUBROUTINE NEW_TRANSFER(SQLTRIG,SCHEMA,TABLE,EVENT,TIME,NEWID,NEWREC,OLD ID,OLDREC,ASSOC,ASSOC.EVENT,COUNT,CHAIN,CASCADE,CASCADE) Do I need to open the file to the SQLTRIG variable in the program? Do I need to open the dictionary to SCHEMA? I'm assuming that trigger_name below should be the catalog name of the program CREATE TRIGGER trigger_name [BEFORE | AFTER] INSERT Can someone provide a concise series of steps I need to take to set this up? -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Retrieving data from remote SQL DB from Universe via ODBC?
As you are AIX you will also need the ODBC clients for AIX which are not provided by Rocket Software or Universe. I use a product from fusionware www.fwic.nethttp://www.fwic.net called the legacy MV2SQL bridge thats provides fast read and write access to our SQL server or Oracle databases with minimal programming. I remember Robert Houben writing a blog on this subject at http://www.fwic.net/NewsInfo/FusionWareIntegrationBlogs/tabid/116/EntryId/6/Easy-access-to-SQL-data-from-MV-BASIC.aspx Neil From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester [jhes...@momtex.com] Sent: Wednesday, June 30, 2010 4:10 PM To: U2 Users List Subject: Re: [U2] Retrieving data from remote SQL DB from Universe via ODBC? Check out the UniVerse ODBC Guide included in the documentation on the UV installation media. If you don't have it, you can get it here: http://www.rocketsoftware.com/u2/pubs/library/ It's pretty straightforward. You'll also need the ODBC client available here: http://www.rocketsoftware.com/u2/downloads/ -John -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Wednesday, June 30, 2010 2:45 PM To: u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org Subject: [U2] Retrieving data from remote SQL DB from Universe via ODBC? Fellow U2 users, The Universe documentation suggests that it is possible to retrieve data from a remote SQL DB on a Windows server from Universe using ODBC. We do the reverse here at present, but haven't done what I am attempting. Can anyone verify or shed some light on how to do this, please? We have Universe 10.3 running on AIX and have ODBC in use. Thanks, Ken Ford, FirstMac Pty Ltd, Brisbane, QLD Australia. ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] A readnext within a VOC?
This capability is in UV 10.2 This example represents a paragraph as it appears in a VOC file: 001 PA 002 RUN BP DUE.LIST 003 DATA ENTER DATE 004 DATA YES 005 RUN BP VENDORS 006 DATA ENTER MONTH From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum [andyb...@yahoo.co.uk] Sent: Thursday, December 10, 2009 1:06 PM To: U2 Users List Subject: Re: [U2] A readnext within a VOC? George, This was possible in PI/Open using PA GET-LIST LISTNAME LOOP IF L, ID = THEN GO NEXT RUN LIB PROGRAMNAME DATA ID REPEAT NEXT: Unfortunately this never made it in to Universe, don't know about Unidata. I reported this when I beta tested the PI/Open to Universe migration stuff,I think they 'fixed it' by documenting somewhere that it doesn't work. Cheers, Andy - Original Message From: George Gallen ggal...@wyanokegroup.commailto:ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org Sent: Thu, 10 December, 2009 19:03:08 Subject: [U2] A readnext within a VOC? I'd like to setup a VOC to select a list, then run a program for each entry in the list (like below...) PA GET-LIST LISTNAME LOOP READNEXT ID ELSE EXIT DATA ID RUN LIB PROGRAMNAME REPEAT I Thought there was a way to do this...but just can't remember how. In the meantime, I pass the list to another program (on another channel) which reads each item and EXECUTEs the PROGRAMNAME George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.commailto:ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Total Control Panel Loginhttps://asp-6.reflexion.net/login?domain=switp.com To: n...@switp.comhttps://asp-6.reflexion.net/address-properties?aID=46755898 From: u2-users-boun...@listserver.u2ug.orghttps://asp-6.reflexion.net/address-properties?aID=60327323 Removehttps://asp-6.reflexion.net/FooterAction?ver=1un-wl-sender-address=1rID=46755898aID=60327323 this sender from my allow list You received this message because the sender is on your allow list. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] A readnext within a VOC?
yep, you are quite right, must learn to read everything before replying Neil From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum [andyb...@yahoo.co.uk] Sent: Thursday, December 10, 2009 1:22 PM To: U2 Users List Subject: Re: [U2] A readnext within a VOC? Neil, The specific request was to be able to process each item in a select list from within a Paragraph which is what the 'L' option of inline prompting did in PI/Open, unfortunately this has not been implemented in Universe. Cheers, Andy - Original Message From: Neil Richards n...@switp.commailto:n...@switp.com To: U2 Users List u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org Sent: Thu, 10 December, 2009 21:13:08 Subject: Re: [U2] A readnext within a VOC? This capability is in UV 10.2 This example represents a paragraph as it appears in a VOC file: 001 PA 002 RUN BP DUE.LIST 003 DATA ENTER DATE 004 DATA YES 005 RUN BP VENDORS 006 DATA ENTER MONTH From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum [andyb...@yahoo.co.ukmailto:andyb...@yahoo.co.uk] Sent: Thursday, December 10, 2009 1:06 PM To: U2 Users List Subject: Re: [U2] A readnext within a VOC? George, This was possible in PI/Open using PA GET-LIST LISTNAME LOOP IF L, ID = THEN GO NEXT RUN LIB PROGRAMNAME DATA ID REPEAT NEXT: Unfortunately this never made it in to Universe, don't know about Unidata. I reported this when I beta tested the PI/Open to Universe migration stuff,I think they 'fixed it' by documenting somewhere that it doesn't work. Cheers, Andy - Original Message From: George Gallen ggal...@wyanokegroup.commailto:ggal...@wyanokegroup.commailto:ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org Sent: Thu, 10 December, 2009 19:03:08 Subject: [U2] A readnext within a VOC? I'd like to setup a VOC to select a list, then run a program for each entry in the list (like below...) PA GET-LIST LISTNAME LOOP READNEXT ID ELSE EXIT DATA ID RUN LIB PROGRAMNAME REPEAT I Thought there was a way to do this...but just can't remember how. In the meantime, I pass the list to another program (on another channel) which reads each item and EXECUTEs the PROGRAMNAME George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.commailto:ggal...@wyanokegroup.commailto:ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Total Control Panel Loginhttps://asp-6.reflexion.net/login?domain=switp.com To: n...@switp.commailto:n...@switp.comhttps://asp-6.reflexion.net/address-properties?aID=46755898 From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.orghttps://asp-6.reflexion.net/address-properties?aID=60327323 Removehttps://asp-6.reflexion.net/FooterAction?ver=1un-wl-sender-address=1rID=46755898aID=60327323 this sender from my allow list You received this message because the sender is on your allow list. ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Total Control Panel Loginhttps://asp-6.reflexion.net/login?domain=switp.com To: n...@switp.comhttps://asp-6.reflexion.net/address-properties?aID=46755898 From: u2-users-boun...@listserver.u2ug.orghttps://asp-6.reflexion.net/address-properties?aID=60327323 Removehttps://asp-6.reflexion.net/FooterAction?ver=1un-wl-sender-address=1rID=46755898aID=60327323 this sender from my allow list You received this message because the sender is on your allow list. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] BCI Connectivity
which user did you install Universe as. They become the user with SQL DBA rights. Check the UV_USERS file which is documented in the SQL Catalog section of the SQLREF guide root needs DBAuth permission to be in this file. Hope this guides you down the right path in resolving and understanding the SQL user setup Neil From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill [bi...@hkmetalcraft.com] Sent: Wednesday, December 09, 2009 3:58 PM To: U2 Users List Subject: Re: [U2] [UV] BCI Connectivity I found a VMark article... written by Brian Leach... for UniData indicating... Send an eMail to Vmark for UniVerse info. Is the referenced companion article for UniVerse available. I am struggling with setting up BCI on our HP-Ux machine. I have the IBM 10.3 BASIC SQL Client Interface Guide but some of the configuration is unClear to me. When I try to connect, I get the following error... # cd /usr/ibm/uv/sql/catalog # /usr/ibm/uv/bin/uv UniVerse Command Language 10.1 (c) Copyright IBM Corporation 2003. All rights reserved. catalog logged on: Wed Dec 9 18:49:15 2009 GRANT CONNECT TO brutzy SQL+ UniVerse/SQL: root does not have DBA privilege. Also, the settings in LOGTO UV uv are unClear. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Total Control Panel Loginhttps://asp-6.reflexion.net/login?domain=switp.com To: n...@switp.comhttps://asp-6.reflexion.net/address-properties?aID=46755898 From: u2-users-boun...@listserver.u2ug.orghttps://asp-6.reflexion.net/address-properties?aID=60327323 Removehttps://asp-6.reflexion.net/FooterAction?ver=1un-wl-sender-address=1rID=46755898aID=60327323 this sender from my allow list You received this message because the sender is on your allow list. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] ODBC + UPS
Take a look at the BCI reference manual The UniVerse BASIC SQL Client Interface is an application programming interface (API) that makes UniVerse a client in a client/server environment. The server data source can be either: A local or remote UniVerse database A relational DBMS such as INFORMIX, SYBASE, or DB2 You use the SQL Client Interface to connect to one or more data sources. ODBC Data Sources To connect to an ODBC data source, an ODBC driver manager and suitable ODBC drivers for the data sources you want to connect to must be installed on the client system. Once connected to any data source, the SQL Client Interface lets you read data from and write data to the data source. Your application program can access the capabilities of the server DBMS Hope this helps Neil From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill [bi...@hkmetalcraft.com] Sent: Tuesday, December 01, 2009 1:08 PM To: U2 Users List Subject: [U2] [UV] ODBC + UPS I can read via ODBC from UniVerse to a Windows PC. Is it possible to write ODBC? I am trying to do an export from United Parcel Service WorldShip. When I try to setup a simple export map link in WorldShip, WorldShip comes back with an error. Help would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Total Control Panel Loginhttps://asp-6.reflexion.net/login?domain=switp.com To: n...@switp.comhttps://asp-6.reflexion.net/address-properties?aID=46755898 From: u2-users-boun...@listserver.u2ug.orghttps://asp-6.reflexion.net/address-properties?aID=60327323 Message Score: 50 High (60): Pass My Spam Blocking Level: Medium Medium (75): Pass Low (90): Pass Blockhttps://asp-6.reflexion.net/FooterAction?ver=1bl-sender-address=1rID=46755898aID=60327323 this sender / Blockhttps://asp-6.reflexion.net/FooterAction?ver=1ent=1bl-sender-address=1rID=46755898aID=60327323 this sender enterprise-wide Blockhttps://asp-6.reflexion.net/FooterAction?ver=1bl-sender-domain=1rID=46755898aID=60327323 listserver.u2ug.org / Blockhttps://asp-6.reflexion.net/FooterAction?ver=1ent=1bl-sender-domain=1rID=46755898aID=60327323 listserver.u2ug.org enterprise-wide This message was delivered because the content filter score did not exceed your filter level. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uucp
The Index's on Universe are held in a seperate directory and are not part of the file you are moving I would grab the following files to transfer also watch for the type 30 files as they too are directories filename I_filename D_filename Neil From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of David A Barrett [dave.barr...@lawpro.ca] Sent: Monday, November 23, 2009 8:19 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uucp UUCP is definitely old-fashioned. The best approach (in my opinion) is to NFS mount the file systems from the production server onto the test server, then use some utility to copy the raw files over. We use cpio. The syntax is something like this (run on the test server): mount -r ProductionServer:/u1 /mnt cd /mnt rm -r /u1/* find . -depth -print | cpio -pd /u1 Runs fast, works like a charm. The only caveat is that the cpio is oblivious to UV access to the data files, and if they are large and people are accessing the files while the cpio is running, you will run the risk of GFE's. We've got about 50GB worth of data, and I run it at night and we don't have any problems. It seems to take an hour or so to complete. I'm not sure why, but sometimes the indexes need to be rebuilt on the test server when it's all done. If you really, really need to get past the live access/GFE issue with a monster file or two, I'd suggest turning off the flag that prevents NFS access to files without UVNet, then create an empty file the test server, fiddle up a VOC entry for the live file and use the UV COPY command to pull the records over. Finally, the toughest part about setting it up is sorting through the security stuff to get the NFS mount to work. It's tough enough to do in Unix, beats me how you do it in AIX. Dave Barrett Project Manager, Lawyers' Professional Indemnity Company (LAWPRO®) 250 Yonge Street, Suite 3101, P.O. Box 3 Toronto, Ontario M5B 2L7 Tel: 416-598-5872 Fax: 416-599-8341 This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please delete it and advise me (by return e-mail or otherwise) immediately. Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez le supprimer et m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen. ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Total Control Panel Loginhttps://asp-6.reflexion.net/login?domain=switp.com To: n...@switp.comhttps://asp-6.reflexion.net/address-properties?aID=46755898 From: u2-users-boun...@listserver.u2ug.orghttps://asp-6.reflexion.net/address-properties?aID=60327323 Message Score: 50 High (60): Pass My Spam Blocking Level: Medium Medium (75): Pass Low (90): Pass Blockhttps://asp-6.reflexion.net/FooterAction?ver=1bl-sender-address=1rID=46755898aID=60327323 this sender / Blockhttps://asp-6.reflexion.net/FooterAction?ver=1ent=1bl-sender-address=1rID=46755898aID=60327323 this sender enterprise-wide Blockhttps://asp-6.reflexion.net/FooterAction?ver=1bl-sender-domain=1rID=46755898aID=60327323 listserver.u2ug.org / Blockhttps://asp-6.reflexion.net/FooterAction?ver=1ent=1bl-sender-domain=1rID=46755898aID=60327323 listserver.u2ug.org enterprise-wide This message was delivered because the content filter score did not exceed your filter level. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users