To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63221
Issue #:|63221
Summary:|Creating a Table by drag'n'drop from calc
Component:|Database access
Version:|OOo 2.0.2
Platform:|PC
URL:|
OS/Version:|Windows 2000
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|rabund
------- Additional comments from [EMAIL PROTECTED] Wed Mar 15 07:24:56 -0800
2006 -------
I've dragged data from calc to a table in an database connected via ODBC to a
DB2/400 UDB. The creation came back with an error telling me, that the HLITSTRBU
would not be identical to the server.
For the name of the table I've entered HLITSTRBU.OOIMP2 which is a valid
combination for naming within DB2/400. I wanted to create table ooimp2 in
hlitstrbu schema.
You generated:
CREATE TABLE "HLITSTRBU"."ES_BUND"."IMPOO2" ("DIVSA" VARGRAPHIC(255) CCSID
13488,"DIVSF" VARGRAPHIC(255) CCSID 13488,"DISPRC" VARGRAPHIC(255) CCSID
13488,"DIVRKY" VARGRAPHIC(255) CCSID 13488,"DIF1" VARGRAPHIC(255) CCSID
13488,"DIKEY2" VARGRAPHIC(255) CCSID 13488,"DIVDAT" VARGRAPHIC(255) CCSID
13488,"DIF2" VARGRAPHIC(255) CCSID 13488,"DIVAKZ" VARGRAPHIC(255) CCSID
13488,"DIVSKZ" VARGRAPHIC(255) CCSID 13488,"DIDTAD" VARGRAPHIC(255) CCSID
13488,"DIDTUP" VARGRAPHIC(255) CCSID 13488,"DIUSUP" VARGRAPHIC(255) CCSID
13488,"DIIACS" VARGRAPHIC(255) CCSID 13488)
correctly it should be:
CREATE TABLE "HLITSTRBU"."IMPOO2" ("DIVSA" VARGRAPHIC(255) CCSID 13488,"DIVSF"
VARGRAPHIC(255) CCSID 13488,"DISPRC" VARGRAPHIC(255) CCSID 13488,"DIVRKY"
VARGRAPHIC(255) CCSID 13488,"DIF1" VARGRAPHIC(255) CCSID 13488,"DIKEY2"
VARGRAPHIC(255) CCSID 13488,"DIVDAT" VARGRAPHIC(255) CCSID 13488,"DIF2"
VARGRAPHIC(255) CCSID 13488,"DIVAKZ" VARGRAPHIC(255) CCSID 13488,"DIVSKZ"
VARGRAPHIC(255) CCSID 13488,"DIDTAD" VARGRAPHIC(255) CCSID 13488,"DIDTUP"
VARGRAPHIC(255) CCSID 13488,"DIUSUP" VARGRAPHIC(255) CCSID 13488,"DIIACS"
VARGRAPHIC(255) CCSID 13488)
In addition please be aware, that quoting names means, that there must exists a
perfect match between the case names are entered and the names as stored in the
DB. DB2, as most other DB Servers, normaly have names unquoted and converts them
to capital letters. Only when names are quoted the system does an exact match.
Therefore it could cause problems to quote.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
