ࡱ> ^`_o@ Ubjbj p p =Foo" 0RRRf8FL|fC3lp ? K22222224R72R22"""82"2","$.:/ xBv2/"0D30C3T/j 8S! 8D/ff 8R/Sg"u :SSS22ff$"ffData Attribute %DecPos( numeric expression ) %Elem( table, array or mult-occur data struct ) %Len( expression ) %Size( variable, literal, array, table, dsn-name ) Dates %Mseconds( number )}Use instead of ADDDUR, SUBDUR Newdate = Duedate + %Days(23)%Seconds( number )%Minutes( number )%Hours( number )%Days( number )%Months( number )%Years( number ) %Date( { expression { : date-format } }) to date %Diff( op1 : op2 : duration code ) %Subdt( value : duration code ) (use %Trim!!) %Time({ expression : { : time-format }}) %Timestamp({ expression : { : *ISO | *ISO0 }}) Data Conversion %Char( expression { : date/time fmt }) from date charvar = %char( Datdatatyp : *USA) %Dec( num/char expr { : precision : dec places }) %DecH %Editc( numeric : editcode { : cur-symbol }) %EditFlt( numeric expression ) %Editw( numeric : editword ) %Float( num/char expression ) %Graph( expression { : ccsid }) %Int( num/char expression ) %IntH( num/char expression ) %Str( basing-ptr { : max-len }) ( right-hand-side ) %Str( basing-ptr : max-len )( left-hand-side ) %UCS2( expression ) %Uns( num/char expression ) %UnsH ( num/char expression ) Files/Arrays Built-in functionWhen to useEquivalent Indicator%EofRead, Readc, Reade, Readp, Readpe, Write (subfile only), OpenEQ%FoundChain, Delete, Setgt, Check, CheckR, Scan (but not %Scan)GT%EqualSetll, Lookupexact match%ErrorOperations with ELT%StatusINFDS *Status Files/Arrays (cont) %Fields( name { : name } ) %Kds( data-structure-name {: number-of-keys }) %Lookup( arg : array { : startidx { : numelems }} ) %LookupGt %LookupGe %LookupLt %LookupLe %Occur( dsn-name ) %Open( file ) %TLookup( arg : search-table { : alt-table }) %TLookupGt, %TLookupGe, %TLookupLt, %TLookupLe %Xfoot( array-expression ) Math functions %Abs( numeric expression ) %Div( numerator : denominator ) %Rem( numerator : denominator ) %Sqrt( numeric expression ) Pointers/Storage %Addr( variable ) %Alloc( num ) %PAddr( string | prototype ) %Realloc( ptr : num ) Strings %Check( comparator : base { : start } ) %CheckR( comparator : base { : start }) %Replace( replstring : srcstring { : startpos { : src len to replace }} ) %Scan( search arg : source string { : start }) %Subst( string : start { : length }) %Trim( string ) %TrimL( string ) %TrimR( string ) %Xlate( from : to : string { : startpos }) Miscellaneous %Bitand( expression : expression {: expression } ) %Bitnot( expression ) %Bitor( expression : expression {: expression } ) %Bitxor( expression : expression ) %NullInd( fieldname ) %Parms %Shtdn %This Information Systems Page  PAGE 2 of  NUMPAGES 1  AUTHOR \* MERGEFORMAT Carmen Nuland  DATE \@ "MM/dd/yy" 09/09/03  FILENAME \p \* MERGEFORMAT \\Server\is_dept\Tips\Built-in functions.doc Built-in Functions Cheat-sheet  FILENAME \p \\Server\is_dept\Tips\Built-in functions.doc +5[dnx      ' 4 ; G N \ c p w | }  ĺįĺĺĺĺĺĺĺĺĞ阎阎h7h75CJ h7CJ hCJhhCJaJhhCJ`aJ`hh6CJhhCJhh}9>*h4hN46CJh0 hN46CJh4hN4CJhhN4>* hN4>*8.^q $$Ifa$gd $Ifgd0EgdgdN4gdN4 "RT     .ckd$$Ifl4F L(  t    44 la $Ifgd0Eckd$$Ifl4F L(t    44 la ) * + , = > ? ckd$$Ifl4F L(  t    44 la $Ifgd0E? @ P Q R S .ckd$$Ifl4F L(  t    44 la $Ifgd0Eckdq$$Ifl4F L(  t    44 laS e f g h y z { ckdc$$Ifl4F L(  t    44 la $Ifgd0E{ | }  + Z j ' F c gdhrSgdhrSgdN4gd4ckd$$Ifl4F L(  t    44 la   & 8 B Y Z i j q { } ~     # ' 1 8 9 C N U X ` j ̿ƶӥ윒h0 hN46CJ h(6CJh0 hhrS6CJh4hhrSCJ hhhrSh7h75CJh7h7CJ h76CJ h7CJ hhrS6CJ hhrSCJhhhrS>* hhrS>* hN4CJh4hN4CJh4hN46CJ0j k n s t ~   ! ( , : D N W Z _ ` j u x } ~ ྐྵhoheCJhoh}9CJhho5CJ h5CJhh}95CJ h]8>*hh}9>*h4hhrS6CJ hhrSCJh0 hhrS6CJh4hhrSCJ h(6CJh0 h(6CJ h(CJ7c  = Q m $IfgdogdgdhrS   pggg $IfgdokdU$$Ifl4F4 Lt  t06    44 la     . S m x !&+378@OPYŷ傈xh4h]8CJy( h]8CJh0 h]86CJhN4h]86CJ h]6CJ hN4h]8 hCJ h6CJhN4h]8CJ hN4>*hhN4>*hN4h]CJ h]CJhoh]8CJh4h]8CJhoheCJhoh}9CJ/   T W qhhh $Ifgdokd$$IflF4 Lt  t06    44 laW X _ m y qhhh $Ifgdokd$$IflF4 Lt  t06    44 lay z qhhh $IfgdokdP$$IflF4 Lt  t06    44 la qhhh $Ifgdokd$$IflF4 Lt  t06    44 la FoqlgbbbYbbb^gd]8gd]8gdN4gd]kd$$IflF4 Lt  t06    44 la YZdew0139BEPSYbepsxz캱xxoeoh0 hX6CJh4hXCJh0 h;Qi6CJh4h;QiCJh0 hf"6CJh4hf"CJh0 huN6CJh4h]ACJh4huNCJhh:t}>*h0 h]86CJh]8h]8CJ h]86CJ h]8CJh4h]86CJh4h]8CJh4h]8CJy('3Ss#K GV`gd]8gdN4gd4gdgd]8^gd]8 +,69=BGKU_bɿ㶬ɿɿ~t~h0 h]86CJh4h]8CJh4'hh}9>* h;QiCJh0 h;Qi6CJh4h;QiCJh4hN46CJh4hN4CJh0 huN6CJh4h]ACJh:t} hN4>*hh:t}>*h4huNCJh4hXCJh0 hX6CJ-bkpx}$(+-06;CGV_bijkpvy~ԺԺԺ hsz4CJ hN4CJ hsz46CJ hN46CJhN4hN4CJhh~n>* h]86CJh4h]8CJh0 h]86CJI !"YPQRSTU$a$gd0 $dN &dPgd4  !"<=CDEFJKUVWXYZrs¹reeXIejhrhd(CJU*hfCJmHnHu*jhrhd(CJU jhrhd(0JCJU*hf0JCJmHnHu*h70JCJmHnHuhrhd(0JCJjhrhd(0JCJUhrhd(CJ h]8h]8h4h]CJh4huNCJh4h;QiCJh4h-7}6CJh4h-7}CJhN4hN4CJ!"NOPQRSTUĵčۉ h]8h]8h>7hfhfCJaJmHnHujh0 CJUaJh0 h0 CJaJjh0 h0 CJUaJh0 h0 h0 CJ aJ h0 CJ aJ hd(hfCJmHnHujhrhd(CJUhrhd(CJ; 0:po/ =!"#$% P0}$$If!vh5(55t#v(#v#vt:Vl4++,5(55tw$$If!vh5(55t#v(#v#vt:Vl4++5(55tw$$If!vh5(55t#v(#v#vt:Vl4++5(55tw$$If!vh5(55t#v(#v#vt:Vl4++5(55tw$$If!vh5(55t#v(#v#vt:Vl4++5(55tw$$If!vh5(55t#v(#v#vt:Vl4++5(55tw$$If!vh5(55t#v(#v#vt:Vl4++5(55t$$If!vh55t 5#v#vt #v:Vl4 t0655t 5$$If!vh55t 5#v#vt #v:Vl t0655t 5$$If!vh55t 5#v#vt #v:Vl t0655t 5$$If!vh55t 5#v#vt #v:Vl t0655t 5$$If!vh55t 5#v#vt #v:Vl t0655t 5$$If!vh55t 5#v#vt #v:Vl t0655t 5<@< rNormalCJ_HmH sH tH :@: Heading 1$@&5>*\@\ m Heading 2$<@& 56CJOJQJ\]^JaJV@V m Heading 3$<@&5CJOJQJ\^JaJV@V Heading 5$$ H@&a$5@CJ0OJQJDA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List 4@4 Header  !4 @4 Footer  !.)@. Page NumbervO1"v Company Name+$$d(y!&P#$+Da$;@KCJKHOJQJ2B@22 Body Textx\OQ2\ Subtitle Coverd$d N @CJ$`OB` Title Cover$$$da$;@ACJ@KHOJQJ0U@a0 m Hyperlink>*B*FV@qF mFollowedHyperlink >*B* ph6@6 :t} Table Grid:V4O4 }9Termx OJQJaJ<O< }9 Definition ^aJ^O^ ]AHeading 3 Char*5CJOJQJ\^J_HaJmH sH tH U U F.^q)*+,=>?@PQRSefghyz{|}+Zj'Fc=QmTWX_myzFo3Ss#K  G V   ! " Y   P Q R S V (0@0x@0@0x@0x(00 0 00000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 000x00@0 (000000x0x00 00000000(0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0(0 0080 00(0800 0(00 0 0 0(00(0x00x(0x0000000000(0x00000x000H0@0@0x@0@0@0@0@0@0@00Dʔ00&0V >;00/2 j YbU !" ? S { c  W y U  T !#(357P^av,2!ttttt8@H0(  2 _Toc20555376V G V iu -V V  urn:schemas:contactsSn /3EIU[ (/GLX`%(RUnr).7=_d+38@GOQY[cfnwzTWtx$*U_bkpx}   " ; C W ]     " Q R V /4_crw~,6kp(0GMdj>CRVsxpv48TXty$+LT   # W ^ " Q R V 333333333333333333333333333333333333333333333333333333}~jsZ_x}b i p v ~ ! " " < F J X Y Q V " Q R V  Carmen NulandScott Roger KinstlerScott Roger Kinstler Denny Vanvick Carmen Nuland Carmen Nuland Bill Theisen Bill Theisen Carmen Nuland| }J)~#V)) Fcvo4%G N * sL-p9Ky~(h^`.^`.88^8`.^`. ^`OJQJo( ^`OJQJo( 88^8`OJQJo( ^`OJQJo(hh^h`. hh^h`OJQJo(^`o()h^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hH88^8`o(.Ky~%G  sL-p~}|                  32mofe]Au0 f"d(cZ(sz4]8}93gMhrSX]Kyh;Qi]j0 n~nkv-7}:t}roMV#V4'0E(s]N44]>7P?@uN78A])*+,=>?@PQRSefghyz{|'c=QTWX_myz! " V @U P@UnknownGz Times New Roman5Symbol3& z Arial?5 z Courier New9Garamond;Wingdings"qh{i&JyFJyFY!24d   3QH(0rC\\Server\is dept\Standards\Standard Form with header and footer.dotBuilt-in functions Carmen Nuland Carmen NulandD         Oh+'0 0< X d p |Built-in functionsuilCarmen Nulandioarm)Standard Form with header and footer.dot WoCarmen Nulandwi16mMicrosoft Word 10.0@Vn @C*v@oh@t$v՜.+,0 hp   Hal Leonard { Built-in functions Title  !"#%&'()*+-./0123456789:;<=>?@ABCDEFGHJKLMNOPRSTUVWX[Root Entry FBv]Data $1Table,M8WordDocument=FSummaryInformation(IDocumentSummaryInformation8QCompObjj  FMicrosoft Word Document MSWordDocWord.Document.89qRoot Entry F{9bData $1Table,M8WordDocument=F  !"#%&'()*+-./0123456789:;<=>?@ABCDEFGHJKLMNOPaSummaryInformation(IDocumentSummaryInformation8|CompObjj  FMicrosoft Word Document MSWordDocWord.Document.89q՜.+,D՜.+,H hp   Hal Leonard { Built-in functions Title4 $,