Re: [U2] Using DICT items in basic program
I am fully aware of the possibility of 5 executes for 1 million records
totalling 5 million executes.
Anyone can create an example of extremes to invalidate any suggestion. My
example was to acquire the results of a dict item within basic, one of those
missing elements that my sub can handle.
If I were intending to process 5 million records as you would suggest, I
would write a simple program to create the csv's. I create many of these as
programs for their recurring use. I use download for the one-shot simple
projects.
Besides, so what if it did 5 million executes. These systems can handle it.
Time or processor consumption wasn't an issue in the original request
My 1 cent
Mark Johnson
- Original Message -
From: "Timothy Snyder" <[EMAIL PROTECTED]>
To:
Sent: Thursday, August 31, 2006 9:57 PM
Subject: Re: [U2] Using DICT items in basic program
> [EMAIL PROTECTED] wrote on 08/31/2006 07:03:29 PM:
>
> > The magic is to take the TCL statement, derive the filename (CUSTOMER)
> and
> > using READNEXT, acquire each of the item id's from the SSELECT
> statement.
> >
> > Then I generate very tiny English statements of the form:
> >
> > EXECUTE "LIST FILE "ID" NAME ID-SUPP COL-HDR-SUPP {any other necessary
> > suppressors}" CAPTURING X
>
> If I'm reading this correctly, you're performing multiple executes for
> each record in the file. In the example you provided, you would be
> performing one execute each for NAME, CSZ, PHONE, CONTACT, and
> AGED.BALANCE. If you're processing a million records, that means you'll
> be performing FIVE-MILLION executes!!!
>
> Maybe I've misunderstood what you're doing. But if not, I don't recommend
> this approach. The overhead of performing that many executes is
> staggering. I had a customer that had a process that was running in eight
> hours, and they desperately wanted to get it down to four hours. It was
> consuming an entire CPU and imposing significant I/O wait times that
> impacted system-wide performance. I found where the program was spending
> most of its time and CPU cycles - it was in a routine that was performing
> executes to locate a value within an index and read through that. I
> changed it to eliminate the executes and use intrinsic basic functions
> instead - nothing else was changed. It went down to twenty minutes - much
> better than they had hoped for. CPU and disk consumption became
> insignificant. Executes are a wonderful thing, but they are very
> expensive operations when performed many times. By adding the capturing
> clause, you're adding even more overhead.
> ---
> 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 Personal Editions
JPB, Yes and no. This is our second issue, so 'no' it isn't new, but it has been a long time and this issue has all new content, so 'yes'. - Chuck "Both Sides of the Issue" Barouch jpb wrote: What U2UG newsletter? Is this something new? - Original Message - From: "David Jordan" <[EMAIL PROTECTED]> The next U2UG newsletter, (available soon) will have articles about release 10.2 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse Personal Editions - Help Please
You left the colon for the drive letter out. F G/IBM/UV/VOC D_VOC should have been F G:/IBM/UV/VOC D_VOC --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse Personal Editions - Help Please
No, I must have explained it wrong. I am happy with the normal path to the VOV I just wanted to access my backup VOC on G: drive. Francis Bennett pointed me in the right direction. Thanks anyway. Louis - Original Message - From: "David Jordan" <[EMAIL PROTECTED]> To: Sent: Saturday, September 02, 2006 4:38 PM Subject: RE: [U2] UniVerse Personal Editions - Help Please Hi Louis I have updated my UniVerse as suggested and I copied the C:\IBM directory to G: drive before (thank goodness!) Obviously I have lost my old VOC so I want to copy stuff back from the backup copy. Help If I understand what you have done correctly. If you originally installed Universe in C:\IBM then all the VOC pointers for system commands, such as LIST, in all universe accounts will have paths pointing to c:\ibm\uv... If now the Universe system directory is G:\ibm\uv then the voc in the current accounts will be now pointing to the wrong directory. The easiest way to recover this is to login into the g:\ibm\uv account. Do a setfile to the voc of the account you wish to fix. Ie SETFILE C:\UV\ACCOUNTS\TEST\VOC VOC.TEST<> SEARCH VOC.TEST<> C:\ibm\uv<> <> ED VOC.TEST< Replace C:\IBM with G:\ibm and save for each record. Regards David Jordan Managing Consultant [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] UniVerse Personal Editions - Help Please
Worked perfectly. Thanks. I thought I had tried all combinations of "\", "/" and ":" but obviously I hadn't. Thanks again. Louis - Original Message - From: "Francis Bennett" <[EMAIL PROTECTED]> To: Sent: Saturday, September 02, 2006 4:21 PM Subject: Re: [U2] UniVerse Personal Editions - Help Please Try: F G:\IBM\UV\VOC G:\IBM\UV\D_VOC - Original Message - From: "Louis Windsor" <[EMAIL PROTECTED]> To: Sent: Saturday, September 02, 2006 3:38 PM Subject: [U2] UniVerse Personal Editions - Help Please I have UniVerse running on XP Prof (at home). I have updated my UniVerse as suggested and I copied the C:\IBM directory to G: drive before (thank goodness!) Obviously I have lost my old VOC so I want to copy stuff back from the backup copy. Help I tried to do this a while ago but ended up "giving up". How do a build an "F" pointer to Drive G:\IBM\VOC so my updated UniVerse can access my backup VOC? I've tried :- F G/IBM/UV/VOC D_VOC without success. I have also tried various combinations of ":" and "\" etc. TIA Louis PS Bring back "good old Unix" any day. Louis - Original Message - From: "Leroy Dreyfuss" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 30, 2006 5:33 AM Subject: [U2] UniVerse Personal Editions > All, > Because the current UniVerse 10.1.11 (Windows) and 10.1.12 > (Linux) > Personal Editions were about to expire (31 August 2006), we > have > reloaded them with a new expiration date. The updated copies > will > expire on 31 October 2006, and will be replaced by UniVerse > 10.2 > versions about a month before then. If you are running either > 10.1.11 > or 10.1.12 Personal Edition, you should download and install > the > replaced copies to avoid interruption. --- 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 Personal Editions - Help Please
Hi Louis >I have updated my UniVerse as suggested and I copied the C:\IBM >directory to G: drive before (thank goodness!) > >Obviously I have lost my old VOC so I want to copy stuff back from >the backup copy. > >Help If I understand what you have done correctly. If you originally installed Universe in C:\IBM then all the VOC pointers for system commands, such as LIST, in all universe accounts will have paths pointing to c:\ibm\uv... If now the Universe system directory is G:\ibm\uv then the voc in the current accounts will be now pointing to the wrong directory. The easiest way to recover this is to login into the g:\ibm\uv account. Do a setfile to the voc of the account you wish to fix. Ie SETFILE C:\UV\ACCOUNTS\TEST\VOC VOC.TEST<> SEARCH VOC.TEST<> C:\ibm\uv<> <> ED VOC.TEST< Replace C:\IBM with G:\ibm and save for each record. Regards David Jordan Managing Consultant [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse Personal Editions - Help Please
Try: F G:\IBM\UV\VOC G:\IBM\UV\D_VOC - Original Message - From: "Louis Windsor" <[EMAIL PROTECTED]> To: Sent: Saturday, September 02, 2006 3:38 PM Subject: [U2] UniVerse Personal Editions - Help Please > I have UniVerse running on XP Prof (at home). > > I have updated my UniVerse as suggested and I copied the C:\IBM > directory to G: drive before (thank goodness!) > > Obviously I have lost my old VOC so I want to copy stuff back from > the backup copy. > > Help > > I tried to do this a while ago but ended up "giving up". > > How do a build an "F" pointer to Drive G:\IBM\VOC so my updated > UniVerse can access my backup VOC? > > I've tried :- > > F > G/IBM/UV/VOC > D_VOC > > without success. I have also tried various combinations of ":" and "\" > etc. > > TIA > > Louis > > PS Bring back "good old Unix" any day. > > Louis > > - Original Message - > From: "Leroy Dreyfuss" <[EMAIL PROTECTED]> > To: > Sent: Wednesday, August 30, 2006 5:33 AM > Subject: [U2] UniVerse Personal Editions > > > > All, > > Because the current UniVerse 10.1.11 (Windows) and 10.1.12 (Linux) > > Personal Editions were about to expire (31 August 2006), we have > > reloaded them with a new expiration date. The updated copies will > > expire on 31 October 2006, and will be replaced by UniVerse 10.2 > > versions about a month before then. If you are running either 10.1.11 > > or 10.1.12 Personal Edition, you should download and install the > > replaced copies to avoid interruption. > --- > 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/
