Blogs

Best way to setup EXTPRC using Turnover at V5R4

  • Posted on: 14 December 2012
  • By: NickLitten

Question: How do I promote External Procedure using Turnover and get them to automatically *REPLACE on the destination machine?

Answer: Like this!

The problem here, is that SQL Stored Procedures have no equivalent of *REPLACE on the CREATE PROCEDURE statement (they do in IBMi 6.1+). That's easy - "just add a Drop to line one of the SQL source code" I hear you say... Well its not that easy in Turnover either. Adding a DROP to the SQL, while using IBMi V5R4 issues a Severity 20 warning message and unfortunately a SEV(20) causes the Turnover SQL Promotion to *FAIL.  Aaaarrrgh!

But wait... help is at hand. We just need to over-ride the default SQL *EXTPRC command to only fail if the severity breaches 20. How about we set it at 25? Luckily thats easy to do:

1 - Set 25 Default

Setup Turnover to over-ride the default severity on the TRUNSQLSTM command (this is the command that Turnover runs to create stored procedures during promotions).

So, launch Turnover and goto - DEV | ADMIN | Type Codes and select EXTPRC.

Note that you need to add the EXTRADFT('ERRLVL(25)') to this command.

How to see which forms were ran from a specific Turnover Application?

  • Posted on: 12 December 2012
  • By: NickLitten

The answer is "YES"

Here is the green screen (5250) way of doing it.

1 - Go into Turnover main menu using cmd(TURNOVER)

2 - Option 6. Work with Forms

3 - Press F17(Filters) and enter the Filter information you want to look for

When you press enter you will see just the FORMS that satisfy that particular filter condition.

:)

 

 

once an AS400 always an AS400

  • Posted on: 11 December 2012
  • By: NickLitten

I was reading an interesting thread on Linkedin this morning, discussing another article about the much loved AS/400

Being as I am an old-school S/34, S/36, S/38 guy from back in the Reagan/Bush days ~ I will still call it “the 400” ~ (iSeries / Series i / Power systems never caught on with me). The original “Silverlake” project started over 25 years ago, and the 400 is still cranking. I raised my children from diapers to degrees while programming on this durable box.

There have been many improvements to the 400, heck IBM even switched it from plain ugly tan to cool sleek black – but the fundamental machine is still the same. It has not tried to be something that it is not. The 400 has not been “improved” beyond what is reasonable. It has remained as steady (and ubiquitous) as the ordinary cup holder – which is pretty extraordinary these days.

[original article]

Windows 8 Shortcut - Win+PrtScrn

  • Posted on: 19 November 2012
  • By: NickLitten

 

Windows Key + PrintScreen: Screen capture

I've long used the SHIFT-ALT-PRINTSCREEN technique to capture screen shots in Windows XP thru 7.

But in Windows8 there is a new PrtSc function - when you press WindowsWindows-PrtSc it not only captures the screen but also saves the screen short as a PNG FILE into the Screenshots folder located in your picture library.

The old methods of a simple copy to the clipboard can also be used by pressing the PrtScrn key or Alt-PrtScrn for the active window only.

 

Update WebSphere Development Studio Client to Version 7.0.0.8

  • Posted on: 16 November 2012
  • By: NickLitten

So, you've installed WDSC7 now what?

 

1 - Automatically update to WebSphere Development Studio Client, Version 7.0.0.8:

Install the fix pack with the same user account that installed the product.

Restrictions:

  • WebSphere Development Studio Client for iSeries, Version 7.0, 7.0.0.1, 7.0.0.2, 7.0.0.4, or 7.0.0.6 must be installed.
  • The product cannot be open when you install this fix pack.

To find and install WebSphere Development Studio Client, Version 7.0.0.8 as an update:

Download and Update WebSphere Development Studio Client WDSC7 for free

  • Posted on: 15 November 2012
  • By: NickLitten
free rpg source edit alternative to seu

I'm an IBM i RPG Developer - do I choose SEU, RSE or WDSC?

If your caught between using SEU (Stoneage Editting Utility) and RSE (Really Stupidly Expensive) for your IBM-i code development environment - you have one other glaringly obvious choice - WDSC (Wonderful Double Super Codetool).

Personally, I like WDSC because its $FREE and I'm cheap :)

This was the last iteration of the Websphere Development suite before IBM, rebuilt and rebranded it as the 'Rational Developer Tool' and decided to charge $900 per copy. For Freelance RPG Programmers like me that just puts the tool completely out of my budget. how could IBM possibly justify $900 for a single code editor application that was previous free. Compare this to Microsoft MSDN charges where I gladly pay $300 for a license for every single piece of Microsoft Software out there! That is a big thumbs up for MSDN subscriptions and a big raspberry for IBM's RDi/p costs.

Single Black iSeries looking for a lasting relationship with the latest IBMi operating system

  • Posted on: 14 November 2012
  • By: NickLitten
as400 thrown out for trash. unable to buy operating system so they are useless

I love programming (RPG, JAVA and CL) on the IBM i Server range... but it feels like IBM are trying to stop me. Aaaaargh!!!!

"But Nick, whats the problem old Chap?" I hear you askcome on ibm i expect better customer service

Here I am - a huge advocate of IBM i technology. I've grown up through the ranks of IBM System 3x systems and evolved alongside IBM through the AS400 and 'i' years. I've excitedly played with the quiet, yet groundbreaking changes in hardware and software that came with the iSeries/eServer range of Servers. I've scratched my head slightly at the i5 branding. I've shook my head at the weirdly blurred focus on Linux. I've cheered at the Power5 Processor range and final (hopefully) name consolidation of the Power Server Hardware and IBMi software. I'm an i-vangelist in the strongest sense.

What does IT Consultant really mean?

  • Posted on: 12 November 2012
  • By: NickLitten


being a computer programmer is a great job

I am not a fan of the 'IT Consultant' moniker because its kind of generic, non-descriptive and dull. Sadly, it's the industry standard so I'm stuck with it. :(

I would like to describe myself as a Programmer in the same way that a person who is a Butcher, Dentist, Mechanic or Carpenter is clearly defined. But then people think I am just a code monkey. *sigh* So, I'm back to writing 'IT Consultant' in any form that asks for job title. So I suppose in my case, being an IT Consultant means I am a software developer, IBM i evangelist, RPG language lover, Drupal enthusiast, software change management tinkerer, early adopter, proponent of open source and hopeless web addict. All of these things add up to one easy to chant mantra

"Yes, I am a Programmer and I am proud to Program - Veni, Vidi, Programmum"

My main fields of expertise are

Query Management Queries are Queer

  • Posted on: 8 November 2012
  • By: NickLitten

So, I was emailed the following hints and tips document discussing the ubiquitous Query Management Qeuery object type on the IBM Power Server (the artist formerly known as AS400). It's useful to refer to so, here it is:

QMQRY - QUery Management Query

A SOURCE FILE FOR YOUR QUERY

The key to making a query dynamic is converting it into a form that can accept variables. The easiest way to do that is to convert your query to a Query Management Query (QMQRY). A QMQRY is simply an SQL statement stored in a source member. Once the SQL statement has been placed into a source member, you can replace hard-coded values from your original query with variables that can be replaced at execution time. If you've never worked with SQL before, you needn't worry; we will make use of an IBM command that will construct SQL statements for you.

We'll begin by creating the source file used to store your QMQRYs: QQMQRYSRC. To create this source file, use command Create Source Physical File:

CRTSRCPF  FILE(library/QQMQRYSRC) RCDLEN(91)

Be sure to specify a record length of 91 (source length of 79, sequence number length of 6, date length of 6) instead of the command default of 92, as QMQRY requires a length of no more than 79 bytes for the source statement. If you specify a length of more than 91 on the CRTSRCPF command, you will not be able to run your SQL statements.

 

Boris the LR3 gets a new crank sensor

  • Posted on: 1 November 2012
  • By: NickLitten
This is not the cursed LR3 this is my most excellent Defender

Courtesy of the very nice chaps at Kensington Motor Cars here in Las Vegas - http://www.kmcnv.com

landorver lr3 crank sensor jobbie

A new engine crank sensor!

Now... this might seem like a tiny little bit of plastic and metal but is it the savior or haunted LR3 engines everywhere?

After many, many, many discussions with the garage owner (Bill) and Customer Service girlie (Trish) we decided this was the next angle of attack. Apparently this little gadget looks at the engine and decides to tell the starter motor wheter it should start - or crank as these Yanks call it - and if its a little bit whoozy or drunk then maybe it wont tell the engine computer its started. Or maybe it will tell it that its started - even when it hasnt. AHA! This could be it. I'm excited.

And guess what... changing the crank sensor seems to have fixed it!

It's now been three weeks and still going strong. Boris has starteda every time.

It's a miracle.

So much for the famous Exorcist quote - I've revised it to "The power of the crank sensor compels thee"

 

Pages