Re: Native files in the 36 Environment

Sam,

  The main problem you need to address is adding records to the file through
your multi-format logical file.  Since the 36RPG program cannot tell DB2 which
format it is writing you will need to write a Format Selector Program and assign
it to the Logical file.  When a 36RPG program writes a record control will pass
to the FSP. It recieves the file buffer, examines it to determine the correct
format name and returns it to the database.  No changes are needed in the 36RPG
programs.  One word of caution: You must handle the condition where it cannot be
determined from the buffer which format is being written.  You must either 'pick
one' (can you say 'bad data') or abnormally terminate the FSP.  If you do not
return a valid format name the FSP will be called repeatedly forever. (guess how
I know.)

 - Larry

Sam wrote:
> 
> Greetings All,
> Has anyone had experience running RPG II and OCL with native files.   I
> have a client who wants to convert their enitre database to native to
> make it easier to convert their homegrown RPG II into native code.  I
> have not had a problem in the past with single format files but they
> have a number of mult rec types.  I've converted one and ran it on a
> program and it seems to work fine.  I used the original flat file name
> as my logical joining the 2 formats.  I'm wondering if there is any
> situation where an RPG II program or an OCL program would have trouble
> picking the correct format.  Any help would be appreciated.
> 
> TIA
> Sam
> 
> +---
> | 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
> +---

-- 
Larry Bolhuis         |
Arbor Solutions, Inc  | Two rules to success in life:
(616) 451-2500        | 1. Never tell people everything you know.
lbolhui@ibm.net       |
+---
| 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
+---