Weekly Round-Up: 7/21/13 to 7/27/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Wed 7/24
jlcollinsnh – Stocks — Part IV: The Big Ugly Event, Deflation and a bit on Inflation – http://markjacobsen.net/l/1828

Thu 7/25
jlcollinsnh – Stocks — Part V: Keeping it simple, considerations and tools – http://markjacobsen.net/l/1829

Fri 7/26
jlcollinsnh – Stocks — Part VI: Portfolio ideas to build and keep your wealth – http://markjacobsen.net/l/1830

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Weekly Round-Up: 7/14/13 to 7/20/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Mon 7/15
MMM @mrmoneymustache on: Getting Rich: from Zero to Hero in One Blog Post – http://mjg2.net/l/1823

Tue 7/16
Craig Jarrow @TMNinja says: Beware: 10 Time Management Rules That You Are Breaking – http://mjg2.net/l/1824

Wed 7/17
jlcollinsnh – Stocks — Part 1: There’s a major market crash coming!!!! and Dr. Lo can’t save you. – http://mjg2.net/l/1825

Thu 7/18
jlcollinsnh – Stocks — Part II: The Market Always Goes Up – http://mjg2.net/l/1826

Fri 7/19
jlcollinsnh – Stocks — Part III: Most people lose money in the market. – http://mjg2.net/l/1827

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

DB2 Incremental Delete

Ever have to delete a lot of records from a table in DB2 and can’t truncate, but you keep filling the transaction log? One way of solving the problem without having to manually update ranges of values in a where clause is to do an incremental delete in a stored proc. Here’s an example/template to get you started…


WHILE EXISTS (  SELECT  ITEM_ID 
		FROM    XX.TABLE
		WHERE   SOMETHING_NB = 1
		FETCH FIRST 1 ROWS ONLY )
DO
	DELETE FROM 
		(SELECT ROW_NUMBER() OVER() AS ROW_NB
		FROM    XX.TABLE
		WHERE   SOMETHING_NB = 1
		FETCH FIRST 20000 ROWS ONLY)
	WHERE ROW_NB <= 20000;
	
	IF ((L_SQLCODE_NB <> 0) AND (L_SQLCODE_NB <> 100)) THEN
		SIGNAL SQLSTATE '20003' SET MESSAGE_TEXT = 'Error deleting records';
	END IF; 
	
	COMMIT;
END WHILE;
Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Weekly Round-Up: 7/7/13 to 7/13/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Mon 7/8
Eric Jackson on: The Ten Biggest Lies of B-School – http://mjg2.net/l/1819

Tue 7/9
Scott Hanselman @shanselman asks: Programming’s not for you? How about thinking? Be empowered. – http://mjg2.net/l/1820

Wed 7/10
Adam Dachis @adachis on: How to Quickly Find and Replace Text Across Multiple Files with One Command – http://mjg2.net/l/1821

Fri 7/12
Leo Babauta @zen_habits tells you how to: Create the Habits of Being Lean, in 7 Years – http://mjg2.net/l/1822

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Weekly Round-Up: 6/30/13 to 7/6/13

The Weekly Round-Up is a once weekly collection of my #1Aday daily shares. Hope you find something of interest!

Mon 7/1
Joshua Becker @joshua_becker on: 10 Unconventional Habits to Live Distraction-Less – http://mjg2.net/l/1815

Tue 7/2
MMM @mrmoneymustache on: Getting Enough.. and Then Some – http://mjg2.net/l/1816

Wed 7/3
Shelly Phillips on: Six Communication Tricks That Will Get Your Kids to Cooperate – http://mjg2.net/l/1817

Fri 7/5
Melanie Pinola asks: How Can I Keep My Family from Disturbing Me When I Work at Home? – http://mjg2.net/l/1818

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Happy birthday America

As I sit here watching “The Patriot” I can’t help but be appreciative of all those who have sacrificed for the dream and reality that is America. Those who gave the ultimate sacrifice and those who left their families – if even for a short time – in service of a cause they considered greater than themselves.

In salute of all the Patriots: Abe Lincoln, Alexander Hamilton, George Washington, John Adams, Sam Adams, Ben Franklin, Teddy Roosevelt, George Patton, General Sherman, General Grant, FDR, those who will never be known (the unknown soldiers), and many many more I am ever grateful to have been born in this wonderful Land of Opportunity.

As a parent, I haven’t the luxury of principles. I have long feared that my sins will come back to haunt me – and the weight is more than I can bare.

Thank you again to all who have sacrificed so that we may pursue happiness.

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...

Resolving Ant javac “class file has wrong version” issues

Ever run an ANT build in eclipse and it works just fine, but as soon as you run it outside of eclipse you get something like…

class file has wrong version 51.0, should be 49.0

The issue is likely that you need to “fork” in your javac task…

Before (with error)

javac srcdir="${build.path}" 
   verbose="true" 
   includeantruntime="false" 
   includejavaruntime="false"

After (no error)

javac srcdir="${build.path}" 
   verbose="true" 
   includeantruntime="false" 
   includejavaruntime="false" 
   fork="yes"

Hopefully this can save you about 2 hours some day!

Please remember to subscribe to the newsletter to stay up to date!

You or someone you know looking to buy or sell?
Disclaimer: Thoughts and opinions are my own, and do not reflect the views of any employer, family member, friend, or anyone else. Some links may be affiliate links, but I don't link to anything I don't use myself. You would think this should be self evident these days, but apparently not...