RE: insert into a member from vb

SQL does not know about members, so it always inserts into *FIRST member.
IBM has provided a workaround via CREATE ALIAS statement, whereby you create
an alias for the particular member you're interested in, and then you insert
into that alias.

CREATE ALIAS QTEMP/MYALIAS FOR library/myfile (mbrIwant)

INSERT INTO QTEMP/MYALIAS (fieldnames)

Elvis

-----Original Message-----
 Subject: insert into a member from vb

Hi all,

   Does any one know the syntax to insert into a member on the as400
from VB  The statement works until the member name is added to the
syntax

Currently trying:        insert into library.myfile(member) (fieldnames)
(fieldvalues)      it is erroring thinking the (member) is the beginning
of the fieldnames

We also tried:         insert into  library.myfile.member  (fieldname)
(fieldvalues)    but then it thought the library name was our system
name 

Thanks in advance!

Angela Wawrzaszek