Required Parameters Only
call td_analyze ( 'adaptivehistogram', 'database = val_source; tablename = customer; columns = income;' );
Two Columns with Different Numbers of Bins
call td_analyze ( 'adaptivehistogram', 'database = val_source; tablename = customer; columns = income, age; bins = 5, 3;' );
Output Table and Several Optional Parameters
Specifies an output table and the optional parameters spikethreshold, subdivisionthreshold, subdivisionmethod. A SELECT statement displays the output table, whose ORDER BY clause is critical to interpreting the resulting sub-bins correctly.
call td_analyze ( 'adaptivehistogram', 'database = val_source; tablename = customer; columns = income; bins = 5; spikethreshold = 12; subdivisionthreshold = 24; subdivisionmethod = quantiles; where = cust_id > 0; outputdatabase = val_results; outputtablename = adaptive_example3;' ); SELECT * FROM val_results.adaptive_example3 ORDER BY 1,2,3,5,4;