Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Rudy Fernandes — — source: Informix-list mailing list archive (1991-1998)
You could design your 4gl program to load your flat file
into a temporary table and work with that.
In article <5kt9qp$kh3@cronkite.ocis.temple.edu>,
david@temss2.main.temple.edu (David Tucker) wrote:
>Currently, I am trying to do a "batch" update of exising records
>within a table. For example if my table contains the following
>records:
> KEY | FIELD 1
> 1 | NO
> 2 | NO
> | | NO
> | | NO
> 100 | NO
>
>
>I would like to read in a flat file consisting of KEY and FIELD 1
>to update FIELD 1 from NO to YES.
>
>i.e.
> 1|YES
> 2|YES
> 3|YES
> |
> |
> etc.
>
>Is there a utility that allows you to update? I believe that LOAD
>only adds to the table. I just want to update specific fields in
>existing records.
>
>Thank you in advance.
----------------------
Rudy Fernandes
GIC, Kuwait
OL 7.20, 4Gl 6.04
----------------------
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.