asked on
ASKER
Delete FROM DB2INST1.BOD
where YEAR(ARCHIVEDATETIME) < 2010;
HTH,
DaveSlash
ASKER
ASKER
IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.
TRUSTED BY
which version?
how many records are in the table?
how do you identify the records you need to delete?