Basic DB2 commands - I

We use the IBM DB2 Control Center for a variety of reasons, mostly to look at data through some simple SQL queries.

Control Center has a number of neat commands that can help save time. It should be noted however, that the reasons for using these commands should NOT be intended to replace ETL workflows which can be scheduled on a regular basis to do the necessary updates.

Consult the DB2 manual for more commands or other examples.

CREATE

To create a table:

CREATE TABLE > like <> in <> INDEX IN <>;

INSERT

If you want to insert records into a table from another table:

INSERT INTO <> SELECT * FROM <> WHERE <>;


DELETE

To delete records from a table:

DELETE FROM <> WHERE <>;

Free Wi-Fi in Toronto

Ever wonder where to get free Wi-fi in Toronto? Want to offer your W-fi to the masses. Check out Wireless Toronto for some hot spots near you? It tells you what you need to get up and running as well.

http://wirelesstoronto.ca/index.php

What if you wanna go out for a bite and still be able to surf the Interweb? Working on something and you just have to have that connectivity to the rest of the world while grabbing a coffee?

Toronto diners now have a number of free wi-fi spots where they can nosh and surf at the same time. Toronto.com has a list of some such places. It's not comprehensive but it's a good place to start. Thanks you Ari Linds for this link.

http://www.toronto.com/restaurants/article/638225

Getting the most out of your Informatica PowerCenter 8 Environment

We use PowerCenter a lot here as our ETL tool. We're always looking for ways to improve our workflows so that they are more efficient and save time.

Maarten Vanleenhove has written some useful tips and tricks to help improve the performance of workflows in Informatica. Check out the link.

Getting the most out of your Informatica PowerCenter 8 Environment

Thanks Christine for finding this!


Shared via AddThis