[U2] Inverting/Pivoting a table
I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Q-Pointers
Follow up from last week: I contacted a former co-worker who has contacts with some of the folks that worked with Dick Pick back in the original days. This guy said that when they were brain storming about how to develop the original Pick database, they talked about a way to point to things quickly, thus the Q in a Q-pointer stands for Quick. I would not stake my life on this answer, but this looks like the most accurate answer so far. John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Q-Pointers
Cite this guy so we can record it in our history logs. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 6:50 am Subject: [U2] Q-Pointers Follow up from last week: I contacted a former co-worker who has contacts with some of the folks that worked with Dick Pick back in the original days. This guy said that when they were brain storming about how to develop the original Pick database, they talked about a way to point to things quickly, thus the Q in a Q-pointer stands for Quick. I would not stake my life on this answer, but this looks like the most accurate answer so far. John ___ 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] Q-Pointers
My contact is Doug Owens with Ashwood Computer, Blue Ash (CIncinanti), OH Doug's contact is Henry (Hank) R Janicki, CEO and Founder of VirtualPlex, LLC John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 10:20 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Q-Pointers Cite this guy so we can record it in our history logs. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 6:50 am Subject: [U2] Q-Pointers Follow up from last week: I contacted a former co-worker who has contacts with some of the folks that worked with Dick Pick back in the original days. This guy said that when they were brain storming about how to develop the original Pick database, they talked about a way to point to things quickly, thus the Q in a Q-pointer stands for Quick. I would not stake my life on this answer, but this looks like the most accurate answer so far. John ___ 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Q-Pointers
I recently read a piece by Brian Stone that 'Q-pointer' meant 'Query-Pointer'. It was part of a Pick history discussion I believe on Linked In. Sorry I don't have the reference at hand now. I will see if I can track it down tonight. Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Monday, September 10, 2012 7:24 AM To: 'U2 Users List' Subject: Re: [U2] Q-Pointers My contact is Doug Owens with Ashwood Computer, Blue Ash (CIncinanti), OH Doug's contact is Henry (Hank) R Janicki, CEO and Founder of VirtualPlex, LLC John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 10:20 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Q-Pointers Cite this guy so we can record it in our history logs. -Original Message- From: Israel, John R. johnisr...@daytonsuperior.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 6:50 am Subject: [U2] Q-Pointers Follow up from last week: I contacted a former co-worker who has contacts with some of the folks that worked with Dick Pick back in the original days. This guy said that when they were brain storming about how to develop the original Pick database, they talked about a way to point to things quickly, thus the Q in a Q-pointer stands for Quick. I would not stake my life on this answer, but this looks like the most accurate answer so far. John ___ 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-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[UV] @TIME and TIME() not reliable
Hello, Has anyone else here observed this behavior for Universe 11.1.3 on a OS other than HP-UX ? Sometimes, @TIME will report an incorrect internal time. When I first observed this behavior, I changed my use of @TIME for a call to TIME(). It fixed the problem on one HP-UX server I was working on, but when I installed the program on a different HP-UX server, TIME() now sometimes reported an incorrect internal time. For example, it was around 6:00 am but the time reported was for about 4:00 am. I fixed the problem on that server by replacing TIME() by ICONVS(TIMEDATE()[1,8],MTS) We have a setup for temporary locks that expire after a given time these temporary locks were being created as already expired. It's a problem when a server can't determine the correct internal time. Thanks Jacques G. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [U2[UV] @TIME and TIME() not reliable
Jacques @TIME doesn't give the current time anyway. It gives the time that whatever program or activity you're running started. So, for example, if you do a listing LIKE: LIST VOC EVAL @TIME EVAL TIME() And sit at the Press any Key .. point for a few seconds then continue, you'll see the difference between the two. But TIME() should go get the current time, so I don't know why it would differ from what your OS is reporting unless there is an environment issue with the time zone for your user. If you 'sh -c date' for that user, does it show the right time? Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: 10 September 2012 17:50 To: U2 Users List Subject: Re: [U2] [U2[UV] @TIME and TIME() not reliable Hello, Has anyone else here observed this behavior for Universe 11.1.3 on a OS other than HP-UX ? Sometimes, @TIME will report an incorrect internal time. When I first observed this behavior, I changed my use of @TIME for a call to TIME(). It fixed the problem on one HP-UX server I was working on, but when I installed the program on a different HP-UX server, TIME() now sometimes reported an incorrect internal time. For example, it was around 6:00 am but the time reported was for about 4:00 am. I fixed the problem on that server by replacing TIME() by ICONVS(TIMEDATE()[1,8],MTS) We have a setup for temporary locks that expire after a given time these temporary locks were being created as already expired. It's a problem when a server can't determine the correct internal time. Thanks Jacques G. ___ 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[UV] @TIME and TIME() not reliable
if I recall correctly @TIME returns the time that the program began running, TIME() returns the current time. Jacques G. wrote: Hello, Has anyone else here observed this behavior for Universe 11.1.3 on a OS other than HP-UX ? Sometimes, @TIME will report an incorrect internal time. When I first observed this behavior, I changed my use of @TIME for a call to TIME(). It fixed the problem on one HP-UX server I was working on, but when I installed the program on a different HP-UX server, TIME() now sometimes reported an incorrect internal time. For example, it was around 6:00 am but the time reported was for about 4:00 am. I fixed the problem on that server by replacing TIME() by ICONVS(TIMEDATE()[1,8],MTS) We have a setup for temporary locks that expire after a given time these temporary locks were being created as already expired. It's a problem when a server can't determine the correct internal time. Thanks Jacques G. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Quirks in UOJ and resizing
I was upgrading our XLr8Resizer to do multi-threading on the analyze and resizing. So, my Java programmer asked a simple question: How much faster will our multi-threading be than single threading? I found it was anywhere from 0% faster to 45% faster when testing our 6000 file sample database with files sizes from 10mb to 2gb. But this got me to thinking is TCL/ECL resizing slower or faster that from UOJ as a command. Oh boy was I surprised. The TCL/ECL resize command on average to anywhere from 5% to 200% slower. I was totally dumb founded on this that UOJ resizing will be faster that typing the command in TCL/ECL. In this case the quirk is a good quirk not a bad one. Regards, Doug www.u2logic.com/tool.html Affordable Eclipse based tools for Universe and Unidata ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Inverting/Pivoting a table
On 10/09/12 14:39, Dave Laansma wrote: I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: I thought there was a command that would flip a FILE like that. I've never used it, but I recall a colleague making good use of it ... 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: And here you're using dynamic arrays. If you're in PI syntax, do a DCOUNT to get the number of people, dimension some static arrays, and dump the data into that. It'll be MUCH faster. You can REMOVE the elements from the original dynamic array (fast), dump them into your static array(s) (fast), and MATBUILD your new array (fast). NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Inverting/Pivoting a table
REFOMAT -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 11:07 am Subject: Re: [U2] Inverting/Pivoting a table On 10/09/12 14:39, Dave Laansma wrote: I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: I thought there was a command that would flip a FILE like that. I've never used it, but I recall a colleague making good use of it ... 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: And here you're using dynamic arrays. If you're in PI syntax, do a DCOUNT to get the number of people, dimension some static arrays, and dump the data into that. It'll be MUCH faster. You can REMOVE the elements from the original dynamic array (fast), dump them into your static array(s) (fast), and MATBUILD your new array (fast). NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma Cheers, Wol ___ 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] [Windows]
Oops I need to modify my message about these zombie tl_server.exe Windows sessions. The server is running Universe on Windows, and our users *should* be running AccuTerm However there is no requirement to run Accuterm as, as I understand it, the tl_service.exe will respond to any request for a telnet session to be opened. Doesn't have to be Accuterm. Doesn't have to be a human. I'm suspicious that there isn't some *other* type of requestor out there somewhere, trying to open a session and then leaving it hang. That could explain the failure to log in if this other something isn't even a human operator, but some kind of automated something. I had hoped I could get come kind of clue by looking at *when* these things are occurring and so Windows Process Explorer was loaded, which at least will tell us the *time* each process was created. But the times seem kinda random, one even occurring at 2 AM (!) -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Sat, Sep 8, 2012 8:57 am Subject: Re: [U2] [Windows] Universe on Windows / with Accuterm -Original Message- From: John Jenkins u2g...@btinternet.com To: U2 Users List u2-users@listserver.u2ug.org Cc: u2-users u2-users@listserver.u2ug.org Sent: Sat, Sep 8, 2012 7:28 am Subject: Re: [U2] [Windows] I suspect the database does not have device licensing. Check with confprod or unregen -z. The shell used (on unix) would be either uvdls or udtts. The client software would need to support it as well. wIntegrate, Dynamic Connect or SBClient usually. Regards JayJay Sent from my iPad On 7 Sep 2012, at 17:57, Wjhonson wjhon...@aol.com wrote: This system entry is empty. -Original Message- From: John Jenkins u2g...@btinternet.com To: U2 Users List u2-users@listserver.u2ug.org Cc: u2-users u2-users@listserver.u2ug.org Sent: Fri, Sep 7, 2012 9:54 am Subject: Re: [U2] [Windows] If you are using device licensing, SYSTEM(51) has some useful information. Regards. JayJay Sent from my iPad On 7 Sep 2012, at 14:59, Wjhonson wjhon...@aol.com wrote: The -o as I reported earlier only links it to the instantiating pid which is of course, much to my dismay, just the tl_service.exe not the actual pid of the tl_server.exe job. So every telnet session, on the -o reports the *same* pid. But in the tasklist of course they each have different pids. So this doesn't solve the issue either. -Original Message- From: Brian Leach br...@brianleach.co.uk To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 6, 2012 7:06 pm Subject: Re: [U2] [Windows] and -o to let you link it with the pid. Sent from my iPad On 6 Sep 2012, at 21:04, Robert Houben robert.hou...@fwic.net wrote: On Windows 7, netstat -help shows this: -fDisplays Fully Qualified Domain Names (FQDN) for foreign addresses. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: September-06-12 1:01 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Windows] There is no -f option on netstat -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 6, 2012 12:15 pm Subject: Re: [U2] [Windows] netstat -f Wjhonson wrote: When a remote PC, asks the Windows server to open a Telnet session, Windows assigns a Process ID to that request. While the telnet session is open,that Process ID will appear in the Windows Task Manager. Is there a way to tell, WHO ask for that Telnet session to be opened? That is, the name of the remote PC, Foreign Address, Mac Address, IP or something of that sort that identifies the requestor/asker ? This has to be done *outside of* Universe, not inside it, for a particular reason. Anyone know the answer? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot 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 ___ 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
Re: [U2] Inverting/Pivoting a table
REFORMAT perhaps? I am find no reference to a Unibasic command/statement REFORMAT. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 2:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table REFOMAT -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 11:07 am Subject: Re: [U2] Inverting/Pivoting a table On 10/09/12 14:39, Dave Laansma wrote: I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: I thought there was a command that would flip a FILE like that. I've never used it, but I recall a colleague making good use of it ... 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: And here you're using dynamic arrays. If you're in PI syntax, do a DCOUNT to get the number of people, dimension some static arrays, and dump the data into that. It'll be MUCH faster. You can REMOVE the elements from the original dynamic array (fast), dump them into your static array(s) (fast), and MATBUILD your new array (fast). NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma Cheers, Wol ___ 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Inverting/Pivoting a table
REFORMAT is a TCL command. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: September-10-12 12:39 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table REFORMAT perhaps? I am find no reference to a Unibasic command/statement REFORMAT. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 2:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table REFOMAT -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 11:07 am Subject: Re: [U2] Inverting/Pivoting a table On 10/09/12 14:39, Dave Laansma wrote: I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: I thought there was a command that would flip a FILE like that. I've never used it, but I recall a colleague making good use of it ... 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: And here you're using dynamic arrays. If you're in PI syntax, do a DCOUNT to get the number of people, dimension some static arrays, and dump the data into that. It'll be MUCH faster. You can REMOVE the elements from the original dynamic array (fast), dump them into your static array(s) (fast), and MATBUILD your new array (fast). NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma Cheers, Wol ___ 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-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] Inverting/Pivoting a table
REFORMAT appears to be a UniQuery command and appears to be used to copy records from one file to another. I'm looking for this type of functionality in a UniBasic program. Sincerely, David Laansma -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, September 10, 2012 3:41 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table REFORMAT is a TCL command. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: September-10-12 12:39 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table REFORMAT perhaps? I am find no reference to a Unibasic command/statement REFORMAT. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 2:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table REFOMAT -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 11:07 am Subject: Re: [U2] Inverting/Pivoting a table On 10/09/12 14:39, Dave Laansma wrote: I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: I thought there was a command that would flip a FILE like that. I've never used it, but I recall a colleague making good use of it ... 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: And here you're using dynamic arrays. If you're in PI syntax, do a DCOUNT to get the number of people, dimension some static arrays, and dump the data into that. It'll be MUCH faster. You can REMOVE the elements from the original dynamic array (fast), dump them into your static array(s) (fast), and MATBUILD your new array (fast). NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma Cheers, Wol ___ 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-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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Inverting/Pivoting a table
EXECUTE REFORMAT it doesn't copy, it changes the format as well in other words, it pivots, as you asked -Original Message- From: Dave Laansma dlaan...@hubbardsupply.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 12:59 pm Subject: Re: [U2] Inverting/Pivoting a table REFORMAT appears to be a UniQuery command and appears to be used to copy records from one file to another. I'm looking for this type of functionality in a UniBasic program. Sincerely, David Laansma -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, September 10, 2012 3:41 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table REFORMAT is a TCL command. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: September-10-12 12:39 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table REFORMAT perhaps? I am find no reference to a Unibasic command/statement REFORMAT. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 2:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table REFOMAT -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 11:07 am Subject: Re: [U2] Inverting/Pivoting a table On 10/09/12 14:39, Dave Laansma wrote: I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: I thought there was a command that would flip a FILE like that. I've never used it, but I recall a colleague making good use of it ... 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: And here you're using dynamic arrays. If you're in PI syntax, do a DCOUNT to get the number of people, dimension some static arrays, and dump the data into that. It'll be MUCH faster. You can REMOVE the elements from the original dynamic array (fast), dump them into your static array(s) (fast), and MATBUILD your new array (fast). NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma Cheers, Wol ___ 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-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-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] Inverting/Pivoting a table
Excerpt from page 1-161 of the UniQuery Commands Reference available at http://www.rocketsoftware.com/u2/products/unidata/resources/manuals/unid ata-7.3-documentation/uniquery-commands-reference/view REFORMAT Syntax REFORMAT filename attributes [selection_criteria] Description The UniQuery REFORMAT command copies record attributes you specify from one data file to another data file. The destination file must already exist. REFORMAT uses the first attribute named in the UniQuery statement as the record ID in the destination file. The remaining attributes in the UniQuery statement become record attributes in the destination file. UniQuery prompts for the name of the destination file after you enter the REFORMAT command. Sincerely, David Laansma -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 4:02 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table EXECUTE REFORMAT it doesn't copy, it changes the format as well in other words, it pivots, as you asked -Original Message- From: Dave Laansma dlaan...@hubbardsupply.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 12:59 pm Subject: Re: [U2] Inverting/Pivoting a table REFORMAT appears to be a UniQuery command and appears to be used to copy records from one file to another. I'm looking for this type of functionality in a UniBasic program. Sincerely, David Laansma -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, September 10, 2012 3:41 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table REFORMAT is a TCL command. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: September-10-12 12:39 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table REFORMAT perhaps? I am find no reference to a Unibasic command/statement REFORMAT. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 2:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table REFOMAT -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 11:07 am Subject: Re: [U2] Inverting/Pivoting a table On 10/09/12 14:39, Dave Laansma wrote: I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: I thought there was a command that would flip a FILE like that. I've never used it, but I recall a colleague making good use of it ... 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: And here you're using dynamic arrays. If you're in PI syntax, do a DCOUNT to get the number of people, dimension some static arrays, and dump the data into that. It'll be MUCH faster. You can REMOVE the elements from the original dynamic array (fast), dump them into your static array(s) (fast), and MATBUILD your new array (fast). NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma Cheers, Wol ___ 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-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-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-Users mailing
Re: [U2] Inverting/Pivoting a table
Columns become rows Rows become columns We call them attributes and item-ids, but it's the same difference -Original Message- From: Dave Laansma dlaan...@hubbardsupply.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 1:12 pm Subject: Re: [U2] Inverting/Pivoting a table Excerpt from page 1-161 of the UniQuery Commands Reference available at http://www.rocketsoftware.com/u2/products/unidata/resources/manuals/unid ata-7.3-documentation/uniquery-commands-reference/view REFORMAT Syntax REFORMAT filename attributes [selection_criteria] Description The UniQuery REFORMAT command copies record attributes you specify from one data file to another data file. The destination file must already exist. REFORMAT uses the first attribute named in the UniQuery statement as the record ID in the destination file. The remaining attributes in the UniQuery statement become record attributes in the destination file. UniQuery prompts for the name of the destination file after you enter the REFORMAT command. Sincerely, David Laansma -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 4:02 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table EXECUTE REFORMAT it doesn't copy, it changes the format as well in other words, it pivots, as you asked -Original Message- From: Dave Laansma dlaan...@hubbardsupply.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 12:59 pm Subject: Re: [U2] Inverting/Pivoting a table REFORMAT appears to be a UniQuery command and appears to be used to copy records from one file to another. I'm looking for this type of functionality in a UniBasic program. Sincerely, David Laansma -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, September 10, 2012 3:41 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table REFORMAT is a TCL command. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: September-10-12 12:39 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table REFORMAT perhaps? I am find no reference to a Unibasic command/statement REFORMAT. Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 2:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table REFOMAT -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 11:07 am Subject: Re: [U2] Inverting/Pivoting a table On 10/09/12 14:39, Dave Laansma wrote: I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: I thought there was a command that would flip a FILE like that. I've never used it, but I recall a colleague making good use of it ... 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: And here you're using dynamic arrays. If you're in PI syntax, do a DCOUNT to get the number of people, dimension some static arrays, and dump the data into that. It'll be MUCH faster. You can REMOVE the elements from the original dynamic array (fast), dump them into your static array(s) (fast), and MATBUILD your new array (fast). NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma Cheers, Wol ___ 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-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-Users
Re: [U2] Inverting/Pivoting a table
Why is the Kink's song Lola suddenly playing in my mind! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 4:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table Columns become rows Rows become columns ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Inverting/Pivoting a table
:-) Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, September 10, 2012 4:31 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table Why is the Kink's song Lola suddenly playing in my mind! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 4:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table Columns become rows Rows become columns ___ 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] [Windows]
What's the real goal here? To get the hostname of any random telnet client? You have the information you need to do that. If nothing else you can get the IP address and someone can manually chase down who's connecting in. Block rogue connections at the firewall. I mean, at this point you're going around in circles and the detail you're providing is irrelevant to the task. What still needs to be resolved? You're right. It doesn't matter what client program is being used as long as they come in via the standard telnet port and we don't care what time of night someone is connecting in. Why can't this thread be marked RESOLVED? T From: Wjhonson Oops I need to modify my message about these zombie tl_server.exe Windows sessions... [huge snip of mostly group-generated footers] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows]
No that's wrong. So far none of the solutions presented has given me the IP or hostname of the particular telnet clients involved. As I mentioned before, you probably didn't read this one, when you start a telnet client it appears in the tasklist In this case, it's tl_server.exe which is Rocket's special telnet server However IF you do *not* login on that telnet server, then no corresponding entry is made in the netstat table, or perhaps one is made and then nulled out again. At the point you want to ask, well what are the ip numbers of these connections, you have 62 tl_server entries and 61 (repeat 61, not 62) netstat entries. That one extra zombie entry in the tasklist, is not present in the netstat output. So netstat is apparently only showing live or active connections or whatever you might call it, whereas the windows server is holding on to one or more *extra* zombies. Yes you can kill those *extra* tl_server.exe sessions, but really it would be nice to know what activated them. I killed all the zombies last week, and now I'm back up to about six extra tl_server sessions without corresponding netstat entries -Original Message- From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 2:37 pm Subject: Re: [U2] [Windows] What's the real goal here? To get the hostname of any random telnet client? You have the information you need to do that. If nothing else you can get the IP address and someone can manually chase down who's connecting in. Block rogue connections at the firewall. I mean, at this point you're going around in circles and the detail you're providing is irrelevant to the task. What still needs to be resolved? You're right. It doesn't matter what client program is being used as long as they come in via the standard telnet port and we don't care what time of night someone is connecting in. Why can't this thread be marked RESOLVED? T From: Wjhonson Oops I need to modify my message about these zombie tl_server.exe Windows sessions... [huge snip of mostly group-generated footers] ___ 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] [Windows]
I recommend that you use the script that I provided which uses the same base table from which the Task Manager draws its data. If that's not working then you have a permissions issue. Fix that problem. Run as administrator or check other permissions issues. But the fact that the script does not return data to you does not mean it's the wrong solution. It's the right solution - I ran through it before posting. This is no longer a U2 issue. Another factor here. You're saying a connection seems to come in and go out so fast that netstat doesn't register it. I Wish that were the case in every other situation. Processes go through various connectivity states including CONNECTING, ESTABLISHED and TIMED_OUT. Many processes hold in a TIMED_OUT or other state for long after a connection is broken. This situation has confused many developers and admins over many years. That your connections seem to go from an Unconnected state to invisible while still holding on is extremely unusual - and that might be worth an enquiry to a networking forum. You don't need to mention Universe - it's just another telnet server. More likely, I'm guessing you're not using the right options on your commands, or perhaps running without the right permissions to get the data you need even from netstat. Personally I'd get SysInternals tools (now Microsoft and still free) or something like WireShark, and get your info like that. This should be fairly easy to resolve - though of course the ones we think are easy are usually not... T From: Wjhonson No that's wrong. So far none of the solutions presented has given me the IP or hostname of the particular telnet clients involved That one extra zombie entry in the tasklist, is not present in the netstat output. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Inverting/Pivoting a table
* OPT 1: a little quicker than nested for..next (depending on how many) xx = dcount(array1,@vm) for x = 1 to xx newarr-1 = array1,x:@vm:array2,x next x OR * OPT 2: the fastest...(cos it maintains a file pos pointer) arr1 = array1 arr2 = array2 more = 1 loop remove val1 from arr1 setting more remove val2 from arr2 setting junk newarr-1 = val1:@vm:val2 while more repeat OR OPT 3: the neatest.. (ie least maintainable) arr1 = array1 arr2 = array2 arr1 = change(arr1,@vm, '+':@vm) : '+' newarr = cats(arr1,arr2) convert '+' to @vm in newarr (use whatever char you wont have in your data) On 10 September 2012 23:39, Dave Laansma dlaan...@hubbardsupply.com wrote: I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma ___ 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