Quality is delighting customers
1.select * from tablename where colunmname="value"
2.select * from tablename where colunmname between value1 and value2
3.create procedure procedurename (@Param1 datatype, ...@Paramn datatype)
//we r using multiple table
i.e select * from TABLE_name;
BETWEEN value1 AND value2
3>CREATE [OR REPLACE] PROCEDURE proc_name [list of parameters]
EXECUTE [or EXEC] procedure_name;
to search a data select * from <db name> when <field name = data/value>;
1. Select * from TableName where ColumnName Like '%PARTIALVALUE%'
2. Select * from TableName where Date Between '01-01-2000' and '01-01-2010'
You have to iterate the list of tables and for each table you have to iterate each column and perform an exist query against it.
You will need three types of queries due to the data types i.e. string, number and date and time.
When constructing a query or a filter, you need to tell Access what to look for in mainframe modernization To find values in a range of numbers type the expression