The following SQL statement gets me the record I'm interested in. I want to delete that record. How do I properly combine this SELECT statement with the DELETE statement? Does this become the WHERE clause after DELETE FROM MYLIB/MYFILE, or a subselect, or?
SELECT MIN( DATE('20' || trim(CHAR(YY)) || '-' || trim(CHAR(MM)) || '-' || trim(CHAR(DD)))) from MYLIB/MYFILE where PERIOD = '22'