Page 1 of 1
Help in solving SQLCODE -144.
Posted: Tue Nov 17, 2015 10:52 pm
by alpna
Hi,
For a SELECT statement I am getting SQLCODE -144. The explanation about it says 'INVALID SECTION NUMBER number '. What does that mean? How do I solve it? Please help.
Thanks.
Re: Help in solving SQLCODE -144.
Posted: Tue Nov 17, 2015 11:35 pm
by zprogrammer
Hi Alpna
Do you mind to provide the SQL statement else and did you check the manual if Your version of DB2 supports the option
What version of Db2 are you using and where did you get this error
Also please provide much information so anyone could help you on this
Re: Help in solving SQLCODE -144.
Posted: Tue Nov 17, 2015 11:46 pm
by Akatsukami
Execute the troubleshooting actions
here.
Re: Help in solving SQLCODE -144.
Posted: Wed Nov 18, 2015 12:33 pm
by chaat
I suspect that you have an overflow condition where the SQLDA area at the end of working storage has been overlaid. I would analyze the dump to check for a storage overflow condition.
Re: Help in solving SQLCODE -144.
Posted: Mon Nov 30, 2015 2:18 pm
by alpna
Recompiling and rebind has helped in solving the problem. Thanks everyone who has helped.