# Funciones WebFOCUS
[https://ikax.net/tic/WebFOCUS/webfocus-functions.html](https://ikax.net/tic/WebFOCUS/webfocus-functions.html)[ikax.net](/ "ikax.net - Página principal")[TIC](/tic/ "ikax.net - TIC")[WebFOCUS](/tic/webfocus/ "ikax.net - WebFOCUS")
A continuación se referencian todas las funciones WebFOCUS de la versión 9.0.1 categorizadas e incluyendo una breve descripción, su sintaxis y el enlace con documentación en línea:
| Índice |
| ------------------------------------------------------------------------------------------------------------ |
| [01. Simplified Analytic Functions](#01-simplified-analytic-functions) |
| [02. Simplified Character Function](#02-simplified-character-function) |
| [03. Character Functions](#03-character-functions) |
| [04. Variable Length Character Functions](#04-variable-length-character-functions) |
| [05. Character Functions for DBCS Code Pages](#05-character-functions-for-dbcs-code-pages) |
| [06. Maintain-specific Character Functions](#06-maintain-specific-character-functions) |
| [07. Data Source and Decoding Functions](#07-data-source-and-decoding-functions) |
| [08. Simplified Date and Date-Time Functions](#08-simplified-date-and-date-time-functions) |
| [09. Date Functions](#09-date-functions) |
| [10. Date-Time Functions](#10-date-time-functions) |
| [11. Maintain-specific Date and Time Functions](#11-maintain-specific-date-and-time-functions) |
| [12. Simplified Conversion Functions](#12-simplified-conversion-functions) |
| [13. Format Conversion Functions](#13-format-conversion-functions) |
| [14. Maintain-specific Light Update Support Functions](#14-maintain-specific-light-update-support-functions) |
| [15. Simplified Numeric Functions](#15-simplified-numeric-functions) |
| [16. Numeric Functions](#16-numeric-functions) |
| [17. Maintain-specific Script Functions](#17-maintain-specific-script-functions) |
| [18. Simplified Statistical Functions](#18-simplified-statistical-functions) |
| [19. Machine Learning (Python-based) Functions](#19-machine-learning-python-based-functions) |
| [20. Simplified System Functions](#20-simplified-system-functions) |
| [21. System Functions](#21-system-functions) |
| [22. Simplified Geography Functions](#22-simplified-geography-functions) |
| [23. SQL Character Functions](#23-sql-character-functions) |
| [24. SQL Miscellaneous Functions](#24-sql-miscellaneous-functions) |
| [25. Trigonometric Functions](#25-trigonometric-functions) |
- ### 01. Simplified Analytic Functions
- **FORECAST_MOVAVE** Calculate a Simple Moving Average Column ```FORECAST_MOVAVE(display, infield, interval,npredict, npoint1)```
- **FORECAST_EXPAVE** Calculate a Single Exponential Smoothing Column ```FORECAST_EXPAVE(display, infield, interval,npredict, npoint1)```
- **FORECAST_DOUBLEXP** Calculate a Double Exponential Smoothing Column ```FORECAST_DOUBLEXP(display, infield,interval, npredict, npoint1, npoint2)```
- **FORECAST_SEASONAL** Calculate a Triple Exponential Smoothing Column ```FORECAST_SEASONAL(display, infield,interval, npredict, nperiod, npoint1, npoint2, npoint3)```
- **FORECAST_LINEAR** Calculate a Linear Regression Column ```FORECAST_LINEAR(display, infield, interval,npredict)```
- **PARTITION_AGGR** Generate Rolling Calculations Using PARTITION_AGGR ```PARTITION_AGGR([prefix.]measure,reset_key,lower,upper,operation)```
- **PARTITION_REF** Retrieve Prior or Subsequent Field Values for Use in a Calculation ```PARTITION_REF([prefix.]field, reset_key, offset)```
- **INCREASE** Calculate the Difference Between the Current and a Prior Value of a Field ```INCREASE([prefix.]field, offset)```
- **PCT_INCREASE** Calculate the Percentage Difference Between the Current and a Prior Value of a Field ```PCT_INCREASE([prefix.]field, offset)```
- **PREVIOUS** Retrieve a Prior Value of a Field ```PREVIOUS([prefix.]field, offset)```
- **RUNNING_AVE** Calculate Running Average Between the Current and a Prior Value of a Field ```RUNNING_AVE(field, reset_key, lower)```
- **RUNNING_MAX** Calculate Running Maximum Between the Current and a Prior Value of a Field ```RUNNING_MAX(field, reset_key, lower)```
- **RUNNING_MIN** Calculate Running Minimum Between the Current and a Prior Value of a Field ```RUNNING_MIN(field, reset_key, lower)```
- **RUNNING_SUM** Calculate Running Sum Between the Current and a Prior Value of a Field ```RUNNING_SUM(field, reset_key, lower)```
- ### 02. Simplified Character Function
- **CHAR_LENGTH** Return the Length of a String in Characters ```CHAR_LENGTH(string)```
- **CONCAT** Concatenate Strings ```CONCAT(string1, string2)```
- **DIFFERENCE** Measure the Phonetic Similarity Between Character String ```DIFFERENCE(chrexp1, chrexp2)```
- **DIGITS** Convert a Number to a Character String ```DIGITS(number,length)```
- **GET_TOKEN** Extract a Token Based on a String of Delimiters ```GET_TOKEN(string, delimiter_string, occurrence)```
- **INITCAP** Capitalize the First Letter of Each Word in a String ```INITCAP(input_string)```
- **LAST_NONBLANK** Return the Last Value That is Neither Blank nor Missing ```LAST_NONBLANK(field)```
- **LEFT** Return Characters From the Left of a Character String ```LEFT(chr_exp, int_exp)```
- **LOWER** Return a String With All Letters Lowercase ```LOWER(string)```
- **LPAD** Pad a Character String on the Left ```LPAD(string, out_length, pad_character)```
- **LTRIM** Remove Blanks From the Left End of a String ```LTRIM(string)```
- **OVERLAY** Replace Characters in a String ```OVERLAY(src, ins, start, len)```
- **PATTERNS** Return a String That Represents the Pattern Profile of the Input Argument ```PATTERNS(string)```
- **POSITION** Return the First Position of a Substring in a Source String ```POSITION(pattern, string)```
- **POSITION** Return the Position of a Search String in a Source String ```POSITION(search, source, start)```
- **REGEX** Match a String to a Regular Expression ```REGEX(string, regular_expression)```
- **REGEXP_COUNT** Count the Number of Matches to a Pattern in a String ```REGEXP_COUNT(string, pattern)```
- **REGEXP_INSTR** Return the Position of a Pattern in a String ```REGEXP_INSTR(string, pattern)```
- **REGEXP_REPLACE** Replace Matches to a Pattern in a String ```REGEXP_REPLACE(string, pattern, replacement)```
- **REGEXP_SUBSTR** Returning the First Match to a Pattern in a String ```REGEXP_SUBSTR(string, pattern)```
- **REPEAT** Repeat a Character String a Given Number of Times ```REPEAT(source_str, number)```
- **REPLACE** Replace all Instances of a String ```REPLACE(input_string , search_string , replacement)```
- **RIGHT** Return Characters From the Right of a Character String ```RIGHT(chr_exp, int_exp)```
- **RPAD** Pad a Character String on the Right ```RPAD(string, out_length, pad_character)```
- **RTRIM** Remove Blanks From the Right End of a String ```RTRIM(string)```
- **SPACE** Return a String With a Given Number of Spaces ```SPACE(count)```
- **SPLIT** Extract an Element From a String ```SPLIT(element, string)```
- **SUBSTRING** Extract a Substring From a Source String ```SUBSTRING(string, position, length)```
- **TOKEN** Extract a Token From a String ```TOKEN(string, delimiter, number)```
- **TRIM_** Remove a Leading Character, Trailing Character or Both From a String ```TRIM_(where, pattern, string)```
- **UPPER** Return a String With All Letters Uppercase ```UPPER(string)```
- ### 03. Character Functions
- **ARGLEN** Measure the Length of a Character String ```ARGLEN(length, source_string, output)```
- **ASIS** Distinguish Between a Space and a Zero ```ASIS(argument)```
- **BITSON** Determine If a Bit Is On or Off ```BITSON(bitnumber, source_string, output)```
- **BITVAL** Evaluate a Bit String ```BITVAL(source_string, startbit, number, output)```
- **BYTVAL** Translate a Character ```BYTVAL(character, output)```
- **CHKFMT** Check the Format of a Character String ```CHKFMT(numchar, source_string, 'mask', output)```
- **CHKNUM** Check the Format of a Character String ```CHKNUM(numchar, source_string, output)```
- **CTRAN** Translate One Character to Another ```CTRAN(length, source_string, decimal, decvalue, output)```
- **CTRFLD** Center a Character String ```CTRFLD(source_string, length, output)```
- **EDIT** Extract or Add Characters ```EDIT(source_string, 'mask')```
- **GETTOK** Extract a Substring (Token)" ```GETTOK(source_string, inlen, token_number, 'delim', outlen, output)```
- **LCWORD** Convert a Character String to Mixed-Case Using LCWORD1 ```LCWORD(length, source_string, output)```
- **LCWORD2** Convert a Character String to Mixed-Case Using LCWORD2 ```LCWORD2(length, string, output)```
- **LCWORD3** Convert a Character String to Mixed-Case Using LCWORD3 ```LCWORD3(length, string, output)```
- **LJUST** Left-Justify a Character String ```LJUST(length, source_string, output)```
- **LOCASE** Convert Text to Lowercase ```LOCASE(length, source_string, output)```
- **OVRLAY** Overlay a Character String ```OVRLAY(source_string, length, substring, sublen, position, output)```
- **PARAG** Divide Text Into Smaller Lines ```PARAG(length, source_string, 'delimiter', max_token_size, output)```
- **PATTERN** Generate a Pattern From an Input String ```PATTERN (length, source_string, output)```
- **POSIT** Find the Beginning of a Substring ```POSIT(source_string, length, substring, sublength, output)```
- **REVERSE** Reverse the Characters in a String ```REVERSE(length, source_string, output)```
- **RJUST** Right-Justify a Character String ```RJUST(length, source_string, output)```
- **SOUNDEX** Compare Character Strings Phonetically ```SOUNDEX(length, source_string, output)```
- **SPELLNM** Spell Out a Dollar Amount ```SPELLNM(outlength, number, output)```
- **SQUEEZ** Reduce Multiple Spaces to a Single Space ```SQUEEZ(length, source_string, output)```
- **STRIP** Remove a Character From a String ```STRIP(length, source_string, char, output)```
- **STRREP** Replace Character Strings ```STRREP (inlength, instring, searchlength, searchstring, replength, repstring, outlength, output)```
- **SUBSTR** Extract a Substring ```SUBSTR(length, source_string, start, end, sublength, output)```
- **TRIM** Remove Leading and Trailing Occurrences ```TRIM(trim_where, source_string, length, pattern, sublength, output)```
- **UPCASE** Convert Text to Uppercase ```UPCASE(length, source_string, output)```
- **XMLDECOD** Decode XML-Encoded Characters ```XMLDECOD(inlength, source_string, outlength, output)```
- **XMLENCOD** XML-Encode Characters ```XMLENCOD(inlength, source_string, option, outlength, output)```
- ### 04. Variable Length Character Functions
- **LENV** Find the Length of an Alphanumeric Field ```LENV(source_string, output)```
- **LOCASV** Create a Variable Length Lowercase String ```LOCASV(upper_limit, source_string, output)```
- **POSITV** Find the Beginning of a Variable Length Substring ```POSITV(source_string, upper_limit, substring, sub_limit, output)```
- **SUBSTV** Extract a Variable Length Substring ```SUBSTV(upper_limit, source_string, start, sub_limit, output)```
- **TRIMV** Remove Characters From a String ```TRIMV(trim_where, source_string, upper_limit, pattern, pattern_limit, output)```
- **UPCASV** Create a Variable Length Uppercase String ```UPCASV(upper_limit, source_string, output)```
- ### 05. Character Functions for DBCS Code Pages
- **DCTRAN** Translate a Single-Byte or Double-Byte Character to Another ```DCTRAN(length, source_string, indecimal, outdecimal, output)```
- **DEDIT** Extract or Add DBCS or SBCS Characters ```DEDIT(inlength, source_string, mask_length, mask, output)```
- **DSTRIP** Remove a Single-Byte or Double-Byte Character From a String ```DSTRIP(length, source_string, char, output)```
- **DSUBSTR** Extract a Substring ```DSUBSTR(inlength, source_string, start, end, sublength, output)```
- **JPTRANS** Convert Japanese Specific Characters ```JPTRANS ('type_of_conversion', length, source_string, 'output_format')```
- **KKFCUT** Truncate a String ```KKFCUT(length, source_string, output)```
- **SFTDEL** Delete the Shift Code From DBCS Data ```SFTDEL(source_string, length, output)```
- **SFTINS** Insert the Shift Code Into DBCS Data ```SFTINS(source_string, length, output)```
- ### 06. Maintain-specific Character Functions
- **CHAR2INT** Translate a Character Into an Integer Value ```CHAR2INT('character')```
- **INT2CHAR** Translate an Integer Value Into a Character ```INT2CHAR(value)```
- **LCWORD** Convert a Character String to Mixed-Case Using LCWORD ```LCWORD(string)```
- **LCWORD2** Convert a Character String to Mixed-Case Using LCWORD2 ```LCWORD2(string)```
- **LENGTH** Determine the Length of a Character String ```LENGTH(string)```
- **LJUST** Left-Justify a Character String ```LJUST(string)```
- **LOWER** Convert a Character String to Lowercase ```LOWER(string)```
- **MASK** Extract or Add Characters ```MASK(fieldname, 'mask')```
- **MNTGETTOK** Extract a Substring (Token)" ```MNTGETTOK(infield,'delim',token_number)```
- **NLSCHR** Convert Characters From the Native English Code Page ```NLSCHR('character')```
- **OVRLAY** Overlay a Character String ```OVRLAY(string1, string2, position)```
- **POSIT** Find the Beginning of a Substring ```POSIT(parent, substring)```
- **RJUST** Right-Justify a Character String ```RJUST(string, length, char)```
- **SELECTS** Decode a Value From a Stack ```target SELECTS (code, result, code, result, ... [ELSE default])```
- **STRAN** Substitute a Substring ```STRAN(string, substr1, substr2)```
- **STRCMP** Compare Character Strings ```STRCMP(string1, string2)```
- **STRICMP** Compare Character Strings and Ignore Case ```STRICMP(string1, string2)```
- **STRNCMP** Compare Character Substrings ```STRNCMP(string1, string2, number)```
- **STRTOKEN** Extract a Substring ```STRTOKEN(string, delimiters)```
- **SUBSTR** Extract a Substring ```SUBSTR(string, start, length)```
- **TRIM** Remove Trailing Occurrences ```TRIM(string)```
- **TRIMLEN** Determine the Length of a String Excluding Trailing Spaces ```TRIMLEN(string)```
- **UPCASE** Convert Text to Uppercase ```UPCASE(string)```
- ### 07. Data Source and Decoding Functions
- **CHECKMD5** Compute an MD5 Hash Check Value ```CHECKMD5(buffer)```
- **CHECKSUM** Compute a CHECKSUM Hash Value ```CHECKSUM(buffer)```
- **COALESCE** Return the First Non-Missing Value ```COALESCE(arg1, arg2, ...)```
- **DB_EXPR** Insert an SQL Expression Into a Request With DB_EXPR ```DB_EXPR(native_SQL_expression)```
- **DB_INFILE** Compare Source and Target Field Values With DB_INFILE ```DB_INFILE(target_file, s1, t1, ... sn, tn)```
- **DB_LOOKUP** Retrieve a Value From a Lookup Data Source ```DB_LOOKUP(look_mf, srcfld1, lookfld1, srcfld2, lookfld2, ..., returnfld)```
- **DECODE** Supply Values in the Function ```DECODE fieldname(code1 result1 code2 result2...[ELSE default ])```
- **FIND** Verify the Existence of a Value in a Data Source ```FIND(fieldname [AS dbfield] IN file)```
- **IMPUTE** Replace Missing Values With Aggregated Values ```IMPUTE(field, reset_key, replacement)```
- **LAST** Retrieve the Preceding Value ```LAST fieldname```
- **LOOKUP** Retrieve a data value from a cross-referenced FOCUS data source in a MODIFY request ```LOOKUP(field)```
- **NULLIF** Return a Null Value for Equal Parameters ```NULLIF(arg1,arg2)```
- ### 08. Simplified Date and Date-Time Functions
- **DAYNAME** Return the Name of the Day From a Date Expression ```DAYNAME(date_exp)```
- **DT_CURRENT_DATE** Return the Current Date ```DT_CURRENT_DATE()```
- **DT_CURRENT_DATETIME** Return the Current Date and Time ```DT_CURRENT_DATETIME(component)```
- **DT_CURRENT_TIME** Return the Current Time ```DT_CURRENT_TIME(component)```
- **DT_TOLOCAL** Convert UTC Time to Local Time ```DT_TOLOCAL(datetime, timezone)```
- **DT_TOUTC** Convert Local Time to UTC Time ```DT_TOUTC(datetime, timezone)```
- **DTADD** Increment a Date or Date-Time Component ```DTADD(date, component, increment)```
- **DTDIFF** Return the Number of Component Boundaries ```DTDIFF(end_date, start_date, component)```
- **DTIME** Extract a Time Component From a Date-Time Value ```DTIME(datetime, component)```
- **DTPART** Return a Date or Date-Time Component in Integer Format ```DTPART(date, component)```
- **DTRUNC** Return the First or Last Date of a Date Period ```DTRUNC(date_or_timestamp, date_period, extend)```
- **MONTHNAME** Return the Name of the Month From a Date Expression ```MONTHNAME(date_exp)```
- ### 09. Date Functions
- **DATEADD** Add or Subtract a Date Unit to or From a Date ```DATEADD(date, 'component', increment)```
- **DATECVT** Convert a Date Format ```DATECVT(date, 'in_format', output)```
- **DATEDIF** Find the Difference Between Two Dates ```DATEDIF(from_date, to_date, 'component')```
- **DATEMOV** Move a Date to a Significant Point ```DATEMOV(date, 'move-point')```
- **DATETRAN** Format Dates in International Formats ```DATETRAN(indate, '(intype)', '([formatops])', 'lang', outlen, output)```
- **DPART** Extract a Date Component and Return It in Integer Format ```DPART (datevalue, 'component', output)```
- **FIQTR** Obtain the Financial Quarter ```FIQTR(inputdate, lowcomponent, startmonth, startday, yrnumbering, output)```
- **FIYR** Obtain the Financial Year ```FIYR(inputdate, lowcomponent, startmonth, startday, yrnumbering, output)```
- **FIYYQ** Convert a Calendar Date to a Financial Date ```FIYYQ(inputdate, lowcomponent, startmonth, startday, yrnumbering, output)```
- **TODAY** Retrieve the Current Date ```TODAY(output)```
- **AYM** Add or Subtract Months to or From a Date ```AYM(indate, months, output)```
- **AYMD** Add or Subtract Days to or From a Date ```AYMD(indate, days, output)```
- **CHGDAT** Change the Date Display String ```CHGDAT('in_display_options', 'out_display_options', date_string,output)```
- **DA Functions** Convert a Date to an Integer (DADMY, DADYM, DAMDY, DAMYD, DAYDM, DAYMD)" ```function(indate, output)```
- **DMY or MDY or YMD** Calculate the Difference Between Two Dates ```function(from_date, to_date)```
- **DOWK** Find the Day of the Week ```DOWK(indate, output)```
- **DOWKL** Find the Day of the Week ```DOWKL(indate, output)```
- **DT Functions** Convert an Integer to a Date (DTDMY, DTDYM, DTMDY, DTMYD, DTYDM, DTYMD)" ```function(number, output)```
- **GREGDT** Convert From Julian to Gregorian Format ```GREGDT(indate, output)```
- **JULDAT** Convert From Gregorian to Julian Format ```JULDAT(indate, output)```
- **YM** Calculate Elapsed Months ```YM(fromdate, todate, output)```
- ### 10. Date-Time Functions
- **HADD** Increment a Date-Time Value ```HADD(datetime, 'component', increment, length, output)```
- **HCNVRT** Convert a Date-Time Value to Alphanumeric Format ```HCNVRT(datetime, '(format)', length, output)```
- **HDATE** Convert the Date Portion of a Date-Time Value to a Date Format ```HDATE(datetime, output)```
- **HDIFF** Find the Number of Units Between Two Date-Time Values ```HDIFF(end_dt, start_dt, 'component', output)```
- **HDTTM** Convert a Date Value to a Date-Time Value ```HDTTM(date, length, output)```
- **HEXTR** Extract Multiple Components From a Date-Time Value ```HEXTR(datetime, 'componentstring', length, output)```
- **HGETC** Store the Current Local Date and Time in a Date-Time Field ```HGETC(length, output)```
- **HGETZ** Store the Current Universal Date and Time in a Date-Time Field ```HGETZ(length, output)```
- **HHMMSS** Retrieve the Current Time ```HHMMSS(output)```
- **HHMS** Convert a Date-Time Value to a Time Value ```HHMS(datetime, length, output)```
- **HINPUT** Convert an Alphanumeric String to a Date-Time Value ```HINPUT(source_length, 'source_string', output_length, output)```
- **HMIDNT** Set the Time Portion of a Date-Time Value to Midnight ```HMIDNT(datetime, length, output)```
- **HMASK** Move Multiple Date-Time Components to a Target Date-Time Field ```HMASK(source, 'componentstring', input, length, output)```
- **HNAME** Retrieve a Date-Time Component in Alphanumeric Format ```HNAME(datetime, 'component', output)```
- **HPART** Retrieve a Date-Time Component in Numeric Format ```HPART(datetime, 'component', output)```
- **HSETPT** Insert a Component Into a Date-Time Value ```HSETPT(datetime, 'component', value, length, output)```
- **HTIME** Convert the Time Portion of a Date-Time Value to a Number ```HTIME(length, datetime, output)```
- **HTMTOTS or TIMETOTS** Convert a Time to a Timestamp ```HTMTOTS(time, length, output)```
- **HYYWD** Return the Year and Week Number From a Date-Time Value ```HYYWD(dtvalue, output)```
- ### 11. Maintain-specific Date and Time Functions
- **HHMMSS** Retrieve the Current Time ```HHMMSS()```
- **Initial_HHMMSS** Retrieve the Initial Time ```Initial_HHMMSS()```
- **Initial_TODAY** Retrieve the Initial Date ```Initial_TODAY()```
- **TODAY** Retrieve the Current Date ```TODAY()```
- **TODAY2** Retrieve the Current Date ```TODAY2()```
- **ADD** Add Days to a Date ```ADD(date,value)```
- **DAY** Extract the Day of the Month From a Date ```DAY(date)```
- **JULIAN** Determine How Many Days Have Elapsed in the Year ```JULIAN(date)```
- **MONTH** Extract the Month From a Date ```MONTH(date)```
- **QUARTER** Determine the Quarter for a Date ```QUARTER(date)```
- **SETMDY** Set a Value to a Date ```SETMDY(date, month, day, year)```
- **SUB** Subtract a Value From a Date ```SUB(date,value)```
- **WEEKDAY** Determine the Day of the Week for a Date ```WEEKDAY(date)```
- **YEAR** Extract the Year From a Date ```YEAR(date)```
- ### 12. Simplified Conversion Functions
- **CHAR** Return a Character Based on a Numeric Code ```CHAR(number_code)```
- **COMPACTFORMAT** Display Numbers in an Abbreviated Format ```COMPACTFORMAT(input)```
- **CTRLCHAR** Return a Non-Printable Control Character ```CTRLCHAR(ctrl_char)```
- **DT_FORMAT** Convert a Date Value to an Alphanumeric String in a Specified Date Format ```DT_FORMAT(date,'date_format')```
- **FPRINT** Display a Value in a Specified Format ```FPRINT(value, 'out_format')```
- **HEXTYPE** Returning the Hexadecimal View of an Input Value ```HEXTYPE(in_value)```
- **PHONETIC** Return a Phonetic Key ```PHONETIC(string)```
- **TO_INTEGER** Convert a Character String to an Integer ```TO_INTEGER(string)```
- **TO_NUMBER** Convert a Character String to a Number ```TO_NUMBER(string)```
- ### 13. Format Conversion Functions
- **ATODBL** Convert an Alphanumeric String to Double-Precision Format ```ATODBL(source_string, length, output)```
- **EDIT** Convert the Format of a Field ```EDIT(fieldname)```
- **FPRINT** Convert Fields Using FPRINT ```FPRINT(in_value, 'usageformat', output)```
- **FTOA** Convert a Number to Alphanumeric Format ```FTOA(number, '(format)', output)```
- **HEXBYT** Convert a Decimal Integer to a Character ```HEXBYT(decimal_value, output)```
- **ITONUM** Convert a Large Binary Integer to Double-Precision Format ```ITONUM(maxbytes, infield, output)```
- **ITOPACK** Convert a Large Binary Integer to Packed-Decimal Format ```ITOPACK(maxbytes, infield, output)```
- **ITOZ** Convert a Number to Zoned Format ```ITOZ(length, in_value, output)```
- **PCKOUT** Write a Packed Number of Variable Length ```PCKOUT(in_value, length, output)```
- **PTOA** Convert a Packed-Decimal Number to Alphanumeric Format ```PTOA(number, '(format)', output)```
- **TSTOPACK** Convert an MSSQL or Sybase Timestamp Column to Packed Decimal ```TSTOPACK(tscol, output)```
- **UFMT** Convert an Alphanumeric String to Hexadecimal ```UFMT(source_string, length, output)```
- **XTPACK** Store Packed Values in an Alphanumeric Field ```XTPACK(in_value, outlength, outdec, output)```
- ### 14. Maintain-specific Light Update Support Functions
- **IWC.FindAppCGIValue** Retrieve a TIBCO WebFOCUS Parameter or Variable Value ```IWC.FindAppCGIValue(parm, mnt_var)```
- **IWC.GetAppCGIValue** Import a TIBCO WebFOCUS Parameter ```IWC.GetAppCGIValue(parm)```
- ### 15. Simplified Numeric Functions
- **ASCII** Return the ASCII Code for the Leftmost Character in a String ```ASCII(charexp)```
- **CEILING** Return the Smallest Integer Greater Than or Equal to a Number ```CEILING(number)```
- **EXPONENT** Raise the Constant e to a Power ```EXPONENT(power)```
- **FLOOR** Return the Largest Integer Less Than or Equal to a Number ```FLOOR(number)```
- **LOG10** Calculate the Base 10 Logarithm ```LOG10(num_exp)```
- **MOD** Calculate the Remainder From a Division ```MOD(dividend, divisor)```
- **POWER** Raise a Value to a Power ```POWER(base, power)```
- **ROUND** Round a Number to a Given Number of Decimal Places ```ROUND(num_exp, count)```
- **SIGN** Return the Sign of a Number ```SIGN(number)```
- **TRUNCATE** Truncate a Number to a Given Number of Decimal Places ```TRUNCATE(num_exp, count)```
- ### 16. Numeric Functions
- **ABS** Calculate Absolute Value ```ABS(in_value)```
- **ASIS** Distinguish Between a Space and a Zero ```ASIS(argument)```
- **BAR** Produce a Bar Chart ```BAR(barlength, infield, maxvalue, 'char', output)```
- **CHKPCK** Validate a Packed Field ```CHKPCK(length, in_value, error, output)```
- **DMOD** Calculate the Remainder From a Division ```function(dividend, divisor, output)```
- **EXP** Raise e to the Nth Power ```EXP(power, output)```
- **EXPN** Evaluate a Number in Scientific Notation ```EXPN(n.nn {E|D} {+|-} p)```
- **FMLCAP** Retrieve Captions in an FML Request Using the FMLCAP Function ```FMLCAP(fieldname|'format')```
- **FMLFOR** Retrieve FML Tag Values ```FMLFOR(output)```
- **FMLINFO** Retain FOR Values in an FML Request ```FMLINFO('FORVALUE', output)```
- **FMLLIST** Retrieve an FML Tag List ```FMLLIST('A4096V')```
- **INT** Find the Greatest Integer ```INT(in_value)```
- **LOG** Calculate the Natural Logarithm ```LOG(in_value)```
- **MAX** Find the Maximum Value ```MAX(value1, value2, ...)```
- **MIN** Find the Minimum Value ```MIN}(value1, value2, ...)```
- **MIRR** Calculate the Modified Internal Rate of Return ```MIRR(cashflow, finrate, reinvrate, output)```
- **NORMSDST** Calculate the Cumulative Standard Normal Distribution ```NORMSDST(value, 'D8')```
- **NORMSINV** Calculate the Inverse Cumulative Standard Normal Distribution ```NORMSINV(value, 'D8')```
- **PRDNOR** Generate Reproducible Random Numbers ```PRDNOR(seed, output)```
- **PRDUNI** Generate Reproducible Random Numbers ```PRDUNI(seed, output)```
- **RDNORM** Generate Random Numbers ```RDNORM(output)```
- **RDUNIF** Generate Random Numbers ```RDUNIF}(output)```
- **SQRT** Calculate the Square Root ```SQRT(in_value)```
- **XIRR** Calculate the Internal Rate of Return ```"XIRR (cashflow, dates,guess, maxiterations, output); WITHIN {sort_field|TABLE}"```
- ### 17. Maintain-specific Script Functions
- **IWCLink** Display a URL in a Browser or Frame ```IWCLink(url, [target], [newwindow], [options])```
- **IWCSwitchToSecure** Turn Secure Sockets Layer On ```IWCSwitchToSecure()```
- **IWCSwitchToUnsecure** Turn Secure Sockets Layer Off ```IWCSwitchToUnsecure()```
- **IWCTrigger** Call a Maintain Function From a Script Handler ```IWCTrigger('functionname'[, 'parm']```
- **IWCTrigger** Pass the Value of an ActiveX Control Property to a Maintain Function ```IWCTrigger ('function',document.form.control.property)```
- **IWC.FindAppCGIValue** Find a TIBCO WebFOCUS Parameter Value ```IWC.FindAppCGIValue(name,value)```
- **IWC.GetAppCGIValue** Retrieve a TIBCO WebFOCUS Parameter ```IWC.GetAppCGIValue(parm)```
- ### 18. Simplified Statistical Functions
- **CORRELATION** Calculate the Correlation Coefficient Between Two Fields ```CORRELATION(field1, field2)```
- **KMEANS_CLUSTER** Partition Observations Into Clusters Based on the Nearest Mean Value ```KMEANS_CLUSTER(number, percent, iterations, tolerance, [prefix1.]field1[, [prefix1.]field2 ...])```
- **MULTIREGRESS** Create a Multivariate Linear Regression Column ```MULTIREGRESS(input_field1, [input_field2, ...])```
- **OUTLIER** Identify Outliers in Numeric Data ```OUTLIER(input_field)```
- **RSERVE** Run an R Script ```RSERVE(rserve_mf, input_field1, ...input_fieldn, output)```
- **STDDEV** Calculate the Standard Deviation in a Set of Data ```STDDEV(field, sampling)```
- ### 19. Machine Learning (Python-based) Functions
- **ANOMALY_IF** Calculate an Anomaly Score ```ANOMALY_IF('options' predictor_field1[, predictor_field2, ...])```
- **CLASSIFY_BLR** Calculate a Binary Logistic Regression ```CLASSIFY_BLR('options', predictor_field1[, predictor_field2, ...] target_field)```
- **CLASSIFY_KNN** Calculate a K-Nearest Neighbors Classification ```CLASSIFY_KNN('options', predictor_field1[, predictor_field2, ...] target_field)```
- **CLASSIFY_RF** Calculate a Random Forest Classification ```CLASSIFY_RF('options', number_of_trees, predictor_field1[, predictor_field2, ...] target_field)```
- **CLASSIFY_XGB** Calculate an Extreme Gradient Boosting Classification ```CLASSIFY_XGB('options', predictor_field1[, predictor_field2, ...] target_field)```
- **REGRESS_KNN** Calculate a K-Nearest Neighbors Regression ```REGRESS_KNN('options', predictor_field1[, predictor_field2, ...] target_field)```
- **REGRESS_POLY** Calculate a Polynomial Regression Column ```REGRESS_POLY('options', predictor_field1, predictor_field2, [...,] target_field)```
- **REGRESS_RF** Calculate a Random Forest Regression ```REGRESS_RF('options', predictor_field1[, predictor_field2, ...] target_field)```
- **REGRESS_XGB** Calculate an Extreme Gradient Boosting Regression ```REGRESS_XGB('options', predictor_field1[, predictor_field2, ...] target_field)```
- **RUN_MODEL** Run a Saved Python Model ```RUN_MODEL('app/modelname') ;```
- **RUN_MODEL2** Run a Saved Python Model (predictor field names are not the same in the model and the data)"```RUN_MODEL2('app/modelname', pfield1, ..., pfieldn) ;```
- ### 20. Simplified System Functions
- **EDAPRINT** Insert a Message in the EDAPRINT Log File ```EDAPRINT(message_type, 'message')```
- **ENCRYPT** Encrypt a Password ```ENCRYPT(password)```
- **GETENV** Retrieve the Value of an Environment Variable ```GETENV(var_name)```
- **PUTENV** Assign a Value to an Environment Variable ```PUTENV(var_name, var_value)```
- **SLACK** Post a Message to a Slack Channel ```SLACK(workspace, channel, message)```
- ### 21. System Functions
- **CHECKPRIVS** Retrieve the Privilege State for the Connected User ```CHECKPRIVS(privcode, output)```
- **CLSDDREC** Close All Files Opened by the PUTDDREC Function ```CLSDDREC(output)```
- **FEXERR** Retrieve an Error Message ```FEXERR(error, 'A72')```
- **FGETENV** Retrieve the Value of an Environment Variable ```FGETENV(length, 'varname', outlen, output)```
- **FINDMEM** Find a Member of a Partitioned Data Set ```FINDMEM(ddname, member, output)```
- **FPUTENV** Assign a Value to an Environment Variable ```FPUTENV (varname_length,'varname',value_length, 'value', output)```
- **GETCOOKI** Retrieve a Cookie Value ```GETCOOKI('cookie_name', length)```
- **GETHEADR** Retrieve an HTTP Header Variable ```GETHEADR('varname', output)```
- **GETPDS** Determine If a PDS Member Exists ```GETPDS(ddname, member, output)```
- **GETUSER** Retrieve a User ID ```GETUSER(output)```
- **GRPLIST** Retrieve a List of Group Memberships for the Connected User ```GRPLIST(outputLength, outformat)```
- **JOBNAME** Retrieve the Current Process Identification String ```JOBNAME(length, output)```
- **MVSDYNAM** Pass a DYNAM Command to the Command Processor ```MVSDYNAM(command, length, outfield)```
- **PUTCOOKI** Submit a Cookie Value ```PUTCOOKI('cookie_name','cookie_value')```
- **PUTDDREC** Write a Character String as a Record in a Sequential File ```PUTDDREC(ddname, dd_len, record_string, record_len, output)```
- **SLEEP** Suspend Execution for a Specified Number of Seconds ```SLEEP(delay, output)```
- **SPAWN** Create a Subprocess From a Procedure ```SPAWN(inlength, command, outcode)```
- **SYSTEM** Call a DOS or Windows Program ```SYSTEM(length, 'string ', returncode)```
- **SYSVAR** Retrieve the Value of a z/OS System Variable ```SYSVAR('length', '[&]sysvar[.]', 'outfmt')```
- ### 22. Simplified Geography Functions
- **GIS_DISTANCE** Calculate the Distance Between Geometry Points ```GIS_DISTANCE(geo_point1,geo_point2)```
- **GIS_DRIVE_ROUTE** Calculate the Drive Route Between Geometry Points ```GIS_DRIVE_ROUTE(geo_start_point,geo_end_point)```
- **GIS_GEOCODE_ADDR** Geocode a Complete Address ```GIS_GEOCODE_ADDR(address[, country])```
- **GIS_GEOCODE_ADDR_CITY** Geocode an Address Line ```City, and State,GIS_GEOCODE_ADDR_CITY( street_addr, city , state [, country])```
- **GIS_GEOCODE_ADDR_POSTAL** Geocode an Address Line and Postal Code ```GIS_GEOCODE_ADDR_POSTAL( street_addr, postal_code [, country])```
- **GIS_GEOMETRY** Build a JSON Geometry Object ```GIS_GEOMETRY(geotype, wkid, geometry)```
- **GIS_IN_POLYGON** Determine if a Point is in a Complex Polygon ```GIS_IN_POLYGON(point, polygon_definition)```
- **GIS_LINE** Build a JSON Line ```GIS_LINE(geometry1, geometry2)```
- **GIS_POINT** Build a Geometry Point ```GIS_POINT(wkid, longitude, latitude)```
- **GIS_REVERSE_COORDINATE** Return a Geographic Component ```GIS_REVERSE_COORDINATE(longitude, latitude, component)```
- **GIS_SERVICE_AREA** Calculate a Geometry Area Around a Point ```GIS_SERVICE_AREA(geo_point, distance, travel_mode)```
- **GIS_SERV_AREA_XY** Calculate a Geometry Area Around a Coordinate ```GIS_SERV_AREA_XY(longitude, latitude, distance, travel_mode[, wkid])```
- ### 23. SQL Character Functions
- **LOCATE** Return the Position of a Substring in a String ```LOCATE(substr, source [,start])```
- ### 24. SQL Miscellaneous Functions
- **CHR** Return the ASCII Character Given a Numeric Code ```CHR(number)```
- ### 25. Trigonometric Functions
- **ACOS** Calculate an Angle Given its Cosine ```ACOS(expression)```
- **ASIN** Calculate an Angle Given its Sine ```ASIN(expression)```
- **ATAN** Calculate an Angle Given its Tangent ```ATAN(expression)```
- **ATAN2** Calculate an Angle Given the Coordinates of its Tangent ```ATAN2(x,y)```
- **COS** Calculate the Cosine of an Angle ```COS(expression)```
- **COT** Calculate the Cotangent of an Angle ```COT(expression)```
- **DEGREES** Convert Radians to Degrees ```DEGREES(expression)```
- **PI** Returning the Value Pi ```PI()```
- **RADIANS** Convert Degrees to Radians ```RADIANS(expression)```
- **SIN** Calculate the Sine of an Angle ```SIN(expression)```
- **TAN** Calculate the Tangent of an Angle ```TAN(expression)```
---
[Funciones WebFOCUS por orden alfabético](webfocus-functions-table.html "Funciones WebFOCUS por orden alfabético")TICWebFOCUSFunciones