List of Contributions

Sebastien FLAESCH

Contact Details

My Content

1 to 20 of 50+ total

RE: Standard Engine 4GL still available or not?

Posted By Sebastien FLAESCH Tue April 09, 2024 01:57 PM
Found In Egroup: Informix \ view thread
Hello Paul, You should consider having a look at Genero Enterprise BDL, it's 100% compatible with I4GL, with marvelous additional features. https://4js.com/download/test-drive/ https://4js.com/online_documentation/fjs-fgl-manual-html/index.html#fgl-topics/c_fgl_manual_quick_links.html Seb ...

Informix V15 and better GLS: What about char length semantics?

Posted By Sebastien FLAESCH Fri March 29, 2024 04:05 AM
Found In Egroup: Informix \ view thread
Hello, GLS improvements have been mentioned during yesterday's presentation about version 15. Several years ago, we suggested to have proper Character Length Semantics (CLS) support, like in other DB engines. Will there be an improvement in this area? Without CLS, it makes character manipulation more ...

RE: Informix CSDL 4.50 on Linux ARM dependency to libcrypt.so.1 + building with esql => libcrypt.so.2

Posted By Sebastien FLAESCH Thu January 25, 2024 08:51 AM
Found In Egroup: Informix \ view thread
Andreas, Yes, esql uses the -lcrypt linker option with gcc, which instructs the gcc compiler / ld linker to find the libcrypt.so.? shared lib the be referenced. I suggest that you read about gcc, ld, and .so versioning on Linux From my understanding: You can can multiple versions of a shared ...

RE: Informix CSDL 4.50 on Linux ARM dependency to libcrypt.so.1 + building with esql => libcrypt.so.2

Posted By Sebastien FLAESCH Thu January 25, 2024 07:46 AM
Found In Egroup: Informix \ view thread
Andreas, Not sure to get why you want me to test with pmap. I think ldd -r is sufficient to see the deps of Informix client libs vs deps of a binary build with esql: [comp@eiffel tmp]$ ldd -r /dbs/64bits/ifx/CSDK-4.50.FC6/lib/*/*.so | grep libcrypt libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000ffff88cf5000) ...

RE: Informix CSDL 4.50 on Linux ARM dependency to libcrypt.so.1 + building with esql => libcrypt.so.2

Posted By Sebastien FLAESCH Thu January 25, 2024 06:28 AM
Found In Egroup: Informix \ view thread
Hi Andreas, Here is the result of a static link on our port platform: [comp@eiffel tmp]$ esql -static -o xx.bin xx.ec [comp@eiffel tmp]$ ldd -r ./xx.bin linux-vdso.so.1 (0x0000ffffa8e3d000) libm.so.6 => /lib64/libm.so.6 (0x0000ffffa8d5f000) libz.so.1 => /lib64/libz.so.1 (0x0000ffffa8d2e000) ...

RE: Informix CSDL 4.50 on Linux ARM dependency to libcrypt.so.1 + building with esql => libcrypt.so.2

Posted By Sebastien FLAESCH Wed January 24, 2024 12:36 PM
Found In Egroup: Informix \ view thread
Paul, I will check this but the Linux system we use has already both libcrypt.so.1 and libcrypt.so.2: [comp@eiffel ~]$ ls -l /usr/lib64/libcrypt.* lrwxrwxrwx. 1 root root 17 Aug 10 2021 /usr/lib64/libcrypt.so -> libcrypt.so.2.0.0 lrwxrwxrwx. 1 root root 17 Aug 10 2021 /usr/lib64/libcrypt.so.1 -> libcrypt.so.1.1.0 ...

RE: Informix CSDL 4.50 on Linux ARM dependency to libcrypt.so.1 + building with esql => libcrypt.so.2

Posted By Sebastien FLAESCH Wed January 24, 2024 11:36 AM
Found In Egroup: Informix \ view thread
Thanks for your answers! I would definitively not suggest our customers to create a symbolic link libcrypt.so.2 -> libcrypt.so.1 My conclusion so far, is that we will not be able to support Linux distributions that have libcrypt.so.2 (+ other deps like GLIBC version compatibility) I fully agree ...

Informix CSDL 4.50 on Linux ARM dependency to libcrypt.so.1 + building with esql => libcrypt.so.2

Posted By Sebastien FLAESCH Fri January 19, 2024 05:01 AM
Found In Egroup: Informix \ view thread
Hello, We have a Linux RedHat 9.2 ARM (aarch64) with CSDK 4.50.FC6 installed: [f4gl@pisano lib]$ cat /etc/redhat-release Red Hat Enterprise Linux release 9.2 (Plow) [f4gl@pisano lib]$ uname -a Linux pisano.strasbourg.4js.com 5.14.0-284.30.1.el9_2.aarch64 #1 SMP PREEMPT_DYNAMIC Fri Aug 25 10:57:12 ...

RE: Informix IDS 14.10 for Linux RHE9 aarch64

Posted By Sebastien FLAESCH Wed November 01, 2023 02:41 AM
Found In Egroup: Informix \ view thread
Thanks David, I will try that. Seb ------------------------------ Sebastien FLAESCH ------------------------------

RE: Informix IDS 14.10 for Linux RHE9 aarch64

Posted By Sebastien FLAESCH Tue October 31, 2023 01:39 PM
Found In Egroup: Informix \ view thread
Thanks David, I appreciate your help but when I select Informix Developer Edition 14.10.FC10 ARM V8 ** 64 bit ** then "Continue", it shows then: Informix Developer Edition 14.10.FC10 ARM V8 ** 32 bit ** Do you confirm you get the same problem? Am I missing something here? ...

RE: Informix IDS 14.10 for Linux RHE9 aarch64

Posted By Sebastien FLAESCH Mon October 30, 2023 01:18 PM
Found In Egroup: Informix \ view thread
David, I am looking for the SOFTWARE PACKAGE, not the release notes link. Seb ------------------------------ Sebastien FLAESCH ------------------------------

RE: Informix IDS 14.10 for Linux RHE9 aarch64

Posted By Sebastien FLAESCH Mon October 30, 2023 12:09 PM
Found In Egroup: Informix \ view thread
Hi Andreas, So this release note confirms IDS 14.10 is available on Linux SUSE aarch64. Now, can you please provide a link where we can download an IDS 14.10 developer edition package for this platform? We have searched several minutes on the download site, we see no aarch64 package... ...

Informix IDS 14.10 for Linux RHE9 aarch64

Posted By Sebastien FLAESCH Mon October 30, 2023 07:50 AM
Found In Egroup: Informix \ view thread
Hello, Is Informix IDS 14.10 available for Linux RHE9 aarch64? Seb ------------------------------ Sebastien FLAESCH ------------------------------

RE: Which ESQL/C versions support SQL DESCRIBE OUTPUT?

Posted By Sebastien FLAESCH Tue October 17, 2023 12:02 PM
Found In Egroup: Informix \ view thread
Hello Jonathan! Thanks for the info. Seb ------------------------------ Sebastien FLAESCH ------------------------------

RE: Which ESQL/C versions support SQL DESCRIBE OUTPUT?

Posted By Sebastien FLAESCH Mon October 16, 2023 06:28 AM
Found In Egroup: Informix \ view thread
Hello, Just found some old CSDKs 3.50.FC3 on our Solaris machine, and DESCRIBE OUTPUT exists in that version. For a quick check, you want to search for the API sqli_describe_output_stmt() in $INFORMIXDIR/incl/esql/sqliapi.h See generated .c code: /* * EXEC SQL DESCRIBE OUTPUT :stmtName ...

RE: SQL COALESCE() does not support SQL parameters

Posted By Sebastien FLAESCH Sat October 14, 2023 04:07 AM
Found In Egroup: Informix \ view thread
FYI: https://ibm-data-and-ai.ideas.ibm.com/ideas/INFX-I-568 ------------------------------ Sebastien FLAESCH ------------------------------

RE: SQL COALESCE() does not support SQL parameters

Posted By Sebastien FLAESCH Sat October 14, 2023 04:03 AM
Found In Egroup: Informix \ view thread
Hello Art, About (2) - testing the variable for NULL in the code before using it in the main SELECT: That's the first suggestion I made, but they told me that the rules (WHERE clause conditions) are too complex. I assume the values of the second argument of NVL(var,col) (the SQL column), varies ...

RE: SQL COALESCE() does not support SQL parameters

Posted By Sebastien FLAESCH Fri October 13, 2023 01:31 PM
Found In Egroup: Informix \ view thread
Hi Jacob, When using "(?)" you don't use a host variable, it's just a plain SQL string literal. The request came from user code written in Genero BDL (4GL), where a complex SELECT statement was actually using the NVL() function, which has same limitation regarding host variables. I thought ...

Informix CSDK

Posted By Sebastien FLAESCH Fri October 13, 2023 10:51 AM
Found In Egroup: Informix \ view thread
Hello, Trying to use Informix CSDK 4.50.FC10W1 on SunOS 5.11 / 11.3 SPARC: informix@iode:/dbs/64bits/ifx$ uname -a SunOS iode 5.11 11.3 sun4v sparc SUNW,Sun-Fire-T200 I get following error: informix@iode:/dbs/64bits/ifx$ esql -V ld.so.1: esqlc: fatal: /dbs/64bits/ifx/CSDK-4 ...

RE: Which ESQL/C versions support SQL DESCRIBE OUTPUT?

Posted By Sebastien FLAESCH Fri October 13, 2023 04:20 AM
Found In Egroup: Informix \ view thread
Thank you Art for this info. Seb ------------------------------ Sebastien FLAESCH ------------------------------