| Below is the latest content available from this feed: Re: NewEra 3.11 installation executables
Posted by: jleffler.iiug@gmail.com (Jonathan Leffler) - Sun, 28 Sep 2008 02:14:28 EDT
On Thu, Sep 25, 2008 at 2:04 AM, MATS HAGGLUND <matshaegglund@gmail.com>
wrote:
> Hi all, pls let me know how to get hold of the installation (executables)
> package of NewEra 3.11 for Windows.
>
> Thank you in advance for your kind attention and cooperation.
Nominally, you'll need to contact IBM - either sales or tech support.
Both are likely to say something along the lines of "not heard of the
product".
It has certainly not been readily available for a long time - I'm not
sure if there's been a release of any sort this millennium, but I
wouldn't be surprised to find that the answer is "No".
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [388]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: NewEra 3.11 installation executables
Posted by: art.kagel@gmail.com (Art Kagel) - Thu, 25 Sep 2008 06:34:00 EDT
NewEra is dead. Long live NewEra. If you have an IBM PA account you can
probably purchase it through there. There is no free or trial/demo download
as this is a legacy only product Informix stopped maintaining it long
before the IBM buyout.
Art
On Thu, Sep 25, 2008 at 5:04 AM, MATS HAGGLUND <matshaegglund@gmail.com>wrote:
> Hi all, pls let me know how to get hold of the installation (executables)
> package of NewEra 3.11 for Windows.
>
> Thank you in advance for your kind attention and cooperation.
>
> Mats
>
>
>
>
>
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [387]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
NewEra 3.11 installation executables
Posted by: matshaegglund@gmail.com (MATS HAGGLUND) - Thu, 25 Sep 2008 05:04:07 EDT
Hi all, pls let me know how to get hold of the installation (executables)
package of NewEra 3.11 for Windows.
Thank you in advance for your kind attention and cooperation.
Mats
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [386]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: clientSDK 3.50 UC1 install question
Posted by: ludmilla.bogavac@vgregion.se (LUDMILLA BOGAVAC) - Thu, 11 Sep 2008 06:56:33 EDT
I had the same problem with 3.50 TC1DE for Windows, but with the lates CSDK
(3.50 TC2DE) the installation worked.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [385]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Updated Informix JDBC driver
Posted by: art.kagel@gmail.com (Art Kagel) - Wed, 03 Sep 2008 15:58:20 EDT
http://www14.software.ibm.com/webapp/download/search.jsp?rs=ifxdl
Art
On Wed, Sep 3, 2008 at 3:53 PM, ROGERIO PAZINI <rogerio.pazini@dhl.com>wrote:
> Does anybody know where can I download the last version of Informix JDBC
> driver ?
>
> Tks,
>
> Rogério.
>
>
>
>
>
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [384]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Updated Informix JDBC driver
Posted by: rogerio.pazini@dhl.com (ROGERIO PAZINI) - Wed, 03 Sep 2008 15:53:53 EDT
Does anybody know where can I download the last version of Informix JDBC
driver ?
Tks,
Rogério.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [383]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: SCO OpenServer 6 compile problems
Posted by: doug.anderson@microstructure.com (DOUG ANDERSON) - Sat, 30 Aug 2008 23:08:32 EDT
Hi Alan
The unixds is the OpenServer Development System. I compiled under 5.0.5 and
moved my binary to 6.0.0. Worked like a charm. I compiled using the Informix
shell tool i4gl not c4gl. Whatever works!
Thx. DJA.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [382]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: SCO OpenServer 6 compile problems
Posted by: smithalan@bigpond.com (ALAN SMITH) - Sat, 30 Aug 2008 18:50:57 EDT
Thanks for the response.
I applied your recommended fixes -
PATH=/osr5/bin:$PATH
and the changes to c4gl recommended by John Boland.
When I compile now, I get the following fatal error:
make score_qsr.4ge
c4gl -c score_qsr.4gl
UX:acomp: ERROR: "/usr/informix/incl/tools/fglsys.h", line 41: cannot find
include file: <stdio.h>
UX:acomp: ERROR: "/usr/informix/incl/tools/fglrep.h", line 63: Syntax error
before or at: FILE
UX:acomp: ERROR: "/usr/informix/incl/tools/fglrep.h", line 63: cannot recover
from previous errors
*** Error code 1 (bu21)
As you can probably tell, Unix C is not my forte, (I inherited this problem
from developing in Informix 4GL and SQL) and didn't understand your reference
to "They need to install the unixds ($99 license)" - could that be the
problem, if so could you clarify the unixds reference please?
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [381]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: SCO OpenServer 6 compile problems
Posted by: Doug.Anderson@microstructure.com (Doug.Anderson@microstructure.com) - Thu, 28 Aug 2008 12:54:51 EDT
Hi Alan
I had the same issues recently. There are no future plans to
port current versions of Informix products to SCO 6.0.0. But
any binaries that are created in SCO 5.0.7 and below will
run on SCO 6.0.0.. The following comes from SCO tech support -
#################
The issues have been covered in J Boland's 2006 migration talk and
recently in a support e-mail .
The error is an indication that they are trying to mix OSR5 ABI code
with SVR5 (newly compiled) code.
It basically is they must use the OSR5 ABI version of the compilation
tools on the system..... They need to install the unixds ($99 license)
set their path to
PATH=/osr5/bin:$PATH
This uses the OSR5 version of the compilation tools automatically.
There is also some script changes that they will need to make; I have
copied John Boland's recent response to Asoh san on this same topic
and
tracked in SR 913415
John Boland wrote:
================================
Asoh san,
This type of issue, ie problems with a 3rd party
Development environment not supported on OpenServer 6
by the vendor (ie Informix) is borderline between
support and consulting. Is the customer prepared to
pay for SCO to help him with this issue?
As a start in understanding the issue I would ask:
1) Has the customer to set their PATH to
/osr5/usr/bin:$PATH
before building and executing the application?
2) What Mainteance Pack is installed. If you dont have MP3 installed,
can you please get it installed and see if the error persists?
3) When you installed the 4Gl did they edit the install script
called $INFORMIXDIR/bin/c4gl and change line
from: TLILIB=/usr/lib/libnsl_s.a
to: TLILIB=/osr5/usr/lib/libnsl.so
and modify link command option
from: -lnsl_s
to: -lnsl
#################
Hope this helps. My code ran successfully by following
the instructions above. I compiled using SCO 5.0.5.
Thx. DJA.
On Thu, 28 Aug 2008 05:41:32 -0400 (EDT)
"ALAN SMITH" <alans@pip.com.au> wrote:
> I have upgraded from SCO OpenServer 5.3 to 6.0 and am failing to
>compile 4GL
> code with the error " UX:ld: ERROR: lib4gsh730.so: cannot link
>OpenServer
> object into Intel iABI (UDK ABI) target".
> I'm using INFORMIX-4GL Version 7.30.UC1
> Initially it was failing with the same message except referring to
>the first
> of the .o modules (in place of lib4gsh730.so) in the program. When I
> re-compiled all the .o's, it reported the above error.
> lib4gsh730.so is part of the c4gl compile system and so I can't
>re-compile it.
> The SCO 6 documentation claims that it's 100% binary compatible with
>SCO 5, so
> I'm stumped.
> Any ideas?
>
>
>
>
>
-----------------------------------------------------------------
Doug Anderson Microstructure Inc.
171 Pilgrim Avenue Telephone - (204) 233-7732.
Winnipeg MB R2M 0L5 Fax - (204) 237-5156.
-----------------------------------------------------------------
The future has many names:
For the fearful, it's the unknown,
For the reckless, it's the adventure,
For the pessimists, it's the unattainable.
For the brave, it is opportunity.
-----------------------------------------------------------------
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [380]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: SCO OpenServer 6 compile problems
Posted by: doug.anderson@microstructure.com (DOUG ANDERSON) - Thu, 28 Aug 2008 12:32:00 EDT
Hi Alan
I had the same issues recently. There are no future plans to
port current versions of Informix products to SCO 6.0.0. But
any binaries that are created in SCO 5.0.7 and below will
run on SCO 6.0.0.. The following comes from SCO tech support -
#################
The issues have been covered in J Boland's 2006 migration talk and
recently in a support e-mail .
The error is an indication that they are trying to mix OSR5 ABI code
with SVR5 (newly compiled) code.
It basically is they must use the OSR5 ABI version of the compilation
tools on the system..... They need to install the unixds ($99 license)
set their path to
PATH=/osr5/bin:$PATH
This uses the OSR5 version of the compilation tools automatically.
There is also some script changes that they will need to make; I have copied
John Boland's recent response to Asoh san on this same topic and
tracked in SR 913415
John Boland wrote:
================================
Asoh san,
This type of issue, ie problems with a 3rd party
Development environment not supported on OpenServer 6
by the vendor (ie Informix) is borderline between
support and consulting. Is the customer prepared to
pay for SCO to help him with this issue?
As a start in understanding the issue I would ask:
1) Has the customer to set their PATH to
/osr5/usr/bin:$PATH
before building and executing the application?
2) What Mainteance Pack is installed. If you dont have MP3 installed,
can you please get it installed and see if the error persists?
3) When you installed the 4Gl did they edit the install script
called $INFORMIXDIR/bin/c4gl and change line
from: TLILIB=/usr/lib/libnsl_s.a
to: TLILIB=/osr5/usr/lib/libnsl.so
and modify link command option
from: -lnsl_s
to: -lnsl
#################
Hope this helps. My code ran successfully by following
the instructions above. I compiled using SCO 5.0.5.
Thx. DJA.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [379]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: SCO OpenServer 6 compile problems
Posted by: art.kagel@gmail.com (Art Kagel) - Thu, 28 Aug 2008 08:46:28 EDT
The 4GL libraries (and your original .o files as well) are OpenServer native
objects, but the compiler is being asked to create an Intel ABI
compatibility executable that can run on any Intel OS rather than a native
one. The two formats are not 'compatible' within the same executable.
There is some option being passed by the c4gl script (or the 4gl IDE) that
is telling it to do that. Read the documentation for cc, find the option,
and change the c4gl script, then recompile everything again. IBM or SCO
should be able to help if you can't figure it out (I haven't had to deal
with that one for many years, so I don't remember the option myself).
Art
On Thu, Aug 28, 2008 at 5:41 AM, ALAN SMITH <alans@pip.com.au> wrote:
> I have upgraded from SCO OpenServer 5.3 to 6.0 and am failing to compile
> 4GL
> code with the error " UX:ld: ERROR: lib4gsh730.so: cannot link OpenServer
> object into Intel iABI (UDK ABI) target".
> I'm using INFORMIX-4GL Version 7.30.UC1
> Initially it was failing with the same message except referring to the
> first
> of the .o modules (in place of lib4gsh730.so) in the program. When I
> re-compiled all the .o's, it reported the above error.
> lib4gsh730.so is part of the c4gl compile system and so I can't re-compile
> it.
> The SCO 6 documentation claims that it's 100% binary compatible with SCO 5,
> so
> I'm stumped.
> Any ideas?
>
>
>
>
>
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [378]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: SCO OpenServer 6 compile problems
Posted by: domusonline@gmail.com (Fernando Nunes) - Thu, 28 Aug 2008 06:52:43 EDT
I have no experience with SCO, but maybe the default object format changed
from 5.3 to 6.0.
If you're able to run c4gl it probably means SCO 6.0 can run older format
binaries.
What it probably can't do is to mix different object formats into one
executable.
Possibly you have options in the C compiler and in the loader (ld) to use
(generate) the old format?
Anyway... is SCO still supported? Wouldn't it be better to move to another
OS?... Linux comes to mind...
Regards, and hope this helps.
On Thu, Aug 28, 2008 at 10:41 AM, ALAN SMITH <alans@pip.com.au> wrote:
> I have upgraded from SCO OpenServer 5.3 to 6.0 and am failing to compile
> 4GL
> code with the error " UX:ld: ERROR: lib4gsh730.so: cannot link OpenServer
> object into Intel iABI (UDK ABI) target".
> I'm using INFORMIX-4GL Version 7.30.UC1
> Initially it was failing with the same message except referring to the
> first
> of the .o modules (in place of lib4gsh730.so) in the program. When I
> re-compiled all the .o's, it reported the above error.
> lib4gsh730.so is part of the c4gl compile system and so I can't re-compile
> it.
> The SCO 6 documentation claims that it's 100% binary compatible with SCO 5,
> so
> I'm stumped.
> Any ideas?
>
>
>
>
>
>
>
--
--
Fernando Nunes
Portugal
http://informix-technology.blogspot.com
My email works... but I don't check it frequently...
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [377]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
SCO OpenServer 6 compile problems
Posted by: alans@pip.com.au (ALAN SMITH) - Thu, 28 Aug 2008 05:41:33 EDT
I have upgraded from SCO OpenServer 5.3 to 6.0 and am failing to compile 4GL
code with the error " UX:ld: ERROR: lib4gsh730.so: cannot link OpenServer
object into Intel iABI (UDK ABI) target".
I'm using INFORMIX-4GL Version 7.30.UC1
Initially it was failing with the same message except referring to the first
of the .o modules (in place of lib4gsh730.so) in the program. When I
re-compiled all the .o's, it reported the above error.
lib4gsh730.so is part of the c4gl compile system and so I can't re-compile it.
The SCO 6 documentation claims that it's 100% binary compatible with SCO 5, so
I'm stumped.
Any ideas?
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [376]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: migrate from oracle start with/ connect by
Posted by: jleffler.iiug@gmail.com (Jonathan Leffler) - Mon, 18 Aug 2008 23:52:02 EDT
On Mon, Aug 18, 2008 at 6:28 PM, Art Kagel <art.kagel@gmail.com> wrote:
> See the Guide to SQL Tutorial, Guide to SQL Reference, Guide to SQL Syntax,
> and DBaccess manuals.
Also look for the MTK - Migration Tool Kit.
Google "site:ibm.com migration toolkit mtk" leads to:
http://www-306.ibm.com/software/data/db2/migration/mtk/
> On Mon, Aug 18, 2008 at 8:14 PM, CHUAN LU <luchuan@cn.ibm.com> wrote:
>
>> Do anybody know how to migrate from oracle start with /connect by to
>> informix in SP?
CONNECT BY is for hierarchical queries (bill of materials, etc), and
unrelated to the plain CONNECT for establishing a connection to the
database.
I do have a stash of code (ancient) related to hierarchical queries -
BOM, etc - in Informix.
However, I don't have anything that explicitly emulates the Oracle
behaviour; I simply haven't tried.
--
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [375]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: migrate from oracle start with/ connect by
Posted by: luchuan@cn.ibm.com (CHUAN LU) - Mon, 18 Aug 2008 23:50:00 EDT
Oracle use start with/connect by in select statement to generate Hierarchical
Query. you don't fully understand my question. any way, thanks...
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [374]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: migrate from oracle start with/ connect by
Posted by: art.kagel@gmail.com (Art Kagel) - Mon, 18 Aug 2008 21:28:03 EDT
See the Guide to SQL Tutorial, Guide to SQL Reference, Guide to SQL Syntax,
and DBaccess manuals.
In Informix you connect similarly:
You can run a script containing the commands as:
dbaccess - - < myscript.sql
or use a 'here' script, the commands are the same:
dbaccess - - <<EOF
connect to mydatabase@myserver user 'mylogin';
Password: mypassword
select * from emp;
EOF
Art
On Mon, Aug 18, 2008 at 8:14 PM, CHUAN LU <luchuan@cn.ibm.com> wrote:
> Do anybody know how to migrate from oracle start with /connec by to
> informix
> in SP?
> Oracle's sample like this.
> SQL> conn scott/tiger
> Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
> Connected as scott
>
> SQL> select * from emp;
>
> EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
> ----- ---------- --------- ----- ----------- --------- --------- ------
> 7369 SMITH CLERK 7902 1980-12-17 800.00 20
> 7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
> 7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
> 7566 JONES MANAGER 7839 1981-4-2 2975.00 20
> 7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
> 7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
> 7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
> 7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
> 7839 KING PRESIDENT 1981-11-17 5000.00 10
> 7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
> 7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
> 7900 JAMES CLERK 7698 1981-12-3 950.00 30
> 7902 FORD ANALYST 7566 1981-12-3 3000.00 20
> 7934 MILLER CLERK 7782 1982-1-23 1300.00 10
>
> 14 rows selected
>
> SQL> insert into emp(empno, ename, mgr, deptno)
> values(9999,'Menglk_9',null,10);
>
> 1 row inserted
>
> SQL> insert into emp(empno, ename, mgr, deptno)
> values(8888,'Menglk_8',7788,10);
>
> 1 row inserted
>
> SQL> commit;
>
> Commit complete
>
> SQL> select * from emp;
>
> EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
> ----- ---------- --------- ----- ----------- --------- --------- ------
> 7369 SMITH CLERK 7902 1980-12-17 800.00 20
> 7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
> 7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
> 7566 JONES MANAGER 7839 1981-4-2 2975.00 20
> 7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
> 7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
> 7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
> 7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
> 7839 KING PRESIDENT 1981-11-17 5000.00 10
> 7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
> 7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
> 7900 JAMES CLERK 7698 1981-12-3 950.00 30
> 7902 FORD ANALYST 7566 1981-12-3 3000.00 20
> 7934 MILLER CLERK 7782 1982-1-23 1300.00 10
> 9999 Menglk_9 10
> 8888 Menglk_8 7788 10
>
> 16 rows selected
> SQL> select level, lpad(' ',level*2,' ')||ename, t.* from emp t start with
> mgr
> is null connect by mgr=prior empno;
>
> LEVEL LPAD('',LEVEL*2,'')||ENAME EMPNO ENAME JOB MGR HIREDATE SAL COMM
> DEPTNO
> ---------- ---------------------------- ----- ---------- --------- -----
> ----------- --------- --------- ------
>
> 1 KING 7839 KING PRESIDENT 1981-11-17 5000.00 10
>
> 2 JONES 7566 JONES MANAGER 7839 1981-4-2 2975.00 20
>
> 3 SCOTT 7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
>
> 4 ADAMS 7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
>
> 4 Menglk_8 8888 Menglk_8 7788 10
>
> 3 FORD 7902 FORD ANALYST 7566 1981-12-3 3000.00 20
>
> 4 SMITH 7369 SMITH CLERK 7902 1980-12-17 800.00 20
>
> 2 BLAKE 7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
>
> 3 ALLEN 7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
>
> 3 WARD 7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
>
> 3 MARTIN 7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
>
> 3 TURNER 7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
>
> 3 JAMES 7900 JAMES CLERK 7698 1981-12-3 950.00 30
>
> 2 CLARK 7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
>
> 3 MILLER 7934 MILLER CLERK 7782 1982-1-23 1300.00 10
>
> 1 Menglk_9 9999 Menglk_9 10
>
>
>
>
>
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do those
opinions reflect those of other individuals affiliated with any entity with
which I am affiliated nor those of the entities themselves.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [373]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
migrate from oracle start with/ connect by
Posted by: luchuan@cn.ibm.com (CHUAN LU) - Mon, 18 Aug 2008 20:14:50 EDT
Do anybody know how to migrate from oracle start with /connec by to informix
in SP?
Oracle's sample like this.
SQL> conn scott/tiger
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as scott
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
14 rows selected
SQL> insert into emp(empno, ename, mgr, deptno)
values(9999,'Menglk_9',null,10);
1 row inserted
SQL> insert into emp(empno, ename, mgr, deptno)
values(8888,'Menglk_8',7788,10);
1 row inserted
SQL> commit;
Commit complete
SQL> select * from emp;
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
----- ---------- --------- ----- ----------- --------- --------- ------
7369 SMITH CLERK 7902 1980-12-17 800.00 20
7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
7839 KING PRESIDENT 1981-11-17 5000.00 10
7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7900 JAMES CLERK 7698 1981-12-3 950.00 30
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7934 MILLER CLERK 7782 1982-1-23 1300.00 10
9999 Menglk_9 10
8888 Menglk_8 7788 10
16 rows selected
SQL> select level, lpad(' ',level*2,' ')||ename, t.* from emp t start with mgr
is null connect by mgr=prior empno;
LEVEL LPAD('',LEVEL*2,'')||ENAME EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------------------------- ----- ---------- --------- -----
----------- --------- --------- ------
1 KING 7839 KING PRESIDENT 1981-11-17 5000.00 10
2 JONES 7566 JONES MANAGER 7839 1981-4-2 2975.00 20
3 SCOTT 7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20
4 ADAMS 7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
4 Menglk_8 8888 Menglk_8 7788 10
3 FORD 7902 FORD ANALYST 7566 1981-12-3 3000.00 20
4 SMITH 7369 SMITH CLERK 7902 1980-12-17 800.00 20
2 BLAKE 7698 BLAKE MANAGER 7839 1981-5-1 2850.00 30
3 ALLEN 7499 ALLEN SALESMAN 7698 1981-2-20 1600.00 300.00 30
3 WARD 7521 WARD SALESMAN 7698 1981-2-22 1250.00 500.00 30
3 MARTIN 7654 MARTIN SALESMAN 7698 1981-9-28 1250.00 1400.00 30
3 TURNER 7844 TURNER SALESMAN 7698 1981-9-8 1500.00 0.00 30
3 JAMES 7900 JAMES CLERK 7698 1981-12-3 950.00 30
2 CLARK 7782 CLARK MANAGER 7839 1981-6-9 2450.00 10
3 MILLER 7934 MILLER CLERK 7782 1982-1-23 1300.00 10
1 Menglk_9 9999 Menglk_9 10
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [372]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: Informix ODBC driver - Multiple DSNS
Posted by: shagrawal@in.ibm.com (Sheshnarayan Agrawal) - Thu, 14 Aug 2008 03:14:38 EDT
If you are using CSDK 3.00 onwards(infact from CSDK 2.90.xC4 onwards) and
trying to create multiple DSNs with same server name but different host,
protocol etc, then you will get following message.
"You have changed the host, service, or protocol for this database server.
These changes will be reflected in all DSNs that use this server and in
the Setnet32 entry for this server."
Do you want to proceed?"
If you are not getting this error then you are not using CSDK 3.00 !!
However, If you have such requirement to have same server names but
different host, protocol etc. Then you need to work on DSNless connection
(there were some issue around this which has been addressed from CSDK
3.00.xC1 onwards), that means you have to provide connection information
as a part of connection string itself. You don't need to create setnet32
entries for these servers.
DSNless connection string example,
"Database=mydb;Server=myonline-server;Service=port_num;Host=myhost;Protocol=onsoctcp;UID=informix;PWD=xxxx;"
HTH
-Shesh
"BRIAN CHARLES" <bcharles@riteaid.com>
Sent by: development-tools-bounces@iiug.org
13/08/2008 23:17
Please respond to
development-tools@iiug.org
To
development-tools@iiug.org
cc
Subject
Informix ODBC driver - Multiple DSNS [370]
We are developing a .NET application which will need to connect to one of
9
IDS servers. We found the 2.8 and 3.0 SDK ODBC Driver for Window but it
appears not to support multiple DSNS. We can define a server but when we
add
another, it overlays the first. How do define multiple DSNs (IDS
connections)
with the Informix ODBC driver for Windows? Thanks in advance.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [371]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Informix ODBC driver - Multiple DSNS
Posted by: bcharles@riteaid.com (BRIAN CHARLES) - Wed, 13 Aug 2008 13:47:57 EDT
We are developing a .NET application which will need to connect to one of 9
IDS servers. We found the 2.8 and 3.0 SDK ODBC Driver for Window but it
appears not to support multiple DSNS. We can define a server but when we add
another, it overlays the first. How do define multiple DSNs (IDS connections)
with the Informix ODBC driver for Windows? Thanks in advance.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [370]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Re: -255 Error : Why and How to resolve it
Posted by: vidyapati@huawei.com (VIDYA PANDEY) - Mon, 04 Aug 2008 07:05:26 EDT
Hi,
I replaced the client SDK
"IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC2
Software Serial Number RDS#N000000"
with
"IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.UC4
Software Serial Number AAA#B000000"
And the problem is solved.
Regards
Vidya
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [369]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Hi,
I replaced the client SDK
"IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.UC2
Software Serial Number RDS#N000000"
with
"IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.UC4
Software Serial Number AAA#B000000"
And the problem is solved.
Regards
Vidya
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
To post a response via email (IIUG members only):
1. Address it to development-tools@iiug.org
2. Include the bracketed message number in the subject line: [369]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
| | | Subscribe to this feed | | You can subscribe to this RSS feed in a number of ways, including the following: Drag the orange RSS button into your News Reader Drag the URL of the RSS feed into your News Reader Cut and paste the URL of the RSS feed into your News Readerv |
|
