Re: Record format level mismatch question

Depends on how the table is being used. If it is defined with DDL and you
open it with file i/o and make a change it goes boom. No difference. A table
defined with DDL is no different than a table generated with DDS. It still
has a record level identifier and it is RPG that is throwing the error.

If you open with SQL and you have selected the fields you want (Database
independent) and you have not changed any type or size, everything runs
without a problem. I

If you use SQL and do something like Select * and you change the underlying
table you are going to get errors or garbage.

On Wed, Jun 24, 2009 at 2:27 PM, Kurt Anderson <kurt.anderson@xxxxxxxxxxxxxx

wrote:

Multiple replies have been made saying that LVLCHK(*NO) is a bad idea.
However it was my understanding (based on my class with Robert Bestgen)
that SQL tables do not trigger level checks (or is LVLCHK(*NO) under the
covers), I forget the exact phrasing. These tables can of course be used by
embedded SQL or as native I/O.

How is this different?

Thanks,
Kurt Anderson
Sr. Programmer/Analyst
CustomCall Data Systems

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Wednesday, June 24, 2009 2:36 PM
To: Midrange Systems Technical Discussion
Subject: Re: Record format level mismatch question

You recompile - pure and simple - LVLCHK(*NO) is 99.99% never to be done.

Chamara Withanachchi wrote:

What is your recommendation, suppose I change my selection criteria and

add a another key and compile what will happen to my programs?

Regards,

Chamara Withanachchi
IBM Certified Power System Expert
RPG Programmer
(owner of www.rpgiv.info)

WWW.RPGIV.INFO
Mob: +971 50 5698644
Tel: +971 6 5595887
chamaraw@xxxxxxxxxx
www.rpgiv.info
i want to be future ready. i want control. i want an i.


Sent from my BlackBerry(r) wireless device

-----Original Message-----
From: Charles Wilt <charles.wilt@xxxxxxxxx>

Date: Wed, 24 Jun 2009 14:58:10
To: Midrange Systems Technical Discussion<midrange-l@xxxxxxxxxxxx>
Subject: Re: Record format level mismatch question


Level Check (*NO) is never a good idea.

I find it hard to believe anyone still would recommend it.

Charles

On Wed, Jun 24, 2009 at 2:54 PM, Chamara Withanachchi
<chamaraw@xxxxxxxxxx>wrote:

Compile the logical with "Level check" parameter and specify "*NO" to

it.

Regards,

Chamara Withanachchi
IBM Certified Power System Expert
RPG Programmer
(owner of www.rpgiv.info)

WWW.RPGIV.INFO
Mob: +971 50 5698644
Tel: +971 6 5595887
chamaraw@xxxxxxxxxx
www.rpgiv.info
i want to be future ready. i want control. i want an i.


Sent from my BlackBerry(r) wireless device

-----Original Message-----
From: "James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>

Date: Wed, 24 Jun 2009 11:39:49
To: Midrange Systems Technical Discussion<midrange-l@xxxxxxxxxxxx>
Subject: Record format level mismatch question


Suppose I have a uniquely-keyed logical with a SELECT. Case in point, a
logical, uniquely keyed on customer number, limited to records of type
"customer."

Suppose I modify this logical so that it is limited to records of type
"customer" in which the customer number field is nonblank.

Would this change cause a level-check error when an existing program
tries to open the logical?

--
JHHL
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.