RE: SQL Insert

Yes, all you have to do is change the select portion of the statement.
So if you wanted everyone's user id to read as BSMITH then you could do:

INSERT INTO RGTSYS/UELLU (EENAME,EUSRID, ECPM, ECPMC)

select EENAME, 'BSMITH', ECPM, ECPMC                    
 from uellu where eusrid = 'SMITHMI'   

or if the userid is a number and you wanted to make everyones user ID
one higher you could do:

INSERT INTO RGTSYS/UELLU (EENAME,EUSRID, ECPM, ECPMC)

select EENAME, EUSRID + 1, ECPM, ECPMC                    
 from uellu where eusrid = 'SMITHMI'   

You should be able to do anything you can do in a select statement.

Christopher

-----Original Message-----
From: midrange-l-bounces+cpayne=thecrowngrp.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+cpayne=thecrowngrp.com@xxxxxxxxxxxx] On
Behalf Of Smith, Mike
Sent: Friday, October 14, 2005 10:45 AM
To: midrange-l@xxxxxxxxxxxx
Subject: SQL Insert

I'm trying to create an SQL statement that will take records from a file
and duplicate them.  However, I want 1 field to change.  
I can get this to work 
INSERT INTO RGTSYS/UELLU (EENAME,EUSRID, ECPM, ECPMC)

select EENAME, EUSRID, ECPM, ECPMC                    
 from uellu where eusrid = 'SMITHMI'    

This copies the records as they are, however, I want to change the value
of EUSRID when I do the copy.  
I haven't been able to get this to work.  Is this possible?  
                

Michael Smith
iSeries.mySeries.