This is a multi-part message in MIME format.
------=_NextPart_000_008A_01C09CC4.2B564110
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
I'm trying to set up a client variable repository using DB2 7.1 on Red =
Hat Linux 7, Apache 1.3.14. After I create and verify the datasource =
successfully, when I attempt to set up the database for client variable =
storage and create the necessary tables, I receive this error message:=20
"Unable to create client tables If they already exist, you should =
uncheck Create Client Tables. DB2 Error Code =3D -604=20
[IBM][CLI Driver][DB2/LINUX] SQL0604N The length, precision, or scale =
attribute for column, distinct type, structured type, attribute of =
structured type, function, or type mapping "DATA" is not valid. =
SQLSTATE=3D42611"=20
Since the automatic creation doesn't work, I set up the 2 tables =
manually, with the following fields: CDATA - cfid char 20, app char 64, =
data long varchar; CGLOBAL - cfid char 20, data long varchar, lvisit =
timestamp (also tried date).=20
I attempt to use my application, and when it's time to submit a form, I =
receive this error message:=20
"DB2 Error Code =3D -104=20
[IBM][CLI Driver][DB2/LINUX] SQL0104N An unexpected token "2001" was =
found following "15:23:26''}#','{ts '". Expected tokens may include: "". =
SQLSTATE=3D42601"=20
At the bottom of the error page is this: "Found The document has moved =
here." - with the word 'here' correctly hyperlinked to the page that the =
form was supposed to return.=20
It looks like data is being written to the CDATA table, but not the =
CGLOBAL table.=20
The application will eventually sit on clustered servers, so that's why =
we're going the database repository route.=20
As a workaround, we've installed MySql and are successfully using that =
as the client variable repository, but ideally we'd like to use DB2 for =
both the data and client variables.=20
Does anyone have any experience or advice with this? Thanks.=20
--
Nikki Woelk
Faludi Computing, Inc. (415) 512-8212
[EMAIL PROTECTED] http://www.faludicomputing.com
------=_NextPart_000_008A_01C09CC4.2B564110
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dwindows-1252">
<META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV>
<DIV>
<P>I'm trying to set up a client variable repository using DB2 7.1 on =
Red Hat=20
Linux 7, Apache 1.3.14. After I create and verify the datasource =
successfully,=20
when I attempt to set up the database for client variable storage and =
create the=20
necessary tables, I receive this error message:=20
<P>"Unable to create client tables If they already exist, you should =
uncheck=20
Create Client Tables. DB2 Error Code =3D -604=20
<P>[IBM][CLI Driver][DB2/LINUX] SQL0604N The length, precision, or scale =
attribute for column, distinct type, structured type, attribute of =
structured=20
type, function, or type mapping "DATA" is not valid. SQLSTATE=3D42611"=20
<P>Since the automatic creation doesn't work, I set up the 2 tables =
manually,=20
with the following fields: CDATA - cfid char 20, app char 64, data long =
varchar;=20
CGLOBAL - cfid char 20, data long varchar, lvisit timestamp (also tried =
date).=20
<P>I attempt to use my application, and when it's time to submit a form, =
I=20
receive this error message:=20
<P>"DB2 Error Code =3D -104=20
<P>[IBM][CLI Driver][DB2/LINUX] SQL0104N An unexpected token "2001" was =
found=20
following "15:23:26''}#','{ts '". Expected tokens may include: "".=20
SQLSTATE=3D42601"=20
<P>At the bottom of the error page is this: "Found The document has =
moved here."=20
- with the word 'here' correctly hyperlinked to the page that the form =
was=20
supposed to return.=20
<P>It looks like data is being written to the CDATA table, but not the =
CGLOBAL=20
table.=20
<P>The application will eventually sit on clustered servers, so that's =
why we're=20
going the database repository route.=20
<P>As a workaround, we've installed MySql and are successfully using =
that as the=20
client variable repository, but ideally we'd like to use DB2 for both =
the data=20
and client variables.=20
<P>Does anyone have any experience or advice with this? Thanks. =
</P></DIV></DIV>
<DIV>--<BR>Nikki Woelk<BR>Faludi Computing,=20
Inc. (415) =
512-8212<BR><A=20
href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A> &n=
bsp; =20
<A=20
href=3D"http://www.faludicomputing.com">http://www.faludicomputing.com</A=
></DIV></BODY></HTML>
------=_NextPart_000_008A_01C09CC4.2B564110--
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
