[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[400guy]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from 400...@openoffice.org Fri Mar 26 16:42:03 
+ 2010 ---
Created an attachment (id=68564)
test data and results


-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[400guy]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from 400...@openoffice.org Fri Mar 26 16:39:35 
+ 2010 ---
Created an attachment (id=68563)
patch for review


-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[400guy]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from 400...@openoffice.org Fri Mar 26 16:36:48 
+ 2010 ---
Attachments coming ...

(*) A patch for consideration

(*) Package of test data and results

  - AA6411.MBR: DDL for table and a view.  

View AA6411V1 derives date and time from the timestamp and
char() of the timestamp, date, and time.  I think that the
char() columns represent the right answers, albeit sometimes
to more precision than OOo displays.

The char() columns deliver good results from V5R3 of target
system but not from V5R2.  I have received one opinion

that we do not care about V5R2.

  - AA6412.MBR:  DML creating some test data.  Nineteen rows.

  - use_OTools_DateTimeToTimestamp.ods: Result of importing
AA6411V1 into Calc.  I manually increased the precision of
column TS in the spreadsheet.


-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[400guy]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from 400...@openoffice.org Fri Mar 19 13:47:25 
+ 2010 ---
Created an attachment (id=68434)
similar results from OS/400 V5R2 and DEV300_m75


-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[400guy]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543


User 400guy changed the following:

What|Old value |New value

  Ever confirmed|  |1

  Status|UNCONFIRMED   |NEW





--- Additional comments from 400...@openoffice.org Fri Mar 19 13:44:43 
+ 2010 ---
Conclusion:  I recommend that this issue be confirmed.


I have managed to create situations very much like what I have noticed
in danros66's attachments.  This happens with OS/400 V5R2 using
database and spreadsheet interfaces of a lightly hacked non-production
local build of DEV300_m75.  As the results are consistent across OOo
interfaces, I am not providing quite the step-by-step instructions
that rainerbielefeld asked for above.


Database setup on AS/400


I defined my test file with an SQL statement in member QALLSRC(AA6411)

create table aa6411 (
  keyfield intnot null   primary key,
  ts   timestamp  not null,
  comment  char(30)
  );

invoked with CL statement 

RUNSQLSTM SRCFILE(QALLSRC) SRCMBR(AA6411) COMMIT(*NONE)


I populated the thest file with SQL statments in member QALLSRC(AA6412)

delete from aa6411;

insert into aa6411 values( 1, '1990-03-02-08.30.00.10',
  'copied from V5R2 manual'   );
insert into aa6411 values( 2, '2008-10-01-10.41.54.09',
  'danros66 got time 10:42'   );
insert into aa6411 values( 3, '2008-10-01-10.41.52.305824',
  'danros66 got time 10:51'   );
insert into aa6411 values( 4, '2008-10-01-10.41.54.306208',
  'danros66 got time 10:44'   );

invoked with CL statment

RUNSQLSTM SRCFILE(QALLSRC)
  SRCMBR(AA6412)
  COMMIT(*NONE)


Using isql, part of DB2 on Linux, I retrieved the table, showing the
expected values

SQL> select * from aa6411
++---+---+
| KEYFIELD   | TS| COMMENT   |
++---+---+
| 1  | 1990-03-02 08:30:00.10| copied from V5R2 manual   |
| 2  | 2008-10-01 10:41:54.09| danros66 got time 10:42   |
| 3  | 2008-10-01 10:41:52.305824| danros66 got time 10:51   |
| 4  | 2008-10-01 10:41:54.306208| danros66 got time 10:44   |
++---+---+
SQLRowCount returns -1
4 rows fetched


I have a prexisting ODBC connection defined to the AS/400.


Observations in OpenOffice
--

I created an OOo database using a previously defined ODBC connection.

In OOo Base SQL View, I created query "simplest" from SQL statement

select * from AA6411

which returns, give-or-take my typing mistakes, the incorrect values
that danros66 reported ...

KEYFIELD  TS  COMMENT
  --  --
1 02/03/90 08:39  copied from V5R2 manual
2 01/10/08 10:42  danros66 got time 10:42
3 01/10/08 10:51  danras66 got time 10:51
4 01/10/08 10:44  danros66 got time 10:44


In Calc, I opened a new workbook, pressed F4, drilled down, and
dragged the query into the worksheet, getting the same incorrect
result.  I shall attach the resulting workbook.


My local hacks to OpenOffice


(*) I have removed "typedef int BOOL;" from iodbcunix.h as it is in my
Ubunty Hardy installation and copied the result to
connectivity/inc/iodbcunix.h and dbaccess/inc/iodbcunix.h

(*) svl/source/misc/inettype.cxx incorporates sb's patch for issue
109146 and the unreferenced routine tje_20100316() quoted in
.

(*) From sw/source/filter/asc/parasc.cxx I have deleted lines 259 and
260, to avoid the assertion described in issue 109179.



-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


---

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[400guy]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543


User 400guy changed the following:

What|Old value |New value

  CC|'mechtilde,rainerbielefeld|'400guy,mechtilde,rainerbi
|' |elefeld'





-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[danros66]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from danro...@openoffice.org Sun Sep 13 17:16:41 
+ 2009 ---
Created an attachment (id=64742)
I discovered that the same problem in finding the data from DB2 on the PC. I 
enclose an example of the differences between Calc and Excel. This can simplify 
your test


-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[danros66]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from danro...@openoffice.org Sun Sep 13 17:15:32 
+ 2009 ---
Created an attachment (id=64741)
I discovered that the same problem in finding the data from DB2 on the PC. I 
enclose an example of the differences between Calc and Excel. This can simplify 
your test


-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[danros66]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from danro...@openoffice.org Mon Aug 24 16:29:13 
+ 2009 ---
A virtual machine is impossible for me

I tried to put on internet an old AS400 but its raid-card battery is dead and
AS400 doesn't work.

For security consideration is impossible to put our production machine on
internet

So, I could extract through calc and excel specific data that you suggest me
or I could test a special version of OOo...


I know it's a small thing but I haven't other idea at the moment

-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[fs]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from f...@openoffice.org Mon Aug 24 09:17:18 + 
2009 ---
a virtual machine, set up to show the problem, would *tremendously* help :)

-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[danros66]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from danro...@openoffice.org Mon Aug 24 08:45:15 
+ 2009 ---
What do you need?
How can I help you?


-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[mechtilde]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543


User mechtilde changed the following:

What|Old value |New value

  CC|'rainerbielefeld' |'mechtilde,rainerbielefeld
|  |'





--- Additional comments from mechti...@openoffice.org Fri Aug 21 08:09:27 
+ 2009 ---
I see no chance to be able ro reproduce this problem.

As far as I know there are no further people working with this combination 
AS/400 Database via ODBC and OpenOffice.org.

So we need your special knowledge to analyse and to solve the problem.





-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[rainerbielefeld]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543


User rainerbielefeld changed the following:

What|Old value |New value

  CC|''|'rainerbielefeld'

Keywords|  |oooqa

Priority|P1|P3

 Version|OOo 3.1   |OOo 3.0 RC1





--- Additional comments from rainerbielef...@openoffice.org Fri May 22 
16:24:54 + 2009 ---
Not P1 (we would have heard some more noise here ...)

@danros66:
Please
- do not modify version, where problem has been observed first time
- read our guidelines on
   and  
  , then
  contribute a clear step by step instruction containing all observations (error
  messages ...), _every_key_press_and_every_mouse_click_ how to reproduce the   
  problem, and explain why you believe that your results are unexpected.

-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[danros66]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543


User danros66 changed the following:

What|Old value |New value

 Version|OOo 3.0   |OOo 3.1





--- Additional comments from danro...@openoffice.org Thu May 14 13:34:37 
+ 2009 ---
Please look this issue.
Now I added a new information

Thanks
Best Regard

-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[danros66]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from danro...@openoffice.org Thu May 14 13:30:56 
+ 2009 ---
Created an attachment (id=62266)
I found that the difference is always a multiple of a constant value and this 
multiple is between 0 and 63


-
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: issues-unsubscr...@dba.openoffice.org
For additional commands, e-mail: issues-h...@dba.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[danros66]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543


User danros66 changed the following:

What|Old value |New value

 Version|OOo 3.0 RC1   |OOo 3.0





-
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]

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[danros66]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from [EMAIL PROTECTED] Wed Oct  1 19:45:05 + 
2008 ---
Created an attachment (id=56962)
Basic timestamp value for better understand the problem


-
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]

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[danros66]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543
 Issue #|94543
 Summary|Error on importing a timestamp field from AS-400 via O
|DBC
   Component|Database access
 Version|OOo 3.0 RC1
Platform|PC
 URL|
  OS/Version|Windows XP
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|DEFECT
Priority|P1
Subcomponent|none
 Assigned to|dbaneedsconfirm
 Reported by|danros66





--- Additional comments from [EMAIL PROTECTED] Wed Oct  1 15:51:50 + 
2008 ---
Strange conversion on a time-stamp field imported from an AS/400 Database via 
ODBC.

The same wrong conversion is in Calc and in Base.

Other program that use the same ODBC (pe Excel) perform the correct conversion.

I attached a file in calc with an example

-
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]

[dba-issues] [Issue 94543] Error on importing a times tamp field from AS-400 via ODBC

[danros66]

To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94543





--- Additional comments from [EMAIL PROTECTED] Wed Oct  1 15:53:13 + 
2008 ---
Created an attachment (id=56959)
Example error on importing a timestamp field from AS-400 via ODBC


-
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]