SQL can select from this DDM (Distributed Data Managment) file

[<elehti@xxxxxxxxxxxxxxxxxx>]

DDM file AMSDTA/F0005, created 7 years ago in 2003, IS viewable with
STRSQL SELECT statements, but WHY?

 

None of our other DDM files are viewable in SQL.

 

5722SS1 V5R4M0  060210                  Display DDM Files
AMSDTA/F0005    

    Local file:


      File . . . . . . . . . . . . . :  F0005


        Library  . . . . . . . . . . :    AMSDTA


    Remote Location:


      Name or address: . . . . . . . :  '


                                         *LOCAL'


        Type . . . . . . . . . . . . :  *SNA


      Device description . . . . . . :  *LOC


      Local location . . . . . . . . :  *LOC


      Remote location network ID . . :  *LOC


      Mode description . . . . . . . :  *NETATR


    Access method:


      Remote file attribute  . . . . :  *RMTFILE


      Local access method  . . . . . :


    Share open data path . . . . . . :  *NO


    Protected conversation . . . . . :  *NO


    Check record format level ID . . :  *RMTFILE


    Text . . . . . . . . . . . . . . :


Remote file name . . . . . . . . :  '                   

                                     AMSCOM/F0005       

                                                        

*          * * * *  E N D  O F  L I S T I N G

select * from amsdta/F0005

....+....1....+....2....+....3....+....4....+

 Syst  Us     User         Description        

 Code  Cd   Def Code                          

 ----  --  ----------  --------------------   

 D1D   $I  LOTN        LT                     

 D1D   $I  UITM        IT                     

 D1D   $V  FUIRFCF     FUIRFCF                

 D1D   $V  FUIRFCL1    FUIRFCL1               

 D1D   $V  FUIRFCL2    FUIRFCL2