Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Augusto Alonso
Thanks Rex. It's a pity. This way, you need lots of space. And what's worse: If you try to restore from the decompressed image (bigger than 2Gb) you get an end of reel after restoring the first 2Gb... So that, if you need to backup more than 20 Gb you can't do it to disk, because of this 2Gb

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Rex Gozar
Unless you need record-level restores, I would recommend using tar to backup your Universe accounts. rex ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Databasic conversion

2011-04-15 Thread Ed Clark
A lot of people used to code their applications to R83 or least common denominator. The company I worked for 15 years ago had a mix of Adds Mentor, Stratus OA, Power95 and a small universe system at a satellite office. We bought a new accounting system that was written to R83. The vendor was a

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Tom Dodds
Ad I am not directly associated with Ashwood Computer Companies, but after the thrashing others have taken for not including the Ad moniker on their postings I felt compelled. Ashwood Computer Companies at www.ashwoodcomputer.com (do...@ashwoodcomputer.com) have a backup product that is

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Israel, John R.
I am not familiar with the specific backup product, but I used to work for Ashwood years ago. They are VERY good people and leaving them was one of the hardest decisions I ever had to make. If you call, tell Doug I said hi. John Israel Senior Programmer/Analyst Dayton Superior Corporation

[U2] Can this be done with SQL?

2011-04-15 Thread George Gallen
I have a DICT item CNT setup as an I desc as (1=1) We use it like: SELECT FILENAME BY FIELD BREAK.ON FIELD TOTAL CNT DET.SUP Which works great for giving counts of FIELD - but you can't sort by it, or select off it. I tried: SELECT FIELD,COUNT(CNT) FROM FILENAME GROUP BY FIELD; Which also

Re: [U2] Can this be done with SQL?

2011-04-15 Thread Brian Leach
George You need the HAVING clause to filter that way (and remember you can use COUNT(*) to get a count): SELECT GENRE, COUNT(*) FROM BOOK_TITLES GROUP BY GENRE; Genre. COUNT ( * ) BIOGRAPHY2 BUSINESS 8 CLASSIC 31 CRIME1 DRAMA

Re: [U2] Who is Ed Clark?

2011-04-15 Thread Dawn Wolthuis
Agreed. Cheers! --dawn On Wed, Apr 13, 2011 at 1:21 PM, George Land george.l...@aptsolutions.netwrote: I don't think anyone has a problem with Ed or anyone else contributing, it's just a case of being open about who he is. Knowing that he is an Intersystems employee means that we can

Re: [U2] Databasic conversion

2011-04-15 Thread FFT2001
In a message dated 4/15/2011 5:43:33 AM Pacific Daylight Time, u...@edclark.net writes: But then we decided we wanted to upgrade the universe system and have all our accounting users on that. Just about everything else was ok, but it took the var 3 months of work to convert the procs to

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Larry Hiscock
LOL, Tom. Just to clarify -- when users of a product or service praise the product or company, when they have no fiduciary stake or relationship to the company, the AD tag is not required. An AD tag is only required when someone stands to gain financially from the product or service that they're

[U2] trigger issue/archive question

2011-04-15 Thread douglas chanco
while my trigger works fine I am getting a weird error message (#2 the line number were added by me and are not part of the program). this error is returning from the following line of code in the trigger RESULTS = setDiagnostics('[ERROR] Sql updated failed .') so I suppose its OK 1.

Re: [U2] trigger issue/archive question

2011-04-15 Thread Horacio Pellegrino
I've seen issues like that when a programmer is debugging and stepping line by line in the WRITE statement. hp On Fri, Apr 15, 2011 at 1:18 PM, douglas chanco d...@chancofamily.comwrote: while my trigger works fine I am getting a weird error message (#2 the line number were added by me and

Re: [U2] Databasic conversion

2011-04-15 Thread Ed Clark
I don't remember all exact details. The biggest problem had to do with universe proc treating backslash as a special character. They used one or the other as a delimiter in data that they passed around, and proc ate it. It was something line this: 0001 PQ 0002 RI 0003 IHA\B\C 0004 F 0005

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Tom
Thanks for the clarification, Larry. With the verbal beating some people took over the last view weeks, I felt it better to be safe than beaten. Sent from my iPhone Tom Dodds t...@ix.netcom.com 630.235.2975 On Apr 15, 2011, at 11:54, Larry Hiscock lar...@wcs-corp.com wrote: LOL, Tom. Just

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Wols Lists
On 15/04/11 13:30, Rex Gozar wrote: Unless you need record-level restores, I would recommend using tar to backup your Universe accounts. While UV is running and being used? tar is all very well, but if the database is being used 24/7 it could easily lead to a corrupt backup. Cheers, Wol

Re: [U2] Databasic conversion

2011-04-15 Thread Tom Dodds
I have been involved in a number of migrations. I have stubbed my toes on several issues. Printers Assembly language code/C++/ what ever foreign external code Interface to external devices, scanners, funny printers/plotters, etc. The issues of printers is the most common. Users and developers

[U2] Unidata Encrypt Function

2011-04-15 Thread Ben Souther
Hello, I'm trying to get Unidata's DIGEST function (using SHA1) to match the output of a Java program using the same algorithm. In the Unidata Commands Reference it states that the output of DIGEST can be either binary or hex. It doesn't tell you how to specify which one you want. The line:

Re: [U2] Unidata Encrypt Function

2011-04-15 Thread Rex Gozar
EQU ALGORITHM$SHA1 TO SHA1 EQU DATALOC$STRING TO 1 EQU DATALOC$FILE TO 2 RESULT = ERRCODE = DIGEST(ALGORITHM$SHA1, TEXT, DATALOC$STRING, RESULT) RESULT = UPCASE(OCONV(RESULT, MX)) rex ___ U2-Users mailing list U2-Users@listserver.u2ug.org

Re: [U2] Unidata Encrypt Function

2011-04-15 Thread Ed Clark
fyi, the MX conversion code is only valid in basictype P. In default basictype U you need to use MX0C On Apr 15, 2011, at 3:38 PM, Rex Gozar wrote: EQU ALGORITHM$SHA1 TO SHA1 EQU DATALOC$STRING TO 1 EQU DATALOC$FILE TO 2 RESULT = ERRCODE = DIGEST(ALGORITHM$SHA1, TEXT, DATALOC$STRING,

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread bpaige
The product provided by Ashwood handles this nicely. On an AIX system, it pauses the database, performs a JFS2 snapshot (in seconds), releases the database, then the customizable backup script (we use tar and gzip) backs up the snapshot. Brian -Original Message- From:

Re: [U2] Question about uvbackup dd and uvrestore

2011-04-15 Thread Danny Ruckel
IBM has a nice point in time product as well... Danny -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com Sent: Friday, April 15, 2011 2:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2]