This is what I have been doing :-) Trying to learn more SQL.
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Wednesday, December 05, 2012 2:33 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Another SQL Question
Did you mean withOUT naming all of the fields?
Sure you can!
Will this work?
CPYF FROMFILE(*LIBL/myFile) TOFILE(QTEMP/myFile) FROMRCD(1)
Runsql 'UPDATE qtemp/myfile set company# = ''2'''
CPYF FROMFILE(QTEMP/myFile) TOFILE(*LIBL/myFile) FROMRCD(1) MBROPT(*add)
Should do the trick.
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact