Re: Pass SQL results to array

In article <35C9CE81.7811@bloomberg.net>, kagel@bloomberg.net wrote: > Edward Villalovoz wrote: > > > > Hi, > > Can anyone show me how to pass my sql results to an array in perl > > instead of UNLOADing them to a flat file, and then LOAD the array results > > into another informix table? Thanks in advance. > > If your ultimate goal is to load the results of the SELECT into another > table without massaging the data in Perl then try this SQL: > > insert into ANOTHER_TABLE(ama_cfc_at) > SELECT ama_cfc > FROM tblamah > GROUP BY .....> > You get the picture. Of course if you need to modify the result, this > will not work. > > Art S. Kagel > Actually, I will be doing some massaging of the data before I insert it to another informix table. :-) -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum