Hello all you smart people. I'm trying to parse some incoming text (converted from a PDF). I have imported the text into Table_1. Each row in Table_1 contains keywords, followed by the data that I want (with variable spaces before the keywords and between the keyword and the data. Table_2 contains the keywords and associated column names.
I first project a temp table to hold the result. I have set up a declare cursor1....fetch vKeyword...and a while loop to step through the keywords. I then use declare cursor2...where Field_1 contains 'vkeyword' to step through the rows. I am using lots of functions SLEN, SGET, ISSPACE, STRIM to parse my data. During processing I get the 'Insufficient Buffer Space to Process _expression_ (2136) Error'.
It seems loose everything and reset the buffer. It will continue processing until the error appears again.
Am I doing something stupid? Is there a way to make the buffer larger? Is there a way to clear the buffer prior to doing the next Table_1 fetch? I have found the Microrim_Tmpmaxblk in the help file. It talks about the buffer for temporary tables. Is this where expressions process, or is it a buffer for accessing/indexing the data in the temp table? I hope one of you smart people can point me in the correct direction.
