sqlite3_open() – will result in a database with the default UTF-8 encoding. sqlite3_open_v2() – will result in a database with the default UTF-8 encoding. sqlite3_open_16() – is used to create…
Category: Database
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…
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…
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…
How to create SQLite3 database using mac Terminal.?
1. Using spolight(press the cmd+space) search the terminal, Terminal its a default editor avilable in mac. or in the Menu go on Application -> Terminal. 2.First select the location where…
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…
Basic AS/400 command abbreviations
Command Abbreviations–Verbs ADD – Add CFG – Configure CHG – Change CPY – Copy CRT – Create DLT – Delete DSP – Display GO – Go to a Menu RMV…
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…
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…
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…