Display PARMLIB concatenation

June 29, 2009 Rui Miguel Feio

An LPAR can have more then one PARMLIB dataset defined to it’s concatenation. The PARMLIB concatenation is defined on the LOADxx member and we can use the MVS command “D PARMLIB”to list it. Example: “D PARMLIB” command returns: RESPONSE=LP1T IEE251I 08.54.47 PARMLIB DISPLAY 825 PARMLIB DATA SETS SPECIFIED AT IPL […]

Work with records older then x days

June 29, 2009 Rui Miguel Feio

For the sake of this example, let’s assume that: we want to work with records older then 60 days the table name is ‘table’ (how original!) the table field with dates is called date_field 🙂 DELETE FROM table WHERE date_field < DATE_SUB(CURDATE(),INTERVAL 60 DAY) This MySQL command deletes all table […]

1 40 41 42