Re: [U2] JDBC and OpenOffice on Linux
Hi, thanks for that encouragement - Better&Better will probably be the place to pursue the IBM angle. However Openoffice.org have also proven that they are willing and able to modify OOo specifically for U2 if there are enough requests from users for similar features/fixes - they have already done so in the past. So, the request is still for the U2 community to take 10 minutes each (in total that adds up to a lot of hours) and vote on the Openoffice.org issue. There are many opportunities to take advantage of OOo, not just as an office suite but as an integrated part of U2 applications, especially if you are looking for similar MSOffice functionality/API on Linux/UNIX. Thanks to those who have already voted. Apart from my own vote 5 other U2 users have used 2 of their votes on this issue. Regards Ian Stuart Results wrote: Ian, U2UG has established a committee that is charged with bringing fixes and enhancements to IBM's attention. The Committee, Better&Better, is currently looking for a new chairman to continue that work. As soon as B&B has a new head, it would be the best place for you to push forward with from this angle. - Chuck Ian Stuart wrote: An issue has been reported on the OpenOffice.org Bugzilla system. But to try and give some impetus to resolving this issue I am "soliciting" the support of this forum to vote on this issue on the OpenOffice.org site as well as to prevail on IBM to cooperate with OpenOffice.org to resolve the issues with JDBC/ODBC and OpenOffice. However, there are still a number of issues to be resolved, including being able to update tables via JDBC ie. although one can create UniVerse tables from within OOo you cannot insert, update or delete; there is a date format problem - see issue 49043, table names have to be "aliased" in the VOC etc. etc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV: uv.rc script curiosity
I believe it's primarily so that the uvadm user can use uv -admin -start/-stop (which executes this script - actually the one in $UVHOME/sample). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Resize
I just wrote the app and am only doing a CLEARFILE. It must be HASH.HELP as you suggested. Thanks Dan. Dan Fitzgerald wrote: I would guess that there's something in your program doing that; maybe it's doing something like creating a linux file, populating it, and moving it over the new file? Also, HASH.HELP sometimes gets the type right, but that's about it. A sep of 1 is almost never a good choice, and I'm tempted to remove "almost" from this sentence. "Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them?" - H.H. the Dalai Lama "When buying & selling are controlled by legislation, the first thing to be bought & sold are the legislators" - P.J. O'Rourke Dan Fitzgerald >From: Lance Jahnke <[EMAIL PROTECTED]> >Reply-To: u2-users@listserver.u2ug.org >To: u2-users@listserver.u2ug.org >Subject: [U2] Resize >Date: Wed, 30 Nov 2005 12:03:03 -0600 > >Just noticed something strange. I have a type 18 file with 25K records in >it. HASH.HELP suggests a MOD of 4241 with a SEP of 1 - So I RESIZE to these >specs and run HASH.HELP. The file stats reflect my resize changes. I run a >BASIC program that clears the file and reloads my 25K records. I run >HASH.HELP and the MOD reported back is 1973. I have been running UniVerse >10.1.1 on RH AS3 for about 2.5 years. I dont really consider this an issue >but was wondering if this is a bug. Any insight into this? Thanks. >--- >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] Resize
I would guess that there's something in your program doing that; maybe it's doing something like creating a linux file, populating it, and moving it over the new file? Also, HASH.HELP sometimes gets the type right, but that's about it. A sep of 1 is almost never a good choice, and I'm tempted to remove "almost" from this sentence. "Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them?" - H.H. the Dalai Lama "When buying & selling are controlled by legislation, the first thing to be bought & sold are the legislators" - P.J. O'Rourke Dan Fitzgerald From: Lance Jahnke <[EMAIL PROTECTED]> Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] Resize Date: Wed, 30 Nov 2005 12:03:03 -0600 Just noticed something strange. I have a type 18 file with 25K records in it. HASH.HELP suggests a MOD of 4241 with a SEP of 1 - So I RESIZE to these specs and run HASH.HELP. The file stats reflect my resize changes. I run a BASIC program that clears the file and reloads my 25K records. I run HASH.HELP and the MOD reported back is 1973. I have been running UniVerse 10.1.1 on RH AS3 for about 2.5 years. I dont really consider this an issue but was wondering if this is a bug. Any insight into this? Thanks. --- 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] SQL Server and UniVerse
I have a machine running Datastage (which uses Universe) and SQL server and everything works ok. Of course both databases are used infrequently so I don't have any contention for processor or disk usage. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Wednesday, November 30, 2005 1:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] SQL Server and UniVerse I know the answer here is to TRY NOT TO, but a client has asked me: Can Microsoft's SQL Server and UniVerse 10.1 run on the same box? I want to give a factual answer - that is, yes, there are sites that do it, or No, it's just will not work. Even with a "yes" answer, I still plan to remind them that any database support issue will be a nightmare for both sides since interactions can never always be predicted or scripted. Thanks for any thoughts from the group... David W. --- 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] SQL Server and UniVerse
I run UV 10.1 , Oracle 10g and SQL Server 2000 on same box (not a production box, but development box) without any problem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Wednesday, November 30, 2005 4:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] SQL Server and UniVerse I know the answer here is to TRY NOT TO, but a client has asked me: Can Microsoft's SQL Server and UniVerse 10.1 run on the same box? I want to give a factual answer - that is, yes, there are sites that do it, or No, it's just will not work. Even with a "yes" answer, I still plan to remind them that any database support issue will be a nightmare for both sides since interactions can never always be predicted or scripted. Thanks for any thoughts from the group... David W. --- 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] SQL Server and UniVerse
David, We have one customer who has been running UniVerse 10.1.0 with an SQL MDE database. They are using ODBC to move data from UV to the MDE database. Granted this is not a full blown version of SQL it has been running fairly smoothly for quite some time. We have been experiencing some issues (performance) recently, but things are starting to point away from either database and more toward data issues. HTH, Mike Dallaire Mortgage Builder Software Inc. (248) 208-3223 ext. 103 [EMAIL PROTECTED] www.mortgagebuilder.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Wednesday, November 30, 2005 4:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] SQL Server and UniVerse I know the answer here is to TRY NOT TO, but a client has asked me: Can Microsoft's SQL Server and UniVerse 10.1 run on the same box? I want to give a factual answer - that is, yes, there are sites that do it, or No, it's just will not work. Even with a "yes" answer, I still plan to remind them that any database support issue will be a nightmare for both sides since interactions can never always be predicted or scripted. Thanks for any thoughts from the group... David W. --- 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] SQL Server and UniVerse
I know the answer here is to TRY NOT TO, but a client has asked me: Can Microsoft's SQL Server and UniVerse 10.1 run on the same box? I want to give a factual answer - that is, yes, there are sites that do it, or No, it's just will not work. Even with a "yes" answer, I still plan to remind them that any database support issue will be a nightmare for both sides since interactions can never always be predicted or scripted. Thanks for any thoughts from the group... David W. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Associated MVs
Is it possible to assocate the same dictionary item (field definition) to more than one association phrase? I'm doing some conversion work and there are several associations that include some of the same dictionaries. For example, the following association phrases were created: Dict Name... Type # Col-Heading Field-Definition AS_10PH IMPDATE IMPVERSION AS_4 PH ADATE ACTIONS BYS AS_4APH ADATE OACTIONS BYS In a Pick style dictionary this is no problem with the "[D]ependent and [C]ontrolling association codes. But I can't figure out how to do it here without creating two new synonym dictionaries for both 'ADATE' and 'BYS'. Thanks, Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Resize
Just noticed something strange. I have a type 18 file with 25K records in it. HASH.HELP suggests a MOD of 4241 with a SEP of 1 - So I RESIZE to these specs and run HASH.HELP. The file stats reflect my resize changes. I run a BASIC program that clears the file and reloads my 25K records. I run HASH.HELP and the MOD reported back is 1973. I have been running UniVerse 10.1.1 on RH AS3 for about 2.5 years. I dont really consider this an issue but was wondering if this is a bug. Any insight into this? Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV: uv.rc script curiosity
The "su" may have been to set Login-uid as required by some versions of the "C2" security level. This was an issue in some "C2" environments, for processes started by the "init" process without any Login-uid. In which case the $UVHOME/bin programs that do setuid would have needed to be invoked via "su" (which itself does setuid, of course, but "su" had a special exemption.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] JDBC and OpenOffice on Linux
Ian, U2UG has established a committee that is charged with bringing fixes and enhancements to IBM's attention. The Committee, Better&Better, is currently looking for a new chairman to continue that work. As soon as B&B has a new head, it would be the best place for you to push forward with from this angle. - Chuck Ian Stuart wrote: An issue has been reported on the OpenOffice.org Bugzilla system. But to try and give some impetus to resolving this issue I am "soliciting" the support of this forum to vote on this issue on the OpenOffice.org site as well as to prevail on IBM to cooperate with OpenOffice.org to resolve the issues with JDBC/ODBC and OpenOffice. However, there are still a number of issues to be resolved, including being able to update tables via JDBC ie. although one can create UniVerse tables from within OOo you cannot insert, update or delete; there is a date format problem - see issue 49043, table names have to be "aliased" in the VOC etc. etc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV: uv.rc script curiosity
It allows you to perform a command from shell with the priorities of the user specified after the 'su'. In this case root Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hennessey, Mark F. Sent: Wednesday, November 30, 2005 8:09 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV: uv.rc script curiosity We are running UV 10.0.8 on Solaris 8. My eunuchs admin asked me why the startup script (/etc/rc2.d/S99uv.rc), which runs as root, uses su commands. For example, here is part of the start: # Find running RPC daemons rlist=`/bin/su root -c "/bin/ps $PSARGS"|grep My guess, based more on ignorance than anything else, is that it's an attempt to make the script as portable from platform to platform as possible... But that was something I more or less just mumbled to hide the sound of my brain cramping. Any thoughts on this? Mark Hennessey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UV: uv.rc script curiosity
[EMAIL PROTECTED] wrote: > We are running UV 10.0.8 on Solaris 8. > > My eunuchs admin asked me why the startup script (/etc/rc2.d/S99uv.rc), which > runs as root, uses su commands. > > For example, here is part of the start: > > # Find running RPC daemons > rlist=`/bin/su root -c "/bin/ps $PSARGS"|grep > > My guess, based more on ignorance than anything else, is that it's an attempt > to make the script as portable from platform to platform as possible... But > that was something I more or less just mumbled to hide the sound of my brain > cramping. > > Any thoughts on this? > Well, if you want an educated guess, I do NOT think startup scripts run "as root". They run as uid 0, which isn't the same thing. I'm guessing the 'su' forces /etc/profile and ~/.profile to run, which will alter the command's environment and change the way the command runs. That's why, in rc.d and cron scripts, you are *always* advised to spell everything out *explicitly* - you can't trust the environment to be what you expect. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV: uv.rc script curiosity
We are running UV 10.0.8 on Solaris 8. My eunuchs admin asked me why the startup script (/etc/rc2.d/S99uv.rc), which runs as root, uses su commands. For example, here is part of the start: # Find running RPC daemons rlist=`/bin/su root -c "/bin/ps $PSARGS"|grep My guess, based more on ignorance than anything else, is that it's an attempt to make the script as portable from platform to platform as possible... But that was something I more or less just mumbled to hide the sound of my brain cramping. Any thoughts on this? Mark Hennessey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] JDBC and OpenOffice on Linux
Hello to all U2 I am still persevering with getting OpenOffice to work with UniVerse and have had some success with the JDBC driver on MS Windows platform connecting to UniVerse - this with tremendous support from Frank Schonheit of Sun and OpenOffice.org. So now one can connect to, with a little difficulty, and query, with a few issues still to be resolved, a UniVerse database from within OpenOffice. Hopefully IBM, will some day take a serious look at this project and contribute something to making UniVerse cooperate with OpenOffice.org using ODBC/JDBC. The problem now encountered is that connecting from OpenOffice.org using JDBC running on a Linux platform presents the same problem as experienced previously on MS Windows - now fixed - (whereas it did work before at some point in the Beta releases) i.e the JDBC driver loads successfully, and a connection to the database is established; but no tables are "visible" and a native SQL query results in a "ResultSet Type 1,005 is not supported" - a message that one used to encounter on MS Windows platforms before the problem was "fixed" An issue has been reported on the OpenOffice.org Bugzilla system. But to try and give some impetus to resolving this issue I am "soliciting" the support of this forum to vote on this issue on the OpenOffice.org site as well as to prevail on IBM to cooperate with OpenOffice.org to resolve the issues with JDBC/ODBC and OpenOffice. If you feel you can assist then please register as a user on www.openoffice.org and vote on issue 58313 - it'll only take about 5 minutes to do so. However, there are still a number of issues to be resolved, including being able to update tables via JDBC ie. although one can create UniVerse tables from within OOo you cannot insert, update or delete; there is a date format problem - see issue 49043, table names have to be "aliased" in the VOC etc. etc. Here's looking forward to your support Thanks and regards Ian Stuart ___ DISCLAIMER ___ This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/