Re: [sqr-users] (SQR 5528) Error (Happersberger. Rich (MSA))

[Britto.Devasahayam@in.standardchartered.com]

You need to give the DISTINCT keyword in the same line with begin-select as
follows


begin-select DISTINCT
bs.sample_type

bs.schedule_seq
.
.
.



Regards,
Britto

-------------------------------------------------------------------------------------------------------------------------------------------------------------
Send sqr-users mailing list submissions to
           sqr-users@sqrug.org

To subscribe or unsubscribe via the World Wide Web, visit
           http://www.sqrug.org/mailman/listinfo/sqr-users
or, via email, send a message with subject or body 'help' to
           sqr-users-request@sqrug.org

You can reach the person managing the list at
           sqr-users-owner@sqrug.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of sqr-users digest..."
Today's Topics:

   1. (SQR 5528) Error (Happersberger. Rich (MSA))
   2. Re: (SQR 5528) Error (George Jansen)
   3. RE: (SQR 5528) Error (Bartlett, Dwain)
   4. RE: (SQR 5528) Error (Alexander, Steve)
   5. Re: (SQR 5528) Error (bmrazek@sympatico.ca)
   6. RE: (SQR 5528) Error (Krishna Chennamaneni)
   7. RE: (SQR 5528) Error (Overcashier, Patricia)
   8. RE: (SQR 5528) Error (rwulfson@bost.com)
   9. RE: (SQR 5528) Error (the dragon)
  10. Anybody have experience with as/400 (Edmundo Reyes Cuellar)
  11. Page Size (Miller, Danika)
  12. Re: (SQR 5528) Error (Dattatraya Shetty)
  13. RE: Page Size (the dragon)
  14. RE: (SQR 5528) Error (Happersberger. Rich (MSA))
  15. RE: (SQR 5528) Error (Happersberger. Rich (MSA))

----- Message from on -----
  
  
  


Hello -

I'm new to SQR, so hope to ask the correct questions -

Curious about the entries in the message below when it says
"sc.queue=:1", etc.
Does this indicate a collision of variables?

This query is part of a local procedure.

If the variables are hardcoded, this query will return stuff via
SQLPlus.


>From the following Select I get the following error;

(SQR 5528) ORACLE OCIStmtExecute error 936 in cursor 5:
   ORA-00936: missing expression
SQL:  SELECT DISTINCT, bs.sample_type, bs.schedule_seq  FROM
batch_schedules
      bs, schedules sc, project_samples ps WHERE sc.schedule_id=ps.hsn
and
      sc.queue=:1 and sc.queue=bs.queue and bs.batch_number=:2 and
      ps.project_seq=:3 and bs.sample_type IN (select sample_type from
      hv$sample_type where sample_type_flag NOT IN ('0','9') )


Error on line 227:
   (SQR 3716) Error in SQL statement.

begin-select

DISTINCT

bs.sample_type

bs.schedule_seq


FROM
batch_schedules bs,
schedules sc,
project_samples ps

WHERE
sc.schedule_id=ps.hsn
and sc.queue=$_bs.Queue
and sc.queue=bs.queue                            !LACH for test purposes
and bs.batch_number=$_bs.BatchNumber               !1963 for test
purposes
and ps.project_seq=#_ProjectSeq                 !14666 for test purposes
and bs.sample_type IN
(select sample_type
from hv$sample_type
where sample_type_flag NOT IN ('0','9')
)

end-select

Thanks to all -

Rich Happersberger
Asst. Systems Administrator
SRCSD Laboratory (MSA)



___________________________________________________________________________________________________________

This email and any attachments thereto may contain private, confidential,
and privileged material for the
sole use of the intended recipient. Any review, copying, or distribution of
this email (or any attachments
thereto) by other than the County of Sacramento or the intended recipient
is strictly prohibited.

If you are not the intended recipient, please contact the sender
immediately and permanently
delete the original and any copies of this email and any attachments
thereto.
___________________________________________________________________________________________________________




----------------------------------------------------------

This email is confidential. If you are not the addressee tell the sender 
immediately and destroy this email without using, sending or storing it. Emails 
are not secure and may suffer errors, viruses, delay, interception and 
amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not accept 
liability for damage caused by this email and may monitor email traffic. Unless 
expressly stated, any opinions are the sender's and are not approved by SCGroup 
and this email is not an offer, solicitation, recommendation or agreement of 
any kind.



Standard Chartered Bank ("SCB") is a member of SCGroup incorporated in England 
with limited liability. SCB's principal office is 1 Aldermanbury Square, 
London, EC2V 7SB, UK. SCB is authorised and regulated by the Financial Services 
Authority ("FSA") and in FSA's register under no. 114276. SCB's VAT no. is 
GB244106593. FSA is the lead regulator for the SCGroup. For regulators in other 
countries contact the local compliance officer.

---------------------------------------------------------
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users