Posted
by tabrez123
on Stack Overflow
See other posts from Stack Overflow
or by tabrez123
Published on 2010-04-12T06:35:21Z
Indexed on
2010/04/12
6:43 UTC
Read the original article
Hit count: 420
how to create huge database in informix ids 11.50
© Stack Overflow or respective owner
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
as seen on Server Fault
- Search for 'Server Fault'
I have around six million files (only files ,no sub-dir) to delete in UFS file system.
Any tips to increase the performance?
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi,
I have a lot of confusion on understanding the difference between a "far" pointer and "huge" pointer, searched for it all over in google for a solution, couldnot find one. Can any one explain me the difference between the two. Also, what is the exact normalization concept related to huge pointers…
>>> More
as seen on Internet.com
- Search for 'Internet.com'
The iPad targets the business market as it simultaneously aims at the education, publishing, and gaming markets.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
how to create huge database in informix ids 11.50
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi.
I've got a "slightly" large sql script saved as a textfile. It totals in at 8.92gb, so it's a bit of a beast.
I've got to do some search and replaces in this file(specifically, change all NOT NULL to NULL, so all fields are nullable) and then execute the darned thing. Does anyone have any suggestions…
>>> More
