Search results

any way you'd suggest to script loading of df files (schema changes)? currently, if the schema is locked then the load_df.p will just hang and wait for it to release which cause other requests to timeout. any ideas on how to get around this?

so no way to do this?

i am using version 10. think 10.2B04. trying to write a script to call load_df.p to load df file for schema change for multi user mode. if there are batch jobs connecting also to the database, it locks the schema till the batch job is done. trying to detect if the batch job is running (and the...

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

that does not work. display ERROR-STATUS:NUM-MESSAGES shows 0.:(

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

sounds like proquiet would wait for all updates to be made. is there a way to tell proquiet to fail if any updates are made(instead of waiting)?

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

thanks a lot. i extracted the code with the following steps: prolib $DLC/src/prodict.pl -yank prodict/load_df.p prolib $DLC/src/prodict.pl -yank prodict/user/uservar.i prolib $DLC/src/prodict.pl -yank prodict/dictvar.i prolib $DLC/src/adecomm.pl -yank adecomm/adestds.i prolib $DLC/src/adecomm.pl...

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