[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: [sqr-users] how to run a SQL procedure in SQR program
Hi Chandra,
Try the following,
Create a procedure
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_sql ($policy_number_nph) ! Procedure in SQR
from contract
where contract.customer_id = '103'
end-select
end-procedure
begin-procedure insert_address_sql($policy_number_nph)
begin-sql
begin
#status := insert_address($policy_number_nph);;
end;;
end-sql
end-procedure
--- Vishali Chandramouli <vichandr@syr.edu> wrote:
> 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
__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users