@echo off

db2 connect to BankData user %1 using %2

db2 insert into Customer (customernumber, name, taxid) values (1, 'Customer1', 'SSN1')
db2 insert into Customer (customernumber, name, taxid) values (2, 'Customer2', 'SSN2')
db2 insert into Customer (customernumber, name, taxid) values (3, 'Customer3', 'SSN3')
db2 insert into Customer (customernumber, name, taxid) values (4, 'Customer4', 'SSN4')
db2 insert into Customer (customernumber, name, taxid) values (5, 'Customer5', 'SSN5')
db2 insert into Customer (customernumber, name, taxid) values (6, 'Customer6', 'SSN6')
db2 insert into Customer (customernumber, name, taxid) values (7, 'Customer7', 'SSN7')
db2 insert into Customer (customernumber, name, taxid) values (8, 'Customer8', 'SSN8')
db2 insert into Customer (customernumber, name, taxid) values (9, 'Customer9', 'SSN9')

db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 1000.00, 1, 1)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 500.00, 2, 1)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 900.00, 3, 1)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 2000.00, 4, 1)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 3000.00, 5, 1)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 700.00, 6, 1)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 9000.00, 7, 1)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 1500.00, 8, 1)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 250.00, 9, 1)

db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 1000.00, 11, 2)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 500.00, 12, 2)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 900.00, 13, 2)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 2000.00, 14, 2)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 3000.00, 15, 2)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 700.00, 16, 2)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 9000.00, 17, 2)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 1500.00, 18, 2)
db2 insert into Account (type, balance, accountnumber, accountsinverse_customernumber) values (1, 250.00, 19, 2)



db2 connect reset

db2 terminate

title Command Prompt