[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Text Variable Overflow?



Good evening!

I'm working on a small SQR to load an image into a DB2 table, using a sample
program as a template (thoughtfully 'donated' by Ray O. - Thanks!)

I've run into a small snag though.  According to everything I've read, text
variables ($image_data) can have any length, depending on system memory.  My
program dies when the length of my $image_data variable tries to exceed
32767 characters.  Here is the error message from my log file:

   (SQR 4749) An attempt was made to move 32768 characters into
'$image_data'.
The maximum allowed is 32767 characters.

I'm at a loss as to what the problem is!  Any ideas?  Thanks in advance for
any and all help!!

--
William Beckner -- Stunt Programmer (Just call me "Bill")
Illinois Central College, Rm L141 -- East Peoria, IL  61635-0001
PH: (309) 694-8419 -- FAX: (309) 694-8995
"Everything is unimportant in some way."