Sqlite table question

We have Cloverleaf 5.7 running on AIX.

I’m trying to create a simple 2 column table via the command line.

I create the table, create the columns with definitions, and insert a couple of rows.  When I query the table, all looks good.

I exit sqlite.  When I restart a session, the table is not there!  

So, what step am I missing??

create table main.FNB_MRN (fnb_cust_num varchar(15), nmh_mrn_num varchar(9));

sqlite> insert into main.FNB_MRN (‘1234567′,’876543’);

sqlite> insert into main.FNB_MRN values (‘2345678′,’987654’);

sqlite> select * from main.FNB_MRN;

1234567|876543

2345678|987654

…after I restart an sqlite session:

select * from main.FNB_MRN;

SQL error: no such table: main.FNB_MRN  

❓