I have a file which contains the Serial number .The total number of serial number may be 10 or 100 or 10000 or more.
So I am using this serial number and fetching the data from sql server.There is simple select statement and in that IN clause I am passing these serial number.BUt there is limitation of IN clause. We can pass 1000 record only.
So I have to capture 1000's record from file and pass into SQL statement and then again pass next 1000 serial number.
How can I do it in Unix Shell script ?
Could you please help.