Database, IOS

What is Save-Points in SQLite !!!

SQLite also support save-point. Savepoints allow you to mark specific points in the transaction. You can then accept or rollback to individual save-points without having to commit or rollback an…

Database, IOS

Datatype supports in Sqlite !!!

SQLite support only five concrete datatypes.i.e NULL,Integer,Float,Text,BLOB. 1) NULL – A NULL is considered its own distinct type. A NULL type does not hold a value. Literal NULLs are represented…

Database, IOS

What are the SQLite standerd return codes.

SQLITE_OK Operation successful SQLITE_ERROR Generic error SQLITE_INTERNAL Internal SQLite library error SQLITE_PERM Access permission denied SQLITE_ABORT User code or SQL requested an abort SQLITE_BUSY A database file is locked (usually…

Database

What is SQLite.?

SQLite is a public-domain software package that provides RDBMS(Relational Database Management System) Relational database systems are used to store user-defined records in large tables. Features of SQLite. Serverless. SQLite is…

Database

Creating a Data File in AS400

To create a file named FTPOUT that is 100 characters in length: CRTPF FILE(MYLIB/FTPOUT) RCDLEN(100) The AS/400 actually creates a file named FTPOUT, a member named FTPOUT and a field…

Database

How to Create an iSeries Database File

Procedure Launch a BlueZone iSeries Display session. From the BlueZone MenuBar, choose Transfer:Send/Receive. The BlueZone Host File Transfer desktop user interface will launch. From the Host File Transfer MenuBar choose…

Database

Tips for Database Normalization

Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirable characteristics like Insertion, Update and Deletion Anamolies. It is a two step process that puts data…