SQL and MIMS table

• Feb 12, 2003

• #2

ssmgr

Technical User

Feb 2, 2003

40

AU

Yes, SQL makes a fine reporting tool. For data dictionaries, check out

http://www.mincom.com

. You can register as a user, then get access to Technical Data for MIMS OE 4.3, Ellipse 5.1 or Ellipse 5.2. These all provide links to data dictionaries.

Steve

 

Upvote 0 Downvote

• Feb 13, 2003

• #3

Calator

Programmer

Feb 12, 2001

262

AU

If you or your client have MIMS, you would also have the data dictionary on site; it is part of the distribution cd-rom; you would also need entity relationship diagrams that should also be part of system doco distributed.

 

Upvote 0 Downvote

• Feb 23, 2003

• #4

Drw

MIS

May 29, 2001

75

KR

If you have access to the MIMS or Ellipse on your server, you should have a copy of the data dictionary called datadict.rpt in the mims_src/software directory for MIMS or login as the mincomcm (Ellipse Source User) and cd to the software directory for Ellipse. This is a plain text file.

Drew

 

Upvote 0 Downvote

• Feb 24, 2003

• #5

PhantomPhil

Programmer

Sep 19, 2002

47

AU

You will also need to translate the logical MIMS files (as listed in the data dictionary doco as referenced above) to the physical Database tables. i.e. There is often, but not always a 1-to-1 relationship between MIMS file and Database table.

Code:

SQL> select table_name               
  2  from user_tables                
  3  where table_name like 'MSF096%' 
  4  ;                               
                                     
TABLE_NAME                           
------------------------------       
MSF096                               
MSF096_STD_MEDIUM                    
MSF096_STD_STATIC                    
MSF096_STD_VOLAT

 

Upvote 0 Downvote