How do I bcp null dates in Sybase?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How do I bcp null dates in Sybase?

As long as there is nothing between the field delimiters in your data, a null will be entered. If there's a space, the value will be Jan 1, 1900.

You can use sed(1) to squeeze blanks out of fields:
sed -e 's/|[ ]*|/||/g' old_file > new_file

(Continued on next question...)

Other Job Interview Questions

• The Basics of Connecting to Sybase
• What is the best value for cschedspins?
• What applications is ASA good for?
• Can Two Tasks Be Assigned to the Same Partition in Sybase?
• How can you change to get the decimal separator as comma instead of the decimal point (.)?
• How Can I Run the ASE Upgrade Manually?
• How Do I Choose Which Tables To Partition in Sybase?
• When are stored procedures compiled in Sybase ?
• State some of the products of Sybase?
• How do I exclude a column in Sybase ?
• More...