Re: ILE RPG suggestions

I love this DS implementation for External defined file formats.   Could use it
right now.

Talking of SQL in RPG.  Can this be better implemented?.  For example currently
you have to use  all those SQLDA and Fetch and those incredible difficulty in
parsing for dynamic SQL.   The CRTSQLRPGI compiler is extremely non descriptive
on errors and trying to do debug is another problem altogether.  For example,
one field in the fetch ds not agreeing with the select can cause severe
headaches on a debug.  I am sure others have similar issues with SQL
implementation within RPG.

Another suggestion, can library name be allowed in the EXTNAME keyword?

Also, data area objects should have the ability of dynamic assignments.
Currently, you have to explicitly specify the data area name in factor2.   The
DEFINE  should accept  a field name in the traditional 20 character
implementation used in API's.

John Carr wrote:

> Speaking of reading into a D/S with a subset of fields; .........
>
> I want to have a D/S   with (say)  5 fields from the file,   and then do a
> SQL  FETCH
> and have the FETCH be smart enough to map FIELD NAME TO FIELD NAME !!!!
> (from file fields  to D/S  fields with same name)
> Is that so freaking hard ?????
>
> I just want to do a fetch into a host D/S without having to specify each
> field on the fetch verb.
> Oh Well,    Maybe we will get some MULTI-PASS compiler improvements.
>

--
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *