| 
 | 
Check your job log for SQL error messages.  I suspect there is something
wrong with the SQL statement or it's encountering an error when executed. 
Hope that helps. 
Donald R. Fisher, III
Project Manager
Roomstore Furniture Company
(804) 784-7600 extension 2124
DFisher@xxxxxxxxxxxxx
<clip>
I am trying to execute this simple update statement. The program compiles
and it runs and gives the dsply message but the file is not updated. Am I 
doing something wrong here? I would really appreciate it if somebody can
point me in the right direction.
<clip>
     C/EXEC SQL
     C+ UPDATE TESTING/CUST SET CUSSTA = 'TX'
     C+ WHERE CUSSTA = 'TN'
     C/END-EXEC
      /FREE
       *inlr = *on;
       EndSR;
<clip>
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.