Tutorial by Examples: i

CREATE DATABASE SAMPLEDB; This will create a new database called sampledb.

CONNECT TO SAMPLEDB; From the command line (db2clp, terminal, db2cmd) you can write: db2 CONNECT TO SAMPLEDB

The following statement will create a new table called employee: CREATE TABLE EMPLOYEE ( EMPNO CHAR(6) NOT NULL, FIRSTNME VARCHAR(12) NOT NULL, LASTNAME VARCHAR(15) NOT NULL, SALARY DECIMAL(9,2) , PRIMARY KEY (EMPNO) ...

Let's suppose we are going to insert rows in the previously created table. We can explicitly name the columns we are going to out values is and its order: INSERT INTO EMPLOYEE (EMPNO, FIRSTNME, LASTNAME, SALARY) VALUES ( '123456', 'Ali', 'Veli', 100000); If we know the order and we are going...

By using server.close() and process.exit(), we can catch the server exception and do a graceful shutdown. var http = require('http'); var server = http.createServer(function (req, res) { setTimeout(function () { //simulate a long request res.writeHead(200, {'Content-Type': 'text/plain'})...

SQLite.NET is an open source library which makes it possible to add local-databases support using SQLite version 3 in a Xamarin.Forms project. The steps below demonstrate how to include this component in a Xamarin.Forms Shared Project: Download the latest version of the SQLite.cs class and add...

You will need a development device Go to your Apple Developer Account and create a provisioning profile with Push Notifications enabled You will need some sort of way to notify your phone (AWS, Azure..etc) We will use AWS here public override bool FinishedLaunching(UIApplication app, NSDictio...

If you have a directory with existing source files, you can use qmake with the -project-option to create a project file. Let's assume, the folder MyProgram contains the following files: main.cpp foo.h foo.cpp bar.h bar.cpp subdir/foobar.h subdir/foobar.cpp Then by calling qmake -projec...

Scala offers implicit conversions between all the major collection types in the JavaConverters object. The following type conversions are bidirectional. Scala TypeJava TypeIteratorjava.util.IteratorIteratorjava.util.EnumerationIteratorjava.util.IterableIteratorjava.util.Collectionmutable.Bufferjav...

>>> df = pd.DataFrame({'Name':['John Smith', 'Mary Brown'], 'Gender':['M', 'F'], 'Smoker':['Y', 'N']}) >>> print(df) Gender Name Smoker 0 M John Smith Y 1 F Mary Brown N >>> df_with_dummies = pd.get_dummies(df, ...

SELECT val FROM (SELECT val, rownum AS rnum FROM (SELECT val FROM rownum_order_test ORDER BY val) WHERE rownum <= :upper_limit) WHERE rnum >= :lower_limit ; this way we can paginate the table data , just like web serch page

Before creating any extension, always check if it has already been implemented. The first thing one would have to do is define the extension class which will house the twig filters and/or functions. <?php namespace AppBundle\Twig; class DemoExtension extends \Twig_Extension { /** ...

as written in [MDN][1] at July 2016: This feature is not implemented in any browsers natively at this time. It is implemented in many transpilers, such as the Traceur Compiler, Babel or Rollup. So here is example with Typescript loader for Webpack: //TODO Create simplified version of this ar...

Do not use registry:latest! This image points to the old v1 registry. That Python project is no longer being developed. The new v2 registry is written in Go and is actively maintained. When people refer to a "private registry" they are referring to the v2 registry, not the v1 registry! do...

Configuring a private registry to use an AWS S3 backend is easy. The registry can do this automatically with the right configuration. Here is an example of what should be in your config.yml file: storage: s3: accesskey: AKAAAAAACCCCCCCBBBDA secretkey: rn9rjnNuX44iK+26qpM4cDEo...

IISNode allows Node.js Web Apps to be hosted on IIS 7/8 just like a .NET application would. Of course, you can self host your node.exe process on Windows but why do that when you can just run your app in IIS. IISNode will handle scaling over multiple cores, process manageement of node.exe, and auto...

To get this example working, you'll need to create an IIS 7/8 app on your IIS host and add the directory containing the Node.js Web App as the Physical Directory. Ensure that your Application/Application Pool Identity can access the Node.js install. This example uses the Node.js 64-bit installation....

Using a Virtual Directory or Nested Application in IIS is a common scenario and most likely one that you'll want to take advantage of when using IISNode. IISNode doesn't provide direct support for Virtual Directories or Nested Applications via configuration so to achieve this we'll need to take adv...

To get Socket.io working with IISNode, the only changes necessary when not using a Virtual Directory/Nested Application are within the Web.config. Since Socket.io sends requests starting with /socket.io, IISNode needs to communicate to IIS that these should also be handled IISNode and aren't just s...

Simulation environments A simulation environment for a VHDL design (the Design Under Test or DUT) is another VHDL design that, at a minimum: Declares signals corresponding to the input and output ports of the DUT. Instantiates the DUT and connects its ports to the declared signals. Instant...