TechTips


TechTip: Wresting Your Files Away from SQL Pseudo-Close PDF Print E-mail
Tips & Techniques - SQL
Written by Joe Pluta   
Friday, 04 March 2016 01:00

Sometimes you want to do something simple and you can't because SQL has your file; this tip provides the fix.

joe plutaWritten by Joe Pluta

SQL is a powerful tool that provides fast access to your data. In order to stay fast, though, it does a few things under the covers that don't always coexist nicely with the rest of the operating system. Today's tip focuses on a specific case, the pseudo-closed cursor.

Add a comment
Last Updated on Friday, 04 March 2016 01:00
Read more...
 
User Rating: / 1
PoorBest 
TechTip: C# for RPGers: Visual Studio's Code-Assistance Tools PDF Print E-mail
Tips & Techniques - Programming
Written by Rafael Victoria-Pereira   
Friday, 26 February 2016 01:00

Let's create a modified version of the simple program created in the previous TechTip to demonstrate Visual Studio's code assistance tools and show how they can be used to improve efficiency.

rafael victoria preiraWritten by Rafael Victória-Pereira

Time to fire up Visual Studio again and do some more coding! Once you've launched the IDE, you'll notice that the Start Page, described in the previous TechTip, now contains an entry under the "Recent" title of the left hand side panel. This allows you to quickly access the last opened projects, just like in many other Windows programs. Click the "HelloWorld" project and add a new line between the "Console.WriteLine…" and the closing curly braces. Let's write the code necessary to send a second message, below the "Hello World" message: type System.Console.wr. The IDE's brains will kick in and offer a couple of suggestions to complete the statement, as shown in Figure 1:

Add a comment
Last Updated on Thursday, 25 February 2016 16:39
Read more...
 
TechTip : Embedded SQL - Easy String Manipulation Using SQL Functions PDF Print E-mail
Tips & Techniques - SQL
Written by Sumit Goyal   
Friday, 26 February 2016 01:00

SQL is always much better than RPG for handling string data.

sumit goyal Written by Sumit Goyal

Embedding SQL in RPG gives RPG the great power not only to handle database operations but also to perform string manipulation. For string manipulation, RPG provides some very basic functions, such as %TRIM, %SUBST, %SCAN, and %REPLACE.

 

 Suppose you want to convert a string to uppercase. How can you do that in RPG? By using the %XLATE function and a couple of constants containing all 26 letters of the alphabet. Something like this:

Add a comment
Last Updated on Friday, 26 February 2016 12:08
Read more...
 
User Rating: / 1
PoorBest 
TechTip: IBM i Services - What It Is PDF Print E-mail
Tips & Techniques - SQL
Written by David Shirey   
Friday, 19 February 2016 01:00

IBM i Services is the hottest, and coolest, thing to hit systems admin since…well, maybe since ever! And its constantly updated SQL tables will give you a whole new slant on managing your i.

david shireyWritten by David Shirey  

Have you heard about IBM i Services? No? Well then, you're in good company because apparently no one at IBM has either. Go ahead; go out to IBM's website and search on "IBM i Services." If you find anything, let me know because I sure didn't. Yet this product looks like a sure bet to be a winner for those who are managing an IBM i.

Add a comment
Last Updated on Friday, 26 February 2016 11:04
Read more...
 
TechTip: Riding the Rails, Part 2 PDF Print E-mail
Tips & Techniques - Scripting
Written by Aaron Bartell   
Friday, 12 February 2016 01:00

Go further into the Rails generators and Convention over Configuration. It just keeps getting better. Saving time never felt so good.

aaron bartellWritten by Aaron Bartell

In the January 2016 article "Riding the Rails, Part 1," I introduced you to how a Rails project is created. We walked through the various files and directories that were generated. We also made it through starting the Rails web server and ended with being able to see a "Hello World" type of screen. In this article, we'll pick up where we left off by generating a Create, Read, Update, Delete (CRUD) application.

Add a comment
Last Updated on Wednesday, 10 February 2016 16:42
Read more...
 
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...
 
<< 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