TechTips


TechTip: How to Change a Database Code Set PDF Print E-mail
Tips & Techniques - Database
Written by Mohankumar Saraswatipura   
Friday, 12 February 2016 01:00

Learn how to migrate data from a non-Unicode database to a Unicode database.

mohan saraswatipuraWritten by Mohankumar Saraswatipura

Editor's note: This article is an excerpt from the book DB2 10.1/10.5 for Linux, UNIX, and Windows Database Administration (Exams 611 and 311): Certification Study Guide.

 

 Both BLU and pureScale require databases to be Unicode, so you should create all new databases as Unicode. Chances are good that the requirement to convert data to a Unicode code set will happen. Because a database cannot be altered to a different code set, this will mean you must unload and load the data.

 

 In the past, string units of character data have been stored in a relational database in bytes. So for a single-byte character set (SBCS), each character represents one byte. The string unit of the column data type is a byte, sometimes referred to as an octet.

Add a comment
Last Updated on Thursday, 11 February 2016 13:42
Read more...
 
TechTip: Running PHP Scripts - Zend Server PDF Print E-mail
Tips & Techniques - Scripting
Written by David Shirey   
Friday, 05 February 2016 01:00

We looked at WAMP/MAMP/LAMP and how they can quickly and cheaply give you the ability to run the PHP scripts that you develop on your PC. But other options are available.

david shireyWritten by David Shirey

Even though MAMP and its two amigos do a good job of letting you run your PHP scripts, there are other, more sophisticated ways to do this. And the first thing that we will look at is using Zend Server to provide the server capability for you.

Add a comment
Last Updated on Friday, 05 February 2016 01:00
Read more...
 
TechTip: Qport Office - A No-Fee Timesaver for IBM Query/400 Users PDF Print E-mail
Tips & Techniques - Database
Written by Bill Langston   
Friday, 29 January 2016 01:00

With this interface to Query/400, users don't need to know how to build queries or write SQL statements. And the accounting department doesn't need to write a check.

bill langstonWritten by Bill Langston

Do you work in a shop where people still use IBM Query/400 (sometimes referred to as STRQRY or WRKQRY)? You aren't alone.

 

Yes, even in 2016, IBM Query/400 remains the first tool thousands of IBM i users turn to when they need a simple report or a custom extract from their DB2 on i database.

Add a comment
Last Updated on Friday, 22 January 2016 13:41
Read more...
 
TechTip: C# for RPGers: Creating Your First C# Program and a Quick Tour of the IDE PDF Print E-mail
Tips & Techniques - Programming
Written by Rafael Victoria-Pereira   
Friday, 15 January 2016 01:00

Now that you've installed Visual Studio, it's time for a quick tour of this IDE. Let's do so while creating your first C# program!

rafael victoria preiraWritten by Rafael Victória-Pereira

The first TechTip of this new series showed you how to install Visual Studio. This one will take you on a quick tour of the IDE. It won't discuss every single detail because Visual Studio (VS) is a multi-purpose, multi-language tool, and there's a lot that's simply not relevant at this time.

 

Let's start our quick tour by picking up where we left off in the previous TechTip, with the Start Page, shown in Figure 1:

Add a comment
Last Updated on Friday, 15 January 2016 01:00
Read more...
 
TechTip: Riding the Rails, Part 1 PDF Print E-mail
Tips & Techniques - Scripting
Written by Aaron Bartell   
Friday, 15 January 2016 01:00

The IT industry is putting an emphasis on automation. The Ruby on Rails web framework has been doing that for a decade. Ride this rail with me as we dive into the many cool realities of Ruby on Rails.

aaron bartellWritten by Aaron Bartell

In the February 2015 article "Trying on a Ruby Ring," I talked about doing a small Hello World Ruby app and showed how to invoke an RPG program from Ruby. In March 2015's article "Sinatra Sings, Ruby Plays," I introduced you to a very simple web framework named Sinatra. In the April 2015 article "Ruby Talks to DB2 for i," I showed how a simple Ruby web application can query DB2.

 

Some of those articles touched briefly on portions of the Ruby on Rails web framework (Rails for short). We are about to embark on a journey to further define the many benefits of Rails and see why so many other technology stacks have followed their lead over the years.

Add a comment
Last Updated on Friday, 15 January 2016 01:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: Running PHP Scripts: WAMP/MAMP/LAMP PDF Print E-mail
Tips & Techniques - Scripting
Written by David Shirey   
Friday, 08 January 2016 01:00

Running RPG programs once they're created is easy. But what about PHP? We created a class-oriented script, but how do we run it? And what kind of setup is required to have a functioning PHP environment?

david shireyWritten by David Shirey  

We spent the last few tips talking about classes and gradually building a small script that was based in a class. But have you run the script? Do you know how to run a PHP script?

 

PHP isn't like RPG. It doesn't just run on the machine that you create it on. And you don't just do a "callphp" or something like that.

Add a comment
Last Updated on Friday, 08 January 2016 01:00
Read more...
 
TechTip: Front-End Your Application Servers with Nginx PDF Print E-mail
Tips & Techniques - Scripting
Written by Aaron Bartell   
Friday, 18 December 2015 01:00

Nginx serves many purposes. One is to sit in front of your Node.js, Ruby, Python, and other application servers, making it a single point of entry.

aaron bartellWritten by Aaron Bartell

In the article "Drivers, Start Your Nginx!", I discussed how to install the Nginx web server and walked through how to set up a simple index.html "Hello World" program. An obvious next step would be to have Nginx act as a front-end to your application servers so it can accomplish what's called a "reverse proxy."

Add a comment
Last Updated on Friday, 18 December 2015 01:00
Read more...
 
TechTip: A Freeware IDE for PHP Development PDF Print E-mail
Tips & Techniques - Dev Tools
Written by Stas Ustimenko   
Friday, 11 December 2015 01:00

If you're developing in PHP and want that development to take place within an IDE, CodeLobster offers a no-cost solution.

stas ustimenkoWritten by Stanislaus Ustimenko

Code development, particularly for creation of websites, often calls for the use of PHP, HTML, CSS, or JavaScript for best results. CodeLobster PHP Edition is a portable IDE that embodies a code editor and numerous other utilities for such projects and is available in a freeware and two licensed shareware versions.

Add a comment
Last Updated on Monday, 23 November 2015 10:15
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 5 of 197

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