How to set the output file for edsbr?

[krutarthap]

Hi,

I want to use edsbr to generate a file with a list of extensions and phone names. I use

edsbr
clear
dir
name
go file

but the file being generated is always /tmpd/edsbr.out. Can i change the name of this file, to e.g. /tmpd/myfile.out?

[Eliott]

mv /tmpd/edsbr.out /tmpd/myfile.out
Other way is not possible as edsbr calls just /usr2/oneshot/mtcl/edmcs with fixed options.
Or use:
cdmao;echo "SELECT Mcdu,S_Name,F_Name,UTF8_S_Name,UTF8_F_Name FROM PHONEB;"|cuser|grep "\-\-" |grep -v Mcdu |cut -c5- >/tmpd/myfile.out

[krutarthap]

Thanks a lot! The second command is very useful, it is much simpler than edsbr.

Is the database structure (tables & fields) documented anywhere? I think there may be other useful queries that we don't know about yet.

[Eliott]

Is the database structure (tables & fields) documented anywhere?

I think so but have never seen it. It's R&D internal and I'm not an ALU developer.

[emning]

Is the database structure (tables & fields) documented anywhere? I think there may be other useful queries that we don't know about yet.

I've been working on a simple extension that required this as well, and found the table names by looking at the files in /DHS3data/mao.

In other words, this should give you a list of table names:

Code: Select all

cdmao
for x in $(ls *.idx); do echo ${x%%M.*}; done

From there a simple "select * from" on a table will give you field names and contents.

[Eliott]

Is the database structure (tables & fields) documented anywhere? I think there may be other useful queries that we don't know about yet.

I've been working on a simple extension that required this as well, and found the table names by looking at the files in /DHS3data/mao.

In other words, this should give you a list of table names:

Code: Select all

cdmao
for x in $(ls *.idx); do echo ${x%%M.*}; done

From there a simple "select * from" on a table will give you field names and contents.

Easier: cat /usr2/fab/tbl2obj.ref