All posts by Mark Jacobsen

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

07/24/2013 Mark Jacobsen Leave a comment

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

DB2 Incremental Delete

07/15/2013 Mark Jacobsen Leave a comment

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?

Weekly Round-Up

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

07/14/2013 Mark Jacobsen Leave a comment

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?

Weekly Round-Up

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

07/07/2013 Mark Jacobsen Leave a comment

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?

Misc / Random

Happy birthday America

07/04/2013 Mark Jacobsen Leave a comment

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?

Java

Resolving Ant javac “class file has wrong version” issues

07/03/2013 Mark Jacobsen Leave a comment

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?

Weekly Round-Up

Weekly Round-Up: 6/23/13 to 6/29/13

06/30/2013 Mark Jacobsen Leave a comment

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

Mon 6/24
The Cost Of FI – http://mjg2.net/l/1811

Tue 6/25
jlcollinsnh on: My path for my kid — the first 10 years – http://mjg2.net/l/1812

Wed 6/26
Martin Luther King Jr’s: Letter from a Birmingham Jail – http://mjg2.net/l/1813

Thu 6/27
jlcollinsnh – Why your house is a terrible investment – http://mjg2.net/l/1842

Fri 6/28
Adam Dachis tells you how to: Generate a Monthly Calendar from the Command Line – http://mjg2.net/l/1814

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

You or someone you know looking to buy or sell?

Weekly Round-Up

Weekly Round-Up: 6/16/13 to 6/22/13

06/23/2013 Mark Jacobsen Leave a comment

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

Mon 6/17
Nora Dunn @hobonora suggests you: Spice Up the Conversation by Skipping “What Do You Do?” – http://markjacobsen.net/l/1805

Tue 6/18
Supercharge Your Command Line’s History Search with Four Lines of Code – http://markjacobsen.net/l/1807

Wed 6/19
Am I Brushing My Teeth Correctly? – http://markjacobsen.net/l/1808

Thu 6/20
Leverage Email to Get a Response When Your Prospect Has Gone Dark – http://markjacobsen.net/l/1809

Fri 6/21
David @DavidDCain on: Why the minimalists do what they do – http://markjacobsen.net/l/1810

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

You or someone you know looking to buy or sell?

Weekly Round-Up

Weekly Round-Up: 6/9/13 to 6/15/13

06/16/2013 Mark Jacobsen Leave a comment

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

Wed 6/12
David Cain @DavidDCain on: How to Walk Across a Parking Lot – http://markjacobsen.net/l/1806

Thu 6/13
Mr. Money Mustache @mrmoneymustache on: The Principle of Constant Optimization – http://markjacobsen.net/l/1802

Fri 6/14
Christopher S. Penn @cspenn gives you: The graduation lesson I wish I’d had – http://markjacobsen.net/l/1803

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

You or someone you know looking to buy or sell?

Challenges

The One a Day Challenge

06/10/2013 Mark Jacobsen Leave a comment

For those of you who follow me on the social media platform of your choice I’m not referring to my (attempted) daily post of something interesting. Instead this is a little challenge I dreamed up and considered a while back, but finally decided to do the month of June. Being the type who likes confirmation before proceeding, I’ve been following the challenge with great success since the beginning of the month so now feel comfortable talking about it.

So you’re probably asking by now, what is it? Simply put, pick something (or in my case 3 somethings) that you want to limit to 1 or less a day. The 3 that I picked are…

1) No more than 1 cup of coffee a day
2) No more than 1 alcoholic beverage a day
3) Spend less than $1 a day directly on myself (primarily eliminates “fancy coffee” and numerous non-brown bag lunches)

Why do I do these things? Primarily to keep myself sharp and to help build willpower. Plus, I like a challenge of my own choosing.

So what about you? Have something you’d like to challenge yourself to limit to 1 or less a day? Tell me about it in the comments below.

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

You or someone you know looking to buy or sell?