I was trying to correct the state of objects in my library and I guess some damaged objects exist in my library. How can I find these damaged objects on an IBM I system?
To find damaged objects in as400, we can follow the below steps:
Run the DSPOBJD command from the command line and create an outfile in the QTEMP library. DSPOBJD OBJ(*ALL/*ALL)
OBJTYPE(*ALL)
OUTPUT(*OUTFILE)
OUTFILE(QTEMP/A1)
Once the outfile is created, start the Interactive SQL session and run the following command from the command line. STRSQL
Run the following SQL query to find damaged objects in the AS400 system. SELECT odlbnm, odobnm, odobtx FROM qtemp/a1 WHERE odobdm <> '0'
Here, the odobdm field value 0 means the object is not damaged; if it’s other than 0, it’s damaged.
We can find damaged objects using the DSPOBJD command outfile, field ODOBDM values, which are as follows:
To find damaged objects in as400, we can follow the below steps:
Run the
DSPOBJDcommand from the command line and create an outfile in the QTEMP library.DSPOBJD OBJ(*ALL/*ALL)OBJTYPE(*ALL)
OUTPUT(*OUTFILE)
OUTFILE(QTEMP/A1)
Once the outfile is created, start the Interactive SQL session and run the following command from the command line.
STRSQLRun the following SQL query to find damaged objects in the AS400 system.
SELECT odlbnm, odobnm, odobtx FROM qtemp/a1 WHERE odobdm <> '0'Here, the
odobdmfield value 0 means the object is not damaged; if it’s other than 0, it’s damaged.We can find damaged objects using the
DSPOBJDcommand outfile, fieldODOBDMvalues, which are as follows: