SqlException DB2 SQL error SQLCODE -302 SQLSTATE 22001 SQLERRMC null

Question

What does sqlcode -302 means  Where do i get the sqlcode definitions   Please advice  Thanks

User · Answer

As a general point when using a search engine to search for SQL codes make sure you put the sqlcode e g  -302 in quote marks - like  -302  otherwise the search engine will exclude all search results including the text 302  since the - sign is used to exclude results

User · Answer

You can find the codes in the DB2 Information Center   Here s a definition of the -302 from the z OS Information Center   THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER position-number IS INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE TARGET VALUE  On Linux Unix Windows DB2  you ll look under SQL Messages to find your error message  If the code is positive  you ll look for SQLxxxxW  if it s negative  you ll look for SQLxxxxN  where xxxx is the code you re looking up

User · Answer

To get the definition of the SQL codes  the easiest way is to use db2 cli    at the unix or dos command prompt  just type   db2    SQL302    this will give you the required explanation of the particular SQL code that you normally see in the java exception or your db2 sql output     hope this helped

[db2] SqlException: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null

Examples related to db2