Re: VARCHAR2 storage on a page

"Pablo Sanchez" <pablo_at_dev.null> wrote in message news:kUaC8.232$pa4.44177_at_news.uswest.net...
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in
> message news:3cd8e597$0$236$ed9e5944_at_reading.news.pipex.net...
> >
> > I can't speak for Informix but the example I use when talking about
> porting
> > code between platforms consists of porting the following Oracle code
> to
> > MSSQL.
>
> Recall that the original poster stated that they are a DBA, they
> weren't porting code. So I'd like to know what assumptions an
> Informix DBA might make which would cause the dire warnings that were
> posted.

ah.missed that. RTFP seems like an appropriate memo to self.

>
> > update emp set sal = sal * 1.05;
> > insert into emp_audit(change_date,change_desc) values
> (sysdate,'Annual
> > Salary increase all staff 5%');
> > commit;
> >
> > which is fairly self explanatory.
> >
> > In MSSQL if , for example, the insert fails then the update will be
> made
> > without having being logged.
>
> What do you mean without being logged? As in the actual transaction
> log? (which I don't believe you mean).

what I mean is without the audit table (emp_audit) being updated.

the statements are a transaction in Oracle but not in MSSQL.

>
> > I don't think that it is unreasonable to assume that the above will
> be
> > processed the same in different databases, but it won't be.
>
> Possibly but I think some projecting is happening here ... <g>

well possibly <g>.

--
Niall Litchfield
Oracle DBA
Audit Commission UK