|
Hi, I think I am missing something basic, but I have been looking at archives for the past hour and can't find anything. I have an input parameter that is defined as varying. I want to move it to another field to use in an SQL insert. The field just comes up blank. D InEmp S 25A Varying D WkEmp S 25 D SvEmp S 8A C MOVE InEmp WkEmp C MOVEL WkEmp SvEmp C/EXEC SQL C+ INSERT INTO V64BPCSUSF/SVL (SVID, SVEMP, SVORD, SVOPR, SVHRS, C+ SVGQT, SVSQT) VALUES('SV', :SvEmp, :WkOrdN, :OpNo, :Hrs, :QtyG, C+ :QtyS) WITH NC C/END-EXEC What am I missing? <===================================================> Terri Harteau Felker Brothers Corporation **************** "The happiest people don't necessarily have the best of everything. They just make the best of everything!" ****************
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.