We have a database called "ZIM" (some kinda Order Tracking Database) we'd like to know how to dump the information in this database to
tab/colon delimited text files.
We had a look around the file system (SCO) and found some datafiles (zim0001, zim0002 zim0003 etc..) a bit obscure, but then we found text for
a procedure, It's not SQL, but might give someone a clue as to what the database engine is. There is a directory for Ingres but it is empty, and
Ingres doesn't appear to be running.
%-comments are here
local (lCode, lCount, lVersion)
find all items where type = 'M' -> sall
sort by stockcode
find all where $distinct(stockcode) = stockcode -> sall
let lCount = $setcount
let lCode = stockcode
etc....... etc..... etc.........
Has anyone got any ideas on What the database is? And more importantly how to dump ALL the data to text files
so we can migrate to another platform/Database.