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] )
|
