I would like to schedule the dbtool to run the sql-width maintenance on a database. The platform is Windows so I assume I can use the windows scheduler to setup a job to call dbtools on a set schedule. The problem is the documentation does not state if you can run the sql-width maintenance from the command line. Is it possible to automate this tool to run? What are the command line parameters to get this to work?
It may seem silly but you cannot do it directly from the command line. Instead you have to build an input file containing the instructions that you would type and redirect input from that file.
This is explained in Knowedge Center solution id# P159769. (I would provide a direct link but so far as I've ever been able to determine there is no reliable way to do so...)
The Knowledge Center is at: http://progress.atgnow.com/esprogress/Group.jsp?bgroup=progress just choose "find solution by id" and enter P159769.
I will mark you as the correct answer but I can't seem to get the "all" table option to work. The following is my input file.
I called support and this was my problem.
The case was talking about running the 4gl script and the input was formatted for 4gl. Where the ~n in the input file you have to actually put a real newline in the input file if you are making the file manually.
this is the new content of my input file without the quotes.
and running the tool is
Hi Mister Mark Ward.
My name is Mauro and i write from Italy.
I read your post about DBTOOL Command and i appreciate so much.
If i understood well , i had the same your problem.
I need to write a UNIX Script to schedule every day DBTOOL Command to all my databases.
I wrote the script in this way :
dbtool <name of db> < input.txt
The file input.txt is written as :
When i run this script , AIX System shows me main menu of DBTOOL Command (see you the attachment), but it seems it is blocked waiting an option again...
It stops on Verbose Option , it seems need another key...
Is that possible to run DBTOOL Command in batch mode ???
Where am i wrong ????
Many thanks to read my message, THANKS IN ADVANCE to anyone...
Ciao to all.
DATABASE TOOLS MENU.docx
Hi Mister Tom Bascom.
I tried to schedule on our AIX System , a script containing the command DBTOOL.
The script is very simple and it cointans this row:
dbtool <nome db> < input.txt
The input.txt file is like that :
When i run the script, Operating System shows the main menu of DBTOOL Command , but it seems it waits for another key to press..
Could you help me ????
Did you ever do anything of similar in DOS or Unix system ???
I need use this command on ALL tables of our database because me and othhers programmers need to use PROGRESS DB via ODBC ..
Thanks in advance.
PS. I attach screenshot of DBTOOL command and where it seems to stop waiting a key...
7360.DATABASE TOOLS MENU.docx
Note that there is a -checkwidth startup parameter for the 4GL. If you specify this parameter then you can cause the 4GL to handle character columsn the same as SQL does, namely that it will not store values larger than the maximum width. Alternatively, you can cause an error message to be generated but the overly wide value will be accepted.
Thanks you very much for your answer and for your advice.
I will talk about that with our software house.
But did you ever do experience with DBTOOL Command ???
Mainly i'd like to use that.
In interactive mode , DBTOOL is very simple to use.
Using DBTOOL in batch mode, i cannot see if it works fine...it seems no..
Can you help anyway about that ???
Did you have an exprience about that ???
Thanks again and the same.