Re: [U2] [UV] QSELECT in transaction
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 = 'Lion' IF (@SYSTEM.RETURN.CODE 0) THEN PERFORM SELECT ANIMAL WITH NAME = 'Simba' END At the end of this BASIC code your active select list contains all records matching the select statements as if you entered them on the command line. With an EXECUTE this does not work. To achieve the same result with an EXECUTE you'd have to do the following: EXECUTE SELECT ANIMAL WITH SPECIES = 'Lion' AND NAME = 'Simba' SETTING nrOfRecords Depending on your selection you'd have to chose what is best. If you're using complicated I-descriptors (that can make selecting on them slow), I'd use a series of PERFORM statements instead of an EXECUTE. If you're using @USER0 through @USER4 in your I-descriptors, those won't be propagated to the statements you run with an EXECUTE statement so you'd have to use a (series of) PERFORM statements for those. As for the original question in this thread, I'm afraid you can't use a QSELECT inside a transaction on uniVerse. I'd like to add that doing SELECT / SSELECT statements inside database transactions on uniVerse can sometimes cause database corruption (we once had this happen to one of our customers' accounts), so I would advise against that. Regards, Mark Cornelissen http://www.innovate-it.com On Jul 27, 2006, at 04:44, Dave R wrote: Preform is an older version and sometime you get different results? D Raven [EMAIL PROTECTED] cell (949)2282224 e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 -- Ray Wurlod [EMAIL PROTECTED] wrote: Have you tried PERFORM rather than EXECUTE? --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Replication Between Unidata and MySQL
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. This may seem overkill but it allows you to format the SQL the way you want, and possibly specify stored procedures (AFAIK MySQL 5 has stored procedures but I haven't used them yet) - The SYNC_ACTIONS holds the actions, each specifying a target, action type (update,insert,delete) and a list of fields that match the column positions specified in the target. - The SYNC_ERRORS logs errors. How you populate the action is then up to you: using triggers, virtual secondary index fields or whatever... Then, write a simple VB/Delphi/.NET/VBScript app with a UO connection to: - load up the targets for reference - select the actions (on a timer loop) sorted by target (so you get advantages of query preparation and caching - it is worth not making the timer interval too short) - prepare insert and delete ADODB commands on each change of target - substitute the parameters and fire the delete and/or insert commands as required It means having a Windows box in the middle, but the route is well known. Any failure just means the actions accumulate until drained. I have a working example I can dig out and send you. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 29 July 2006 03:12 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Replication Between Unidata and MySQL From: Of Mike Randall Sent: Friday, July 28, 2006 5:46 PM ...The trigger could normalize your data (or whatever you needed done) and could be added with no impact to your application. I wouldn't say no impact per se but I think the trigger idea has merit overall as a minimally invasive change watcher. But then what? What's the best way to get the deltas into the MySQL instance? --- 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] [UV] exit status and @SYSTEM.RETURN.CODE
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, but it appears that is not the case. Is this expected behaviour, or is there a way of doing this, apart from displaying the value of @SYSTEM.RETURN.CODE and capturing the output. Phil. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] QSELECT in transaction
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 Disclaimer) that must be accessed and read at the following address or by copying and pasting the following address into your Internet browser's address bar: http://www.frstia.co.za/Disclaimer.asp The Disclaimer is deemed to form part of the content of this email in terms of Section 11 of the Electronic Communications and Transactions Act, 25 of 2002. If you cannot access the Disclaimer, please obtain a copy thereof from us by sending an email to mailto:[EMAIL PROTECTED] FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata/Oracle connection problem
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 to hold my odbc.ini file and set the ODBCSYSINI environment variable to point there. 7I created the odbc.ini file as shown below. 7 My oracle dba also did some configuration setup for the Oracle client and was able to connect through the client. [DV83] Driver=/usr/local/lib/hsdb_odbc.sl Description=Oracle ODBC on test system SERVER=testserver PORT=1521 USER=test_user Password=** Database=DV83 OPTION=3 SOCKET= TraceFile=/production/udtmp/odbc_rich.trace Trace=1 Can anyone tell me if they have successfully gotten a BCI connection going to Oracle and how you did it. By the way I am on an HP Unix system. Thanks in advance for any help. Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata/Oracle connection problem
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 Building Products Corporation One Silver Line Drive North Brunswick NJ, 08902 [EMAIL PROTECTED] Ph: 732.435.1000 X4495 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Richard Taylor Sent: Monday, July 31, 2006 3:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata/Oracle connection problem 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 to hold my odbc.ini file and set the ODBCSYSINI environment variable to point there. 7I created the odbc.ini file as shown below. 7 My oracle dba also did some configuration setup for the Oracle client and was able to connect through the client. [DV83] Driver=/usr/local/lib/hsdb_odbc.sl Description=Oracle ODBC on test system SERVER=testserver PORT=1521 USER=test_user Password=** Database=DV83 OPTION=3 SOCKET= TraceFile=/production/udtmp/odbc_rich.trace Trace=1 Can anyone tell me if they have successfully gotten a BCI connection going to Oracle and how you did it. By the way I am on an HP Unix system. Thanks in advance for any help. Rich Taylor | Senior Programmer/Analyst| VERTIS COMMUNICATIONS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.454.8392 [EMAIL PROTECTED] | http://www.vertisinc.com Vertis Communications - Partnering with clients to solve the most complex, time-sensitive marketing challenges through consulting, creative, research, direct, media, technology, and production services. The more they complicate the plumbing the easier it is to stop up the drain - Montgomery Scott NCC-1701 --- 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] Reading Binary data from a file...
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, 2006 8:04 PM To: u2-users@listserver.u2ug.org Subject: U2] Reading Binary data from a file... George Gallen wrote: When assigning 1 to System(1017), does that only affect the current process, or all processes running on UV? So, does System(1017) get reset when the program terminates? or do I need to set it back to normal. The setting is per-process and is reset when the program terminates. Unfortunately I'm not aware of any way to check the value of SYSTEM(1017) before setting in case you wish to restore to a previous value. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] exit status and @SYSTEM.RETURN.CODE
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 PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] [UV] exit status and @SYSTEM.RETURN.CODE Date: Mon, 31 Jul 2006 20:29:13 +1200 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, but it appears that is not the case. Is this expected behaviour, or is there a way of doing this, apart from displaying the value of @SYSTEM.RETURN.CODE and capturing the output. Phil. --- 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] exit status and @SYSTEM.RETURN.CODE
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 and @SYSTEM.RETURN.CODE 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 PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] [UV] exit status and @SYSTEM.RETURN.CODE Date: Mon, 31 Jul 2006 20:29:13 +1200 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, but it appears that is not the case. Is this expected behaviour, or is there a way of doing this, apart from displaying the value of @SYSTEM.RETURN.CODE and capturing the output. Phil. --- 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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/