create table Product (ApplNo int, ProductNo int, Form varchar, Dosage varchar, ProductMktStatus  

   create table Product (ApplNo int, ProductNo int, Form varchar, Dosage varchar, ProductMktStatus  

   varchar, TECode int, ReferenceDrug int, drugname varchar, activeingred varchar)

   int, TECode int, ReferenceDrug int, drugname varchar, activeingred varchar)

Note that originally, the TECode column was entered as ''int''; however, upon creating the command (see next question) to convert the files from <code>sed</code> to SQL  <code>insert</code> statements, I realized that because not everything in this code was an integer (SQL pointed this out to me with an instance of AA in the TECode column when I tried to insert the data into the SQL table) the command needed to be changed.  

Note that originally, the TECode column was entered as ''int''; however, upon creating the command (see next question) to convert the files from <code>sed</code> to SQL  <code>insert</code> statements, I realized that because not everything in this code was an integer (SQL pointed this out to me with an instance of AA in the TECode column when I tried to insert the data into the SQL table) the command needed to be changed.  

   create table Product (ApplNo int, ProductNo int, Form varchar, Dosage varchar, ProductMktStatus  

   create table Product (ApplNo int, ProductNo int, Form varchar, Dosage varchar, ProductMktStatus  

   varchar, TECode '''varchar''', ReferenceDrug int, drugname varchar, activeingred varchar)

   int, TECode '''varchar''', ReferenceDrug int, drugname varchar, activeingred varchar)

   create table Product (ApplNo int, ProductNo int, Form varchar, Dosage varchar, ProductMktStatus  

   create table Product (ApplNo int, ProductNo int, Form varchar, Dosage varchar, ProductMktStatus  

   varchar, TECode int, ReferenceDrug int, drugname varchar, activeingred varchar)

   int, TECode int, ReferenceDrug int, drugname varchar, activeingred varchar)

'''2. Provide the <code>sed</code> command sequences that you used to convert the raw text files into sequences of SQL <code>insert</code> statements.'''

'''2. Provide the <code>sed</code> command sequences that you used to convert the raw text files into sequences of SQL <code>insert</code> statements.'''

*For the Product text I used <code>wc Product.txt</code> which gave me <code>32771 369379 2856017</code>. This means that there are 32,770 entries in the Product file.

*For the Product text I used <code>wc Product.txt</code> which gave me <code>32771 369379 2856017</code>. This means that there are 32,770 entries in the Product file.