Search results

Ok thank you Rob and Tom!!!

Hello @RealHeavyDude, Sql is already installed and running fine. We want to create one user under _user table and want to give permission similar to one existing user. One way of doing so, we have to list all permissions of that existing user (read/write/delete for all tables) and give the...

Hi @Rob Fitzpatrick, do you have any update on this? Kind Regards

Sorry forgot to mention, it's 10.2b.

Hello All, I want to create one user in _user table for odbc access and want to grant permissions similar to one existing user. Example:- One user "cust" has read/write permission on multiple tables, now I want to create one new user and want to give similar rights like cust user. Is there...

Hi Tom, Thanks for your reply on this!!! Live server is up but OER server is down from last few days. Restarting replication server (By command: - dsrutil source-db-name -C restart server) isn’t working because I think it will only work when both Live and OER servers are up and time gap of...

Hello All, We have one Live production server and one OpenEdge replication server. If connection fail between Live (Source) and OER (Target) server because of ERROR: - “(12688) The Replication Server has been terminated or the Source database has been shutdown. The Agents will enter...

Hello all, hope you all are doing well!!! This post is regarding Progress database access through SQL client. As per my knowledge, when we want to give access of a Progress database table to SQL user then we create one user (in _user) with sysprogress userid and grant access. I have been...

Thanks a lot Rob for this amazing information!!! I didn't see your post and posted mine. Kindly ignore. :) Regards

As per my understanding:- Meta data is the data about data or the data which is maintained for other data. For example:- _lock, _file and _Fields are tables which are maintaining information about other tables so it is meta data. If this is the correct concept of meta data then this meta...

One more question Rob, What do mean by "it won't include the size of the record and table meta data stored on the disk". Is meta data is some predefined data to user table or VST tables. Isn't the data inserted by user in user defined table?. Will proutil utility contain the size of the meta...

Thanks Rob, for this valuable information. Regards

Thanks for your reply Tamhas! Can for each give me the size of the table in B, MB and GB. I think it won't. Kindly suggest. Regards

Hi All, I want to know the size and number of records of a table. We have below mentioned progress utility for the same but it is for all tables of the database not for one required table. proutil db-name -C tabanalys Above mentioned utility is so much time consuming as I want to know the...

Thanks RealHeavyDude, Tom Bascom and Rob for your valuable inputs!!

Hi RealHeavyDude, I thought it should get updated on pause statement because customer.name field is already updated before this pause statement. I was expecting this on pause statement because as you said writing data to bi file is an asynchronous process that’s way time taken on pause...

Thanks a lot RealHeavyDude for sharing this important information!! Almost all of my questions are cleared except one: I understood that bi file update is an asynchronous process and this update will not be in-line with ABL code execution. But as per below mention code bi file is not getting...

Hello Team, I am new to DBA activities and started learning the same. Please help me out with below mentioned queries regarding BI files. 1. When .bi file gets updated. I thought is should be only when we update any DB field and transaction hasn’t completed yet or DB changes are partially...