33 C
Chennai, India
Saturday, October 2, 2021 08:45 AM
Informix

Informix

I was working in a Software Company.

I need to learn Informix 4GL according to my Project Requirement. I would like to know how we can execute the .per files?

Can you tell me the procedure to execute those files.

  • 1125 views
  • 1 answers
  • 0 votes

Good day,

Let me put this issue in this way: I have 4 databases on my Informix server 11.5 say A, B, C, D. I can connect to B, C and D which are the default Informix databases and A is created by the DBA.

The information about A:

1- This database is created from an earlier existing database on an older version

2- Not sure what was the platform on which the Informix was running, from which this database has been imported

3- The newer version of Informix runs on Windows Server 2003

Now when I try to connect to the database, it gives me 23197: Database locale information mismatch.

  • 4636 views
  • 1 answers
  • 21 votes

 

Hello,

I had installed Informix 11.10 developer edition in Windows XP. Without changing any of the configuration parameters, I tried to import a database. While executing the dbimport command, the database got created, around 15 tables got created and loaded, and then I got the following errors:
 
271 – Could not insert new row into the table.
 
131 – ISAM error: no free disk space.
 
Can someone please help me resolve the errors?
 
Thanks and best wishes to all.

 

 

  • 7270 views
  • 2 answers
  • 20 votes

Hi,

I would like to configure an enterprise replication between two databases (for only specific tables) in one single database server. Can this be accomplished by creating an alias name for the dbserver and using the actual dbservername and the dbserveralias to start replication?

I.e., DBSERVER=ids_em, DBSERVERALIAS=ids_em_alias, 1st db=test, 2nd db=test1, specific tables to be replicated from test to test1.

I don’t want to use triggers, as triggers are immediate and any error on “test1” would prevent the transaction from getting committed even in the db “test”. So I preferred to use ER in background. Can anybody help me out?

Regards.

  • 1073 views
  • 1 answers
  • 20 votes

Hi,

I am using the Informix database with dbaccess data_base_name. Could you please let me know how to execute a SQL query every month end without modification of the query? For example every end of month I have a dozen of SQL queries to be executed and I have to send the results to my colleagues but I have to edit each of them to modify the period from Day 1 to Day 30 if it’s November or from Day 1 to Day 31 if it’s December, etc.

How should I write these fields in my SQL script?

Thanks.

  • 1460 views
  • 1 answers
  • 20 votes

Good day,

I am working on converting windows applications, so it can be used with SQL server and Informix database. In a SQL server, the return data type of the SUM () function is the same as the data type of the column begin summed. So, if I sum integer field I get integer data type. It appears in Informix, that no matter what I SUM (), I get a float data type.

I have two questions:

1-Is there a setting that could change this?

2-What other aggregate functions does this apply to?

 

Thank you in advance for your help.

Regards.

  • 1576 views
  • 1 answers
  • 20 votes

Hello,

I am confused. DISTINCT or GROUP BY which one has a better performance in Informix database? I am new to the Informix database. By the way, in my Select query there is no aggregate function. It’s a direct Select query with WHERE clause and I used DISTINCT, but one of my seniors told me that GROUP BY has a better performance than DISTINCT. Is it true? Please let me know the details or post any article url explaining this issue.

Thanks.

  • 1670 views
  • 2 answers
  • 20 votes

Hi all,

I am working with two databases in Informix 10. Each one is on a different machine and I am trying to copy some data from one table to an identical table in the other database. Both databases are in UTF-8.

  • 2599 views
  • 1 answers
  • 20 votes

Hi experts,

I would like someone to help me with migration that I must execute soon. I will migrate an older Informix database to a newer Oracle 11g database. This is my first big migration experience and I have some questions.

First, I would like to know if Oracle Migration workbench already does what Oracle says and migrates easily or should I expect problems with its usage? My second question is, if I must do the migration manually, which steps do you recommend? I really need any help, suggestions and advice on this issue.

Thanks.

  • 2549 views
  • 1 answers
  • 20 votes

Hi,

I have faced a strange problem and I cannot solve it. I have an ASP.net application and I have made a setup of the Informix .NET provider.

– When I run my Application with F5 in debug mode, everything works fine, but the same application with the same unchanged mode and on the same machine does not work on IIS7.

– When I run it on IIS7, the connection to the database opens fine, and after executing the IFXDataReader I receive a null value, already the same code, same machine, and same databases! What is the reason behind this?

Thanks in advance.

  • 2219 views
  • 1 answers
  • 20 votes

Articles

Blogs

Tips