MVSFORUMS.com

[ANDY]

CREATE TABLE DBSSMSHR."ADCP_#ITT_UPF_R"
(CTRYNUM CHAR(3) FOR SBCS DATA NOT NULL ,
ACTION_CODE CHAR(6) FOR SBCS DATA NOT NULL ,
IUPF_START_YR CHAR(4) FOR SBCS DATA NOT NULL ,
IUPF_START_MTH CHAR(522) FOR SBCS DATA NOT NULL ,
.....

get the following error message:

[url]DSNT408I SQLCODE = -670, ERROR: THE RECORD LENGTH OF THE TABLE EXCEEDS THE PAGE SIZE LIMIT
DSNT418I SQLSTATE = 54010 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXICB3 SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 270 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'0000010E' X'00000000' X'00000000' X'FFFFFFFF' X'00
INFORMATION [/url]

How can I enlarge page limitation?
_________________
cheers,
Andy

[kolusu]

Andy,

Did you look up the sqlcode of -670 ?

Check this link for a detailed explanation of -670

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.307?SHELF=&DT=20010718150520&CASE=

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[schintala]

CREATE TABLE DBSSMSHR."ADCP_#ITT_UPF_R"
(CTRYNUM CHAR(3) FOR SBCS DATA NOT NULL ,
ACTION_CODE CHAR(6) FOR SBCS DATA NOT NULL ,
IUPF_START_YR CHAR(4) FOR SBCS DATA NOT NULL ,
IUPF_START_MTH CHAR(522) FOR SBCS DATA NOT NULL ,


I doubt, can we have more than 255 bytes in CHAR data type? I guess the column IUPF_START_MTH should be defined as VARCHAR data type to accommodate 522 bytes. What do you think?

[videlord]

create a tablespace with large page size first (using 8k/16k/32k bufferpool)
then create your table in that tablespace

[ANDY]

Hello videlord,

Thank you for your idea. This is correct way.
_________________
cheers,
Andy