Re: Getting all data for a specific column from a file

If I understand correctly, the following procedure will populate the driver file [driver_dta] with the desired data from the attributes file [attributes] and items file [items_file]. Of course the Attribute_Data column of the driver file will have to be declared as a VARCHAR capable of accepting the various data types and lengths of the different columns\data from the items file:

create procedure driver_ins
language sql
begin
for Rqs as DriverIns cursor for
select 'insert into driver_dta' concat
' select item, ''' concat attribute_name concat ''', '
concat attribute_name concat
' from items_file' as InsStmt
from attributes
do
/* call rexsay(Rqs.InsStmt) ; -- @dbg */
execute immediate Rqs.InsStmt ;
end for;
end

Regards, Chuck

On 07 Jun 2012 10:24, Jeff Young wrote:

The file of attributes has the following:
*Attribute Name*
commonname
ponumber
batchnumber
productiondate
receptiondate
storeno
netweight
.
.
.

The file of items has
Item CommonName PoNumber etc....
1234 Test Item 123456 ...
5645 Another Item 143556 ...

What I want to do is for the attribute named "commonname", get all
items and the data for the CommonName field.
Then repeat for each attribute in my driver file using the data from
the corresponding field.

I will be creating new records in my driver file for each
item/attribute pair.

On Thu, Jun 7, 2012 at 11:09 AM, Jeff Young<jyoung0950@xxxxxxxxx> wrote:

<<SNIP>>

My driver file has the following fields:
Item
Attribute Name
Attribute Data

For each attribute name, I want to get just the item and data from
the corresponding column for all records from the input file.