× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I want to do an update in my sqlrpgle program, much like the insert I am
doing right now.
In this code below I use the data structure named FIELDOUT to write the
record when I insert.

Csr   InsertRec     begsr
C/exec sql
C+ INSERT INTO COMP_ORDER VALUES : fieldout
C/end-exec
Csr                 endsr

I know if I were in SQL I would just do
UPDATE TABLEA
SET COLUMN1 = 'SOMETHING'
WHERE KEY = THISONE

Not sure how to do it and still use my data structure, can I?
Or do I have to do something like this?
SET COLUMN1 = FIELDOUT_1
SET COLUMN2 = FIELDOUT_2
ETC. ETC.


    Dave Reiher
    System Analyst
    Prairie Farms Dairy - Corporate
    dreiher@xxxxxxxxxxxxxxxx


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.