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

... it was created with SQL statement create alias (it points to the *local system)

D*B

--------------------------------------------------
From: <elehti@xxxxxxxxxxxxxxxxxx>
Sent: Thursday, October 07, 2010 11:40 PM
To: <midrange-l@xxxxxxxxxxxx>
Subject: SQL can select from this DDM (Distributed Data Managment) file

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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.