Embedded SQL in Qdesign

Fri, 22 Mar 2002 11:36:08 -0600

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1D1C8.0D31DAC0
Content-Type: text/plain;
	charset="iso-8859-1"

Hi,

I've not used and am not that familiar with the embedded SQL, could someone
explain the why and when one would use this?
Is this to overcome some things that can't be done or is it more effecient
or ...?

Thanx
       Lorry Litman

-----Original Message-----
From: Fry, Mark [mailto:Mark.Fry@COGNOS.com]
Sent: Friday, March 22, 2002 4:43 AM
To: Deskin, Bob; powerh-l@lists.swau.edu
Subject: RE: Embedded SQL in Qdesign

...and another example (not from the manual this time) is embedding SQL DML
directly into a procedure without declaring an SQL cursor, as in...

PROCEDURE PREUPDATE RECOVERABLE 
BEGIN 
  SQL IN <databasename> & 
    UPDATE PERSONNEL & 
    SET SALARY = 1000000 & 
    WHERE EMPLOYEE_CODE = 'MF' 
END 

(<sigh>, if only!!!) :-) 

Best Regards, 

Mark Fry 
Mark.Fry@Cognos.com 

-----Original Message----- 
From: Deskin, Bob [ mailto:Bob.Deskin@cognos.com
<mailto:Bob.Deskin@cognos.com> ] 
Sent: 21 March 2002 19:21 
To: powerh-l@lists.swau.edu 
Subject: RE: Embedded SQL in Qdesign 

I don't think a few examples are going to help in the generalized case. You 
can download the manuals for free from www.cognos.com/powerhouse. But here's

an example from the manual. 

> SET LIST SQL 
> SQL DECLARE EMPLIST CURSOR FOR & 
> SELECT EMPLOYEE, FIRST_NAME, LAST_NAME, & 
> EMPLOYEES.BRANCH,BRANCH_NAME & 
> FROM EMPLOYEES, BRANCHES 
> SCREEN EMPBRANCHC 
> CURSOR EMPLIST & 
> WHERE (EMPLOYEES.BRANCH = BRANCHES.BRANCH) & 
> PRIMARY KEY EMPLOYEE 
> __ Sql after substitutions are applied: 
__ SELECT EMPLOYEE, FIRST_NAME, LAST_NAME, 
__ EMPLOYEES.BRANCH, BRANCHES.BRANCH, 
__ BRANCH_NAME 
__ FROM EMPLOYEES, BRANCHES 
__ where EMPLOYEES.BRANCH = BRANCHES.BRANCH 

Bob Deskin              
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc. 
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178 
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA 

-----Original Message----- 
From: John Hunter [ mailto:jthunter@nbnet.nb.ca
<mailto:jthunter@nbnet.nb.ca> ] 
Sent: Thursday, March 21, 2002 2:18 PM 
To: powerh-l@lists.swau.edu 
Subject: Embedded SQL in Qdesign 

Hi Gang, 

Could some kind soul please show me an example of an embedded SQL in 
Qdesign?  I would RTFM but, alas, I don't have one.  I think I'm close, but 
am still running into problems.  My platform is Powerhouse 820 on VMS. 

Thanks, 
-John 

= = = = = = = = = = = = = = = = = = = = = = = = = = = = 
Mailing list: powerh-l@lists.swau.edu 
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu 
Unsubscribe: "unsubscribe" in message body to 
powerh-l-request@lists.swau.edu 
http://lists.swau.edu/mailman/listinfo/powerh-l
<http://lists.swau.edu/mailman/listinfo/powerh-l>  
This list is closed, thus to post to the list you must be a subscriber. 

This message may contain privileged and/or confidential information.  If you

have received this e-mail in error or are not the intended recipient, you 
may not use, copy, disseminate or distribute it; do not open any 
attachments, delete it immediately from your system and notify the sender 
promptly by e-mail that you have done so.  Thank you. 

= = = = = = = = = = = = = = = = = = = = = = = = = = = = 
Mailing list: powerh-l@lists.swau.edu 
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu 
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu 
http://lists.swau.edu/mailman/listinfo/powerh-l
<http://lists.swau.edu/mailman/listinfo/powerh-l>  
This list is closed, thus to post to the list you must be a subscriber. 

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.

------_=_NextPart_001_01C1D1C8.0D31DAC0
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Embedded SQL in Qdesign</TITLE>

<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV>Hi,</DIV>
<DIV>&nbsp;</DIV>
<DIV>I've 
not used and am not that familiar with the embedded SQL, could someone explain 
the why and when one would use this?</DIV>
<DIV>Is 
this to overcome some things that can't be done or is it more effecient or 
...?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanx</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Lorry 
Litman</DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
 <DIV align=left class=OutlookMessageHeader dir=ltr>-----Original Message----- From: Fry, Mark 
 [mailto:Mark.Fry@COGNOS.com] Sent: Friday, March 22, 2002 4:43 
 AM To: Deskin, Bob; powerh-l@lists.swau.edu Subject: RE: 
 Embedded SQL in Qdesign </DIV>
 ...and another example (not from the manual this time) is 
 embedding SQL DML directly into a procedure without declaring an SQL cursor, 
 as in...
 PROCEDURE PREUPDATE RECOVERABLE BEGIN &nbsp; SQL IN &lt;databasename&gt; 
 &amp; &nbsp;&nbsp;&nbsp; UPDATE PERSONNEL &amp; 
 &nbsp;&nbsp;&nbsp; SET SALARY = 1000000 &amp; 
 &nbsp;&nbsp;&nbsp; WHERE EMPLOYEE_CODE = 'MF' 
 END 
 (&lt;sigh&gt;, if only!!!) :-) 
 Best Regards, 
 Mark Fry Mark.Fry@Cognos.com 
 
 -----Original Message----- From: 
 Deskin, Bob [<A 
 href="mailto:Bob.Deskin@cognos.com">mailto:Bob.Deskin@cognos.com</A>] 
 Sent: 21 March 2002 19:21 To: 
 powerh-l@lists.swau.edu Subject: RE: Embedded SQL in 
 Qdesign 
 I don't think a few examples are going to help in the 
 generalized case. You can download the manuals for 
 free from www.cognos.com/powerhouse. But here's an 
 example from the manual. 
 &gt; SET LIST SQL &gt; SQL DECLARE 
 EMPLIST CURSOR FOR &amp; &gt; SELECT EMPLOYEE, 
 FIRST_NAME, LAST_NAME, &amp; &gt; 
 EMPLOYEES.BRANCH,BRANCH_NAME &amp; &gt; FROM 
 EMPLOYEES, BRANCHES &gt; SCREEN EMPBRANCHC 
 &gt; CURSOR EMPLIST &amp; &gt; WHERE 
 (EMPLOYEES.BRANCH = BRANCHES.BRANCH) &amp; &gt; 
 PRIMARY KEY EMPLOYEE &gt; __ Sql after substitutions 
 are applied: __ SELECT EMPLOYEE, FIRST_NAME, 
 LAST_NAME, __ EMPLOYEES.BRANCH, 
 BRANCHES.BRANCH, __ BRANCH_NAME __ FROM EMPLOYEES, BRANCHES __ where 
 EMPLOYEES.BRANCH = BRANCHES.BRANCH 
 Bob 
 Deskin&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 PowerHouse Web Product Manager, Application 
 Development Tools, Cognos Inc. bob.deskin@cognos.com 
 (613) 738-1338 ext 7268 FAX: (613) 727-1178 3755 
 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA 
 -----Original Message----- From: John 
 Hunter [<A 
 href="mailto:jthunter@nbnet.nb.ca">mailto:jthunter@nbnet.nb.ca</A>] 
 Sent: Thursday, March 21, 2002 2:18 PM To: powerh-l@lists.swau.edu Subject: Embedded 
 SQL in Qdesign 
 Hi Gang, 
 Could some kind soul please show me an example of an embedded 
 SQL in Qdesign?&nbsp; I would RTFM but, alas, I don't 
 have one.&nbsp; I think I'm close, but am still 
 running into problems.&nbsp; My platform is Powerhouse 820 on VMS. 
 Thanks, -John 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 Mailing list: powerh-l@lists.swau.edu Subscribe: "subscribe" in message body to 
 powerh-l-request@lists.swau.edu Unsubscribe: 
 "unsubscribe" in message body to powerh-l-request@lists.swau.edu <A 
 href="http://lists.swau.edu/mailman/listinfo/powerh-l" 
 target=_blank>http://lists.swau.edu/mailman/listinfo/powerh-l</A> 
 This list is closed, thus to post to the list you must be a 
 subscriber. 
 This message may contain privileged and/or confidential 
 information.&nbsp; If you have received this e-mail in 
 error or are not the intended recipient, you may not 
 use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the 
 sender promptly by e-mail that you have done so.&nbsp; 
 Thank you. 
 = = = = = = = = = = = = = = = = = = = = = = = = = = = = 
 Mailing list: powerh-l@lists.swau.edu Subscribe: "subscribe" in message body to 
 powerh-l-request@lists.swau.edu Unsubscribe: 
 "unsubscribe" in message body to powerh-l-request@lists.swau.edu 
 <A href="http://lists.swau.edu/mailman/listinfo/powerh-l" 
 target=_blank>http://lists.swau.edu/mailman/listinfo/powerh-l</A> 
 This list is closed, thus to post to the list you must be a 
 subscriber. 
 This message may contain privileged and/or confidential 
 information.&nbsp; If you have received this e-mail in error or are not the 
 intended recipient, you may not use, copy, disseminate or distribute it; do 
 not open any attachments, delete it immediately from your system and notify 
 the sender promptly by e-mail that you have done so.&nbsp; Thank 
 you.</BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C1D1C8.0D31DAC0--