SQLite3 database connection functions and commands !
database connection 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 a database, the default string encoding…
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 entire transaction. Unlike transactions, you can have more…
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 by the keyword NULL. 2)Integer – size is 8 bytes. range…
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 recoverable)…
How to create SQLite mac Terminal?
SQLite 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 you want save your database file. i choose…
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 a serverless does not…
Basic AS/400 command abbreviations
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 – Remove STR…
Creating a Data File in AS400
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 of length 100 that is named FTPOUT. To…
How to Create an iSeries Database File
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…
Tips for Database Normalization
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 into tabular…