Hi,

We have a big table with 168 columns containing +/- 55000000 records. We transfer this table from a Sybase IQ server to another Sybase IQ using the load table in binary through named pipes.


1 - We execute a "select * from table" with options temp_extract_name1, temp_extract_binary and temp_extract_null_as_zero correctly configured. And we receive during the load the following error :
Error -157
Cannot convert to date(4) (column X).
IMPORTANT, this error occurs only on the table with 168 columns. We didn't receive any errors with the another tables. The speed of load is +/- 8 seconds for 500000 records.

2 - We execute a "select <all columns specified here> from table " with options temp_extract_name1, temp_extract_binary and temp_extract_null_as_zero correctly configured. And we didn't receive this error. The speed of load is very slow +/- 200 seconds for 500000 records !!!

What happens ?
What is the difference between the first select and the second ?

Thank you for your help,
Xavier