DB2 clob type inserts data larger than 32k and reports an error

unreal99

The table structure is like this
create table CONTENT (
ID VARCHAR (30),
CONTENT CLOB (2M)
);

I heard that the db2lic.ini file needs to be changed, so I added [common] to the file. In fact, I do n’t know if I should use the [common] tag or the database name in the system, such as [mydbname] But no matter it is [common] or [mydbname] tag, use command to insert into content values ​​('abc', 'ddddddddddddddddddddddddddd ......) when the content content is greater than 32k, it will report sqlstate: 54002 characters String constant is too long. I really don't know how to insert data larger than 32k into db2. Please give us some opinions!

; Comment lines start with a semi-colon.

[tstcli1x]
uid = userid
pwd = password
autocommit = 0
TableType = "'TABLE', 'VIEW', 'SYSTEM TABLE'"

[tstcli2x]
; Assuming dbalias2 is a database in DB2 for MVS.
SchemaList = "'OWNER1', 'OWNER2', CURRENT SQLID"


[MyVeryLongDBALIASName]
dbalias = dbalias3
SysSchema = MYSCHEMA


[common]
LONGDATACOMPAT = 1
LOBMAXCOLUMNSIZE = 2147483647

[mydbname]
LONGDATACOMPAT = 1
LOBMAXCOLUMNSIZE = 2147483647

vincentpan

It is the limitation of sql length, you'd better pass the value by parameter

For example, in .net development, you won't still use patchwork sql.

琳儿宝贝

Your table space should be large, generally no more than 32K with no pages!

luckythename

I also want to know, I am looking for information in this area~~~~~