Re: Are level checks still useful?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Mark, et al.

The specific context was to find a way easily to use SETLL to test 
existence, and not have to be concerned if more columns were added.

The OP was given several alternatives, including some SQL techniques - 
he wants to go SQL for almost everything.

This technique for the OP makes several assumptions - fixed key length, 
no change in those particular key columns, etc.

Since it is ALL that the OP intends to do with this, it seemed not so 
bad an idea.

There is an explicit statement in the programmer's guide chapter 15 that 
no level checking is done for program-described files. Only for 
externally-described ones. That is obvious, once I got to thinking about it.

Again, this was a VERY narrow context. All manner of dangers of not 
using level checks were presented to the OP.

Vern

On 11/7/2012 12:39 PM, Mark S Waterbury wrote:
> Nathan:
>
> Technically, this is a "program described" file, not an "externally
> described" file -- so I don't think the RPG compiler generates the code
> to initialize the UFCB in such a way that the "level check" will be
> performed (at open time).
>
> As far as I am concerned, this "technique" is equivalent to telling
> someone to "Close your eyes and step on the gas!" while driving a
> car...  :-o
>
> IMHO, you are just handing a loaded gun to some "programmers" so they
> can shoot off some of their own toes!
>
> Good luck with that ...
>
> Mark
>
>   > On 11/7/2012 1:15 PM, Nathan Andelin wrote:
> > > PHP/MYSQL people scratch there head (more like point fingers at
> > > me and snicker) when we struggle with level check.
> > There was a tip on Linkedin last night for people who are struggling with file level checks. It seemed to be worth considering, so I wrote a small program to test the idea. This is a program that performs setll, read, write, update, and delete operations against a table:
> >
> > http://www.radile.com/rdweb/temp/rla110.txt
> >
> >
> > With this structure, no file level checks are reported at runtime even though the file is defined with LVLCHK(*YES), new fields have been added, using alter table, the program was NOT recompiled, and it seems to run flawlessly.
> >
> > Thoughts?
> >
> > Record layouts and key layouts are externally defined, too. Nice!
> >
> > -Nathan