Re^4: How to connect to a remote teradata machine using perl on windows machine and execute BTEQ commands

i tried to install DBD::Teradata as below and i am using windows

C:\Windows\System32>cpan DBD::Teradata
CPAN: CPAN::SQLite loaded ok (v0.202)
Database was generated on Mon, 03 Nov 2014 08:05:20 GMT
Running install for module 'DBD::Teradata'
Running make for D/DA/DARNOLD/DBD-Teradata-1.52.tar.gz
CPAN: Digest::SHA loaded ok (v5.63)
CPAN: Compress::Zlib loaded ok (v2.042)
Checksum for C:\Dwimperl\cpan\sources\authors\id\D\DA\DARNOLD\DBD-Tera
+data-1.52
tar.gz ok
CPAN: Archive::Tar loaded ok (v1.80)
CPAN: File::Temp loaded ok (v0.22)
CPAN: CPAN::Meta loaded ok (v2.142690)

  CPAN.pm: Building D/DA/DARNOLD/DBD-Teradata-1.52.tar.gz



 *** Configuring DBD::Teradata (feature-limited free edition)...


***************************************************************
*
*       !!!NOTE TO INSTALLERS!!!
*
*       DBD::Teradata will be built using the following
*       directives:
*       Libraries:
*       Include files: -IC:\PROGRA~1\NCR\TERADA~1\cli\inc
*       Compile flags:
*
*       If your CLI2 libraries and/or include files are in another
*       location, please update the TDAT_DBD_CLI_LIB and
*       TDAT_DBD_CLI_INC environment variables before running
*       Makefile.PL.
*
***************************************************************

Checking for DBI, 1.40 or later ... ok
Checking for Math::BigInt, 1.73 or later ... ok
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for DBD::Teradata
Writing MYMETA.yml and MYMETA.json
CPAN: Module::CoreList loaded ok (v2.57)
cp lib/DBD/Teradata.pm blib\lib\DBD\Teradata.pm
Running Mkbootstrap for DBD::Teradata ()
"C:\Dwimperl\perl\bin\perl.exe" -MExtUtils::Command -e chmod -- 644 "T
+eradata.b
"
"C:\Dwimperl\perl\bin\perl.exe" "C:\Dwimperl\perl\lib\ExtUtils\xsubpp"
+  -typema
 "C:\Dwimperl\perl\lib\ExtUtils\typemap"  Teradata.xs > Teradata.xsc &
+& "C:\Dwi
perl\perl\bin\perl.exe" -MExtUtils::Command -e mv -- Teradata.xsc Tera
+data.c
Please specify prototyping behavior for Teradata.xs (see perlxs manual
+)
gcc -c  -IC:\PROGRA~1\NCR\TERADA~1\cli\inc      -s -O2 -DWIN32 -DPERL_
+TEXTMODE_
CRIPTS -DUSE_SITECUSTOMIZE -DPERL_IMPLICIT_CONTEXT -DPERL_IMPLICIT_SYS
+ -fno-str
ct-aliasing -mms-bitfields -s -O2         -DVERSION=\"1.52\"    -DXS_V
+ERSION=\"
.52\"  "-IC:\Dwimperl\perl\lib\CORE"   Teradata.c
Teradata.xs:5:22: error: coptypes.h: No such file or directory
Teradata.xs:6:21: error: dbcarea.h: No such file or directory
Teradata.xs:7:20: error: coperr.h: No such file or directory
Teradata.xs:8:20: error: parcel.h: No such file or directory
Teradata.xs:34: error: expected specifier-qualifier-list before 'DBCAR
+EA'
Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_init_dbcarea':
Teradata.xs:68: error: 'DBCAREA' undeclared (first use in this functio
+n)
Teradata.xs:68: error: (Each undeclared identifier is reported only on
+ce
Teradata.xs:68: error: for each function it appears in.)
Teradata.xs:68: error: 'dbcp' undeclared (first use in this function)
Teradata.xs:73: error: 'struct <anonymous>' has no member named 'dbc'
Teradata.xs:78: error: 'EM_OK' undeclared (first use in this function)
Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_get_connection':
Teradata.xs:102: error: 'DBCAREA' undeclared (first use in this functi
+on)
Teradata.xs:102: error: 'dbcp' undeclared (first use in this function)
Teradata.xs:102: error: 'struct <anonymous>' has no member named 'dbc'
Teradata.xs:149: error: 'DBFCON' undeclared (first use in this functio
+n)
Teradata.xs:156: error: 'EM_OK' undeclared (first use in this function
+)
Teradata.xs:176: error: 'DBFFET' undeclared (first use in this functio
+n)
Teradata.xs:184: error: 'PclLSN' undeclared (first use in this functio
+n)
Teradata.xs:188: error: 'PclSUCCESS' undeclared (first use in this fun
+ction)
Teradata.xs:191: error: 'PclFAILURE' undeclared (first use in this fun
+ction)
Teradata.xs:192: error: 'PclERROR' undeclared (first use in this funct
+ion)
Teradata.xs:204: error: 'PclENDSTATEMENT' undeclared (first use in thi
+s functio
)
Teradata.xs:205: error: 'PclENDREQUEST' undeclared (first use in this 
+function)
Teradata.xs:213: error: 'REQEXHAUST' undeclared (first use in this fun
+ction)
Teradata.xs:234: error: 'DBFERQ' undeclared (first use in this functio
+n)
Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_get_tdat_release'
+:
Teradata.xs:257: error: 'DBCAREA' undeclared (first use in this functi
+on)
Teradata.xs:257: error: 'dbcp' undeclared (first use in this function)
Teradata.xs:257: error: 'dbc_ctx_t' has no member named 'dbc'
Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_cleanup':
Teradata.xs:273: error: 'DBCAREA' undeclared (first use in this functi
+on)
Teradata.xs:273: error: 'dbcp' undeclared (first use in this function)
Teradata.xs:273: error: 'struct <anonymous>' has no member named 'dbc'
Teradata.xs:277: error: 'DBFDSC' undeclared (first use in this functio
+n)
Teradata.xs:280: error: 'EM_OK' undeclared (first use in this function
+)
Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_send_request':
Teradata.xs:303: error: 'DBCAREA' undeclared (first use in this functi
+on)
Teradata.xs:303: error: 'dbcp' undeclared (first use in this function)
Teradata.xs:303: error: 'struct <anonymous>' has no member named 'dbc'
Teradata.xs:334: error: 'DBFIRQ' undeclared (first use in this functio
+n)
Teradata.xs:337: error: 'EM_OK' undeclared (first use in this function
+)
Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_wait_for_response
+':
Teradata.xs:358: error: 'EM_OK' undeclared (first use in this function
+)
Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_get_response':
Teradata.xs:385: error: 'DBCAREA' undeclared (first use in this functi
+on)
Teradata.xs:385: error: 'dbcp' undeclared (first use in this function)
Teradata.xs:385: error: 'dbc_ctx_t' has no member named 'dbc'
Teradata.xs:413: error: 'DBFFET' undeclared (first use in this functio
+n)
Teradata.xs:414: error: 'EM_OK' undeclared (first use in this function
+)
Teradata.xs:426: error: 'EM_NODATA' undeclared (first use in this func
+tion)
Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_end_request':
Teradata.xs:448: error: 'DBCAREA' undeclared (first use in this functi
+on)
Teradata.xs:448: error: 'dbcp' undeclared (first use in this function)
Teradata.xs:448: error: 'struct <anonymous>' has no member named 'dbc'
Teradata.xs:449: error: 'EM_OK' undeclared (first use in this function
+)
Teradata.xs:455: error: 'DBFERQ' undeclared (first use in this functio
+n)
Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_abort_request':
Teradata.xs:475: error: 'DBCAREA' undeclared (first use in this functi
+on)
Teradata.xs:475: error: 'dbcp' undeclared (first use in this function)
Teradata.xs:475: error: 'struct <anonymous>' has no member named 'dbc'
Teradata.xs:476: error: 'EM_OK' undeclared (first use in this function
+)
Teradata.xs:482: error: 'DBFABT' undeclared (first use in this functio
+n)
Teradata.xs: In function 'XS_DBD__Teradata__Cli_tdxs_test_leak':
Teradata.xs:505: error: 'DBCAREA' undeclared (first use in this functi
+on)
Teradata.xs:505: error: 'dbcp' undeclared (first use in this function)
Teradata.xs:505: error: 'dbc_ctx_t' has no member named 'dbc'
Teradata.xs:528: error: 'DBFIRQ' undeclared (first use in this functio
+n)
Teradata.xs:530: error: 'EM_OK' undeclared (first use in this function
+)
Teradata.xs:545: error: 'DBFFET' undeclared (first use in this functio
+n)
Teradata.xs:555: error: 'DBFERQ' undeclared (first use in this functio
+n)
dmake.EXE:  Error code 129, while making 'Teradata.o'
  DARNOLD/DBD-Teradata-1.52.tar.gz
  C:\Dwimperl\c\bin\dmake.EXE -- NOT OK
CPAN: YAML loaded ok (v0.77)
Running make test
  Can't test without successful make
Running make install
  Make had returned bad status, install seems impossible
[download]

Comment on Re^4: How to connect to a remote teradata machine using perl on windows machine and execute BTEQ commands Download Code

Replies are listed 'Best First'.
Re^5: How to connect to a remote teradata machine using perl on windows machine and execute BTEQ commands by marto (Cardinal) on Nov 03, 2014 at 10:36 UTC
`!!!NOTE TO INSTALLERS!!!` [download] Looks like you didn't read this part, or the module documentation on cpan. If you want to make life needlessly difficult for yourself continue to ignore this.	[reply] [d/l]
Re^5: How to connect to a remote teradata machine using perl on windows machine and execute BTEQ commands by CountZero (Bishop) on Nov 03, 2014 at 15:01 UTC
It seems your system cannot find the library and header files necessary to build this module. Are you sure you have these files on your system? The help file of this module specifically lists the following files and libraries to be made available: libcliv2.so libtdusr.so libtdgss.so parcel.h dbcarea.h coperr.h coptypes.h errmsg.cat clispb.dat CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James My blog: Imperial Deltronics	[reply]