RE: delete records from a S/36 (QS36F) file?

When creating a S/36 file, you have the option of making it
delete capable.  Here's the S/36 BLDFILE command:

   BLDFILE MYFILE,I,RECORDS,10000,100,,T,1,5,NDFILE,NODUPKEY,1

If you change the "NDFILE" to a "DFILE" it becomes delete-capable,
and then you can use DEL in an O-spec to delete records.


On Thu, 13 Jun 2002, Dan Bale wrote:

> Nope.  Already had that.  As mentioned in the first post, the file in
> question does not allow deletes.
>
> I should have phrased the question better.  What I was really after was
> whether S/36 files were typically not delete-capable.  Memory seems to serve
> that one would typically use a one-character status field, change a record's
> status to 'D' or 'X' when it became "deleted", and those records were not
> included in a reorg at some future date.
>
> I was going to surmise that S/36 RPG-II did not allow a program to delete
> records from a file, but then RPG-II has always had the DEL option on the
> O-spec, hasn't it?
>
> P.S.  I solved the problem by just putting the delete status on the records
> I was trying to delete, so they'll be purged at the end of the month.
>
> Thanks!
>
> Dan Bale
> SAMSA, Inc.
> 989-790-0507
> DBale@SAMSA.com <mailto:DBale@SAMSA.com>
>   Stanley Cup Finals lower bowl tickets at Joe Louis Arena: $500
>   Official Red Wings jersey: $150
>   Octopii to drop splat in front of Irbe: $22 each
>   Darren McCarty - YES, DARREN MCCARTY - scoring three goals on three shots
> vs. Patrick Roy: PRICELESS! ABSOLUTELY PRICELESS!
>
>
> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
> Behalf Of Richard B Baird
> Sent: Thursday, June 13, 2002 10:08 AM
> To: rpg400-l@midrange.com
> Subject: Re: delete records from a S/36 (QS36F) file?
>
>
>
> What about this?
>
> C            except     delrecord
>
> ....
>
> Ofilename   EDEL               delrecord
>
> ---original message------
> Wracking my brains, trying to figure out how to delete records from a
> program-described file.  Finally determined that the S/36-type file does
> not allow deletes.  Is this typical for QS36F files?
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>