RE: [U2] UniVerse and Shadow copy on Windows 2003
Hi Ron Thanks for that. Are you aware of any issues I need to look out using this? Regards David Jordan Universe 10.2.2 on Solaris 10 ASSIGN 1 TO SYSTEM(43) to suspend And 0 to un-suspend Or UVSUSPEND.FILES ON/OFF (APP.PROGS/UVSUSPEND.B) Ron Bertrand --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse and Shadow copy on Windows 2003
Hi JayJay The transaction processing will not write incomplete transactions to the disk file at the time of suspend.file protecting transactional integrity. I believe that the dbpause completes any writes before pausing. However one area I am not sure of is the data in buffers. The suspend program mentions checking buffers are flushed. This could be an issue for sequential writing. Regards David Jordan However, I too am curious about the Server 2003 VSS (not *nix, sorry!). Running it cannot cause corruption to the Unidata files even while people are logged in -- is that correct? From what I've read, Server 2003 lets the processes finish their disk writes, pauses the processes on an OS level, writes the disk branching information, and then resumes the processes. Programs wouldn't even known it's happening. Even deleting the VSS restore point is a safe operation as far as I know in that it simply writes the new file indexes stored in the restore points into the master file table, right? That's where the VSS awareness comes in, right? Programs that are aware could ensure data integrity through transactional logs. I'm guessing it's the restore that would be the issue. Although the processes would finish their writes, that would just be for one block of data and you could be missing part of a record in a file or even have inconsistencies between files if you tried to restore. Risky, risky... I guess my question now is: *on Windows*, do the dbpause/dbstart or SUSPEND.ON/SUSPEND.OFF commands ensure structural integrity to some extent, like Martin Phillips said earlier? If I start to write array variable ABC containing 10,000 items 1000 characters each in length to a file, and that file is only valid if ABC is completely written, will it let ABC finish writing to that file? Will I have to check after the restore if only 9,999 items were written? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Debug problems with 10.2.4 Reality format
Hi Brenda You have continue statements that would not reach that debug statement. I suspect that the test data is different to the live data and hence the program is not acting as you expected, rather than an issue with the debug statement. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniSelectList problem
Hi Charles Use the slap.lastrecordread property to check end of select rather that key . You could run into funny issues including type mismatches that could fall over. Also aren't you meant to look in field 3 not field 2 of the key for 000. If you are new to VB, it is worth considering your design. With Client server, it is important to keep the business logic close to the database and not with the client. The client should be more for display logic. If you keep the business logic in subroutines in Uv, then you can reuse the business logic for web pages, web services and other applications. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniData to UniVerse Translation??
Hi David You probably want to look at BY.EXP and WHEN for dealing with multivalues in UniVerse Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ReadListAsStringArray Returns Nothing
Hi Charles I suspect the select you created is cleared at the end of the command or beginning of the select initiation. Try the following options. - Select to 1 instead of the default 0. The default may be cleared as part of the initiation process for the select method. - Try saving the select list and using the get list option. Returning xml from unibasic through a subroutine There are 2 options 1 use U2 xml routines to build the xml string. 2 load the data into a .Net dataset and use the dataset xml facilities (.Net 2.0) You could also consider the UniDataset class. I suspect that most are doing this sort of stuff within subroutines for reasons of best practice in a client server environment. Regards David Jordan Subject: RE: [U2] ReadListAsStringArray Returns Nothing Is there anyway to report bugs to IBM? There appears to be a problem with ReadListAsStringArray, or possibly CreateUniSelectList. Charles Shaffer Senior Analyst NTN-Bower Corporation --- 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- HTTP secure logins
The application checks to see if the user has access to the web page. If the user does not it should go to a login page to prompt for username and password. To by pass this, you may be able to call the login page, feed username and password and then call the page you require. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Stringing commands together on the command line. Possible?
If you had a program such as example below ED BP TEST.BREAK 3 lines long. : P 0001: PRINT ENTER NAME : 0002: INPUT NAME 0003: EXECUTE LIST VOC :NAME Bottom at line 3. RUN BP TEST.BREAK ENTER NAME ?~DOS /c DIR It will list the VOC then execute the DOS command DIR. In Unix the SH shell command would probably do the same. There are security measures that can be taken to mitigate this. Using the voc security routine, Cleaning control characters out of inputted data. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Stringing commands together on the command line. Possible?
Hi Brian I can achieve it with Ray's control character or paste it from another application. This does not work from TCL, but does work in an execute command within a program as demonstrated below, allowing a user to get to operating system commands. Regards David Jordan If you had a program such as example below ED BP TEST.BREAK 3 lines long. : P 0001: PRINT ENTER NAME : 0002: INPUT NAME 0003: EXECUTE LIST VOC :NAME Bottom at line 3. RUN BP TEST.BREAK ENTER NAME ctl-^DOS /c DIR It will list the VOC then execute the DOS command DIR. In Unix the SH shell command would probably do the same. There are security measures that can be taken to mitigate this. Using the voc security routine, Cleaning control characters out of inputted data. Regards David Jordan Managing Consultant --- 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] Phantom creating Zombies
Hi David Just a thought, but you could change your approach to this and use some newer technologies such as MQ or web services using connection pooling. These are designed to handle issues like you have mentioned better than the phantom process. Regards David Jordan Managing Consultant [EMAIL PROTECTED] Mobile: 0428 669 730 Phone: 61 2 9418 8329 Fax: 61 2 9427 2371 PO Box 909 Lane Cove NSW 2066 Australia www.dacono.com.au CAUTION: This email and any attachments are confidential, may be privileged, and are intended for use solely by the addressee. The confidentiality and/or privilege in this email is not waived, lost or destroyed if it has been transmitted to you in error. If you receive this email in error, please notify Dacono by reply email immediately, delete the email and destroy any printed copies. You must not disclose, disseminate, distribute, reproduce or use the information contained in this email which may contain intellectual property or copyright irrespective whether you are or are not the intended recipient. The content and opinions contained in this email are those of the individual sender and may not necessarily reflect the views and opinions of Dacono. Dacono does not guarantee that this email is free from viruses, errors, interception or interference. Use of this email and any attachments is at the sole risk of the user. Dacono does not accept any liability for any loss or damage to your computer system or network (including any consequential damage) which may occur directly or indirectly from the use of this email. -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Norman, David (SAAS) Sent: Monday, 5 November 2007 9:52 AM To: u2-users@listserver.u2ug.org Subject: [U2] Phantom creating Zombies UV 10.0.16 (Information) HP-UX 11i We have a permanently-running phantom, which needs to periodically start another phantom, with both phantoms running independently. When the 2nd phantom stops, that process becomes a zombie until the original phantom stops (which is preferably just about never). As these zombies mount up, we get to the situation where the id associated with the phantom can't run processes or even login until the zombies are cleared (by stopping the first phantom). Our work-around is to stop and restart the first phantom weekly, but we really don't want to have to do this. It's no good just running the BP of the second phantom, because then the first phantom pauses until the second phantom stops. Is there a better way of one phantom launching another without the zombie problem ?? Thanks, David Norman Senior Software Engineer SA Ambulance Service Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * [EMAIL PROTECTED] --- 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] Universe on Windows Vista
Hi Dianne I have been testing with the PE environment before moving to live. The version 10.1 would not run properly with vista, I could not access telnet and the rpc was not robust. I download 10.2 and this seems to be working with no problem. The administrator and other U2 eclipse tools are not compatible with the vista graphics and vista downgrades graphics to run these. Otherwise performance wise it seems OK. Vista does like memory, performance is average at 1G memory but good at 2G. Some VB6 applications do not work in Vista and if you use VS2005 you need to install an additional service pack after service pack 1 and run it in administration mode. (SQL Server 2005 also needs a special service pack.) As Vista does not have administrator user as you would have had in XP, you need to initialise the administrator user in the control panelusers as this was often used to set up as the root users for universe and has the SQL authorisations. There is an option in the application properties to run an application in administration mode (for compatibility issues) and you may need to do this for any apps that are not performing well. VPN is an issue particularly if a site uses CISCO PIX firewalls. Microsoft no longer accepts MS CHAP 1 authentication, only MS CHAP 2. Some firewalls do not handle MS CHAP 2 and this has caused issues. The alternative option is to run virtual pc with windows xp or server 2003. With 2GB memory this works fine and is great for demoing server applications like sharepoint. I am able to access VPN from the Virtual PC to sites that the host vista does not allow. Otherwise after a few weeks of hair pulling it seems to be performing well. Regards David Jordan Managing Consultant [EMAIL PROTECTED] PO Box 909 Lane Cove NSW 2066 Australia www.dacono.com.au -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Tuesday, 15 January 2008 6:49 AM To: U2 List Server Subject: [U2] [UV] Universe on Windows Vista Does anyone have experience running the latest Universe version (not PE) on Windows Vista Professional? It's not listed on the product matrix, but ... Thanks! -Dianne --- 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] Problems with disconnects - telnet
Hi Gabe With Remote Desktop Connection, as the terminal emulator is running on the server, if the connection drops, the terminal emulator is still connected to the server and you can reconnect and continue from where you left off. Also as the session is tied to the user through login and password, you can avoid someone accessing another person's session. I have not tested this on terminal services environment, but as RDC uses terminal services, I would assume this would work. Maybe setting up a terminal services environment would be the cheapest and quickest solution. You should look at Windows 2008, where the end user can access an application through Remote Desktop Connection, and it is so seamless, it looks like just another application on the user's PC. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObjects error 30105 Unable to load subroutine on server
Hi Wol UniObjects does not like returning unassigned variables, it causes a fatal. In the unibasic subroutine, you could check if the parameter is unassigned and set it to before returning. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Change SCHEMA name in UniVerse SQL
Does anyone know how to change the SQL schema name for an account in UniVerse. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Change SCHEMA name in UniVerse SQL
Hi Ray To drop schema means that you have to drop all the tables as well? The moving of scemas, copying schemas, etc in UniVerse is very painfull, there must be better ways. Ie copying a test account. Regards David Jordan Managing Consultant -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Monday, 11 February 2008 7:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Change SCHEMA name in UniVerse SQL The only legal way is DROP SCHEMA followed by CREATE SCHEMA. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] FORMAT.CONV -export for SQL SCHEMA
Has anyone ever used the FORMAT.CONV export and import options for transferring SQL tables between schemas in Universe. I have never got this to work as by instructions in the manual and wonder if anyone else has made it work for universe. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] FORMAT.CONV -export for SQL SCHEMA
The Import process falls over with SQL statements going over one line and using _ statement. CREATE EXISTING TABLE BB_LOAN_APPLIC2 (_ + SQL+ACC_NO VARCHAR NOT NULL PRIMARY KEY FORMAT '10R',_ SQL+ UniVerse/SQL: ; unexpected I am exploring ways to cleanly copy a schema to a new schema. It looks like you have to build from scratch all the tables and then copy the data across. Regards David Jordan Subject: RE: [U2] [UV] FORMAT.CONV -export for SQL SCHEMA We did get it to work during the original UV/SQL training run by Ted Hatch. I have not tried it since. I do recall that it's quite fiddly to set up. --- 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] UD and SBS Server
Hi Bill One of the issues from UniVerse was users not having read/write access to the temp directory under \ibm\uv\temp Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD and SBS Server
Hi Bill This is an old problem with UniVerse on SBS that only those with admin rights could login and I am sure it had been resolved. Chase up IBM support. Other option is to change the services login for the UD telnet server. Try allowing service to interact with desktop. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Question about the U2 News Flash...
I believe U2.Net is mv.Net customised to work better with U2 products. Regards David Jordan 1) U2.NET Beta available and 2) developerWorks article on U2 and IBM Data Server Provider for .NET So... These two items are both to get .NET code working, but each uses a different process to do it? Is the U2.NET going to 'obsolete' the logic and ideas presented in the IBM DSP article? Seems like IBM is pushing full steam ahead on .NET -- the new SB+/XA included... The question is how do I/we know which 'avenue' to follow? What is the general take? U2.NET worth holding out for compared to using the ServiceProvider? I've only started playing with this functionality to know what options are there - is U2.NET going to make things easier and worth waiting on? 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] INCLUDE weirdo
Check that the SNIPPETS file is type 1 or 19 I use $INCLUDE also. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Sharepoint Pick
Hi Ryan I took the web services route and used uniobjects in the web service to talk to the database. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 and winserver 2008
What version are you trying. 10.1 does not work on Vista, but 10.2 does. Also IBM has stated that they will support 64bit Win 2008, but not 32bit. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 and winserver 2008
The underlying technology is similar to Vista, hence if you have compatibility issues with vista, you will likely have it with Win2008. The problem with vista, is that it has to cope with every mom dad machine, every corner store computer shop, every device coming out of all sorts of nooks and crannies. What is the main issue is that there are not the device drivers out for Vista. However from a server end, hopefully people are more discerning about devices they use and there will be less of an issue. Before knocking 2008, people should have a look at it. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] VISTA and U2 Tools
Hi Brenda Universe as a database needs to be Rel 10.2 to run on vista. I have run the latest versions of Wintegrate and dynamic connect and they work alright. Uniadmin and webtools has a slight incompatibility with the screen resolution, and Vista down scales resolution to cope. You may have to run some applications as administrator to make them work. Also look out for some VB6 applications may stop working. Be careful of the VPN gotcha. Vista does not support MSCHAP1 and many VPN/routers do not support MSCHAP2, hence vpn does not work in some cases. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] problem with SQL Users
I just upgraded to Uv ReLease 10.2.8 PE on my laptop. It does not recognise me as a sql user, even though the the login name is in UV_USERS. The difference is the user name in UV_USERS has the domain name in lower case, but if I do who the domain name is uppercase. This is the username that loaded Universe, so it should be the uv user. I suspect it is a bug, related to casing, as I am sure this was not a problem in the previous release. Has anyone come across this problem in the latest release Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] problem with UniVerse SQL Users on windows
Hi Ray Mapping in UV.LOGINS does not help. UV_USERS has domain\user, and if you type WHO, you get DOMAIN\user, the difference being casing. There is no way to force the login to be in lower case and no way to change UV_USERS as I am not a valid SQL User. UniVerse has made NT AUTHORITY\System the default DBA, but as this has no password as an internal user, I cannot login as NT AUTHORITY\system to create a new SQL User. When you hit this type of issue, there appears to be no tools for an administrator to get in to resolve problems, it becomes a lockout situation. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] problem with UniVerse SQL Users on windows
Hi Ken The user NT AUTHORITY\System is an internal windows user name. It is part of the internals of windows and adding a password to it could cause all sorts of things to stop working. It is not a login name, hence I am not sure why it is now being used as the default SQL DBA in universe on windows. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] problem with UniVerse SQL Users on windows
Hi Ken With windows the installer was the default SQL Account, which is usually the administrator. It is in updating to the new release that has changed the way things have been done. My actual issue is that UniVerse no longer recognises current SQL users, the only thing I can see is that the domain name is in a different case to that which is stored on UV_USERS in the SQL Catalog. The second issue, is that it does recognise current SQL users, I have no SQL DBA access to UniVerse to resolve issues. Hence locked out. Regards David Jordan Managing Consultant David - Install instructions for UV on Unix states that you need a uvsql user for this purpose which needs to be setup prior to the installation. Have you checked the Windows installation instructions in the UV docs. You might not have setup the default user prior to the installation. Ken At 01:00 PM 4/4/2008, you wrote: Hi Ken The user NT AUTHORITY\System is an internal windows user name. It is part of the internals of windows and adding a password to it could cause all sorts of things to stop working. It is not a login name, hence I am not sure why it is now being used as the default SQL DBA in universe on windows. Regards David Jordan --- 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] problem with UniVerse SQL Users on windows (Domain name is now case sensitive)
Hi Ken 1. I did install as the same user 2. You are right that the domain name is case insensitive in windows, however it appears UniVerse is case sensitive when check against UV_USERS for valid SQL Users. 3. Security of the directories are OK. I eventually uninstalled UniVerse and reinstalled. Now in UV_USERS all domain names are in uppercase and it recognises SQL users. Problem: IBM is making domain name case sensitive and this will effect anyone upgrading where domain names are in lowercase in SQL_USERS. Regards David Jordan Managing Consultant [EMAIL PROTECTED] Mobile: 0428 669 730 Phone: 61 2 9418 8329 Fax: 61 2 9427 2371 PO Box 909 Lane Cove NSW 2066 Australia www.dacono.com.au CAUTION: This email and any attachments are confidential, may be privileged, and are intended for use solely by the addressee. The confidentiality and/or privilege in this email is not waived, lost or destroyed if it has been transmitted to you in error. If you receive this email in error, please notify Dacono by reply email immediately, delete the email and destroy any printed copies. You must not disclose, disseminate, distribute, reproduce or use the information contained in this email which may contain intellectual property or copyright irrespective whether you are or are not the intended recipient. The content and opinions contained in this email are those of the individual sender and may not necessarily reflect the views and opinions of Dacono. Dacono does not guarantee that this email is free from viruses, errors, interception or interference. Use of this email and any attachments is at the sole risk of the user. Dacono does not accept any liability for any loss or damage to your computer system or network (including any consequential damage) which may occur directly or indirectly from the use of this email. -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Ken Hall Sent: Saturday, 5 April 2008 10:49 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] problem with UniVerse SQL Users on windows Hi David - Did you do the upgrade with a different user that the original install? If so, uninstall UniVerse and re-install it. It should leave all your user stuff alone, and after the new install, instead of an upgrade, things should be fine. You should however, logon to each account as the administrator who did the install to auto run UPDATE.ACCOUNT. Also, the domain name is case insensitive in Windows authorization. Also, it may be a permissions issue after the update. I have had this type of problem with a Unix update. Check all the permissions on the UniVerse files, especially in the .uvhome/uv/bin directory. Hope this helps. Ken At 03:28 PM 4/4/2008, you wrote: Hi Ken With windows the installer was the default SQL Account, which is usually the administrator. It is in updating to the new release that has changed the way things have been done. My actual issue is that UniVerse no longer recognises current SQL users, the only thing I can see is that the domain name is in a different case to that which is stored on UV_USERS in the SQL Catalog. The second issue, is that it does recognise current SQL users, I have no SQL DBA access to UniVerse to resolve issues. Hence locked out. Regards David Jordan Managing Consultant David - Install instructions for UV on Unix states that you need a uvsql user for this purpose which needs to be setup prior to the installation. Have you checked the Windows installation instructions in the UV docs. You might not have setup the default user prior to the installation. Ken At 01:00 PM 4/4/2008, you wrote: Hi Ken The user NT AUTHORITY\System is an internal windows user name. It is part of the internals of windows and adding a password to it could cause all sorts of things to stop working. It is not a login name, hence I am not sure why it is now being used as the default SQL DBA in universe on windows. Regards David Jordan --- 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/ --- 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] UniVerse SQL Tables
Gerry If you define a column as integer and that attribute is not an integer, then the write will lead to a fatal error if you do not have opencheck or on error options built into your code. If you do not define a column as multivalue, then it will have a problem with multivalues. If you do not define the column, then there is no type checking. The big issue to consider with SQL Tables is moving accounts around. With the SICA attached to the tables, it is not as easy to copy an account to a different area or to duplicate account for testing as you would do with standard files. You cannot change the schema name, so when you copy the account you still have the same schema name in the duplicated account. Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] passing file pointers?
Use the Fileinfo routine. If fileinfo(fv,1) = (if 0 not open, if 1 open) This checks that is a valid file that is open. This is good practice to test the file is open before opening, as reopening the file clears all previous record locks held on that file by that user and can cause fatal errors when using transaction boundaries Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Record Locking Problems
Bill I think your problem is related to re-opening the file in the subroutine. Everytime you open a file you clear all the previous locks. Ie the user opens file, locks record and then opens file again there is no record locks. Use a fileinfo statement to check file is open and if it is skip opening it. Regards --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Problems with the IBM DB2 U2 Dotnet provider and vista
Has anyone had a problem installing the new IBM.Net Data provider Ver 9.5 service pack onto Vista. When you double click on the setup.exe and click the Vista allow access, it comes back the program has stopped working. The Ver9.5 installed OK on Vista (it just does not connect to U2 databases), however the service pack does not. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Ruby on Rails and PHP
Hi Mike It may be worth looking at the IBM database client, where IBM is using one client to access DB2, Informix and U2. U2 is using this for a .Net data provider. The client also has a ruby on rails and PHP interfaces and it may be worth talking with IBM if this could be taken advantage of to enable you to access U2 from Ruby on rails. This may require building a business case to IBM why this is beneficial and how many other users want ruby on rails and php access. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] locking code question
You could look at SQLising the BP file. Having a SICA, you could restrict read and update to all users and have a BASIC program manager with the AUTHORIZATION command, handle check out, check in, compilation, etc. This means that programs could only be accessed through the program manager and not directly. This would only work on UniVerse as I believe UniData does not have the AUTHORIZATION Command. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] locking code question
Hi Clif You are right, you cannot SQLise 1,19 file types. However I think the authorisation command would still work if you changed the OS permissions. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata 7.1 ODBC Threading Problems?
This is just a wild thought as I do not know the details of what you are doing. Maybe look at a transaction process around the routine, where you set the transaction level to the lowest. When operating in ODBC you need to deal with RDBMS logic more that U2 for file processing. To get a clean read of a database file, the theory is that you need to lock the file to prevent others updating until you completed a series of reads. Ie if you wanted to total the General Ledger File, it is possible, that while you are reading the GL file, someone else Debit an account you have processed and Credits account that you have not processed, which would make your report not balance, hence why you should lock the file in this type of situation even though you are just reading. By default ODBC might lock that file, it maybe also caused by the ODBC parameters you set up in the calling routine. Words like exclusive, means I have to lock the file. As your routine is not handling an environment like this it maybe causing a fatal for an unexpected expectation. Regards David --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] New .Net data provider (Vista)
Hi Brian Have you been able to load the new .Net data provider on Vista. IBM tells us we need to load SP1, but this just crashes on Vista and IBM has not been able to duplicate, even though another client in the UK is having the same problem. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: ODBC problems
Hi Anthony It may be an issue with permissions for the temp directory where the sort is occurring, whether on the PC or the server. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] [UB] Equating Two Arrays in UniBasic
Hi Bill The variable has probably been set up as a dimensioned array somewhere else in the program or an include file. Ie DIM Var(10) Regards David Jordan Managing Consultant --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uniobjects help needed!
Hi Doug I usually would create a como in the Basic routine to capture any error messages that might come up in the subroutine when calling from uniobjects. Thoughts you could consider. 1- A filtering/trapping application from a virus, spam, web filter, instant messaging that is filtering the port. 2- The UV Login has a login paragraph or other security application that is interfering with the call of the subroutine. 3- An encryption process has been turned on. 4- Someone has setup data at rest. 5- Running VOIP that gives priority to VOIP traffic and causing timeouts on U2 traffic. 6- Issue with XP Service Pack 3 or Vista 7- Does telnet suffer similar issues across the same network. Is their noise on the line? I have never seen corrupted data between rpc server and client. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] uniobjects
Hi Doug One of the problems is that VB6 is not really supported. As the security packs are added to XP there is more chance that a security pack causes issues for VB6. Of course .Net is supported. If you upgrade to vista it is likely not to work at all. Check users are super users on the client. If you can make changes to the VB6, try and move the install out of program files and keep registered dlls from the windows directory. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: RE: [U2] Why Develop in UniVerse?
A U2 reseller has just replaced a SAP site in Australia. A good CFO should be evaluating the business case. Also many businesses are getting hamstrung by the lack of flexibility in some of these systems and U2 applications are coming out on top in that area. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SOAP in Unidata 6.1
Hi Tony One of the reasons to keep everything in the U2 environment is that it is nice for an ISV when you have little control of the environment you putting the product in. If you can just load universe on the server and everything works life is easy. Every time you layer another product, it is one more thing that can go wrong. I have had to put applications into difficult, high secure environments and the simpler the environment the easier. It is also cheaper as you do not need as many support staff. What makes me nervous and this includes IBM tools, is that clean simple environment to install and support is not as easy to do and it is something all tool providers need to focus on if they want ISVs to include their tools. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help!
Hi Laura Have they check the temp directory access rights, users require read write access to the temp directory. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Leaving U2 World to the Dark Side (SQL)
Whilst RDBMS allows easy direct manipulation of the database through products like .Net, the reality is that it is a nightmare if not thought out properly. If the business logic is in the client and you have a 1000 pcs, then a change to the business logic has to be sent out to 1,000 pcs at once. Then there is the issue of PCs being restored or offline when the update is occurring. If the business logic is at a central site, then it only has to be changed once. Also that same business logic could be reused for web services, web sites, mobile devices etc. This is why U2 is so strong as it has a powerful business rules programming language that runs at the database, that far outstrips the database programming languages of RDBMS. Whilst SQL Server allows .Net to be a business rule language they also warn of the performance hit. Those dealing with RDBMS usually implement an application server, which hosts the business rules at a central site in a friendlier programming language than what the database has. For U2 the application server is combined with the database, instant cost and performance saving. Whilst it may be simple to link a dataset to a database and drag and drop it to text boxes on a client, one can be creating a rod for their back as business logic on the client will be a nightmare to support. What many do is link the dataset to a subroutine output thus keeping the logic on the database. If people want to link datasets directly to the database in .Net/java then they should look at 3 tier client server with this being done in the middle tier (application server) Just my 2c on this subject Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Another probably simple SB+ issue.
Hi Jeff Check the default printer for that PC. It probably has no printer so it is saving the print image as a file Regards David Jordan Managing Consultant da...@dacono.com.au --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [u2u] UV on Windows question
Hi Brian Where is the registry change for the DOMAIN\username in windows, I have been caught by that problem before and did not know their was a simpler solution. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web services
I am trying to work out how to identify who the person is that is consuming a web service using the U2 web services developer. I know techniques to do it in .Net. How do ensure that a person is authorized to consume that service. What approaches have others taken to tackle this. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web services
The Web Services Developer is very quick and easy to set up a service talking to a Basic Subroutine. The only issue I have is the authorisation and why in the past I have used .Net. I was trying to work out whether PAM/LDAP could be used as it is available with UniVerse 10.3, but there is little documentation. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Basic Developer Toolkit - Eclipse SDK
As eclipse is talking to Universe through java uniobjects, I suspect that half the work is already done to be able to duplicate this on .Net. It is really a requirement of someone duplicating the eclipse functionality in .Net and use the same calls to the database David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Telnet service won't start
Hi Francis It is in the Services section. Click on the required service and select the second tab which I think is the logon tab. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Program Comments/Documentation/Notes/Revision History
Think about using xml for documentation in the source code, then some external tools can be used for documentation. *subRoutine to * modAdded to * mod Date . * mod Author Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Running total from UniVerse dict
Hi Kate I believe you are looking for the @ variables to solve your problem. I think in the uv help they come under the @ in the same area as the screen commands Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV global catalog in Pick flavour
I wanted to catalog a subroutine globally so that it could be accessed by IBM .Net data provider for U2. But the catalog routine does not allow this in the PICK flavour of UniVerse. Has anyone found a way round this. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multivalue market and users
If you are looking to justify to higher management multivalue penetration do not forget to add Intersystems users to the list, they are multivalue even though many are not PICK. Also you need to take into account that multivalue systems are based on concurrent users where RDBMS are based on per seat licenses and also additional license for mobile devices and so on. IBM has still experienced double digit growth for U2 for a number of years, which they are not getting from other products. Multivalue products are sold as part of applications, so it is often best to talk about vendors that provide banking systems, car dealerships systems, library systems, health systems, MRP, ERP systems, university systems, etc. Also in the current market, I have found the ability to deliver on time and budget, low resource requirements and real ROI are far more valuable in the current economy, than brands. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV on Windows
Hi Jerry The windows version works pretty much the same. I have found select lists to perform far faster in windows than unix, I am not sure why. You should also look at using Virtual environments, a number of our clients are beginning to use this and UniVerse seems to work well on this. With windows servers, a lot of clients are using backup snapshots multiple times a day. You should look at building database pause and start as part of that process. You will need to modify security policy to allow users to login to the server if they are using telnet, this is explained in previous u2-list emails. You can switch on the Unix routines on in windows. You need to be careful of virus software on the server running on the windows server as some conflict with UniVerse. My biggest pain is dropped processes that hang onto record locks, it is often a convoluted process to release them. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] xml mapping file question
Hi Norm Have you found any tools to help generate the excel stylesheets other than manual coding. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Better and Better Application - Launching today Friday 8/21/09 -- Browser instructions
There has been an issue about the application being implemented differently to what it was designed for and this is causing the browser issues. Please do not criticize the tools and applications, nor make derogatory comments about designers as it is totally uncalled for and defamotory. This has been a project done by volunteers around the world working in their spare time. This is a tremendously difficult task of communicating between people in different timezones who have to also work in their paid jobs. It is no mean feat to coordinate a project around the world with so little resources. There is no funding for this project and it is done out of the kindness of others. When you have an environment like this, there is bound to be misunderstandings, miscommunications and teething problems. Please give the user group a chance to resolve the issues before tearing it apart, furthermore volunteers are always welcome. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Change is a coming!
This company provides OEM software to IBM. This does not mean IBM won't continue to sell U2, this is still to be explained. In this crisis companies like IBM are looking to focus on their core business and U2 is a different beast. This does not mean its good or bad, just different to everything else they are doing, hence I would see this as a strategic move rather than a sell off. I would not take the view that Rocket is just sustaining technology, they have modern products and are developing new technology. They don't seem to have a list of old solutions. What I would say to management at the moment, is that they are more secure than most other platforms with a guaranteed path of continuity. There are several mv vendors out there who are successful and growing. It is not as big a task to move mv platforms as it is with RDBMs. The mv market is a vibrant market, well established in banking, distribution, ERP and MRP with leading companies. U2 business has still been growing double digits for many years now. IBM was great for brand name, but it was restrictive for U2. Rocket does not have the branding, but it will be more dynamic. Any organisation, has one focus and that is to make money. If Susie puts a business case and shows a return, then Rocket will pursue and develop the business. Informix and IBM never bought U2 as a product, it came with the baggage. Rocket has made a strategic decision to buy U2. Whilst being cautious, it is too early to say that this is negative and there are reasons for optimism. Like anything in life, it is what we make of it. Informix and IBM were both staggered at the passion of the U2 community, and if we present this to Rocket, they will be too. So at the moment, I have cautious optimism to the future of U2 and as a user group we can hopefully make it successful. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] u2/rocket/datastage
Datastage is not part of U2. There is no comment about it being sold and I doubt if it would. It is a strategic component of their business intelligence stable. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of doug chanco Sent: Thursday, September 17, 2009 12:05 AM To: u2-users@listserver.u2ug.org Subject: [U2] u2/rocket/datastage has anyone heard anything about datastage? Since it uses universe I would think that IBM would of sold it as well ... dougc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] U2 come back
One thing I have noticed from the GFC, is that management are no longer impressed by sparkle. They are looking for delivery and some of the market leaders have a reputation for not delivering, for cost blowouts and failure to perform to expectations. When times are tight, management are looking for cost effective solutions that deliver. There has never been a better time to grow the U2 market than now. That PICK is inferior is a mindset, the grass is not greener on the other side. I have dealt with other products and some of the stuff they do is archaic. One brand name GL that has replaced PICK general ledgers with something that is supposed to be more modern is a COBOL application. It is all in the marketing. I have an OEM product and my business grew 40% this past year. The IBM name did not help, it was sold on its merits and what it delivered to management. IBM marketing was no help so no loss there. I am seeing situations where users are talking about dropping brand name GUI general ledger packages and selecting a character based green screen general ledger. We just have to look a cache and see what they have done with Mumps technology. The problem with U2 is not the technology, it is a failure to sell its strengths, to have direction. Get some switched on people and U2 sales will go through the roof. It is attitude, attitude, attitude I have seen 20 years of change from Prime to vmark to Ardent to Informix to IBM. I am still in business. Over 20 years ago I saw the newspaper headlines PICK is dead, well the coffin is still in the corner collecting dust. Over 20 years ago I saw the headline, Unix spells the death knell for PICK, now the question is will Unix survive linux. The world will change, companies come and go. Don't judge the world on the ones that have gone, but on the ones that are coming. The GFC has caused brand name comapnies to collapse. As a small business, I use it to tell potential clients that large public listed companies do not guarantee continuity and that I provide better security of future by partnering with other businesses. The problem with the PICK market, is the siege mentality. We have bunkered down for so long in the castle, that all we think is that we are under attack by superior forces. It is a mentality that is dragging down the industry. It is time to drop the draw bridge and charge as PICK is far superior in many ways. The decision about Rocket software is a done deal, nothing we can change about that. Now it is about how to make the most of the opportunities provided by the Rocket acquisition. Focus on the positives, build on the strengths. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem with Multi-value market in general
Glen A U2 application just threw SAP out of a site it can and is being done. I believe there is a case study available of it on the IBM U2 site. The CEO stated that SAP did not deliver for the cost and this U2 application did. I would challenge the consultants who recommended SAP to advice what homework they did and what products they compared. (Doubt if they did any.) Second ask what commissions and financial incentives did they receive for recommending SAP. Under worldwide governance legislation such as SOX, these are questions that have to be answered for due diligence. These guys get away with it, because no one challenges them. Like bullies, they often run away at the first challenge. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Problem with Multi-value market in general
Cache has evolved from the old Mumps environment. This was a multidimensional flavor similar to PICK. Intersystems bought out all the flavours of mumps to form the company today. Mumps background was largely in health, so they are a major player in that industry. However they have a range of markets and are OEM as much as U2 is. I came upon cache being used for backing up student work at a private school, so it has a range of clients. As cache was already multivalue, they added the PICK flavor to their flavors just like flavors on UniVerse. What I like about Cache is that is provides competition in the Multivalue market. If Oracle had the same level of competitive providers as the mv world has, they would not have got away with their price tag for so long. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Cloud computing
Due to the structure of UniVerse and UniData, I suspect that it has a heads up in cloud computing and virtual environments. It may be ahead of the pack as it does not have the footprint required by the other RDBMS nor some of the baggage. U2 has learnt to adapt to a changing world quickly and effortlessly, I wonder how easily some of the RDBMS will adapt to the future challenges. Adaption is the strongest requirement for a technology to be resilient and I think U2 has shown that well over the past 15 years or more. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Basic developer toolkit crashing
Is anyone else experiencing basic developer hanging and crashing. I am running it on Vista and I keep having it hang. It seems to be when it is checking syntax it gets lost. For example I type something like VARIABLE(X)1,5 and before I put the it goes a wondering and does not come back. It is very frustrating as you loose your work since the last save and it breaks your concentration. I am trying to identify it is a toolkit problem or an environment issue. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 is now Rocket U2
What you say is correct Lee. However those days are gone with GFC for many large operations. U2 sales are OEM, people buy the package not the database. Even Oracle, is doing a major push to attract OEM as their sales future and so is Microsoft. Most boards, managers and companies do not even know that they are running U2, they are running an ERP system, an MRP system, a library system, etc. IBM knows it needs to sell through OEM, but it cannot get there. IBM knows that its market opportunity lies with SME, but does not know how to deal with them. Even before GFC sales to large corporations had squeezed. I remember something at a Digital sales conference. The top 20% of their customers were responsible for 70% of the revenue, however the other 80% were responsible for all the profit. The problem with big sites, is that sales had little margin, as the company wanted to say that they had these guys as customers. With the GFC, managers are looking more and more for value and delivery of results from IT and IT managers jobs are on the line. Whilst I don't see this as U2 going to increase sales 200 or 300 %, I do believe that there is an immense opportunity open up for U2 packages. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample program - to extract data from Table
With a number of the modern languages, there is a lot of code that is mind numbing boring and tedious. What is a couple of lines in unibasic is hundreds of lines in .Net, Java, etc. What is being outsourced is all the tedious unclever stuff such as defining variables and validations and other functions that don't require smarts but are responsible for a volume of the work in these languages. Ironically as in manufacturing, automation is replacing the manual repetitive work. The next release of .Net is reducing a lot of this unnecessary work. If you can structure coding to be like a production line catering for less skilled people, then you can automate it and that is what .Net is doing. Hence automation is going to kill the lucrative outsourcing business in the end. The key to survival is being resourceful, adaptive and innovative. The days of coding drones is becoming numbered. What businesses need are people who come up with innovative and clever ways of doing things that improves the bottom line. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sequentially Hashed Files
Hi Ray Are you using UniVerse or UniData. I use dynamic files and never have to resize them in UniVerse. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] unable to run universe adminstrator
Hi Dave The administrator is in the client tools download. You can find it under the trials menu option. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave R Sent: Sunday, 20 December 2009 7:34 AM To: U2-Users@listserver.u2ug.org Subject: [U2] unable to run universe adminstrator I have setup universe and universe administrator at work an it is working properly. I added the account I needed and setup a few files to handle the job. I decided to install the 2 user version at home and it is running. However when I added an older version of the Administrator it will not launch. I tried it to my Laptop and it wont launch either. I went to Rocket and looked for a newer version of the U3 administrator but cant locate one there. Enough time spent Saturday morning time to call in some exports. Is there a patch in MSW that blocks it. Is there a newer version? this ones dated 2002. Any help would be good. Dave R. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] odd problem with read statement assigning variable with random data with else clause in pick flavor
Hi Troy The problem with that code is that the else clause is taken when the record is locked. You are assuming if the else clause is taken that the record does not exist, which is not a safe assumption. I would suggest Readu citem from fv, key locked * locked options End then * then options End else Citem = end -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Logitek Systems) Sent: Wednesday, 23 December 2009 7:59 AM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] odd problem with read statement assigning variable with random data with else clause in pick flavor We are running universe 10.2.10 in pick flavor. I have a program (part of a 4gl subroutine) that simplified does the following: CITEM = READU CITEM FROM F.FILE, CID THEN END ELSE IF CITEM # THEN PRINT CITEM IS NOT NULL! END According to the documentation, when running in pick flavor, the value of CITEM is unchanged if the read fails. What happens is that CITEM is sometimes assigned to a random value and not NULL. Right now it is being assigned to zero. Last week, this same CITEM was being assigned to an escape sequence (about 8 characters long) when the read failed. CITEM is a non-named common variable. This issues does NOT happen if CITEM is not a common variable. The result also has varied if I use READU vs READ. Clearly there is a bug here in retaining the value of CITEM with a READ statement in pick flavor. Unfortunately, I have not been able to create a simple example to reproduce this problem outside of the 4gl. And this does not happen in all the code, only in one section so far and IS reproducible in this one case from logon session to logon session. Any ideas? -Troy ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Slow Universe/Win processes dropping
Hi Tony This one is a pain. Uniadmin is possibly the best option, however it is not always effective and straight away plus you really bang your head on the wall if a record is locked by one of those processes. Regards David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, 24 December 2009 6:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Slow Universe/Win processes dropping One of our clients with Universe over Windows has something causing their system to periodically run Very slowly with high CPU utilization. Rocket Support is on it. Until the core issue is resolved, client/server interfaces via UO.NET and Telnet will see that the server is not responsive for some period of time, and all they can do is disconnect the client side. Of course the server side can't be disconnected in this scenario, and unfortunately the connections aren't automatically dropping when the CPU comes available again. My question is: what are the current/best mechanisms for getting Universe/Windows to promptly terminate Telnet and UO connections when the client has gone away? Thanks! Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse haning after putting password in (win2003)
Has anyone experienced a situation where UniVerse hangs after you enter user name and password has been entered. We had this problem with uniObjects and then I tested the telnet and this is the situation I discovered. When we do a reboot the problem seems to clearaway. This is running on a windows server Regards David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Error connecting to Universe using Web Service Developer
I have seen this before. Check all the permissions such as c:\ibm\uv\bin\uvtemp Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick on Mac
The MAC OS is a version of openBSD I believe, and Universe did have a BSD implementation in the past. If Rocket had a business case for doing it, I suspect Rocket could put UniVerse on Mac. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Dynamic Connect - Mousing
Hi Bill This is a problem with Wintegrate and DC on Vista and Windows 7. I believe Rocket is looking at this, but you should make a support call to Rocket on this. If you use Windows 7, you could run DC through the xp virtual mode. You could try running DC in xp compatible mode in windows 7 and see if that works. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brutzman, Bill Sent: Wednesday, 7 April 2010 8:21 AM To: U2 Users List Subject: [U2] Dynamic Connect - Mousing An important user here (my boss) likes to use the mouse to move around our green screen applications. Although I have tried to discourage this type of mouse use, he asked me to find the answer. He tells me that this worked at one time. It is not clear to me if I changed our applications or if there were pertinent changes in subsequent releases of DC. When he does things like copy and paste say a six-digit part number such as 101234... When he pastes it, some screens will come back with 10?1234. Of course some screen validate keystroke entries such as... Read the first character of the PN and require it to be a 1 or a 3. Fixes would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Quick poll - how many use 3-tier or N-tier Architecture
Hi Baker We have 2 tier with the business rules in the database and a VB.Net frontend. We are also installing 3 tier with webservise based on IINet. The backend is UniVerse We use VB.Net as it has better interaction with office, that C# cannot easily do and it is easier for people who have not had C++ or java experience. C# developers can write VB, but VB developers don't easily handle C#, so I double the available developers with VB. We use subroutines in UniVerse as the business rules, and pass the data to datasets in .Net. Due to complexity, we find it quicker and better to keep the business rules in UniVerse Basic. As the business rules are integrated with the database, we believe there is a performance advantage over a middle tier business rule engine, but we have not tested that theory. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
Hi Kevin Are you putting the domain name in the username dn\user for the logon to Unidata? Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
Hi Kevin I suggest you try with the domain and see if that works. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
Hi Kevin It maybe permissions on other folders on that server. I would suspect that OLEDB needs to hold data in a temporary area, that temporary area may not be the same level of permissions on the box that is failing. Calling within linked server may change where that temporary area is located. Have you been able to link from that SQL Server to the other SQL Server? Regards David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [ud] Unidata as a SQL Server Linked Server via OLEDB
Hi Kevin They do the same thing in IIS. It is a security issue to restrict unauthorized users from accessing greater functionality. I would suspect this is to stop hackers being able to use SQL Queries to access the operating system and carrying out malicious activities. This is probably part of the security enhancements being made to SQL Server, maybe different patch updates between the 2 servers. Regards David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniRPC Connection
Bill At one stage in UniVerse, in Service to tick the box to allow the service to interact with the desktop. If it is a Win2008 server there are issues with User access Control. Finally I have had a problem with Win2008 with one of the rpc dlls going missing and had to copy back that dll. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, 11 October 2010 11:19 AM To: U2 Mail List Subject: [U2] UniRPC Connection I have access to multiple UniData servers and connect to these servers via RDP on Windows. I use UniAdmin to administer the UniData dbms. On one particular server I last used UniAdmin about four months ago without any problem. However, now when I try to connect via UniAdmin I get the message No RPC Connection active. Looking on the machine at netstat I see: C:\Documents and Settings\myusernetstat -an Active Connections Proto Local Address Foreign AddressState TCP0.0.0.0:21 0.0.0.0:0 LISTENING TCP0.0.0.0:25 0.0.0.0:0 LISTENING . . TCP0.0.0.0:31438 0.0.0.0:0 LISTENING . TCP192.168.20.141:139 0.0.0.0:0 LISTENING TCP192.168.20.141:1045216.52.233.221:443 ESTABLISHED TCP192.168.20.141:982375.145.23.137:1914 ESTABLISHED TCP192.168.20.141:3389192.168.20.140:56293 ESTABLISHED TCP192.168.20.141:31438 75.145.23.137:2739 TIME_WAIT . As can be seen, the service is in running and my failed attempt to connect has been noticed. I've rebooted the server and still cannot connect. I've tried several variations of login credentials to no avail and am logged in via telnet on port 9823. A look at services shows that the UD RPC services, the UD Dbms, and the UD Telnet service are all running. I can open up a DOS window on my local machine and telnet theiraddress 31438 and connect, so I know the router is properly routing port 31438 to the correct machine. Does anyone know what I'm missing on my Sunday's sojourn in troubleshooting hell? Thanks, -- Bill Haskett * / Advantos Systems, Inc./ * ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 DataVu Query
You need to populate that UD.ACCOUNT with a record for that UD.ACCOUNT. You can either manually create it or use UniAdmin to update an already created account. You may also need to fill in the description field. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bruce McAdoo Sent: Saturday, 20 November 2010 8:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 DataVu Query Using unidata 7.1, testing U2 DataVu Query, established and tested connection successfully, but unable to have any data files displayed to select via the Create New U2 Query. I was able to view files and create U2 Query when I use the DEMO account. Any ideas would be greatly appreciated. Bruce W. McAdoo Wagner Brown, Ltd. bmca...@wbltd.commailto:bmca...@wbltd.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
U2 has probably spoiled us. You should see some of the issues others face upgrading in Oracle, SQL Server, Windows and so on. We have an expectation of seamless upgrades that does not occur in other environments. For people to have software that is 25 years old still running on U2 is pretty good. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Friendfeed and U2 EDA similarities
The main benefit for EDA is to be able to tell clients that your application runs on Oracle, DB2, SQL Server, etc. At the end of the day the customer may just run U2, but it enables a VAR to meet a criteria. Tender documents might require that products have to run on Oracle that would have denied U2 applications the opportunity. Termenos has sold their pick application on Oracle. As a banking system, customers feel more comfortable with Oracle as a database, so why loose the sale when you can say I run on Oracle. The question is, how much of the Database needs to be put on the external database to satisfy a customer's expectation. Do you just transport information for enquiry/data warehouse data or do you transfer the whole transaction database. One are to be aware is that most pick applications are pessimistic locking and SQL databases prefer optimistic locking for performance. It would usually require U2 to the only application updating the database. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections 2010 - Request For Comment
to improve membership, but what I can do to help others to prosper new members and spread the message. I hope that I inspire others through passion and belief in the technology we use. Whether it is working on the beta program for DataVu, or sitting down with Microsoft to see how to port UniVerse applications onto Microsoft Azure, or to talk to new developers about the benefits of U2 or seeing how we can get U2 to be included in University courses, all of these play a small role in making U2 stronger. If there are 3,000 people all doing the same thing, think of what we could achieve. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata sessions stop at any time
Hi Marco Call support of the guys you brought Unidata from, I think there is a patch for your issue. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Antonio Rojas Castro Sent: Sunday, 20 March 2011 6:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata sessions stop at any time Hello Unidata 7.1.0 on Windows 2008 installed 2 weeks ago. 80 users logged on Unidata sessions stop at any time Event viewer show these messages Error19/03/2011 11:42:17Application Error1000(100) Aplicación con errores udt.exe, versión 7.1.0.3146, marca de hora 0x42c2d61b, módulo con errores unknown, versión 0.0.0.0, marca de tiempo 0x, código de excepción 0x8026, desplazamiento con errores 0x7549a57d, Id. de proceso 0x38bc, hora de inicio de la aplicación 0x01cbe65488e6d5b1. (1100 occurs) Error19/03/2011 12:05:21UniData Telnet1004NingunoTelnet set client binary mode failed.. (13 occurs) Error19/03/2011 11:41:47UniData Telnet1004NingunoTelnet Client/Site licensing inquiry failed.. (42 occurs) How can I fix this ??? Regards, Marco Rojas ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections 2010 - Request For Comment
The user group is for the users. If any user has an idea that we can put into a business plan then we can put it to Rocket and Rocket will respond on the merits of the plan. What is difficult at the moment is what we can do. Rocket advertises the user group in its emails, at the U2 University. Susie regularly advertises the user group in her presentations around the world. Every U2U bag has a U2UG advert paid for by Rocket. The issue of membership is about relevance to users. For a user who is using a ERP solution, they are more interested in belonging to the ERP solution user group than the U2 User group. So who is our audience, ISVs, consultants, programmers, etc. Both George in the UK and Brian in Australasia advertise the user group to their ISVs. However the ISVs rarely advertise to their customer base. We all wish we could get the message out there more, but what we need is ideas more than money. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections 2010 - Request For Comment
First Fft2001 Can we have your name. How do we know that you are not someone from a competitor like Oracle trying to make Rocket look bad. Secondly the focus on money is pointless. We don't need money we need ideas. If anyone has a good idea and it needs some money from Rocket to make it happen, then I am sure that Rocket will consider it. Rocket is not like IBM who were sucking money out of U2 to push DB2, Rocket brought U2 to grow the business and if you have any ideas that will grow the business they will listen. Throwing money at a problem does not solve it. The board have racked their brains trying to come up with ideas to touch base with all users, if anyone has ideas let us know. Thirdly the directors don't have the time to do everything that is required, many hands make light work and we need more involvement of other users. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections 2010 - Request For Comment
Thanks Ron Not knowing raises concerns of what are the motives behind the emails. Will probably means well, but misunderstands what Rocket is doing for the U2UG and some of his comments are unfair to the people involved. David ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections 2010 - Request For Comment
Hi Dawn I was raising an issue of etiquette to put names to emails so that everyone knows who they are dealing with and it is transparent that there are no hidden agendas. Not everyone knows who Will is as he has a meaningless email and he signs off with W. George would not know that Will was on the board of U2UG. I was trying to raise a perspective, that not knowing who you are dealing with raises questions about what are the motives. Members particularly new members don't know if Will is working for jBase or Intersystems or other competitors, so being upfront with who you are clears the air for everyone in discussions and minimises misunderstandings. Regards David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Opinions on Cache
From my observations, I don't quite agree on Tony's summation of Cache vs U2. Cache has the same burden as U2 in that they came from mumps where U2 came from Pick. The biggest difference between Cache and U2 is marketing where Cache takes on RDBMS and U2 is apologetic for being Pick, but that is not the issue with the technology. Cache is a multi dimensional platform, the same as Pick but in a slightly different way. U2 has SQL just as much as Cache, I have applications written in U2 that have SQL tables and SQL grants and can be accessed with SQL queries. If Cache can sell itself as an SQL database, then so can U2 they are both in the same boat. Whilst I think some of Cache's technology is clever in their object model, people need to consider some issues with Cache. Check that the ATOMic transaction model is what you expect. U2 complies to the standards, when I looked at Cache, I don't believe that they did. Also consider the continuity of the company, what is the future of Intersystems when the founder exits, where Rocket is a more established business that is not so dependent on key managers. I am currently looking at how U2 fits in the cloud environment with products like Microsoft Azure and I think the model of U2 where each table is a separate os file is better for cloud computing than Cache's one system file (similar to the approach of other RDBMs). DataVu provides a significant solution to an area of weakness in the U2 camp related to reporting. DataVu gives U2 the equivalent of SQL Reporting services and more. DataVu provides a competitive position to products like Cognos. This is one technology that I do not believe that Cache can cover off. I think it is great to have Cache in the MV world, it provides competition and will keep Rocket on its toes, both have strengths and weaknesses. However I would not agree in Tony's email that it is a better technology than U2 or that it is a solution to the management concerns who are more familiar with Oracle and SQL Server. I also don't believe that U2 is locked to green screen applications. I am seeing new generations of applications that don't have green screens, they have a range of .Net, java and web interfaces. Honestly the PICK issue does not come up as much as people think it does, nor is it a hindrance. Management are looking for ROI, they want responses to business problems and they want to ensure that Risk management is ticked off. All these can be achieved with U2 as a community we need to learn how to answer those concerns. There are some areas of U2 that need to be refined and as U2 users we need to tell Rocket where to put the priority to ensure that meets our requirements. The U2UG has set up the better and better site and Rocket has the u2as...@rs.com email. Please take advantage of these to refine U2 to meet your expectations. Regards David Jordan U2UG VP ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Opinions on Cache
I am not familiar with UniData and I am aware that UniVerse has had better SQL support than uniData. I have found that UniVerse SQL performs well. The UniVerse query engine is used by both SQL and retrieve, where they pass the query over to an optimizer engine. One thing that has been a bit slow is the ODBC driver which has been updated at release 11.1 . Also the query integrates with EDA, so I can be selecting data off a UniVerse, Oracle and SQL Server at the same time. I would be interested in comparisons in performance of a similar data file with similar indexs, triggers, etc. There is also a consideration issue whether systems are designed for fast retrieval or fast update. It is difficult to assess query performance, we all know how meaningless the old TPS tests were that the RDBMs used to quote all the time. I agree with Dawn some of Caches object model for data is quite innovative and how it propagates to client tools is nifty. With IBM U2 was under resourced, with Rocket U2 has better resources and it is in a much better position to advance quickly with new innovation, it is now time for ideas. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Opinions on Cache
Rather my point about the Pick issue is not to say that it is not a problem, it is more the perception of how to sell Pick to senior executives. Business management are not as concerned about technology as they are about results. They may have a concern or a perception about the technology being limiting but they can be convinced otherwise. What I would point out is that it is important that we as a community build the right message that argues the point. Unfortunately I hear too often people being apologetic of the technology rather than pushing its merits. Part of that problem is many people who have grown up with the PICK environment don't understand the limitations of other RDBMs. Many of the new sales of U2 are application driven not technology driven, PICK or U2 is not even mentioned. Many of the sites that are struggling with the PICK issue are sites that have based applications on the technology they have being PICK. The question is not about the technology but a concern if the application is tired. The application could be renewed two ways, replace it or put up a proposal to upgrade and renew the current application. Unfortunately many of these applications have moved into maintenance mode giving it the tired image. What I was trying to do with my comments, is to get people thinking about the strengths of U2. I invite some rigorous debate as it raises questions and generates new ideas people have never thought of. For instance with cloud computing, SQL database applications are designed to be multitenant. In other words I have one set of tables for my applications but I prefix every key with a company identifier. So on a multitenant CRM application where 100 companies are using the applications, the Customer Table would prefix the customer number with a unique identifier for each company using the application and they would all share the same table. With the structure of U2, it would be efficient enough to have a separate account for each company. Technically this might not be an issue to developers but perceptions to a business manager are different. They could perceive an issue of their data sitting alongside other company's data. As an IT manager trying to keep a Pick site, this information could stop a move to another application. What I would put to everyone at the moment is that we have been is a siege mentality over the last decade trying to convince IBM, Informix and management that U2 is a going concern. Now that Rocket has purchased U2 as a growth opportunity, the siege gates have been thrown open and we have the opportunity to attack the competition. As in sport, it is how we think that wins or loses opportunities and I believe that this is the essential issue, we need to change our thinking about Pick. In the last two years I have seen a major change in direction in IT thinking where U2 has some real opportunities. Governments around the world are having to trim budgets and they are not prepared to waste money on brand names. Larger corporations are cost sensitive. I believe U2 is in a strong position to take advantage of that change. Difficulty in finding people is not necessarily a negative. Right at the moment Microsoft SQL has a major issue that those who know TSQL are mostly 40+, I don't see Microsoft sales slowing down because of this. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
Have people who criticised U2 interfaces actually worked with other database applications. Remember the joke What hardware and operating system doe Oracle best run on, a projector and powerpoint. Too much of the competitors' products are gloss and when it comes to writing applications they become a chain and ball. When I look at competitor applications they have pretty interfaces but lack substance. I beat competitors from major companies because I provide functionality at a price that leaves the others for dead. Clients are starting to question the gloss and are looking for substance. As I have said in previous emails, it is not about the technology, it is about how it is sold. We have an Australian U2 GL package that kicked SAP out of a site, it is not impossible. For too long U2 has sold it self, however due to competition, we need to apply more money to marketing and sales people. Marketing budgets of some of the competitors are well over 20%-40% of revenue, few U2 application vendors spend anywhere near that much. Marketing statistics identified that optimists outsold pessimists. If you think U2 is not up to scratch with the competitor, then how are you going to convince the customer. Rethink how you look at U2 compared to other databases and it will change the discussions with senior management. Senior management are on bonuses and they do not get paid for buying brands they get paid for delivering results, you need to demonstrate how U2 improves their bonuses and you are in. Of course there is room for improvement in U2 products and Rocket is working on them, but uniobjects is still one of the most efficient and effective APIs that I have worked with and you can easily add gloss to tired applications with a range of client tools including .Net, java, etc. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Saying Goodbye...
HI Jake A work group license is A$570 David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Reliability doesn't raise enough issues to keep the list busy
It is the problem with a reliable product there are not enough issues to keep the list busy. If you had one of the competitor products there would be a ton of issues to deal with to keep multiple forums busy. Funny how buggy software can look good, because there are a ton of forums to deal with all the bugs. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reliability doesn't raise enough issues to keep the list busy
One of the things that U2 has is the KISS principle. What I find like in .Net, is sometimes it overcomplicates a solution. 80% of my code is in UniBasic and 20% in .Net, however I feel like 80% of my time is taken up managing the .Net code compared to 20% managing the greater amount of code in UniBasic. That is something I hear from a number of developers who develop in both environments. I agree we should not do everything in U2, but I wish some of the other environments kept it simple to. One thing I have always liked about U2 is that I always felt confident that I would deliver a project close to time and close to budget, I rarely get surprises. However with .Net, suddenly I hit strange problems relating to versions of OS, security issues, etc that muddy the waters. Hence I spend a lot of time on .Net forums seeking solutions that I just don't need to do with U2. Buggy may have been a bit harsh, but there is an issue of consistency and dependability of development. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Reliability doesn't raise enough issues to keep the list busy
Databases have become utility. I don't see many applications today advertising they run on Oracle or Microsoft, many are trying to be generic. People are more interested in buying SAP than worry what database it runs on. Those days of user base and TPC ratings are gone. Users and developers want to know does it run on the environments they want, does it interface with other applications, does it work with cloud, what are the costs, what are the returns it will deliver. They are not asking who uses the database or how many users around the world use it, they are asking who uses the application that they are looking to buy. There is nothing in U2 that stops me interfacing with new technologies. Sure I would like some more native and sometimes simpler interfaces but I have been able to do most things talking to U2. Rocket may not publish figures, but U2 is increasing staff, U2 are introducing new products such as DataVu, these are not indicators of a dying product. Less than 500 people attended U2 universities around the world which means everyone else failed to find out what Rocket is doing. Rocket created the opportunity, but people failed to take advantage of it. Stop focusing on what U2 does not do as all technologies have holes. Focus on what it does do and then work with Rocket to further improve the technology. People do not understand where they are touched by U2. Your baggage being unloaded from the plane is probably using U2. Dialing an emergency number, the operator could be using U2. Doing a banking transaction often has a pick application involved, booking a flight, membership to a union, project management of a building site, dealing with a car distributor, going to the library, managing a nuclear reactor. You name it you are being touched by U2 applications everyday. For me U2 allows me to compete with a small RD staff, small support staff and at a lower cost. I am able to deliver far more for a tenth of the cost of my competitors. If new developers are making decisions based on technology awe instead of business justification, then they will have a short life span. I don't really see why we need to know what the number of users in the market are, it is not that relevant. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users