Insert or Update to a Long Character field in Peoplesoft.

最新推荐文章于 2023-11-30 22:36:55 发布

conanxun

最新推荐文章于 2023-11-30 22:36:55 发布

阅读量108

点赞数

分类专栏： Peoplecode

Peoplecode 专栏收录该内容

23 篇文章

订阅专栏

当使用PeopleCode、独立SQL或Application Engine SQL在PeopleSoft中插入或更新长度超过254个字符的LongCharacter字段时，会遇到字符串被截断的错误。本文介绍了一种解决方案，通过使用%TextIn函数可以成功处理长字符串。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

When inserting or updating a Long Character field in Peoplesoft using peoplecode, standalone SQL or Application Engine SQL, if the target string to be inserted

happens to be more than 254 characters long, the program results in an error saying "String or Binary data would be truncated" and the insert/update fails.

This issue can be resolved by using the %TextIn function as shown below.

UPDATE RECORDNAME SET XLATLONGNAME = %TEXTIN(:1)
INSERT INTO RECORDNAME VALUES(:1,:2,%TEXTIN(:3))

In the above example, :1 and :3 are the target long string that is to be inserted in the Long character field.

-- This tip has been provided by Sumanta K Sen.

Sumanta K Sen1/India/IBM.