RE: [U2] [UD] ODBC TIMEOUT question
I checked the unirpcservices and it is set to the default of 6 minutes for all of its values. So it doesn't seem to be doing what I need either. Thanks anyway. Arthur Metherall Courier Corporation On 06/03/07, Symeon Breen [EMAIL PROTECTED] wrote: You can change the timeouts in the unirpcservices file. However if your VB app is not coded to accept the exception/error of a timedout connection object you may get into trouble. unirpcservices is in /usr/unishared/unirpc on *nix - there is documentation on what to change. Rgds Symeon. On 05/03/07, Metherall, Arthur [EMAIL PROTECTED] wrote: Hello, I'm running a VB read-only application that connects into UniData 6.0.8 on an IBM AIX 4.3.3, using ODBC. My problem is that we keep running out of user licenses on UniData. I have TIMEOUT set in the VOC-LOGIN, but that doesn't seem to effect the ODBC logins. Is there a way in UniData and/or Unix to set an ODBC TIMEOUT, without having to mess with the VB source code? Thanks, Arthur E. Metherall Courier Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] ODBC TIMEOUT question
Hello, I'm running a VB read-only application that connects into UniData 6.0.8 on an IBM AIX 4.3.3, using ODBC. My problem is that we keep running out of user licenses on UniData. I have TIMEOUT set in the VOC-LOGIN, but that doesn't seem to effect the ODBC logins. Is there a way in UniData and/or Unix to set an ODBC TIMEOUT, without having to mess with the VB source code? Thanks, Arthur E. Metherall Courier Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: U2 Users Digest V1 #1283
We're running VERCOM's PRIMAC and everything is PROC based. I, also, have an old photocopied Microdata PROC Programming Manual [#82-1074] (with page 120 missing). Prior to finding this manual I used the following websites, in an effort to understand what an existing proc is/was doing: - Raining Data - Online Technical Manual http://www.rainingdata.com/support/techpubs2/apprm013.html - Microdata REALITY (3.0 Series) Proc Batch Programming Manual http://www.bitsavers.org/pdf/microdata/771044_realityProcBatch_77.pdf *** Did some poking but I couldn't find the PROC Programming Manual (which is much better) - Malcolm Bull - PROC Online Technical Manual http://members.aol.com/mbtpublish/mmp214.html *** This one doesn't seem to work anymore (was the best) *** Does someone know where it went?? - Also, PROC Guidelines might help with the format and structure http://www.mindspring.com/~tpackert/pguide.htm I hope these help. PROC seems to be a blackhole within UniData, it still exists but there is NO supported documentation. -- Arthur Metherall Sr. Programmer/Analyst Courier Corporation -- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 08, 2006 12:50 PM To: U2 Subject: [U2] Unidata proc manual Has anyone ever seen a unidata proc manual? I can't find any reference, other than some information on user exits - -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.7/411 - Release Date: 8/7/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata proc manual
We're running VERCOM's PRIMAC and everything is PROC based. I, also, have an old photocopied Microdata PROC Programming Manual [#82-1074] (with page 120 missing). Prior to finding this manual I used the following websites, in an effort to understand what an existing proc is/was doing: - Raining Data - Online Technical Manual http://www.rainingdata.com/support/techpubs2/apprm013.html - Microdata REALITY (3.0 Series) Proc Batch Programming Manual http://www.bitsavers.org/pdf/microdata/771044_realityProcBatch_77.pdf *** Did some poking but I couldn't find the PROC Programming Manual (which is much better) - Malcolm Bull - PROC Online Technical Manual http://members.aol.com/mbtpublish/mmp214.html *** This one doesn't seem to work anymore (was the best) *** Does someone know where it went?? - Also, PROC Guidelines might help with the format and structure http://www.mindspring.com/~tpackert/pguide.htm I hope these help. PROC seems to be a blackhole within UniData, it still exists but there is NO supported documentation. -- Arthur Metherall Sr. Programmer/Analyst Courier Corporation -- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, August 08, 2006 12:50 PM To: U2 Subject: [U2] Unidata proc manual Has anyone ever seen a unidata proc manual? I can't find any reference, other than some information on user exits - -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.7/411 - Release Date: 8/7/2006 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UD] XML levels question
I have a Purchase Order XML file that I need to load into UniData, the problem is that it has 4 levels to it. I can read it to the SVM level (3) with the extraction file, but what do I do about level 4? I tried using two extraction files, one for the 'Header' information. And one for the 'Detail' (line item) information, this way it only goes to 3 levels. But, it won't create a separate record ID for each (multiple) Line Number in the UniData file. Is this possible? If not I'm still stuck back at 4 levels. Here's my system info/versions: Hardware : IBM Operating system : AIX O.S. version : 4.3.3 UniData version : 6.0.8 Thanks, in advance. -Arthur Arthur E. Metherall Sr. Programmer Analyst Courier Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] Separate catalog space 2 instances of Unidata installed
Andy, We have 3 instances of UniData running on a DEC Alpha and IBM AIX boxes. We created 3 unix directories '/usr/ud60/ud60dev', '/usr/ud60/ud60qa', and '/usr/ud60/ud60pc' and within them created symbolic links back to the '/usr/ud60' directories so the only 'real' subdirectory in the '/usr/ud60/ud60xx' directories is 'sys'. We created it as a copy of the /usr/ud60/sys directory. When a user logs in the .profile prompts for what UniData account to use, and then it sets the UDTHOME environment variable to the '/usr/ud60/ud60xx' directory. The UDTBIN variable is set to '/usr/ud60/bin'. It then cd's to the UniData account and executes UDT. The VOC in each of the accounts uses @UDTHOME, including Production so we can easily refresh the test accounts, instead of referencing '/usr/ud60'. It sounds harder than it really is. Good Luck, Arthur - - - - - - - - - - Arthur Metherall Courier Corporation - - - - - - - - - - -Original Message- Date: Thu, 19 Jan 2006 06:00:14 -0500 From: Andy Pflueger [EMAIL PROTECTED] Subject: [U2] [UD] Separate catalog space 2 instances of Unidata installed Hi, We are in the early planning stages of building a new dev/test box and would like some feedback on how best to setup Unidata with 2 instances (dev test) with separate catalog spaces as an ultimate goal. Is this even possible on the same box? Oh, and we're planning to goto Unidata 7.1.0 on this new box as well which will run Solaris 8. I was hoping someone out there has done this and could send some simple procedures on how to make this happen...or should I just RTM as I haven't honestly done that yet. :-) Thanks in advance, Andy Pflueger Application Developer Ivy Hill - Louisville, KY - -- The Linux philosophy is 'Laugh in the face of danger'. Oops. Wrong One. 'Do it yourself'. Yes, that's it. Linus Torvalds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] SBClient 5.2.4 Downloads
Hello, We're running SBClient 5.2.4 / UniData 6.0.8 on and IBM AIX unix 4.3.3 platform. Some of our UniBasic programs we download output file straight to the users pc using the SBClient TU.PC.DOWNLOAD routine. My question/problem is: How do I get rid of the 'filename' line that gets inserted into the first line of the downloaded file? None of the options seem to prevent this. Thanks, Arthur - - - - - - - - - - Arthur Metherall Courier Corporation - - - - - - - - - - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] pgsql and unidata basic
Jeff, I'm not sure how different postgresql is from MSSQL or where its installed (OS) but, you'll probably need to 'acquire' a 3rd party software in order to access non-unix databases from unix. We're running AIX 4.3.3 and have found Easysoft ODBC-ODBC Bridge software to be great for both reads and updates from UniData 6.0.8! Check out their website at www.easysoft.com, their inexpensive especially compared to certain other 3rd parties. It's easy to install and setup. Contact me off list if you have any questions. Hope this is helpful, Arthur - - - - - - - - - - Arthur Metherall Courier Corporation - - - - - - - - - - -Original Message- Date: Wed, 14 Dec 2005 08:01:58 -0600 From: Jeff Powell [EMAIL PROTECTED] Subject: [U2] pgsql and unidata basic Is there a way to execute queries to a postgresql database from within a unibasic program? I want to have our pick ticket print routine insert records into a pgsql table. Our system is an IBM RS6000 running AIX 5.3, UniData 6.0, SystemBuilder 5.3.8 and Prelude ADS v18.1. Thanks in advance for any advice. Jeff u2-users-digest 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: U2 Users Digest V1 #928
Andy, We had a similar problem here with UniData. Even though the user had unix 'secondary' group access to the data files, UDODBC did not look beyond the unix 'primary' group access. Once we changed the users to match the unix 'primary' group access of the data file(s), the error went away and the ODBC logins connected. We found this because some users could login and other couldn't. -Arthur - - - - - - - - - - Arthur Metherall Courier Corporation - - - - - - - - - - -Original Message- Date: Fri, 18 Nov 2005 09:59:31 - From: Andy Moore [EMAIL PROTECTED] Subject: [U2] UVODBC not recognising users on AIX 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 all, I have the UVODBC running on Universe on an AIX server and am trying to connect to it using the same username and password that I can telnet on to the machine with. I am getting an error message stating that the login is not correct. UniVerse ODBC configuration test failed. [IBM][UVODBC][0301892]Error ID: 124 Severity: SEVER Facility: LINKERR - Could not start server. rexecd: 0826-604 The login is not correct. I know that if this occurs on a Windows server I just put the domain in front of the username, but that doesn't seem to be required here. Do I need to do anything permissions wise to the user for it to connect via UVODBC? Is there anything permission wise on AIX that I a missing? I know the port's not firewalled as I can telnet the IP address on port 512 and it accepts my connection. Any suggestions? Thanks Andy Moore Selima Software Tel : 0114 2815000 Fax : 0114 281 Support : http://www.tracker.selima.co.uk Forum : http://forum.selima.co.uk --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] connection from UniBasic to a SQL database [was What are you using to develop your web pages...] {Unclassified}
Wendy,
Not sure I cut your original message out of the messages correctly, but here
goes.
As someone else mentioned for unix you need to 'acquire' 3rd party software
in order to access non-unix databases from unix, i.e., MS SQL, Oracle, Sybase,
etc.
We're running AIX and have found Easysoft ODBC-ODBC Bridge software to be
great! (granted we're only pulling information from MS SQL into UniData, but
that's ALL we need it for.)
Check out their website at www.easysoft.com, their inexpensive especially
compared to certain other 3rd parties.
It's easy to install and setup. Contact me off list if you have any questions.
Hope this is helpful,
Arthur
Arthur Metherall
Courier Corporation
-Original Message-
From: [EMAIL PROTECTED] On Behalf Of Wendy Smoak
Sent: Friday, 14 October 2005 09:10
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] connection from UniBasic to a SQL database [was What are you
using to develop your web pages...] {Unclassified}
We're on HP-UX. At the moment I'm reading from Sybase with their JDBC
driver then using UniObjects for Java to write records into UniData.
It's working fine, but it would be
*really* nice to connect directly to Sybase from a UniBasic program.
--
Wendy Smoak
---
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Parsing XML
Jeff, Depending on the release of UniData 6.0, or 6.1 (7.? not sure haven't seen it) the UniData preparation is some what different between versions: UDT 6.0 You need to create a Extraction file definition (see chapter(s) 10-Using UniQuery, or 14-Using Unidata the chapters are identical) Then use UniQuery commands like PREPARE.XML, LIST XMLDATA, and RELEASE.XML or use UniBASIC commands like PrepareXML, OpenXMLData, ReadXMLData, CLOSEXMLDATA, and RELEASEXML (case is important!) UDT 6.1 Create a Mapping File (see chapter 6-UniBasic Extensions) Then use the above commands If your running 6.0; my advice is, once your head stops pounding from reading the 6.0 manual, read thru the 6.1 manual. It's explained a little better/clearer. Once you have the Extraction/Mapping file built its pretty easy. Hope this helps. -Arthur - - - - - - - - - - Arthur Metherall Courier Corporation Sr. Programmer/Analyst - - - - - - - - - - -Original Message- -- Date: Tue, 4 Oct 2005 09:52:09 -0400 From: Jeffrey Butera [EMAIL PROTECTED] Subject: [U2] Parsing XML I know there are native tools in Unidata to output XML datasets. However, can anyone shed light on tools (custom or native) to read/parse XML data? - -- Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML question on UniData 6.0
Hello, Sorry I wasn't clear. Yes, I want to load a single UniData internal or external date field from the XML date fields. Instead of having to save them as three individual fields and then combine them in an I-Type or doing it inside my UniBasic program. How do I need to define my Unidata 6.0 XML extraction file to do this? Thanks. - - - - - - - - - - - - Arthur E. Metherall Sr. Programmer Analyst Courier Corporation - - - - - - - - - - - - -Original Message- From: Metherall, Arthur Sent: Monday, September 19, 2005 10:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] XML question on UniData 6.0 Yes, you've read this before. But all the XML experts must have been on vacation, so I'm posting it again in hopes that they 're back. Is there a way to define the following XML section in a Unidata 6.0 extraction file, so that it will give me a single date (07/20/2005) value/DICT entry, without having to define individual Month (07), Day(20), Year(2005) DICT items and then using an I-Type to rebuild it? BusinessAcknowledgementDate Date Year2005/Year Month07/Month Day20/Day /Date Time14:47:45/Time /BusinessAcknowledgementDate This is a predetermined XML format for handling dates with our customers, I can't change the structure. Thanks, Arthur - - - - - - - - - - - - Arthur E. Metherall Sr. Programmer Analyst Courier Corporation - - - - - - - - - - - - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] XML question on UniData 6.0
Yes, you've read this before. But all the XML experts must have been on vacation, so I'm posting it again in hopes that they 're back. Is there a way to define the following XML section in a Unidata 6.0 extraction file, so that it will give me a single date (07/20/2005) value/DICT entry, without having to define individual Month (07), Day(20), Year(2005) DICT items and then using an I-Type to rebuild it? BusinessAcknowledgementDate Date Year2005/Year Month07/Month Day20/Day /Date Time14:47:45/Time /BusinessAcknowledgementDate This is a predetermined XML format for handling dates with our customers, I can't change the structure. Thanks, Arthur - - - - - - - - - - - - - Arthur E. Metherall Sr. Programmer Analyst Courier Corporation - - - - - - - - - - - - - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] XML question on UniData 6.0
Is there a way to define the following XML section in a Unidata 6.0 extraction file, so that it will give me a single date (07/20/2005) value/DICT entry, without having to define individual Month (07), Day(20), Year(2005) DICT items? BusinessAcknowledgementDate Date Year2005/Year Month07/Month Day20/Day /Date Time14:47:45/Time /BusinessAcknowledgementDate This is a predetermined XML format for handling dates with our customer, I can't change the structure. Thanks, Arthur - - - - - - - - - - - - Arthur E. Metherall Sr. Programmer Analyst Courier Corporation - - - - - - - - - - - - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Connecting SQL server from Universe
We're using Easysoft ODBC-ODBC-Bridge, on our AIX using UniData connecting to MSSQL 2K, for database inquiries. I don't see why it wouldn't work for uniVerse also, you would just need write UVBASIC code to use GCI/BCI? to interface with the ODBC driver. The code is pretty simple, with BCI at least. This might be easier than trying to learn XML, if you don't already know/use it. -Arthur - - - - - - - - - - - - Arthur E. Metherall Sr. Programmer Analyst Courier Corporation - - - - - - - - - - - - -Original Message- Date: Mon, 25 Jul 2005 11:03:44 -0500 From: Yang, Songying, JIMS [EMAIL PROTECTED] Subject: [U2] Connecting SQL server from Universe Hello all, We are trying to connect to MSSQL server from Universe Database Server (currently we are using Universe 10.1.7 on Aix 5.2). Doesn't anybody have experiences in that? Thanks, Songying Yang Johnson County Court, KS --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Installing Easysoft ODBC-ODBC-Bridge on AIX
Thanks Tim and Geoff. I have fixed the LIBPATH typo, but I'm still getting the problem going into UniData. exec(): 0509-036 Cannot load program udt because of the following errors: 0509-150 Dependent module /usr/local/easysoft/unixODBC/lib/libodbc.a(odbc.so) could not be loaded. 0509-152 Member odbc.so is not found in archive I know I had to run makeudt on our old system (Dec Tru64/UDT5.2), with a change in the base.mk replacing ODBC_LIBS with the proper path for the DataDirect library. ODBC_LIBS = -lbcidummy If that is needed again, I've got 3 Easysoft libraries now and the base.mk file is different ODBC_LIBS = -L/.udlibs -lodbc Thanks, Arthur - - - - - - - - - - Arthur Metherall Courier Corporation 978-251-6213 - - - - - - - - - - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 03, 2005 4:05 AM To: [EMAIL PROTECTED] Subject: U2 Users Digest V1 #639 -- Date: Mon, 2 May 2005 17:42:48 -0400 From: Metherall, Arthur [EMAIL PROTECTED] Subject: [U2] Installing Easysoft ODBC-ODBC-Bridge on AIX I'm trying to install the Easysoft ODBC-ODBC-Bridge on an AIX system. Has anyone done this? When I define LIBPATH with the Easysoft libraries, for the Easysoft tests to work, UniData won't run. $ LIBPATH='$LIBPATH:/usr/local/easysoft/lib:/usr/local/easysoft/oob/client:/usr/local/easysoft/unixODBC/lib:/usr/lib:/lib' $ export LIBPATH $ udt exec(): 0509-036 Cannot load program udt because of the following errors: 0509-150 Dependent module /usr/local/easysoft/unixODBC/lib/libodbc.a(odbc.so) could not be loaded. 0509-152 Member odbc.so is not found in archive I know on our old Tru64 system, running a free HP DataDirect ODBC drivers, I had to recompile UniData. Would I do the same on AIX adding the Easysoft libraries to the makeudt? Thanks, Arthur - - - - - - - - - - - Arthur Metherall Courier Corporation - - - - - - - - - - - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Installing Easysoft ODBC-ODBC-Bridge on AIX
I'm trying to install the Easysoft ODBC-ODBC-Bridge on an AIX system. Has anyone done this? When I define LIBPATH with the Easysoft libraries, for the Easysoft tests to work, UniData won't run. $ LIBPATH='$LIBPATH:/usr/local/easysoft/lib:/usr/local/easysoft/oob/client:/usr/local/easysoft/unixODBC/lib:/usr/lib:/lib' $ export LIBPATH $ udt exec(): 0509-036 Cannot load program udt because of the following errors: 0509-150 Dependent module /usr/local/easysoft/unixODBC/lib/libodbc.a(odbc.so) could not be loaded. 0509-152 Member odbc.so is not found in archive I know on our old Tru64 system, running a free HP DataDirect ODBC drivers, I had to recompile UniData. Would I do the same on AIX adding the Easysoft libraries to the makeudt? Thanks, Arthur - - - - - - - - - - Arthur Metherall Courier Corporation - - - - - - - - - - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: ODBC driver for accessing MS-SQL from AIX running unix
Stuart, We're currently running 5.2 on an HP Tru64 system currently, and we are upgrading to 6.x on an IBM AIX system shortly. We already have all the programs written using a DataDirect ODBC interface, which was proved free of charge from HP. IBM does not make the same offer. So we're looking for a new less costly driver that will basically be plug and play, without having to rewrite everything and learn an additional set of tools. Thanks for the input though, and we'll probably look into at a later point. Accessing some of our other SQL databases through HTML would be quite helpful. -Arthur -Original Message- Date: Wed, 2 Mar 2005 15:52:19 +1100 From: [EMAIL PROTECTED] Subject: RE: [U2] ODBC driver for accessing MS-SQL from AIX running unix Arthur, If you're up to it, have a look at using the IIS interface SQLXML. If you are using a release of U2 which supports http functions then there's nothing to install on the U2 side. It basically just needs to have the interface set up under SQL. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/intro_3tbm.asp Data can be retrieved as easily as: url = 'http://sqlsvr/u2source'?SQL=select%20*%20from%20mytable%20for%20xml%20auto' crt createRequest(url,'GET',sessionHandle) crt submitRequest(sessionHandle,1,'',httpHeaders,response,httpStatus) *// optionally use the u2 xml functions or hard-parse the returned xml in response. It's pretty efficient too. A quick test on a sql server sitting on the other side of our DMZ took 3 minutes to write a program and 2.5 secs to return 10mb of data. Cheers, Stuart - -Original Message- Metherall, Arthur Hello, Is anyone using a unix ODBC driver, other than DataDirect, that can be installed onto an AIX box that will connect to MS-SQL 2000? I need to pull information from the MS-SQL 2000 database into my UniData environment for reporting using BCI. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] ODBC driver for accessing MS-SQL from AIX running unix
Hello, Is anyone using a unix ODBC driver, other than DataDirect, that can be installed onto an AIX box that will connect to MS-SQL 2000? I need to pull information from the MS-SQL 2000 database into my UniData environment for reporting using BCI. Thanks, Arthur - - - - - - - - - - Arthur Metherall Courier Corporation 978-251-6213 - - - - - - - - - - --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
