Documenting column in SQL table in QADBIFLD (AS400)
When a table is created with SQL, several fields in the system cross-reference file QADBIFLD gets content (headings, defults a.o). I noticed that the QADBIFLD table contains a column named DBIREM (length 2000 bytes..). I also noticed that the old S36 IDDU actually put some documentation into this column. Now my question: How can text-documenation [...]

Answer Question   |  March 2, 2010  10:12 AM
AS/400 SQL, Documentation, QADBIFLD, SQL, SQL generated files, SQL tables

AS/400 QADBIFLD error Duplicate Record Key?
The AS400 job QDBSRVXR2 has system error message Duplicate Record in QADBIFLD. I am aware this is a system cross reference file. (System is doing an automatic reply of C and then tries again) Is this file now corrupt ? Would an IPL help ? Reclaim Storage ? What is causing this error. (System is [...]

Answer Question   |  February 3, 2009  11:56 AM
AS/400 error messages, AS/400 errors, Database Cross-Reference 2, Duplicate records, IPL, QADBIFLD, QDBSRVXR2, V5R2