Skip to main content

Problem:

This Demo reads in the binary data of a .jpg and then writes it to a database 8KB at a time.  The .jpg is stored in the database as an Image field.  It then reads this Image field 8KB at a time into a memory buffer and then writes it to a file on disk and then opens the file.

Resolution:

INTRODUCTION

==========

This Demo reads in the binary data of a .jpg and then writes it to a database 8KB at a time.  The .jpg is stored in the database as an Image field.  It then reads this Image field 8KB at a time into a memory buffer and then writes it to a file on disk and then opens the file.

SOURCE FILES:

=========

Program Files           Description

--------------------     -----------------------------------------------------------

BlobDemo.cbl

Copy Files:

--------------------     -----------------------------------------------------------

SQLCA.CPY             Located in your Net Express\\base\\source directory

WINDOWS.CPY       Located in your Net Express\\base\\source directory

REQUIREMENTS:

==========

This demo works with SQL Server.  Create an ODBC data source with the name BlobDB.  Add the stored procedues to the database.

OPERATION:

========

After you have set up the ODBC DSN and added the stroed procedurs to the database, run the program.  It will create a table in the database and then write the binary data from the .jpg to the table.  It will then read this binary data from the table  into a memory buffer and write it to disk as a new .jpg file.  It will then open this new .jpg file.

REFERENCES:

========

NOTE:

====

==========================================================

Keywords: demonstration, sample, example, demo, printraw.zip

demo.ex

demo.me

demo.ne

demo.se

Attachments:

BlobDemo.zip

Attachments

Old KB# 4048