Qmf for Windows 8.1 fp18 – date datatype from db2 z/os 8 format error in excel 2003

5 pts.
Tags:
IBM DB2
Microsoft Excel 2003
Microsoft Excel formulas
QMF
QMF V8
Windows XP SP2
z/OS
When I import a DB2 z/OS query result  containing date or date(timestamp) columns from QMF for WINDOWS in EXCEL 2003 using the Add-in the cells cannot be formatted. In the same column the date are displayed sometimes as dd/mm/yyyy, sometimes as nnnnn or in the previously defined format (example dd-month ) if exists. The first format can't be modified, unless double cliking the cell without updating, the wrong cells are contiguous and occasionally there are blocks of  contiguous cells with the correct format, for example on the same day. The same report loaded in excel using the QMF function "Display Excel Sheet (ctrl + B )" works properly. Everything is correct with QMF for W 8.1 FP10. Thanks in advance !

Software/Hardware used:
qmf for windows db2 z/os 8 NFM Windows XP SP2 Excel 2003

Answer Wiki

Thanks. We'll let you know when a new response is added.

fine

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Meandyou
    The first place I would check is the data itself. Run your query on z/OS, using SPUFI or QMF or what have you. Compare the results from this with the results you are getting from QMF for Windows. When DB2 returns a DATE, she will return it in the format specified in the query or the default of your DB2 system (ISO, JIS, etc). My point being that one DATE column in the result set might have a different format than another DATE column. A DATE column would never be represented by nnnnn. This sounds more like the result of subtracting one date from another. The result of such a calculation is NOT a DATE, but is a duration.
    5,220 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following