[[{“value”:”It has always been a bit of a bind to look up what a SQL codes means, to be able to discover what error or warning Db2 for i is giving me for a SQL statement I have executed. There is a message file, QSQLMSG, where I can convert the SQL code into a message id and then look in the message file for the message texts:
SQL code -501 = Message id SQL0501
DSPMSGD RANGE(SQL0501) MSGF(QSQLMSG)
With the technology refreshes for IBM i 7.5 TR3 and 7.4 TR9 comes a table function where I can pass it the SQL code, and the results include all the information I desire:
Message id
Message text
Second level message text
Read more »”}]] Read More