Home Page for the TeradataForum
 

 

UDF Library: 'is_integer'

Component: 'readme.txt'


 
  is_integer_v.c >>

Hi,

This is a  Is_Integer UDF.   It support.

   NULLS          ( returns 0 )
   Char/VarChar

Currently the UDF ignores leading and trailing whitespace.   If you
don't desire this functionality please edit the  source file follow
the directions in the comments.


To install    cd to the directory where these files exist and execute

    bteq "logon copid/user,password" < install_from_client.txt

        BTEQ must be TTU 7.1 or higher to do the installation.

if you don't have  TTU 7.1   then  Copy the source file

    is_integer_v.c

to the TPA node into the directory

    MPRAS TPA Node :    /Teradata/tdbs_udf/usr/

    Windows TPA Node :  X:\program files\ncr\tdat\Teradata\tdbs_udf\usr\
        Where X is the drive letter where Teradata is installed.

and execute

    bteq "logon copid/user,password" < install_from_server.txt

This USER has to have been granted

    CREATE FUNCTION

rights or this command will fail.   Also USER  can not be DBC.


The installation script also includes a verification script to make
sure it got installed properly.   To execute the verification
script type

     bteq "logon copid/user,password" < verify.txt


Please verify the output of the verification script to ensure
proper installation.

If you need to uninstall these functions you can execute the uninstall script

     bteq "logon copid/user,password" < uninstall.txt

Please let me know if there are any issues although is no guarantee
implied or inferred those issues will be addressed.

Author --    Dennis Calkins   ( [email protected] )


  is_integer_v.c >>





 
  Top Home Privacy Feedback  
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky
Copyright 2016 - All Rights Reserved
Last Modified: 28 Jun 2020