Re: SQL Insert summary data from a file plus "other" data

Mary,

I don't know a strictly SQL solution (there may be one), but if this is run from a CL, you could use the RTVJOBA USER(&DEVDOD). From within an RPG IV program, the current user is in positions 358 - 367 pf the PSDS (Program Status Data Structure).


* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
615.995.7024
fax
615.995.1201
email
jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Kern, Mary T wrote:

I want to summarize data in a file insert it into another file and also attach a user's name to that record. Something like this:
INSERT INTO library.myfile (DEVGFT, DEVPLG, DEVPG, DEVTOTC, DEVDOD) (SELECT SUM(TOTAMT), SUM(PLBALD), SUM(PGEAMT), COUNT(TOTAMT) FROM library.MMRGDB201) The DEVDOD field is my problem. The name doesn't exist anywhere to grab. I simply want to insert "Kern " into that field. How?

Thanks! Mary
¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«
Mary Kern
Director of Information Services
University of Toledo Foundation
2801 W Bancroft St Mail Stop 319, Toledo, OH 43606
Voice: (419) 530-5611 (800) 640-0147 Fax: 419-530-2895
Email: Mary.kern4@xxxxxxxxxxx
"Three things in human life are important. The first is to be kind.
The second is to be kind. The third is to be kind. -- Henry James
¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«¤»§«¤»¥«