Re: BIG Query Question

SQL is in there somewhere, we get "level checks" and perhaps level check
is the wrong term. Haven't had a halt lately to see the msg..
jim franz

To: <midrange-l@xxxxxxxxxxxx>
Sent: Monday, June 12, 2006 4:51 PM
Subject: RE: BIG Query Question

Chuck,

I did an experiment recently, and suprisingly (because I thought that it

used to do level check checking) dropping or adding an unused field did not

seem to matter.  Apparently is uses SQL (and the corresponding leniencies)
under the covers.

-mark

Original Message:
-----------------
From: Chuck Lewis chuck.lewis@xxxxxxxxxxxxx
Date: Mon, 12 Jun 2006 16:33:22 -0400
To: midrange-l@xxxxxxxxxxxx
Subject: RE: BIG Query Question


Mark,

Hmmm. So even if the file has been recompiled ? They usually add field to
the end of a file...

Thanks,

Chuck

-----Original Message-----
From: midrange-l-bounces+chuck.lewis=leesupply.net@xxxxxxxxxxxx

[mailto:midrange-l-bounces+chuck.lewis=leesupply.net@xxxxxxxxxxxx] On Behalf

Of mlazarus@xxxxxxxxxxxxx
Sent: Monday, June 12, 2006 1:24 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: BIG Query Question

Chuck,

If the fields used in the query have not changed, or been removed, you
should not receive a level check.

-mark

Original Message:
-----------------
From: Chuck Lewis chuck.lewis@xxxxxxxxxxxxx
Date: Mon, 12 Jun 2006 13:16:04 -0400
To: midrange-l@xxxxxxxxxxxx
Subject: RE: BIG Query Question


Bryan,

The problem we are going to have is a level checking problem not an actual
name change.

Thanks,

Chuck

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bryan Dietz
Sent: Monday, June 12, 2006 12:19 PM
To: Midrange Systems Technical Discussion
Subject: Re: BIG Query Question

If the queries will bomb because of a file name change, how about creating
a logical with the old name and create it over the new file name.


_____________________________
Bryan


--------------------------------------------------------------------
mail2web - Check your email from the web at
http://mail2web.com/ .



--

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.