infa_函数.docVIP

UPPER(IPF_NAME) = X-SELLING PRICE STABILITY AND PERIOD_ID = :LKP.LKP_PERIOD_Q(Calculate Employee IPF %, Pending Calculation) 将字符转换成大写 ceil(NEXTVAL/5000)+100进位的意思，ceil(20.21)=21,ceil(20.98)=21,ceil(-21.87)=-21 Character Functions The transformation language includes the following character functions: ASCII ASCII( ITEMS )返回ASCII码值 CHR CHR( ITEM_ID )返回数值的对应字母：for ex: Joan || CHR(39) || s car returns Joans car CHRCODE CONCAT CONCAT( CONCAT( FIRST_NAME, ), LAST_NAME ) FIRST_NAME LAST_NAME RETURN VALUE John Baer John Baer INITCAP INITCAP( FIRST_NAME )将第一个字母大写 INSTR LENGTH LOWER LPAD LTRIM METAPHONE REPLACECHR REPLACESTR RPAD RTRIM SOUNDEX SUBSTR UPPER Conversion Functions The transformation language includes the following conversion functions: TO_CHAR(Date) TO_CHAR(Number) TO_DATE TO_DECIMAL TO_FLOAT TO_INTEGER Data Cleansing Functions The transformation language includes a group of functions to help you eliminate data errors. With data cleansing functions you can: Test input value. Convert the datatype of an input value. Trim string values. Replace characters in a string. Encode strings. The transformation language includes the following data cleansing functions: INSTR IS_DATE IS_NUMBER IS_SPACES ISNULL LTRIM METAPHONE REPLACECHR REPLACESTR RTRIM SOUNDEX SUBSTR TO_CHAR TO_DATE TO_DECIMAL TO_FLOAT TO_INTEGER Date Functions The transformation language includes a group of date functions to help you round, truncate, or compare dates, extract one part of a date, or perform arithmetic on a date. You can pass any value with a date datatype to any of the date functions. However, if you want to pass a string to a date function, you must first use the TO_DATE function to convert it to a transformation Date/Time datatype. The transformation language includes the following date functions: ADD_TO_DATE DATE_COMPARE DATE_DIFF GET_DATE_PART LAST_DAY MAX MIN ROUND SET_DATE_PART TRUNC Numeric Functions The tr