dbexport error/bug
Netters,
i've come across some bugs/limitations on the dbeport command that i
think are related to the number of columns in a table. does anyone
know if these are truely bugs? if so, when will they be fixed?
for example:
The following table will cause dbexport to get a Bus error - core dump.
CREATE TABLE "informix".asic_bible2 (
spec_group CHAR (2), { }
time_stamp DATETIME YEAR to SECOND, { }
status CHAR (1), { }
option_dev_no SERIAL NOT NULL, { }
issue_no CHAR (10), { }
reason CHAR (30), { }
device CHAR (16), { }
engineer CHAR (6), { }
project CHAR (10), { }
release_to_prod CHAR (1), { }
ciruit_desc CHAR (30), { }
customer CHAR (16), { }
wafer_start_qty INTEGER, { }
gen_shop_order CHAR (1), { }
mask_shop CHAR (10), { }
mask_no CHAR (6), { }
start_material CHAR (16), { }
pal_code CHAR (4), { }
mrps_code CHAR (6), { }
prod_line CHAR (16), { }
source_type CHAR (16), { }
woo_no CHAR (16), { }
die_no CHAR (16), { }
wafer_size INTEGER, { }
die_size_x DECIMAL (12,3), { }
die_size_y DECIMAL (12,3), { }
test_time CHAR (15), { }
pos_die_per_waf DECIMAL (12,2), { }
wafer_proc_yld DECIMAL (12,2), { }
probe_yld DECIMAL (12,2), { }
scribe_hp DECIMAL (12,2), { }
assembly_yld DECIMAL (12,2), { }
final_test_yld DECIMAL (12,2), { }
cum_dev_waf DECIMAL (12,2), { }
no_leads INTEGER, { }
package_type CHAR (16), { }
bom CHAR (16), { }
base_part CHAR (16), { }
lid_part CHAR (16), { }
die_hi_power_no CHAR (16), { }
wb_diag CHAR (16), { }
assy_flow CHAR (16), { }
twelve_m_no CHAR (16), { }
tool_outline_no CHAR (16), { }
obs_mask_set CHAR (20), { }
dest_obs_layers CHAR (20), { }
new_mask_set CHAR (20), { }
stck_new_layers CHAR (20), { }
engring_mask CHAR (1), { }
production_mask CHAR (1), { }
prod_engring CHAR (4), { }
prod_engring_dt DATE, { }
prod_control CHAR (4), { }
prod_control_dt DATE, { }
mos_vi CHAR (4), { }
mos_vi_dt DATE, { }
acct_fin CHAR (4), { }
acct_fin_dt DATE, { }
doc_central CHAR (4), { }
doc_central_dt DATE, { }
prod_engr CHAR (4), { }
prod_engr_dt DATE, { }
writer CHAR (4), { }
writer_dt DATE, { }
cad CHAR (3), { }
pkg CHAR (3), { }
asic_cust CHAR (3), { }
marking_code CHAR (2), { }
wire_bond_doc CHAR (16), { }
ref_group CHAR (10), { }
flag_cav_x DECIMAL (8,3), { }
flag_cav_y DECIMAL (8,3), { }
flow_id CHAR (2), { }
mquad_vent_part CHAR (16), { }
tray_rail_part CHAR (16), { }
pad_expoxy_part CHAR (16), { }
frame_part CHAR (16), { }
array CHAR (16), { }
mcr CHAR (3) { }
)
IN rootdbs
EXTENT SIZE 16
NEXT SIZE 16
LOCK MODE PAGE
;
REVOKE ALL ON "informix".asic_bible2 FROM "public";GRANT SELECT,UPDATE,INSERT,DELETE,INDEX
ON "informix".asic_bible2 TO public AS informix;
The following table causes dbexport to get a Memory Fault -
core dump.
CREATE TABLE "edi".att_correlation (
correlated_time CHAR (20), { }
fad_total_recs INTEGER, { }
fad_supplier INTEGER, { }
fad_division INTEGER, { }
fad_device INTEGER, { }
fad_customer_dev INTEGER, { }
fad_dev_desc INTEGER, { }
fad_waf_p_tech INTEGER, { }
fad_chip_length INTEGER, { }
fad_chip_width INTEGER, { }
fad_waf_p_id INTEGER, { }
fad_waf_p_loc INTEGER, { }
fad_waf_p_lin INTEGER, { }
fad_package_code INTEGER, { }
fad_pkg_material INTEGER, { }
fad_pkg_type INTEGER, { }
fad_assm_loc INTEGER, { }
fad_package_line INTEGER, { }
fad_pkg_lead_count INTEGER, { }
fad_score DECIMAL (15,5), { }
aoq_total_recs INTEGER, { }
aoq_month_year INTEGER, { }
aoq_supplier INTEGER, { }
aoq_division INTEGER, { }
aoq_test_id INTEGER, { }
aoq_test_desc INTEGER, { }
aoq_device INTEGER, { }
aoq_customer_dev INTEGER, { }
aoq_mark_date_code INTEGER, { }
aoq_lot_number INTEGER, { }
aoq_dev_desc INTEGER, { }
aoq_waf_p_tech INTEGER, { }
aoq_waf_p_id INTEGER, { }
aoq_waf_p_loc INTEGER, { }
aoq_waf_p_lin INTEGER, { }
aoq_package_code INTEGER, { }
aoq_pkg_material INTEGER, { }
aoq_pkg_type INTEGER, { }
aoq_assm_loc INTEGER, { }
aoq_package_line INTEGER, { }
aoq_test_loc_name INTEGER, { }
aoq_pkg_lead_count INTEGER, { }
aoq_sample_size INTEGER, { }
aoq_total_rejects INTEGER, { }
aoq_reject_desc INTEGER, { }
aoq_lot_size INTEGER, { }
aoq_tst_submission INTEGER, { }
rap_total_recs INTEGER, { }
rap_quarter_year INTEGER, { }
rap_supplier INTEGER,