problem with dbexport and float fields
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------ =_NextPart_000_01BE5A95.A9D6FE80
Content-Type: text/plain
Hello everyone.
I am having problems with a dbexport
I am exporting a database with a single table with a single row.
The table consists of 77 columns about 60 of which are of type FLOAT.
The single row has a few char fields that are populated with chars
and everyone of the FLOAT fields contains a zero.
I know this because I typed the data in myself.
I am doing this on AIX 4.1.5 using INFORMIX SQL 6.05 (ONLINE)
The dbexport consistently core dumps when exporting this database.
The unload file produced consists of a single row (as expected) but each
float contains -1e
If I try unloading this in SQL then each float field contains
0.000000e+00 (which is what the export should produce)
I also happen to have a SCO box where this is not a problem
IS this a bug under AIX. There is nothing in the release notes. Has
anyone else encountered this ??
comments very welcome
Rekaish Bhardwaj
Computer Answers International Limited
9 The Courtyard
Warwick Road
Solihull
West Midlands B91 3DA
United Kingdom
Tel: +44 (0) 121 703 0300
Fax +44 (0) 121 703 0399
Mobile: +44 (0) 498 765424
Email: rekaishb@compans.com
------ =_NextPart_000_01BE5A95.A9D6FE80
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+Ii8QAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAAzwcCABEAEAAyAC0AAwBbAQEggAMADgAAAM8HAgAR
ABAAMgAtAAMAWwEBCYABACEAAAA4NEUwRDI0RjI3QzZEMjExQUE0RTAwMTA0QjA2NzlBMwAHBwEE
gAEAJwAAAHByb2JsZW0gd2l0aCBkYmV4cG9ydCBhbmQgZmxvYXQgZmllbGRzAHUOAQ2ABAACAAAA
AQABAAEDkAYABAsAAC4AAAADAAOACCAGAAAAAADAAAAAAAAARgAAAABShQAAdBAAAB4ABIAIIAYA
AAAAAMAAAAAAAABGAAAAAFSFAAABAAAABQAAADguMDIAAAAAAwAFgAggBgAAAAAAwAAAAAAAAEYA
AAAAAYUAAAAAAAALAACACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAsABoAIIAYAAAAAAMAA
AAAAAABGAAAAAA6FAAAAAAAAAwABgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAAeACCAG
AAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMACIAIIAYAAAAAAMAAAAAAAABGAAAAABiFAAAAAAAA
HgAJgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAABAAAAAAAAAB4ACoAIIAYAAAAAAMAAAAAA
AABGAAAAADeFAAABAAAAAQAAAAAAAAAeAAuACCAGAAAAAADAAAAAAAAARgAAAAA4hQAAAQAAAAEA
AAAAAAAAAgEJEAEAAAD9AwAA+QMAAAcGAABMWkZ1LWKAggMACgByY3BnMTI1BjIA+Atgbmc3MTfS
NwFVMzYB6CACpAT0CQIAY2gKwHNldDB6IAhQbQ3gBgQF4AKAfbMKgAjIIDsJaQ4gOAojbxTBFAoK
FA4wNQKACoF1dmMAUAsDYwBBDwIB0DUDD3ALszE2IEhlbFEJACBldgSQeQIgZQYuCqIKgEkgYW0g
xRGwdguAZyBwA2ACYExlbQQgA/B0aBpQIOBkYmV4cAkRCuMaJdccJBrCG+FhAZFhEeAbhvcAkA8g
G0AgAZEfQR6cA2BydxnVVGgfVgWgAIFz4nQEIG9mIA9gIeEKQH5tBjEBoAhgBUAQACJydx5oDeAb
wQlwInJ0eXDBHnBGTE9BVCDpIEjzGoEjQSBmB9ERoidACJB8bGQEIBuwHhAkcxxAcPp1C2B0CYAb
hBGjGeQAcP8pYAxAGUcMQBIQJLMhYSVDXyfWIfEBkAuAJxJ6BJBvuRnXa24mwRuwBAAgHBD4Y2F1
HmEaQCTyKWAr8kUeAiALgCBteRHgbOZmGdUZ6WRvGsIu0wIgACBBSVggNC4xGC41IC9gGsJJTkaI
T1JNM1FTUUwjsIIuGDAgKE9OTDRAPEUpIPgcByH1CfB0bNZ5IeEkkWQjEHAbcSFgnwOgHUgu0x4G
IOl1bgkAvmEpYCfgH0EbATgwYylRfyH6ICo1UCcBHCEFkClBKfsvECORZQDQG8AO8DswNvP5LTQt
MStgMWoikC+hGYD/OvUyhzCxNNIr8TjBPxgn480s+DA1IEUzZStFMDVQPyQkLvEkIChxK/IcJXNo
nwhgRFE7xTXVGedscxkw7RGwcCUQA6B0SYIZYBvRyFNDTy8Qb3g4giSR/0JkBCAukCiBGvYxWwXw
LtM/G+A+wBrgOwAEgTMyLiD/IVEkkUvkJDAa0TCxK/IJcF8bQB5STBEHkE8QSCcCbu8ZkhlASWBG
8W4FoDsAKUCzCXEuxD8/GeQFoG0HgP8CMAQgGWIbgBkAVDFAawr0ZwzQAcEH8GVrC3BHgCDCQhGx
ZHdhahnkEjH/KQBTATMwAIBVEBHQL5BS8ppuHhBpAiAHQCBMB3D3G6AJgBnkOU8iEiEIcCTwmwsT
GgJXCsAD8GNrB/HLO0AZ5FMG8GloKRAJUMdcJAeQBUBNaWQPASghgEI5MSAzREEZ5HZVAwApQksa
wTJgTNtUQRkAOiArNDQ1UDBHPqAOIF9wNzAzRQAzM0UwGeRGYUsQYh8zOTo5GeRNGyA7gWH4NDmC
OCKgNjU0MjQZ5PZFAMADEDoXkSuRF5MpEHNQoVcjYkBUMQqwAIAu/1QxF5EOUBihFOAxZGgBaJFf
GIRV6heiGfMTIQBtYAAAAAMAJgABAAAAAwA2AAAAAAALAAIAAQAAAAIBMQABAAAATgEAAFBDREZF
QjA5AAEAAgCWAAAAAAAAADihuxAF5RAaobsIACsqVsIAAEVNU01EQi5ETEwAAAAAAAAAABtV+iCq
ZhHNm8gAqgAvxFoMAAAATkVXVE9XTgAvbz1Db21wdXRlciBBbnN3ZXJzIEludGVybmF0aW9uYWwg
TGltaXRlZC9vdT1CSVJNSU5HSEFNL2NuPVJlY2lwaWVudHMvY249UmFrYWlzaEIALgAAAAAAAACg
VNWsiYbSEaaSACCv+aNgAQByEu4DWgDSEaZiACCv+aNgAAAASS0OAAAAAAAALgAAAAAAAACgVNWs
iYbSEaaSACCv+aNgAQByEu4DWgDSEaZiACCv+aNgAAAASS0PAAAQAAAAhODSTyfG0hGqTgAQSwZ5
oycAAABwcm9ibGVtIHdpdGggZGJleHBvcnQgYW5kIGZsb2F0IGZpZWxkcwAAAB4AcAABAAAAJwAA
AHByb2JsZW0gd2l0aCBkYmV4cG9ydCBhbmQgZmxvYXQgZmllbGRzAAACAXEAAQAAABYAAAABvlqV
qMU2VceIxkUR0pZgAGAIc00mAABAADkAcPi/qZVavgEDAPE/CQQAAB4AMUABAAAACQAAAFJBS0FJ
U0hCAAAAAAMAGkAAAAAAHgAwQAEAAAAJAAAAUkFLQUlTSEIAAAAAAwAZQAAAAAADAP0/5AQAAAMA
gBD/////AgFHAAEAAAAzAAAAYz1HQjthPSA7cD1DT01QQU5TLkNPTTtsPU5FV1RPV04tOTkwMjE3
MTY1MDQ1Wi04MDYAAAIB+T8BAAAAbgAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAAAAAAAAAvTz1D
T01QVVRFUiBBTlNXRVJTIElOVEVSTkFUSU9OQUwgTElNSVRFRC9PVT1CSVJNSU5HSEFNL0NOPVJF
Q0lQSUVOVFMvQ049UkFLQUlTSEIAAAAeAPg/AQAAABEAAABSZWthaXNoIEJoYXJkd2FqAAAAAB4A
OEABAAAACQAAAFJBS0FJU0hCAAAAAAIB+z8BAAAAbgAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAA
AAAAAAAvTz1DT01QVVRFUiBBTlNXRVJTIElOVEVSTkFUSU9OQUwgTElNSVRFRC9PVT1CSVJNSU5H
SEFNL0NOPVJFQ0lQSUVOVFMvQ049UkFLQUlTSEIAAAAeAPo/AQAAABEAAABSZWthaXNoIEJoYXJk
d2FqAAAAAB4AOUABAAAACQAAAFJBS0FJU0hCAAAAAEAABzBQBL2plVq+AUAACDCA/taplVq+AR4A
PQABAAAAAQAAAAAAAAAeAB0OAQAAACcAAABwcm9ibGVtIHdpdGggZGJleHBvcnQgYW5kIGZsb2F0
IGZpZWxkcwAAHgA1EAEAAAA9AAAAPDUwNDZGN0EyMTVCN0QyMTFBQTQ5MDAxMDRCMDY3OUEzMEIw
RDFCQG5ld3Rvd24uY29tcGFucy5jb20+AAAAAAsAKQABAAAACwAjAAAAAAADAAYQFugPHQMABxCD
AwAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAEhFTExPRVZFUllPTkVJQU1IQVZJTkdQUk9C
TEVNU1dJVEhBREJFWFBPUlRJQU1FWFBPUlRJTkdBREFUQUJBU0VXSVRIQVNJTkdMRVRBQkxFV0lU
SEFTSU5HTEVST1dUSEVUQUIAAAAAAgF/AAEAAAA9AAAAPDUwNDZGN0EyMTVCN0QyMTFBQTQ5MDAx
MDRCMDY3OUEzMEIwRDFCQG5ld3Rvd24uY29tcGFucy5jb20+AAAAACSx
------ =_NextPart_000_01BE5A95.A9D6FE80--