Skip to Content
0
Jun 12, 2020 at 09:04 PM

XML Transformation larger than 65k

53 Views

I have a requirement to store and transform a large XML document...larger than 65k (string limit). I am using an LCHR to store the XML. Since it exceeds the LCHR/INT2 32k byte limit I am splitting the XML into pieces and storing in multiple rows. That seems to be working. Trouble is on the XML transformation. The string limit for input to the transformation is 65k. Is there a way to work around this limit...maybe perform the transformation in chunks and concatenate together later? Thanks in advance for any assitance which might be provided. Mat.