Hi Friends,

Can you help me please with some dos programming in win98 using
sqlloader?

I have sales files with date attached to it in my sales folder.
The file names look like this.

sales03012003.dat

The file content format (columns) are
store_no, total_items_sold,total_sales_amnt

001, 200, 1200.00
002, 250, 1500.00
.
.
.

separated by comma, corresponding to my daily_sales_table

store_no, total_items_sold, total_total_amnt, sales_date.

001 200 1200.00 03012003
002 250 1500.00 03012003

The input data does not contain sales_date, but it is to be taken
from the date attached to the file name. In unix I can capture the
date using the "cut" command and store it in a variable. But in
windows I do not know how.

Can you share me your knowledge in windows batch programming please?, on how to handle this problem. Or can you give me site where I could
learn batch programming in windows.

Thank you all in advance for your support.