Re: [U2] UniQuery COPY FROM syntax error - Weird behavior
Brian and Gregor, Thanks SO much for your suggestions. I checked the VOC entries and found that the FROM entry was indeed missing in our development account. I added it back and was able to perform the command. I really appreciate everyone's help with this. Cheers! Eric :ELE VOC File name = VOC. Record name = FROM New record. : I 0001= K 0002= FROM 0003= : FI FROM filed in file VOC :COPY FROM APPROVALS RECORD1, RECORD2 1 records copied ___ 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] 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
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
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
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 eric.malmb...@cpcc.edu To: 'U2 Users List' u2-users@listserver.u2ug.org 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
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
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