HDTenEightyP/NetNews huggingface dataset:
From: ark@DB.STANFORD.EDU (Arthur Keller)
Newsgroups: bit.listserv.sqlinfo
Subject: Re: IN predicate
Date: 7 Nov 92 02:41:51 GMT
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU

John F. Griffin writes:
 Please note that in the subquery, I coded it as y.filed2 = x.field2.  The
 order is CRITICAL.  If it is coded in the reverse order (x.field2 = y.field2)
 then it will not perform as well.  This is a common problem, since the
 intuitive way to write the statement is not the best way.  (I have written
 this type of query, given it to people to implement, and had them change the
 order to make it read better, but then it performs much worse.)  The reason
 you need to have the order correct, is because for the predicate to be
 sargable, it must be of the form <column> <operator> <column or value>.
 When the subquery is evaluated, the current value of x.field2 is used as a
 value.  If you code it in the wrong order (x.field2 = y.field2) then it is
 of the form <value> <operator> <column>, which is non-sargable, and
 non-indexable.

 Regards,
 John F. Griffin
 Stellar Systems Group
 306 - 1095 McKenzie Avenue
 Victoria, B.C.  Canada  V8P 2L5
 Phone:(604) 479-7722  Fax:(604) 479-6526

Arthur Keller replies:
Is this an inherent restriction of SQL (I sure hope not!) or a restriction
of the particular vendor's implementation.  Please explain why some
vendor's implementation could not reverse the order of an equality
expression or do some other equivalence transformations.

Thanks.

Arthur M. Keller
Senior Research Scientist
Stanford University
Computer Science Dept.
Stanford, CA  94305-2140 USA
ark@db.stanford.edu
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sqlinfo
Date:         Tue, 10 Nov 1992 10:06:07 -0600
From:         "Frank C. Fillmore Jr." <TFG01@IBRDVM1.BITNET>
Subject:      Arthur Keller's Observation

 Dr. Keller wanted to know if the difference in performance based on the
 order of operands in a predicate was implementation-dependent or a part
 of the relational model of data.  That is

 "a = b" and "b = a"

 must produce equivalent results based on the arithmetical principle of
 *reflexiveness*.  The relative performance of these two will depend on
 a particular vendor's optimizer, as John Griffin explained in some detail.
 I have not been able to find in my library (after an admittedly less than
 exhaustive search) whether Ted, Chris, and the gang have ever stated that
 performance - which is a physical characteristic - must also adhere to the
 principle of reflexivity.

 I would agree with Dr. Keller's implication that it would certainly be more
 ergonomic and user-friendly to NOT require end-users to understand the
 rules of sargability.  I know IBM has improved the process of parsing
 a query in progressive releases of SQL/DS (John, which version?) whereby
 the query is restated in a more efficient form before being passed to the
 optimizer.  I'm sure we will see continued work in this area from all
 vendors.

 I'm just not sure if it's one of the "rules".  Anyone else know?

 I can be reached at IBRD 202-473-9682
 -or- at The Fillmore Group, Inc. 410-465-6335
From: mereddy@walt.tmc.edu (Praveen K. Mereddy)
Newsgroups: bit.listserv.sqlinfo
Subject: Re: (no subject given)
Date: 13 Nov 92 03:34:01 GMT
Organization: Mississippi State Univ.


Hi netters Can anybody help this struggle person!!,

I am working on SQLReportWriter1.1   on SUN    

I am not able to invoke a report from the command line.  I am using the folowing command.

runrep term=srw_sun report=DIAL_STATE_PROPERTY userid=pkm1/pkm1 paraform=no TYPE='S'

My Query follows......

SELECT ITEM.ITEMID, ITEM.EQUIPID, ITEM.PROJID, ITEM.EMPID, ITEM.CONDITION
 FROM ITEM, ITEM_PROPNUMBER 
WHERE ITEM.ITEMID = ITEM_PROPNUMBER.ITEMID
AND ITEM_PROPNUMBER.PROPTYPE = '&TYPE'
ORDER BY ITEM.ITEMID 



I have created a parameter in the parameter menu as follows

 Parameter Name   | Type | Width | Default Value    | Label Input Format     
 TYPE             | CHAR |  1    |                  | Type 


I am able to create the form with above command line COMMAND but it not doing any
query.


Is my commandline command correct.??

I appreciate ur HELP.

Thanks
Praveen
.

 
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sqlinfo
Date:         Tue, 10 Nov 1992 18:48:43 -0600
From:         Darlene Sulea <DSULEA@BCSC02.BITNET>
Subject:      Re: query problem

 *** Reply to note of 11/09/92 06:32

 Please remove my name from this service.  Thanks.

 Regards,
 Darlene Sulea, Sr. Technical Analyst
 Health Planning Database                    (Phone: 356-9139)
 MoH Systems Division                        (Fax  : 387-3006)
From: IHEY400@INDYCMS.BITNET (Carol Hey)
Newsgroups: bit.listserv.sqlinfo
Subject: Re: Embedding SQL/DS command in COBOL2 (VM/XA)
Date: 10 Nov 92 18:43:46 GMT
Comments: Gated by NETNEWS@TWNMOE10
              10 Nov 1992 11:51:40 EST from <S0SRIN01@ULKYVM.LOU ISVILLE.EDU>

There are 2 files on the SQL/DS production disk which may help you with
your problem.  They are ARISCBLC MACRO (this is a sample COBOL program)
and SQLCBLC EXEC (this is an exec to precompile, compile and link-edit a
COBOL program with embedded SQL).  If these don't help, I can send you
a copy of the CLG EXEC that we use.
Comments: Gated by NETNEWS@TWNMOE10
Newsgroups: bit.listserv.sqlinfo
Date:         Tue, 10 Nov 1992 08:46:47 -0800
From:         Arthur Keller <ark@DB.STANFORD.EDU>
Subject: Re: Arthur Keller's Observation

Mr. Fillmore inquires whether the rules of SQL require that the
reflexivity be adopted by the optimizer (i.e., that "a = b" and "b = a"
produce the same code).  Such transformations are legal by the
optimizer but not required.  Since transformations are legal, rules
about sargability seem unfortunate, but it is entirely within the
vendors right to make such restrictions.  My point was that other
vendors could "do it right."  Furthermore, the user community is within
its rights to pressure the vendor to make implementation changes so as
to eliminate the restriction.

Portability of SQL code extends only to correctness, not to efficiency,
and this must be the case.

Arthur Keller
Stanford University
From: CCSYS007@CCSUVM1.BITNET (Thomas Schenk)
Newsgroups: bit.listserv.sqlinfo
Subject: Re: Can one read data in?
Date: 11 Nov 92 08:43:02 GMT
Comments: Gated by NETNEWS@TWNMOE10
              9 Nov 1992 16:05:59 -0400 from <agnew@GEMS.VCU.EDU>

Try looking for the DATALOAD keyword.  We use it to load several tables
from a CMS fixed length file by using a REXX exec to invoke dbutil which
reads a control file of SQL commands (DATALOAD is one of them).

As another beginner, I hope this helps.

Tom

CCSYS007@CCSUVM1.BITNET
schenk@falcon.ccsu.edu
From: agnew@gems.vcu.edu
Newsgroups: bit.listserv.sqlinfo
Subject: Can one read data in?
Date: 9 Nov 92 16:05:59 -0400
Organization: Medical College of Virginia

Dear Netpeople,
  I have a question about SQL.  As a rank beginner, I'm seeing how sql is
well designed, altho quite rigorously so strict to the math, and not quite
to real life, but "that's life".

  Is there no way to read a file in as input to a database?  I'm operating
under Ingres, and can't believe that the design of SQL has left that out.

  Am I missing something, fellas??

Jim

         /^^^\   \ /   Jim Agnew         | AGNEW@RUBY.VCU.EDU  (Internet)
        /      >  ||   Neurosurgery,     | AGNEW@VCUVAX        (Bitnet)
   /\_/     '   \  /   MCV-VCU           | This disc will self destruct in
 /________________>    Richmond, VA, USA | five seconds.  Good luck, Jim..."

Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.sqlinfo
Date:         Mon, 9 Nov 1992 08:28:20 CST
From:         "Kathleen Dickey" <KFD862B@SMSVMA.BITNET>
Subject:      Re: query problem

On Mon, 9 Nov 1992 09:02:55 EST Carol Hey said:
>You didn't state in your question how this query is being done?  Is it
>in a COBOL program, RXSQL, ISQL, etc.  That makes a big difference.  We
>are also on SQL/DS 3.2 and have found that the optimizer handles COBOL
>different than the others.  Page 119 of the System Database Administration
>manual has a table in it that tells when the optimizer uses indexes.  We
>have found that if we can change code (such as greater than or like) to
>'between' in a COBOL program it will use the index and will perform much
>better.  Also, if you're using COBOL, don't forget to rebind the package
>after creating a new index.

The query is being done thru QMF.  I changed the greater than to a between
and the optimizer is using the index.  Thanks for the suggestion.

Kathleen
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
From: STELLAR@BCSC02.BITNET (Stellar Systems Group)
Newsgroups: bit.listserv.sqlinfo
Subject: Re: Index Usage
Date: 5 Nov 92 23:25:25 GMT
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU


 On Thu, 5 Nov 1992 15:28:59 CST Kathleen Dickey said:

 >On Thu, 5 Nov 1992 09:34:11 GMT Anne L Zorner R27.G5/ said:
 >>SQL Support Section (SQS)         Mail ALZ@UK.AC.RL.IB
 >>===============================================================
 >>The query below needs to be supported by an index for (withdraw,soc_sec)
 >>for one table and the other table needs it on soc_sec. possibly.
 >>The problem is that we cannot see how many distinct the values there are so
 >>we
 >>cannot necessarily think like the optimiser. By the way have you specified
 >>withdraw_code as char or varchar? and how long is it?
 >>Anne
 >>SELECT NAME, A.SOC_SEC, SEX, WITHDRAW_CODE, WITHDRAW_DATE,
 >>PERMNT_STREET, PERMNT_CITY, PERMNT_STATE, PERMNT_ZIP
 >>FROM STUDENT A, ADDRESS B
 >>WHERE  WITHDRAW_CODE    > ' '
 >>AND B.SOC_SEC = A.SOC_SEC
 >>ORDER BY 1
 >>
 >>Thankyou
 >>===============================================================
 >The primary key for both tables is soc_sec.  WITHDRAW_CODE is CHAR(1).
 >I built the index (withdraw_code, soc_sec) and re-explained the query.
 >It still is using just the primary key.  I appreciate your ideas.
 >I'll be glad to try anthing else you can think of.

 I would expect that the WITHDRAW_CODE has very few values, that a large
 number of rows will qualify based on the WITHDRAW_CODE > ' ', and that the
 table is not clustered by the (WITHDRAW_CODE, SOC_SEC) index.

 If you really want to make it use the new index (which may not even be the
 right thing to do, after all, the optimizer should have a reason for not
 using the index), then here are some ideas:

 1) Reorganize the table, and make the (WITHDRAW_CODE, SOC_SEC) index the
    clustering index.  Of course, this should be done with CAUTION, since
    changing the clustering of a table to help one query, may adversely
    affect other queries.

 2) Create the new index on (WITHDRAW_CODE, SOC_SEC, WITHDRAW_DATE, SEX)
    if those are all the columns which are read from the STUDENT table
    (it's hard to tell from the query which columns belong to which table).
    This would allow it to use an Index Only Read, in which case SQL/DS
    only reads the index and not the data pages (meaning that the actual
    clustering of the data isn't important, since it doesn't read data pages).

 3) Change the ORDER BY to order on WITHDRAW_CODE, SOC_SEC.  That may not
    be possible for the way you need to report your data, but if it is an
    option to you then it could help.

 Regards,
 John F. Griffin
 Stellar Systems Group
 306 - 1095 McKenzie Avenue
 Victoria, B.C.  Canada  V8P 2L5
 Phone:(604) 479-7722  Fax:(604) 479-6526
From: KFD862B@SMSVMA.BITNET (Kathleen Dickey)
Newsgroups: bit.listserv.sqlinfo
Subject: (no subject given)
Date: 5 Nov 92 21:28:59 GMT
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
              5 Nov 1992 09:34:11 GMT from <ALZ@IBM-B.RUTHERFORD .AC.UK>

On Thu, 5 Nov 1992 09:34:11 GMT Anne L Zorner R27.G5/ said:
>SQL Support Section (SQS)         Mail ALZ@UK.AC.RL.IB
>===============================================================
>The query below needs to be supported by an index for (withdraw,soc_sec)
>for one table and the other table needs it on soc_sec. possibly.
>The problem is that we cannot see how many distinct the values there are so we
>cannot necessarily think like the optimiser. By the way have you specified
>withdraw_code as char or varchar? and how long is it?
>Anne
>SELECT NAME, A.SOC_SEC, SEX, WITHDRAW_CODE, WITHDRAW_DATE,
>PERMNT_STREET, PERMNT_CITY, PERMNT_STATE, PERMNT_ZIP
>FROM STUDENT A, ADDRESS B
>WHERE  WITHDRAW_CODE    > ' '
>AND B.SOC_SEC = A.SOC_SEC
>ORDER BY 1
>
>Thankyou
>===============================================================
The primary key for both tables is soc_sec.  WITHDRAW_CODE is CHAR(1).
I built the index (withdraw_code, soc_sec) and re-explained the query.
It still is using just the primary key.  I appreciate your ideas.
I'll be glad to try anthing else you can think of.

Thanks again
Newsgroups: bit.listserv.jes2-l
From: j-grout@uxa.cso.uiuc.edu (grout john robert)
Subject: Re: STORAGE BELOW 16M LINE
Reply-To: j-grout@uiuc.edu
Organization: University of Illinois at Urbana
Date: Thu, 5 Nov 1992 15:57:42 GMT

Richard Rodriguez <GRZ046@vm.gmd.de> writes:

>But MVS >= V2 has to have a way to do this, because it has to
>be able to allocate two contiguous pages of real storage for
>the segment table for address spaces larger than 1GB. Right?

True, but not relevant... RSM keeps a "double frame queue" of pairs of free
frames for segment tables, and will do aggressive things during page
replacement (such as moving data from one frame to another) to keep it
replenished.  However, this queue is _just_ for segment tables... there isn't
any way to GETMAIN storage from it.

My other post (on the DAT-off nucleus) describes the lesser known way MVS/XA
provides contiguous real storage for system services (the better known way is
V=R address spaces).

-- 
John R. Grout						j-grout@uiuc.edu
University of Illinois, Urbana-Champaign
Center for Supercomputing Research and Development
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Wed, 4 Nov 1992 16:07:00 PST
From:         Leonard D Woren <LDW@USCMVSA.BITNET>
Subject:      Re: STORAGE BELOW 16M LINE

This discussion now belongs on IBM-MAIN.  I suggest that if it's to
continue, someone move it there.

On Wed, 4 Nov 1992 12:19:04 CET,
   Christian.J.Reichetzeder@AWIIMC12.IMC.UNIVIE.AC.AT said:
> Anyway LRA will  return an address that  is real to your  MVS virtual machine.
> That  means that  if this  machine has  less than  16M you  will NEVER  see an
> address above  16M.

Hah!  Try doing an LRA for page 0 when you're running V=R.  You'll get
a real address which is the next frame above your virtual machine
size.  After some hair pulling, I had to code around this in one of my
programs.

> Also  if your  MVS version doesn't  support more  than 16M
> you'll also NEVER see an address above 16M.

MVS/SP V1R3 supports up to 64M real, but only 16M virtual.  LRA *will*
return addresses that don't fit in 24 bits in that case.

Anyway, with reconfigurable storage, especially running under VM, I
suspect that you will see real addresses > 16M.


/Leonard
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
From: RYERSONRA@COMPCTR.CCS.CSUS.EDU (Rob Ryerson)
Newsgroups: bit.listserv.jes2-l
Subject: MVS JES2 FIFO print class
Date: 12 Nov 92 18:38:20 GMT
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Mailer: Pegasus Mail v2.1c R5.
X-Pmrqc:  1
Comments: To: jes2-l@vtvm2.bitnet

We're sending VM printed output to MVS via RSCS, all printers are now
under MVS control. Output comes as two separate files, a custom
banner, and the output. Question - how can we guarantee FIFO treatment
of the files by JES. We've started with a unique class, assigned
solely to a printer, but I can't identify any parms to guarantee FIFO.
Rob Ryerson Cal. State Sacramento. (cross posted to IBM-MAIN)
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Thu, 12 Nov 1992 22:23:00 CST
From:         Michael Stack <A01MES1@NIU.BITNET>
Subject:      Re: JOBCARD standards enforcement

> At our shop we are considering enforcing some sort of standards
> for jobs submitted into JES2.  We want to make sure that certain
> fields in the JOBCARD are present, and if not, we want to pull
> them in.  We would like to be able to get this information from
> the userid that the job is submitted under.  ...

Let me add to Dave Ulrick's response.  During JES2 exit 6 processing,
we create the entire JOB accounting field in internal text format
(after deleting any found), effectively adding it to the job's JCL.
This way, the users have no requirement to specify the accounting
field according to some unfathomable set of rules, and (even more
important) we have no need to write code to scan said field while
accommodating every possible mistake.  We place whatever fields we
want there, and can change the format any time we want.

I like to believe that life is in a small way less stressful because
of this.

Michael Stack

Northern Illinois University            Internet: a01mes1@mvs.niu.edu
Computer Systems and Operations         Bitnet:   a01mes1@NIU
DeKalb, IL  60115-2854                  Lipnet:   (815) 753-9447
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Fri, 13 Nov 1992 06:30:00 EST
From:         Mike Alexander <ZSYSWMA@UCCCMVS.BITNET>
Subject:      re: JOBCARD Standards

With respect to Arthur Gutowski original question on 12 November 1992,
I'd like to add in a possible extension to Dave Ulrick's response on
Exit 6.

I feel it is also the best way to go in part because it is already under
a subtask environment and it is actually easier to scan internal text
than it is to parse the text under Exit 3.

The extension I'd like to mention lies in creating a rules table in CSA
during JES2 initialization (using Exit 24) containing any information
needed for a job (or just a set of defaults). In this way, the table may
be maintained by a batch job and, even under a subtask environment, the
performance would be improved since there would be no need to invoke the
overhead of issuing a call to ACF2 (or RACF). If an entry was not found
in your incore table, then the call could be issued if need be.

Mike Alexander

ZSYSWMA@UCCCMVS
University of Cincinnati
Technical Systems Support
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Mon, 9 Nov 1992 13:06:24 SST
From:         Chang Koon Wang <CCECKW@NUSVM.BITNET>
Subject:      PGFIX ETC

The exit routine has been modified and is now running fine.  Thanks to
all those who have contributed.


Chang K W
Systems Programmer
National University of Singapore
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Thu, 12 Nov 1992 16:25:00 PST
From:         Leonard D Woren <LDW@USCMVSA.BITNET>
Subject:      Re: MVS JES2 FIFO print class

> Output comes as two separate files, a custom banner, and the output.
> Question - how can we guarantee FIFO treatment of the files by JES.

I think that JES2 doesn't have any provision for such a thing.  And if
you're running multiple NJE streams, your output file could even
arrive before the custom banner.  I suggest rewriting your VM
application to send it all together in one file.  Depending on RSCS
capabilities, another possiblity would be to send both files in a
single sysout job, i.e., one NJH and two NDHs.

/Leonard
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Tue, 10 Nov 1992 12:10:41 EST
Comments:     Converted from PROFS to RFC822 format by PUMP V2.2X
From:         David Ehresman <DEEHRE01@ULKYVM.LOUISVILLE.EDU>
Subject:      JES2 3.1.3 Security Checking of Sysout Datasets

We are upgrading from JES2 3.1.1 to 3.3.3.  I have discovered that
3.1.3 does security checking of at least some sysout data sets,
namely DD SYSUDUMP.  It does not appear to be checking other
"normal" sysout data sets, e.g. DD SYSOUT.  Can anyone tell me
which sysout data set names are being checked and how they are
checked.

We are running ACF2/MVS 5.2 as our security system and are upgrading
MVS to MVS SP JES2 3.1.3.

***************************************************************
*David Ehresman, University of Louisville, (502) 588-5224
*Bitnet:DEEHRE01@ULKYVM Internet:DEEHRE01@ULKYVM.LOUISVILLE.EDU
*(Standard network disclaimer)
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
Newsgroups: bit.listserv.jes2-l
Date:         Thu, 12 Nov 1992 16:24:29 EST
From:         Arthur Gutowski <AGUTOWS@WAYNEST1.BITNET>
Subject:      JOBCARD standards enforcement

At our shop we are considering enforcing some sort of standards
for jobs submitted into JES2.  We want to make sure that certain
fields in the JOBCARD are present, and if not, we want to pull
them in.  We would like to be able to get this information from
the userid that the job is submitted under.  JES2 Exit 3 seems to
be the ideal place to accomplish this goal.

We are running ACF2, and already maintain some of the needed fields
in the LIDREC.  We would have to add a couple more.  It doesn't seem
like it would be that difficult to place an ACF2 call to get the
LIDREC for fhe submitting userid and fill in the blanks from there.

Other approaches I've considered are using ACF2's exit facilities in
the JES2 interface it has, but 1) their docs seem to recommend against
modifying those exits which would be useful, and 2) there is a
possibility we will be moving to RACF, and rather than reinvent the
wheel, it would be easier to modify a JES2 exit already in-place to
make the appropriate call to RACF.  Besides, it's a JES2 kind of
function I'm doing, it would be best placed in the JES2 environment.
I've also considered writing a SUBMIT exit or Rexx front-end to SUBMIT
that would pull the desired info from, say, a user profile dataset.
That doesn't cover STCs and TSUs, though.  We already have an EXEC
in place on VM that is used when submitting jobs from VM to JES2 via
RSCS, but it seems to me that a JES2 exit would replace the need for
that.  One program maintained at the point of entry into the system
seems like a much better idea.

Anyone got any comments or suggestions as to whether I'm on the
right track or barking up the wrong tree?

Thanks for any help,
Art
Comments: Gated by NETNEWS@AUVM.AMERICAN.EDU
X-Envelope-to: liaison@BITNIC.BITNET
X-VMS-To: IN%"liaison@bitnic.bitnet"
X-VMS-Cc: R_IRIARTE
Newsgroups: bit.listserv.liaison
Date:         Mon, 9 Nov 1992 09:02:00 AST
From:         "Rafael E. Iriarte,
              University of Puerto Rico Mayaguez Campus"
              <R_IRIARTE@UPR1.UPR.CLU.EDU>
Subject:      International phonetic alphabet.

      Greetings:
      I'm looking for a character set (or a font) that includes al the
characters of the International Phonetic Alphabet.
      Is there one available?
      Thanks
      R.E. Iriarte
      University of Puerto Rico