Embedded SQL in Qdesign
Mikael A Olesen
mao@krifapost.dk
Fri, 22 Mar 2002 14:30:33 +0100
If only!
Maybe in the next version???
Kind Regards
Mikael A. Olesen
Systemudvikler
--------------------------------------------
Tlf.: +45 7227 7020 (office)
Tlf.: +45 8745 0890 (home)
E-mail: mao@krifapost.dk
--------------------------------------------
"Fry, Mark"
<Mark.Fry@COGNOS. To: "Deskin, Bob" <Bob.Deskin@COGNOS.com>, powerh-l@lists.swau.edu
com> cc:
Sent by: Subject: RE: Embedded SQL in Qdesign
powerh-l-admin@cu
be.swau.edu
22-03-2002 11:42
...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.