How can seam-gen be customized to support another database?
I would like to create an application from a database schema using seam-gen; unfortunately Informix isn't supported out of the box. Where can I add another db? ...
informix
Generated queries contain schema and catalog name
I've the same problem as described here In the generated SQL Informix expects catalog:schema.table but what's actually generated is catalog.schema.table which leads to a syntax error. Setting: hibernate.default_catalog= hibernate.default_schema= had no effect. I even removed schema and catalog from the table annotation, this caus...
Is this Informix SE?
I have a group of files that have extensions of .dat & .idx. They seem to be named in pairs. These files were under a folder named deeds.dbs. How do I access this data? Sorry for the general question, but I know nothing about Informix at all. ...
Created query is not supported by my DB
I created an application using seam-gen. The created operation to search the DB ends with and exception (syntax error). The query has a where clause like this: lower(barcode0_.barcode_ean) like lower((?||'%')) limit ? Does hibnerate or seam create the where clause which my DB can't understand? Or is there a workaround for SQL stateme...
Migrating Data to SQL Server 2008
I am trying to migrate data from an Informix database to SQL Server 2008. I've got quite a lot of data to move. I've been try multiple methods to get the data over, and so far SQLBulkCopy in multiple chunks seems to be the fastest that I can find. Does anyone know of a faster means of getting the data over? I'm trying to cut down on the...
Sync tables between different database providers
I have 2 tables in 2 different databases, one is in a mysql server and one is in an informix server. Using .net and odbc, is there a way to identify the differences of both tables and merge them? so that both informix database and mysql database have the same data. thanks. ...
Informix - Fetching Records from a table
Consider the table below: Col1 Col2 Col3 123 ABC 20/5/2010 123 CDS 21/5/2010 123 VDS 22/5/2010 123 ABC 23/5/2010 123 VDS 24/5/2010 123 CDS 25/5/2010 123 ABC 26/5/2010 I need to fetch the first occurrence of CDS and calculate the time diff between the next row. Similarly I need to find out the next occurrence of CDS and...
Informix: datetime manipulation
I have 2 fields in a table test1: onlydate DATE onlytime DATETIME HOUR TO MINUTE and 1 field in a table test2: dateandtime DATETIME YEAR TO SECOND Now I need to append the value of onlydate and onlytime field and set it to dateandtime field. How do I do that? ...
Declaring Variables on Informix
Hi everybody. I've a Store Procedure Routine. I want to get some variables from the execution of that proc. But i don't know how to create it. For example: CREATE PROCEDURE foo() ... RETURN somebar; END PROCEDURE; then, when i call it: -- DEFINE bar, this is what i want to know!!!! execute procedure foo() into bar; How can i initial...
Converting Informix 'Perform' screens to a Windows-based application
For the past several years we have slowly built an Access-based front end to access our InformixSE database (unix). Our Sun server will be shut down in a couple of months and I'm looking for a relatively inexpensive solution for porting over the remainder of our old ".per" screens to a Windows-based solution. And even for the screens th...
Including tax in total sale price.
INFORMIX-SQL 7.3 Perform Screen: Suppose I have a customer who wants to pay a $100 (7% tax included), what logic can I use so that when the cashier clerk enters $100 in the tax included sale amount, it will calculate the sale price and tax so that it adds up to $100. I have the following 3 field tags in my Perform screen: sprice = tra...
Consolidating separate Loan, Purchase & Sales tables into one transaction table.
INFORMIX-SE with ISQL 7.3: I have separate tables for Loan, Purchase & Sales transactions. Each tables rows are joined to their respective customer rows by: customer.id [serial] = loan.foreign_id [integer]; = purchase.foreign_id [integer]; = sale.foreign_id [integer]; I would like to c...
How do I call Informix stored procedures from Perl?
How do I call informix stored procedures from Perl? I use DBD::ODBC to connect to informix database, but I don't know how to call procedures. my code like this: my $dbh = DBI->connect("dbi:".DBDRIVE.":".DBNAME,DBUSER,DBPASS, {RaiseError=>0,PrintError=>0,AutoCommit=>1}) || die $DBI::errstr; $dbh->do("e...
Mimic ISQL Perform screen with I4GL
Is it possible to mimic ISQL Perform screen functionality (i.e. QBF, master/detail, etc.) with a 4GL program? ...
ISQL Perform instruction: after editadd editupdate of table vs. after add update of table
INFORMIX-SQL 7.3 Perform Screens: According to documentation, in an "after editadd editupdate of table" control block, its instructions are executed before the row is added or updated to the table, whereas in an "after add update of table" control block, its instructions are executed after the row has been added or updated to the table....
TransFusion: Should I denormalize Loan, Purchase, Inventory and Sale tables into one Transaction table?
Based on the information I have provided below, can you give me your opinion on whether its a good idea to denormalize separate tables into one table which holds different types of transactions?.. What are the pro's/con's?.. Has anyone attempted this before?.. Banking systems use a CIF (Customer Information File) [master] where customers...
Variable table or column names.
INFORMIX-SQL or any other SQL-based DB: Suppose I have an app where depending on the value of some columns, example: company.code char(3) {abc} company.branch char(2) {01} Can I construct table name "abc01" for inclusion in SELECT * FROM abc01; ? In other words, a variable table name.. same question applies for column names. ...
Where can I find source code of complex ISQL perform screens and ace reports?
I have searched in several software repositories but havent come across any. ...
Self referencing update SQL statement for Informix
Need some Informix SQL... Courses get a regular grade, but their associated labs get a grade of 'LAB'. I need to update the table so that the lab grade matches the course grade. Also, if there is no corresponding course for a lab, it means the course was canceled. In that case, I want to place a flag value of 'X' for its grade. Exam...
What deficiencies, limitations or flaws do you feel exist with SQL and what would you change or add to it?
Have you encountered deficiencies, limitations or flaws while using SQL? I can think of several examples: Complicated queries/updates, SQL injection, etc. € Could you accomplish the same task easily with a different DML or programming language? Can you provide me with case examples of problems you have encountered or cases where for ex...