TechTips


TechTip: New Function Resolution Casting Rules for DB2 PDF Print E-mail
Tips & Techniques - Database
Written by Kent Milligan   
Friday, 11 July 2014 00:00

They may be obscure, but they're definitely not to be overlooked.

kent milligan 117x117Written by Kent Milligan

My recent article on the DB2 for i 7.2 release highlighted some of the more noteworthy database enhancements in the latest IBM i release. There wasn't room in the previous article to discuss all of the DB2 enhancements, so in this article you'll learn about a smaller DB2 improvement known as function resolution casting rules.

Add a comment
Last Updated on Thursday, 10 July 2014 09:57
Read more...
 
TechTip: Suggestions for DB2 for i Code Quality Testing PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 11 July 2014 00:00

Prepare to put your DB2 SQL code "through the ringer" to ensure it's ready for prime time.

Written by Michael Sansoterra

Typically, developers love writing new code. And while an application is new and business rules are fresh in the mind, it's generally pleasurable to enhance code as change requests meander in. But after the years roll on, and business requirements are forgotten, and complex code looks unfamiliar, then maintaining the code can get downright ugly. How does one know an obscure business rule wasn't violated when changing code?   It's usually not until code has been moved into production that the misery starts after a bug rears its ugly head.

Add a comment
Last Updated on Wednesday, 09 July 2014 11:30
Read more...
 
TechTip: More GridX Features PDF Print E-mail
Tips & Techniques - Programming
Written by Danielle Carmon   
Friday, 20 June 2014 00:00

In my previous article, I introduced the GridX library and a few of its features. In this article, we'll take a deeper dive into GridX features.

daniell carmonWritten by Danielle Carmon

In today's TechTip, we'll look at examples that show widgets in cells, embedded forms, and tree grids.

Add a comment
Last Updated on Friday, 20 June 2014 00:00
Read more...
 
TechTip: DB2 for i Impersonation Take 2: External Routines PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 13 June 2014 00:00

Use these external SQL routines as an alternative to the somewhat restrictive SET SESSION AUTHORIZATION statement.

Written by Michael Sansoterra

In "Impersonate Your Neighbor Using DB2 for i," I outlined how to use the SET SESSION AUTHORIZATION SQL statement to override the user profile of the current thread or, in many cases, the current job. The benefits of doing this include providing temporary authorization to resources such as IFS files and impersonating another user so that user-dependent code will be tricked into thinking that a different user is running it. However, there are a few restrictions on this statement that can limit its usefulness. In this tip, I'll introduce some external SQL routines (written in RPG) that allow an application to override the user profile without some of the restrictions of the built-in DB2 functionality.

Add a comment
Last Updated on Friday, 13 June 2014 00:00
Read more...
 
TechTip: Simplifying PowerVM Enterprise Virtualization Management with IBM PowerVC PDF Print E-mail
Tips & Techniques - Dev Tools
Written by Joe Cropper   
Friday, 13 June 2014 00:00

Partnering the PowerVM hypervisor with Power Virtualization Center (PowerVC), IBM's new enterprise virtualization management solution for Power Systems, is an assured way to bring tremendous value to your organization.

Written by Joe Cropper

IBM Power Systems have always provided huge "bang for the buck" through industry-leading hardware coupled with all of the features you would expect from an enterprise-grade hypervisor (i.e., PowerVM). Power Systems are generally managed via either the Integrated Virtualization Manager (IVM) or the Hardware Management Console (HMC). While both of these platform management solutions provide administrators with all the knobs and buttons to manage their systems (and will continue to do so), IBM recognizes the need for a simple, user-friendly solution that focuses on enterprise virtualization management to streamline your day-to-day virtualization management tasks and unleash the many strengths of IBM Power Systems. This is where PowerVC is called to duty!

Add a comment
Last Updated on Friday, 13 June 2014 00:00
Read more...
 
TechTip: Impersonate Your Neighbor Using DB2 for i PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 06 June 2014 00:00

Learn how to override the current user profile handle with a different user profile in DB2.

Written by Michael Sansoterra

For most database-related applications, using adopted authority is the preferred way to temporarily grant users controlled access to sensitive data. But one limitation of the adopted authority model is that it doesn't override IFS permissions. A second limitation is that the adopted authority model doesn't allow an application to "impersonate" another user. To help with these issues, the DB2 for i statement SET SESSION AUTHORIZATION provides a way to overcome both of these limitations.

Add a comment
Last Updated on Thursday, 05 June 2014 13:16
Read more...
 
Partner TechTip: Secret Capabilities of Robot/SCHEDULE Revealed PDF Print E-mail
Tips & Techniques - System Administration
Written by Chuck Losinski   
Friday, 06 June 2014 00:00

Even after 30 years, Robot/SCHEDULE still has tricks up its sleeve, which shocks (and delights) our tech support team. We asked for their best-kept secrets, and they were happy to share.

ChuckLosinski 116x116Written by Chuck Losinski

For hundreds of satisfied customers, it’s no surprise that Robot/SCHEDULE is the world’s most advanced job scheduler, yet there are still features customers don't know about. These tips from our tech gurus have helped customers who needed to export jobs to another partition, check the value of a Data Area before processing, view a screen to show jobs as they processed, and automate for checking for late jobs.

Add a comment
Last Updated on Thursday, 05 June 2014 13:15
Read more...
 
TechTip: Introduction to GridX for Dojo Developers PDF Print E-mail
Tips & Techniques - Programming
Written by Danielle Carmon   
Friday, 30 May 2014 00:00

Learn the basics of GridX, an open-source JavaScript library that makes it easy to create sophisticated interactive tables for the web.

daniell carmonWritten by Danielle Carmon

What is GridX? GridX is a library created to display data stores in a table. It's a great alternative to Dojo's native dojox.grid. It comes with many modules that add additional features to a basic table and is designed to be easily extended by users' modules.

Add a comment
Last Updated on Wednesday, 28 May 2014 14:57
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 180

WEBCAST

MC Webcast CenterFEATURED WEBCAST

See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:

 

  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 

 

Watch the Webinar Now!

 

TRIAL SOFTWARE

MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.


   MC-STORE.COM