Here is a simple
BTEQ program that can be used to verify that the SAS Data Quality
Accelerator for Teradata is operational.
The code first lists
the locales that are installed in the QKB. Then it creates a table
and executes the DQ_GENDER() stored procedure on the table. Before
running the example, substitute a real value for the output_table_1, output_table_2,
and locale variables throughout
the program. For locale, use
one of the values returned by the DQ_LIST_LOCALES() stored procedure.
This example assumes that the SAS Data Quality Accelerator for Teradata
is using the QKB for Contact Information.
The CREATE VOLATILE
TABLE statement is used to create a temporary input table named Dqacceltest
that lasts for the duration of the SQL session. The example also sets
the SAS Data Quality Accelerator DQ_OVERWRITE_TABLE option to create
temporary output tables in the SAS Data Quality Accelerator session.
If you run the example again in the same SAS Data Quality Accelerator
session, the new output tables overwrite any existing output tables
and the output tables are automatically discarded at the end of the
session.
call sas_sysfnlib.dq_list_locales('mydb.output_table_1');
select * from mydb.output_table_1;
call sas_sysfnlib.dq_set_option('DQ_OVERWRITE_TABLE', '1');
create volatile table mydb.dqacceltest (id_num integer, name varchar(64))
unique primary index(id_num)
on commit preserve rows;
insert into mydb.dqacceltest (id_num, name) values (1, 'John Smith');
insert into mydb.dqacceltest (id_num, name) values (2, 'Mary Jones');
call sas_sysfnlib.dq_gender('Name', 'mydb.dqacceltest', 'name', 'id_num',
'mydb.output_table_2', 'locale');
select gender from mydb.output_table_2;
If the request was successful,
the SELECT statement produces an output table that contains this: