RE: UV on W2K3 - trying to add to path

2004-03-24 Thread djordan
Hi Sara I assume you mean when you do a dos command from universe over telnet. If that is the case every time you do the dos cammand it launches another DOS command execute, like launching another shell. I am not sure if there is a way of copying the variables from the base as you can with unix.

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 giv

RE: [OT] Access Denied Continued

2004-03-26 Thread djordan
Hi Ron The difficulty of getting reconnection with the server is a problem that went away with Win2000. If I remember NT4 still does a lot with netbui for this, although I don't think xp has netbui installed by default. With the overhead cranes, you should be able to get shielded cable that shou

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 from

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 the

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 at

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 thi

RE: Data typing in MV Basic

2004-03-31 Thread djordan
9:03 PM 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]

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 Boa

Microsoft reaches settlement agreement with Sun

2004-04-02 Thread djordan
Hi This may be of Interest for the java vs .Net development directions This morning Microsoft and Sun Microsystems announced that they have entered into a broad technology collaboration agreement and have settled all pending litigation between the two companies. Elements of the far-ranging serie

RE: Conversions

2004-04-03 Thread djordan
Hi Mark I have one client that uses Great Plains. Although an old version I felt that the system was not as aligned to the work flow as many PICK systems are. There was also a trap similar to the old spreasheets in the report generator, where the calculations are directional ir verticle or horiz

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 p

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 t

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 consid

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. D

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, like

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
oup.com Take 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, jb

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 would

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

2004-04-15 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 th

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 f

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 bus

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: Database Level Encryption

2004-01-24 Thread djordan
Hi Tom I haven't follow the total chain of this, but do you want the data encrypted for external users or for other universe users. Could you not do something like with MS Windows where you set the directory to encryption, the user does not have to do anything as the OS does the encryption. You

RE: Looking for Software

2004-01-26 Thread djordan
It is also worth looking at Office 2003. You can set up the word document with xml described items like form fields. You can then save just the xml data which is the elements and values that you can pass back to system builder. I think you can reload the data back into the origional Word documen

RE: mkdbfile: create file in another account

2004-01-27 Thread djordan
Title: Message Hi Kate   The SQL Create Table command allows you to create a file in another directory and it is documented.   Regards   David JordanManaging Consultant[EMAIL PROTECTED] Dacono Holdings Pty LtdBusiness & Technology ConsultingPO Box 909Lane Cove NSW 2066AustraliaPh 61 2 94

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 w

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 nothin

RE: [ot]how much does datastage and universe differ now

2004-01-29 Thread djordan
Title: Message Hi David   How much is the universe and datastage products differ.  The other area I have been quite interested in, is where I have an application that I want to extract data out of a Peoplsoft or SAP application could I use the products datastage uses to talk to these applic

RE: [ot] Peoplesoft migrates to Ascential

2004-01-29 Thread djordan
Hi Dawn The arguments we had with Ardent management on this. Ardent Management were saying that they don't know why anyone would buy a multivalue database, whilst on the other hand they were promoting Datastage a UniVerse product, as being one of the best Datawarehousing tools on the market. Fig

RE: [UV/AIX] gzip data to file?

2004-02-05 Thread djordan
Hi David Have you found gzip from AIX reliable. I have one client who would gzip the universe sequential file (30MB) and then unzip it on a Win NT4 server and we had a high level of corruption. They don't compress and they transmitt the files in the evening now. I don't know if this was the gzi

RE: [UV/AIX] gzip data to file?

2004-02-05 Thread djordan
Stuart David has a point. What we do is a writeseq to a disk file and once this is completed the UVBasic program executes a unix routine to do an ftp of the file to another position. So if the ftp fails, the file still exists. The BASIC Program also deletes the previous file as a process of se

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 Ltd

RE: Debug problem with Distributed files

2004-02-06 Thread djordan
Add the on error option to your read & write statement. First you can use the STATUS() to identify the fatal error and second, this allows a graceful exit from the program when you have a fatal. It sounds like you are unable to resolve the key for the part file at the time of the read or write, s

RE: Real Time Data Warehouse

2004-02-09 Thread djordan
Hi Tom We customise many strategic systems to achieve this sort of facility. I would question how real time the OLAP & BI tools are never mind the database. I would look at breaking the data in two components as some details such as financial require to be snapshoted to ensure the integrity of t

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: [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 Davi

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 sam