Re: Postgresql

Thank you very much.
Works OK!

Best regards.

El lun., 10 de ago. de 2020 a la(s) 13:12, Fernando Ortiz (
[email protected]) escribió:

> Hola
>
> Try with:
>
> A4GL_SQLTYPE=pg8
> A4GL_TARGETDIALECT=POSTGRES8
> A4GL_LEXTYPE=C
>
> Regards,
>
>
> El dom., 9 de ago. de 2020 a la(s) 16:32, Sergio Szychowski (
> [email protected]) escribió:
>
>> Hello,
>> I am trying to connect aubit4gl (1.5.2) with postgresql,
>> (see 9.4), a simple example how to connect to the base, works fine.
>> But this code returns an error,
>> ------
>> database novatecnologias
>> main
>> define waret record like ntcpte.*
>> display "I'm connected"
>> declare curcli cursor for select * from ntcpte
>> foreach curcli into waret.*
>>   display waret.nucomprob_i
>> end foreach
>> end main
>> -------
>> ./test0
>> I'm connected
>> Error:Could not find function in shared library
>> (A4GLSQLLIB_A4GLSQL_set_sqlca_sqlcode)- STOP
>> ---------
>>
>> The adbschema tool also fails.
>> $ adbschema -d novatecnologias
>> ADBSCHEMA (c) 2005-2007 Aubit Computing Ltd
>> Error:Could not find function in shared library
>> (A4GLSQLLIB_A4GLSQL_declare_cursor_internal)- STOP
>>
>> -------
>>
>> Environment variables:
>>
>> export AUBITDIR=/usr/local/aubit4gl-1.5.2pgsql/aubit4glsrc
>> export PATH=$PATH:${AUBITDIR}/bin
>> export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$AUBITDIR/lib
>>
>> # FOR AUBIT4GL
>> export AUBITDIR_SRC=$AUBITDIR
>> export A4GL_INIFILE=$AUBITDIR/etc/aubitrc
>> export AWK=gawk
>> export DBSCREENOUT=/tmp/${USER}.out
>> export A4GL_PRINTSCRKEY=CONTROL-P
>> export A4GL_PRINTSCRFILE=+$DBSCREENOUT
>> export ODDOPTIONS=N
>> export FORCE_CLOSE=Y
>> export BINDDBDATE=Y
>> export CACHESCHEMA=Y
>> export DATE_AS_CHAR=Y
>> export NO_UPDATE_TABLE=Y
>> export FIXUPDATE=Y
>> export DBDATE=DMY4/
>> export NODATETIMES=Y
>> export A4GL_ALLOWCOMMAINDECIMAL=N
>> export LOGODBCSQL=N
>> export A4GL_NUMERIC=.
>> export DATE_AS_ISO_DATE_STRING=Y
>> export USEREALTABLEFORREP=Y
>> export LOGPROXY=Y
>>
>> #####################
>> #Normally - you should have one definition within a GLOBALS .. END GLOBALS
>> #and then you reference that definition from a GLOBALS "filename.4gl"
>> #In Aubit4gl - we try to initialise globals (in informix4GL - c-compiler
>> version - they are not initialised) -
>> #but if its defined in two files - it will get initialised in both (when
>> any function in that module is called).
>> #If you've got it in two files, and you can't "fix" it - try compiling
>> with
>> #####################
>>
>> export NOGLOBALINIT=Y
>> #####################
>> # FOR postgresql
>> export PGHOST=10.1.2.5
>> export PGDATABASE=novatecnologias
>> export PGUSER=myuser
>> export PGPASSWORD=mypassword
>> export PATH=$PATH:/usr/local/PostgreSQL/9.4/bin
>> export
>> LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/PostgreSQL/9.4/lib:/usr/local/PostgreSQL/9.4/lib/postgresql
>>
>> export A4GL_SQLTYPE=pg
>> export A4GL_LEXTYPE=EC
>> export A4GL_LEXDIALECT=POSTGRES
>> # All updates will be transformed to Ansi syntax
>> export A4GL_FIXUPDATE=Y
>> # The keyword 'AS' is included when using an alias on a select column
>> export A4GL_USE_ALIAS_AS=Y
>> # Any CREATE TEMP TABLE .. WITH NO LOG will have the 'WITH NO LOG'
>> silently removed
>> export A4GL_OMIT_NO_LOG=Y
>> # No indicator variables
>> export A4GL_USE_INDICATOR=N
>> # When needed use the ecpg UNLOAD statement rather
>> # than the aubit code
>> export A4GL_ESQL_UNLOAD=Y
>>
>> export A4GL_SQLUID=myuser
>> export A4GL_SQLPWD=mypassword
>> export SQLUID=myuser
>> export SQLPWD=mypassword
>>
>>
>>
>> _______________________________________________
>> Aubit4gl-discuss mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
>>
>

_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss