Micros database - New at DBISQL Syntax

[Uofmlisa]

I need to pull data out of some tables in a micros database and I am using DBISQL to get this data. I will end up writing a couple of stored procedures and creating a staging table for an interface that will run every other Friday. I have not gotten that far in the process yet but what I am having trouble finding is how to query the entire database I have for every table containing a certain field. A table that I am querying has a field called labor_week and has numbers listed in it. I know there has to be some type of table that holds that value as the key and will tell me what the numbers stands for but I cannot find it. Is there any way to query the database for all tables holding a certain field when using DBISQL from Micros.

 

[DrZogg]

Goto the Sybase installation on the Micros server, search for the CHM file, there are 2. It has more than you will ever need to know about Sybase SQL