RE: Frontend to UniVerse?

2004-04-30 Thread djordan
Trevor You have access to a variety of clients including java, .Net, VB, etc. Access can be through ODBC OLE DB, but also through a UniObjects which is a class that drops into java or a com object that drops into VB .Net. This is more efficient than the ODBC environment. (a .Net interface is

RE: How far can U2 scale?

2004-04-23 Thread djordan
Design plays a big role. Some banks have massive systems, because all the customer data is in one spot even though customers are spread over several cities and states. To me if you live in City A you conduct most of your transactions in city A and occasionaly on business or holiday you may do

RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

2004-04-16 Thread djordan
Hi Foo Could it be an application problem. It sounds like an application is adding data to a possible type 1 file as a log or a como file or even a print job and it is growing to an enormous size consuming resources. There might be some other application that has gone rogue. Can you identify

RE: Crystal Reports

2004-04-16 Thread djordan
Take the Lead If they have SQL Server already, build a mini datawarehouse that you populate Daily, and then set up the new Report Services of SQL Server which is a free add on to SQL Server 2000. In somes ways it has some better features than Crystal reports. It gives your system a fresh face

RE: RedBack from .net

2004-04-15 Thread djordan
Graham There is a white paper on U2 .Net on the IBM U2 web page. This had some references on how to use Redback with .Net Regards David Jordan Managing Consultant [EMAIL PROTECTED] Dacono Holdings Pty Ltd Business Technology Consulting PO Box 909 Lane Cove NSW 2066 Australia Ph 61 2 9418

RE: Jbase handles multivalue on RDBMS

2004-04-15 Thread djordan
and give some delight today. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of djordan Sent: Thursday, April 15, 2004 12:27 AM To: 'U2 Users Discussion List' Subject: Jbase handles multivalue on RDBMS Hi Steve Just to correct you, jbase does not require you

RE: UV Crash on W2K3

2004-04-15 Thread djordan
Hi Sarah What is the application currently running on and what version. (ie Win2000 Uv9.4?) and what flavour. In the past Loging in went through a login paragraph LOGIn. I think around release 1, the login paragraph went by the account name not LOGIN. Also with direct Login and Logto one

RE: The future of U2

2004-04-14 Thread djordan
There are a variety of ways that this can be achieved. 1. the records are stored in the relational database as a raw string including value marks etc. This is meaningless data to DB2 users. 2. The data is converted into two dimensional databases, requiring data typing, length definitions, etc.

Jbase handles multivalue on RDBMS

2004-04-14 Thread djordan
Hi Steve Just to correct you, jbase does not require you to move to 1NF files to run on an RDBMS. Jbase will port multi dimensional data across to an RDBMS and automatically handle the conversion to multiple tables invisible to the application. The issue is in the quality of the dictionary,

RE: The future of U2

2004-04-13 Thread djordan
I think the target was for next year. David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steve Mayo Sent: Wednesday, 14 April 2004 2:46 AM To: [EMAIL PROTECTED] Subject: The future of U2 Hi, Does anyone out there know whether IBM is

RE: Objectcall headache...

2004-04-09 Thread djordan
Hi Martin It is a while since I use dobjectcall, but as far as I remember UniObjects has all the functionality and more that objectcall and is a lot simpilar. You should be able to convert the application to UniObjects reasonably quickly, unless it is done by some third party, possibly quicker

ReOpening a File drops File Lock

2004-04-05 Thread djordan
I uncovered an issue in 10.1 that may be an issue to some. If one does a FILELOCK and then opens the File again then the File Lock is dropped. This may occur where some one has the file variables in common, and may open the file again in a subroutine, where they are unsure if the File had been

RE: Volunteer Board

2004-04-01 Thread djordan
Hi Ross Australia and the UK is represented on the board as well as the USA Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Thursday, 1 April 2004 10:38 AM To: U2 Users Discussion List Subject: RE: Volunteer

RE: Comparing Oracle with UV

2004-03-31 Thread djordan
Trevor If you are bored, the real test is a mutidimensional file ie Invoice and Items and compare that to a select against a joined table on SQL Server particularly where you select criteria from both tables. Then for fun add record locking with say a 1000 routines locking and updating records

RE: Data typing in MV Basic

2004-03-31 Thread djordan
The issue I have had to deal with, which may be common to this discussion is where we use fiscal year 0203 for 2002/2003. If you do A = 0203, then sometimes but not always it becomes 203. where a = 0203 it remains 0203. If you want to add a year to make 0203 to 0304 requires something like this

RE: Data typing in MV Basic

2004-03-31 Thread djordan
To: 'U2 Users Discussion List' Subject: RE: Data typing in MV Basic Surely OneYear = 101 Current = 0203 * NextYr = ( Current + OneYear ) R(0)#4 would be simpler??? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of djordan Sent: 31 March

RE: Modern Universe - was: The lists are closing

2004-03-29 Thread djordan
Hi Joe I have worked with variety of databases and I think using one performance statistic to evaluate the capabilities of one database against another is meaningless. As a professional I consider all databases for any business requirement and select on their merits. To discount MV products

RE: Modern Universe

2004-03-29 Thread djordan
Hi Joe The area I push Uv is complex transaction processing. RDBMS are designed for High Volume Simple transaction processing. When the Business rules become complex and there is a high level of crossreference, Uv outperforms. A Pick application runs in virtually every bank in the world from

RE: Writing a RPC Service

2004-03-26 Thread djordan
Hi Michael The only thing I can think of is to restrict Access to Universe for this account, so that they cannot write, update or delete for this user group. Create Subroutines that have this access writes to write Delete by using the Authorization statement in the code, which allows you to

RE: UV on Itanium

2004-03-10 Thread djordan
If my memory serves me correct, Intel eventually had to get alpha intellectual property to get Intel 64 off the ground. And the guy behind AMD 64 was one of the architects of alpha. I had to chuckle after attending an HP session about converting from 32bit to 64bit Intel platforms, it was the

RE: [UV] Change prompt?

2004-03-08 Thread djordan
Another method if you are using a terminal emulator is to use the login paragrah to change the title of the session at the top of the screen. I also try to change the screen color, ie Red background is the live account which you should also be able to set through the login paragraph Regards

RE: UV losing print characters

2004-03-02 Thread djordan
That is a common issue of comms where the buffer is overflowing. Check how the printer is connected, serieal, TCP/IP. Also check the distance of the printer from the computer and issues of electrical noise that could corrupt information going down the line. Regards David Jordan -Original

RE: InValid Characters

2004-02-06 Thread djordan
The easiest way I got over this is to select the file by @ID. The control characters are usually at the top or the end (by.dsnd) Then do an ED file And then delete the record, stepping through the select list. Regards David Jordan Managing Consultant [EMAIL PROTECTED] Dacono Holdings Pty

RE: Help with UniObjects

2004-01-28 Thread djordan
Check the vb code for a fatal. Make sure you have some on error statements in the subroutines. It sounds like something has caused a fatal and continued due to a resume next statement, but that the ObjSessiont is now nothing. Check and see if the ObjSessionis still active or is now set for

RE: mkdbfile: create file in another account

2004-01-27 Thread djordan
Title: Message Hi Kate You could set up a VOC Paragraph or a program in the remote account that reads parameters from the command line as paramters for the CREATE FILE statement. Then all you are doing is using the EXECUTE 'DOS uvbinpath\UV remoteacc\PROG fn mod " At least this