Re: [sqr-users] how to run a SQL procedure in SQR program

["Vishali Chandramouli" <vichandr@syr.edu>]

Chandra,
Check out this link on how to run a SQL proc from SQR. Hope this helps!
http://www.sqrug.org/ftp/miti_sqr_faqs/ora_faq/plsqlcal.htm

Thanks,
Vishali

>>> Spoth.Richard@healthnow.org 12/19/03 02:24PM >>>
I'm really only familar with Sybase and SQL Server. 

To execute a Store Procedure via SQR in Sybase you have to use the EXECUTE 
command.  The DO command is for calling SQR procedures.  I'm not sure if 
that is the case with Oracle but by gut feeling is that you need to use 
some sort of EXECUTE command. 

Rick Spoth
716-887-8923




chandrashekar patlolla <chandrashekar_patlolla@yahoo.com>
Sent by: sqr-users-admin@sqrug.org 
12/19/03 02:15 PM
Please respond to sqr-users

 
        To:     sqr-users@sqrug.org 
        cc: 
        Subject:        Re: [sqr-users] how to run a SQL procedure in SQR 
program


i am using oracle 8.1.7

Richard C Spoth <Spoth.Richard@healthnow.org> wrote:What type of 
datastores are you using? (Sybase, SQL Sever, etc...)

Rick Spoth





chandrashekar patlolla 
Sent by: sqr-users-admin@sqrug.org 
12/19/03 01:35 PM
Please respond to sqr-users


To: sqr-users@sqrug.org 
cc: 
Subject: [sqr-users] how to run a SQL procedure in SQR program


Hi All

I have an SQR program and i want to call a SQL procedure in that sqr 
program, and i am doing it this way. Is this the right way to do it.

begin-procedure get_customer_id
begin-select
customer_id &customer_id
let $customer_id = &customer_id
if $customer_id = '103'
do get_policy_number
do insert_address($policy_number_nph) ---- is the procedure written in 
the SQL
from contract
where contract.customer_id = '103'
end-select
end-procedure


Any help is appreciated

Thanks and Regards
Chandra
chandrashekar patlolla wrote:
begin-select
a.x1
b.x1
FROM a,b
WHERE a.x1 =b.x1(+)

using your table
mtl_sv.sap_mtl_nbr = mtl_planner_sv.sap_mtl_nbr(+)
or
mtl_sv.sap_mtl_nbr(+) = mtl_planner_sv.sap_mtl_nbr
depending on which table has and does not have the common values.


This might help.

Shailesh Sugandhi wrote:
Hi,

This is a query regarding the use of outer join in SQR.

I have to join 2 tables mtl_sv and mtl_planner_sv using
outer join.The key fields of both the tables are the same
ie. sap_mtl_nbr.

The join condition is
mtl_sv.sap_mtl_nbr = mtl_planner_sv.sap_mtl_nbr

mtl_planner_sv contains a field called planner code
which is getting selected and in the where clause of
which comes the joining condition.

There are values of sap_mtl_nbr which are there in mtl_sv
and not in mtl_planner_sv.
Output should come for all the sap_mtl_nbr in mtl_sv
even though many of them may not be in mtl_planner_sv.

I need help in joining the 2 tables using outer join
and i need the correct syntax in SQR.

Thanks in advance.

Regards,
Shailesh

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

---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now

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

---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

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





CONFIDENTIALITY NOTICE: This email message and any attachments are for the 
sole use of the intended recipient(s) and may contain proprietary, 
confidential, trade secret or privileged information. Any unauthorized 
review, use, disclosure or distribution is prohibited and may be a 
violation of law. If you are not the intended recipient or a person 
responsible for delivering this message to an intended recipient, please 
contact the sender by reply email and destroy all copies of the original
message.

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


---------------------------------
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing

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



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

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