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_01C1C5E3.1FBAFA00 Content-Type: text/plain; charset="iso-8859-1" Hi Bert, Hmmm - in your example, the cursor you declare (CURSOR_TEST) is not the cursor you are accessing (CURSOR_INVERZEKERING), but besides that, give the following a try... sql in AL_DB declare CURSOR_TEST cursor for & select CONTRACTNR , NAWNR , '' as test & from CONTRACT_GEG & where CONTRACTNR = 2002017030 access CURSOR_TEST Best regards, Mark Fry Cognos Limited email: Mark.Fry@Cognos.com Cognos Limited Registered in England, number 1635598. Registered office: Westerly Point, Market Street, Bracknell, Berkshire, RG12 1QB -----Original Message----- From: bert.dn@arma.nl [mailto:bert.dn@arma.nl] Sent: 07 March 2002 14:01 To: PH listserver Subject: RE: Add Null value to cursor Hi all, In a cursor (Oracle) I would like to add an extra column with value "NULL" As NULL is a reserved word I need to enclose it in double quotes ( Yes,I did RTFM!) However PH keep complaining that the column cannot be found. sql in AL_DB declare CURSOR_TEST cursor for & select CONTRACTNR , NAWNR , "NULL" as test & from CONTRACT_GEG & where CONTRACTNR = 2002017030 access CURSOR_INVERZEKERING *E* Error parsing SQL statement. DMS-E-GENERAL, A general exception has occurred during operation 'prepare request'. DMS-E-RBI_COLUMN, Column NULL was not found. When I do this directly in SQL there is no problem. Any suggestions? Bert de Nooij = = = = = = = = = = = = = = = = = = = = = = = = = = = = 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_01C1C5E3.1FBAFA00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: Add Null value to cursor Hi Bert,
Hmmm - in your example, the cursor you declare = (CURSOR_TEST) is not the cursor you are accessing = (CURSOR_INVERZEKERING), but besides that, give the following a = try...
sql in AL_DB declare CURSOR_TEST cursor = for &
select CONTRACTNR , NAWNR , '' as = test &n= bsp; &
from = CONTRACT_GEG = = = &
where CONTRACTNR =3D 2002017030access CURSOR_TEST
Best regards,
Mark Fry
Cognos Limited
email: Mark.Fry@Cognos.comCognos Limited
Registered in England, number 1635598. = Registered office: Westerly Point, Market Street, Bracknell, = Berkshire, RG12 1QB
-----Original Message-----
From: bert.dn@arma.nl [mailto:bert.dn@arma.nl]
Sent: 07 March 2002 14:01
To: PH listserver
Subject: RE: Add Null value to cursor
Hi all,
In a cursor (Oracle) I would like to add an = extra column with value "NULL"
As NULL is a reserved word I need to enclose it in = double quotes ( Yes,I did
RTFM!)
However PH keep complaining that the column cannot = be found.sql in AL_DB declare CURSOR_TEST cursor = for &
select CONTRACTNR , NAWNR , "NULL" as = test = &
from = CONTRACT_GEG = = = &
where CONTRACTNR =3D 2002017030access CURSOR_INVERZEKERING
*E* Error parsing SQL statement.
DMS-E-GENERAL, A general exception has occurred = during operation 'prepare
request'.
DMS-E-RBI_COLUMN, Column NULL was not found.
When I do this directly in SQL there is no = problem.
Any suggestions?
Bert de Nooij
=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_01C1C5E3.1FBAFA00--