Search results

need a command line way to detect if a database is locked. we currently run batch jobs that lock the db schema and prevent loads of data definitions (.df file). would like a way to detect if the schema is currently locked (by one of these batch jobs) is there a proutil command i can run or a...

is it possible to clear a progress database cache? have a query that runs slow the first time and then fast afterwards since the records are all cached. trying to determine why the initial query is slow (doing a FOR EACH thru 300 or so records and some other FINDs in the loop) it takes around 30...

would like to know how to catch run-time errors. have the following code(error.p) which exceeds array bounds: /* error.p */ DEFINE VARIABLE v-array AS INTEGER EXTENT 10. DEFINE VARIABLE v-i AS INTEGER. DO v-i = 1 TO 11 ON ERROR UNDO, LEAVE: v-array[v-i] = v-i. END. i go into editor and run...

is it possible to bring up a progress database read only when doing multi user mode? (hoping there is a -RO option that can be giving to proserve) i know you can connect to a database read only with the -RO option, but what if you need to have the progress database up in server mode(using...

I have an incremental .df file with a schema change. I would like to have a script that can run progress code to apply it. (currently, doing thru the admin menu choice in mpro. would like to automate it to possible do at off-hours) i've heard people mention load_df.p, but i can't seem to find...