Sql insert multiple records

  An SQL probIem, I want add records from fileB into fileA where they don?t 
already exist in fileA. But I gather the Insert command is a bit funny about 
inserting more that 1 row? There are only 2 fields, I want to add the product 
code which will be obtained from fileB and the 2nd field is just some fixed 
text ("DISC")
   
  My current script is?
  INSERT INTO CRLIB/fileA
  values((select code from CRLIB/fileB
  exception join 
  CRLIB/fileA on code=acode),'DISC') 
   
  Any help would be appreciated.
  On another matter, I don?t suppose anyone knows if it is possible to convert 
AS400 query definitions into their equivalent SQL commands (a bit of a long 
shot I think?!)
  Many thanks,
  Colin.

                
---------------------------------
 What kind of emailer are you? Find out today - get a free analysis of your 
email personality. Take the quiz at the Yahoo! Mail Championship.