#!/bin/bash

function replaceDate()
{
sed 's/TO_DATE/CONVERT/g' $file >> $newFile
sed 's/TO_CHAR/CONVERT/g' $newfile>> $newFile
}

#Datatype conversion
function replaceWord()
{
sed 's/VARCHAR2/VARCHAR/g' $file >> $newFile
sed 's/NUMBER/NUMERIC/g' $newfile >> $newFile2
sed 's/DATE/DATETIME/g' $newFile2 >> $file

}
function menu()
{

echo "This program will convert Oracle schemas into SYBASE schemas."

}


menu

read -p "Please enter the file name that you wish to convert?" file
read -p "Please enter the name of the new file?" newFile


        replaceDate
        replaceWord