SQLCODE -327



Get solution for your ABEND Codes & System Error Messages, SQL Codes, File Status etc...

SQLCODE -327

Postby andrekilik » Tue Nov 06, 2012 6:42 pm

Hi guys, i'm with a little problem with this SQLCODE, hope you guys can help me get a clear picture of it.

This is how my table is declared.

EXEC SQL DECLARE DB2PRD.THIST_ESTAT_MOVTO TABLE           
( CPSSOA_JURID                   DECIMAL(10, 0) NOT NULL,
  NSEQ_UND_ORGNZ                 DECIMAL(8, 0) NOT NULL, 
  CPRODT_SERVC_OPER              DECIMAL(8, 0) NOT NULL, 
  HINCL_HIST                     TIMESTAMP NOT NULL,     
  CPTCAO_TBELA                   DECIMAL(2, 0),           
  QMOVTO_OPER_APLIC              DECIMAL(8, 0),           
  VMOVTO_OPER_APLIC              DECIMAL(17, 2),         
  PMED_TX_OPER                   DECIMAL(7, 4),           
  TMED_CURVA_DEP                 DECIMAL(5, 0),           
  QMOVTO_OPER_RESGT              DECIMAL(8, 0),           
  VMOVTO_OPER_RESGT              DECIMAL(17, 2),         
  QMOVTO_BAIXA_RESGT             DECIMAL(8, 0),           
  VMOVTO_BAIXA_RESGT             DECIMAL(17, 2),         
  QMOVTO_PGTO_RESGT              DECIMAL(8, 0),           
  VMOVTO_PGTO_RESGT              DECIMAL(17, 2),         
  HATULZ_ESTAT_MOVTO             TIMESTAMP NOT NULL       
) END-EXEC.                                               

It is using the field CPTCAO_TBELA as its partitioning field, as follow below in the create of the table.

PARTITION BY (  CPTCAO_TBELA)                               
(                               
  PARTITION 1 ENDING AT (9),     
  PARTITION 2 ENDING AT (19),   
  PARTITION 3 ENDING AT (29),   
  PARTITION 4 ENDING AT (39),   
  PARTITION 5 ENDING AT (49),   
  PARTITION 6 ENDING AT (59),   
  PARTITION 7 ENDING AT (69),   
  PARTITION 8 ENDING AT (79),   
  PARTITION 9 ENDING AT (89),   
  PARTITION 10 ENDING AT (99)   
)                               


Now here is my problem, since the partitions go from 0 to 99, and my field is declared as DECIMAL (2, 0), i believe it should accept any value between this range, since i am not even allowed to insert a value bigger than 99, am I right?

The problem is, no matter which value i try to insert in this field, i get a -327 SQLCODE.
I have no idea, why this is happening, can anyone help me out?
Thanks in Advance

Code'd
andrekilik
 
Posts: 1
Joined: Tue Nov 06, 2012 6:29 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQLCODE -327

 

Re: SQLCODE -327

Postby Pandora-Box » Tue Nov 06, 2012 6:59 pm

What is your value to insert data??

Without seeing that no one could provide with best answers

Also Please see explanation of SQLCODE -327

-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 processed.
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
User avatar
Pandora-Box
 
Posts: 65
Joined: Fri Feb 10, 2012 8:30 pm
Location: Mars
Has thanked: 3 times
Been thanked: 6 times


Return to ABENDS & SQL Codes

 


  • Related topics
    Replies
    Views
    Last post