Re: LVLCHK *NO

["Peter Dow" <pcdow@xxxxxxxxx>]

> Okay, so the gist of this is, it would take too much time and processor
power
> to dynamically link the files, and you think we want the extra check at
run time.

> The main advantage to static linking is the system can open the programs
faster,
> and the program won't run if it fails the level check.  Although I think
that the way
> RPG shotguns memory locations for files may come into play also.
>
> Has anyone ever did a test on the added time and processor needed to be
able
> to link database files dynamically on the AS/400?

I've seen several postings in this list nudging us towards using SQL in our
RPG programs, and none of them complain about time and processing power. How
much does it take to process a dynamic SELECT statement? Also, how many of
us use some file utility such as DBU, VIEW or even the lowly UPDDTA? All of
these obtain the field list for the file and format it for us, and while it
may take a second or two longer, I for one am not complaining. And how much
time are we talking about anyway? Minutes? Seconds? Subseconds? If we're
talking about a program that prints a report from thousands or millions of
records, what is that percentage-wise?

OTOH, there's the consideration of what this would do to RPG. I haven't used
SQL with RPG yet, so I'm not familiar with how variables are defined, but
since the manual talks about a pre-compiler it's probably done from the
external definition. If RPG were modified to dynamically link files, would
the definition happen at compile-time or run-time? If it happens at
run-time, things could get really interesting (does EVAL A = B + C mean add
two numbers or concatenate two strings? would this be determined at
run-time?)  If it happens at compile-time, that means some more checking at
file open time to determine if the fields not only have the same name, but
the same type and precision.

Maybe some of you people that use SQL with RPG could give us some hints on
what it would be like to have dynamically linked files built into RPG.


>
> | 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
> +---


__________________________________________________
Do You Yahoo!?
Bid and sell for free at http://auctions.yahoo.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
+---