Jacob SalomonBio

440 messages in this archive (392 questions asked, 48 answers given) — 2009-11-24 18:29:16 to 2009-11-24 18:29:16

Threads

• Rename a partition
• Where do dynamic logs get created? Speculation on DYNAMIC_LOGS parameter (2 messages)
• Re: Union view limits
• Tablespace page limit
• Re: (Another) ontape to recover from a FIFO pipe
• Re: (Another) ontape to recover from a FIFO pipe
• Re: (Another) ontape to recover from a FIFO pipe
• Re: (Another) ontape to recover from a FIFO pipe
• Re: Select the tablespace of the fragment containing the selected row
• Re: Select the tablespace of the fragment containing the selected row
• Select the tablespace of the fragment containing the selected row
• Re: WebLogic Connection Pool
• WebLogic Connection Pool
• NCHAR and NVARCHAR for Foreign letters in English application
• dbload finds fault with my FILE statement
• New release: beautify-unl.sh
• CloudScape: Install -> invalid page fault
• table design
• Re: Column names in unload
• There is a God!
• Altering a table and Long Transactions
• Which table is in which dbspace?
• dbaccess to stop script upon error (2 messages)
• How dangerous is to update a sysmaster table (syschunks)?
• Calling SYSTEM from Stored Procedure...
• How much BLOB space does a table occupy?
• dbexport failed with "Disk space full" message. (3 messages)
• How long has a session been connected?
• Row locked on reads even under dirty read
• oncheck -pP for users
• How to find out which table is locked and kill the responsible process?
• How could I know a row has been updated ?
• Locating the rowid index on a fragmented table
• Newbie question on logs
• Re: oninit -i
• Re: Better locks info
• RE: System Calls in stored procedures SE 7.2
• Re: New utility and requred update of an old one
• Re: Size of logical logs
• New utility and requred update of an old one
• New Utility Shell Script - table-iostats.sh
• Testing nntp server..
• Multiple copies of temp tables (3 messages)
• Connecting to database on another Server
• SQL-Statement UNLOAD TO and jdbc!!
• New utility script - dup-spaces.sh
• Is this an informix leap year bug?
• monitoring temp space
• SQL QUESTION (2 messages)
• How can I speed up the 'drop index' command?
• Procedure bitval() in sysmaster
• Re: List tables per dbspace
• Long checkpoints causing crashes
• Run out of space when re-locating table index
• Newbie shell question.
• Query Optimizer Weirdness in Stored Procedure
• New utilities: dbspace-pages.sh and monitor-space.sh
• system catalog cleanup
• SMI to Detect a Stalled Checkpoint
• Help! Reentrant Triggers
• SMI to Detect a Stalled Checkpoint
• Latest version of informix::DBD for perl 5_004+
• Table locking problem.
• KAIO Environment Variables
• Strange temp table tblspaces in onstat -g ses
• Table unload in ESQLC
• setnet32 dialog box too small - cuts off windows controls
• Re: Ho to identify temp tables from catalog or sysmaster/SMI (2 messages)
• Re: 4gl experts ( Mr. Leffler?) please help, how can I speed up this 4gl?
• Ho to identify temp tables from catalog or sysmaster/SMI
• Re: Null value gets past check constraint
• Null value gets past check constraint
• Join between 32-bit and 64-bit servers
• Re: dbload and load both very slow
• || in 4GL and upshift in SQL
• Move a database to another dbspace
• Interesting: Dbspace names cropping up as databases
• Bogus PID for client on remote host (Re-Post)
• Bogus PID for client on another host
• Ref integrity
• RE: Bogus non-exclusive access creating a foreign key
• Bogus non-exclusive access creating a foreign key
• Question about logical log
• 4GL Newbie Admin question
• Store procedures freezing on sysprocplan lock
• Stored Procedures owned by informix
• Anyone hear of SQL-99 yet?
• Check for index before creation in DBAccess
• changing size of logs
• triggers and C functions/programs???
• Tables in dbspacetemp
• Count Question
• Re: SELECT BETWEEN DIFFERENT SERVERS
• Re: Stored Procedures
• Re: lock modes, isolation levels, and scanning
• Opening a PUT cursor not in a tranasaction
• Re: dbexport
• fgl_init(), fgl_sigint() and other fgl functions
• Anyone using SE with high transaction volume?
• FYI: Uninstall IDSPE, keep ROM - NOT
• Relational Object Manager
• Re: BEGIN/COMMIT work in Stored Procedure
• Re: Increase Raw Device Size
• Re: Log backup on /dev/null
• Re: Help with "458: Long transaction aborted."
• Re: E/SQL host arrays with defined sizes
• Starting a transaction within a SP
• Re: Simple question on INSERT
• Re: Using Sqlda/Sqlca Structures with Describe
• False Alarm?: Choice: Error 27001 or 23101
• Re: Choice: Error 27001 or 23101
• Re: Index Creation Questions
• Choice: Error 27001 or 23101
• Tiny shell script to chase symbolic links to true file name
• New utility in IIUG archives: pgdump
• Multiple instances of SE?
• Tools to retrieve data + pictures
• Re: dbimport utility
• Re: Informix on Linux install
• Re: Question about the 'CURRENT' function in 4gl
• Re: FORMS error 1141
• Re: [Help Me] about dynamic sql?
• Re: World Cup
• Re: -461 error on connect.
• Re: Stored procedures and multiple record set returns
• Re: CHAR or VARCHAR for Key Field?
• Re: Stored procedures and multiple record set returns
• GIF or JPG images in a report
• Re: Get Diagnostics from Stored Procedure
• onstat: Shared memory: permission denied.
• Re: Ontape Level 0 Archive Aborts Itself....
• Re: UNLOAD and backslashes
• Re: Help
• Re: Constraints
• Re: Is it really necessary to mirror the physical log?
• Re: Is it really necessary to mirror the physical log?
• Re: Reading a temp table
• Is it really necessary to mirror the physical log?
• Re: fragmented system tables
• Re: Informix Online - Forms
• Re: Javascript access to SQLCA
• Informix news release in my mailbox
• Re: Update with a correlated subquery - YUCCH
• Update with a correlated subquery - YUCCH
• Re: oninit sessions
• Re: Followup: [?]Menu development tool documentation
• Re: Followup: [?]Menu development tool documentation
• Re: row locking / repeatable read
• Re: row locking / repeatable read
• Re: Dumb question again
• Re: Diverting the target of an ontape?
• Diverting the target of an ontape?
• Follow-up: Newly configured system can't be brought on line
• Newly configured system can't be broght on line
• Re: Deframenting a table too big for ALTER INDEX
• Re: spl function returning row type?
• Deframenting a table too big for ALTER INDEX
• Re: Multiple queries into a single temp table
• well deserved lambaste for changed installation tape formats
• Re: No. of rows selected
• Re: Triggers
• Re: Making Triggers Fire Only After a Commit
• Table failure: sysmaster:informix.arc_file_copy
• Changing data structure forced command termination.
• Re: Restricting ODBC access
• Restricting ODBC access
• Re: How to recover the CHUNK DOWN..?
• Re: What size for LOGSIZE and LOGFILES on OWS 7.22
• Re: course material
• Error 212/130 creating index on a temp table
• Re: HELP!! oninit -i fails ... Help
• Numeric codes for the page types
• Re: help.
• Re: trouble with exclusionary SQL query
• Re: Ontape -s , multiple tapes & cron.
• Re: Informix subqueries
• Re: Ontape -s , multiple tapes & cron.
• Re: Extended checkpoint times
• RUN WITHOUT WAITING blanks screen and forces me to refresh
• Re: Trouble creating stored procedure
• Re: HELP: How to Increase Chunk Size
• Re: number of line in a cursor
• Re: Corrupt indexes on a system catalog
• Re: esql-c update return code
• Corrupt indexes on a system catalog
• Re: informix and oracle
• Pigging out on temp table space?
• Re: Row and Byte locks
• Re: Warning: dbexport can't handle a column named current
• Warning: dbexport can't handle a column named current
• Re: How do I recognize a system catalog table?
• Re: Getting serial value of just inserted record
• Re: Delete Cascade & Delete Triggers
• Re: A very simple SQL question.
• HP-UX 10.x: Where is the bad-block reserve pool kept?
• Re: Changing size of Char field
• Re: How do I recognize a system catalog table?
• How do I recognize a system catalog table?
• Re: self-referential integrity?
• Re: Crontab oncheck script
• Re: How to select first N rows?
• Re: dbimport filling up /tmp?
• Re: SPL Return Value problem
• dbimport filling up /tmp?
• Re: stale dbspace info
• Re: stale dbspace info
• Re: Nearest point problem
• Re: Ontape verification method?
• Re: foreign keys and row types?
• Re: What's the problem with stored procedures
• Re: What's the problem with stored procedures
• Re: FOREIGN KEY IN DIFFERENT DATABASES
• Getting started on Multiple Language apps
• Re: Q: Mirroring - what is the better way
• Re: Duplicate Rows
• Re: DBCENTURY and 4GL
• Re: Priveleges in stored procedure
• DBCENTURY and 4GL
• Re: Interference among instances
• Re: isolation level RR
• Re: Interference among instances
• Re: Cancelling A query
• Re: Return Values from SPL
• Interference among instances
• Conditional exit for SQL
• Re: 4gl opportunity in orange county
• Size of the archive
• Re: Exit status of onstat
• Exit status of onstat
• Re: Boolean complement of a pair of OR clause
• Re: Spam alert for Informix people
• Boolean complement of a pair of OR clause
• Re: Informix knowledge needed
• Re: Help! Error -956: My system doesen't trust itself
• Help! Error -956: My system doesen't trust itself
• Why should I archive now?
• onmonitor: Please install run-time 4GL..??
• Re: Is the selection possible?
• Re: Granting access to rows in a table
• Re: Unix to DOS/Windows Tape
• Re: Shared memory segments hanging around
• Re: Scroll Cursor for Update
• Re: Tables on a particular chunk.
• Re: How to get next serial value
• Re: Q: Assigning names to values returned from SP
• Re: Including 4GL program variable in selection list of SELECT statement?
• Amount of free log space
• Re: how does ODS uniquely id transactions?
• Re: scheduling Informix stored procedures on NT
• Re: Username for this session
• Re: How to bring up an unmirrored chunk?
• Re: Wierd omission in 4ge behaves in P-Code
• Re: Foreach statement
• Wierd omission in 4ge behaves in P-Code
• Shared memory segments hanging around
• Re: SQL queries from shell scripts, and capitalisation
• Re: Case insensitive search
• Re: Retrieving into char variable
• Re: Transaction logging
• Re: Any Way to Defer Triggers?
• Re: Any Way to Defer Triggers?
• Re: Find out database
• Re: INDEXING large tables?
• Re: Array in stored procedure
• Re: Find out database
• Re: Meshing two databases
• dbschema -ss
• Re: Problem with accents
• Re: search on TEXT field
• Re: Referential Integrity across Multiple Databases? Please Help!
• Re: Graphical GUI tool FREE!
• Re: Extents overlap
• Re: Graphical GUI tool FREE!
• Re: INFORMIX WISH LIST
• Re: begin works and commit works in storeprocs
• Re: US- Permanent Employability in Informix
• Re: US- Permanent Employability in Informix
• Followup: SPL to replicate a row with serial key
• Re: SPL to replicate a row with serial key
• SPL to replicate a row with serial key
• Concatenation operator in embedded SQL statements in 4GL
• Re: Chunks Disappeared After Reboot!
• Re: Syntax error? What syntax error??
• Syntax error? What syntax error??
• Re: Force index usage
• Re: Need a 4GL pretty printer with syntax highlightning and other advanced stuff
• Re: qqqqqqqqqqqq
• Pesky informational messages in dbaccess
• Re: cursors question
• Re: Individual database backup/restore
• Re: Creating Views on Multiple Identical Tables
• Re: 4gl Input array question?
• Re: Creating Views on Multiple Identical Tables
• Re: Executing Stored procedures with multiple Result sets
• onlog and dd'ing log tapes
• Re: identiers > 18 characters possible??
• Re: Trigger calling Store Procedure
• Re: Question about regular delete and cascading delete.
• 4GL Help Numbers: Yuchh!
• Bar Codes in a Report
• Re: dbaccess sql output
• Re: Diagnostic & Violations tables
• Re: Where is dbspace?
• Re: Diagnostic & Violations tables
• Re: Uhh...Informix on block device?!
• Re: Subquery variants returning impossible(?) results
• Subquery variants returning impossible(?) results
• Re: Doing a "construct" in SQL rather than 4GL
• Re: Currently logged in users
• Re: get_fldbuf(variable-field-name)
• Re: Informix equivalent of savepoint
• Re: Functions using variables values
• get_fldbuf(variable-field-name)
• Re: Host Variable in dbaccess sql script.
• Flame on low-ball job offers
• Re: Informix 4GL question
• Re: update table
• Re: IF EXISTS SYNTAX
• Re: SPL and transaction question
• Re: Best Tune for Online 5.02
• Re: Are BLOBs logged?
• Re: Setuid execution not allowed
• Re: Delete cascade?
• Locating a blob in memory
• Re: DBACCES-Error 801/845 on Informix 7.20 / HP-UX 10
• Table aliases on a DELETE statement
• Re: Calling a C function for Informix 4gl
• Re: Reports on BAKCGROUND
• Re: reboot
• Re: How to execute shell command and store result to variable?
• Re: NEWERA -- big record, multi-screens?
• Re: dbaccess and vi Weird Behavior
• 4GL Programming tidbit
• Re: Is sqlexit available on R4GL?
• Re: accessing two database one with logging and without
• Re: ? on serial values
• Re: RUN the VI editor from a 4GL program
• Re: 4GL/Engine: FETCH RELATIVE acting flakey
• 4GL/Engine: FETCH RELATIVE acting flakey
• Re: Prob with COUNT in a VIEW
• Answers: 4GL: Turn off cursor name mangling.
• Re: SQL for current database
• Re: Single Database or Multiple Database
• 4GL: Turn off cursor name mangling.
• RUN the VI editor from a 4GL program
• Re: [Q] fragmentation and rowids
• Window name in a variable
• Re: Array subscripts with expressions
• Array subscripts with expressions
• Re: 4GL INPUT statement problem
• tblspace number and rowid
• Re: Problem with a VIEW
• Re: CREATE ROLE
• Source code control & revision numbers
• Re: User privilege
• tblspace number and rowid
• Re: Selecting Locked rows
• Re: BLOB Datatype question ?
• Re: need help with unload problem
• Re: Blobs: How to tell when I retrieved a null blob
• Re: FW: Infromix question - The acursed recursive trigger again!
• Re: Naming Standards
• Blobs: How to tell when I retrieved a null blob
• Re: Need help with INFORMIX SQL problem
• log-begin on new transactions (7.11.UC1)
• Re: How do You know when LL is free
• Re: Primary Key Constraint Question
• Re: Easiest way to get databases for a server from UNIX
• Re: Physical Log Boundedness...
• Re: Should I4GL support new functions like dbinfo(...) ???
• Local variable acting static in 4GL report
• Re: Aliasing column names from a stored procedure - Possible?
• Re: Question on BLOB stored in the table
• Re: Triggers?
• Re: max raw chunk size
• Re: Stored Procedures and clipping strings
• Re: Viewpoint 2.x
• Re: How to 'clear' the full log dbspace?
• Re: using a select.
• Re: Archive sizes
• Re: How do I identify a tables dbspace?
• Re: trigger question
• Re: Two databases, same name, same machine
• Re: DEFAULT value for a DATETIME Column
• Re: open cursor ==> error -255/0
• open cursor ==> error -255/0
• Re: ONCONFIG
• Re: Removing a DBSpace
• Re: Manipulating strings in SQL, SPL
• Re: ONCONFIG
• Re: Table io rate
• Re: Exclusion list in a query-by-example
• Re: Exclusion list in a query-by-example
• Re: Converting ESQL/C code from Informix 5.05 to 7.1X; question
• Exclusion list in a query-by-example
• Re: Informix sqlca and Delphi
• Re: Numer of rows in a cursor
• Re: SQL Question
• Re: Informix Debugger and Interrupt Key.
• Re: multi-valued field?
• Re: Variables in SP
• Re: How to do it in SQL
• Re: HELP! My Page Cleaners keep dying!!!
• Re: PB app, locking in Informix 5
• Re: Can't Remove Update Lock
• Re: Informix 7.13 on HP 10.01
• Re: Printing TOP OF PAGE character
• Re: 4GL err -257: System limit on maximum number of statements exceeded
• Re: Is this stack trace normal?
• Re: Index Read Errors
• Re: calling stored procedures
• Re: Triggers using stored procedures
• Re: PIVOT tables
• Re: EXECUTE ... SELECT COUNT(*) ... INTO ?
• Re: case insensitive order by
• Re: Another bug of IPLOAD !
• Re: EXECUTE ... SELECT COUNT(*) ... INTO ?
• Re: IPLOAD KABOUM
• Re: Stored procedures
• Re: SPL & Triggers - do's and don'ts
• Re: Informix 7.12: Stored Procs vs Roles
• Re: Can you have arrays in SPL
• Re: 4GL compile on uniprocessor/multiprocessor systems
• Re: SPL & Triggers - do's and don'ts
• Re: Inserting NULL values into a column of type TEXT?
• Re: How to use LBU_PRESERVE
• Re: Divide by zero
• Re: Log files to disk
• Re: ESQL/C and error msgs
• Re: Exception Report
• Re: database engine
• Re: Help with Ace Report