problem with dbexport and float fields
Posted in 1999
Topics: Server Administration, Migration, Import/Export & Data Conversion, Platform-Specific Issues, Third-Party Tools & Monitoring
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--