LVARCHAR in SQL (Error -999)
Hi,
I have two database RRADMINDB and RRRPDB, both have table "emMessageTemplates"
which includes a LVARCHAR column - "messagetext". What I want is to copy the
value of this column from RRADMINDB:emMessageTemplates to
RRRPDB:emMessageTemplates. In database RRRPDB, below SQL doesn't work:
insert into emMessageTemplates (messagetext)
select messagetext from RRADMINDB:emMessageTemplates;Error is : "SQL Error (-999): Not implemented yet.".
How can I walk around this error?
Thanks in advance,
Michael Wei
--0__=09BBFA8CDFCD10638f9e8a93df938690918c09BBFA8CDFCD1063
Content-type: multipart/alternative;
Boundary="1__=09BBFA8CDFCD10638f9e8a93df938690918c09BBFA8CDFCD1063"
--1__=09BBFA8CDFCD10638f9e8a93df938690918c09BBFA8CDFCD1063
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
PTS FEA 159230 : SUPPORT INTERNAL UDTS SUCH AS BOOLEAN, LVARCHAR AND
EXPLICITLY CAST TRUE UDTS ACROSS DATABASES
1. Allow select, update, insert, delete operations on internal UDTs
such as boolean, lvarchar across databases.
2. Allow cross-database execution (explicit and implicit) of UDRs
with internal UDT parameters/return types.
3. Allow the above operations (1. & 2.) on true UDTs explicitly cast
to built-in standard sql types or internal UDTs
This feature is available in 10.00.xCx
Thanks and Regards,
Gaurav
=
"MICHAEL WEI" =
<mwei@trangosoft. =
com> =
To
Sent by: ids@iiug.org =
forum.subscriber@ =
cc
iiug.org =
Subj=
ect
LVARCHAR in SQL (Error -999) =
06/13/2005 10:09 [5142] =
AM =
=
=
=
=
=
Hi,
I have two database RRADMINDB and RRRPDB, both have table
"emMessageTemplates" which includes a LVARCHAR column - "messagetext". =
What
I want is to copy the value of this column from
RRADMINDB:emMessageTemplates to RRRPDB:emMessageTemplates. In database
RRRPDB, below SQL doesn't work:
insert into emMessageTemplates (messagetext)
select messagetext from RRADMINDB:emMessageTemplates;Error is : "SQL Error (-999): Not implemented yet.".
How can I walk around this error?
Thanks in advance,
Michael Wei
=
--1__=09BBFA8CDFCD10638f9e8a93df938690918c09BBFA8CDFCD1063
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>PTS FEA 159230 : SUPPORT INTERNAL UDTS SUCH AS BOOLEAN, LVARCHAR AND=
EXPLICITLY CAST TRUE UDTS ACROSS DATABASES<br>
<br>
1. Allow select, update, insert, delete operations on internal UDTs <br=
>
such as boolean, lvarchar across databases.<br>
2. Allow cross-database execution (explicit and implicit) of UDRs <br>
with internal UDT parameters/return types.<br>
3. Allow the above operations (1. & 2.) on true UDTs explicitly cas=
t<br>
to built-in standard sql types or internal UDTs<br>
<br>
This feature is available in 10.00.xCx<br>
<br>
Thanks and Regards,<br>
Gaurav<br>
<img src=3D"cid:10__=3D09BBFA8CDFCD10638f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "MICHAEL WEI&q=
uot; <mwei@trangosoft.com>">"MICHAEL WEI" <mwei@tran=
gosoft.com><br>
<br>
<br>
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D09BBFA8=
CDFCD10638f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid=
th=3D"40%">
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"MICHAEL WEI" <mwei@trangosoft.com=
></font></b><font size=3D"2"> </font><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">06/13/2005 10:09 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"60%">
<table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">=
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBFA8CDFCD10638f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBFA8CDFCD10638f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">ids@iiug.org</font></td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBFA8CDFCD10638f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"=
100%"><img src=3D"cid:30__=3D09BBFA8CDFCD10638f9e8a93df938@us.ibm.com" =
border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
</td></tr>
<tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3=
0__=3D09BBFA8CDFCD10638f9e8a93df938@us.ibm.com" border=3D"0" height=3D"=
1" width=3D"58" alt=3D""><br>
<div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt=
h=3D"100%"><img src=3D"cid:30__=3D09BBFA8CDFCD10638f9e8a93df938@us.ibm.=
com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"2">LVARCHAR in SQL (Error -999) [5142]</font></td></tr>
</table>
<table border=3D"0" cellspacing=3D"0" cellpadding=3D"0">
<tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D09BBFA8CDFCD=
10638f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=
=3D""></td><td width=3D"336"><img src=3D"cid:30__=3D09BBFA8CDFCD10638f9=
e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><=
/td></tr>
</table>
</td></tr>
</table>
<br>
<tt>Hi,<br>
<br>
I have two database RRADMINDB and RRRPDB, both have table "emMessa=
geTemplates" which includes a LVARCHAR column - "messagetext&=
quot;. What I want is to copy the value of this column from RRADMINDB:e=
mMessageTemplates to RRRPDB:emMessageTemplates. In database RRRPDB, bel=
ow SQL doesn't work:<br>
insert into emMessageTemplates (messagetext)<br>
select messagetext from RRADMINDB:emMessageTemplates;<br>
Error is : "SQL Error (-999): Not implemented yet.".<br>
<br>
How can I walk around this error?<br>
<br>
Thanks in advance,<br>
Michael Wei<br>
<br>
<br>
</tt><br>
</body></html>=
--1__=09BBFA8CDFCD10638f9e8a93df938690918c09BBFA8CDFCD1063--
--0__=09BBFA8CDFCD10638f9e8a93df938690918c09BBFA8CDFCD1063
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=09BBFA8CDFCD10638f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7
--0__=09BBFA8CDFCD10638f9e8a93df938690918c09BBFA8CDFCD1063
Content-type: image/gif;
name=@@DQ
--0__=09BBFA8CDFF075248f9e8a93df938690918c09BBFA8CDFF07524
Content-type: multipart/alternative;
Boundary="1__=09BBFA8CDFF075248f9e8a93df938690918c09BBFA8CDFF07524"
--1__=09BBFA8CDFF075248f9e8a93df938690918c09BBFA8CDFF07524
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: quoted-printable
Hi,
This restriction of lvarchar references across databases on same server=
has
been removed in IDS Version 10.
One possible work around for lower versions would be to create another
table on the source database using char instead of lvarchar type.
Subsequently use this new table for cross-database insert.
database RRADMINDB;
create table newemMessageTemplates(messagetext char(sizeoflvarcharcolum=n));
insert into newemMessageTemplates
select messagetext from emMessageTemplates;
database RRRPDB;
insert into emMessageTemplates (messagetext)select TRIM(messagetext) from RRADMINDB:newemMessageTemplates;
Thanks,
Nita Dembla
Software Engineer
IBM - Information Management Solutions
=
"MICHAEL WEI" =
<mwei@trangosoft. To: ids@iiug.org =
com> cc: =
Sent by: Subject: LVARCHAR in SQ=
L (Error -999) [5142]
forum.subscriber@ =
iiug.org =
=
=
06/13/2005 10:09 =
AM =
=
Hi,
I have two database RRADMINDB and RRRPDB, both have table
"emMessageTemplates" which includes a LVARCHAR column - "messagetext". =
What
I want is to copy the value of this column from
RRADMINDB:emMessageTemplates to RRRPDB:emMessageTemplates. In database
RRRPDB, below SQL doesn't work:
insert into emMessageTemplates (messagetext)
select messagetext from RRADMINDB:emMessageTemplates;Error is : "SQL Error (-999): Not implemented yet.".
How can I walk around this error?
Thanks in advance,
Michael Wei
=
--1__=09BBFA8CDFF075248f9e8a93df938690918c09BBFA8CDFF07524
Content-type: text/html; charset=US-ASCII
Content-Disposition: inline
Content-transfer-encoding: quoted-printable
<html><body>
<p>Hi,<br>
<br>
This restriction of lvarchar references across databases on same server=
has been removed in IDS Version 10.<br>
<br>
One possible work around for lower versions would be to create another =
table on the source database using char instead of lvarchar type. Subse=
quently use this new table for cross-database insert.<br>
<br>
<font face=3D"Courier">database RRADMINDB;</font><br>
<font face=3D"Courier">create table newemMessageTemplates(messagetext c=
har(sizeoflvarcharcolumn));</font><br>
<font face=3D"Courier">insert into newemMessageTemplates</font><br>
<font face=3D"Courier">select messagetext from emMessageTemplates;</fon=
t><br>
<br>
<font face=3D"Courier">database RRRPDB;</font><br>
<font face=3D"Courier">insert into emMessageTemplates (messagetext)</fo=
nt><br>
<font face=3D"Courier">select TRIM(messagetext) from RRADMINDB:newemMes=
sageTemplates;<br>
</font><br>
Thanks,<br>
Nita Dembla<br>
Software Engineer<br>
IBM - Information Management Solutions<br>
<br>
<br>
<img src=3D"cid:10__=3D09BBFA8CDFF075248f9e8a93df938@us.ibm.com" width=3D=
"16" height=3D"16" alt=3D"Inactive hide details for "MICHAEL WEI&q=
uot; <mwei@trangosoft.com>">"MICHAEL WEI" <mwei@tran=
gosoft.com><br>
<br>
<br>
<table V5DOTBL=3Dtrue width=3D"100%" border=3D"0" cellspacing=3D"0" cel=
lpadding=3D"0">
<tr valign=3D"top"><td width=3D"1%"><img src=3D"cid:20__=3D09BBFA8CDFF0=
75248f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"72" al=
t=3D""><br>
</td><td style=3D"background-image:url(cid:30__=3D09BBFA8CDFF075248f9e8=
a93df938@us.ibm.com); background-repeat: no-repeat; " width=3D"1%"><img=
src=3D"cid:20__=3D09BBFA8CDFF075248f9e8a93df938@us.ibm.com" border=3D"=
0" height=3D"1" width=3D"225" alt=3D""><br>
<ul>
<ul>
<ul>
<ul><b><font size=3D"2">"MICHAEL WEI" <mwei@trangosoft.com=
></font></b><br>
<font size=3D"2">Sent by: forum.subscriber@iiug.org</font>
<p><font size=3D"2">06/13/2005 10:09 AM</font></ul>
</ul>
</ul>
</ul>
</td><td width=3D"100%"><img src=3D"cid:20__=3D09BBFA8CDFF075248f9e8a93=
df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br>
<font size=3D"1" face=3D"Arial"> </font><br>
<font size=3D"2"> To: </font><font size=3D"2">ids@iiug.org</font><br>
<font size=3D"2"> cc: </font><br>
<font size=3D"2"> Subject: </font><font size=3D"2">LVARCHAR in SQL (Err=
or -999) [5142]</font></td></tr>
</table>
<br>
<br>
<tt>Hi,<br>
<br>
I have two database RRADMINDB and RRRPDB, both have table "emMessa=
geTemplates" which includes a LVARCHAR column - "messagetext&=
quot;. What I want is to copy the value of this column from RRADMINDB:e=
mMessageTemplates to RRRPDB:emMessageTemplates. In database RRRPDB, bel=
ow SQL doesn't work:<br>
insert into emMessageTemplates (messagetext)<br>
select messagetext from RRADMINDB:emMessageTemplates;<br>
Error is : "SQL Error (-999): Not implemented yet.".<br>
<br>
How can I walk around this error?<br>
<br>
Thanks in advance,<br>
Michael Wei<br>
<br>
<br>
</tt>
</body></html>=
--1__=09BBFA8CDFF075248f9e8a93df938690918c09BBFA8CDFF07524--
--0__=09BBFA8CDFF075248f9e8a93df938690918c09BBFA8CDFF07524
Content-type: image/gif;
name="graycol.gif"
Content-Disposition: inline; filename="graycol.gif"
Content-ID: <10__=09BBFA8CDFF075248f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu
ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7
--0__=09BBFA8CDFF075248f9e8a93df938690918c09BBFA8CDFF07524
Content-type: image/gif;
name="ecblank.gif"
Content-Disposition: inline; filename="ecblank.gif"
Content-ID: <20__=09BBFA8CDFF075248f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7
--0__=09BBFA8CDFF075248f9e8a93df938690918c09BBFA8CDFF07524
Content-type: image/gif;
name="pic03711.gif"
Content-Disposition: inline; filename="pic03711.gif"
Content-ID: <30__=09BBFA8CDFF075248f9e8a93df938@us.ibm.com>
Content-transfer-encoding: base64
R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA
AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh
EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR
RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH
LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3
Hi,
You must write a Stored procedure to acomplish that,
because informix cannot query this data types between databases.
You must cast that datatype to char.
A simple example is:
In a database A:
Create funcion spsenddata()
Returning char(1000)
--this variable is define with max lvarchar value...
Define lvalue char(1000);
Foreach
Select fiellvarchar
into lvalue
from yourtable
return lvalue with resume;
End foreach;
End function
In database B:
Execute function A:spsenddata();--If you run this function in a dbaccess you'll receive full table from
database A,
--or you can specify a foreach of that stored procedure in this
database.
--At the end you must implement this for your requeriments.
I hope you find this helpful
Regards.
-----Mensaje original-----
De: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org] En
nombre de MICHAEL WEI
Enviado el: Lunes, 13 de Junio de 2005 10:09 a.m.
Para: ids@iiug.org
Asunto: LVARCHAR in SQL (Error -999) [5142]
Hi,
I have two database RRADMINDB and RRRPDB, both have table
"emMessageTemplates" which includes a LVARCHAR column - "messagetext".
What I want is to copy the value of this column from
RRADMINDB:emMessageTemplates to RRRPDB:emMessageTemplates. In database
RRRPDB, below SQL doesn't work:
insert into emMessageTemplates (messagetext)
select messagetext from RRADMINDB:emMessageTemplates;Error is : "SQL Error (-999): Not implemented yet.".
How can I walk around this error?
Thanks in advance,
Michael Wei