Add VOC Entry for ';'

[nick.bond]

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.

[chulett]

Wow... didn't even know there was a VOC entry for that. All I can tell you is this:

Code: Select all

NAME:   ;
TYPE:   K
DESC:   Keyword - SQL statement terminator

If that helps at all...

[nick.bond]

Sort of - I can see that by selecting from another project, my problem is what is the syntax for creating the record with Type = K and the description?

[nick.bond]

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.

[chulett]

Sorry, no idea what's going on. I work pretty much above ground. You're going to have to wait for one of the Grognards to come along.

[nick.bond]

Ray you're a star (or solider) but unfortunately I seem to have a case of the old 'catch 22'

I can't run your statement because ';' isn't in the VOC!!

I get the error "Unexpected symbol. Token was ';' "

Any ideas?

[ray.wurlod]

Catch 22 it certainly is. Type the following line exactly as shown.

Code: Select all

COPYI FROM NEWACC TO VOC ';' REPORTING 

Let me know if that worked.

[nick.bond]

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.

[ray.wurlod]

... 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!

[chulett]

Nice to know about the COPY command and NEWACC. About the only time I end up using ED is when something has gone all twisty and I'm being walked through it - usually by Ms Powers.

[nick.bond]

Thanks Ray, I didn't doubt for a second that the copy wouldn't work (or wouldn't be the better solution) I had already done it though ED though. Maybe when we're not in the middle of migration I'll delete the record again and try the copy!