RE: [U2] [UV] DATA statement not executing
And, just for the record, you can also stack as many commands as you wish like this: COMMANDS = 'SELECT FILE' COMMANDS-1 = 'PROGRAM2RUN' EXECUTE COMMANDS [ append optional parameters here ] [snip] Generally I prefer this syntax EXECUTE SELECT FILE,//IN. PROGRAM2RUN [snip] EXECUTE SELECT FILE IF SYSTEM(11) THEN EXECUTE PROGRAM2RUN --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] DATA statement not executing
but with that syntax, wont PROGRAM2RUN execute regardless of whether or not the SELECT returns results? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stevenson, Charles Sent: Thursday, February 24, 2005 8:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] DATA statement not executing And, just for the record, you can also stack as many commands as you wish like this: COMMANDS = 'SELECT FILE' COMMANDS-1 = 'PROGRAM2RUN' EXECUTE COMMANDS [ append optional parameters here ] [snip] Generally I prefer this syntax EXECUTE SELECT FILE,//IN. PROGRAM2RUN [snip] EXECUTE SELECT FILE IF SYSTEM(11) THEN EXECUTE PROGRAM2RUN --- 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] InterCall on Linux (to AIX)
Hey all, All of this talk of web interfaces has gotten me to experiment with InterCall .. I'm trying to get a sample program running InterCall to work on a RedHat machine talking to a UDT database on an AIX machine .. I've successfully gotten the ICTEST program to work native on the AIX machine, and also have it talk to other servers that we have .. I'm guessing that to get the ICTEST working on Linux, I've got to get a version of PE for Linux, and then MAKE the ICTEST there .. IBM took down the PE from their web site .. So - assuming I've got my process correct, if anyone has a copy of PE to share so I can get InterCall working, please email me privately .. Thanks .. -Chuck --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] DATA statement not executing
but with that syntax, wont PROGRAM2RUN execute regardless of whether or not the SELECT returns results? Yes. Like I said, it was for the record. I've deleted the original post, but I think the question was about this syntax sometimes failing: CLEARDATA DATA 'PROGRAM2RUN' EXECUTE 'SELECT FILE' I have never seen that fail, so I'm no help. And, look, let's not nitpick about how the original poster runs his program, whether he selects inside or outside the PROGRAM2RUN, etc., how he tests intermediate results, etc.. Obviously FILE and PROGRAM2RUN are not the real thing. He simplified things just to set up an example we could all comprehend. My own tangential point was that it is possible to stack tcl commands in a dynamic array, separated by field marks, then execute the lot. Basically the array can look like a paragraph, including IF, GO, and labels. (Silly) example: CT CDS.BP CLARK CLARK 0001 CMD = 'TIME' 0002 CMD-1 = 'SELECT VOC WITH TYPE = NOSUCH SAMPLE' 0003 CMD-1 = 'IF @SELECTED 0 THEN GO GOT.IT' 0004 CMD-1 = 'GO FAILED' 0005 CMD-1 = 'GOT.IT: DISPLAY GOT IT' 0006 CMD-1 = 'GO DONE' 0007 CMD-1 = 'FAILED: DISPLAY FAILED' 0008 CMD-1 = 'DONE: DISPLAY DONE' 0009 CMD-1 = 'WHO' 0010 CMD-1 = 'TIME' 0011 EXECUTE CMD RUN CDS.BP CLARK 10:59:53 24 FEB 2005 0 record(s) selected to SELECT list #0. FAILED DONE 11 cds33896 10:59:53 24 FEB 2005 One nice thing about this technique is that it spawns the execution once, not once per command to execute. When and whether appropriate to use this command stacking technique, I leave to individual programmers. cds P.S. 'empirical' is spelt with an 'i' in the middle, not an 'e' like one ideot posted yestirday. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Order of criteria
Hi All, Does the order of criteria matter in a select or list statement, or is the execution order arbitrary? For example, if I wanted to select vendors who sell apples in Denver, is Select vendors with location='Denver' and products='Apples' the same as Select vendors with products='Apples' and location='Denver' Given that out of 300 vendors, 50 sell apples, and 100 are in denver, and 15 of those in Denver sell apples. If it does matter, should I put the criteria that is likely to return the smallest result set first? TIA, John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2][UV] Forcing a port to close
Is anyone aware of a way to force a socket port to close at the operating system level. We are currently using Sun 9.xx. We have a process that opens a port and accepts socket connections. Whenever we stop it and try to restart it, we get a port in use message. The only way that I've been able to get it to release the port is to stop and start universe again. I'm just wondering if there is a way to force the port to close. Thanks. Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Order of criteria
As I understand it, the query optimizer can shuffle things around as necessary, but the real issue is whether any of the fields are indexed. If the fields are indexed you might get better response by selecting those using an index first, and then subselecting the remaining ones after the initial select has completed. If you try to select an indexed field alongside a couple of nonindexed fields, the query optimizer may or may not choose to use the index; I'm still a bit unclear as to the line there. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John Sent: Thursday, February 24, 2005 1:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Order of criteria Hi All, Does the order of criteria matter in a select or list statement, or is the execution order arbitrary? For example, if I wanted to select vendors who sell apples in Denver, is Select vendors with location='Denver' and products='Apples' the same as Select vendors with products='Apples' and location='Denver' Given that out of 300 vendors, 50 sell apples, and 100 are in denver, and 15 of those in Denver sell apples. If it does matter, should I put the criteria that is likely to return the smallest result set first? TIA, John --- 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][UV] Forcing a port to close
quote who=Nick Cipollina Is anyone aware of a way to force a socket port to close at the operating system level. We are currently using Sun 9.xx. We have a process that opens a port and accepts socket connections. Whenever we stop it and try to restart it, we get a port in use message. The only way that I've been able to get it to release the port is to stop and start universe again. I'm just wondering if there is a way to force the port to close. Thanks. I'm not sure this will help, but in Linux there's the /proc filesystem. In that filesystem there's a file that represents everything that's going on. Whenever I have a similar problem, I use fuser -k /proc/whatever/file and that essentially 'closes' the process. Karl Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- 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/
RE: [U2] Order of criteria
Generally speaking, you've got it right, John. A few caveats, notes, gotchas: - Use EXPLAIN keyword to get RetrieVe to show you what it is going to do. - If a field is indexed, and no select list is active when the retrieve command starts, the index will be applied before any actual select data lookup on the primary data file. - If your 'products' field were an expensive calculated value like a trans() or t-correlative to another file or an expensive subroutine call, you should probably do it after the selection on simple stored data. - If you have multiple passes over the same file, e.g., A SELECT or 2 followed by LIST, leave the list unsorted until the final pass. That way the intermediate select lists remain in disk order, resulting in less disk reads if multiple records happen to hash to the same group. - Use parentheses to better control your selection criteria. - If it gets too complicated and you want explicit control, pack all your selection criteria into one I-descriptor that returns a true or false. That way it is just basic code that you and the pgmr that follows you 2 years from now can easily understand and maintain. cds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John Sent: Thursday, February 24, 2005 12:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Order of criteria Hi All, Does the order of criteria matter in a select or list statement, or is the execution order arbitrary? For example, if I wanted to select vendors who sell apples in Denver, is Select vendors with location='Denver' and products='Apples' the same as Select vendors with products='Apples' and location='Denver' Given that out of 300 vendors, 50 sell apples, and 100 are in denver, and 15 of those in Denver sell apples. If it does matter, should I put the criteria that is likely to return the smallest result set first? TIA, John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Order of criteria
I agree with Kevin's answer. Also, it may depend on which U2 product/pick-like product you are using. I always try to order the WITH statements so the one selecting the fewest records is first. However, I always place the fields with translates last since I know that translates are much more expensive than looking at data within the record. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] Hi All, Does the order of criteria matter in a select or list statement, or is the execution order arbitrary? For example, if I wanted to select vendors who sell apples in Denver, is Select vendors with location='Denver' and products='Apples' the same as Select vendors with products='Apples' and location='Denver' Given that out of 300 vendors, 50 sell apples, and 100 are in denver, and 15 of those in Denver sell apples. If it does matter, should I put the criteria that is likely to return the smallest result set first? TIA, John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Unidata vs SQL
Does anyone know where I can get a document that explains the key differences between the Unidata and SQL database ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UV] Forcing a port to close
[EMAIL PROTECTED] wrote: I'm not sure this will help, but in Linux there's the /proc filesystem. In that filesystem there's a file that represents everything that's going on. Whenever I have a similar problem, I use fuser -k /proc/whatever/file and that essentially 'closes' the process. Karl You can also reference the port directly with fuser. This should work for other unixes in addition to linux. For example, fuser -k telnet/tcp would kill all the telnet daemon processes, fuser -k 5100/upd would kill whatever's listening on udp port 5100. The default fuser kill signal is SIGKILL (9), which might not be the most desirable way to terminate the process. On linux you can specify a different kill signal (like 15) with the fuser -signal option. On unix you might want to use fuser to determine the process ID, then use kill to get rid of it. -John -- John Hester System Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Order of criteria
Under Universe 9.6, I found that it was much faster to do two selects, the first one with just the index and then the second for the rest of the conditions. The new versions are supposed to optimize for indexing and also for tfile conversions. Roger Kevin King wrote: As I understand it, the query optimizer can shuffle things around as necessary, but the real issue is whether any of the fields are indexed. If the fields are indexed you might get better response by selecting those using an index first, and then subselecting the remaining ones after the initial select has completed. If you try to select an indexed field alongside a couple of nonindexed fields, the query optimizer may or may not choose to use the index; I'm still a bit unclear as to the line there. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Aherne, John Sent: Thursday, February 24, 2005 1:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] Order of criteria Hi All, Does the order of criteria matter in a select or list statement, or is the execution order arbitrary? For example, if I wanted to select vendors who sell apples in Denver, is Select vendors with location='Denver' and products='Apples' the same as Select vendors with products='Apples' and location='Denver' Given that out of 300 vendors, 50 sell apples, and 100 are in denver, and 15 of those in Denver sell apples. If it does matter, should I put the criteria that is likely to return the smallest result set first? TIA, John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Forcing a port to close
This is a typical socket address condition that can't be safely overridden by hand. If you look at your net stats, the socket in question is probably in a CLOSE_WAIT state. This is a subsystem status that says the remote has shutdown and it's waiting for the socket to close and cleanup. If the socket gets dumped improperly by the socket application, then the socket can be left in CLOSE_WAIT with no process attached to finish cleanup. The status will clear up, but it could take a long time. That all depends on the tcp_close_wait setup and whether or not the socket is setup with the SO_LINGER flag. If the socket's SO_REUSEADDR flag can be enabled using some kind of U2 setsocketopt function before you listen on it, then you can re-use the same socket address over and over again. Check out this sockets FAQ: http://www.unixguide.net/network/socketfaq/ Glen http://picksource.com http://mvdevcentral.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nick Cipollina Sent: Thursday, February 24, 2005 4:20 PM To: u2-users@listserver.u2ug.org Subject: [U2][UV] Forcing a port to close Is anyone aware of a way to force a socket port to close at the operating system level. We are currently using Sun 9.xx. We have a process that opens a port and accepts socket connections. Whenever we stop it and try to restart it, we get a port in use message. The only way that I've been able to get it to release the port is to stop and start universe again. I'm just wondering if there is a way to force the port to close. Thanks. Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- 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] Unidata vs SQL
Do you want something to justify UniData to management or for evaluation for development purposes. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: Friday, 25 February 2005 9:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata vs SQL Does anyone know where I can get a document that explains the key differences between the Unidata and SQL database ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- 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] Unidata vs SQL
We use both Unidata and SQL. I wanted to see if SQL has the equivalent of multivalues in Unidata. Or how does SQL handle mv's for instance. David Jordan [EMAIL PROTECTED] wrote: Do you want something to justify UniData to management or for evaluation for development purposes. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: Friday, 25 February 2005 9:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata vs SQL Does anyone know where I can get a document that explains the key differences between the Unidata and SQL database ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- 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/ - Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unidata vs SQL
Traditional Sql (rdbms) doesn't support multi valies. You have to create tables and relationships in sql to handle what a mv database can do in one record. I have seen benchmarks where a mv db out performs oracle and other relational databases simply because you don't have the cost of joins in a mv db. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: Thu Feb 24 18:27:49 2005 Subject: RE: [U2] Unidata vs SQL We use both Unidata and SQL. I wanted to see if SQL has the equivalent of multivalues in Unidata. Or how does SQL handle mv's for instance. David Jordan [EMAIL PROTECTED] wrote: Do you want something to justify UniData to management or for evaluation for development purposes. Regards David Jordan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave S Sent: Friday, 25 February 2005 9:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata vs SQL Does anyone know where I can get a document that explains the key differences between the Unidata and SQL database ? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- 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/ - Do you Yahoo!? Yahoo! Mail - Find what you need with new enhanced search. Learn more. --- 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] Order of criteria
EXPLAIN is Universe-only, not Unidata. Sorry about that. It goes anywhere on the RetrieVe command line. If run from tcl, output is to the screen. -Original Message- From: Don Verhagen Charles, What is the syntax for the EXPLAIN keyword I don't see it documented in Unidata (6.X) I tried: SELECT MY.FILE WITH MY.FILE=SOMETHING EXPLAIN All it did was select the records, does it EXPLAIN in a log file or somewhere else? Thanks, --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/