Recent content by meker

Bins, You are wondering into dangerous waters when talking about doing distributed transactions. It is hard to handle/control failures on the other side (db2 in your example). Locked records will cause nightmares. If a failure occurs, how you recover and how you identify which transactions...

Not sure why it took so long for someone to say: Yes. SQL Loader will do the number conversion and the (?) value in a number declaration is its character length, regardless of neg/pos. That said, ensure you are using a delimited file or you account for the 8 characters within the control file...

From Bill Gates: "You can specify an external data source by using Microsoft Query. Microsoft Query is an optional feature for Microsoft Excel. If you chose the Typical installation option during Setup, Microsoft Query is not installed on your computer." If you go this route, search...

Hi, I work at a manufacturing company that has made its bread and butter using telnet sessions and character based forms. We are now faced with having to upgrade to Forms 6i, but we are not sure whether that's the best choice. We have over 100 forms running on three Unix servers with hundreds...

Raider2001, I thought about a longer version of this, but then I ran into the problem of processing a Sunday record after a Monday record. When a connectivity problem arises, I typically receive only two, maybe three files. They are always consecutive days. This file naming convention I've...

Hi, I receive data files that have a three letter abreviation for the day of the week appended to the end of the file name (example DATA_Mon, DATA_Tue, etc). Each file represents all of the data collected for that day, and must be processed in chronological order. Sometimes I get several of...

Thanks, Apparently I need to learn how to navigate metalink better.

Hi, My DBA's tell me that in the next couple of months we will be upgrading from Oracle 8.0.5 to Oracle 8.1.7. I've seen some neat features that will be available in the upgrade (ex: in-line queries) in various forums, but I cannot seem to lay my hands on a comprehensive list of the features...