Saturday, June 30, 2007

What's new in RPGIV in V5R4? by Bob Cozzi

What's new in RPGIV in V5R4 by Bob Cozzi

Bob has put together a short video walkthrough of what's new in V5R3/R4 for RPGIV. It's fairly high level but there are some points of depth here.

Most highlighted are the new BIF codes available, and another long section is devoted to the XML parsing.

My favorite is EVAL-CORR.

The video run time is under 15 minutes. It is hosted at i5 TV.


Friday, June 29, 2007

Flickr Photos Integrated into Yahoo Image Search

Thomas Hawk's Digital Connection: Flickr Photos Integrated into Yahoo Image Search

Thomas Hawk, CEO of Zummr, writes insightfully about Yahoo's integration of Flickr for searches. Thomas' take is frank and unbiased. In the comments, he mentions how to opt out for this type of search, however, Thomas does think the search will bring good attention to photographers.

My personal take is in line with Thomas'. I'd love to have someone be able to find my better pictures. Also knowing that they can be searched outside of Flickr, I'll probably try to add more tags to my photos.

Please click through and let Thomas know what you think.

Nods to Thomas,

Thursday, June 28, 2007

RPGIV RPGLE and FREE what do you want to see?

Programming on the System i? Working in RPGIV/RPGLE? Doing some experimentation with /FREE? Then tell me what I can write about to help you out?

Need some SETLL examples? How about left and right adjusting within a field? Want some help working through using some BIF commands to replace legacy code?

Let me know and I'll do my best to tackle it here on the blog. If I can't do come up with the answer on my own, I'll steer you to some other resources on the web or in a book.

So comment here and let me know. Or if you are a bit shy of blog commenting, how about contacting me directly here.

Your humble and fellow programmer,

Simon's Ephemera: Sierra Club Online

Simon's Ephemera: Sierra Club Online

Read this rant, enjoy a laugh, and decide if you are mature or infantile. :)

Most fun find today!


Embedded SQL in RPG on the AS/400

Today's post is a quick introduction to using SQL embedded within an RPGIV or RPGLE program.

The example SQL:
Select PEPSN from F5542330 where PEDOCO = 1148919 and
PELNID = 1000

Note: The RPG member type must be SQLRPGLE in both cases.
Note: The user of a colon before a variable indicates it is otherwise declared within the program.
Note: The compiler optimizes nondynamic SQL statements in an SQL precompiler.

in C specs

C+ Select PEPSN into :PEPSN from F5542330
C+ Where PEDOCO = 1148919 and
C+ PELNID = 1000

in /FREE specs

Exec SQL Select PEPSN into :PEPSN from F5542330
Where PEDOCO = 1148919 and PELNID = 1000;

In either case, a dynamic SQL statement can be run by creating an SQL statement within the program.

in C specs
C+ Declare Lines Cursor for
C+ Select PEPSN from F5542330
C+ Where PEDOCO = 1148919

C+ Open Lines

C+ Fetch next from Lines for 100 rows into :PSNS

C+ Close Lines

in /FREE specs
Exec SQL Declare Lines Cursor for
Select PEPSN from F5542330 Where PEDOCO =1148919

Exec SQL Open Lines

Exec SQL Fetch next from Lines
for 100 rows into :PSNS

Exec SQL Close Lines

As you can see, the total amount of lines is slightly smaller for using /FREE. The biggest benefits are the requirement to close the EXEC SQL, and that no C specs would be required, breaking up the rest of the /FREE code.

SQL is not always the right solution, but being able to make use of it adds a significant tool to your arsenal.

tojosan - at -

Tuesday, June 26, 2007

iPhone vs N95 - parody

If nothing else, this video makes its point. Enjoy.

Thank you Robert Scoble for pointing this out.

Sunday, June 24, 2007

Mike Jorgensen's Web Log: iPhone is a polarizing design

Take a moment and read an interesting take on the iPhone and how has folks taking sides.

Mike Jorgensen's Web Log: iPhone is a polarizing design

Saturday, June 23, 2007

Blogging Tip #47



Love lists? Love lists of 5 things? Love Merlin Mann?

Go to 5ives.

A Dog's Breakfast

David Hewlett, to most of us Rodney McKay on Stargate Atlantis, comes to us with his own feature film. A dark comedy, and as David is quoted as saying, "A murder the whole family can enjoy."

From the website:
"If you've never been good at anything in your life, why would murder be any different? Patrick has always had a somewhat combative relationship with his little sister Marilyn. But when she brings home her new sci-fi-soap star fiancĂ© Ryan, it's all out war. When Patrick fails to drive a wedge between the happy couple, he reaches for sharper instruments. Every family has a few skeletons in the closet; A Dog’s Breakfast is the nightmarishly funny mess Patrick makes when he tries to add another to his.

A Dog's Breakfast is a head smacking, bone breaking, fiancé bashing romp, with a family that just loves themselves to pieces."

David's site host some clips from the movie, a sidebar to monitor him on Twitter and a way for fans to sign up and comment.

I got a big laugh just watching the clips, and I'm sure I'll purchase this when it comes out.


Thursday, June 21, 2007

Killer video search engine (ClipBlast) � Scobleizer

Not yet on TechCrunch: killer video search engine (ClipBlast) @ Scobleizer

Robert Scoble shares the scoop with us about the killer video search engine, Clipblast.

To quote him:

Anyway, here’s the highlights.

1. Their engine has been spidering the video world for 3.5 years.
2. Three million professionally-done video clips with five million additional of user generated clips.
3. The current interface on Clipblast went live in April.

Robert had the chance to chat one on one with the CEO of Clipblast, Gary Baker. Mr. Baker shared some history and the company's strengths but my favorite quote is this.

“Our ultimate goal is to get viewers and more views to the video.”

All said, I'm going to give it a try. Maybe it'll find my one and only video! The site itself looks like this.

ClipBlast Video Search Engine

Please check them out at, and show them some love by blogging about them and sharing the link with your friends.


Tuesday, June 19, 2007

43f Feature: Michael Buffington’s “How I use iGTD”

43f Feature: Michael Buffington’s “How I use iGTD” | 43 Folders

"With Quicksilver and iGTD I get the task out of head and into a place I trust, and because it took mere seconds to record I’m right back in flow, realizing that if I’m wanting to do multiple inheritance in Ruby I’ve probably designed something incorrectly in the first place."

Michael Buffington, via a guest post at 43Folders, introduces us to using Quicksilver to getting tasks into iGTD. Following his article, I was able to download, iGTD, install it, and add as task via Quicksilver in just minutes.

Quicksilver is a Mac application that captures keyboard sequences to trigger or communicate with applications.


"You are a busy person, aren't you? And there's an easy way to track all things that have to be done... and to get those things done! iGTD takes some concepts from Getting Things Done methodology and makes them easy to understand and use in your every day life. But it's definitely not limited to the GTD concept - you can really use it the way you want."

Mac user? Into GTD? Then give this combination a spin. Thanks again 43Folders and Michael Buffington.


Saturday, June 16, 2007

DOPPLR - Invites to give out

I have nine (9) DOPPLR invites to give out. Leave a comment and an email to reach you at. First nine folks that contact me get one.


Wednesday, June 13, 2007

RPGLE FREE - SETLL use without indicators

RPGIV and with /FREE has some good support for SETLL with its indicator replacements, %FOUND and %EQUAL.

Use it like this.

SETLL (KeyField1: KeyField2) myFileFormat;
If %Equal;
Dsply "Hey I found a match!";

The above IF/EndIf only executes if SETLL finds an exact matching record. This can be used to avoid entering a DO/READ loop if no match is found. This flag can be on in addition to %Found;

SETLL (KeyField1: KeyField2) myFileFormat;
If %Found;
Dsply "Hey, at least 1 record.";

In this case %Found will be on if there is at least one record to read. %Found will always be on if %Equal is on.

I recommend the use of SETLL if you want to check for the presence of a specific record with a key. There is less overhead if %Equal is true because no record is read in.


Tuesday, June 12, 2007

Mac Fanboys love Safari on Windows

1. It's their app away from home when they must use a Windows machine.

2. Anything that competes with IE is good in their book.

3. They can finally show off some Apple goodness to family and friends.

4. More web pages will become Safari friendly.

5. Private browsing. Hear them snicker.

6. Bookmark hot-keys.

7. Snapback is yummy.

8. Built on open source.

9. iTunes and Quicktime have a buddy app now.

10. A bunch of features they've coveted from Firefox.

Not the most fun, but I decided not to pick on Microsoft too much. Some would say the list could begin and end with 1-10: Not M$!

Monday, June 11, 2007

Kung Fu Cinema - Jet Li and Jason Statham go to ‘War’

Kung Fu Cinema - Jet Li and Jason Statham go to ‘War’

First off, find an official trailer here.

Jet Li and Jason Statham have a new movie, WAR. Kung Fu Cinema provides a great preview article, with information about the actors, and the production team, including Corey Yuen.

I'm a big fan of Jet Li and Jason Statham, both of whom are pure action stars. The trailer gives us just a taste of what's to come.

Please show Kung Fu Cinema some love and click through to their write up, but follow the video link above to


Sunday, June 10, 2007

Blogging Mistakes: Final List

Blogging Mistakes: Final List

Brought to us from Daily Blog Tips:

"This is the final list of entries for the blog project “Blogging Mistakes”. We had 48 blogs participating on the project, hopefully we will learn from those mistakes and avoid them on the future. I was thinking that people would mention the same blogging mistakes over and over again, but that was not the case so make sure to check all the entries!"

This page is the list of links for each of the 48 blogs. Some links have just a couple of lessons learned, others more, but I'm looking to find several that I can learn from.

Please show some love to Daily Blog Tips and to the 48 participating blogs by clicking through, and following some of the links. Also, feel free to blog them too. ;)

Your fellow blogger,

The Top 10 Blogging Mistakes I Made in My First Year - eMoms at Home - Blogging and Internet Marketing for Home Based Entrepreneurs

The Top 10 Blogging Mistakes I Made in My First Year - eMoms at Home - Blogging and Internet Marketing for Home Based Entrepreneurs

Wendy Piersall of eMOMS AT HOME brings us her list of top 10 blogging mistakes. The list is thoughtful and easy to read. It assumes you are interested in growing your blog. If your goal is to post notes for friends and family you might benefit some, but all of the gotchas are worth watching if you are more serious.

One of the big ones I'm probably most guilty of is #2 - I stopped commenting on others' sites.

I believe that any sufficiently busy person falls into this trap. It's probably more true if you are busy searching for ideas to blog about and blogging them and perhaps working a full time job on the side.

An upside example of where it pays off is that when you do comment on other people's sites, they are more likely to visit yours. Well at least once. But that's a content issue if they visit again.

All in all this article is short and to the point. Another in a long list of useful articles on the eMoms At Home site.

Click through and enjoy the free advice.
Your fellow blogger,

Saturday, June 09, 2007

CrunchNotes: Nicely Done

CrunchNotes: Nicely Done: "Whatever company this is, they should use this as one of their primary recruiting tools. Well done. As soon as you get to about 0:53, you know it’s going to be good."

What CrunchNotes said. Go check out the video and feel job envy.

Dreaming of working some place so cool,

Ms. Dewey - Search Vixen

Ms. Dewey - Search Vixen

So mix a bit of MS Live Search, a bit of sexy woman in annoying clips and patience trying delays and you have Ms Dewey the search bot.

Yes, she looks pretty and has a sweet voice, but that only goes so far. After the first time I'm reading the search results and she taps on the 'glass' to prompt me, our relationship was about over.

The site is much like any other search site, you fill in the text field and hit enter, then you get search results. In this case though, Ms Dewey has to put on the show of 'thinking' about your question, displaying an animated response, then the results come up in a 3"x3" window.

The results 'window' has no scroll bar but is responsive to mouse scrolling.
("Hello, type something here", as she taps on the screen.)
Results are shown with a small bit of text from the page, as well as the page title and the link. A problem is that where you see the link, you can't click, but you click on the title.
(She shoots a rubber band at us.)

I don't need a search interface that makes flirty eye contact, ask me if I'm there, nor ponder my searches. Oh yes, and don't search on Ms. Dewey, or you'll hear about her family reunions.

Overall, this is fun to show your friends ... once. After that not so much.
("Hello, type something here", she prompts again.)

Ok, I'm done letting Ms. Dewey search for me.


Friday, June 08, 2007

Real Americans Aren't Bashful

We even wear pajamas to the store. :)

Check out the further adventures of the Hil and Lil.

Real Americans Read Comics

Maybe some folks won't admit they have read comics, but some adults even still read them. You know why? Because we still hold out for heroes. America still believes in the larger than life, the impossible, and the hero who prevails against unbeatable odds.

Please click the pic and show Mav some love on this shot.

Your fellow American,

Real Americans Enjoy Family Time

Feet Up - Family Style!
Originally uploaded by ambrosialove.
America proudly supports having family and friends. This family definitely enjoys life together.

Your fellow American,

Real Americans Eat Big

It's a pound!
Originally uploaded by Dave77459.
At least as evidenced by this photo by Dave.
Click through and show how impressed you are!


SCIFI.COM - The Dresden Files

SCIFI.COM | The Dresden Files

If you aren't watching The Dresden Files on SciFi Channel you are missing out. The actor, Paul Blackthorne, has played on a lot of TV shows over the recent years, including 24, ER, and even Deadwood. In the role of Harry Dresden, he's a likable schmuck of a wizard, whom everyone on the series either loves or hates. The only undecided folks are ones that haven't met him.

Harry operates as a wizard out in the open, even going so far as to be listed in the yellow pages. The stories take place in Chicago, and frequently involve murder, magic and demons. He is frequently paired with a police lieutenant named Murphy, who busts his chops as often as she partners with him on a case.

The part is well acted and the series is entertaining. I recommend you check it out at the SciFi website. Also consider downloading an episode or two off of iTunes Music Store.


Marc Andreessen on how to hire good people ... (

Marc Andreessen on how to hire good people. Don't just hire smart people or people with degrees...look for drive, curiosity, and ethics. "Pick a topic you know intimately and ask the candidate increasingly esoteric questions until they don't know the answer. They'll either say they don't know, or they'll try to bullshit you. Guess what. If they bullshit you during the hiring process, they'll bullshit you once they're onboard."

Attribution to
As per, this is attribution, share-alike under the Creative Commons License.

Great article if not a bit wordy. I think the point about honesty is probably the strongest made.

Swaptree Beta

I have one invite to share. Best comment will get it.

Swaptree is web site community focused around trading items instead of purchasing and selling them. You post what you have, ditto with other members. The system matches up your wants with what you have to trade. It also lets you know what you can get for what you are offering.

So far I've yet to make my first trade, but I apparently have at least one book that lots of folks want to trade for.

The site also allows for trading of music, DVDs and video games. Do check it out.


24 Hour Adventure - 2nd Adventure

The above is the kick-off video for Lil and Hil's 2nd 24 Hour Adventure.

Check out the site and keep up with them on their lock-in from noon Fri to noon Sat.



RPGLE in FREE supports two ways to convert numerics to a character field. Both are Built In Functions, BIF. These are %Char and %EditC.

Both functions are replacements for the use of MOVE in RPG III/IV.

Let’s consider a positive numeric of 6 positions and 3 decimal places, numeric = 6.000.

myCharNum = %Char(numeric);

This produces a left adjust output of ‘6.000′.

myEditNum = %EditC(numeric: ‘X’);

This produces a right adjusted output of ‘006000′.

Notice the stripping of the decimal when using %EditC. Also to note is the addition of leading zeroes in the %EditC output.

Both options have their uses depending on what the text form of the number is for.

Let’s now consider a negative numeric, -6.000.

The %Char output is ‘-6.000′.

The %EditC ouput is ‘00600}’.

As you can see here, %EditC not only doesn’t maintain the integrity of the number, but provides nonnumeric output. Again, note that the %EditC function right adjusts the value.

From these tests it might appears that %Char might be your best and obvious choice for all numeric to character conversions. But there is more to %EditC than just the ‘X’ option. %EditC is actually short for edit code. It allows the use of all numeric edit codes for formatting. This includes most importantly the Date formats.

The proper edit code used in place of ‘X’, provides also for asterick fill in place of leading zeroes. Another possible edit choice adds a currency symbol.

In conclusion, for simple numeric conversions, %Char is probably the best and most straightforward choice. For more complex conversions, especially for dates, then %EditC is the only option.

In another entry I’ll a few of the other edit codes for %EditC.

Thursday, June 07, 2007

Real Americans Rock Out in Their Cars

Tech.Chick.Blog - Monday Morning Heroes Musings

Tech.Chick.Blog - Monday Morning Heroes Musings

Go and check out Tech Chick's musings about her favorite show, Heroes. Sadly I'm pointing you to this after the season finale, but some of this stuff makes for a good laugh. She points to some cool fan stuff related to Heroes as well as the NBC swag. :)

Click through and grab a smile,

Tuesday's Top 10: Top 10 Online Pet Peeves

Tech.Chick.Blog - Tuesday's Top 10: Top 10 Online Pet Peeves

Check out Tech Chick's blog post about her top 10 online pet peeves.

I strongly agree with her #1 Videos that play automatically on a page as being in the peeve category.

The one I'd have to disagree with is #5 Any link that opens in a whole new friggin window. I personally prefer that since I hate being dumped off onto another site and all too often unable to use the back button. With Firefox, new window actually equals a new tab, which I prefer.

Please click through to check out the list and some good comments from her fans.


Wednesday, June 06, 2007

Thinking Machine 4

Thinking Machine 4 explores the invisible, elusive nature of thought. Play chess against a transparent intelligence, its evolving thought process visible on the board before you.

This online chess game is most interesting because it displays a visual representation of the moves it's considering. It does this differently than the standard of having a sideboard or scratch area where it shows the move or displays the notation view, but by a series of colored lines, building on one another over and over while the AI considers its move.

It is fascinating to watch, though it may not give some of you real experts a challenge. In theory the AI gets better over time, but I don't believe I've played enough games to find out.

Please check it out and try a game or two.

Your chess playing fool,

Michael Shermer: Why people believe strange things (video)

Michael Shermer created a video for TED to tell us about why people believe strange and sometimes obviously untrue things. What Michael has to say is both entraining and surprising. If you've ever felt like we sometimes wander around like sheep, this will confirm that feeling.

Michael Shermer is founding publisher of Skeptic Magazine.

Please check out and enjoy.


St. Louis has some Cocoa Heads!

"The St. Louis CocoaHeads are interested in promoting and improving their Cocoa skills as well as other Mac programming. If you are in the St. Louis area, please join us for our presented topics, casual discussions, and group Cocoa projects."

I've been interested in doing some Cocoa programming and have actually gotten started on a learning book. This community might be a help.

My fellow blogger, ,, attended their last meeting at the St. Louis Bread Co. on May 26th. He indicated this group is for individuals serious about their programming. The group's focus isn't so much on teaching a topic but being in the same place, coding alongside one another, and only interrupting when you have a real question.

He did mention they were fairly friendly though. Oh and bring your laptop.

For more information, check their site, or contact Jay Tuley.

Your fellow programmer,

Quote from my wife the bus driver

“Are you wearing pants under that?”
— Wife to 5th grader on her bus

Sunday, June 03, 2007

Special Topics In Calamity Physics | A Novel By Marisha Pessl

Special Topics In Calamity Physics | A Novel By Marisha Pessl

I've not read this book, but checking out the website makes me want to. This is a fun and unique website. The site is highly interactive, including a book with terms, excerpts and other information.

Quite interesting.


Saturday, June 02, 2007

Boy, 12, Helps Police Nab Two Gunmen

Excite News - Boy, 12, Helps Police Nab Two Gunmen

How many kids can say they jumped naked out of a second story window, before they even went to college? This story relates how to men jumped out of windows in their house during a break-in to get help. Brave young men.

Check it out,

24 Hour Adventure

24 Hour Adventure

These ladies took 24 hours, added in a dash of New York, and a wee bit of giddy adventurous attitude to have quite the journey around the burrows of the Big Apple. From beach to coaster, with cotton candy, candy apples, kielbasa and beer, they really tasted New York.

Please give their website a few minutes of your time. I guarantee you'll smile and maybe even laugh. :)


Friday, June 01, 2007


Fun game

I'm not sure what language it is but this is an addictive and fun game. The graphics are even fun.

Click through at your own risk.


Awesome Violin to the Blak-eyed Peas

Hot Violin Skills - The funniest home videos are here

Burning Questions • It's True-gle!

Burning Questions • It's True-gle!

It's True-gle!
Unlike the rumor that FeedBurner is nearly code-complete on a multiplayer Wii edition, the blog posts, phone calls and conjecture about our future as part of the Google family tree are now officially true.

You probably have lots of questions about this, so they've posted a faq.

From their own site about Feedburner:

FeedBurner is the leading provider of media distribution and audience engagement services for blogs and RSS feeds. Our Web-based tools help bloggers, podcasters and commercial publishers promote, deliver and profit from their content on the Web.

If you are a blogger and not using them, you are missing out on good statistics about who is reading up on your site. Check them out, and help them celebrate becoming part of Google.


Engadget editor shows his ignorance when it comes to robots

Artificial Intelligence and Robotics: Engadget editor shows his ignorance when it comes to robots

Click through and read one blogger's thoughts about this recent Engadget article.

It's an interesting view point.