Under ISDB, JOBLOG showed' Internal Error 1001 has occurred SQLCOD -901'
SQLCOD was ‘-901’ (i.e. minus 901) which according to manual ’SQL Programming’ is associated with Message SQL0901 – ‘SQL System Error’
SQLERP was ‘QSQROUTE’ - According to Manual ‘DB2 Universal Database for ISeries Appendix B SQL Comms Area’, SQLERP contains the name of the product and module returning the error (see Page 826).
The first 3 characters identify the product (in this case ‘QSQ’ for ‘DB2 UDB for iSeries’ )
The Module is ‘ROUTE’ – but where are Modules explained ???????
And then advises to see ‘CONNECT (Type 1) (Page 417) or CONNECT (Type 2) (Page 422)
SQLSTT was ‘58004’ - according to manual ‘SQL Messages and Codes’ the Meaning is ‘A system error (that does not preclude the successful execution of subsequent SQL statements) occurred’.
Does this mean that the construct of the SQL statement I had attempted to build within RPG was incorrect in some way (syntactically or otherwise) or does the problem lie elsewhere?
If elsewhere, where should I look?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!