IDS Forum

XML and Smartblob Storage

Posted By: Clifton Bean
Date: Wednesday, 28 October 2009, at 3:16 p.m.

IDS 11.5.FC5 AIX 5.3

XML Programmer can run simple functions like genxmlqueryhdr().

Example: On web database as user ifxweb

"EXECUTE FUNCTION genxmlqueryhdr('emarriage','select c_grm_lname from emarriage');" runs!

Ran into errors when XML output is greater than 32739 bytes.
Reading Informix red books, output larger than 32739 bytes need to go to Smart Large Objects and the
function needs to be one of the XML CLOB functions like genxmlqueryhdrClob().

Example: select genxmlclob(emarriage, "row") from emarriage;
Generates an Error -9810 or "No sbspace number specified".

-9810 Smart-large-object error.
An error occurred during the processing of a smart large object.
For more information, check the accompanying, detailed smart-large-object error code.

Further reading suggest the configuration file needs to be modified to create a "default sbspace". This is by default
defined in the SBSPACENAME configuration parameter. (see below) There were other topics about "permanent" versus "temporary", etc....

Since he did not need to keep the results for other than the query, I thought he could use an SBSPACETEMP space instead. A space of 1 GB was configured and assigned to that $ONCONFIG variable. I also established the following thread: VPCLASS idsxmlvp,num=1 # XML Thread Activation

He then attempted to run his query:

10/28/09 1:51 PM Executing statement:
SELECT genxml(emarriage, "row") from emarriage;
SQL Error (-8368): genxml
Error Position: Ln: 1 Col: 1

-8368 Function <funcname> Buffer size exceeds maximum size

Explanation:The output of <funcname> must be less than 32739 bytes.
Action:If the combined size of output records exceeds 32739 bytes, one need to use a clob function.

He then changed it to use the CLOB function:

10/28/09 2:01 PM Executing statement:
SELECT genxmlclob(emarriage, "row") from emarriage;
SQL Error (-9810): Smart-large-object error.
Smart Large Objects: No sbspace number specified.
Error Position: Ln: 1 Col: 1

..... back to the original error ....

Why wouldn't a SBSPACETEMP work? What uses the SBSPACETEMP space?

Since it will not work for this query, I am presuming I will need to create a regular (non-temporary) smartblob space.

When I create that space and modify the $ONCONFIG, the engine will be bounced. Do I need to leave the SBSPACETEMP variable as is (with its 1 GB assignment)?

Thanks in advance.

Clifton

_________________________________________________________________
Windows 7: Simplify your PC. Learn more.
http://www.microsoft.com/Windows/windows-7/default.aspx?ocid=PID24727::T:WLMTAGL:ON:WL:en-US:WWL_WIN_evergreen1:102009

Messages In This Thread

• XML and Smartblob Storage
  Clifton Bean -- Wednesday, 28 October 2009, at 3:16 p.m.
  • Re: XML and Smartblob Storage
    Fernando Nunes -- Thursday, 29 October 2009, at 7:46 a.m.
    • RE: XML and Smartblob Storage (Resolution)
      Clifton Bean -- Wednesday, 4 November 2009, at 2:35 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.