Is the a way to print the file specifications for a master file or synonym? I know you can print it in text view but that is not very friendly. I’m looking for a way to print it in a field view look with name/format/desc/etc.

In the synonym editor there is a print option but it is grayed out and you can copy and paste but it only pastes the field name.

This message has been edited. Last edited by: <Kathryn Henning>,

Well, you can report on it:

CHECK FILE CAR HOLD
-RUN

TABLE FILE HOLD
PRINT FIELDNAME ALIAS TITLE DESCRIPTION FORMAT INDX
BY FILENAME NOPRINT
BY SUFFIX NOPRINT
BY SEGNO NOPRINT
BY SEGNAME NOPRINT
BY FLDNO NOPRINT

ON TABLE SUBHEAD
"<FILENAME <SUFFIX"

ON SEGNAME
"<SEGNAME"

ON TABLE PCHOLD FORMAT HTML
END

I assume there are methods to send report output straight to a printer.

You can use the internal system table called SYSCOLUM to print reports regarding data tables.

It is located in the reporting server catalogue directory (D:\ibi\srv77\home\catalog\syscolum.mas).

You cannot PRINT *, because it has several segments, but you can take a look at the master and try something like this:

TABLE FILE SYSCOLUM
PRINT 
NAME
COLTYPE
LENGTH
SCALE
WHERE TBNAME EQ 'CAR'
END

quote:

You cannot PRINT *, ....

If you SET ALL = PASS this will allow you to use PRINT * but be mindful of the size of synonym that you are querying. Always target a specific TBNAME unless you don't mind waiting for your browser (or other APP) to receive and display the data.

T