Hi, list.
I currently have 2 zVM 4.4 partitions running in a zSeries. One of them is running in an IFL.
Under my zVM IFL system I have installed:
- SLES9
- DB2 ESE 8
and have connected DB2 ESE to my existing DB2 in the CP zVM.
I have successfully migrated my DB2/VM database into DB2 ESE under SLES9 and I have connected DB2 VM with DB2 ESE to be able to query my database under LINUX. But to my surprise all the CHAR and DATE type fields are returned only half of their length, that is:
- CHAR(20) returns a CHAR(10) string.
- CHAR(9) returns a CHAR(5) string.
- DATE returns a 5 char long date string. (e.g. "2005-")
DECIMAL fields do not have this problem.
Has anyone had the same (or similar) problem ?
Any ideas will be very welcome.
Greetings,
José Raúl Barón
I currently have 2 zVM 4.4 partitions running in a zSeries. One of them is running in an IFL.
Under my zVM IFL system I have installed:
- SLES9
- DB2 ESE 8
and have connected DB2 ESE to my existing DB2 in the CP zVM.
I have successfully migrated my DB2/VM database into DB2 ESE under SLES9 and I have connected DB2 VM with DB2 ESE to be able to query my database under LINUX. But to my surprise all the CHAR and DATE type fields are returned only half of their length, that is:
- CHAR(20) returns a CHAR(10) string.
- CHAR(9) returns a CHAR(5) string.
- DATE returns a 5 char long date string. (e.g. "2005-")
DECIMAL fields do not have this problem.
Has anyone had the same (or similar) problem ?
Any ideas will be very welcome.
Greetings,
José Raúl Barón