Re: Couple of problems...

} > Status: R } > } > Hello, } > } > I have two problems not related to each other. } > } > (1) I am using Informix ODS 7.10 and want to extract data onto ASCII files } > after left-padding and right-padding certain fields so that the load files } > working on these files could pick up specific number of characters. } > The ASCII files would be used as load files for an Oracle datawarehouse. } > Is there a character padding function available in Informix I-SQL ? I am } > using unload for the dumping right now. } > } > (2) Another application that I am dealing with is on Informix 5.* There is a } > certain table that is to be updated. However, if the update process } > affects more than 1 row, it is to be rolled back, and if it is affects } > only 1 row, it is to be commited. ( The checking is done through sqlca. } > errd) But when , in dbaccess, I try the update, then try to roll it back, } > it does not happen. The update is commited implicitly as soon as it is } > given. I read sometime back Jonathan Leffler's mail about implicit } > commits, but is there a way to prevent this, and ensure the update does } > not go through if a rollback is issued ? I tried the excercise in Buffered } > as well as Unlogged mode logging of the database. } > } > Hoping to get some help on these two matters. } > Thanks in advance, } > } > Vinitha Bhat } > } > } } --- End Included Message ------------------------------------------------------ }