[comp.lang.c] Embedded SQL - INGRES/6.3 - 01 Sun/4.1

pditallo@uswat.uswest.com (Paula Ditallo) (01/15/91)

	Hello C Pros....

	....I've gotten myself into a fine kettle of fish....
	...and thought someone out there may have the answer...


	I am trying to do row processing through embedded SQL...from the
	first row in the table through the last....and while each row
        is being processed...i need to parse 2 strings on the fly
        based on the character length of the original strings....
        ..which are actually
        the returned  values from 2 columns --  i then need to concatenate
        these 2 strings with a third string (which will always be the
        same) and insert the result string into another table.

           ...so far i've created 2 function calls - 1 to handle the
             integer values of the string lengths and the other to
             handle concatenating the final string.

        ...but i have no idea how to incorporate what i need to do in C
       into the middle of an SQL loop.......any ideas???


			   - Thanks

			   /*paula*/


 BTW, the db i'm working with is Ingres-- version 6.3/01 for a Sun Server/4.1C

*********************************************************
Paula L. DiTallo             Delta Research & Development
11994 Bear Park Rd.          999 18th Street, Suite #1000
Conifer, CO 80433            Denver, CO  80202
303-838-4889		     303-291-9525
"76176.1634@compuserv.com"   "pditallo@uswest.com"

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