Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
What is -327 sql code

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
jayanta_nit

New User


Joined: 13 Apr 2006
Posts: 22
Location: hyderabad

PostPosted: Fri Feb 01, 2008 11:30 am    Post subject: What is -327 sql code
Reply with quote

Hi,

Can any one please tell what is -327 sql code??

Thanks
Jayanta,Hyderabad
Back to top
View user's profile Send private message

mkk157

Active User


Joined: 17 May 2006
Posts: 310

PostPosted: Fri Feb 01, 2008 12:01 pm    Post subject: Hi Jayanta
Reply with quote

Here is the information

-327 THE ROW CANNOT BE INSERTED BECAUSE IT IS OUTSIDE THE BOUND OF THE PARTITION RANGE FOR THE LAST PARTITION

Explanation: When a row is inserted, the calculated partition key value
for the new row must be within the bounds of a partition (as specified in
the VALUES clause of the CREATE INDEX statement).

System Action: The statement cannot be executed.

Programmer Response: Correct the statement to specify a value for the
partition key that is within the bounds of the last partition of the
partitioned table space.

SQLSTATE: 22525
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Feb 01, 2008 8:30 pm    Post subject:
Reply with quote

Hello,

Quote:
Can any one please tell what is -327 sql code??
When you have a question like this, you will usually get a much quicker answer by looking in the SQL Messages which is linked to via the "Manuals" link at the top of the page.

You were lucky that a reply was posted in 1/2 an hour - often it is much longer and if it is something you are focused on, you can save yourself time.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting GG return code abdulrafi IMS DB/DC 2 Tue Apr 10, 2018 12:31 pm
No new posts IMS error U4038 while executing my PL... abdulrafi IMS DB/DC 2 Thu Feb 08, 2018 1:05 pm
No new posts Conditional setting of return-code af... sanvan COBOL Programming 9 Wed Jan 31, 2018 11:05 pm
No new posts IBEGENER RETURN CODE 12 anilkumar922 All Other Mainframe Topics 5 Wed Dec 13, 2017 11:41 am
No new posts Finding the plan when code compiled u... Ahemad DB2 2 Fri Dec 01, 2017 6:38 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us