Add VOC Entry for ';'
Moderators: chulett, rschirm, roy
Add VOC Entry for ';'
Hi,
I've been stupid and deleted the VOC entry for ';' by mistake. Not sure of the total impact at the moment but certainly can't use SQL from command line.
Can someone give the the exact command to run to recreate this??
Thanks, Nick.
I've been stupid and deleted the VOC entry for ';' by mistake. Not sure of the total impact at the moment but certainly can't use SQL from command line.
Can someone give the the exact command to run to recreate this??
Thanks, Nick.
Regards,
Nick.
Nick.
Wow... didn't even know there was a VOC entry for that. All I can tell you is this:
If that helps at all...
Code: Select all
NAME: ;
TYPE: K
DESC: Keyword - SQL statement terminator
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
As additional info - I think I managed to delete the record after I had created a pointer to a hashed file with the incorret path, so I tried to delete the pointer using the following command I found on the forum
DELETE VOC "<<I2,HashedFile>>"
I was presented with the sort of prompt you get when executing SQL without ';' on the end, so I enteed ';' and executed!
I then found that the HashedFile pointer was still there so tried to select it from VOC to work out why it was there, only to find I couldn't use SQL anymore.
DELETE VOC "<<I2,HashedFile>>"
I was presented with the sort of prompt you get when executing SQL without ';' on the end, so I enteed ';' and executed!
I then found that the HashedFile pointer was still there so tried to select it from VOC to work out why it was there, only to find I couldn't use SQL anymore.
Regards,
Nick.
Nick.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Catch 22 it certainly is. Type the following line exactly as shown.
Let me know if that worked.
Code: Select all
COPYI FROM NEWACC TO VOC ';' REPORTING
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Thanks again ray - didn't get to try your option as IBM phoned me back. For anyone else unfortunate enough (stupid enough!) to do this here is what I did:
Open uvsh
>LOGTO projectname
>ED VOC ;
New record.
----: I
0001= Keyword - SQL statement terminator
0002= 500
0003= just hit return here- don't type this
Bottom at line 2.
----: FI
";" filed in file "VOC".
>
Nick.
Open uvsh
>LOGTO projectname
>ED VOC ;
New record.
----: I
0001= Keyword - SQL statement terminator
0002= 500
0003= just hit return here- don't type this
Bottom at line 2.
----: FI
";" filed in file "VOC".
>
Nick.
Regards,
Nick.
Nick.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
... but I don't grumble
Nick, I didn't want to take you through an ED dialogue - I did think of it, but felt that a copy from NEWACC (the source for standard VOC entries) was safer.
For anyone else, prefer the COPY command - you can get into a heap of trouble using ED if you don't know what you're doing - and a heap more if you do!
Nick, I didn't want to take you through an ED dialogue - I did think of it, but felt that a copy from NEWACC (the source for standard VOC entries) was safer.
For anyone else, prefer the COPY command - you can get into a heap of trouble using ED if you don't know what you're doing - and a heap more if you do!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.