Tim

I know this was discussed a while ago and may have had something done but if so I missed it. Is there a way to get back information if a table verified or had a problem so it needs repairing. Other than a user sitting there watching in EDBManager?

Roy Lambert

Roy,

Good point. I thought if I used:

verify table table1!
verify table table2!
verify table table3!
verify table table4!

in an SQL window with "Request Execution Plan" turn on, it would show the results in the execution plan tab. But no "execution plan" tab opens up.

It also does not show up in Configuration.LogEvents.

Methinks Tim might have forgotten something.

Barry

Roy,

Yes, there is the STMTRESULT PSM/SQL function.
It returns the result of the execution of the execution of the last REPAIR TABLE and VERIFY TABLE.
There is an example in the manual showing how to use it.

--
Fernando Dias
[Team Elevate]

Barry

In EDB Manager, the errors found during VERIFY or REPAIR, if any, are shown in the "Log Messages" tab, and the final result is shown in the status bar. To make the tab visible, in case it's not, click "Log Messages" in the "Explorer" menu.

--
Fernando Dias
[Team Elevate]

Fernando


Isn't reading the manual considered as cheating?

Thanks. I'll modify my query to a script and off we go.

Roy Lambert

Fernando


Having been told about this by someone who reads the manual ,g> I'm testing it out. I tried

SCRIPT(IN Action VARCHAR, IN TableName VARCHAR, OUT Worked BOOLEAN)
BEGIN
DECLARE Stmt STATEMENT;
PREPARE Stmt FROM Action + ' TABLE '+ QUOTEDSTR(TableName,'"');
EXECUTE Stmt;
SET Worked = STMTRESULT(Stmt);
END

in EDBManager but for both REPAIR and VERIFY Worked is only set to false. I tried verifying and repairing the table as simple operations and that seems fine. I also tried SET Worked = TRUE and that was fine.

Am I doing something wrong or is it a bug?

Roy Lambert

Roy,

The manual is wrong, it's exactly the opposite - it returns TRUE if there are errors (VERIFY) or if repairs have been made (REPAIR), otherwise it returns false.
It seems I haven't read the manual carefully.

--
Fernando Dias
[Team Elevate]

Fernando


Thanks.

Roy Lambert

Fernando,

I don't see how manual is wrong in this case :

as per manual : "each reports False if no errors were found"

Conversely if VERIFY finds errors or REPAIR repairs them it will return
TRUE as per manual - which is what you're seeing.

Raul



On 1/31/2013 10:11 AM, Fernando Dias wrote:
> Roy,
>
> The manual is wrong, it's exactly the opposite - it returns TRUE if
> there are errors (VERIFY) or if repairs have been made (REPAIR),
> otherwise it returns false.

Raul,

The is now correct, but it has been corrected today, when Roy first saw it it was wrong

--
Fernando Dias
[Team Elevate]