tisdag 23 augusti 2011

Call DB2 Stored procedure from Command Editor

Open Command Editor:
Start-> All Programs -> IBM DB2 -> DB2Copy1 (Default) -> Command Line Tools -> Command Editor

Enter call stored procedure:
CALL YITIRAA.A747HI01_DISPATCH_LOT_LIST (BEGHN0040, ' ' ,' ', 20, ' ', ' ', ' ', ' ', ' ', ' ', ' ',
V074305, LOC, '2011-08-23 00:00', '2011-08-23 00:00', ?, ?, ?, ?);

So:
- No single quotes around strings
- Single quetes around blanks
- Single quetes around dates
- Questionmarks for output parameters

tisdag 2 augusti 2011

Search on google on specific site

To search on Google on specific site, use site:+url, ie:
site:ad-thomas.blogspot.com Excel

måndag 1 augusti 2011

Visual studio: Display current file in solution explorer

To display the current opened file in solution explorer in Visual Studio:
* Select Tools->options
* Select Projects ans Soulutions
* Check row: Track Active Item in Solution Explorer