Re: [U2] [UV] QSELECT in transaction

2006-07-31 Thread Mark Cornelissen
Assuming we're talking about uniVerse (and not uniData): PERFORM is a different command. EXECUTE creates it's own execution environment, where PERFORM does not. This means that with PERFORM you can do a series of SELECT statements in the following way: PERFORM SELECT ANIMAL WITH SPECIES =

RE: [U2] Replication Between Unidata and MySQL

2006-07-31 Thread Brian Leach
Kevin I'd go for a 'keep it simple' approach. First, create three data files on UniData: SYNC_TARGETS, SYNC_ACTIONS and SYNC_ERRORS. - The SYNC_TARGETS defines a table or entity to update, including insert and delete commands (Update=delete+insert) and a list of column positions to substitute.

[U2] [UV] exit status and @SYSTEM.RETURN.CODE

2006-07-31 Thread phil walker
I am calling a UniVerse BASIC program TEST from the UNIX command prompt using the following command 'uv TEST' which sets @SYSTEM.RETURN.CODE to various values. I was hoping to be able to check the exit status of the uv command thinking that @SYSTEM.RETURN.CODE may be used to set the exit status,

[U2] [UV] QSELECT in transaction

2006-07-31 Thread Brian Whitehorn
Whats slightly confusing / inconsistent is that an EXECUTE with SELECT / SSELECT is catered for inside a transaction but not QSELECT? Why allow / cater for one and not the other? -Brian. Important Notice: This email is subject to important restrictions, qualifications and disclaimers (the

[U2] Unidata/Oracle connection problem

2006-07-31 Thread Richard Taylor
I am attempting to setup a data source under Unix to allow access to an Oracle database. I am having a lot of trouble getting this to work. I have: 7Installed the oracle client 7Setup a place to hold the driving library 7 Setup a folder

RE: [U2] Unidata/Oracle connection problem

2006-07-31 Thread Angelo Collazo
Rich, One important issue to know is to determine if you need a 64 or 32 bit UNIX driver. Also what is your .udlibs soft link look like? Hope this helps. Take a look-see at this link. http://www.easysoft.com/cgi-bin/search/search.cgi Cheers, Angelo Collazo System Administrator Silver Line

[U2] Reading Binary data from a file...

2006-07-31 Thread George Gallen
not a problem. As long as it's reset when the program terminates and is localized to that program, There would be no reason for me to reset it. Thanks for the info. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Craig Bennett Sent: Sunday, July 30,

Re: [U2] [UV] exit status and @SYSTEM.RETURN.CODE

2006-07-31 Thread Ray Wurlod
No, they're unrelated. uv will finish irrespective of whether or not @SYSTEM.RETURN.CODE is set. The exit status of uv only reports whether you were successful in invoking the environment (for example try in a non-account directory). - Original Message - From: phil walker [EMAIL

RE: [U2] [UV] exit status and @SYSTEM.RETURN.CODE

2006-07-31 Thread phil walker
bu..er. I guess I am just going to have to return some output and capture/parse it ;-). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Tuesday, 1 August 2006 3:30 p.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] exit status