Recent content by kasundha

Thanks. Yes, we are planning to move AIX to Linux and upgrade the OE version too.

OE 11.7.19 OS : - AIX 7.2.0.0 As an audit requirement, I want to track structural-level changes in the DB. Adding new extents. Loading DF files. online backups. or any other changes in the db. (Not data level changes).

So do we have any mechanism to apply some conditions to DBA users like a password expiration period?

Encoded charaters are same for different charater sets... :oops:

I'm using _user table to manage user accounts in the system but I'm using application-level password policy to manage user's passwords. I need to implement a password policy in the database. scenarios as follows. for password complexity. password renewal timeframes. password history (cannot use...

In 2023, I'm facing the same issue. If guys have found any solution to this, please do comment. thanks

Thank you... this is great

I need to use XIRR function with openedge 10.2B version.

I need to remove large spaces from a given string value before updating the db. eg: - 'PTPPromise to Pay :- 07/05/2019 , 13500.00 , Walk In , , RelativesMet customer wife . T.p.0702462817.'

we have limited user licence and that is why i'm suffering about this issue. these days our network is a little bit slower than other days, is it effects to occur this issue.?

This is the code. DEFINE NEW GLOBAL SHARED VARIABLE mBNAME AS CHAR. DEFINE NEW GLOBAL SHARED VARIABLE mSYSDATE AS DATE. DEFINE NEW GLOBAL SHARED VARIABLE loginname AS CHAR. DEFINE VARIABLE vConFlag AS LOGICAL NO-UNDO. SESSION:MULTITASKING-INTERVAL = 100. DO WHILE NOT (CONNECTED ("gl")...

The session is still shown as an active session in PROMON.

Hi all, I have scheduled an automated process to generate a system report. after the process completed it needs to disconnect the DB connection and close the program. the problem is, the program(Screen) is closing properly but the session in the DB server is still in the active mode and I have...

Hi, I have a openedge code and it gets more than 10 hours to run. first table has 40K + records and other tables have about 5 records per each record of first table. can you give me any suggestion to improve the efficiency of this code. -------------------- FOR EACH corpdata.ArrearsRpt...