Re: Informix questions

Sankaran said: > > Hi, > > Can you please help me out with the following queries. > > 1) Do Smartblobspaces exist in IDS 7.31? (From my little investigation, > I believe it exists). No. > 2) If so, then how do we check if a dbspace is smart blobspace or not? > (IDS 9.x has is_sbspace column in sysdbspaces) See above. > 3) Also, I would like to know the steps to create a sbspace. "onspaces --" will tell you -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule" - Coluche did i mention i like nulls? heck, i even go so far as to say that all columns in a table except the primary key could/should be nullable. this has certain advantages, for example, if you need to insert a child record and you don't have a parent row for it, just do an insert into the parent table with the primary key value (everything else null), and voila, relational integrity is preserved. but this is, admittedly, a bit controversial among modellers. --r937, dbforums.com sending to informix-list