RE: Sql insert multiple records

["Jonathan Mason \(Tiscali\)" <jonathan.mason@xxxxxxxxxxxxx>]

Hi Colin

> > 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.!)

I haven't tried it on "complicated" queries, but you can use the RTVQMQRY
command to get back the QMQRY definition of a Query/400 query.  The QMQRY
definition does contain the SQL commands for the query which you can cut and
paste quite happily.  For example:

H QM4 05 Q 01 E V W E R 01 03 07/16/02 11:41                      
V 1001 050                                                        
V 5001 004 *HEX                                                   
SELECT                                                            
  ALL       XROBNM, XROBLB, XROBTP, XROBTX, XRRFOB, XRRFLB, XRRFTP
  FROM      A10UTLLIB/AUKP225A T01                                
  WHERE     XRRFOB NOT LIKE 'Q%'                                  
  ORDER BY  XROBNM ASC, XRRFTP ASC, XRRFOB ASC                    

You will need to specify ALWQRYDFN(*YES) on the RTVQMQRY command to pull
back the definition from the Query/400 object.

Hope it helps

All the best

Jonathan
                
---------------------------------
 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.