×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Actually, that is the initial problem, but as I tried more things, I
found more problems:
1. Can't insert a CLOB column from IFS
2. Can't select a CLOB column from IFS
Here's an example:
select cast ( get_clob_from_file('/myfiles/sample_001.xml')
as varchar(20000)) ifsfile from sysibm/sysdummy1
Whatever I do, all of the above actions eventually fail with this as the
low-level error:
Message ID . . . . . . : CPF503E
Date sent . . . . . . : 04/09/13 Time sent . . . . . . :
11:23:23
Message . . . . : User-defined function error on member SYSDUMMY1.
Cause . . . . . : An error occurred while invoking user-defined function
GET_CLOB_FROM_FILE in library QSYS2. The error occurred while
invoking the
associated external program or service program QDBSSUDF2 in library
QSYS,
program entry point or external name QSQGTCF, specific name
GET_CLOB_FROM_FILE_1. The error occurred on member SYSDUMMY1 file
SYSDUMMY1
in library SYSIBM. The error code is 1. The error codes and their
meanings
follow:
1 -- The external program or service program returned SQLSTATE
42926. The
text message returned from the program is: LOB and XML locators are not
allowed with COMMIT(*NONE). .
More...
Argh.
I have done the following, either individually or in combination: used
"with CS" or "with UR" on the updates and selects. Executed STRCMTCTL
before firing up STRSQL. Used COMMIT(*ALL) on STRSQL. I've even started
journaling on SYSDUMMY1. All to no avail.
Is anyone else running into this?
Joe
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.