perl DBD Informix install and test
1.安装Informix_Client_SDK 1)root用户登录,添加informix home目录、组、用户 # mkdir -p /opt/informix # groupadd informix # useradd -G informix -d /opt/informix informix # passwd informix # chown informix -R /opt/informix # chmod 775 -R /opt/informix 2)安装Informix_Client_SDK informix用户复制Informix_Client_SDK_V3.50.FC5_Linux_x86_64_CZ4HFEN.tar到/opt/informix目录下 >tar xvf Informix_Client_SDK_V3.50.FC5_Linux_x86_64_CZ4HFEN.tar /opt/informix目录新建文件.profile? > vi .profile? export INFORMIXDIR=/opt/informix root用户安装 #cd /opt/informix # ./installclientsdk? ? ? ? ? ? Initializing InstallShield Wizard........ ? ? ? ? ? Launching InstallShield Wizard........ ------------------------------------------------------------------------------- Welcome to the InstallShield Wizard for IBM Informix Client-SDK Version 3.50 The InstallShield Wizard will install IBM Informix Client-SDK Version 3.50 on your computer. To continue,choose Next. IBM Informix Client-SDK Version 3.50 IBM Corporation http://www.ibm.com Press 1 for Next,3 to Cancel or 4 to Redisplay [1] (回车) ------------------------------------------------------------------------------- ? ? ?International Program License Agreement? ? ? ?? ? ? ?Part 1 - General Terms? ? ? ?? ? ? ?BY DOWNLOADING,INSTALLING,COPYING,ACCESSING,OR USING THE PROGRAM? ? ? ?YOU AGREE TO THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCEPTING THESE ? ? ? TERMS ON BEHALF OF ANOTHER PERSON OR A COMPANY OR OTHER LEGAL ? ? ? ENTITY,YOU REPRESENT AND WARRANT THAT YOU HAVE FULL AUTHORITY TO ? ? ? BIND THAT PERSON,COMPANY,OR LEGAL ENTITY TO THESE TERMS. IF YOU DO ? ? ? NOT AGREE TO THESE TERMS,? ? ? ? ? ? ? ? - DO NOT DOWNLOAD,INSTALL,COPY,ACCESS,OR USE THE PROGRAM; AND? ? ? ? ? ? ? ? - PROMPTLY RETURN THE PROGRAM AND PROOF OF ENTITLEMENT TO THE PARTY Press Enter to continue viewing the license agreement,or,Enter "1" to accept? the agreement,"2" to decline it or "99" to go back to the previous screen,"3" ?Print. 1 (输入1,回车) Press 1 for Next,2 for Previous,3 to Cancel or 4 to Redisplay [1] (回车) ------------------------------------------------------------------------------- IBM Informix Client-SDK Version 3.50 Install Location Please specify a directory or press Enter to accept the default directory. Directory Name: [/opt/informix] (回车) Press 1 for Next,3 to Cancel or 4 to Redisplay [1] (回车) ------------------------------------------------------------------------------- Choose the setup type that best suits your needs. [X] 1 - Typical ? ? ? ? The program will be installed with the suggested configuration. ? ? ? ? Recommended for most users. ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? [ ] 2 - Custom ? ? ? ? The program will be installed with the features you choose. ? ? ? ? Recommended for advanced users. To select an item enter its number,or 0 when you are finished: [0] 2(输入2,回车) [ ] 1 - Typical ? ? ? ? The program will be installed with the suggested configuration. ? ? ? ? Recommended for most users. ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? [X] 2 - Custom ? ? ? ? The program will be installed with the features you choose. ? ? ? ? Recommended for advanced users. To select an item enter its number,or 0 when you are finished: [0] (回车) Press 1 for Next,3 to Cancel or 4 to Redisplay [1] (回车) ------------------------------------------------------------------------------- Select the features for "IBM Informix Client-SDK Version 3.50" you would like to install: ? ?IBM Informix Client-SDK Version 3.50 ? ?To select/deselect a feature or to view its children,type its number: ? ? ?1. ?[x] Client (installed) ? ? ?2. ?[x] Messages (installed) ? ? ?3. ?[x] Global Language Support (GLS) (installed) ? ?Other options: ? ? ?0. Continue installing ? ?Enter command [0] (回车) Press 1 for Next,3 to Cancel or 4 to Redisplay [1] (回车) ------------------------------------------------------------------------------- IBM Informix Client-SDK Version 3.50 will be installed in the following location: /opt/informix with the following features: Client Messages Global Language Support (GLS) for a total size: ?95.1 MB Press 1 for Next,3 to Cancel or 4 to Redisplay [1]? Installing IBM Informix Client-SDK Version 3.50. Please wait... |-----------|-----------|-----------|------------| 0% ? ? ? ? 25% ? ? ? ? 50% ? ? ? ? 75% ? ? ? ?100% |||||||||||||||||||||||||||||||||||||||||||||||||| Creating uninstaller... Performing GSKit installation for Linux ... Branding Files ... Installing directory . Installing directory etc Installing directory bin Installing directory lib Installing directory lib/client Installing directory lib/client/csm Installing directory lib/esql Installing directory lib/dmi Installing directory lib/c++ Installing directory lib/cli Installing directory release Installing directory release/en_us Installing directory release/en_us/0333 Installing directory incl Installing directory incl/esql Installing directory incl/dmi Installing directory incl/c++ Installing directory incl/cli Installing directory demo Installing directory demo/esqlc Installing directory demo/c++ Installing directory demo/cli Installing directory doc Installing directory doc/gls_api Installing directory doc/gls_api/en_us Installing directory doc/gls_api/en_us/0333 Installing directory tmp Installing directory gsk Installing directory gsk/client Installing directory gskit Installing directory gsk Installing directory gsk/client IBM Informix Product: ? ? ? IBM INFORMIX-Client SDK Installation Directory: /opt/informix Performing root portion of installation of IBM INFORMIX-Client SDK... Installation of IBM INFORMIX-Client SDK complete. Installing directory etc Installing directory gls Installing directory gls/cm3 Installing directory gls/cv9 Installing directory gls/dll Installing directory gls/etc Installing directory gls/lc11 Installing directory gls/lc11/cs_cz Installing directory gls/lc11/da_dk Installing directory gls/lc11/de_at Installing directory gls/lc11/de_ch Installing directory gls/lc11/de_de Installing directory gls/lc11/en_au Installing directory gls/lc11/en_gb Installing directory gls/lc11/en_us Installing directory gls/lc11/es_es Installing directory gls/lc11/fi_fi Installing directory gls/lc11/fr_be Installing directory gls/lc11/fr_ca Installing directory gls/lc11/fr_ch Installing directory gls/lc11/fr_fr Installing directory gls/lc11/is_is Installing directory gls/lc11/it_it Installing directory gls/lc11/ja_jp Installing directory gls/lc11/ko_kr Installing directory gls/lc11/nl_be Installing directory gls/lc11/nl_nl Installing directory gls/lc11/no_no Installing directory gls/lc11/os Installing directory gls/lc11/pl_pl Installing directory gls/lc11/pt_br Installing directory gls/lc11/pt_pt Installing directory gls/lc11/ru_ru Installing directory gls/lc11/sk_sk Installing directory gls/lc11/sv_se Installing directory gls/lc11/th_th Installing directory gls/lc11/zh_cn Installing directory gls/lc11/zh_tw IBM Informix Product: ? ? ? Gls Installation Directory: /opt/informix Performing root portion of installation of Gls... Installation of Gls complete. Installing directory etc Installing directory msg Installing directory msg/en_us Installing directory msg/en_us/0333 IBM Informix Product: ? ? ? messages Installation Directory: /opt/informix Performing root portion of installation of messages... Installation of messages complete. ------------------------------------------------------------------------------- The InstallShield Wizard has successfully installed IBM Informix Client-SDK Version 3.50. Choose Finish to exit the wizard. Press 3 to Finish or 4 to Redisplay [3] (回车) /opt/informix #? 2.设置root环境变量 1)./etc/profile # End of /etc/profile # export INFORMIXDIR=/opt/informix export INFORMIXSERVER=ol_informix001(server_name) export LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql export PATH=$PATH:$INFORMIXDIR/bin export DBI_DBNAME=stores_demo(database) export DBD_INFORMIX_DATABASE=stores_demo(database) export DBD_INFORMIX_USERNAME=informix(user) export DBD_INFORMIX_PASSWORD=informix(name) 2).配置sqlhosts # more /opt/informix/etc/sqlhosts # ************************************************************************ # # ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? IBM INC. # # ? ? ? ? ? ? ? ? ? ? ? ? ? ? PROPRIETARY DATA # # ? ?Licensed Material - Property Of IBM # # ? ?"Restricted Materials of IBM" # # ? ?IBM Informix Client SDK # # ? ?(c) ?Copyright IBM Corporation 2002. All rights reserved. # # ? Title: ? ? ?sqlhosts.demo # ? Description: # ? ? ? ? ? ? ? Default sqlhosts file for running demos. # #************************************************************************** ol_informix001 onsoctcp 192.168.0.1 2008 #? 3.安装Test-Pod root用户登录编译 Test-Pod-1.48.tar.gz 4.编译Perl Informix DBD 模块 1)rpm 包需求 perl-5.10.0-64.47.8 perl-DBI-1.607-1.16 2)编译安装DBD-Informix informix账户登录执行安装 > tar zxvf DBD-Informix-2013.0521.tar.gz? DBD-Informix-2013.0521/ DBD-Informix-2013.0521/Announce DBD-Informix-2013.0521/bug-lvcnn.ec DBD-Informix-2013.0521/bug-lvcnn.pl DBD-Informix-2013.0521/BugReport DBD-Informix-2013.0521/ChangeLog DBD-Informix-2013.0521/DBD-Informix.jdc DBD-Informix-2013.0521/DBD-Informix.msd DBD-Informix-2013.0521/DBD-Informix.nmd DBD-Informix-2013.0521/dbdattr.ec DBD-Informix-2013.0521/dbdimp.ec DBD-Informix-2013.0521/dbdimp.h DBD-Informix-2013.0521/dbdixmap.h DBD-Informix-2013.0521/debug.h DBD-Informix-2013.0521/decfix.c DBD-Informix-2013.0521/decsci.c DBD-Informix-2013.0521/decsci.h DBD-Informix-2013.0521/decsetexp.c DBD-Informix-2013.0521/dumpesql.h DBD-Informix-2013.0521/eprintf.c DBD-Informix-2013.0521/esql5_00.h DBD-Informix-2013.0521/esql7_20.h DBD-Informix-2013.0521/esql_ius.h DBD-Informix-2013.0521/esqlbasic.ec DBD-Informix-2013.0521/esqlc.h DBD-Informix-2013.0521/esqlc_v5.ec DBD-Informix-2013.0521/esqlc_v6.ec DBD-Informix-2013.0521/esqlcc DBD-Informix-2013.0521/esqlcver.ec DBD-Informix-2013.0521/esqlld DBD-Informix-2013.0521/esqllib.h DBD-Informix-2013.0521/esqlperl.h DBD-Informix-2013.0521/esqlsed DBD-Informix-2013.0521/esqltest.ec DBD-Informix-2013.0521/esqltype.h DBD-Informix-2013.0521/esqlutil.h DBD-Informix-2013.0521/examples/ DBD-Informix-2013.0521/ifmxdec.h DBD-Informix-2013.0521/inc/ DBD-Informix-2013.0521/Informix.h DBD-Informix-2013.0521/Informix.pm DBD-Informix-2013.0521/Informix.xs DBD-Informix-2013.0521/InformixTechSupport DBD-Informix-2013.0521/ItWorks DBD-Informix-2013.0521/ixblob.ec DBD-Informix-2013.0521/ixblob.h DBD-Informix-2013.0521/jtypes.c DBD-Informix-2013.0521/kludge.c DBD-Informix-2013.0521/kludge.h DBD-Informix-2013.0521/lib/ DBD-Informix-2013.0521/link.c DBD-Informix-2013.0521/link.h DBD-Informix-2013.0521/Makefile.PL DBD-Informix-2013.0521/MANIFEST DBD-Informix-2013.0521/META.yml DBD-Informix-2013.0521/mknmd.sh DBD-Informix-2013.0521/Notes/ DBD-Informix-2013.0521/odbctype.c DBD-Informix-2013.0521/odbctype.h DBD-Informix-2013.0521/prodverstamp.sh DBD-Informix-2013.0521/README DBD-Informix-2013.0521/Release.Checklist DBD-Informix-2013.0521/sqltoken.c DBD-Informix-2013.0521/sqltoken.h DBD-Informix-2013.0521/sqltype.ec DBD-Informix-2013.0521/t/ DBD-Informix-2013.0521/test.all.sh DBD-Informix-2013.0521/test.c4gl.sh DBD-Informix-2013.0521/test.one.sh DBD-Informix-2013.0521/test.quiet.sh DBD-Informix-2013.0521/test.run.sh DBD-Informix-2013.0521/TODO DBD-Informix-2013.0521/t/decgen.pl DBD-Informix-2013.0521/t/dtgen.pl DBD-Informix-2013.0521/t/t00basic.t DBD-Informix-2013.0521/t/t01stproc.t DBD-Informix-2013.0521/t/t02ixtype.t DBD-Informix-2013.0521/t/t05dbase.t DBD-Informix-2013.0521/t/t07dblist.t DBD-Informix-2013.0521/t/t08fork.t DBD-Informix-2013.0521/t/t09date.t DBD-Informix-2013.0521/t/t10sqlca.t DBD-Informix-2013.0521/t/t12bindval.t DBD-Informix-2013.0521/t/t13bindref.t DBD-Informix-2013.0521/t/t14bindcol.t DBD-Informix-2013.0521/t/t15bindtyp.t DBD-Informix-2013.0521/t/t20error.t DBD-Informix-2013.0521/t/t21mconn.t DBD-Informix-2013.0521/t/t22mconn.t DBD-Informix-2013.0521/t/t23mconn.t DBD-Informix-2013.0521/t/t24mcurs.t DBD-Informix-2013.0521/t/t25dratt.t DBD-Informix-2013.0521/t/t28dtlit.t DBD-Informix-2013.0521/t/t29update.t DBD-Informix-2013.0521/t/t30update.t DBD-Informix-2013.0521/t/t31nulls.t DBD-Informix-2013.0521/t/t32nulls.t DBD-Informix-2013.0521/t/t33holdcurs.t DBD-Informix-2013.0521/t/t35cursor.t DBD-Informix-2013.0521/t/t40rows.t DBD-Informix-2013.0521/t/t41txacoff.t DBD-Informix-2013.0521/t/t42txacon.t DBD-Informix-2013.0521/t/t43trans.t DBD-Informix-2013.0521/t/t44txansi.t DBD-Informix-2013.0521/t/t46chpblk.t DBD-Informix-2013.0521/t/t50update.t DBD-Informix-2013.0521/t/t51getinfo.t DBD-Informix-2013.0521/t/t53types.t DBD-Informix-2013.0521/t/t54native.t DBD-Informix-2013.0521/t/t55mdata.t DBD-Informix-2013.0521/t/t56tabinfo.t DBD-Informix-2013.0521/t/t57tables.t DBD-Informix-2013.0521/t/t58typeinfoall.t DBD-Informix-2013.0521/t/t60unlog.t DBD-Informix-2013.0521/t/t61varchar.t DBD-Informix-2013.0521/t/t65updcur.t DBD-Informix-2013.0521/t/t66insert.t DBD-Informix-2013.0521/t/t72blob.t DBD-Informix-2013.0521/t/t73blobupd.t DBD-Informix-2013.0521/t/t74blob.t DBD-Informix-2013.0521/t/t75blob.t DBD-Informix-2013.0521/t/t76blob.t DBD-Informix-2013.0521/t/t77varchar.t DBD-Informix-2013.0521/t/t78varchar.t DBD-Informix-2013.0521/t/t90ius.t DBD-Informix-2013.0521/t/t91udts.t DBD-Informix-2013.0521/t/t92rows.t DBD-Informix-2013.0521/t/t93lvarchar.t DBD-Informix-2013.0521/t/t94bool.t DBD-Informix-2013.0521/t/t95int8.t DBD-Informix-2013.0521/t/t98pod.t DBD-Informix-2013.0521/t/t99clean.t DBD-Informix-2013.0521/Notes/bug.reports DBD-Informix-2013.0521/Notes/environment.variables DBD-Informix-2013.0521/Notes/eprintf DBD-Informix-2013.0521/Notes/FAQ DBD-Informix-2013.0521/Notes/hpux DBD-Informix-2013.0521/Notes/hpux-gcc-build.sh DBD-Informix-2013.0521/Notes/linux DBD-Informix-2013.0521/Notes/load.unload DBD-Informix-2013.0521/Notes/nonroot.install DBD-Informix-2013.0521/Notes/nt DBD-Informix-2013.0521/Notes/olipcshm DBD-Informix-2013.0521/Notes/static.build DBD-Informix-2013.0521/Notes/web.servers DBD-Informix-2013.0521/Notes/Working.Versions DBD-Informix-2013.0521/lib/Bundle/ DBD-Informix-2013.0521/lib/DBD/ DBD-Informix-2013.0521/lib/DBD/Informix/ DBD-Informix-2013.0521/lib/DBD/Informix/Configure.pm DBD-Informix-2013.0521/lib/DBD/Informix/GetInfo.pm DBD-Informix-2013.0521/lib/DBD/Informix/Metadata.pm DBD-Informix-2013.0521/lib/DBD/Informix/Summary.pm DBD-Informix-2013.0521/lib/DBD/Informix/TechSupport.pm DBD-Informix-2013.0521/lib/DBD/Informix/TestHarness.pm DBD-Informix-2013.0521/lib/DBD/Informix/TypeInfo.pm DBD-Informix-2013.0521/lib/Bundle/DBD/ DBD-Informix-2013.0521/lib/Bundle/DBD/Informix.pm DBD-Informix-2013.0521/inc/ExtUtils/ DBD-Informix-2013.0521/inc/ExtUtils/AutoInstall.pm DBD-Informix-2013.0521/examples/fetchscroll.pl DBD-Informix-2013.0521/examples/fixin.pl DBD-Informix-2013.0521/examples/README DBD-Informix-2013.0521/examples/x01fetchall.pl DBD-Informix-2013.0521/examples/x02fetchrow_array.pl DBD-Informix-2013.0521/examples/x03fetchrow_arrayref.pl DBD-Informix-2013.0521/examples/x04fetchrow_hashref.pl DBD-Informix-2013.0521/examples/x05fetchall_arrayref.pl DBD-Informix-2013.0521/examples/x06chopblanks.pl DBD-Informix-2013.0521/examples/x07fetchrow_array.pl DBD-Informix-2013.0521/examples/x10cgi_nodbi.pl DBD-Informix-2013.0521/examples/x11cgi_nodbi.pl DBD-Informix-2013.0521/examples/x12cgi_noform.pl DBD-Informix-2013.0521/examples/x13cgi_noform.pl DBD-Informix-2013.0521/examples/x14cgi_form.pl DBD-Informix-2013.0521/examples/x15cgi_form.pl > > cd DBD-Informix-2013.0521/ > perl Makefile.PL? *** ExtUtils::AutoInstall version 0.63 *** Checking for dependencies... [Core Features] - DBI ? ? ? ? ...loaded. (1.607 >= 1.38) [High Resolution Timing] - Time::HiRes ...loaded. (1.9711) [POD Format Testing] - Test::Pod ? ...loaded. (1.48) *** ExtUtils::AutoInstall configuration finished. Configuring Informix Database Driver for Perl DBI Version 2013.0521 (2013-05-21) (aka DBD::Informix) ? ? ? ? You are using DBI version 1.607 and Perl version 5.010000 Remember to actually read the README file! Perl: ? ? /usr/bin/perl v5.010000 x86_64-linux-thread-multi dl_dlopen.xs System: ? linux knorr 2.6.32 #1 smp 2010-04-12 12:31:11 +0200 x86_64 x86_64 x86_64 gnulinux? *** Ideally,you should upgrade to Perl version 5.016003 or later. *** Ideally,you should upgrade to DBI version 1.627 or later. Using INFORMIXDIR=/opt/informix and ESQL/C compiler esql Using IBM Informix CSDK Version 3.50,IBM Informix-ESQL Version 3.50.FC5 from /opt/informix Beware: DBD::Informix is not yet aware of all the new IUS data types. Assert macro will be disabled! lib/DBD/Informix/Defaults.pm written OK esqlinfo.h written OK Testing whether your Informix test environment will work... ESQLTEST Program Running: @(#)$Id: esqltest.ec,v 2008.1 2008/05/13 23:13:10 jleffler Exp $ ? ? ? ? $INFORMIXDIR is set to '/opt/informix'. ? ? ? ? $INFORMIXSERVER is set to 'ol_informix1170'. ? ? ? ? $DBI_DBNAME set to 'demo'. ? ? ? ? $DBD_INFORMIX_DATABASE set to 'stores_demo'. ? ? ? ? $DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores_demo'. ? ? ? ? $DBD_INFORMIX_USERNAME is set to 'informix'. ? ? ? ? $DBD_INFORMIX_USERNAME2 is unset - defaulting to 'informix'. ? ? ? ? $DBD_INFORMIX_PASSWORD is set. ? ? ? ? $DBD_INFORMIX_PASSWORD2 is unset - defaulting to $DBD_INFORMIX_PASSWORD. Testing connection to stores_demo ? ? ? ? CONNECT TO 'stores_demo' with user info Testing concurrent connection to stores_demo ? ? ? ? CONNECT TO 'stores_demo' with user info Your Informix environment is (probably) OK Checking if your kit is complete... Looks good Using DBI 1.607 (for perl 5.010000 on x86_64-linux-thread-multi) installed in /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/ Writing Makefile for DBD::Informix informix@WebReportServ:/home/informix-dbd/DBD-Informix-2013.0521> make cp lib/DBD/Informix/Summary.pm blib/lib/DBD/Informix/Summary.pm cp lib/DBD/Informix/TechSupport.pm blib/lib/DBD/Informix/TechSupport.pm cp lib/DBD/Informix/GetInfo.pm blib/lib/DBD/Informix/GetInfo.pm cp lib/Bundle/DBD/Informix.pm blib/lib/Bundle/DBD/Informix.pm cp lib/DBD/Informix/Configure.pm blib/lib/DBD/Informix/Configure.pm cp Informix.pm blib/lib/DBD/Informix.pm cp lib/DBD/Informix/TestHarness.pm blib/lib/DBD/Informix/TestHarness.pm cp lib/DBD/Informix/TypeInfo.pm blib/lib/DBD/Informix/TypeInfo.pm cp lib/DBD/Informix/Defaults.pm blib/lib/DBD/Informix/Defaults.pm cp lib/DBD/Informix/Metadata.pm blib/lib/DBD/Informix/Metadata.pm /usr/bin/perl -p -e "s/~DRIVER~/Informix/g" /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/Driver.xst > Informix.xsi /usr/bin/perl /usr/lib/perl5/5.10.0/ExtUtils/xsubpp ?-typemap /usr/lib/perl5/5.10.0/ExtUtils/typemap Informix.xs > Informix.xsc && mv Informix.xsc Informix.c cc -c ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? -DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC "-I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE" ?-DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T Informix.c Informix.xsi: In function ??S_DBD__Informix__db_disconnect? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?Informix.xsi:306: warning: format ?ld?expects type ??ong int? but argument 2 has type ??32? Informix.xsi:306: warning: format ?ld?expects type ??ong int? but argument 3 has type ??32? Informix.xsi: In function ??S_DBD__Informix__db_DESTROY? ? ?Informix.xsi:352: warning: format ?ld?expects type ??ong int? but argument 2 has type ??32? Informix.xsi:352: warning: format ?ld?expects type ??ong int? but argument 3 has type ??32? Informix.xsi:380: warning: format ?ld?expects type ??ong int? but argument 2 has type ??32? Informix.xsi:380: warning: format ?ld?expects type ??ong int? but argument 3 has type ??32? Informix.xsi: In function ??S_DBD__Informix__st_finish? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Informix.xsi:675: warning: format ?ld?expects type ??ong int? but argument 2 has type ??32? Informix.xsi:675: warning: format ?ld?expects type ??ong int? but argument 3 has type ??32? Informix.xsi: In function ??S_DBD__Informix__st_DESTROY? ? ?Informix.xsi:752: warning: format ?ld?expects type ??ong int? but argument 2 has type ??32? Informix.xsi:752: warning: format ?ld?expects type ??ong int? but argument 3 has type ??32? Informix.xsi:766: warning: format ?ld?expects type ??ong int? but argument 2 has type ??32? Informix.xsi:766: warning: format ?ld?expects type ??ong int? but argument 3 has type ??32? INFORMIXC="/usr/bin/perl esqlcc" ESQLCC="cc" esql -c -shared ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI ?-D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? ?-DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE -DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T dbdimp.ec dbdimp.ec: In function ??bd_ix_db_connect? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? dbdimp.ec:623: warning: format ?ld?expects type ??ong int? but argument 2 has type ??32? dbdimp.ec:623: warning: format ?ld?expects type ??ong int? but argument 3 has type ??32? dbdimp.ec: In function ??bd_ix_db_disconnect? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?dbdimp.ec:909: warning: format ?ld?expects type ??ong int? but argument 2 has type ??32? dbdimp.ec:909: warning: format ?ld?expects type ??ong int? but argument 3 has type ??32? dbdimp.ec: In function ??bd_ix_st_finish? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? dbdimp.ec:2201: warning: format ?ld?expects type ??ong int? but argument 2 has type ??32? dbdimp.ec:2201: warning: format ?ld?expects type ??ong int? but argument 3 has type ??32? dbdimp.ec: In function ??bd_ix_st_bind_type? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? dbdimp.ec:3174: warning: format ?d?expects type ??nt? but argument 2 has type ??V? rm -f dbdimp.c INFORMIXC="/usr/bin/perl esqlcc" ESQLCC="cc" esql -c -shared ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI ?-D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? ?-DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE -DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T dbdattr.ec rm -f dbdattr.c cc -c ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? -DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC "-I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE" ?-DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T sqltoken.c INFORMIXC="/usr/bin/perl esqlcc" ESQLCC="cc" esql -c -shared ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI ?-D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? ?-DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE -DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T sqltype.ec rm -f sqltype.c INFORMIXC="/usr/bin/perl esqlcc" ESQLCC="cc" esql -c -shared ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI ?-D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? ?-DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE -DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T ixblob.ec rm -f ixblob.c cc -c ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? -DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC "-I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE" ?-DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T odbctype.c cc -c ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? -DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC "-I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE" ?-DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T kludge.c cc -c ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? -DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC "-I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE" ?-DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T link.c INFORMIXC="/usr/bin/perl esqlcc" ESQLCC="cc" esql -c -shared ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI ?-D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? ?-DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE -DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T esqlcver.ec rm -f esqlcver.c INFORMIXC="/usr/bin/perl esqlcc" ESQLCC="cc" esql -c -shared ?-I/opt/informix/incl/esql -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI -I/usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI ?-D_REENTRANT -D_GNU_SOURCE -DPERL_USE_SAFE_PUTENV -DDEBUGGING -fno-strict-aliasing -pipe -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -fmessage-length=0 -O2 -Wall -D_FORTIFY_SOURCE=2 -fstack-protector -funwind-tables -fasynchronous-unwind-tables -g -Wall -pipe ? ?-DVERSION="2013.0521" -DXS_VERSION="2013.0521" -fPIC -I/usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/CORE -DESQLC_VERSION=350 -DNDEBUG -DDO_NOT_USE_STDERR_H -DESQLC_IFX_LOC_T esqlc_v6.ec rm -f esqlc_v6.c Running Mkbootstrap for DBD::Informix () chmod 644 Informix.bs rm -f blib/arch/auto/DBD/Informix/Informix.so INFORMIXC='/usr/bin/perl esqlld' ESQLLD='cc -shared -L/usr/local/lib64' esql ?-shared -L/usr/local/lib64 Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o ?-o blib/arch/auto/DBD/Informix/Informix.so ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?? chmod 755 blib/arch/auto/DBD/Informix/Informix.so cp Informix.bs blib/arch/auto/DBD/Informix/Informix.bs chmod 644 blib/arch/auto/DBD/Informix/Informix.bs cp InformixTechSupport blib/script/InformixTechSupport /usr/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/InformixTechSupport Manifying blib/man1/InformixTechSupport.1 Manifying blib/man3/DBD::Informix::TechSupport.3pm Manifying blib/man3/DBD::Informix::Summary.3pm Manifying blib/man3/DBD::Informix::Configure.3pm Manifying blib/man3/DBD::Informix::TypeInfo.3pm Manifying blib/man3/DBD::Informix::TestHarness.3pm Manifying blib/man3/DBD::Informix::GetInfo.3pm Manifying blib/man3/Bundle::DBD::Informix.3pm Manifying blib/man3/DBD::Informix.3pm Manifying blib/man3/DBD::Informix::Defaults.3pm Manifying blib/man3/DBD::Informix::Metadata.3pm > make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0,'blib/lib','blib/arch')" t/t00basic.t t/t01stproc.t t/t02ixtype.t t/t05dbase.t t/t07dblist.t t/t08fork.t t/t09date.t t/t10sqlca.t t/t12bindval.t t/t13bindref.t t/t14bindcol.t t/t15bindtyp.t t/t20error.t t/t21mconn.t t/t22mconn.t t/t23mconn.t t/t24mcurs.t t/t25dratt.t t/t28dtlit.t t/t29update.t t/t30update.t t/t31nulls.t t/t32nulls.t t/t33holdcurs.t t/t35cursor.t t/t40rows.t t/t41txacoff.t t/t42txacon.t t/t43trans.t t/t44txansi.t t/t46chpblk.t t/t50update.t t/t51getinfo.t t/t53types.t t/t54native.t t/t55mdata.t t/t56tabinfo.t t/t57tables.t t/t58typeinfoall.t t/t60unlog.t t/t61varchar.t t/t65updcur.t t/t66insert.t t/t72blob.t t/t73blobupd.t t/t74blob.t t/t75blob.t t/t76blob.t t/t77varchar.t t/t78varchar.t t/t90ius.t t/t91udts.t t/t92rows.t t/t93lvarchar.t t/t94bool.t t/t95int8.t t/t98pod.t t/t99clean.t t/t00basic.t ........ ok ? ?? t/t01stproc.t ....... ok ?? t/t02ixtype.t ....... ok ? ?? t/t05dbase.t ........ ok ? ?? t/t07dblist.t ....... skipped: DBI->data_sources('Informix') because of username/password t/t08fork.t ......... ok ?? t/t09date.t ......... ok ? ?? t/t10sqlca.t ........ ok ?? t/t12bindval.t ...... ok ?? t/t13bindref.t ...... skipped: bind_param_inout not supported by DBD::Informix t/t14bindcol.t ...... ok ? ? t/t15bindtyp.t ...... ok ? ? t/t20error.t ........ ok ?? t/t21mconn.t ........ ok ? ? t/t22mconn.t ........ ok ?? t/t23mconn.t ........ ok ? ? t/t24mcurs.t ........ ok ? ?? t/t25dratt.t ........ ok ?? t/t28dtlit.t ........ ok ? ?? t/t29update.t ....... ok ?? t/t30update.t ....... ok ? ?? t/t31nulls.t ........ ok ?? t/t32nulls.t ........ ok ?? t/t33holdcurs.t ..... ok ? ? t/t35cursor.t ....... ok ? ? t/t40rows.t ......... ok ?? t/t41txacoff.t ...... ok ? ? t/t42txacon.t ....... ok ? ? t/t43trans.t ........ ok ? ? t/t44txansi.t ....... skipped: MODE ANSI test - database 'stores_demo' is not MODE ANSI t/t46chpblk.t ....... ok ? ? t/t50update.t ....... skipped: MODE ANSI test - database 'stores_demo' is not MODE ANSI t/t51getinfo.t ...... ok ? ?? t/t53types.t ........ ok ?? t/t54native.t ....... ok ?? t/t55mdata.t ........ ok ?? t/t56tabinfo.t ...... ok ?? t/t57tables.t ....... ok ?? t/t58typeinfoall.t .. ok ? ? t/t60unlog.t ........ ok ? ? t/t61varchar.t ...... ok ?? t/t65updcur.t ....... ok ? ? t/t66insert.t ....... ok ? ? t/t72blob.t ......... ok ? ? t/t73blobupd.t ...... ok ? ? t/t74blob.t ......... ok ? ? t/t75blob.t ......... ok ? ? t/t76blob.t ......... ok ?? t/t77varchar.t ...... ok ?? t/t78varchar.t ...... DBD::Informix::st execute failed: SQL: -2: No such file or directory at t/t78varchar.t line 55. !! Terminating Test !! ?at /home/informix-dbd/DBD-Informix-2013.0521/blib/lib/DBD/Informix/TestHarness.pm line 309 ? ? ? ? DBD::Informix::TestHarness::stmt_fail() called at t/t78varchar.t line 55 t/t78varchar.t ...... Dubious,test returned 255 (wstat 65280,0xff00) Failed 3/5 subtests? t/t90ius.t .......... ok ?? t/t91udts.t ......... ok ? ? t/t92rows.t ......... ok ? ? t/t93lvarchar.t ..... ok ? ? t/t94bool.t ......... ok ?? t/t95int8.t ......... ok ? ? t/t98pod.t .......... ok ? ?? t/t99clean.t ........ ok ?? Test Summary Report ------------------- t/t78varchar.t ? ?(Wstat: 65280 Tests: 3 Failed: 1) ? Failed test: ?3 ? Non-zero exit status: 255 ? Parse errors: Bad plan. ?You planned 5 tests but ran 3. Files=58,Tests=848,648 wallclock secs ( 0.87 usr ?0.14 sys + ?4.65 cusr ?0.62 csys = ?6.28 CPU) Result: FAIL Failed 1/58 test programs. 1/848 subtests failed. make: *** [test_dynamic] Error 255 informix@WebReportServ:/home/informix-dbd/DBD-Informix-2013.0521> su -c "make install" Password:? Files found in blib/arch: installing files in blib/lib into architecture dependent library tree Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Informix/Informix.so Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Informix/Informix.bs Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/Bundle/DBD/Informix.pm Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix.pm Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/Summary.pm Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/Configure.pm Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/GetInfo.pm Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/Metadata.pm Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/TypeInfo.pm Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/Defaults.pm Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/TechSupport.pm Installing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/DBD/Informix/TestHarness.pm Installing /usr/share/man/man1/InformixTechSupport.1 Installing /usr/share/man/man3/DBD::Informix::TypeInfo.3pm Installing /usr/share/man/man3/DBD::Informix::Defaults.3pm Installing /usr/share/man/man3/DBD::Informix::GetInfo.3pm Installing /usr/share/man/man3/DBD::Informix::Configure.3pm Installing /usr/share/man/man3/DBD::Informix::TechSupport.3pm Installing /usr/share/man/man3/DBD::Informix::Metadata.3pm Installing /usr/share/man/man3/DBD::Informix::TestHarness.3pm Installing /usr/share/man/man3/DBD::Informix::Summary.3pm Installing /usr/share/man/man3/DBD::Informix.3pm Installing /usr/share/man/man3/Bundle::DBD::Informix.3pm Installing /usr/bin/InformixTechSupport Writing /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBD/Informix/.packlist Appending installation info to /usr/lib/perl5/5.10.0/x86_64-linux-thread-multi/perllocal.pod >? 5.测试脚本 1).create table # more testInfix_create.pl? use DBI; printf("Create Table Sample DBD::Informix Program running.n");? my($user)="informix"; my($passwd)="informix"; my($database)="stores_demo"; my($dbh) = DBI->connect("DBI:Informix:$database",$user,$passwd) or die; my $prep = "create table table01(? id serial not null,? msg char (200) )"; my($sth) = $dbh->prepare($prep) or die;? $sth->execute() or die;? $dbh->disconnect();? printf("nCreate Table ?Sample Program over.nn"); #? 2).insert record # more testInfix_insert.pl? use DBI; printf("Insert Record Into Table Sample DBD::Informix Program running.n");? my($user)="informix"; my($passwd)="informix"; my($database)="stores_demo"; my($dbh) = DBI->connect("DBI:Informix:$database",$passwd) or die; my $prep = "insert into table01(msg) values('event01')"; my($sth) = $dbh->prepare($prep) or die;? $sth->execute() or die;? $dbh->disconnect();? printf("nInsert Record Into Table Sample Program over.nn"); #? 3).read records # more testInfix.pl? use strict; use DBI; printf("Read Records From Table Sample DBD::Informix Program running.n");? my($user)="informix"; my($passwd)="informix"; my($database)="stores_demo"; my($dbh) = DBI->connect("DBI:Informix:$database",$passwd) or die; my $prep = "SELECT * FROM table01"; my($sth) = $dbh->prepare($prep) or die;? $sth->execute() or die;? my($id,$msg);? while (($id,$msg) = $sth->fetchrow_array()) {? printf("%s %s n",($id,$msg));? } undef $sth;? $dbh->disconnect();? printf("nRead Records From Table Sample Program over.nn"); # (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |