DB2 describe command for logical files
Home > IT Answers > AS/400 > DB2 describe command for logical files
VelcroGuy
0 pts.
0
Q:
DB2 describe command for logical files
AS/400
I've created indexes, logical files, on certain files. What is the SQL command to view the definitions of these indexes. In Oracle, SQL Server and other SQLs, the command would be 'info' or 'desc'. What is the equavalent command for DB2?
ASKED: Sep 1 2005  2:54 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
WaltZ400
535 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Whether you created a LF file from DDS or an SQL view, they are both stored as a *FILE object with an LF attribute. You can use the AS/400 DSPFD command to display view information. It displays all SQL information here.
Last Answered: Sep 2 2005  12:22 AM GMT by WaltZ400   535 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0