The following enhancements have been made to the R:BASE 11 functions:
•New CVAL('LAST_MOD') function to return the date and time stamp (text) for the last modification made to the database data
SET VAR vLastMod TEXT = (CVAL('LAST_MOD'))
•New CVAL('LAST_SCHEMA_MOD') function to return the date and time stamp (text) for the last modification made to the database schema
SET VAR vLastSchemaMod TEXT = (CVAL('LAST_SCHEMA_MOD'))
•New FISHER statistical function to return the Fisher transformation. This transformation produces a function that is normally distributed rather than skewed.
SET VAR vFisherResult DOUBLE = (FISHER(0.063))
•New RANKAVG statistical function to return the statistical rank of a given value, within a supplied array of values
SET VAR vRankAvg DOUBLE = (RANKAVG('1534','Score','TestScores',1))
•New RANKEQ statistical function to return the statistical rank of a given value, within a supplied array of values
SET VAR vRankEQ DOUBLE = (RANKEQ('80,000','InvoicePrice','CarSales',1))
•Enhanced SELECT... LISTOF(ColName) function to support up to 10,000 characters
•New CVAL('QUALKEY TABLES') function to return tables which contain a QualKey column
SET VAR vQualkeyTables TEXT = (CVAL('QUALKEY TABLES'))
•New CVAL('QUALKEYS') function to return columns assigned as a QualKeys
SET VAR vQualkeyColumns TEXT = (CVAL('QUALKEYS'))
•New CVAL('DBCOMMENT') function to retrieve the comments for a connected database
SET VAR vDBComment TEXT = (CVAL('DBCOMMENT'))
•Enhanced CTXT function to support capturing VARCHAR data to a TEXT string
•Enhanced SFIL function which can fill a NOTE data type value to the maximum size limit of 10,000 characters (was 4,092)
