Hello,
If anyone has an extra set of Progress manuals/books lying in their offices & want to sell it, I'm willing to buy it. Please let me know ASAP or if anyone knows if it can be bought at any other place for rates less then PSC charges.
I'm interested in actual books not e-documentaion of...
Syntax on Point 1 is correct.
In addition to this You can also think about increasing number of clusters by using proutil db-name -C bigrow n
By default cluster# are 4 but you can see how much you want.
#2 I believe to change cluster size your DB must be SHUT; AI doesn't have to be. I'm not...
PROGRESS 9.1D on Unix.
I moved a table from one area to another using
proutil dbname -C tablemove pub.tablename "accounting data area" "accounting data area"
This command ran successfully.
I logged in to the DB and went to data dictionary => Schema => Modify table => picked same table i...
I've figured out the answer from Peg.com. Its because of whitespaces between content elements. If i convert my XML to one single line then i can see all data pulled by the program.
This works but its a weird solution that everytime i need to convert my XML to a single line first to be able to...
Code Below is supposed to read an XML document & list all the tags (in ShowAll procedure) & all Data in (ShowDataOnly prcedure).
But this prcedure is working correctly only for Tags & isn't showing data at all. Eventhough data between tags is there I 'm displaying it in a message in block...
Yes as a matter of fact I have changed DB startup script to start watchdog after starting DB. & last night I rebooted the server and so far have not seen any semphore error. Yeah i don't have trap 0 or 1 in the scripts.
Interestingly there's no warning msg 0f 1093. But wih your help I have been...
11:26:04 Usr 65: Login by uucp on batch. (452)
11:26:04 Usr 65: Logout by uucp on batch. (453)
11:27:43 Usr 65: Login by uucp on batch. (452)
11:27:43 Usr 65: Logout by uucp on batch. (453)
11:28:19 Usr 65: Login by uucp on batch. (452)
11:28:19 Usr 65: Logout by uucp on batch...
SYSTEM ERROR: unable to set semaphore set :\, errno 22. (551)
.
.
.
.
Invalid semaphore id (1132)
.
.
.
Semaphore id 8799 was removed (1075)
I'm seeing bunch of these messages with in 1 day of processing in log file of the database. When Semphore ID is removed a user gets disconnected.
I...
hey dean
i'm having trouble even with starting Word.Application Componet with progress handle.
DEFINE VARIABLE chWordApplication AS COM-HANDLE.
/* create a new Word Application object */
CREATE "Word.Application" chWordApplication.
/* chWordApplication:Visible = TRUE. */
I compile...
I took a test recently and there were these 2 Q:-
Q. Do you think it is appropriate to use the ‘LIKE’ option on variable and temp-table definitions?
I favoured LIKE option and told about how it inherits all the attributes of DB field or table. etc etc..
Q. Which function is best CAN-DO or...
this u can use heavy as 1 entry costs only 14KB -> refers to -L parameter for lock table. i meant u can use a big number like 50k or more if ur daily activities update/delete/create a lot of records.
Btw i might have understood ur Q wrong. which side u need help with. system hardware config or...
is it somehow related to manually debugging of the Database??
If yes lets say i started my DB with this param; where do i check the logs or activity or debugging results for this???
I read this Q somewhere and i tried to find docs but couldn't.
TIA.
How much disk space and RAm your server has??
Ideally You shud have BIW & AIW running but also think about starting APWs depending up on the system activity. I read in Progress docs that 9 APW is all you need but most common use is 2 APWs.
If you have plenty of RAM then don't hesitate in...
use mvsch if your version of Progress supports it otherwise you'll have to get patch for it. This is the only solution for it, as far as i know from all the doc. I have read.
proutil <dbname> -C mvsch
This will move all the Data objects to the next unused storage areas.
There's a KB for this...
You can also do the dump&Load from Production Db in to a newly created MV DB with more extents, i suggest you go to 9 extents based on the daily growth of ur DB.
Ur newly created MV will based on new .st file with >= 6 extents.
lets see if i can help you.
lets say ur path is /usr/databases/live/base1.db.
1. First of all make a new directory
"mkdir dbbakup" in any other directory or in /usr/databases/live/
2. MOVE your current single DB in /usr/databases/live/dbbakup
directory.
3. now create a dbname.st file...
ASSIGN
call_data.sys_code = sv_sys_code
call_data.call_date = today
call_data.call_time =
REPLACE(STRING(TIME,"hh:mm:ss"),":","").
If call_time field can't be changed to numeric then this is the ONLY answer.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.