Hi...

I have a text file in Unix server to import into Sybase database. But the value of one of the columns in file is null and I need put a default value in the table (Datetime, current time).

Ex.
Table:
Col1 char(5)
Col2 char(10)
Col3 DateTime


Bcp file in Unix.

10.0
3
1 SYBCHAR 0 5 "" 1 Col1
2 SYBCHAR 0 10 "" 2 Col2
3 SYBCHAR 0 8 "/n" 3 Col3


Text file in Unix


aaa Test
bbb Test
ccc Test


I need something like:

Col1 Col2 Col3
---- ---- ----
aaa Test 01/07/2005
bbb Test 01/07/2005
ccc Test 01/07/2005



help me?