[U2] [AD} Camry Group[/AD]
For anyuone who works with Camry Group or used their PiE (Pick/EDI) product, please note this information which arrived in my e-mail box: The Camry Group, Inc. is pleased to announce our move to new offices. 200 Corporate Plaza Unit A101 Islandia, NY 11749-1507 phone: 631-963-0060 fax: 631-963-0063 e-mail addresses will remain the same, example: [EMAIL PROTECTED] URL: www.camrygroup.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Connection Problems with Ud6 and UV10
David Tod Sigafoos wrote: Ron, Wednesday, August 10, 2005, 1:01:03 PM, you wrote: RW Launch UniAdmin and select Telnet under the Network services RW header. When RW the screen appears, the first thing on the screen is the desired RW telnet RW port number. RW After entering your port number, click the stop button to stop the UV RW services RW and then click start to restart them. If you are accessing UV with a RW terminal RW emulator you will have to change your telnet port setting in the RW emulator as well. I start UniAdmin and Local Host shows on the left. The menu items are File, View, COnnect, Admin, Window, Logging and Help Under Admin is Network Services. Problem is that ALL items under Admin are grayed out. I find that if i use uniadmin on another server those items don't become available until a connection has been made. So is this one of those chicken and egg things G To manually change the port, go to C:\windows\system32\drivers\etc and edit the services file with notepad. Near the bottom of the list of services you will see an entry for uvtelnet. Change the port number in the second column to your desired port and save the file. Then restart the UniVerse Services in the control panel/services. This should do the trick just as well as UniAdmin. Ron White --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[4]: [U2] Connection Problems with Ud6 and UV10
Bill_H, Wednesday, August 10, 2005, 4:57:21 PM, you wrote: B Dave: B I'm just guessing here but I wonder if there is a registry setting B inke in HLM Software Informix (or is it IBM) Universe (or UniData) that sets B the port for telnet. I have modified the setting and I know the setting took root as trying to start the link got message back that it couldn't connect But when telnet 127.0.0.1 7005 it reacts the same. This is just so weird .. it only happens on U2 databases. I have SqlServer, MySql and others and they work just fine. Guess i will just need to move to another environment G -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[2]: [U2] Connection Problems with Ud6 and UV10 - unmentioned
Chuck, Thanks for the try .. I have removed UV and UD, then installed UD only. Still no connection. I have turned off as many services as I could and that didn't help. I can only conclude that there is SOMETHING running on this box that keeps UV RPC from working. DSig Wednesday, August 10, 2005, 10:15:44 PM, you wrote: KA Sig, KA Have you checked for IP port conflicts? I had a similar KA problem when I had UniVision and UniVerse on the same box. I movedsome IP Port assignments and voila! KA - Chuck KA -- Original Message - KA Subject: Re: [U2] Connection Problems with Ud6 and UV10 - unmentioned KA info KA From: David Tod Sigafoos [EMAIL PROTECTED] KA From UniAdmin and Intercall client i get 'No RPC Connection Active' KA (or server from Intercall). This means that the Intercall client has KA found the server (127.0.0.1) but that it did not find the RPC service KA running .. KA If i try the telnet i just get the blinking cursor. If i hit enter it KA moves down a line but blinks .. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ When i'm good, i'm good. When i'm bad i'm even better Mae West --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] SELECT without
I think its COUNT.SUP That seems to work well on my system. Thank you very much! Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Re[2]: [U2] Connection Problems with Ud6 and UV10 - unmentioned
if it's running under unix, and it's trying to telnet to itself, then you may need to add 127.0.0.1 to the /etc/hosts.allow file usually, the process name under linux is in.telnetd, under digital unix it was just telnetd. So you would have a line like: in.telnetd: 127.0.0.1 or telnetd: 127.0.0.1 If this is a windows machine then I don't know. George -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Tod Sigafoos Sent: Thursday, August 11, 2005 2:52 PM To: Key Ally Subject: Re[2]: [U2] Connection Problems with Ud6 and UV10 - unmentioned Chuck, Thanks for the try .. I have removed UV and UD, then installed UD only. Still no connection. I have turned off as many services as I could and that didn't help. I can only conclude that there is SOMETHING running on this box that keeps UV RPC from working. DSig Wednesday, August 10, 2005, 10:15:44 PM, you wrote: KA Sig, KA Have you checked for IP port conflicts? I had a similar KA problem when I had UniVision and UniVerse on the same box. I movedsome IP Port assignments and voila! KA - Chuck KA -- Original Message - KA Subject: Re: [U2] Connection Problems with Ud6 and UV10 - unmentioned KA info KA From: David Tod Sigafoos [EMAIL PROTECTED] KA From UniAdmin and Intercall client i get 'No RPC Connection Active' KA (or server from Intercall). This means that the Intercall client has KA found the server (127.0.0.1) but that it did not find the RPC service KA running .. KA If i try the telnet i just get the blinking cursor. If i hit enter it KA moves down a line but blinks .. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ When i'm good, i'm good. When i'm bad i'm even better Mae West --- 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] Connection Problems with Ud6 and UV10
David Tod Sigafoos wrote: Bill_H, Wednesday, August 10, 2005, 4:57:21 PM, you wrote: B Dave: B I'm just guessing here but I wonder if there is a registry setting B inke in HLM Software Informix (or is it IBM) Universe (or UniData) that sets B the port for telnet. I have modified the setting and I know the setting took root as trying to start the link got message back that it couldn't connect But when telnet 127.0.0.1 7005 it reacts the same. This is just so weird .. it only happens on U2 databases. I have SqlServer, MySql and others and they work just fine. Guess i will just need to move to another environment G I don't have any other advise. I just tried the command telnet 127.0.0.1 7005 on my development machine and the login prompt appeared immediately. I don't have a copy of the personal edition to test with. Ron --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Connection Problems with Ud6 and UV10
David Tod Sigafoos wrote: Bill_H, Wednesday, August 10, 2005, 4:57:21 PM, you wrote: B Dave: B I'm just guessing here but I wonder if there is a registry setting B inke in HLM Software Informix (or is it IBM) Universe (or UniData) that sets B the port for telnet. I have modified the setting and I know the setting took root as trying to start the link got message back that it couldn't connect But when telnet 127.0.0.1 7005 it reacts the same. This is just so weird .. it only happens on U2 databases. I have SqlServer, MySql and others and they work just fine. Guess i will just need to move to another environment G On my development machine I have the M$ telnet service disabled. If yours is still running it will intercept your telnet request before UV sees it. That is the last idea in my head. The (head) room is now completely empty. :-) Ron White --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Socket universe vs d3
Tony Gravagno wrote: This is one of the unfortunate issues of using sockets from MV. Part of the problem is that the MV DBMS is an application over the OS, and the handle to the socket is only released if the MV monitor explicitly releases it. If you whack an MV process without allowing it to go through a proper wrapup, then the host OS doesn't know that the socket should be available, so SO$REUSEADDR is useless anyway. In the case of D3, the only way to release a socket that's been whacked like this is to reboot D3 itself - a major pain to get all users off the system to release a single socket - and for this reason I discourage use of D3 as a socket server. I'd be interested to know if U2 is any more adept at handling this scenario. I guess it comes down to the definition of the word whacked and how well U2 handles such conditions. Well on D3 Unix/Linux no need to reboot D3 to release sockets, only on d3 windows, I think. I'm currently porting jd3 from d3 to universe in fact. Socket are okay for us with a program like jd3 Cedric --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Socket universe vs d3
Craig Bennett wrote: Hi Cedric, I think the UniVerse equivalent would be: err = initServerSocket(, ser.port, backlog, sock) err = acceptConnection(sock, timeout, client.addr, client.name, client.sock) loop while 1 do send/revceive using client.sock repeat Thanks, it seems good now... In fact, I'm trying to move jd3 (java-d3, see http://www.djpatterson.com/jd3php.html) from Pick D3 to Universe. It's a way to communicate from apache/php to a multivalued DB. If some people are interested here, universe_jd3 will be GPL and I think we may release an alpha version by september. Cedric --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Connection Problems with Ud6 and UV10 - unmentioned
George Gallen wrote: if it's running under unix, and it's trying to telnet to itself, then you may need to add 127.0.0.1 to the /etc/hosts.allow file usually, the process name under linux is in.telnetd, under digital unix it was just telnetd. So you would have a line like: in.telnetd: 127.0.0.1 or telnetd: 127.0.0.1 If this is a windows machine then I don't know. George OP stated that he is running Windows XP. I don't think this would be necessary. Ron White --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Re[2]: [U2] Connection Problems with Ud6 and UV10 - unmentioned
With just UniData installed can you use UDT to connect - that will take telnet out of the equation. Colin Alfke Calgary, AB -Original Message- From: David Tod Sigafoos Chuck, Thanks for the try .. I have removed UV and UD, then installed UD only. Still no connection. I have turned off as many services as I could and that didn't help. I can only conclude that there is SOMETHING running on this box that keeps UV RPC from working. DSig Wednesday, August 10, 2005, 10:15:44 PM, you wrote: KA Sig, KA Have you checked for IP port conflicts? I had a similar problem KA when I had UniVision and UniVerse on the same box. I movedsome IP Port assignments and voila! KA - Chuck KA -- Original Message - KA Subject: Re: [U2] Connection Problems with Ud6 and UV10 - unmentioned KA info KA From: David Tod Sigafoos [EMAIL PROTECTED] KA From UniAdmin and Intercall client i get 'No RPC Connection Active' KA (or server from Intercall). This means that the Intercall client KA has found the server (127.0.0.1) but that it did not find the RPC KA service running .. KA If i try the telnet i just get the blinking cursor. If i hit enter KA it moves down a line but blinks .. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Re[4]: [U2] Connection Problems with Ud6 and UV10
Shot in the dark... is there a nat (Network Address Translator) on this network? Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama When buying selling are controlled by legislation, the first thing to be bought sold are the legislators - P.J. O'Rourke Dan Fitzgerald From: David Tod Sigafoos [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: Bill_H u2-users@listserver.u2ug.org Subject: Re[4]: [U2] Connection Problems with Ud6 and UV10 Date: Thu, 11 Aug 2005 11:54:56 -0700 Bill_H, Wednesday, August 10, 2005, 4:57:21 PM, you wrote: B Dave: B I'm just guessing here but I wonder if there is a registry setting B inke in HLM Software Informix (or is it IBM) Universe (or UniData) that sets B the port for telnet. I have modified the setting and I know the setting took root as trying to start the link got message back that it couldn't connect But when telnet 127.0.0.1 7005 it reacts the same. This is just so weird .. it only happens on U2 databases. I have SqlServer, MySql and others and they work just fine. Guess i will just need to move to another environment G -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama --- 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[2]: [U2] Connection Problems with Ud6 and UV10
Ron, sorry to hear it is empty G ms telnet is disabled Thursday, August 11, 2005, 12:42:03 PM, you wrote: RW David Tod Sigafoos wrote: Bill_H, Wednesday, August 10, 2005, 4:57:21 PM, you wrote: B Dave: B I'm just guessing here but I wonder if there is a registry setting B inke in HLM Software Informix (or is it IBM) Universe (or UniData) that sets B the port for telnet. I have modified the setting and I know the setting took root as trying to start the link got message back that it couldn't connect But when telnet 127.0.0.1 7005 it reacts the same. This is just so weird .. it only happens on U2 databases. I have SqlServer, MySql and others and they work just fine. Guess i will just need to move to another environment G RW On my development machine I have the M$ telnet service disabled. If RW yours is RW still running it will intercept your telnet request before UV RW sees it. RW That is the last RW idea in my head. The (head) room is now completely empty. :-) RW Ron White RW --- RW u2-users mailing list RW u2-users@listserver.u2ug.org RW To unsubscribe please visit http://listserver.u2ug.org/ RW __ NOD32 1.1192 (20050811) Information __ RW This message was checked by NOD32 antivirus system. RW http://www.eset.com -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[2]: [U2] Connection Problems with Ud6 and UV10
Ron, Thursday, August 11, 2005, 12:37:27 PM, you wrote: RW I don't have any other advise. I just tried the command telnet RW 127.0.0.1 7005 on my RW development machine and the login prompt appeared immediately. I RW don't RW have a copy RW of the personal edition to test with. I don't know either. I know that it works well on my desktop back in Oregon .. maybe it is the california weather .. The desktop I have it running on is even XP home .. G .. There just has to be something with HP laptops (2 now) or the XP media edition .. THanks for trying -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[4]: [U2] Connection Problems with Ud6 and UV10 - unmentioned
colin, Thursday, August 11, 2005, 1:01:24 PM, you wrote: catc With just UniData installed can you use UDT to connect - that catc will take catc telnet out of the equation. true .. but the problem is that connectivity with u6 other requires telnet and even more importantly RPC .. Neither of which 'work' though the services say they are running -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ 'Politics is like driving. To go backward, put it in R. To go forward, put it in D' unknown --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[6]: [U2] Connection Problems with Ud6 and UV10
Dan, .. i have even removed my laptop from the network .. rebooted .. no network .. still no joy in mudville Dsig Thursday, August 11, 2005, 1:02:10 PM, you wrote: DF Shot in the dark... is there a nat (Network Address Translator) DF on this DF network? DF Our greatest duty in this life is to help others. And please, if DF you can't DF help them, could you at least not hurt them? - H.H. the Dalai Lama DF When buying selling are controlled by legislation, the first DF thing to be DF bought sold are the legislators - P.J. O'Rourke DF Dan Fitzgerald From: David Tod Sigafoos [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: Bill_H u2-users@listserver.u2ug.org Subject: Re[4]: [U2] Connection Problems with Ud6 and UV10 Date: Thu, 11 Aug 2005 11:54:56 -0700 Bill_H, Wednesday, August 10, 2005, 4:57:21 PM, you wrote: B Dave: B I'm just guessing here but I wonder if there is a registry setting B inke in HLM Software Informix (or is it IBM) Universe (or UniData) that sets B the port for telnet. I have modified the setting and I know the setting took root as trying to start the link got message back that it couldn't connect But when telnet 127.0.0.1 7005 it reacts the same. This is just so weird .. it only happens on U2 databases. I have SqlServer, MySql and others and they work just fine. Guess i will just need to move to another environment G -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Our greatest duty in this life is to help others. And please, if you can't help them, could you at least not hurt them? - H.H. the Dalai Lama --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DF --- DF u2-users mailing list DF u2-users@listserver.u2ug.org DF To unsubscribe please visit http://listserver.u2ug.org/ DF __ NOD32 1.1192 (20050811) Information __ DF This message was checked by NOD32 antivirus system. DF http://www.eset.com -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ When i'm good, i'm good. When i'm bad i'm even better Mae West --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Re[2]: [U2] Connection Problems with Ud6 and UV10 - unmentioned
I have turned off as many services as I could and that didn't help. I can only conclude that there is SOMETHING running on this box that keeps UV RPC from working. Windows Firewall? Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re[4]: [U2] Connection Problems with Ud6 and UV10 - unmentioned
Ken, Thursday, August 11, 2005, 4:56:18 PM, you wrote: I have turned off as many services as I could and that didn't help. I can only conclude that there is SOMETHING running on this box that keeps UV RPC from working. KW Windows Firewall? Yes .. BUT if you bring up the security screen it says Firewall on. Drill down to the setting and it says it is off .. I am not getting the ' your computer is not protected ' from windows with makes me think SOMETHING is still working to block actual work .. -- DSig ` David Tod Sigafoos ( O O ) ___oOOo__( )__oOOo___ Should any political party attempt to abolish social security, unemployment insurance, and eliminate labor laws and farm programs, you would not hear of that party again in our political history. There is a tiny splinter group, of course, that believes you can do these things. Among them are a few Texas oil millionaires, and an occasional politician or business man from other areas. Their number is negligible and they are stupid. --President Dwight D. Eisenhower, 1954 (source: Eisenhower Presidential Papers, Document #1147; November 8, 1954 The Papers of Dwight David Eisenhower, Volume XV - The Presidency: The Middle Way Part VI: Crises Abroad, Party Problems at Home; September 1954 to December 1954,) Chapter 13: A new phase of political experience --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] True random select lists?
Sidebar: Are you playing the MP3's with QM or just managing them. Thanks. - Original Message - From: Dave Walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, August 09, 2005 10:04 AM Subject: [U2] True random select lists? I've posted the following to the OpenQM user's list, and thought I'd have a crack at U2-users as well. I've been playing with OpenQM at home for a couple of days now. Most of the questions I've had were quickly answered by consulting the manual. But because of the app I'm building at home, I have a question that could just as easily pertain to D3, U2, OpenQM or any of the other various multivalue databases. I've built a database of all my mp3s. Now I want to generate a random list of 100 songs. s there a way to do that with a SELECT statement, or must I muck around in basic to do so. I've searched c.d.p. and the U2 users mailing list. I use U2 at work, and am familiar with SELECT ... SAMPLE 100, but it returns the same 100 records every time. Any thoughts? Thanks, -- Dave Walker 8..7 4(()) -::- -::-8.74 .74(()) ((88.74 ..74 -::- ((88.74 * Peace --- 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] True random select lists?
You are getting at the ID3 tags from QM? Sorry for the late question. I've been away for 3 days. Thanks. - Original Message - From: Dave Walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, August 09, 2005 1:50 PM Subject: RE: [U2] True random select lists? I use xmms for playing the music, but until now have used a mysql database to generate the playlists. What I'm actually trying to do is learn how to talk to OpenQM with qmclilib. I've managed to create a python wrapper for the library, and have now built the database using the same program I wrote to learn how to program python. I've just stripped out the mysql bits and put in the OpenQM equivalent. (The database structure has also changed, of course, to take advantage of multivalues!) I'll eventually put a pretty face on the frontend with PyQT, and possibly give it multiple personalities with apache2 and mod_python. But I have to learn to walk before I can run, and an mp3 application is the easiest way I have to generate a fair sized database. I can populate it from the mp3 tags themselves, and do so many fun things with it after it's built! Thanks for the comments, -- Dave Walker 8..7 4(()) -::- -::-8.74 .74(()) ((88.74 ..74 -::- ((88.74 * Peace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood Sent: Tuesday, August 09, 2005 12:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] True random select lists? The I-desc is a nice idea, however you're going to get multiple hits on the same song, and don't we all hate that when we hear the same song? The basic idea is very similar to something that I did with the thought of the day. I used to select the entire file put it into an array, and then base the random number based off of the time of the day with a modulo of a prime number close to the total number of records selected and use that to prime RND. Or maybe visa versa. It was a LONG time ago in a universe very very far away ;) This was similar to hashing in pick, and where I got the idea. Using the time, gave as close to a really random number as possible. Since I was only selecting one record a day, I would post a 1 to that record so it would not be selected the next time. When my select didn't return any records I would just clear all the 1's in the file and start over. Worked great! But but but, why not just get the free winamp www.winamp.com and just click on random??? Allen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dave Walker Sent: Tuesday, August 09, 2005 08:22 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] True random select lists? Yes, I would like a DIFFERENT 100 every time, otherwise the FIRST would have worked. The first thing I thought of was your basic routine, but I just wondered if I'd overlooked a SELECT option that I wasn't familiar with. I'm wondering which would be more efficient; the basic subroutine or Christophe's suggestion of an I descriptor? Thanks, -- Dave Walker 8..7 4(()) -::- -::-8.74 .74(()) ((88.74 ..74 -::- ((88.74 * Peace -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Martin Phillips Sent: Tuesday, August 09, 2005 10:46 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] True random select lists? Hi Dave, I've built a database of all my mp3s. Now I want to generate a random list of 100 songs. s there a way to do that with a SELECT statement, or must I muck around in basic to do so. This depends what you mean by random. If you are happy to agree that the hashing process is effectively random from an external point of view, simply use SELECT filename FIRST 100 However, you seem to want a different 100 records each time. I cannot see any way to do this aside from using a Basic program. Even then, you will have to start with a list of all the records and then extract 100 items randomly... OPEN 'filename' TO FVAR ELSE STOP SELECT FVAR READLIST LIST THEN N = DCOUNT(LIST, @FM) FOR I = 1 TO 100 X = RND(N) + 1 ID = LISTX DEL LISTX N -= 1 NEXT I END The above idea assumes that the list has over 100 items in it The basic problem here is that computers are supposed to be repeatable. What you want is random behaviour so you are unlikely to find it in the standard toolset. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org
[U2] Remove Scenario
Here's a doozy. Thanks for the previous suggestion of using REMOVE instead of the extractions. That's working very well. New problem. One client's application is written in The Programmer's Helper (TPH) which MATREADS and has EQUATES assigning variables like INVNO.TABLE TO CUST(40) etc. The program is written with INVNO.TABLE1,X style extracts everywhere. There are probably 15 mv'd fields with the suffix TABLE and their mv counters are in sync. Prior to using REMOVE (it had an issue on D3), I MATREAD in a BIG(30) array which breezed through the high item count of 155,000 records.(REMOVE took 8 seconds, BIG took around 12 and took over 9 minutes). Here's the rub. This is a Cash Reciept application where the BIG array is one customer's invoices. The load-in process jogs through the BIG array and for those items with a non-zero balance, it creates these 15 TABLE variables. Trouble is, if there's 155,000 total records for this 1 customer, 100,000 may have a balance of zero leaving 50,000 to be handled in the application. So while REMOVE is a great way to extract from BIG as a dynamic array and MATREAD is great for extracting from a DIM array, what would be the best way to build these 15 separately named TABLE variables. The original program (sans REMOVE) looked like this: C=DCOUNT(BIG,CHAR(254)) FOR I=1 TO C ID=BIGI READV BAL FROM ARFILE, ID, 10 THEN IF BAL # 0 THEN INV.TABLE1,-1=ID AAA.TABLE1,-1=SOMETHING ELSE BBB.TABLE1,-1=SOMETHING ELSE CCC.TABLE1,-1=SOMETHING ELSE MMM.TABLE1,-1=SOMETHING ELSE END END NEXT I So while REMOVE is a great extractor for these 150,000 fields, what is a great inserter for these 15 TABLE variables. In essence, the BAL # 0 is 50,000 records. I tried MV=MV+1 INV.TABLE1,MV=ID etc and got a minor improvement. I tried INV.TABLE:[EMAIL PROTECTED]:SOMETHING ELSE etc and got a slightly better improvement. In either case, you could see the progressive (exponential) delay as it performs these 50,000 (x 15) TABLE actions. I tried using my DIM BIG(30) where the dim element number was the insertable MV and I used the dynamic array concept on each dimensioned array element. Thus: MV=0 ; L=0 LOOP REMOVE ID FROM XREF AT L SETTING D READV BAL FROM ARFILE, ID, 10 THEN IF BAL # 0 THEN MV=MV+1 BIG(MV)1=ID BIG(MV)2=SOMETHING ELSE BIG(MV)3=SOMETHING ELSE BIG(MV)15=SOMETHING ELSE END END UNTIL D=0 DO ; REPEAT and it took only 8 seconds. Cool. So now I have a dimensioned BIG array with 50,000 elements each having 15 attributes. Because the infidel TABLE variables are scattered throughout this generated 1,500 line program, I don't want to search and replace them all with their BIG(MV)12 equivilents unless I really have to. Eventually, I have to take these mv'd TABLE variables and writev (sic) them onto the data file. MATBUILD doesn't seem to work with 2 dimensioned dimensioned arrays nor with elements containing attributes or values. It only likes the elements being simple variables. If this were a report program I would kick it off on a phantom and be done with it. Since it's a user oriented Cash Receipts program, the user literally waits 5-9 minutes while a single customer 'loads'. Of course, the larger more important customers are handled more frequently, thus more headaches. So the question is whether there is an INSERT or append function with the magic of REMOVE. Thanks for any insights. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Remove Scenario
Goo'day, Mark, Off the top of the head - your numbers are boggling. And you don't want *another* array with only the unpaid invoices in it? Then you write to *this* array only when you create an invoice and delete from it only when the invoice is fully paid? Or some such? Wastes disk capacity but saves time At 00:25 12/08/05 -0400, you wrote: Here's a doozy. Thanks for the previous suggestion of using REMOVE instead of the extractions. That's working very well. New problem. snip -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.7/70 - Release Date: 11/08/05 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.338 / Virus Database: 267.10.7/70 - Release Date: 11/08/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Remove Scenario
UniVerse answer, but I think it's OK in UniData too. The -1 notation with angle brackets is good, but is improved by using it at the field level. Then it's a simple string append, and rather faster. So, build the multi-valued fields by this method, then apply a LOWER function as part of building the TABLE variables or the dynamic array that you will WRITE. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Remove Scenario
Hi Mark, I seem to remember something about an internal point that is maintained for field marks @AM and not value markers @VM. I believe you will get some improvement by trying INV.TABLE:[EMAIL PROTECTED]:SOMETHING ELSE Regards, Stewart -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Friday, 12 August 2005 13:56 To: u2-users@listserver.u2ug.org Subject: [U2] Remove Scenario Here's a doozy. Thanks for the previous suggestion of using REMOVE instead of the extractions. That's working very well. New problem. One client's application is written in The Programmer's Helper (TPH) which MATREADS and has EQUATES assigning variables like INVNO.TABLE TO CUST(40) etc. The program is written with INVNO.TABLE1,X style extracts everywhere. There are probably 15 mv'd fields with the suffix TABLE and their mv counters are in sync. Prior to using REMOVE (it had an issue on D3), I MATREAD in a BIG(30) array which breezed through the high item count of 155,000 records.(REMOVE took 8 seconds, BIG took around 12 and took over 9 minutes). Here's the rub. This is a Cash Reciept application where the BIG array is one customer's invoices. The load-in process jogs through the BIG array and for those items with a non-zero balance, it creates these 15 TABLE variables. Trouble is, if there's 155,000 total records for this 1 customer, 100,000 may have a balance of zero leaving 50,000 to be handled in the application. So while REMOVE is a great way to extract from BIG as a dynamic array and MATREAD is great for extracting from a DIM array, what would be the best way to build these 15 separately named TABLE variables. The original program (sans REMOVE) looked like this: C=DCOUNT(BIG,CHAR(254)) FOR I=1 TO C ID=BIGI READV BAL FROM ARFILE, ID, 10 THEN IF BAL # 0 THEN INV.TABLE1,-1=ID AAA.TABLE1,-1=SOMETHING ELSE BBB.TABLE1,-1=SOMETHING ELSE CCC.TABLE1,-1=SOMETHING ELSE MMM.TABLE1,-1=SOMETHING ELSE END END NEXT I So while REMOVE is a great extractor for these 150,000 fields, what is a great inserter for these 15 TABLE variables. In essence, the BAL # 0 is 50,000 records. I tried MV=MV+1 INV.TABLE1,MV=ID etc and got a minor improvement. I tried INV.TABLE:[EMAIL PROTECTED]:SOMETHING ELSE etc and got a slightly better improvement. In either case, you could see the progressive (exponential) delay as it performs these 50,000 (x 15) TABLE actions. I tried using my DIM BIG(30) where the dim element number was the insertable MV and I used the dynamic array concept on each dimensioned array element. Thus: MV=0 ; L=0 LOOP REMOVE ID FROM XREF AT L SETTING D READV BAL FROM ARFILE, ID, 10 THEN IF BAL # 0 THEN MV=MV+1 BIG(MV)1=ID BIG(MV)2=SOMETHING ELSE BIG(MV)3=SOMETHING ELSE BIG(MV)15=SOMETHING ELSE END END UNTIL D=0 DO ; REPEAT and it took only 8 seconds. Cool. So now I have a dimensioned BIG array with 50,000 elements each having 15 attributes. Because the infidel TABLE variables are scattered throughout this generated 1,500 line program, I don't want to search and replace them all with their BIG(MV)12 equivilents unless I really have to. Eventually, I have to take these mv'd TABLE variables and writev (sic) them onto the data file. MATBUILD doesn't seem to work with 2 dimensioned dimensioned arrays nor with elements containing attributes or values. It only likes the elements being simple variables. If this were a report program I would kick it off on a phantom and be done with it. Since it's a user oriented Cash Receipts program, the user literally waits 5-9 minutes while a single customer 'loads'. Of course, the larger more important customers are handled more frequently, thus more headaches. So the question is whether there is an INSERT or append function with the magic of REMOVE. Thanks for any insights. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any attachments are confidential. They may contain legally privileged information or copyright material. You should not read, copy, use or disclose them without authorisation. If you are not an intended recipient, please contact us at once by return email and then delete the original message and all copies. We do not accept liability in connection with computer virus, data corruption, delay, interruption, unauthorised access or unauthorised amendment. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Remove Scenario
One thought. It seems I remember that using VAR += 1 is significantly faster than VAR = VAR + 1. It's not much, but maybe it will help. Karl quote who=Mark Johnson Here's a doozy. Thanks for the previous suggestion of using REMOVE instead of the extractions. That's working very well. New problem. One client's application is written in The Programmer's Helper (TPH) which MATREADS and has EQUATES assigning variables like INVNO.TABLE TO CUST(40) etc. The program is written with INVNO.TABLE1,X style extracts everywhere. There are probably 15 mv'd fields with the suffix TABLE and their mv counters are in sync. Prior to using REMOVE (it had an issue on D3), I MATREAD in a BIG(30) array which breezed through the high item count of 155,000 records.(REMOVE took 8 seconds, BIG took around 12 and took over 9 minutes). Here's the rub. This is a Cash Reciept application where the BIG array is one customer's invoices. The load-in process jogs through the BIG array and for those items with a non-zero balance, it creates these 15 TABLE variables. Trouble is, if there's 155,000 total records for this 1 customer, 100,000 may have a balance of zero leaving 50,000 to be handled in the application. So while REMOVE is a great way to extract from BIG as a dynamic array and MATREAD is great for extracting from a DIM array, what would be the best way to build these 15 separately named TABLE variables. The original program (sans REMOVE) looked like this: C=DCOUNT(BIG,CHAR(254)) FOR I=1 TO C ID=BIGI READV BAL FROM ARFILE, ID, 10 THEN IF BAL # 0 THEN INV.TABLE1,-1=ID AAA.TABLE1,-1=SOMETHING ELSE BBB.TABLE1,-1=SOMETHING ELSE CCC.TABLE1,-1=SOMETHING ELSE MMM.TABLE1,-1=SOMETHING ELSE END END NEXT I So while REMOVE is a great extractor for these 150,000 fields, what is a great inserter for these 15 TABLE variables. In essence, the BAL # 0 is 50,000 records. I tried MV=MV+1 INV.TABLE1,MV=ID etc and got a minor improvement. I tried INV.TABLE:[EMAIL PROTECTED]:SOMETHING ELSE etc and got a slightly better improvement. In either case, you could see the progressive (exponential) delay as it performs these 50,000 (x 15) TABLE actions. I tried using my DIM BIG(30) where the dim element number was the insertable MV and I used the dynamic array concept on each dimensioned array element. Thus: MV=0 ; L=0 LOOP REMOVE ID FROM XREF AT L SETTING D READV BAL FROM ARFILE, ID, 10 THEN IF BAL # 0 THEN MV=MV+1 BIG(MV)1=ID BIG(MV)2=SOMETHING ELSE BIG(MV)3=SOMETHING ELSE BIG(MV)15=SOMETHING ELSE END END UNTIL D=0 DO ; REPEAT and it took only 8 seconds. Cool. So now I have a dimensioned BIG array with 50,000 elements each having 15 attributes. Because the infidel TABLE variables are scattered throughout this generated 1,500 line program, I don't want to search and replace them all with their BIG(MV)12 equivilents unless I really have to. Eventually, I have to take these mv'd TABLE variables and writev (sic) them onto the data file. MATBUILD doesn't seem to work with 2 dimensioned dimensioned arrays nor with elements containing attributes or values. It only likes the elements being simple variables. If this were a report program I would kick it off on a phantom and be done with it. Since it's a user oriented Cash Receipts program, the user literally waits 5-9 minutes while a single customer 'loads'. Of course, the larger more important customers are handled more frequently, thus more headaches. So the question is whether there is an INSERT or append function with the magic of REMOVE. Thanks for any insights. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 800-789-9300 1,29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
