Re: Fw: File in CL Program

["Mike Silvers" <msilvers@xxxxxxxxxxx>]

This code does not allow you to update a file using CL, it uses RPGLE
programs to do the file manipulation.  You still can not update a file in CL
only.


----- Original Message -----
From: Jodi Walker <Jodi_Walker@ccmail.columbia.com>
To: <RPG400-L@midrange.com>
Sent: Tuesday, August 29, 2000 11:48 AM
Subject: Re: Fw: File in CL Program


>      Actually, yes it is possible to update a db file in a CL.  In fact,
>      you can do more than update - IF you have a little help.  Read the
>      article at
>
http://www.as400network.com/artarchive/index.cfm?fuseaction=viewarticl
>      e&CO_ContentID=7217
>
>      then download & install the code.  I couldn't resist trying it & it
>      works like a champ.
>      If the link doesn't work, just search the AS400 network site for the
>      article called 'CL flexes its database muscles' by Peter Clifford.
>
>      Things you can do with these db i/o commands in CL:
>      Open a db file
>      Close a db file
>      Read a record from a db file
>      Position the file cursor in a db file
>      Update a record in a db file
>      Write a record to a database file
>      Delete a record from a database file
>      Release a locked record
>      Retrieve the value of a named field from a record format
>      Change the value of a named field in a record format
>
>         jw
>
> ______________________________ Reply Separator
_________________________________
> Subject: Fw: File in CL Program
> Author:  Nancy Savino <newnancy@juno.com> at Internet
> Date:    08/29/2000 7:47 AM
>
>
>
>
> --------- Forwarded message ----------
> From: Nancy Savino <newnancy@juno.com>
> To: RPG400-L@midrange.com
> Date: Fri, 25 Aug 2000 11:18:56 -0400
> Subject: File in CL Program
> Message-ID: <20000825.112007.-159601.0.newnancy@juno.com>
>
> I recently went on an interview. (By the way, I am the one who has been
> looking for a job for over a year and has not found one yet). He asked me

> about files in CL programs. I told him that there can only be one, that I
> have read database files in a CL program in a loop, etc. Can you update a
> database file in a CL program? I told him that I never had done that.
>
> Sincerely, Nancy
>
> ________________________________________________________________
> YOU'RE PAYING TOO MUCH FOR THE INTERNET!
> Juno now offers FREE Internet Access!
> Try it today - there's no risk!  For your FREE software, visit:
> http://dl.www.juno.com/get/tagj.
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

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