| 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 Reader>v | |