-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have problem with performance of Java UDR functions on Informix on Windows.
On this server I already have some functions in C and SPL.
I chose one function to write it in those 3 languages and I measured
performance of this function on test table.
Function calculates some kind of checksum so it…
>>> More
-
as seen on Server Fault
- Search for 'Server Fault'
I have informix 11.5 running in my Win-2003 box and few databases running in it.
System databases have locale en_us.819
My custom databases have locale en_us.57372 (UTF8).
There is also application deployed to JBoss 4.0.2 which has few datasources configured for those custom databases.
<local-tx-datasource>
<jndi-name>InformixDS</jndi-name>
<connection-url>jdbc:informix-sqli://@database…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have problem with JDBC application that uses MONEY data type.
When I insert into MONEY column:
insert into _money_test (amt) values ('123.45')
I got exception:
Character to numeric conversion error
The same SQL works from native Windows application using ODBC driver.
I live in Poland and have…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
INFORMIX-SQL 4.1 - There's this ASCII UNIX file called "passwd" in /usr/informix/etc which
holds all the user id's and encrypted passwords to log into ISQL.
Is there a system catalog table which holds the logged in users?
I see a SYSUSERS.DAT file but when I queried it, it didnt show my login id…
>>> More
-
as seen on Stack Overflow
- Search for 'Stack Overflow'
How can I concatenate two char columns within a perform screen?
example:
table sample
col1 char(1),
col2 char(1)
.
.
after editadd of sample
let label_3 = sample.col1 + sample.col2
.. this didn't work, I even tried using subscripts for the 2 cols but no dice!
>>> More
