Shell Programming and Scripting

Hi porter
Should I be storing the data from csv file in a variable?

I use sybase

Thanks

I thought you would be reading the data from the separate columns then generating the "insert" SQL statements.

IMHO, If your goal is to select the first column out of your csv/xls file, and then use it in a stored procedure, I would suggest that you use awk to extract out the first column into a flat file, load that file into a temp table and then reference the temp table from your stored procedure.

Not sure how many rows you will have in thie csv/xls file, but the more rows you will have, the tricky it will be to pass it into the stored procedure. Look for a more robust solution.

Hi porter

sorry, I would not be doing any "insert" SQL statement.

I need to
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.

I hope I make my question clear

Thanks

this is one way how you get your first column data

Code:

# cut -f1 -d"," < csvfile | paste -sd","
1234,2345,3345

you just have to assign the select statement to a variable using the above method

Code:

cmd="select * from table where id in ( `the above command` )"
isql -uUser -Sserver <options> << EOF
 exec procedure $cmd
EOF

Since you are beginner to shell, you can read up some tutorial first. see here for some tutorials