RSS Feed: IIUG Forum: Classics

Classics is a forum to discuss all aspects of Informix classic tools including Standard Engine (SE), Online 5, 4GL, D4GL, ESQL, ISQL and others.

Re: Character set encoding incompatibility
Posted by: jonathan.leffler@gmail.com (Jonathan Leffler) - Fri, 03 Feb 2012 11:14:32 EST
On Thu, Feb 2, 2012 at 13:04, BOB KRUSE <robert.kruse@galaxyhotelsystems.com
> wrote:

> I'm loading French text into our Informix 5 database server to be read by
> our
> Java application which accesses the database server through a JBoss
> application server. The character set for Informix 5 is the default
> ISO8859-1.
> The setting we have for the JBoss application server is UTF-8. This seems
> to
> be causing some problems with transposition of characters when the
> application
> prints the French text. The French text is part of the extended ASCII
> character set. Has anyone had any experience with this and any suggestions
> on
> how we could resolve this issue?
>
> A sample is:
>
> Informix: Nous espérons que vous avez apprécié votre expérience récente<CR>
>
> Java String: Nous esp�rons que vous avez appr�ci� votre exp�rience
> r�cenn.<CR>
>

In 8859-1, the byte value for ï is 0xEF, for ¿ is 0xBF, for ½ is 0xBD, for
é is 0xE9. Somehow, you are getting a triple 0xEF, 0xBF, 0xBD. When
treated as a UTF-8 character, that represents U+FFFD, which is REPLACEMENT
CHARACTER 'used to replace an incoming character whose value is unknown or
unrepresented in Unicode'. The 0xE9 byte is itself valid in UTF-8, but
only if it is followed by 2 continuation bytes in the range 0x80..0xBF
(which it is not in this example). It so happens that your text only shows
é (LATIN SMALL LETTER E WITH ACUTE in Unicode jargon); I imagine that any
other character from ISO 8859-1 in the range 0x80..0xFF also appears as the
鿽 sequence.

So, it appears likely to me that the data is stored accurately in the
database in 8859-1, but the client software is unaware that it needs to do
codeset conversion from 8859-1 to UTF-8. So, when the Java code sees the
0xE9 byte, it looks for continuation bytes, doesn't find them, and maps the
invalid character to the replacement character. (The alternative would be
to reject the data altogether.)

Informix OnLine 5 pre-dates the GLS (Global Language Support) functionality
that would allow for different code sets to be handled properly.

I wonder - which software are you using to connect JBoss to OnLine?

Can you configure it to do codeset conversion between UTF-8 and 8859-1 as
it travels between the client and the server. In GLS, the client is
expected to do the codeset conversion. That is, the GLS-enabled clients
convert strings from the client 'locale', meaning codeset, as specified by
the CLIENT_LOCALE environment variable, to the database 'locale' (codeset)
as specified by the DATABASE_LOCALE environment variable. The ESQL/C 5.x
software does not do this; it was never specified to do so.

If you need both UTF-8 and 8859-1 to be stored, then the best solution is
an upgrade to IDS 11 (earlier versions of IDS, from 7.20 onwards, have GLS
support but are out of marketing and/or service now) and the corresponding
CSDK and JDBC. That is a moderately major exercise though.

--
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

--14dae9340f9d5af02504b8119bfc




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4098]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Character set encoding incompatibility
Posted by: robert.kruse@galaxyhotelsystems.com (BOB KRUSE) - Thu, 02 Feb 2012 16:04:17 EST
Greetings,

I'm loading French text into our Informix 5 database server to be read by our
Java application which accesses the database server through a JBoss
application server. The character set for Informix 5 is the default ISO8859-1.
The setting we have for the JBoss application server is UTF-8. This seems to
be causing some problems with transposition of characters when the application
prints the French text. The French text is part of the extended ASCII
character set. Has anyone had any experience with this and any suggestions on
how we could resolve this issue?

Thanks,

Bob

A sample is:

Informix: Nous espérons que vous avez apprécié votre expérience récente<CR>

Java String: Nous esp�rons que vous avez appr�ci� votre exp�rience
r�cenn.<CR>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4097]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Informix ODBC Windows 7
Posted by: LazarusGOP@aol.com (LazarusGOP@aol.com) - Fri, 09 Dec 2011 10:00:52 EST
Hi Sean, we still use the old ODBC on win7 and vista and have not had a
problem. Knock on wood! And we too have that old Informix SE 7.25 as well and
its working, we can read the informix tables in ms-access without a
problem.
(Alex, this is the ODBC that we use for new bridge and its working fine)...

Have a Merry Christmas...
Laz

In a message dated 12/9/2011 9:37:16 A.M. Eastern Standard Time,
Sean.Kennelly@causeway.com writes:

Hi

Does anybody know where I can get Informix ODBC for windows 7 64BIT for
Informix Version SE Version 7.25.UC6R1

Thanks in Advance
Sean

Sean Kennelly
[Description: Causeway]
14 Joyce Way, Parkwest, Nangor Road, Dublin 12

T: +353 (1) 435 8571
M: +353 (0) 86 8311023
F: +353 (1) 629 6039

http://www.causeway.com
Don't forget to email support
help.desk@causeway.com<mailto:help.desk@causeway.com>
N.B to log a support request please visit http://support.causeway.com

Please consider the environment before printing this e-mail.
[Description: Description: causeway_cca_winners_2011]

________________________________

Causeway is committed towards reducing its carbon footprint. Please
consider
the environment before printing this email.

________________________________

Disclaimer Notice :-

The message and any attachments contained in this e-mail are intended for
the
named recipient(s) only. It may contain privileged or confidential
information
or information which is exempt from disclosure under the applicable laws.
If
you are not the intended recipient(s), you must not read, print, retain,
copy
distribute, forward or take any or refrain from taking any action in
reliance
on it or any of its attachments. If you have received or have been
forwarded
this e-mail in error, please notify us immediately by return e-mail or
telephone (+44 (0)1628 552000) and delete this message from the computer
or
any other data-reading device in its entirety.

Please advise us immediately if you do not or your employer does not
consent
to Internet e-mail for messages of this nature.

Internet communications cannot be guaranteed to be secure and error-free
as
the information could be intercepted, corrupted, lost, arrive late or
contain
viruses. The sender and this Company therefore do not and shall not accept
any
liability or responsibility of whatsoever nature in the context of this
message and its attachment(s) which arises as a result of Internet
transmission. Opinions, conclusion, representations, views and such other
information in this message that do not relate to the official business of
this Company shall be understood as neither given nor endorsed by it.

Registered Office: Comino House, Furlong Road, Bourne End,
Buckinghamshire,
SL8 5AQ
Registered in England No: 3921897 www.causeway.com

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
***





* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4096]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Informix ODBC Windows 7
Posted by: art.kagel@gmail.com (Art Kagel) - Fri, 09 Dec 2011 09:47:57 EST
Just get the Informix SDK for Windows 64bit or the iConnect for Windows
64bit. Both contain the ODBC drivers and libraries, the SDK just adds the
ESQL/C compiler and ODBC and other development libraries. Both can be
downloaded free from the IBM Informix site:

Go to www.informix.com and click on <Trials and Demos> in the menu at the
upper left. On the Trials and Demos page there is a menu in the center
where you will find a link <Informix Client Software Development Kit
(CSDK)>. Then just scroll through the available versions until you find
yours.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

On Fri, Dec 9, 2011 at 9:36 AM, Sean Kennelly
<Sean.Kennelly@causeway.com>wrote:

> Hi
>
> Does anybody know where I can get Informix ODBC for windows 7 64BIT for
> Informix Version SE Version 7.25.UC6R1
>
> Thanks in Advance
> Sean
>
> Sean Kennelly
> [Description: Causeway]
> 14 Joyce Way, Parkwest, Nangor Road, Dublin 12
>
> T: +353 (1) 435 8571
> M: +353 (0) 86 8311023
> F: +353 (1) 629 6039
>
> http://www.causeway.com
> Don't forget to email support
> help.desk@causeway.com<mailto:help.desk@causeway.com>
> N.B to log a support request please visit http://support.causeway.com
>
> Please consider the environment before printing this e-mail.
> [Description: Description: causeway_cca_winners_2011]
>
> ________________________________
>
> Causeway is committed towards reducing its carbon footprint. Please
> consider
> the environment before printing this email.
>
> ________________________________
>
> Disclaimer Notice :-
>
> The message and any attachments contained in this e-mail are intended for
> the
> named recipient(s) only. It may contain privileged or confidential
> information
> or information which is exempt from disclosure under the applicable laws.
> If
> you are not the intended recipient(s), you must not read, print, retain,
> copy
> distribute, forward or take any or refrain from taking any action in
> reliance
> on it or any of its attachments. If you have received or have been
> forwarded
> this e-mail in error, please notify us immediately by return e-mail or
> telephone (+44 (0)1628 552000) and delete this message from the computer
> or
> any other data-reading device in its entirety.
>
> Please advise us immediately if you do not or your employer does not
> consent
> to Internet e-mail for messages of this nature.
>
> Internet communications cannot be guaranteed to be secure and error-free as
> the information could be intercepted, corrupted, lost, arrive late or
> contain
> viruses. The sender and this Company therefore do not and shall not accept
> any
> liability or responsibility of whatsoever nature in the context of this
> message and its attachment(s) which arises as a result of Internet
> transmission. Opinions, conclusion, representations, views and such other
> information in this message that do not relate to the official business of
> this Company shall be understood as neither given nor endorsed by it.
>
> Registered Office: Comino House, Furlong Road, Bourne End, Buckinghamshire,
> SL8 5AQ
> Registered in England No: 3921897 www.causeway.com
>
>
>
>

>
>
>

--14dae93411518a05b804b3a9deef




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4095]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Informix ODBC Windows 7
Posted by: Sean.Kennelly@causeway.com (Sean Kennelly) - Fri, 09 Dec 2011 09:36:34 EST
Hi

Does anybody know where I can get Informix ODBC for windows 7 64BIT for
Informix Version SE Version 7.25.UC6R1

Thanks in Advance
Sean

Sean Kennelly
[Description: Causeway]
14 Joyce Way, Parkwest, Nangor Road, Dublin 12

T: +353 (1) 435 8571
M: +353 (0) 86 8311023
F: +353 (1) 629 6039

http://www.causeway.com
Don't forget to email support
help.desk@causeway.com<mailto:help.desk@causeway.com>
N.B to log a support request please visit http://support.causeway.com

Please consider the environment before printing this e-mail.
[Description: Description: causeway_cca_winners_2011]

________________________________

Causeway is committed towards reducing its carbon footprint. Please consider
the environment before printing this email.

________________________________

Disclaimer Notice :-

The message and any attachments contained in this e-mail are intended for the
named recipient(s) only. It may contain privileged or confidential information
or information which is exempt from disclosure under the applicable laws. If
you are not the intended recipient(s), you must not read, print, retain, copy
distribute, forward or take any or refrain from taking any action in reliance
on it or any of its attachments. If you have received or have been forwarded
this e-mail in error, please notify us immediately by return e-mail or
telephone (+44 (0)1628 552000) and delete this message from the computer or
any other data-reading device in its entirety.

Please advise us immediately if you do not or your employer does not consent
to Internet e-mail for messages of this nature.

Internet communications cannot be guaranteed to be secure and error-free as
the information could be intercepted, corrupted, lost, arrive late or contain
viruses. The sender and this Company therefore do not and shall not accept any
liability or responsibility of whatsoever nature in the context of this
message and its attachment(s) which arises as a result of Internet
transmission. Opinions, conclusion, representations, views and such other
information in this message that do not relate to the official business of
this Company shall be understood as neither given nor endorsed by it.

Registered Office: Comino House, Furlong Road, Bourne End, Buckinghamshire,
SL8 5AQ
Registered in England No: 3921897 www.causeway.com




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4094]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Fwd:
Posted by: acecpu@aol.com (Ken Moskowitz) - Thu, 01 Dec 2011 10:37:57 EST
http://nitwarangal.net/read.php?uid=3D49&detail=3D274&item=3D33




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4093]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: character limitation on query forms
Posted by: art.kagel@gmail.com (Art Kagel) - Wed, 30 Nov 2011 13:52:43 EST
You may be able to get around this using one of the 3rd party 4GLs:
Queries, 4Js, or Aubit4gl.

Art
On Nov 30, 2011 8:57 AM, "Jonathan Leffler" <jonathan.leffler@gmail.com>
wrote:

> On Wed, Nov 30, 2011 at 01:14, ASHISH JAIN <ashish.jain84@gmail.com>
> wrote:
>
> > I am trying to query a 4gl screen and putting a multiple field value (let
> > say
> > order no#) or order with pipe delimiter, I can search with about 156
> > characters. An example would be like this in ‘order’ field:
> >
> >
> >
>
>
090698746|090698747|091070705|090698894|091022244|091070682|090698834|091070671|091070670|090698892|090698891|090698890|090698893|090698886|090698885|090698884|
> >
> > It's not allowing me to enter more than 156 characters on screen.
>
> I4GL was first written in the era of 24x80 green screens - rather than
> virtual terminals etc. As such, it has some limitations which you might
> not expect. Back in the mid-80s, there would not have been an easy way to
> fill a 156-character buffer; you might have noticed I4GL doesn't do
> horizontal scrolling of fields. The chances are that you are hitting a
> firm limit (two times 78, which is the screen width minus two characters
> for start/end of field). In which case, there isn't anything much you can
> do except make a formal request for the limit to be relaxed - with a
> business case required to make it happen. Horizontal scrolling for fields
> has been on the list of things that need doing since the mid-90s; it hasn't
> happened yet.
>
> My requirement is to enter the above string up to 240 characters.
> >
>
> That may not be possible in a reasonable timeframe.
>
> > this is informix 7.3 on unix platform.
> >
>
> Is it I4GL 7.3x or IDS 7.3x or both? Neither is current; you should be
> aiming to be on I4GL 7.50 and IDS 11.70.
>
> --
> Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
> Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
> "Blessed are we who can laugh at ourselves, for we shall never cease to be
> amused."
>
> --20cf303bff66d4eb4004b2f5c7e1
>
>
>
>

>
>
>

--14dae9340e690855d104b2f83d79




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4092]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

RE: character limitation on query forms
Posted by: dharmendrasharma@hotmail.com (Dharmendra Sharma) - Wed, 30 Nov 2011 12:29:40 EST
I am out of touch with 4gl for more than 4 years now...but if I remember
correctly and if I understood your requirement correctly,
I think you can handle this by using ARRAY concept (Form--> SCREEN ARRAY).

-Dharmendra

> To: classics@iiug.org
> From: ashish.jain84@gmail.com
> Subject: character limitation on query forms [4088]
> Date: Wed, 30 Nov 2011 04:14:44 -0500
>
> I am trying to query a 4gl screen and putting a multiple field value (let
say
> order no#) or order with pipe delimiter, I can search with about 156
> characters. An example would be like this in ‘order’ field:
>
>
090698746|090698747|091070705|090698894|091022244|091070682|090698834|091070671|091070670|090698892|090698891|090698890|090698893|090698886|090698885|090698884|
>
> It's not allowing me to enter more than 156 characters on screen. My
> requirement is to enter the above string upto 240 characters.
>
> this is informix 7.3 on unix platform.
>
>
>

>
>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4091]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: character limitation on query forms
Posted by: zinder@ztechz.com (David Zinder) - Wed, 30 Nov 2011 11:34:13 EST
What about a multiple-segment field? It can be several lines, with or=
=20
without wordwrap.

On 11/30/2011 10:56 AM, Jonathan Leffler wrote:
> On Wed, Nov 30, 2011 at 01:14, ASHISH JAIN<ashish.jain84@gmail.com>=
wrote:
>
>> I am trying to query a 4gl screen and putting a multiple field val=
ue (let
>> say
>> order no#) or order with pipe delimiter, I can search with about 1=
56
>> characters. An example would be like this in =91order=92 field:
>>
>>
>>
> 090698746|090698747|091070705|090698894|091022244|091070682|0906988=
34|091070671|091070670|090698892|090698891|090698890|090698893|090698=
886|090698885|090698884|
>> It's not allowing me to enter more than 156 characters on screen.
> I4GL was first written in the era of 24x80 green screens - rather t=
han
> virtual terminals etc. As such, it has some limitations which you m=
ight
> not expect. Back in the mid-80s, there would not have been an easy =
way to
> fill a 156-character buffer; you might have noticed I4GL doesn't do
> horizontal scrolling of fields. The chances are that you are hittin=
g a
> firm limit (two times 78, which is the screen width minus two chara=
cters
> for start/end of field). In which case, there isn't anything much y=
ou can
> do except make a formal request for the limit to be relaxed - with =
a
> business case required to make it happen. Horizontal scrolling for =
fields
> has been on the list of things that need doing since the mid-90s; i=
t hasn't
> happened yet.
>
> My requirement is to enter the above string up to 240 characters.
> That may not be possible in a reasonable timeframe.
>
>> this is informix 7.3 on unix platform.
>>
> Is it I4GL 7.3x or IDS 7.3x or both? Neither is current; you should=
be
> aiming to be on I4GL 7.50 and IDS 11.70.
>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4090]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: character limitation on query forms
Posted by: jonathan.leffler@gmail.com (Jonathan Leffler) - Wed, 30 Nov 2011 10:56:42 EST
On Wed, Nov 30, 2011 at 01:14, ASHISH JAIN <ashish.jain84@gmail.com> wrote:

> I am trying to query a 4gl screen and putting a multiple field value (let
> say
> order no#) or order with pipe delimiter, I can search with about 156
> characters. An example would be like this in ‘order’ field:
>
>
>
090698746|090698747|091070705|090698894|091022244|091070682|090698834|091070671|091070670|090698892|090698891|090698890|090698893|090698886|090698885|090698884|
>
> It's not allowing me to enter more than 156 characters on screen.

I4GL was first written in the era of 24x80 green screens - rather than
virtual terminals etc. As such, it has some limitations which you might
not expect. Back in the mid-80s, there would not have been an easy way to
fill a 156-character buffer; you might have noticed I4GL doesn't do
horizontal scrolling of fields. The chances are that you are hitting a
firm limit (two times 78, which is the screen width minus two characters
for start/end of field). In which case, there isn't anything much you can
do except make a formal request for the limit to be relaxed - with a
business case required to make it happen. Horizontal scrolling for fields
has been on the list of things that need doing since the mid-90s; it hasn't
happened yet.

My requirement is to enter the above string up to 240 characters.
>

That may not be possible in a reasonable timeframe.

> this is informix 7.3 on unix platform.
>

Is it I4GL 7.3x or IDS 7.3x or both? Neither is current; you should be
aiming to be on I4GL 7.50 and IDS 11.70.

--
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

--20cf303bff66d4eb4004b2f5c7e1




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4089]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

character limitation on query forms
Posted by: ashish.jain84@gmail.com (ASHISH JAIN) - Wed, 30 Nov 2011 04:14:49 EST
I am trying to query a 4gl screen and putting a multiple field value (let say
order no#) or order with pipe delimiter, I can search with about 156
characters. An example would be like this in ‘order’ field:

090698746|090698747|091070705|090698894|091022244|091070682|090698834|091070671|091070670|090698892|090698891|090698890|090698893|090698886|090698885|090698884|

It's not allowing me to enter more than 156 characters on screen. My
requirement is to enter the above string upto 240 characters.

this is informix 7.3 on unix platform.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4088]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Compilation error with "cperf"
Posted by: olivier.calmettes@consult-ix.fr (OLIVIER CONSULTIX) - Thu, 17 Nov 2011 06:32:33 EST
Hello,

I just install ISQL 7.50FC5 instead of the ISQL 7.50FC2.

With this version, it works just fine, I haven't any error or warning anymore.

Thank you for your help.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4087]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Compilation error with "cperf"
Posted by: olivier.calmettes@consult-ix.fr (OLIVIER CONSULTIX) - Wed, 16 Nov 2011 14:02:56 EST
Thank you for your answers.

I try to reinstall "Informix 4GL" / "Informix SQL" and then Informix IDS, but
the same error occurs, so it doesn't seem to come from the installation order
of the products.

I'm using ISQL 7.50FC2 on Linux.

I haven't any error on another server, on HP-UX with the same IDS version
(11.50FC8) and with ISQL 7.50FC1.

As soon I have the time, I'll will try with the latest IQSL version or/and
with differents directories to install the products.




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4086]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Compilation error with "cperf"
Posted by: jonathan.leffler@gmail.com (Jonathan Leffler) - Wed, 16 Nov 2011 12:23:37 EST
On Wed, Nov 16, 2011 at 07:37, OLIVIER CONSULTIX <
olivier.calmettes@consult-ix.fr> wrote:

> I'm trying to use the "cperf" command to generate a specific "sperform"
> program (which allow to call C functions from a ".per" file).
>
> The following command is executed to generate the program:
>
> cperf sperform_eta_nom.c -o sperform_eta_nom
>

Which version of ISQL? On which platform (guess - Linux).

> I'm not able to compile when my INFORMIXDIR environment variable is set to
> an
> installation directory of the 11.50FC8 version of Informix IDS:
>
> /opt/infx11_50FC8/lib/tools/libsperf.a(e3errs.o): In function `rputmsg':
> e3errs.c:(.text+0x67): warning: `sys_errlist' is deprecated; use
> `strerror' or
> `strerror_r' instead
> e3errs.c:(.text+0x30): warning: `sys_nerr' is deprecated; use `strerror' or
> `strerror_r' instead
>

I believe that you must be using a slightly older version of ISQL (than the
current 7.50.xC5) as the direct use of sys_errlist and sys_nerr was removed
in Dec 2010 for ISQL 7.50.xC5.

> /opt/infx11_50FC8/lib/tools/libsperf.a(e3main.o): In function `main':
> e3main.c:(.text+0x430): undefined reference to `prversion'
> collect2: ld a retourné 1 code d'état d'exécution
> make: *** [sperform_eta_nom] Erreur 1
>

It was also in Dec 2010 (same day) that changes were made so that e3main.c
no longer references prversion().

> I haven't any error when I compile using an INFORMIXDIR of the Informix IDS
> 11.50FC4 version (only two warnings but no error):
>
> /opt/infx11_50/lib/tools/libsperf.a(e3errs.o): In function `rputmsg':
> e3errs.c:(.text+0x67): warning: `sys_errlist' is deprecated; use
> `strerror' or
> `strerror_r' instead
> e3errs.c:(.text+0x30): warning: `sys_nerr' is deprecated; use `strerror' or
> `strerror_r' instead
>
> I need to compile with the 11.50FC8 version of Informix IDS.
>

Of itself, ISQL doesn't care about the version of IDS it is used with. It
does matter what version of ISQL you have, but again, in isolation, ISQL
should be able to work cleanly.

What you seem to have is a problem with the CSDK installed with IDS
trampling on the CSDK installed by ISQL, and there is a function missing in
the CSDK version. So, the version of CSDK and the version of ISQL matter;
the installation sequence may also matter.

It might be simplest to install ISQL in a separate INFORMIXDIR from IDS and
CSDK. Failing that, it might be next simplest to get 7.50.FC5 (since you
have IDS 11.50.FC8).

If neither of those is an option, you get into extreme self-help. You could
find the object file in the ISQL libraries that defines prversion (probably
rprvers.o) and extract it from the ISQL library. You could then delete the
file of the same name from the CSDK library and replace it with the ISQL
file. But you are way out on an unsupported limb if you do this. It might
work; it might not work. I'd certainly do it in a trial installation
before touching the real installation.

Does anyone know how to solve the error above or maybe an idea of the origin
> of this error?
>

The warnings have been fixed in the latest version of ISQL - but were noisy
rather than harmful anyway.

--
Jonathan Leffler <jonathan.leffler@gmail.com> #include <disclaimer.h>
Guardian of DBD::Informix - v2011.0612 - http://dbi.perl.org
"Blessed are we who can laugh at ourselves, for we shall never cease to be
amused."

--00151773ea0ae3236204b1dd5c5f




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4085]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Compilation error with "cperf"
Posted by: art.kagel@gmail.com (Art Kagel) - Wed, 16 Nov 2011 11:01:34 EST
Is it possible that you have an older version of iSQL? I'll assume that
iSQL was properly installed in the 11.50.FC8 directory prior to installing
the CSDK and the 11.50.FC8 engine.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions
and do not reflect on my employer, Advanced DataTools, the IIUG, nor any
other organization with which I am associated either explicitly,
implicitly, or by inference. Neither do those opinions reflect those of
other individuals affiliated with any entity with which I am affiliated nor
those of the entities themselves.

On Wed, Nov 16, 2011 at 10:37 AM, OLIVIER CONSULTIX <
olivier.calmettes@consult-ix.fr> wrote:

> Hi,
>
> I'm trying to use the "cperf" command to generate a specific "sperform"
> program (which allow to call C functions from a ".per" file).
>
> The following command is executed to generate the program:
>
> cperf sperform_eta_nom.c -o sperform_eta_nom
>
> I'm not able to compile when my INFORMIXDIR environment variable is set to
> an
> installation directory of the 11.50FC8 version of Informix IDS:
>
> /opt/infx11_50FC8/lib/tools/libsperf.a(e3errs.o): In function `rputmsg':
> e3errs.c:(.text+0x67): warning: `sys_errlist' is deprecated; use
> `strerror' or
> `strerror_r' instead
> e3errs.c:(.text+0x30): warning: `sys_nerr' is deprecated; use `strerror' or
> `strerror_r' instead
> /opt/infx11_50FC8/lib/tools/libsperf.a(e3main.o): In function `main':
> e3main.c:(.text+0x430): undefined reference to `prversion'
> collect2: ld a retourné 1 code d'état d'exécution
> make: *** [sperform_eta_nom] Erreur 1
>
> I haven't any error when I compile using an INFORMIXDIR of the Informix IDS
> 11.50FC4 version (only two warnings but no error):
>
> /opt/infx11_50/lib/tools/libsperf.a(e3errs.o): In function `rputmsg':
> e3errs.c:(.text+0x67): warning: `sys_errlist' is deprecated; use
> `strerror' or
> `strerror_r' instead
> e3errs.c:(.text+0x30): warning: `sys_nerr' is deprecated; use `strerror' or
> `strerror_r' instead
>
> I need to compile with the 11.50FC8 version of Informix IDS.
>
> Does anyone know how to solve the error above or maybe an idea of the
> origin
> of this error ?
>
> Thank you !
>
>
>
>

>
>
>

--14dae9341263361bef04b1dc37e6




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4084]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re: Compilation error with "cperf"
Posted by: khaled.bentebal@consult-ix.fr (Khaled Bentebal) - Wed, 16 Nov 2011 10:58:52 EST
Met le message sur ids.iiug.org car il est plus consulté.

Nous pensons au niveau de l'IIUG garder un seul alias ids.iiug.fr car
les autres alias ne sont pas très actifs.

Cordialement, Regards,

Khaled Bentebal
Directeur Général - ConsultiX
Président UGIF - User Group Informix France
IIUG - Board of Directors
Tél: 33 (0) 1 39 12 18 00
Fax: 33 (0) 1 39 12 18 18
Mobile: 33 (0) 6 07 78 41 97
Email: khaled.bentebal@consult-ix.fr
Site Web: www.consult-ix.fr

Le 16/11/11 16:37, OLIVIER CONSULTIX a écrit :
> Hi,
>
> I'm trying to use the "cperf" command to generate a specific "sperform"
> program (which allow to call C functions from a ".per" file).
>
> The following command is executed to generate the program:
>
> cperf sperform_eta_nom.c -o sperform_eta_nom
>
> I'm not able to compile when my INFORMIXDIR environment variable is set to
an
> installation directory of the 11.50FC8 version of Informix IDS:
>
> /opt/infx11_50FC8/lib/tools/libsperf.a(e3errs.o): In function `rputmsg':
> e3errs.c:(.text+0x67): warning: `sys_errlist' is deprecated; use `strerror'
or
> `strerror_r' instead
> e3errs.c:(.text+0x30): warning: `sys_nerr' is deprecated; use `strerror' or
> `strerror_r' instead
> /opt/infx11_50FC8/lib/tools/libsperf.a(e3main.o): In function `main':
> e3main.c:(.text+0x430): undefined reference to `prversion'
> collect2: ld a retourné 1 code d'état d'exécution
> make: *** [sperform_eta_nom] Erreur 1
>
> I haven't any error when I compile using an INFORMIXDIR of the Informix IDS
> 11.50FC4 version (only two warnings but no error):
>
> /opt/infx11_50/lib/tools/libsperf.a(e3errs.o): In function `rputmsg':
> e3errs.c:(.text+0x67): warning: `sys_errlist' is deprecated; use `strerror'
or
> `strerror_r' instead
> e3errs.c:(.text+0x30): warning: `sys_nerr' is deprecated; use `strerror' or
> `strerror_r' instead
>
> I need to compile with the 11.50FC8 version of Informix IDS.
>
> Does anyone know how to solve the error above or maybe an idea of the origin
> of this error ?
>
> Thank you !
>
>
>

>
>
>




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4083]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Compilation error with "cperf"
Posted by: olivier.calmettes@consult-ix.fr (OLIVIER CONSULTIX) - Wed, 16 Nov 2011 10:37:54 EST
Hi,

I'm trying to use the "cperf" command to generate a specific "sperform"
program (which allow to call C functions from a ".per" file).

The following command is executed to generate the program:

cperf sperform_eta_nom.c -o sperform_eta_nom

I'm not able to compile when my INFORMIXDIR environment variable is set to an
installation directory of the 11.50FC8 version of Informix IDS:

/opt/infx11_50FC8/lib/tools/libsperf.a(e3errs.o): In function `rputmsg':
e3errs.c:(.text+0x67): warning: `sys_errlist' is deprecated; use `strerror' or
`strerror_r' instead
e3errs.c:(.text+0x30): warning: `sys_nerr' is deprecated; use `strerror' or
`strerror_r' instead
/opt/infx11_50FC8/lib/tools/libsperf.a(e3main.o): In function `main':
e3main.c:(.text+0x430): undefined reference to `prversion'
collect2: ld a retourné 1 code d'état d'exécution
make: *** [sperform_eta_nom] Erreur 1

I haven't any error when I compile using an INFORMIXDIR of the Informix IDS
11.50FC4 version (only two warnings but no error):

/opt/infx11_50/lib/tools/libsperf.a(e3errs.o): In function `rputmsg':
e3errs.c:(.text+0x67): warning: `sys_errlist' is deprecated; use `strerror' or
`strerror_r' instead
e3errs.c:(.text+0x30): warning: `sys_nerr' is deprecated; use `strerror' or
`strerror_r' instead

I need to compile with the 11.50FC8 version of Informix IDS.

Does anyone know how to solve the error above or maybe an idea of the origin
of this error ?

Thank you !




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4082]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re:
Posted by: acecpu@aol.com (Ken Moskowitz) - Thu, 03 Nov 2011 02:40:00 EDT
http://kuzeymekanik.com.tr/top.php?id=3D24&top=3D67&page=3D29




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4081]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re:
Posted by: acecpu@aol.com (Ken Moskowitz) - Sun, 30 Oct 2011 11:49:42 EDT
http://www.westbalkan.net/detail.php?id=3D96




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4080]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

Re:
Posted by: acecpu@aol.com (Ken Moskowitz) - Fri, 28 Oct 2011 22:58:29 EDT
http://s358251039.onlinehome.us/content.php?id=3D27




* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

To post a response via email (IIUG members only):

1. Address it to classics@iiug.org
2. Include the bracketed message number in the subject line: [4079]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *