Xref: utzoo comp.databases:8472 comp.lang.c:35296
Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sun-barr!apple!usc!sdd.hp.com!zaphod.mps.ohio-state.edu!ub!csn!uswat!pditallo
From: pditallo@uswat.uswest.com (Paula Ditallo)
Newsgroups: comp.databases,comp.lang.c
Subject: Embedded SQL - INGRES/6.3 - 01  Sun/4.1
Message-ID: <14386@uswat.UUCP>
Date: 14 Jan 91 23:39:38 GMT
Sender: news@uswat.UUCP
Distribution: na
Organization: US WEST Advanced Technologies, CO, USA
Lines: 40


	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"

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