Re: New Opcodes - %SETCELL

[John P Carr <jpcarr@xxxxxxxxxxxx>]

        >> I know it's not realy the way you want to do it, but just a
thought.

        Right,  It's not what I want.   There's a lot of ways to fudge it.  
        I want the RPGIV language to actively participate in the IFS 
        world directly.   Every new product (Application) that is comming
        to the AS/400 will be in the IFS.   RPGIV needs to address that
        fact.   

        In VA/RPG we have DDE direct link to active spread sheets.
        I would like some "Native"  ability to update a Stream File
        in the IFS.    I can personally get along with out having 
        yet another native DB2/400 chain opcode

        What I would like is "New" built-in  functions like
        %GETCELL  and %SETCELL etc.   

        What "New" and exotic functions would you all like??

        John Carr




        From:   Bob Larkin@blarkin on 09/06/99 11:09 AM
        To:     RPG400-L@RPG400-L@midrange.com@SMTP@EXCHCONNECT
        cc:      

        Subject:        Re: New Opcodes - %SETCELL

        John,
        It is easy, and it already exists. Sort Of. Have Excell access the
data via ODBC
        in a Database in the QSYS file system! Then you can modify the
columns as we
        always have. I know it's not realy the way you want to do it, but
just a thought.

        Bob
        John P Carr wrote:

        > Hey Hans & Barb.
        >
        > How about some useful built-ins for things we can't do today?
        >
        > Like  being able to  update an Excel spread sheet's cells?
        >
        > If I have a .XLS Excel spread sheet on the IFS,   I would like to
        > be able to read/update cells in it.     I was reading how easy it
        > is to this in Lotus Script.    How about helping us with API's in
        > conjunction with new built-in functions where I could read
        > (say)  Column A of a spread sheet(maybe Part Number),
        > and Update  Column C (maybe on-hand quantity).??
        >
        > Maybe a %GETCELL and %SETCELL ??
        >
        > We need some NEW functionality in addition to
        > giving us numerous new ways of being able to
        > do things we could already do.
        >
        > IFS Stream File affinity for example.
        >
        > Lotus Notes .NSF file support would be
        > right up there also.  Reading/Updating it?
        >
        > It should be easy with the CF's in place Right?
        >
        > Just dreaming I guess.
        >
        > John Carr
        >
        >
        > +---
        > | 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
+---