PRO*COBOL Large Objects (LOBs) EXAMPLES 5/15/00 
/rdbms/demo/lobs/pro examples

Note:
These lob examples are available in /rdbms/demo/lobs for the first time in 
Oracle8i release 3 (8.1.7). 
The example scripts, are taken from the "Oracle8i Application Developer's Guide - 
Large Objects (LOBs)" release 2 (8.1.6). The majority of these examples 
are based on the multimedia_tab schema. The set up and clean up scripts for 
these examples are described in the manual at the beginning of chapters 9,10,
and 11, and can also be found here in the file:
On UNIX:/rdbms/demo/adlsetup.sql
On NT: $HOME\demo\adlsetup.sql


DOC REF		DEMO NAME	DESCRIPTION

Pro*COBOL Internal Persistant LOBs Examples from Chapter 9
* For the "DEMO NAME", the Internal Persistant LOBs examples have a prefix = i

adlb001i	iinsert		inserting a row by initializing lob locator bind variable
adlb002i	iload		loading lob with data from bfile
adlb003i	iifopen		seeing if lob is open
adlb004i	ichkout		checking out a lob
adlb005i	ichkin		checking in a lob
adlb006i	idisplay	displaying lob data
adlb007i	iread		reading data from lob
adlb008i	ireadprt	reading portion of a lob (substr)
adlb009i	icompare	comparing all or part of two lobs
adlb010i	ipattern 	seeing if pattern exists in the lob (instr)
adlb011i	ilength		getting the length of a lob
adlb012i	icopy		copying all or part of a lob to another lob
adlb013i	icopyloc	copying a lob locator
adlb014i	iappend		appending one lob to another
adlb015i	iwriteap	writing to the end of a lob (write append)
adlb016i	iwrite		writing data to a lob
adlb017i	itrim		trimming lob data
adlb018i	ierase		erasing part of a lob
adlb019i	iflush		flushing buffer
adlb020i	iupdate		updating by initializing a lob locator bind variable
adlb059i	idisable	disabling buffering
adlb060i	ibuffer		enabling buffering

Pro*COBOL Temporary LOBs Examples from Chapter 10
* For the "DEMO NAME", the Temporary LOBs examples have a prefix = t
	
adlb021t	tcreate		creating a temporary lob
adlb022t	tiftemp		seeing if lob is temporary
adlb023t	tfree		freeing a temporary lob
adlb028t	tload 		loading temp lob with data from bfile (Note: The
				example shown in the 8.1.6 manual is incorrect.
				The "load" example in rdbms/demo/lobs/procobol is correct.
adlb024t	tifopen		seeing if temporary lob is open
adlb025t	tdisplay	display the temporary lob data
adlb026t	tread		reading data from a temporary lob
adlb027t	treadprt	reading portion of a temporary lob (subsr)
adlb029t	tcompare	comparing all or part of two (temporary) lobs
adlb030t	tpattern	seeing if a pattern exists in a temporary lob (instr)
adlb031t	tlength		getting length of a temporary lob
adlb032t	tcopy 		copying all or part of one (temporary) lob to another
adlb033t	tcopyloc	copying a lob locator for a temporary lob
adlb034t	tappend		appending one (temporary) lob to another
adlb035t	twriteap	writing to the end of a temporary lob (write append)
adlb036t	twrite		writing data to a temporary lob
adlb037t	ttrim		trimming temporary lob data
adlb038t	terase		erasing part of a temporary lob
adlb039t	tbuffer		enabling lob buffering for a temporary lob
adlb040t	tflush		flushing buffer tor a temporary lob
adlb041t	tdisable	disabling lob buffering for a temporary lob

Pro*COBOL External LOBs (Bfiles) Examples from Chapter 11
* For the "DEMO NAME", the External LOBs (bfile) examples have a prefix = f

adlb042f	finsertn 	inserting a row by means of BFILENAME()
adlb043f	finsert		inserting a row containing a bfile by initializing a bfile locator
adlb044f	fload		loading lob with bfile data
adlb045f	fopen		opening a bfile with open
adlb046f	fisopen		seeing if bfile is open with ISOPEN
adlb047f	fdisplay	displaying bfile data
adlb048f	fread		reading data from a bfile
adlb049f	freadprt	reading a portion of bfile data (substr)
adlb050f	fcompare	comparing all or parts of two bfiles
adlb051f	fpattern 	seeing if a pattern exists (instr) in the bfile
adlb052f	fexists		seeing if the bfile exists
adlb053f	flength		getting length of a bfile
adlb054f	fcopy		copying lob locator for a bfile
adlb055f	fgetdir		getting directory alias and filename
adlb056f	fupdate		updating a bfile by initializing a bfile locator
adlb057f	fclose		closing a bfile with CLOSE
adlb058f	fcloseal	closing all open bfiles

*****************
