host structure arrays - SQL insert

[George221]

Hi,
Would anyone have an RPGLE example of gettting records loaded into a host data structure, then used in a SQL insert statement?

 

[Mercury2]

d W_MyFile      e ds                  extname(MyFile)
d                                     prefix(W_) 

/free
  // Read MyFile into data structure W_MyFile
  Read MyRec MyFile;
  ... 
  // Fld1, Fld2, etc belong to file MyFile
  Exec sql insert into MyNewFile (  Fld1, Fld2, ... )                                            
                    values( :W_Fld1, :W_Fld2, ... );

The semicolon is mandatory to insert a variable into an sql stm.

hth

 

[George221]

Is this structure an array? I do not want to do single row inserts.
I'm also not sure how to deal with loading the array.