[U2] PERL regular expression interpreter in UV Basic?
Hello U2 Users. I have been using a UV Basic function I call REGEXP that takes a text string and a PERL formatted regular expression and executes a PERL script and returns a matched string if found. The problem is that it can't handle some of the things in strings that are passed to it and PERL bombs. Because of this, I am in the midst of writing a UV Basic interpreter of PERL regular expressions, which is an interesting challenge. I checked via google search for any such UV Basic program already out there, but found none. So I am curious to know if anyone has done this, and if so, would care to share the code. Thanks to anyone who can assist. Ken Ford. Firstmac Ltd Brisbane, Australia. --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) ---___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Self Deadlatch error on device 655372, inode 610205,
Thanks all who responded. Never underestimate the power of the u2-users group! The problem was, as suggested, an i-descriptor subroutine (triggered by a secondary index update) that read the primary record being updated. A suitable workaround was found that avoided the problem. Regards, Ken Ford. --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) ---___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Self Deadlatch error on device 655372, inode 610205, group 11460608, latch 80000 to WRITE.
We are getting the error in the subject line in a 3rdParty program (no sourcecode). We have recreated the file, resized the file and rebuilt its secondary indices, and still get the error. There is a group lock when it occurs. A search of the archives has not produced anything useful. Any ideas would be appreciated. Thanks. Ken Ford Firstmac Ltd Brisbane QLD Australia --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) ---___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV full screen editor
I have used Emacs for UV development, including source coding and file editing for many years. There is a mode for UVBasic (unibasic-mode) and I have written a number of emacs-lisp based modes for editing m/v files. These are all available on the PickWiki site. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe file trigger subroutine issue
Greetings fellow U2 users. We use Universe 10.3 on an AIX 5.3 server. We have file triggers on a number of files, with one master globally catalogued subroutine calling locally catalogued subroutines depending upon the file involved. My understanding was that if one of these Is changed and the triggers associated with the file involved are dropped and recreated, the changes in the subroutine would take effect. But I found that programs updating the file associated with the trigger were still using the old version of the subroutine. Should this be happening? The work around was to rename the subroutine, drop the triggers and recreated them, using the renamed subroutine. Any suggestions or thoughts would be appreciated. Thanks, Ken Ford Software Engineer ken.f...@firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMacLimited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniObjects.Net error message
I wonder if anyone can assist with this problem: We are using UniObjects.Net with Universe 10.3 on under AIX 5.3. A web request is returning an error about a subroutine failing to complete: [IBM U2][UODOTNET - UNICLIENT][ErrorCode=30107] The subroutine failed to complete successfully It works successfully with other web requests, and the format of the request is correct. The apiserver log file reveals that the request was received, but has this line after the request details: ICSubCall UVSETJMP returncode=30107. When I run the request using a Universe request emulation program that calls the same subroutine, it works correctly and the output is correctly formatted. Thanks for any help or suggestions you may have. Ken Ford Software Engineer (Universe, etc.) Phone: 07 3013 8605 Fax: 07 3002 8400 Email: ken.f...@firstmac.com.au Web: www.firstmac.com.au # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Telnet session limt has been reached (was Retrieving data from remote SQL DB from Universe via ODBC?)
Firstly, my apologies for using an old posting's subject line as clarified in the new subject line! Now, the problem described in my last posting (the body of which was correct!) has been solved. The message in question was actually generated by our Universe Administrator's putting a new step in the UV account login paragraph and forgetting to tell the Universe development staff (unless I have just forgotten being told - quite possible). Thanks anyone who was wrestling with a response or who has responded already. I shall try to expect the unexpected in future before burdening the list with such questions. :-) Ken Ford Software Engineer Brisbane, Queensland, Australia. # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] FW: Retrieving data from remote SQL DB from Universe via ODBC?
Fellow U2 Users, I am getting the message 'Telnet session limit has been reached' when I try to log in to Universe. The machine is a development only machine and has 2 Universe licences assigned to it, but this occurs when none are in use! Any suggestions. There are no phantoms running. I could find nothing pertinent in the archives or on the web. Ken Ford Software Engineer=20 Brisbane, Queensland, Australia. # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Editors/Development Tools for Universe Basic programs.
Hello fellow U2-groupies. There has been recent discussion on useful tools for editing and/or compiling/testing U2 software. I am a 28 year user of Universe and its predecessors (including Prime Information and Pick flavours), and during most of that time a user of Emacs (on several platforms, including Windows and Linux). Over that time I have build a library of tools that aid the areas under discussion. If you look at the following link, you will file links to some of them under "BasicSource" and "EmacsLisp". In my humble opinion, Emacs is still the tool of choice (and XEmacs for that matter) for most software development. The link to the main page is: http://www.pickwiki.com/cgi-bin/wiki.pl?SourceCode With the tools I have written (which have been further developed since I uploaded them), you can do things like: 1. Work on Basic source, Paragraphs, multiple records in files at once, select lists of records, dictionary items - colourised for clarity. 2. Display/edit multivalued fields in records, with multivalues listed and numbered one per line. 3. (With Emacs standared features) edit code in one part of a window, and compile and run/debug code in another part, create macros to do repetitive tasks that involve both shell windows and coding windows, search/replace using full regular expression funcitionality. There are so many features available, if you care to undertake the easy learning curve to using it. To get the full benefit, you will need to use a windows-like version of emacs, like Unix X (my choice), MS Windows, or Linux. I hope someone finds this useful. I am open to questions. Regards, Ken Ford, Brisbane, QLD, Australia. # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Connectivity issue with ODBC - SQL.
From: Ken Ford Sent: Wednesday, 24 November 2010 11:37 AM To: 'u2-users@listserver.u2ug.org' Cc: Angel Frost Subject: Connectivity issue with ODBC - SQL. Could anyone shed light on the following problem we are having? We have a Windows 2003 R2, running SQL Server 2008R2 connecting to Universe 10.3 on AIX 5.3, via UniVerse ODBC driver 3.7 And are getting the error below intermittently (sensitive details represented with '*'s): Message: Executed as user: ***. The OLE DB provider "MSDASQL" for linked server "**" reported an error. The provider reported an unexpected catastrophic failure. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "**". [SQLSTATE 42000] (Error 7303). The step failed. We have checked the user group list archives, and couldn't find anything matching this completely. Thanks for any help you can provide, Ken Ford Senior Software Engineer - Universe "Today, the Universe - tomorrow, the world!" Phone: 07 3013 8605 Fax: 07 3002 8400 Email: ken.f...@firstmac.com.au Web: www.firstmac.com.au # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2-Users Digest, Vol 15, Issue 17
Thanks, David. It was just what I was after. Regards, Ken. -Original Message- Date: Tue, 20 Jul 2010 14:13:24 +1000 From: "Hona, David" To: 'U2 Users List' Subject: Re: [U2] Tracing ODBC requests Message-ID: <297b19fd90fdb14da1c8ceff0b6cffe76785e3f...@vaunsw139.au.cbainet.com> Content-Type: text/plain; charset="iso-8859-1" Hello Ken, Check out the API Supplement PDF (apisupp.pdf) Try this... haven't used it for a long time...I believe ODBC connections go via "uvserver". Last time I used was for "uvcs" though, I can't recall it actually works for ODBC connections. You can also get your remote system to invoke a stored procedure to your UV Regards David Extracted out of the PDF: Logging Client Connections Beginning at UniVerse 10.0, a server-side debugging log is available for tracking client connections. The debugging log is located in the /tmp/ directory on UNIX, or C:\tmp on Windows platforms, by default. Complete the following steps to set up the debugging log: 1.Edit the serverdebug file in the UVHOME directory. 2.In the first column, enter uvcs, indicating that you want to log the connection progress for both uvapi_server and uvapi_slave. 3.In the next column, enter an integer indicating the level of logging information you want to maintain. The valid integers are: 0 - No debugging. 1 - Captures information about the startup connection only. 9 - Captures information about every call. 4.In the third column, enter the full path for the log file location. If this value does not exist, the logs are written to /tmp/uvapiserver_###.log as the default on UNIX systems, or C:\tmp\uvapiserver.log as the default on Windows systems. is the uvapi_server process ID. # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Tracing ODBC requests
Hello List Members. Can anyone suggest a way to log the SQL requests sent via ODBC to the Universe DB (from a MS Windows client to a AIX based Universe DB). I suppose I want the commands processed by the uvapi_slave process. I have tried capturing them via the LOGIN paragraph to no avail. Any help would be appreciated. The manuals, as is often the case, were unhelpful. Regards, Ken Ford Software Engineer - Universe Phone: 07 3013 8605 Fax: 07 3002 8400 Email: ken.f...@firstmac.com.au Web: www.firstmac.com.au # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[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. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2-users-requ...@listserver.u2ug.org Sent: Thursday, 1 July 2010 5:00 AM To: u2-users@listserver.u2ug.org Subject: U2-Users Digest, Vol 14, Issue 24 Send U2-Users mailing list submissions to u2-users@listserver.u2ug.org 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 u2-users-requ...@listserver.u2ug.org You can reach the person managing the list at u2-users-ow...@listserver.u2ug.org When replying, please edit your Subject line so it is more specific than "Re: Contents of U2-Users digest..." Today's Topics: 1. UniJDBC calling UV subroutine: MESSAGE command limitations? (Womack, Adrian) 2. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Womack, Adrian) 3. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Womack, Adrian) 4. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Dan McGrath) 5. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Womack, Adrian) 6. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (phil walker) 7. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Womack, Adrian) 8. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Hona, David) -- Message: 1 Date: Wed, 30 Jun 2010 09:17:45 +0800 From: "Womack, Adrian" To: "'U2 Users List'" Subject: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Message-ID: <647edc140798bc48a4661de9805407481ec7e7b...@excmbx01.rac.com.au> Content-Type: text/plain; charset="us-ascii" We have a jsp page that calls a Universe subroutine using that method detailed in the JDBC manual, this works as expected and the subroutine completes it's task successfully. Also from a separate phantom process for certain important events we have some code that sends a splat message to line 23 of specific users' sessions (this uses the Universe MESSAGE command) -this also works fine. We're now trying to get the subroutine called via JDBC to also use the MESSAGE command. But each time it throws this error message into the uv errlog: "root VOC entry "MESSAGE" illegal as or in a procedure." Does anyone know what's wrong here? I've looked through the manuals and the help and can't find any mention of this particular restriction. Thanks, Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. -- Message: 2 Date: Wed, 30 Jun 2010 09:49:33 +0800 From: "Womack, Adrian" To: "'U2 Users List'" Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Message-ID: <647edc140798bc48a4661de9805407481ec7e7b...@excmbx01.rac.com.au> Content-Type: text/plain; charset="us-ascii" I'm wondering if it's because MESSAGE can optionally prompt for input, and because the call statement is executed from the jsp page via executeQuery - maybe it won't allow input inside a query (similar to the rule about input inside a transaction). Perhaps if I execute a PHANTOM command to perform the MESSAGE commands in a different process - maybe that would work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 9:18 AM To: 'U2 Users List' Subject: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? We have a jsp page that calls a Universe subroutine using that method detailed
Re: [U2] pick item date/time modification (Ken Ford)
Doug, There is nothing in Universe to do it (unless it is a type 1 or 19 file - in which case you have Unix level date/time modified). I don't know what you are using, but if it is Universe, I would suggest a file trigger that writes the information to a log file, e.g. the process id and user updating, the date/time updated, and the file/item name. It should be fast on most Unix boxes today. Let me know if you want any help on it. Regards, Ken Ford, FirstMac P/L Brisbane, QLD. Australia. -Original Message- On 06-21-2010 1:51 PM, doug chanco wrote: > I am pretty sure there is a way to get the "date/time"a pick item was > modified (at least I hope so) anyway if its possible can anyone share > how? > > thanks > > dougc > > ___ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Input is not permitted when a trigger is active
U2-listers, Can anyone shed light on the message in the subject line? I have searched all over the place and tried quite a few things to prevent it happening. I am running RAID on a program that updates a file that has an update trigger on it. As soon as the program hits the WRITE statement to the file in question, it crashes with the above message. Any assistance would be appreciated. Ken Ford Software Engineer - Universe Phone: 07 3013 8605 Fax: 07 3002 8400 Email: ken.f...@firstmac.com.au Web: www.firstmac.com.au # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Auto-updating of secondary indices.
I think I have now grasped it! Thank you all who responded. Obviously, any I-descriptors in a file that refer to other files will not be re-evaluated to automatically update a secondary index when one of those other files is updated, unless the parent file (of the I-descriptors) is itself updated. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Auto-updating of secondary indices.
>From my reading of the Universe documentation, secondary indices should be automatically updated. I have a case where a file has about 8 secondary indices, some of which are updated automatically, and some seem not to be. A complete rebuild is done on all these indices each night. There does not seem to be anything significantly different about the ones that don't update automatically. They are I-descriptors that call a subroutine, but others like these update automatically. Any suggestions? I am thinking I should delete the indices in question, recreate them, and rebuild them. Regards, Ken Ford Universe Software Engineer [cid:image001.gif@01C9D7B2.503A0520]<http://www.firstmac.com.au/> Phone: (07) 3013 8686 Email: ken.f...@firstmac.com.au<mailto:mark.b...@firstmac.com.au> Web: www.firstmac.com.au<http://www.firstmac.com.au/> # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # [demime 1.01d removed an attachment of type image/gif which had a name of image001.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DATE.FORMAT illegal when a transaction is active
Thank you to those who assisted with this issue. Adding 'H' to the DATE.FORMAT verb did the trick. However, it is not apparent why it did! Perhaps Universe thinks it is running a transaction when a file trigger subroutine executes. No transaction was active. Regards, Ken Ford Universe Software Developer [cid:image001.gif@01C9BE8F.CF28AD00]<http://www.firstmac.com.au/> Phone: (07) 3013 8686 Email: ken.f...@firstmac.com.au<mailto:mark.b...@firstmac.com.au> Web: www.firstmac.com.au<http://www.firstmac.com.au/> # This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) # [demime 1.01d removed an attachment of type image/gif which had a name of image001.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/