Access the OXE database

[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?

[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';

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

[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