|
|
Browse by Tags
- 126
- 2000
- 244
- 3
- 4gl
- bulk data extraction
- C#
- cannot
- case
- character
- cksum
- client
- convert
- count
- csv
- current
- cursor
- data base
- database
- date
- dateadd
- datediff
- datetime
- db
- dbaccess
- dblink
- decode
- delete
- describle
- distinct
- do
- download
- driver
- dts
- e_nointerface
- error
- esql
- execution
- export
- extent
- failed
- feature
- file
- fingerprint
- fraction
- function
- GLIBC_2.0
- hash
- having
- IBM
- ids
- implemented
- infx5
- insert
- java
- jdbc
- join
- libc.so.6
- linked server
- management
- md5
- Microsoft
- migrate
- minutes
- misys
- multiple
- ODBC
- oracle
- query
- server
- setenv
- setnet32
- shared
- size
- sql
- sqlca
- sqlca.sqlerrd
- sqlerrd
- statement
- store
- stored
- stored procedure
- structure
- subquery
- subtract
- syntax
- system
- table
- timeout
- too
- translation
- translationdll
- unixODBC
- unload
- update count
- user
- vb
- vs
- within
- write
-
Oracle Dblink to Informix
How do I create a dblink in an Oracle 10g database to an Informix database? -
Inserting data into Informix database
Hi Experts and everybody, Here is my problem. I have an informix database which i recently installed and i have a c++ based application using it. When i created the database ,i exported the data and later used the export scripts to create the objects. database name is tester hence used the tester.sql... -
sqlca.sqlerrd[3] in Informix ?
hi expert; Statement below refers ... ------------------------------------------------------- UPDATE glmastregm SET mth_open_bal = mth_open_bal + w_gladjdet.amt WHERE br_code = w_gladjdet.br_code AND gl_alloc_code = w_gladjdet.gl_alloc_code AND fin_year = w_gladjreg.adj_year AND period_no = c_period... -
Using SQL to create sequential list of item numbers
I need to create a SQL that will fill in the empty id numbers. For example, Table items Items id description 1 red pencil 2 green pencil 5 red pen 6 black pen 8 paper My query needs to return: id description 1 red pencil 2 green pencil 3 4 5 red pen 6 black pen 7 8 paper I am stumped on this simple issue... -
Informix Subquery Join
Is there a syntax for a subquery join in Informix? SQL similar to the following works in most database management systems, but errors in Informix: select * from table1 t1 left outer join (select * from table2) sub on t1.id = sub.id I realize there are other ways to write this query--my real example is... -
SQL Reporting Services and Informix database
I created a report in Reporting Services (Sql 2000) that queries an Informix database. The dataset selects data from a view (Command type = text) and passes a parameter. The query works fine in VStudio designer, but when I publish the report to the report server, it fails. I believe my connection is... -
SQL query help
I have a query that does a self-join to a table and returns values. I want to expand to add error checking so that it will return a blank if the resource indicated does not exist. In other words if one of the values doesn't exist I still want the other two. The following below works when an ID has... -
How to increase the db size in informix?
Hello experts, I need to increase the size of my informix database, I used google to figure it out but Im not quite sure how to do it and how to do it safely. Would you please explain me how to do it, I'll appreciate it. I also use WinSQL, I'm hoping to do it with TSQL. Thank you -
Informix. Installation failed. version GLIBC_2.0 not defined in file libc.so.6
Hello First of all, sorry for my bad english I´m trying to install Informix 7.25 on Open Suse 11.1 Installing directory bin etc/brand: relocation error: etc/brand: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference Installation of INFORMIX-SE failed. Information: quasar... -
Set timeout in Informix JDBC connection?
Hi experts, In one of my projects I am having some strange Problems. Even if they occur about every 3-4 Months, I would like to get rid of them. The problem is that I have a JDBC connection to an Informix database and use this to log changes to my data. Now about every 3-4 Months a JDBC request hangs...