Looking into IBM Informix
As posted previously we're researching a storage intensive relational database project at the office. I talked with the DB2 guys at IBM today and they asked me to look into Informix instead of DB2 since Informix has a BLOB (Binary Large OBject) support superior to DB2. In additional the fragment support for tables sounds like it's something we could use to help "partition" the tables in date segments.
Anyone who has some "getting started" information for Informix? I figured the "dbaccess" command out but it would be nice with a tutorial or similar to get started.
The small differences between Notes and COM sometimes matters
Had an example of this today when porting some LotusScript in Notes to VBA using COM to access Notes. In Notes the GetAllDocmentsByKey function of the NotesView class can take an array of parameters, the array being of any datatype (String, Integer etc.). It turns out that this isn't the case for COM access where the array must be a Variant array as shown below. If you supply a String array you'll get an error at runtime.
// declarations
Dim session NotesSession
Dim db As NotesDatabase
Dim view As NotesView
Dim dc As NotesDocumentCollection
Dim v(1) As Variant
// get session, database, views etc.
Set db = session.GetDatabase("server", "path")
Set view = db.GetView("someview")
...
...
// populate key array
v(0) = "key1"
v(1) = "key2"
// get by key
Set dc = view.GetAllDocumentsByKey(v, True)
Msgbox dc.Count
Being fair the difference is noted in the Designer help database.