How to insert/update records using SQL?

["Art Tostaine, Jr." <art@xxxxxxxxxxx>]

I have to update a table on SQL/Server from the Iseries.  I have the
connectivity issues resolved.

Using a sql statement, how do INSERT or UPDATE the records that already
exist.

In RPG, I would CHAIN, and either WRITE or UPDATE if %FOUND.  Does a similar
function exist in SQL?

What is the standard or preferred method of doing a mass update?

My SQL table is basically,

CustId
OpenAr
Open30
Open60
Open90
Open120

Thanks.

Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---