f



RE: Informix DBD, PERL and esql #2

After stripping every flag out of the esql program that it whined about
I get down to:
 gcc: CC_TH=gcc: No such file or directory
 In file included from /usr/include/sys/localedef.h:46,
                  from
/opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.2.0.0/3.3.2/include/stdlib.h:
538,
                  from esqlbasic.ec:25:
 /usr/include/sys/localedef31.h:195: error: conflicting types for
`loc_t'
 /opt/informix/IDS_9.40.FC6/incl/esql/locator.h:123: error: previous
declaration of `loc_t'

This is my last post on this, hate to torment you folks with my lack of
gcc prowess.
No comments from you OTC! :)

Thanks again, 
Sam


-----Original Message-----
From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
On Behalf Of Gentsch, Sam 
Sent: Thursday, June 23, 2005 5:50 PM
To: informix-list@iiug.org
Subject: RE: Informix DBD, PERL and esql

 sorry I suck.

When running esql -o esqlbasic esqlbasic.ec

-----Original Message-----
From: Gentsch, Sam
Sent: Thursday, June 23, 2005 4:08 PM
To: informix-list@iiug.org
Subject: Informix DBD, PERL and esql

Actually this is a esqlc problem and may be because we are trying to use
gcc instead of cc_r

I receive
gcc: '-b' must come at the start of the command line Or cc: '-b' must
come at the start of the command line if INFORMIXC not set.

IBM Support said there was a bug for 4gl basically saying gcc does not
work with it and they were not planning on fixing it (and the support
guy said that meant it was true for ESQLC too)

So has anyone managed to overcome this problem and successfully use gcc
with AIX 5.3?

Hopefully, I am missing something simple.

Thanks a lot!

Sam

System info follows (probably more than you want)

 Perl:     perl v5.008007 aix-64all dl_aix.xs
 System:   aix aix 3 5 00cc339e4c00 (5.3)
 Using INFORMIXDIR=/opt/informix/IDS_9.40.FC6 and ESQL/C compiler esql
Using IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.FC3
from /opt/informix/IDS_9.40.FC6  DBI 1.48 installed  IDS 9.40FC6, with a
stores
 gcc: 3.3.2

Have INFORMIXC=gcc
DBD_INFORMIX_ESQLC_LINKAGE='-b' //tried it anyways Changed
LD_LIBRARY_PATH to LIBPATH since on AIX



Big -V stuff:
 gcc -v
 Reading specs from
/opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.2.0.0/3.3.2/specs
 Configured with: ../configure --with-as=/usr/bin/as
--with-ld=/usr/bin/ld --disable-nls --enable-languages=c,c++
--prefix=/opt/freeware --enable-threads
--enable-version-specific-runtime-libs --host=powerpc-ibm-aix5.2.0.0
Thread model: aix  gcc version 3.3.2

perl -V
 Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
   Platform:
     osname=aix, osvers=5.3.0.0, archname=aix-64all
     uname='aix aix 3 5 00cc339e4c00 '
     config_args='-Dcc=gcc'
     hint=recommended, useposix=true, d_sigaction=define
     usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
     useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
     use64bitint=define use64bitall=define uselongdouble=undef
     usemymalloc=n, bincompat5005=undef
  Compiler:
     cc='gcc', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-DUSE_NATIVE_DLOPEN -fno-strict-aliasing -pipe -maix64
-DUSE_64_BIT_ALL',
     optimize='-O',
     cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
-DUSE_NATIVE_DLOPEN -fno-strict-aliasing -pipe'
     ccversion='', gccversion='3.3.2', gccosandvers='aix5.2.0.0'
     intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321
     d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
     ivtype='long long', ivsize=8, nvtype='double', nvsize=8,
Off_t='off_t', lseeksize=8
     alignbytes=8, prototype=define
 Linker and Libraries:
     ld='gcc -maix64', ldflags =' -Wl,-brtl -Wl,-bdynamic
-Wl,-bmaxdata:0x80000000 -maix64 -Wl,-b64'
     libpth=/lib /usr/lib /usr/ccs/lib
     libs=-lbind -lnsl -ldbm -ldl -lld -lm -lcrypt -lc -lbsd
     perllibs=-lbind -lnsl -ldl -lld -lm -lcrypt -lc -lbsd
     libc=, so=a, useshrplib=false, libperl=libperl.a
     gnulibc_version=''
   Dynamic Linking:
     dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Xlinker
-bE:/usr/lib/perl5/5.8.7/aix-64all/CORE/perl.exp'
     cccdlflags=' ', lddlflags='  -Wl,-b64 -Wl,-bhalt:4 -Wl,-bexpall
-Wl,-G -Wl,-bnoentry -lc'
 

 

 Characteristics of this binary (from libperl):
   Compile-time options: USE_64_BIT_INT USE_64_BIT_ALL USE_LARGE_FILES
   Built under aix
   Compiled at Jun 23 2005 11:54:26
   @INC:
     /usr/lib/perl5/5.8.7/aix-64all
     /usr/lib/perl5/5.8.7
     /usr/lib/perl5/site_perl/5.8.7/aix-64all
     /usr/lib/perl5/site_perl/5.8.7
     /usr/lib/perl5/site_perl
 

sending to informix-list




sending to informix-list
0
Gentsch
6/24/2005 3:56:09 PM
comp.databases.informix 16083 articles. 0 followers. Post Follow

3 Replies
452 Views

Similar Articles

[PageSpeed] 3

this is some time ago.... may be off here...

please check rel.notes regarding loc_t; on aix you may get a clash with
a system header with loc_t. afaikr there is some kind of switch you
have to use in order to  overcome this...
i think this is doc'ed in the release notes.

Superboer.

-- Jonathan comments please.

Gentsch, Sam  schreef:
> After stripping every flag out of the esql program that it whined about
> I get down to:
>  gcc: CC_TH=gcc: No such file or directory
>  In file included from /usr/include/sys/localedef.h:46,
>                   from
> /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.2.0.0/3.3.2/include/stdlib.h:
> 538,
>                   from esqlbasic.ec:25:
>  /usr/include/sys/localedef31.h:195: error: conflicting types for
> `loc_t'
>  /opt/informix/IDS_9.40.FC6/incl/esql/locator.h:123: error: previous
> declaration of `loc_t'
>
> This is my last post on this, hate to torment you folks with my lack of
> gcc prowess.
> No comments from you OTC! :)
>
> Thanks again,
> Sam
>
>
> -----Original Message-----
> From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org]
> On Behalf Of Gentsch, Sam
> Sent: Thursday, June 23, 2005 5:50 PM
> To: informix-list@iiug.org
> Subject: RE: Informix DBD, PERL and esql
>
>  sorry I suck.
>
> When running esql -o esqlbasic esqlbasic.ec
>
> -----Original Message-----
> From: Gentsch, Sam
> Sent: Thursday, June 23, 2005 4:08 PM
> To: informix-list@iiug.org
> Subject: Informix DBD, PERL and esql
>
> Actually this is a esqlc problem and may be because we are trying to use
> gcc instead of cc_r
>
> I receive
> gcc: '-b' must come at the start of the command line Or cc: '-b' must
> come at the start of the command line if INFORMIXC not set.
>
> IBM Support said there was a bug for 4gl basically saying gcc does not
> work with it and they were not planning on fixing it (and the support
> guy said that meant it was true for ESQLC too)
>
> So has anyone managed to overcome this problem and successfully use gcc
> with AIX 5.3?
>
> Hopefully, I am missing something simple.
>
> Thanks a lot!
>
> Sam
>
> System info follows (probably more than you want)
>
>  Perl:     perl v5.008007 aix-64all dl_aix.xs
>  System:   aix aix 3 5 00cc339e4c00 (5.3)
>  Using INFORMIXDIR=/opt/informix/IDS_9.40.FC6 and ESQL/C compiler esql
> Using IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.FC3
> from /opt/informix/IDS_9.40.FC6  DBI 1.48 installed  IDS 9.40FC6, with a
> stores
>  gcc: 3.3.2
>
> Have INFORMIXC=gcc
> DBD_INFORMIX_ESQLC_LINKAGE='-b' //tried it anyways Changed
> LD_LIBRARY_PATH to LIBPATH since on AIX
>
>
>
> Big -V stuff:
>  gcc -v
>  Reading specs from
> /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.2.0.0/3.3.2/specs
>  Configured with: ../configure --with-as=/usr/bin/as
> --with-ld=/usr/bin/ld --disable-nls --enable-languages=c,c++
> --prefix=/opt/freeware --enable-threads
> --enable-version-specific-runtime-libs --host=powerpc-ibm-aix5.2.0.0
> Thread model: aix  gcc version 3.3.2
>
> perl -V
>  Summary of my perl5 (revision 5 version 8 subversion 7) configuration:
>    Platform:
>      osname=aix, osvers=5.3.0.0, archname=aix-64all
>      uname='aix aix 3 5 00cc339e4c00 '
>      config_args='-Dcc=gcc'
>      hint=recommended, useposix=true, d_sigaction=define
>      usethreads=undef use5005threads=undef useithreads=undef
> usemultiplicity=undef
>      useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
>      use64bitint=define use64bitall=define uselongdouble=undef
>      usemymalloc=n, bincompat5005=undef
>   Compiler:
>      cc='gcc', ccflags ='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -DUSE_NATIVE_DLOPEN -fno-strict-aliasing -pipe -maix64
> -DUSE_64_BIT_ALL',
>      optimize='-O',
>      cppflags='-D_ALL_SOURCE -D_ANSI_C_SOURCE -D_POSIX_SOURCE
> -DUSE_NATIVE_DLOPEN -fno-strict-aliasing -pipe'
>      ccversion='', gccversion='3.3.2', gccosandvers='aix5.2.0.0'
>      intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=87654321
>      d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=8
>      ivtype='long long', ivsize=8, nvtype='double', nvsize=8,
> Off_t='off_t', lseeksize=8
>      alignbytes=8, prototype=define
>  Linker and Libraries:
>      ld='gcc -maix64', ldflags =' -Wl,-brtl -Wl,-bdynamic
> -Wl,-bmaxdata:0x80000000 -maix64 -Wl,-b64'
>      libpth=/lib /usr/lib /usr/ccs/lib
>      libs=-lbind -lnsl -ldbm -ldl -lld -lm -lcrypt -lc -lbsd
>      perllibs=-lbind -lnsl -ldl -lld -lm -lcrypt -lc -lbsd
>      libc=, so=a, useshrplib=false, libperl=libperl.a
>      gnulibc_version=''
>    Dynamic Linking:
>      dlsrc=dl_aix.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Xlinker
> -bE:/usr/lib/perl5/5.8.7/aix-64all/CORE/perl.exp'
>      cccdlflags=' ', lddlflags='  -Wl,-b64 -Wl,-bhalt:4 -Wl,-bexpall
> -Wl,-G -Wl,-bnoentry -lc'
>
>
>
>
>  Characteristics of this binary (from libperl):
>    Compile-time options: USE_64_BIT_INT USE_64_BIT_ALL USE_LARGE_FILES
>    Built under aix
>    Compiled at Jun 23 2005 11:54:26
>    @INC:
>      /usr/lib/perl5/5.8.7/aix-64all
>      /usr/lib/perl5/5.8.7
>      /usr/lib/perl5/site_perl/5.8.7/aix-64all
>      /usr/lib/perl5/site_perl/5.8.7
>      /usr/lib/perl5/site_perl
>  
> 
> sending to informix-list
> 
> 
> 
> 
> sending to informix-list

0
Superboer
6/27/2005 7:14:36 AM
ahum did a quick search for aix and
loc_t ...
check out 

-D_H_LOCALEDEF

Superboer.

0
Superboer
6/27/2005 7:22:59 AM
Superboer wrote:
> ahum did a quick search for aix and
> loc_t ...
> check out 
> 
> -D_H_LOCALEDEF

Yes - that was a major part of the problem.

Sam now has a severely hacked AIX-specific ESQL/C script that works with 
GCC.


-- 
Jonathan Leffler                   #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/
0
Jonathan
6/28/2005 5:27:25 AM
Reply:

Similar Artilces:

RE: Informix DBD, PERL and esql
sorry I suck. When running esql -o esqlbasic esqlbasic.ec -----Original Message----- From: Gentsch, Sam Sent: Thursday, June 23, 2005 4:08 PM To: informix-list@iiug.org Subject: Informix DBD, PERL and esql Actually this is a esqlc problem and may be because we are trying to use gcc instead of cc_r I receive gcc: '-b' must come at the start of the command line Or cc: '-b' must come at the start of the command line if INFORMIXC not set. IBM Support said there was a bug for 4gl basically saying gcc does not work with it and they were not planning on fixing it (and the support guy said that meant it was true for ESQLC too) So has anyone managed to overcome this problem and successfully use gcc with AIX 5.3? Hopefully, I am missing something simple. Thanks a lot! Sam System info follows (probably more than you want) Perl: perl v5.008007 aix-64all dl_aix.xs System: aix aix 3 5 00cc339e4c00 (5.3) Using INFORMIXDIR=/opt/informix/IDS_9.40.FC6 and ESQL/C compiler esql Using IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.FC3 from /opt/informix/IDS_9.40.FC6 DBI 1.48 installed IDS 9.40FC6, with a stores gcc: 3.3.2 Have INFORMIXC=gcc DBD_INFORMIX_ESQLC_LINKAGE='-b' //tried it anyways Changed LD_LIBRARY_PATH to LIBPATH since on AIX Big -V stuff: gcc -v Reading specs from /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.2.0.0/3.3.2/specs Configured with: ../configure --with-a...

RE: Informix DBD, PERL and esql #3
Gentsch, Sam said: > This is my last post on this, hate to torment you folks with my lack of > gcc prowess. > No comments from you OTC! :) I would never mock someone's inability to perform. Much. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche A smile is a gift that is free to the giver and precious to the recipient. But giving someone the finger is free too, and I find it more personal and sincere. sending to informix-list ...

RE: Informix DBD, PERL and esql #4
Thanks to all !! I posted most of it for your consumption, if you need it all email me, and I will send it. S -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Jonathan Leffler Sent: Tuesday, June 28, 2005 1:27 AM To: informix-list@iiug.org Subject: Re: Informix DBD, PERL and esql Superboer wrote: > ahum did a quick search for aix and > loc_t ... > check out > > -D_H_LOCALEDEF Yes - that was a major part of the problem. Sam now has a severely hacked AIX-specific ESQL/C script that works with GCC. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.01 -- http://dbi.perl.org/ sending to informix-list ...

Re: Database Server Hangs / Perl DBD Informix Module
I found a solution, It worked well with tcp connections, Looks like perl's Informix DBD Module doesn't like shared memory connections,at least with my versions. But I can live with tcp connections. Thanks anyway. I have other question , Does anybody knows how to actually get the number of rows returned/affected in a query with perl ? I tried with : $nrows=$sth->rows(); always returned 0. $nrows = $sth->{ix_sqlerrd}[2] always returned 0 too. Any ideas ? ----- Original Message ----- From: "Francisco Roldan" <f_roldan@admcentralag...

[Fwd: Re: Database Server Hangs / Perl DBD Informix Module]
This is a multi-part message in MIME format. --------------000806050204000100000404 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit I sent this to Francisco from the office, and I don't have direct posting access to news groups while I'm in the office. He agreed that the example code using rows worked and answered his questions. "Francisco Roldan" <f_roldan@admcentralagricola.com.gt> wrote: >> I found a solution, >> It worked well with tcp connections, >> Looks like perl's Informix DBD...

RE: Informix DBD, PERL and esql >>RESOLVED<<
Hello ALL! With the help of Jonathan, we managed to get PERL DBI/DBD built using gcc on AIX. Jonathan edited the esql wrapper script, and Edgar Riegger introduced me to the -maix64 flag. From there everything worked like a dream. I set the following environment variable. # NO - DBD_INFORMIX_ESQLC_LINKAGE=-static INFORMIXC=gcc And below is PART of the esql file that worked for me, I think I got all the changes in the post. Thanks again to everyone that helped. Sam : ' : ************************************************************************ : : 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: esql.sh : Description: : Source for shell script for running the ESQL/C preprocessor : : ************************************************************************ * : ' INFDIR=${INFORMIXDIR=/usr/informix} DB2CLIDIR=${INSTHOME=/usr/db2} PREPCC=${INFDIR}/lib/esql/esqlc # JL - removed (see below) #CC="${INFORMIXC=cc} -qchars=signed -q64 -qlanglvl=ansi -qalign=natural -qcheck=nullptr -qmaxmem=-1 -qspill=2000 -D_H_LOCALEDEF" #CC_TH="${INFORMIXC=xlc_r} -qchars=signed -q64 -qlanglvl=ansi -qalign=natural -qcheck=nullptr -qmaxmem=-1 -qspill=2000 ...

ANNOUNCE: DBD::Informix
IBM Informix Database Driver for Perl DBI Version 2005.01 (2005-03-14) has been uploaded to CPAN. IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.6.1 or later to access Informix databases via the DBI module (but if you are not already using Perl 5.8.5, you should be planning to upgrade to it). You will need the code for DBI version 1.38 or later as well (v1.48 recommended). The code for DBD::Informix is available for download via: http://www.perl.org/CPAN/modules/by-category/07_Database_Interfaces http://dbi.perl.org/ ** When you...

Re[2]: Strange behavior of DBI/DBD::Informix #2
Hi. I built a new test environment finally. The behavior is the same. No error appears if I disconnect before binding parameters and executing SQL. Here is the new tested versions information: DBI-1.37 DBD-Informix-2003.04 # esql -V INFORMIX-ESQL Version 9.51.UC3 IDS 9.30.UC1 and IDS 9.30.FC1 (both are checked) # perl -V Summary of my perl5 (revision 5.0 version 8 subversion 0) configuration: Platform: osname=solaris, osvers=2.8, archname=sun4-solaris uname='sunos name 5.8 generic_108528-19 sun4u sparc sunw,sun-blade-1000 ' config_args='-ds...

Informix DBD, PERL and esql
Actually this is a esqlc problem and may be because we are trying to use gcc instead of cc_r I receive gcc: '-b' must come at the start of the command line Or cc: '-b' must come at the start of the command line if INFORMIXC not set. IBM Support said there was a bug for 4gl basically saying gcc does not work with it and they were not planning on fixing it (and the support guy said that meant it was true for ESQLC too) So has anyone managed to overcome this problem and successfully use gcc with AIX 5.3? Hopefully, I am missing something simple. Thanks a lot! Sam System info follows (probably more than you want) Perl: perl v5.008007 aix-64all dl_aix.xs System: aix aix 3 5 00cc339e4c00 (5.3) Using INFORMIXDIR=/opt/informix/IDS_9.40.FC6 and ESQL/C compiler esql Using IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.FC3 from /opt/informix/IDS_9.40.FC6 DBI 1.48 installed IDS 9.40FC6, with a stores gcc: 3.3.2 Have INFORMIXC=gcc DBD_INFORMIX_ESQLC_LINKAGE='-b' //tried it anyways Changed LD_LIBRARY_PATH to LIBPATH since on AIX Big -V stuff: gcc -v Reading specs from /opt/freeware/lib/gcc-lib/powerpc-ibm-aix5.2.0.0/3.3.2/specs Configured with: ../configure --with-as=/usr/bin/as --with-ld=/usr/bin/ld --disable-nls --enable-languages=c,c++ --prefix=/opt/freeware --enable-threads --enable-version-specific-runtime-libs --host=powerpc-ibm-aix5.2.0.0 Thread model: aix gcc vers...

RE: [Maybe spam] Re: Relation of OS user to Informix database #2
You can only revoke a privilege that exists explicitly and you are the GRANTOR, if a user's rights are part of "public" then you cannot prevent the access unless you revoke connection privileges from public Regards Colin There are 10 types of people in the world, those that understand binary and those that don't >From: "Gosney Simon" <GosneyS@axxia.com> >To: "Jonathan Leffler" <jleffler@earthlink.net>, <informix-list@iiug.org> >Subject: RE: [Maybe spam] Re: Relation of OS user to Informix database >user >Date: Thu, 25 Aug 2005 08:48:31 +0100 > >Jonathan... am I correct in thinking that you can't revoke rights from a >user who has those rights because they're a member of public? > >Ie, if they don't have the rights assigned with an explicit GRANT >statement, then you can't revoke their rights without revoking public's >rights and then granting permissions to all other users individually? > >Cheers > >Simon > >-----Original Message----- >From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] >On Behalf Of Jonathan Leffler >Sent: 25 August 2005 05:24 >To: informix-list@iiug.org >Subject: [Maybe spam] Re: Relation of OS user to Informix database user > >anupam.mukherjee@gmail.com wrote: > > I had just installed Informix Advanced Server version 10.0 f...

Re: Perl DBD:Informix on NT
To avoid getting a C compiler and building the Informix module on Windows, I used the ODBC module and was able to connect to my Informix databases from Windows easily. Here were the steps: 1- Install the CSDK on Windows 2- Set all the connection info in setnet32 and test it with ilogin or dbping. 3- Create a ODBC DSN and test it. 4- Install the DBD:ODBC perl module 5- Create my perl script with using DBD:ODBC and the DSN created in setp 3. The only issues you may have are if you are using Informix specific features that are not supported in the ODBC module. If you stick to g...

Re: Start informix database #2
Hi.. This is an example INFORMIXDIR=/opt/informix PATH=$PATH:$HOME/bin:$INFORMIXDIR/bin INFORMIXSERVER=coldecon_shm ONCONFIG=onconfig.coldecon export PATH INFORMIXDIR INFORMIXSERVER ONCONFIG oninit INFORMIXSERVER=opera_shm ONCONFIG=onconfig.opera export PATH INFORMIXDIR INFORMIXSERVER ONCONFIG oninit --- madiego <madiego@qf21.com> wrote: > Hello, > > I had an informix database in the unix server. The > server has been > restarted and now I can't start the database. > I execute 'oninit' and only can started the default...

How to copy a sun-database in one informix database to another informix database?
Hi, Sorry I am not an informix dba, and I was faced to copy a sub-database(sorry I don't know the clear name of such concept, as informix is like sql-server, which used multiple database) from one informix database system to another informix database. I know in oracle, we can use transportable tablespace, copy the datafile and transport the metadata, and do something else. How can I do it in informix then? Is there document which talk about the detail step? Thanks It would really help if you knew the versions of the Informix databases. Assuming Informix IDS 7.x or IDS...

Re: Difference between Informix connect and Informix Client SDK #2
Hi Francisco. Client SDK is a developer's kit. You can create and compile program using ESQL/C (it is bundled.) Connect is a runtime of Client SDK. HTH. -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: Francisco Roldan <froldan@5b.com.gt> >To: informix-list@iiug.org >Subject: Difference between Informix connect and Informix Client SDK >Date: Tue, 8 Jul 2003 12:18:35 -0600 > >Does Somebody would tell me the difference between >those Informix products? > >And the estimated cost of each one (for Linux) ? > >...

RE: Informix database creation #2
Hi The existing chunk is already starting at offset of 500. Your new chunk should have the offset as 600501 . Regards Ravinder Bahadur _________________________________________________________________ Are you Unmarried? http://www.bharatmatrimony.com/cgi-bin/bmclicks1.cgi?4d Register in India's No 1 Matrimony. sending to informix-list "Ravinder Bahadur" <ravinder_b@hotmail.com> wrote in message news:bgsam4$i9q$1@terabinaries.xmission.com... > > Hi > The existing chunk is already starting at offset of 500. Your new chunk > sh...

RE: [Informix][Informix ODBC Driver] Database locale information mismatch
You could try issuing the following statement and see what the engine is configured for. onstat -g env This will give you the environment of the engine. I believe it is listed there what the locale is set to. David -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of bobkot@gmail.com Sent: Tuesday, May 23, 2006 7:28 AM To: informix-list@iiug.org Subject: [Informix][Informix ODBC Driver] Database locale information mismatch I have download ClientSDK 2.90.TC4 I am trying to connect to an IDS10 database. My iLogin works fine, but I cannot set up the ODBC driver, I keep getting the message "[Informix][Informix ODBC Driver] Database locale information mismatch" I cannot leave it blank, under environment, and I cannot find any matching pairs. Can somebody help. XP client and Linux server _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list Version 10.00.UC4E is what I am running. How do I determine what the database was created with ? I have no customer support - that is me - so where to for the patches ? Would that be for the IDS or the SDK This is a multipart message in MIME format. --=_alternative 0023D97D65257178_= Content-Type: text/plain; charset="US-ASCII" To find out what's the database locale in your environment go to the server in...

Re: Moving Informix TableSpaces between databases #2
I think your best bet would be to use HPL to unload data from the logged db and load it into the non-logged db as long as they both have the same schema(=table definition). Regards, Uday. "Aashish Ramsinghani - ASDC, Chennai" To <Aashishsr@hcl.in informix-list@iiug.org > cc Sent by: owner-informix-li Subject st@iiug.org Moving Informix TableSpaces between databases 12/09/2005 07:01 AM Hi I am using Informix for one of my DW projects. We are loading data from the source system into the staging area both are separate Databases. Source has logging enables and staging has it disabled. The problem comes when I try to access data across both these databases. I cannot link tables between these databases because of their logging properties. So I am dumping the data into a CSV file and loading it again but for my initial load which consists of 40+ million records it is a problem. In oracle I know we can make a separate table space and dump the data there then load the table space to another database. I don't know if such a thing is possible in Informix. Any help will be appreciated. Th...

Re: How to run Informix as a normal/unprivileged "informix" user? #2
--0-1804522149-1193257177=:47469 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable > Making the IDS start with SYSTEM account is even worse than starting it w= ith as an administrator of the system=0A=0AWhy is it worse? =0A=0ASYSTEM is= not a real user. Many server programs choose to run their services as SYST= EM for security purposes so the real users can be taken out of Administrato= rs group. Can you elaborate on your specific concerns about running IDS as = SYSTEM user.=0A=0AGuy=0A=0A=0A----- Original Message ----=0AFrom: "kdobrev@= gmail.com" <kdobrev@gmail.com>=0ATo: informix-list@iiug.org=0ASent: Wednesd= ay, October 24, 2007 2:07:11 AM=0ASubject: Re: How to run Informix as a nor= mal/unprivileged "informix" user?=0A=0A=0AI'm using Windows Server 2003 Sta= ndart. I have tried to make Informix=0Amember of Users instead of member of= Administrators, but a user cannot=0Astart services. I have given the right= to login as service, but still=0Ano luck. Making the IDS start with SYSTEM= account is even worse than=0Astarting it with as an administrator of the s= ystem.=0A=0AAny other suggestions?=0A=0A___________________________________= ____________=0AInformix-list mailing list=0AInformix-list@iiug.org=0Ahttp:/= /www.iiug.org/mailman/listinfo/informix-list=0A=0A=0A=0A=0A=0A_____________= _____________________________________=0ADo You Yahoo!?=0ATired of spam? Ya= hoo! Mail has th...

Re: Moving Data from Informix SE 4 to Informix SE 7 #2
"DBEXPORT bombs out on certain databases because of corrupted system > > tables and/or bad data." I have found that nearly all instances of DBEXPORT "bombing" are due to invalid data in date fields, especially when the data originated in 4.x or earlier versions of the database. The best way around the problem is by first finding the offending rows with a where clause that includes <datefieldname> not between "01011800" and "12312099" and then updating or deleting such rows with the same where clause. If you delete such rows,...

Re[2]: Strange behavior of DBI/DBD::Informix
Thank you for the reply. Sorry, I wrote late in the evening and forgot to post my configuration: Perl 5.6.1 AIX 4.2.1 (I know it's old but this should not be relevant to the problem) DBI 1.32 DBD-Informix-1.04.PC1 IDS 7.30.UC8 ESQL/C 9.30.UC1 SDK 2.40.UC1 All software is located on the same server. I could not test this with the newer version or on the other platform right now... Recently I sent just a scenario. Here is the working example (change appropriately environment, database name and column name): ~~~~~~~ cut here ~~~~~~~~~~~ #!/usr/l...

RE: How long can an Informix database name be? #2
The database name on SE is limited to 10 characters. This is an historical anomaly based on the fact that the database name was used as the directory name where that database will be stored. Directory names in early versions of unix were restricted to 14 characters, but that was including any extension, and as informix used dbname.dbs that restricted the database name to 10 characters. And beware - on some versions that ran on DOS it was further restricted to 8 characters - but that's another story. Regards Malcolm -----Original Message----- From: owner-informix-list@...

Re: Naming Convention for Informix Database Objects #2
Obnoxio The Clown wrote: > Christopher wrote: > > >>Can anyone recommend a good naming convention for database objects in >>Informix? >> >>Generally, I use my own variation on Hungarian, but I wondered if >>there is an equivalent of the RVBA (also known as Leszynski/Reddick) >>standard among Informix developers. >> >>I would also be thrilled to find a write-up I can reuse or just plain >>plagiarize. >> >>As an aside, this is to be implemented on IDS 9.4, so long identifiers >>are not an issue....

Re: Perl DBD::Informix and IDS 64-bit
Hi, I'm using Perl 64 bit on Solaris 9. The Sun provided Perl is 5.6.1 and 32bit. So I built my own 5.8.0 with the Sun CC 5.4 and DBD-Informix 2003.04 and DBI 1.34, CSDK 2.81FC2, IDS 7.31FD5. Works fine and is in production now. But I never managed it to get a DBI>1.34 working on this Plattform. I've escalated this case with IBM informix Support here in Germany, but it didn't get to Jonathan Leffeler I think. The problem was that DBI->errstr pointed in the wrong direction so that I got a Segmentation Violation when trying to print it. > I'm curio...

Re: Does Informix-SQL have Perl-like functions? #2
I saw what this functions do and it look awesome! What is interesting most, to me, is the term: "Bladelet" How it is related a Bladelet to a Datablade? Where can I find Information on "Bladelets"? Thanks in Advance, Chucho! Paul G. Brown wrote: > Professor Bruno <pyz@panix.com> wrote in message news:<bijd3j$mh8$1@reader2.panix.com>... > >>Greetings, >> >>Apologies if this has been answered before. >> >>Does Informix-SQL have functions such as Perl's 'split'. > > > htt...

Web resources about - RE: Informix DBD, PERL and esql #2 - comp.databases.informix

IBM Informix - Wikipedia, the free encyclopedia
IBM Informix is a product family within IBM's Information Management division that is centered on several relational database management system ...

IBM Informix (@IBM_Informix) on Twitter
Sign in Sign up To bring you Twitter, we and our partners use cookies on our and other websites. Cookies help personalize Twitter content, tailor ...

Informix - News, Features, and Slideshows
Latest news, features, and slideshows on Informix from Computerworld

Informix Database Administrator / Developer
Defining Technology for Australia's IT Leaders.

Informix technology whiz bails out for Andromedia
San Francisco, CA News - View Daily Local Business News, Resources & more in San Francisco, California. Informix, the Menlo Park-based database ...

S&P Stock Reports: Informix Corp.
Revenues in the first quarter of 1997 declined over 30%, owing to sluggishness associated with product transition uncertainties stemming from ...

Informix says Oracle is "sleazy"
... A CNET article by CNET News.com Staff, . Published on January 24, 1997 12:30 PM PST. No love has ever been lost between database makers Informix ...

IBM Acquires Informix
IBM took a major step today in its effort to strengthen its software business and take down Oracle by agreeing to acquire Informix Software's ...

The Four HundredIBM Buys Other Half of Informix with Ascential Acquisition
IBM Buys Other Half of Informix with Ascential Acquisition by Timothy Prickett Morgan Four years ago, in April 2001 to be precise, IBM bought ...

IBM's Informix buya billion dollars worth of benefit?
So IBM is buying Informix Software, Informix Corp.'s database unit and the heart of the company.

Resources last updated: 3/1/2016 12:56:31 AM