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

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] 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,

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

[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

[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

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

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

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

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

[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

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

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

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

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

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

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

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