Hello everybody! I'm doing some work with Informix IDS. I have to create some dbspaces, sbspaces, etc. Which mode is better to make this changes? Quiescent, or Single-user? Why? Thanks a lot! ...
For example: Being able to start displaying or manipulating rows as they are being returned by a query while the query has not finished searching the table?.. and I don't mean using the FIRST ROWS directive to hint the engine, I mean transparently, without having to add addtional logic. A feature like this would be useful for queries whi...
It's my understanding that the quickest way to access a particular row is by its ROWID. In INFORMIX-SE 7.3, when I do a 'SELECT ROWID FROM table;' I notice that its values are type SERIAL[INT]. In oracle, they are SERIAL[HEX]. Has anyone ever used ROWID for any practical use?.. If I wanted to locate the most recent row added to a table, ...
Hello everybody. I'm starting with Databases. I've been playing around with MySQL and Informix, but never had a real life project. What is the real responsibility of a Database? Should we add Store procedures and functions to de Database or just let it to be a data repository with no logic? ...
INFORMIX-SQL 7.32 (SE) Perform screen: Let's say I have a start date of FEB-15-2010 and an end date of MAY-27-2010. I can calculate the number of elapsed days with 'let elapsed_days = end_date - start_date', but how can I convert these number of days into 3 months, 1 week and 5 days? A raw calculation I've seen used, rounding every m...
INFORMIX-SE 7.32: I'm getting error 360 when I try to execute the following statement: update transaction set transaction.colx = (select tab1.cola from tab1) where transaction.num = (select max(transaction.num) from transaction) and transaction.colx IS NULL; Any ideas? ...
INFORMIX-SE 7.32: I have a transaction table with about 5,000 nrows. The transaction.ticket_number[INT] is a column which gets updated with the next available sequential ticket number every time a specific row is updated. The column is unique indexed. I'm currently using the following SELECT statement to locate the max(transaction.ticke...
ISQL 7.3 Perform: In my perform screen I have: dsptag1 = DISPLAYONLY TYPE SMALLINT; dsptag2 = DISPLAYONLY TYPE DECIMAL; lastpdate = transaction.last_pymt_date; [DATE] inttab1 = interest.int_rate1; [DEC(5,2) {from lookup table}] AFTER QUERY DISPLAY OF transaction LET dsptag1 = TODAY - lastpdate LET dsptag2 = inttab1 * dsptag1 [...] ...
Hi, I have posted the same question 2 month ago here and lot of nice people helped me. I was able to go through all the instructions mentioned in the link below to set up the ssl connections.Below are the links: Configure connections to the data source to use SSL. (link1) Configure your Java Runtime Environment to use SSL. (link2) I...
I have the following dilema: My clients (mom-n-pop pawnshops) have been using my mgmt. system, developed with ISQL, for over 20 years. Throughout these two decades, I have customized the app to each clients desire, or when changes in Laws/Regulations have required it. Most clients are single-user sites. Some have multiple stores, but hav...
INFORMIX-SQL 7.32 (SE): I've created an audit trail "a_trx" for my transaction table to know who/when has added or updated rows in this table, with a snapshot of the rows contents. According to documentation, an audit table is created with the same schema of the table being audited, plus the following audit info header columns pre-fixed...
Back in 1985, when I was a Product Planner for AT&T-IS Labs (Unix Product Management), one of my primary duties was to evaluate emerging 4GL/RDBMS products, submit product plans and recommend whether AT&T should pursue a co-marketing or co-labeling agreement with the vendor or just test/certify it as compatible on our 3B-series systems. ...
Hello everybody. I'm administrating a informix IDS DBMS in Argentina. We speak spanish, and the traditional ASCII caracter Set of Informix doesn't fit our needs. I've been fooling around, and make it work with the DB_LOCALE variable. But i've seen some other call CLIENT_LOCALE and SERVER_LOCALE. Should i use them? Is it enough with DB_L...
INFORMIX-SQL 2.10.06E (DOS 6.22): This is one of the legacy version of isql that runs in pure DOS, but didnt have support for DATETIME or CURRENT! However the ace report writer has the 'time' keyword constant which returns the time of day from the system clock in military format "hh:mm:ss". I could never understand why RDS (in those day...
INFORMIX-SE: SE allows you to create an audit file for any table. The audit file has the same schema as the table being audited plus a header consisting of several columns, one of them being a_time INTEGER, which contains a UNIX timestamp of when the row was added, updated or deleted. UNIX timestamp is an INTEGER value corresponding to ...
Although Oracle is one of the earliest to create stored procedures (PL/SQL) then Informix with (SPL) which RDBMS products besides DB2 have implemented SQL/PSM or a subset of it after 1998?.. Which RDBMS' can support procs like in the following example?: CREATE OR REPLACE FUNCTION foo1(a integer) RETURNS void AS $$ CASE a WHEN 1, ...
Back in 1989, when I used to program with Oracle 5.2.3 on UNIX and VAX/VMS platforms, I considered SQL*PLUS as having the richest super-set of built-in functions. ORACLE*FORMS also had the ability to embed SQL statements within triggers. That was then, 21 years ago. At present, which other RDBMS' have come close, have the same, or more f...
INFORMIX-SQL 7.32 (SE) Linux Pawnshop App. I have some users who own several pawnshops within a 100-mile radius. Each pawnshop app runs with SE. The only functionality these owners need are: ability to remotely login to any store in order to view transactions, running totals and consolidate daily totals at end of business day. This can ...
I am looking to retrieve the raw query bytes from an Oracle statement and copy them directly into a POD C structure. The reason for this is due to legacy code that must be ported to using Oracle from Informix. I'll illustrate what I basically need below. I have been looking into using the Oracle Template Library (OTL) but I have been una...
My first experience developing DBMS-based apps was with IMS, using COBOL calls to DLI. Later on, I worked with several other products, on a smaller scale, such as: DBASE, INFORMIX 3.3/SQL and ORACLE on DOS, UNIX-XENIX and VAX/VMS platforms. When I was a product planner for AT&T-IS Labs, I had the opportunity to eval several RDBMS-based a...