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…
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…
Tips for SQL Query Optimization
Tips for SQL Query Optimization The sql query becomes faster if you use the actual columns names in SELECT statement instead of than ‘*’. For Example: Write the query as SELECT id, first_name, last_name, age, subject FROM student_details;…
Tips for Database ConnectionStrings of Various Provider
Tips for Database ConnectionStrings of Various Provider Microsoft SQL Server // ODBC DSN using System.Data.Odbc; OdbcConnection conn = new OdbcConnection(); conn.ConnectionString = “Dsn=DsnName;” + “Uid=UserName;” +…
How to Check your browser supports IndexedDB or not
Browser supports IndexedDB The very first thing we should do is check for IndexedDB support. While there are tools out there that provide generic ways to check for browser features, we can make this much simpler since we’re just checking for one…
What is IndexedDB in HTML5 ?
IndexedDB provides a way for you to store large amounts of data on your user’s browser. Any application that needs to send a lot of data over the wire could greatly benefit from being able to store that data on the client instead. Of course storage is…
Creating Simple Event with MySQL
Creating a First Event Creating an Event is somewhat like creating stored procedure or user defined function in MySQL. You will have DELIMITER, BEGIN, DO and END keywords. As mentioned earlier we can define the execution time for the event while creating…