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_01C1D18E.49ECEE30
Content-Type: text/plain;
charset="iso-8859-1"
...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]
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]
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
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
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_01C1D18E.49ECEE30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
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 =3D 1000000 =
&
WHERE EMPLOYEE_CODE =3D =
'MF'
END
(<sigh>, if only!!!) :-)
Best Regards,
Mark Fry
Mark.Fry@Cognos.com
-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@cognos.com]<=
/FONT>
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 =3D 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 =3D 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]
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
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
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
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.
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D
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
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_01C1D18E.49ECEE30--