Count of fields from physical file using Query..

[sireesha]

How to retrive the no.of fields/columns from physical file using the DB2/400 quey

[tomholden]

Re: Count of fields from physical file using Query..

DSPFFD on the file to an outfile then use QRY/400 on that file. or use a real tool to do the job...

[B.Hauser]

Re: Count of fields from physical file using Query..

Hi,

you may access the catalog view SYSCOLUMNS (which also can be used with Query/400)

Select Count(*) from syscolumns
Where System_Table_Name = 'MYFILE' and System_Table_Schema = 'MYLIB'

Birgitta

[sireesha]

Re: Count of fields from physical file using Query..

Hi,

you may access the catalog view SYSCOLUMNS (which also can be used with Query/400)

Select Count(*) from syscolumns
Where System_Table_Name = 'MYFILE' and System_Table_Schema = 'MYLIB'

Birgitta

Thank You....