Re: How to LOAD selected columns from a delimited file?
use dbload
On Mar 25, 1:42pm, Matt Reprogle wrote:
} Subject: How to LOAD selected columns from a delimited file?
} I have searched the docs, but cannot find out how use the LOAD command
} to insert selected columns from a delimited file. Example:
}
} data.psv (input file)
} -----------
} ID|PRODUCT|VAL1|VAL2|VAL3
} 24|XYZ|1.2|3.4|5.6
}
} columns in table "tests":
} -------------------------
} id
} product
} val1
} val3
}
} I want to do something like (%%bad syntax alert!%%):
} load from "data.psv" columns(ID,PRODUCT,VAL1,VAL3) insert into tests
}
} or
}
} load from "data.psv" insert into tests(id,product,val1,NULL,val3)
} or
} load from "data.psv" insert into tests(id,product,val1,,val3)
}
} The first one is bad syntax, and the last two fail when executed.
} Is something like this possible, or do I have to strip the unwanted
} columns from the input file first to make it match the table?
}
} TIA,
}
} --
} Matt Reprogle
} Delco Electronics - IC Integrated Manufacturing phone:(317)451-9651
} mcreprog@koicew00.delcoelect.com FAX: (317)451-8230
}-- End of excerpt from Matt Reprogle