FatsGordon
Programmer
Hi,
My problem is that I have to fill a CHAR(6000) variable with data in different sections of a SP. First time is just as easy as doing a LET assignment, but next ones wouldn't work because of the fixed quality of the CHAR data type.
Is there a way to fill in that CHAR in sucessive LET sentences? Say, if just 1000 characters have been written, then 5000 are padding blanks, so I want to start from 1001 and continue writing until all the appending is done (more or less at a point between 4000 and 5000).
I know this could be done by using several variables (one for each LET sentence), and at the end just concatenate them into the CHAR(6000) variable, but this is kind of "dirty" and I wanted a more "elegant" solution, if it is possible (of course).
Thank you in advance for your comments on this one.
Alejandro
My problem is that I have to fill a CHAR(6000) variable with data in different sections of a SP. First time is just as easy as doing a LET assignment, but next ones wouldn't work because of the fixed quality of the CHAR data type.
Is there a way to fill in that CHAR in sucessive LET sentences? Say, if just 1000 characters have been written, then 5000 are padding blanks, so I want to start from 1001 and continue writing until all the appending is done (more or less at a point between 4000 and 5000).
I know this could be done by using several variables (one for each LET sentence), and at the end just concatenate them into the CHAR(6000) variable, but this is kind of "dirty" and I wanted a more "elegant" solution, if it is possible (of course).
Thank you in advance for your comments on this one.
Alejandro