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

Hi Eric

SQL uses DDM files as the mechanism to support aliases. That is possibly what this is - note the *LOCAL. Or maybe *LOCAL DDM files have always been readable with SQL.

Vern

On 10/7/2010 4:40 PM, elehti@xxxxxxxxxxxxxxxxxx wrote:

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