There is a one-to-many relationship in my model, where the child entity is stored in two tables. @Entity @Table(name = “child1”) @SecondaryTable(name = “child2”, pkJoinColumns = { @…
Tag: informix
SSRS 64bit to mandatory 32bit ODBC (Cisco UCCX)
We’re using 64bit SSRS on our reporting server (2008 R2). We have an ODBC connection with the 32bit IBM Informix driver connecting to Cisco UCCX. When I try to add a New Data Source in SSRS to this connection I get the below error. “ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN …
Given any child in the hierarchy, fetch complete tree by INFORMIX hierarchical SQL
I need a little help with Informix hierarchical sql query. I have table with the following structure : I am able to run the following query successfully : which returns the exact hierarchy as specified in the table above. However, I am trying to achieve something different here. I am trying to get the same re…
How to create trigger in informix?
I am trying to write a trigger like in the following simplified example: This fails! Only this works: What am I doing wrong? Answer I think you should write a stored procedure with the IF – THEN logic and call that from this trigger. I think triggers support only simple SQL statements, not SPL statement…
Need to perform ORDER by Twice
I want to sort according to date first and then if date is similar then according to id..How to do that in Informix/HSQL query? Answer A good tutorial on this SQL ORDER BY