Command Abbreviations–Verbs ADD – Add CFG – Configure CHG – Change CPY – Copy CRT – Create DLT – Delete DSP – Display GO – Go to a Menu RMV…
Tag: 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…
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…
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,…
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;” + “Pwd=Secret;”; conn.Open(); // ODBC — Trusted Connection using System.Data.Odbc; OdbcConnection conn…
How to Check your browser supports IndexedDB or not .
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…
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…
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…