Four Js Development Tools Forum

Genero 2.20.06 is not using GL_DATETIME enviroment variable for formatting DATETIME variables:

Environment used:


OS:
   Red Hat Enterprise Linux ES release 4 (Nahant Update 8 )
   Architecture: x86_64

      % uname -a
      Linux xxxxxxx 2.6.9-89.ELsmp #1 SMP Mon Apr 20 10:33:05 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux

      % arch
      x86_64

      % rpm -q kernel
      kernel-2.6.9-89.EL

      % rpm -q glibc
      glibc-2.3.4-2.43
      glibc-2.3.4-2.43

      # shell used: tsch (/bin/tcsh) version 6.13.00
      % rpm -q tcsh
      tcsh-6.13-10.el4

      % echo $version
      tcsh 6.13.00 (Astron) 2004-05-19 (x86_64-unknown-linux) options 8b,nls,dl,al,kan,rh,color,dspm,filec


Informix:
   Client-SDK 3.50.FC4:

      % esql -V
      IBM Informix CSDK Version 3.50, IBM Informix-ESQL Version 3.50.FC4
      Software Serial Number AAA#B000000

   IBM Informix Dynamic Server 11.50.FC4:

       % onstat -V
       IBM Informix Dynamic Server Version 11.50.FC4     Software Serial Number AAA#B000000

       % dbaccess -V
       DB-Access Version 11.50.FC4     Software Serial Number AAA#B000000



Four J's Genero BDL:
   Genero BDL 2.20.06

   % fgl2p -V
   fgl2p 2.20.06 build-1369.77
   (c) 1989-2009 Four J's Development Tools


OS Locale settings:
   % echo $LANG
   pt_PT.iso885915@euro

   % env | grep LOCALE
   DB_LOCALE=pt_pt.8859-15
   SERVER_LOCALE=pt_pt.8859-15
   CLIENT_LOCALE=pt_pt.8859-15

   % echo $GL_DATETIME
   %d/%m/%iY %H:%M:%S

   % echo $GL_DATE
   %d/%m/%iY



1.) Using dbaccess the display is correct (the GL_DATETIME setting is used)

        % cat prog0001.sql
        select cast("2009-07-27 09:15:22" as datetime year to second) as my_datetime -- July 27, 2009 (09h15m22s)
            from sysmaster:sysdual;

        % dbaccess sysmaster prog0001.sql

        Database selected.

        my_datetime  27/07/2009 09:15:22

        1 row(s) retrieved.

        Database closed.

        # Correct format.



2.) Using a simple Genero BDL program dbaccess the display is incorrect (the GL_DATETIME setting is NOT used, the default format is used):

        % setenv FGLGUI 0              # The problem is the same in GUI mode (FGLGUI=1)
        % cat prog0001.4gl
        main
           define
              l_my_datetime      datetime year to second

           let l_my_datetime = "2009-07-27 09:15:22" -- July 27, 2009 (09h15m22s)

          display l_my_datetime
        end main

        % fgl2p prog0001.4gl

        % fgl2p -o prog0001.42r prog0001.42m

        % fglrun prog0001.42r
        2009-07-27 09:15:22

        # Wrong format!



3.) Using Informix 4GL-RDS 7.30.UC2 in a similar environment, the display is correct  (the GL_DATETIME setting is used):

        % fglpc -V
        IBM INFORMIX-4GL Version   7.32.UC2
        Pcode Version 732

        Software Serial Number RDS#N000000


        % fglpc prog0001.4gl

        % fglgo prog0001.4go
        27/07/2009 09:15:22

        # Correct format.





Vitorino Ribeiro
SINFIC - Sistemas de Informação Industriais e Consultoria, S.A.
http://www.sinfic.pt
vribeiro@sinfic.pt

Hello Vitorino,


May I ask you to read the purpose of the technical forum please :

   https://4js.com/fjs_forum/index.php?topic=7.0

This post is a support issue, may I ask you to send it to your support center please.

Thank you and regards,



Olivier ECKERT - Four J's Development Tools Support