1. Rollback all data on import from a table if a row is corrupted. You have a list of sql queries as a parameter:
Read the rest of this entry »
Posts Tagged SQL
SQL Transactions in Java
Jun 11
PostgreSQL recently added several great new features like Common Table Expressions (CTE), Recursive CTEs, Windowing Functions (my favorite) and Parallel restoring of dumps. The goal of this article is to provide an overview of the new PostgreSQL Windowing Functions. Previously limited to enterprise databases such as Oracle and DB2, they open up a completely new world of functionality to SQL queries.
Read the rest of this entry »
SQL statements can be embedded directly into PowerScript code, allowing you to include PowerScript variables in any area of the statement ,whereas you can’t include them if using PowerBuilder Database painter.
To work with variables, the SELECT statement accept the INTO clause, that enable assignment of the result to existent variables.
For example:
SELECT COUNT(*) INTO :il_bools
FROM books;
Concurrency
Several clients sharing a resource
Contention
Multiple users try to access a resource at the same time resulting in waits or event deadlocks.
Deadlocks
A deadlock occurs when two or more transactions are both in a wait state, with each one waiting for the other to release a lock before it proceeds.
Read the rest of this entry »
