Page 1 of 1
Access the OXE database
Posted: 01 Jun 2023 06:23
by beatrixmartin
Hi all
Can someone get me a question about how I can access the OXE database,
I need to perform some queries directly in the database this is possible?
Re: Access the OXE database
Posted: 09 Jun 2023 18:46
by frank
All database tables are stored in their own files, in /DHS3data/mao
Use **cuser** to connect to the DB (after you changed directory to the one listed above)
I cant remember how to connect remotely to the DB
Once you are in, you can do things like
select * from POSTE where numan='xxxx';
Re: Access the OXE database
Posted: 22 Jul 2024 10:18
by felipegomes
Can i get more info on this?
I Just started learning OXE on my new job and need to run some querys on the database.
Re: Access the OXE database
Posted: 23 Jul 2024 09:10
by frank
There is no reason why you would edit the database directly, knowing that all tables are interconnected.
Best way to edit the database is through the mgr command
Any other query you would run, you either have a command line for it, or statistics from 4760 / 8770