Unanswered: reading from csv file and use the data in stored procedure
I am trying to accomplish the following tasks
1. use shell script to read the first column of data in csv file
2. pass the data to a sybase stored procedure using shell script
3. in the stored procedure, I would have a "select" SQL statement (i.e select * from db where id in (1234,2345,....))
1234,2345... are data from the first column of the csv file.
Can someone give me some example/advice on how to go about solving this problem?