SQL and MIMS table

[wrong12]

Could I use SQL as report tool ?. I don´t have a table structure of MIMS (Data Dictionary) and I need to do
some reports.

 

[ssmgr]

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

 

[Calator]

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.

 

[Drw]

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

 

[PhantomPhil]

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.

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