DOS Blobs at red!
Posted in 1992
Topics: Storage & Space Management, Connectivity: ESQL/C, 4GL & Embedded SQL, Data Types & Schema Design, Networking & sqlhosts Configuration
Few weeks ago I mailed the following, > Look at this scenario: > > A TCP/IP Network. > > One Unix Database Server (Online, Informix-Net, TCP/IP) > > A lot of PC-DOS Workstations, running an ESQL/C app.. (INET- > PC, PC/TCP). This ESQL/C program provides a working > environment to chronicle-writers, BUT without built-in word > processor. The WP is started from within our program. > The program makes updates and querys to the remote (Unix- > based) database. Remind: PC-DOS Workstations!! > > We need: a)To access resources provided by the ON-LINE DB > engine, *FROM* this program built under PC-DOS. > This implies how to get access to special > data types (var-length, DateTime, etc.). > > b)To pass BLOBS from the DB Server to a > workstation, modify them with DOS-based tools and > thus restore them to the Database (PC-net-Unix). > etc...... It happens that nobody has replied to these questions, but I have an idea I want to submit to this forum. 1.The Blobs we access are referenced in the corresponding column of the table, but sepparately stored. When we access a blob, I suppose, a)On-Line looks into the Blobspace for the Blob referenced in the table, extracts it and send it to the (explicitly or by default) specified blob manager (vi, etc.). b)the resultant product delivered by the blob manager is restored to the blobspace. 2.As we need to process this Blob under DOS, we can do as follows: a) The Blob manager is specified as an archiving facility, wich only copies the incoming blob onto a previously designated file, b) This file is FTPed to the PC wich will make use of the blob, c)The Blob is processed by a DOS program, and restored to the DOS file system, d) The blob file is FTPed from the PC to the DB server and e) the blob file is archived into the blobspace. 3.That's OK. I've resolved the question about how to pass the blob between Unix and DOS and vcvrs, but some doubts remain. This is: can I make use of 4.00+Online resources from a DOS ESQL/C app?. I suspect some is missing in paragraph 1.(Moreover, does someone knows if TEXT Blobs are good for WordPerfect under DOS?. It is specified that TEXT blobs only support a subset of <Ctrl>-Something.). As before, many thanks in advance. Ricardo. --- +-------------------------+----------------------------------------+ | ////////////////// | Postmaster (Ricardo GUIDO LAVALLE) | | ////////////////// | 6 Nro. 938 P. 19 Of. 3 | | O C C A M | (1900) La Plata - Argentina | | ////////////////// | T.E.: 54 021 4-8455/4-5925 | | ////////////////// +----------------------------------------+ |Ingenieria de Sistemas | postmast@occam.com.ar | +-------------------------+----------------------------------------+