RE: Learning new SQL tricks

Move the WITH NC command after WHERE clause i.e.

INSERT INTO DJLIB/CUSSN
  SELECT * FROM DJLIB/CUSMAS, PRODLIB1/CUSSN
  WHERE CUSMAS.CSC# = CUSSN.SNC#

WITH NC

-----Original Message-----
From: midrange-l-bounces+anand.praj=wipro.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+anand.praj=wipro.com@xxxxxxxxxxxx] On Behalf
Of Dan
Sent: Friday, August 05, 2005 2:16 AM
To: Midrange Systems Technical Discussion
Subject: Learning new SQL tricks

I have a customer master file (CM) that contains a subset of records I
culled from the production file.  I would now like to copy every
detail record from a production order file to a duplicate test file
for which the customer number exists in CM.  Here is what I've
attempted so far.  Actually, this is the last attempt of a dozen or so
tries:

INSERT INTO DJLIB/CUSSN
  SELECT * FROM DJLIB/CUSMAS, PRODLIB1/CUSSN WITH NC
  WHERE CUSMAS.CSC# = CUSSN.SNC#

This generates SQL0199 "Keyword WHERE not expected. Valid tokens:
<END-OF-STATEMENT>."

Any ideas would be greatly appreciated.

TIA,
Dan

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




Confidentiality Notice

The information contained in this electronic message and any attachments to 
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or 
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or 
Mailadmin@xxxxxxxxx immediately
and destroy all copies of this message and any attachments.