When I run a an insert statement with a large "contents" value I get an error "Could not execute statement. Server 'DirectoryServer': No such file or directory SQLCODE=-660, ODBC 3 State="HY000"
Anybody know why I'm erroring out? This happens when "contents" value is over 3000.
asked 11 Sep '12, 19:01
Does it work when you assign the file contents to a LONG VARBINARY variable and then use that variable within the insert, such as:
begin declare myBlob long varbinary; set myBlob = 0x5768656E20492072756E206120616E20696E736<skipped>206572; Insert into DBA.Attachments(Contents, File_Name) values (myBlob, 'test.txt'); end;
answered 12 Sep '12, 10:43