Extracting data from an unknown SCO Unix database (for Remanco POS)

Hi

I'm trying to extract data from a POS system called Ramenco. Apparently this is running on SCO Unix, possibly with a SQLTurbo (?) back end

Data is already being extracted from one table with a scipt like the following:


#set -x
. /usr/local/bin/setit.term
. /usr/local/bin/setit

rm DBtmp
echo "
lines 0
select somecolumns
from sometable
where something = somethingelse
into DBTmp
/" | SQL

cat DBTmp | awk 'BEGIN {FS="|"}{if ( $3 == 1||2||3 ) print $3 "," $1 "," $2 "," $4 "," $5 }' >RemncoDB.CSV
rm DBTmp


..... then some more code to FTP RemancoDB.CSV to a windows box.




I think I have a basic understanding of what the script is doing. I need to extract data from a different table. To do that I need to interrogate the database and find out some table names and columns, and to do that I need to:

1. Work out what kind of database server it is (cant find SQLTurbo on the net)
2. How do I get some kind of interactive command line into it?
3. What commands do I use to list all of the tables and fields in the database?

Thanks,

NickStart Free Trial