Dbtool

[vasudha]

Hi ,

I am trying to use the DBTOOL from command prompt.
But i am not able to use this dbtool. I am reffering the KB P24496.
Please help me out how can i use Dbtool.
I don't know how to start this.

Regards,
Vasudha

 

[Casper]

Maybe if you tell us what is the problem (error?) and what OS you are using then we could help.... (forgot my crystal ball ).


Casper

 

[vasudha]

Hi Casper,

I am getting error in the SQL query .
"Exceeding its maximum length and precision".
So i want to check the Width of this field.
I am using PROGRESS 9.1D. When i try to run DBTOOL it is giving error "dbtool is not recognized as an internal or external command.
Is this tool not available in Version 9.1D?

 

[Casper]

dbtool was introduced in 9.1D SP6.
If you have SP6 or higher then make sure you either start from porenv are set your PATH environment variable to include $DLC/bin

Casper.

 

[girish66]

As for the SQL precision error, you may have to change the SQL width of the variable in the DB. You can use the GUI/CHAR db admin tools to do this.

 

[Casper]

As for the SQL precision error, you may have to change the SQL width of the variable in the DB. You can use the GUI/CHAR db admin tools to do this.

how about dbtool....

 

[TomBascom]

Hi Casper,
I am using PROGRESS 9.1D. When i try to run DBTOOL it is giving error "dbtool is not recognized as an internal or external command.
Is this tool not available in Version 9.1D?

I'm guessing that you're running on Windows?

That error is a windows error that usually means the PATH does not include %DLC%\bin.

You can fix it by adding the path to the executable to the PATH environment variable.

 

[vasudha]

Yes, i can change the width by using the GUI. Thanks everyone.
Ok now i got the reason why i am not able to start the DBTool because of progress version..
Thanks
My problem resolved by changing the width by using GUI.. SQL properties


Regards,
Vasudha

 

[Casper]

You could also do it with 4GL.
It is the _field._width field which has to be updated.

Als sample 4GL program to detect problematic SQL width:
http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress&id=P13348

But why not install SP9, lots of SQL improvements have been made there and dbtool runs much faster then any program you could write yourself furthermore it is an online utility and you don't need to restart the database after changing the _width field.....


Casper.

 

[vasudha]

Ok ... From which place i can get this SP06 ..
I want to install this..

 

[Casper]

Sorry, must have missed this.

If you have a valid serienumber control code then you can download it here: http://psdn.progress.com choose product download.

Follow the instructions to register.

Regards,
Casper.

 

[vasudha]

Thanks Casper ...