Help in solving SQLCODE -144.

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
alpna
Registered Member
Posts: 56
Joined: Fri Jun 21, 2013 10:35 pm

Help in solving SQLCODE -144.

Post 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.
zprogrammer
Global Moderator
Global Moderator
Posts: 588
Joined: Wed Nov 20, 2013 11:53 am
Location: Mars

Re: Help in solving SQLCODE -144.

Post 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
zprogrammer
User avatar
Akatsukami
Global Moderator
Global Moderator
Posts: 122
Joined: Tue Oct 20, 2015 3:20 am
Location: Bloomington, IL
Contact:

Re: Help in solving SQLCODE -144.

Post by Akatsukami »

Execute the troubleshooting actions here.
"I come to the conclusion that, men loving according to their own will and fearing according to that of the prince, a wise prince should establish himself on that which is in his own control and not in that of others." -- Niccolò Machiavelli
chaat
New Member
Posts: 5
Joined: Thu Oct 30, 2014 8:12 am

Re: Help in solving SQLCODE -144.

Post 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.
Chuck Haatvedt
alpna
Registered Member
Posts: 56
Joined: Fri Jun 21, 2013 10:35 pm

Re: Help in solving SQLCODE -144.

Post by alpna »

Recompiling and rebind has helped in solving the problem. Thanks everyone who has helped.
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”