Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
Check the VOC entries for "COPY" and "FROM" to ensure they are correct. It could be that something other than the failed COPY command has caused your problem by corrupting the "FROM" entry in the VOC. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Malmberg Sent: Thursday, 2 August 2012 7:01 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniQuery COPY FROM syntax error - Weird behavior I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1Fge2UMmSJ/1IopnSZLqhJubA54RdaPfK/3.307 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
Can you compare the VOC entry of COPY in the other working accounts vs. the VOC COPY entry in your development account? Do they match? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Eric Malmberg Sent: Thursday, 2 August 2012 7:01 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniQuery COPY FROM syntax error - Weird behavior I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1FgeDwxYsH/5dEbw3xNr22C0ByWltu3XD/2.212 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
The use of COPY FROM is flavor dependent, per each accounts' setting ED VOC RELLEVEL is see your flavor for *this* account -Original Message- From: Eric Malmberg To: 'U2 Users List' Sent: Wed, Aug 1, 2012 3:12 pm Subject: Re: [U2] UniQuery COPY FROM syntax error - Weird behavior Actually, the statement I am using is copying a record with an old key to a new key in the same file (basically just changing the primary key keeping everything else identical). It is syntactically correct and works in other environments but the command interpreter is throwing an error in this one environment. Just tried the lower case "copy" and received the same error. Grrr... ___ 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] UniQuery COPY FROM syntax error - Weird behavior
Actually, the statement I am using is copying a record with an old key to a new key in the same file (basically just changing the primary key keeping everything else identical). It is syntactically correct and works in other environments but the command interpreter is throwing an error in this one environment. Just tried the lower case "copy" and received the same error. Grrr... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
I dont remember is it U vs P mode in Unidata, I dont have an active install try lower case "copy" so Prime information copy style should kick in Eric Malmberg wrote: I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
You seem to be missing a "TO" clause Eric Malmberg wrote: I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ 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] UniQuery COPY FROM syntax error - Weird behavior
I have encountered a strange problem after mistyping the UniQuery COPY command in one of our development environments. The command tried to copy the same record to itself and failed gracefully but subsequent attempts to properly copy records in this environment fail with a syntax error. :COPY FROM APPROVALS RECORD1, RECORD1 Copying APPROVALS RECORD1 to RECORD1... RECORD1 exists in APPROVALS, cannot overwrite 0 records copied All copy statements now result in the message: :COPY FROM APPROVALS RECORD1, RECORD2 -^ syntax error We have several environments on the same server but our dev account seems to be the only one affected. Does anyone have any thoughts on what could be the problem and suggest a resolution. Thanks in advance. Eric ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Running a command in a different account
We are working on an internal scheduler to run jobs in other accounts. You can add the LOGTO command to your paragraph or proc and log to whatever account you need to run the process in... As long as the login VOC tests for phantoms it should work fine. Tom RATEX Business Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com Sent: Tuesday, July 31, 2012 11:16 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Running a command in a different account It's unix, so all the suggestions are well taken. Thanks, all!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Friday, July 27, 2012 12:31 PM To: 'U2 Users List' Subject: Re: [U2] Running a command in a different account Are you on Unix or Windows? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com Sent: Friday, July 27, 2012 10:42 AM To: u2-users@listserver.u2ug.org Subject: [U2] Running a command in a different account Greetings! We have a program that runs in one account, but under certain conditions it is becoming necessary for that program to execute a command in another account, and then continue on its merry way doing other things. One fairly simplistic example might be that the process might find it necessary to create a file in another account. We have come up with a number of different ways of accomplishing this, but all involve a "phantom" LOGTO of some sort -whether it be through working with the UV.ACCOUNT file, the LOGIN paragraph, or some combination of the above. While this will do what is necessary, there are timing issues to consider, control and response issues, error checking, etc. It can be done, but it's not pretty. Does anyone have a more elegant and efficient way of accomplishing this? Thanks in advance! Brian F. Paige _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - - CONFIDENTIALITY NOTICE: If you have received this email in error, please immediately notify the sender by e-mail at the address shown. This email transmission may contain confidential information. This information is intended only for the use of the individual(s) or entity to whom it is intended even if addressed incorrectly. Please delete it from your files if you are not the intended recipient. Thank you for your compliance. Copyright (c) 2012 Cigna = = ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ 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] Universe; SQL; Indexes?? (10.3.7 on Windows)
Try and be very specific what it is you are doing and why. For example - why are you using SQL? Are you doing SQL queries via the TCL prompt or using a client tool on Windows? What is the query? What do you mean by 'optimize the performance'...Etc., etc. UV has two query languages and a single database engine. Meaning, there is should be no difference in respect to the utilisation of indices. Clearly, if you have having to do a SQL query that requires unnest or join operation - then indices may not be significant in improving performance. Try adding the EXPLAIN keyword to your query give some clue to what (if any) query optimisation is going on...including of indices. Being unfamiliar with SQL can also be part of the issue...it's extremely powerful and can be difficult to master. Hence not for the faint hearted - especially if the query is complex and/or your table/schema is also complex. You can perform queries which can have a profound impact on the system performance, if incorrectly structured. Indexes aren't the answer to every optimisation issue. There needs to be a balance between cost versus benefit. It depends on the nature and utilisation of the file in question. Therefore: one really needs to optimise one's own SQL skills...not an easy ask...then optimise your query in order maximise expected query performance. Or perhaps avoid SQL, if it is not really necessary to utilise it. Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Saturday, 28 July 2012 1:35 AM To: .U2 List Subject: [U2] Universe; SQL; Indexes?? (10.3.7 on Windows) I'm using SQL to query Universe 10.3.7 data files, (ANSi-compliant and non-compliant formats) and indexing the files to try to optimize the performance seems in some cases to have little or no effect. I'm pretty clear on index behavior with Universe's native query language, but SQL is somewhat unfamiliar to me, and I'm wondering why I'm not getting the behavior I expect. Can anyone either point me to reference material on this, or offer thoughts based on experience? Thank you. -- Allen Egerton; aeger...@pobox.com ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users