RE: [U2] ICONV of Date - Strange result
I may have missed something but maybe an empty string value is accurate for the year . The way we are treating our planet whose to says there will be any computing going on anyway. Trevor Ockenden h: +61 2 9499 9636 m: +61 414 731 634 e: [EMAIL PROTECTED] __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.4/109 - Release Date: 21/09/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] THE variable names
Aaah! REMOVE or not to REMOVE. REMOVE has three other associated statements that make the set a very powerful and distinct statement set indeed. REMOVE has REVREMOVE and GETREM and SETREM. The only gotcha I fell into many years ago was upon seeing a statement that read... VAR = VAR I promptly deleted it thinking it had become redundant code after some sort of global editor change. To my cost it was in fact a very important statement as it resets the REMOVE pointer to the beginning thus ensuring any subsequent REMOVE upon this variable would start at the beginning. I put it back with a nice big comment to that effect. So Will please be open minded as to the need and merits of all statements as they are only unreadable to the uninitiated. My 2 cents Trevor Ockenden e: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 20 July 2005 11:33 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] THE variable names Will, There is a very good use for REMOVE. Consider a cross-reference item (inherited, not built by current programmer) which has many thousands of keys and IDs. You could select the IDs and READNEXT or REMOVE to process. Either is far faster than FOR/NEXT and extract. I've seen a 40 minute process reduced to 6 seconds (thanks Louis Nardozi) by changing to this method. To everything there is a season, and to each instruction there is a task. Regards, Charlie Noah Inland Truck Parts [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) writes: Then you are mistaken. Remove does not confuse me. Remove unnecessarily confuses other people. Why use a structure when another one, less confusing, more known, more used is readily available? And I think you missed my point, even if it did confuse me, the main thrust is to write code that is easily maintained by others, not by yourself. So whether or not it confused me should not be one of the criteria imho. READNEXT works just find for processing a multi-item list just as REMOVE does and it's much more widely used and understood. So I see no point to the Remove command at all. If you imagined that I have not opened a manual in 25 years, you are mistaken. I routinely review manuals for training other programmers. Not just Universe manuals, but other Pick manuals as well. And I have used Remove on occasion, but was never very satisfied with it. Will Johnson --- 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/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.9.2/52 - Release Date: 19/07/2005 __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.9.2/52 - Release Date: 19/07/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] THE variable names
Will wrote... I have yet to hear of a good, legitimate, use for REMOVE. OK! Good point Will. Try coding a routine like sdiff that you can find in some flavours of Unix in UVBasic with and without the REMOVE set of statements and see the difference it makes to the speed. This task was greatly simplified with the ability to REVREMOVE and the speed difference was enormous. Also, when I first wrote that routine sequential dynamic array extracts were not particularly efficient as each extract had to search from the beginning of the dynamic array string. Therefore on long strings the performance would degrade notably as it progressed. The ability to save a position in a dynamic array so you can reset the pointer to that point at a later stage is invaluable. Performance is greatly enhanced also. Will, don't balk at new and unusual statements - they help create the mystique that surrounds our otherwise mundane careers - don't you think? Cheers Trevor Ockenden e: [EMAIL PROTECTED] __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.9.2/52 - Release Date: 19/07/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE:
Dear Howard VMark was the company that developed the UniVerse Data Base product for which I have had much to do with for many years. VMark acquired Unidata and renamed itself to Ardent Software. Ardent was purchased by Informix and Informix was purchased by IBM. IBM now sell and support UniVerse. Now on another point. You say your boss may not want to spend good money keeping old data alive. Well it seems to me that if this old data is still useful and necessary then it must surely be considered current and active data. The fact that it resided in an old application is besides the point. I suggest purchasing the minimum UniVerse licences possible as this data probably only needs one or two uses accessing it at any point in time and this would keep the cost to a minimum. Hope this suggestion is useful. Cheers Trevor Ockenden Open Systems Professionals Sydney Australia m: 0414 731 634 e: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wong, Howard Sent: Wednesday, 16 March 2005 1:46 AM To: 'u2-users@listserver.u2ug.org' Subject: To all, I posted to the Chatter forum but was advise that the mail list would have wider audience for my question. My original post. In a nutshell, we know nothing about UniVerse, but need to keep the data and move them to a newer server, Unix or otherwise. Our plan is to convert the data into a mainstream DBMS, e.g. SQL Server, DB2, etc. But further research after my original post indicates that it will be very involved. Since we don't know how the data is organised in the DB, we have to assume for the worst case. I'm afraid multivalues and subvalues will trip us up. Updating to a new version of UniVerse is probably going to solve the problem, but I doubt the manager would have the appetite to spend good money just to be able to read the very old data. Please read the original post for details,. Again, any help is much appreciated. Sincerely, Howard Wong [EMAIL PROTECTED] ~~~ Original Post: ~~~ We have a very old Unix server that has to be decommissioned. On it is an application that has long since been migrated to a newer app and UNIX platform. This old app is kept around for reference, and is not being actively updated. We have to replace the old Unix box, so the old app has to migrate too. Trouble is the app uses a database called VMark, which no one around here knows anything about. I did some research on the Net and it seems that VMark was a company name, and its database product was UniVerse. Further searches brought me to this site. Am I on the right track? Can someone tell me if: 1) My understanding of VMark (a vendor) and UniVerse (the DBMS) correct? 2) If (1) is good, then is the IBM UniVerse DB the successor of the VMark UniVerse DB? 3) If (2) is correct, then is there any tool or utilities that can either (a) extract the structure and content of the database and perhaps migrate them to another DBMS (Unix or Windows), or (b) let us understand the structure and content of the DB? Any help is much appreciated. Please feel free to email me. Sincerely, Howard ~~~ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005 __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.7.3 - Release Date: 15/03/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] (ignore last email!) GE and LE question
Thank you Will! You have proved my point. In the example you used it is a string of length zero or if you like an empty string. Your example is in fact a constant, that is, hard wired into the source code. Try... X = '' PRINT X Cheers Trevor Ockenden Open Systems Professionals Can you prove that? If you examine the opcode of a BASIC program the statement Print translates to 09FF 09 = Print and FF = end-of-string So Null in this case is nothing at all, no code whatsoever. Will In a message dated 2/13/2005 3:45:05 AM Pacific Standard Time, [EMAIL PROTECTED] writes: Null will not pass the test as null is CHAR(128) and means the value is unknown. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 10/02/2005 __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 10/02/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] (ignore last email!) GE and LE question
Further to Martin's splendid explanation of Pick NULL vs SQL NULL (below) there is sometimes some confusion with the statement NULL. This has nothing to do with the value(s) NULL but refers to a No-Op statement that can be used when nothing needs to be done but a THEN or ELSE statement is required. Example... LOCATE (X, REC ; POS ; 'AR') ELSE NULL Enjoy! Trevor Ockenden Open Systems Professionals -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Martin Phillips Sent: Monday, 14 February 2005 3:44 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] (ignore last email!) GE and LE question Pick style databases have historically used the term null to mean an empty (zero length) character string. When SQL support was added, the developers of UniVerse (etc) were faced with a problem of terminology as SQL uses the term null to mean has no value. The distinction between Pick null and SQL null is always an exciting one to try to explain to novice users. Pick null is explicitly empty whereas SQL null has no value. In my experience, not very many multivalue applications actually use the SQL null concept. In UV, SQL null is represented by putting a special, configurable value in the data field, usually char(128). This is recognised by the query processor and some program constructs. Any use of the term null in the UV world generally has then Pick meaning unless you make it clear you are talking about SQL null. Hence, the original posting that raised this thread was absolutely right; a null field is an empty string. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 10/02/2005 __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 10/02/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe/Linux Performance Issue
Just a suggestion! Whenever I have encountered this type of problem there are usually oversized items involved. I MEAN OVERSIZED thus causing serious I/O and memory usage stats. Ensure the rollover process is not creating really large items. Maybe there is a log file that is getting too large due to too many updates at once. If you do find it to be the cause then let us know if you want help with it. Cheers Trevor Ockenden Open Systems Professionals -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz Sent: Monday, 14 February 2005 11:12 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe/Linux Performance Issue I am experiencing some strange behavior on our Linux machine. We have been running on this machine since October. I am just getting into some file cleanup, year end rolls, etc.. What is happening is that the machine comes down to a crawl. We were on DG/UX and this kind of thing never happened on that platform. I could 'roll' files, etc and I never experienced anything like this. Linux itself seems to be moving along fine. Anything in Universe takes almost 1/2 minute to get any response. Without the purge/cleanup programs running, everything is just peachy. The files are all Dynamic. The programs are doing readu/delete, write. That is read a record and write it to a history file and delete from current file. Or read a record, move this years data to last years fields and write the record back out. Anybody experience this sort of thing ? Anyway to tweak things up ? I have an idea that the files might not be 'sized' correctly. I also remember that Universe on DG/UX was tweaked specfically for that OS. So, maybe it was just more efficient at doing this kind of thing. Any suggestions would be appreciated. Thanks Anthony -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 2/10/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 10/02/2005 __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.7 - Release Date: 10/02/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [AD] UniBasic Program with arguments
In short - you can't. That is, you need to call it from another program... something like... 0001: CALL XYZ (ARG1, ARG2) 0002: END Depending upon how you have written this routine it may be possible to call it from a Dictionary item also but that is for another e-mail. Cheers Trevor Ockenden m: 0414 731 634 e: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Chauhan, Savita Sent: Wednesday, 2 February 2005 9:48 AM To: u2-users@listserver.u2ug.org Subject: [U2] [AD] UniBasic Program with arguments Hi, I am trying to run a unibasic program (external subroutine) that takes two arguments. I don't know how do I pass it the arguments if I run it directly from shel prompt instead of calling it from another program. I have gone through the manual, but can't find anything. Pls help. Thanks Savita. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.3 - Release Date: 31/01/2005 __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.3 - Release Date: 31/01/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Dimensioned arrays
I am trying to find the best way to update a dimensioned array where any updates/changes are inserted to the beginning of each associated field My 2 cents worth is to convert the dimensioned array into a dynamic array then perform your inserts then convert back. Refer to MATPARSE and MATBUILD statements. Dimensioned arrays are not ideal for this type of data manipulation whereas dynamic arrays are perfect. Horses for courses! Cheers Trevor Ockenden m: 0414 731 634 e: [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, 4 November 2004 11:26 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [U2] Dimensioned arrays __ ella for Spam Control has removed Spam messages and set aside Newsletters for me You can use it too - and it's FREE! http://www.ellaforspam.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 1/11/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe PTERM CASE INVERT / NOINVERT Preferences
I am a programmer and I prefer the CASE inversion. However, our 4GL tools (in-house) sorts out the case and all users of the software have a totally consistent CASE scenario in that the shift key provides upcase. Of course, where necessary the software can force entry of either case when necessary. Cheers Trevor Ockenden OSP - Original Message - From: Stevenson, Charles [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 03, 2004 9:02 AM Subject: [U2] Universe PTERM CASE INVERT / NOINVERT Preferences I am curious about people's experience: 1. Do your end users like or dislike this case-inverting behavior? I think most dislike it. 2. How about programmers and techies? 3. Do you let users configure it for themselves? By the way, Stuart meant paragraph, not phrase. Line 1 would start PA, not PH : To fix this permanantly for all accounts create a VOC phrase in the UV account: UV.LOGIN 001 PH 002 PTERM CASE NOINVERT --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.699 / Virus Database: 456 - Release Date: 4/06/2004 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] CATALOG verb
Dianne wrote... Interesting idea, Trevor. I do prefer the INFORMATION verbs, probably because I'm more used to them. I'll definitely make a COPYI ! As you may have discovered by now, COPYI already exists and there is also a COPYP for those that prefer Pick style copies. In fact the Pick style copy (COPYP) has one very useful feature I haven't been able to reproduce using the COPYI verb namely the ability to list a program (or whatever) without the line numbers. The command is: COPYP BP PROGRAM (SN rtn TO: rtn Hope that helps! Cheers Trevor Ockenden OSP - Original Message - From: Dianne Ackerman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 19, 2004 11:30 PM Subject: Re: [U2] [UV] CATALOG verb Thanks, Dianne Trevor Ockenden wrote: Dianne wrote... I'm using PICK flavour in UV version 9.6.1.4. I want all programs to be catalogued with the COMPLETE keyword. Is there an option somewhere I can set to force that keyword? I have found the Pick flavour of verbs frustrating so whenever I am in a Pick flavoured account I create several Information flavoured verbs as follows: Create CREATE.FILEI and CATALOGI as follows... Copy these verbs from the NEWACC,INFORMATION file you will find in the UV account or copy the Pick flavoured verbs and change the PICK to INFORMATION in the new VOC entries. Now you can use these new verbs as though they were from a non Pick flavoured account. Cheers Trevor Ockenden OSP PS the above information applies to UV. Similar changes might work for UD but I'm not sure about this. --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.687 / Virus Database: 448 - Release Date: 17/05/2004 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
Re: [U2] [UV] CATALOG verb
Dianne wrote... I'm using PICK flavour in UV version 9.6.1.4. I want all programs to be catalogued with the COMPLETE keyword. Is there an option somewhere I can set to force that keyword? I have found the Pick flavour of verbs frustrating so whenever I am in a Pick flavoured account I create several Information flavoured verbs as follows: Create CREATE.FILEI and CATALOGI as follows... Copy these verbs from the NEWACC,INFORMATION file you will find in the UV account or copy the Pick flavoured verbs and change the PICK to INFORMATION in the new VOC entries. Now you can use these new verbs as though they were from a non Pick flavoured account. Cheers Trevor Ockenden OSP PS the above information applies to UV. Similar changes might work for UD but I'm not sure about this. --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.687 / Virus Database: 448 - Release Date: 17/05/2004 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
[U2] u2 community OR u2 user
I am glad to see that the U2 products are so robust that we have so much time to devote to u2-community conversations. Is anybody else getting anything in the u2-community folder as I am not especially as it seems much of the last couple of threads should have been there. Cheers Trevor Ockenden OSP --- Outgoing mail is certified Virus Free by AVG 6.0. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004 --- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users