[U2] IBM UniVerse JDBC driver with WebLogic web application server

2006-08-01 Thread Vance, Kathy
All, Does anybody have the experience on how to configure the weblogic connection pool with IBM UniVerse JDBC driver? I got the following error even the console window tells connection is successful and the pool state is "Running". Any idea? I am using WebLogic 8.1.5 and UniVerse 10. Than

RE: [U2] OK...Is there a way....UV

2006-05-26 Thread Vance, Kathy
It is true that the sample is the first execution before the sorting takes place. Oracle DB dose the same thing. I was unsuccessfully trying to use sub-query in this case. Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Thursday

RE: [U2] Linked server fails when using Analysis services

2006-05-11 Thread Vance, Kathy
I run into the similar situation while using linking Universe server in SQL. Eventually I got it fixed is: 1) check the User account and make sure it has right to read the UniVerse tables. 2) make sure the column name used in UniVerse view is not uniVerse reserved word. If you could view the data

RE: [U2] call sunroutine in command line

2006-05-09 Thread Vance, Kathy
(if the server is the computer you are running it on). Unidata has a "connect" command IIRC and universe may have something similar that lets you send interactive sql to another server. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Beh

[U2] call sunroutine in command line

2006-05-09 Thread Vance, Kathy
All, How could I test a subroutine with AccuTerm command line? For example, the subroutine is called WEB.BI.RENTAL.SUB(BTN.ID,CUST.ID,ERR.MSG) and it has a select statement and returns a result set. In subroutine, there is something like: SUBROUTINE WEB.BI.RENTAL.SUB(BTN.ID,CUST.ID,ERR.MSG) .

RE: [U2] Changes to the List

2006-03-16 Thread Vance, Kathy
I did not post too many messages either, as I am new to UniVerse. I am still learning. But I am thinking that we(ourselves) could have a choice on how to reply the email to the list. Currently, if I want to reply to the person posted the email only, I just hit the Reply on my outlook. If I need t

[U2] Number of JDBC connections

2006-03-05 Thread Vance, Kathy
All, I am still new to UniVerse and I keep learning it every day. Can I check the number of JDBC connections from my Java app to UniVerse with UniAdmin. When I click the Users in UniAdmin, I could see interactive users and background processes. My guess is that the "interactive users" is the one I

RE: [U2] Universe Scalability

2006-03-03 Thread Vance, Kathy
As a new learner to Universe, I was asking the same question regarding the scalability of universe before. I am still not very clear on the answer. I did not see any online document of the comparison between the Universe and other database. Have you guys found some online resources on this topic?

RE: [U2] Access IBM Knowledge base/Blink Error

2006-02-23 Thread Vance, Kathy
to remind myself on how to use "fnuxi" on ALL files in a directory the information is there, but ... (reminders gratefully accepted :) Ross Ferris Stamina Software Visage > Better by Design! >-Original Message- >From: [EMAIL PROTECTED] [mailto:owner-u2- >[EMAIL

[U2] Access IBM Knowledge base

2006-02-22 Thread Vance, Kathy
All, I remember we had a discussion on the accessibility to the IBM knowledge base several weeks ago. Yesterday, I received my IBM user ID from our vendor (tech support), which allows me to view the locked articles in IBM KB. I believe this user list has very positive impact on this move made by I

RE: [U2] Knowledgebase access

2006-01-26 Thread Vance, Kathy
I have to ask our tech support (distributor) to forward the articles to me each time. I saw the articles of titles but I could not open it. I do not understand what IBM is thinking? Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of phil walker Sent:

RE: [U2] Knowledgebase access

2006-01-26 Thread Vance, Kathy
I am 100% agree with Phil. It was very frustrating when I had questions and saw the article titles in KB on IBM site but could not read it. It is very weird that IBM has KB but does not allow people to view them. I have not seen any other web sites doing so. The one of reasons people find that it

RE: [U2] Java Platform Struggles

2006-01-24 Thread Vance, Kathy
You guys have lots of experience on using UniObjects. May I ask "How do you manage the DB connection with UniObjects? How could I check the number of DB connections in UniVerse while a web based Java app is running?" We are using UniVerse 10. Thanks in advance, Kathy -Original Message-

RE: [U2] UV How control number o concurrent sesions?

2005-10-27 Thread Vance, Kathy
I am thinking a similar question. How do we know how many database connections opened by an application? Could we query a universe table or file to get the info of current active sessions? Thanks, Kathy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of J

RE: [U2] ODBC

2005-10-19 Thread Vance, Kathy
I did the same thing in SQL 2000. I created a linked server in SQL 2000 with IBM ODBC driver. I could run the query with Openquery. But I could not see the tables and views in SQL enterprise manager. When I clicked on the tables, I got error saying something like: "Error0: SqlDumpExceptionHandler:

RE: [U2] connection from UniBasic to a SQL database

2005-10-18 Thread Vance, Kathy
Hi Bob, I hope I did not miss your reply. We have the problem to make SQL 2000 communicate with Universe 10 or 11 with IBM Universe ODBC driver. Based on its document, this driver seems do not support the SQL server. Could you share your experience on the way of using OpenLink ODBC driver for SQL

RE: [U2] Java calss calls a universe subroutine

2005-10-04 Thread Vance, Kathy
Value<1,1>=31 returnValue<1,2>=32 returnValue<1,3>=33 END -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Vance, Kathy Sent: Monday, October 03, 2005 10:15 PM To: u2-users@listserver.u2ug.org Subject:

[U2] Java calss calls a universe subroutine

2005-10-03 Thread Vance, Kathy
Hi list, I need you guys help. I am a Java programmer and new to Universe. Could anybody show me how to call a universe subroutine which returns a list of values? Ex. sub1 (var in) Returns three rows: a1,b1,c1 a2,b2,c2 a3,b3,c3 How could I loop through these three rows and get each va