I am having trouble escaping the string value for the FILENAME argument to
the SYSCS_IMPORT_TABLE.
The following tests were run in IJ, but get the same results in a Java app.
The following command:
CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE (null, 'TEMPTBL',
'C:/Chip's/TERMS.dat', null, null, null, 0)
jrgchip wrote:
>
> The failure still occurs.
>
Per investigation in DERBY-4032, it appears that there is indeed a bug in
Derby. The problem here is that there are two records for 'HG15497' in the
unique index on the Product table (one active and one marked as deleted)
Rick Hillegas-2 wrote:
>
> Upgrading to 10.3.3.0 will remove this theory from consideration.
>
I tested with v10.3.3.0 and v10.4.2.0...to no avail. The failure still
occurs.
--
View this message in context:
http://www.nabble.com/Record-not-found-in-some-SQL---Bug--tp21700110p21727785.html
S
oysteing wrote:
>
> Have you tried to run the Derby consistency checker?
>
Yes...it reports all 44 tables as OK per SYSCS_CHECK_TABLE.
Kristian Waagan-4 wrote:
>
> Be aware that 10.3.1.4 and 10.3.2.1 had a corruption bug, mostly (or
> only) seen on Windows.
>
Can you point me to inform
e to a solution.
jrgchip wrote:
>
> I have a "Product" table with a "Num" column that contains a record that
> is only accessible by some SQL and not others.
>
--
View this message in context:
http://www.nabble.com/Record-not-found-in-some-SQL---Bug--tp21700110
I have a "Product" table with a "Num" column that contains a record that is
only accessible by some SQL and not others. I have tested this by JDBC
access from my Java app as well was from IJ directly.
ij> select "Num", length("Num") as "Len" from app."Product" where "Num" like
'HG1549%';
Num
