I want to BCP out a table in to a flat file which is around 1.5GB. I want to bcp out a subset of data each time because of space issue. What are the different approaches to do this. Just keep in mind i can't create views in database. I tried with following command but i am getting syntax error saying syntax near keyword 'where'. database server is sybase 11.9.2
bcp "select * from table where date = 20010101" out /home/flatfile -Uuser Sserver -c
Could anyone help me.