Sybase IQ 12.7 ESD #2 supports using a BCP character file as input to the LOAD TABLE command. For syntax and usage updates to the LOAD TABLE information in Chapter 7, “Moving Data In and Out of Databases” of the Sybase IQ System Administration Guide, see “LOAD TABLE supports BCP files as input [CR 437332]”.
The LOAD TABLE FORMAT BCP feature in Sybase IQ 12.7 ESD #2 eliminates the need for special handling of dates in Adaptive Server Enterprise BCP OUT files. The section “Ensuring accurate dates” in the section “Matching Adaptive Server Enterprise data types” in Chapter 7, “Moving Data In and Out of Databases” can be ignored and has been removed from the chapter for future releases.