I have query regarding SQL statement which i need to use where from file is flat file and i need to extract records from that Flat file based on values in position 15th = 'X'
Select * from Flatfile where Flatfile (position 15th = 'X') Is it possible?
Is it possible from below Code?
CPYF FROMFILE(&flib/Flat file)
INCREL((*IF Flatfilefield *EQ 'C'))
Please guide .