Unanswered: sybase bcp out clean records using bash shell script
Is it possible to achieve this on bash shell script on ASE version 12.5 running in linux platform. I'm trying to extract good records from bad table on a huge table with 6+ millions rows. I'm looking to craft a bash script that will accomplish this along with BCP command to pullout good records, I'm worried about the bad records that will encounter upon running the BCP out. Is this achievable using bash shell script and bcp? How will bcp out handle error upon encountering bad data?error handler on script if any? logic to be insert on the script if the bcp encounters an error on the data?
hoping you could give some sample scripts of yours if you have one.