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

["Richard C Spoth" <Spoth.Richard@healthnow.org>]

What type of datastores are you using?  (Sybase, SQL Sever, etc...)

Rick Spoth





chandrashekar patlolla <chandrashekar_patlolla@yahoo.com>
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 <chandrashekar_patlolla@yahoo.com> 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