TechTips


TechTip: PDO for PHP PDF Print E-mail
Tips & Techniques - Web Languages
Written by David Shirey   
Friday, 02 December 2016 00:00

Why do we use PHP with an HTML web page? Lots of reasons, but data access is one of the most important, and PHP Data Objects (PDO) is, for me, the best way to do that.

david shireyWritten by David Shirey

There are lots of web languages out there, aren’t there? HTML5, JavaScript, PHP, CoyoTE. I actually don’t know if that last one exists, but given the number of special languages available for the web, I think I’ve got a 50-50 chance.

 

And increasingly, on the IBM i, we are being introduced toand find reasons to usemore and more of these languages. Each has its own list of things that it does well and things that it doesn’t.

Add a comment
Last Updated on Wednesday, 30 November 2016 14:31
Read more...
 
TechTip: The .NET Core Framework PDF Print E-mail
Tips & Techniques - Dev Tools
Written by Joydip Kanjilal   
Friday, 02 December 2016 00:00

Provide support for a variety of chip and OS targets.

joydip kanjilalWritten by Joydip Kanjilal

Since the initial version of .NET Framework (the first beta version of .NET 1.0 was released in the fall of 2000), Microsoft has released many more upgrades over the years. With an intent to make the framework cross-platform, open source, and modular, the software giant has now come up with .NET Core Framework.

Add a comment
Last Updated on Thursday, 01 December 2016 10:32
Read more...
 
TechTip: Store and Parse JSON Data Natively with DB2 for i PDF Print E-mail
Tips & Techniques - Database
Written by Michael Sansoterra   
Friday, 18 November 2016 00:00

Learn how the latest DB2 for i features can reduce development time when interacting with the popular JSON data format.

Written by Michael Sansoterra

In my prior tip about using JSON with DB2 for i, I articulated a method of accessing JSON with SQL by use of Java external user-defined functions (UDFs) that convert JSON to XML and XML to JSON. Starting in IBM i 7.1 TR10 (Database Group PTF Level 34) and IBM i 7.2 TR2 (Database Group PTF Level 5), IBM has added native JSON support to the DB2 for i database engine. Keep in mind that, at this first release, the JSON support is still considered a "technology preview," so be sure to test any JSON implementations carefully before using them in production. Also, based on available documentation, some of these features and JSON functions are not yet advertised by IBM for the IBM i and may be subject to change.

Add a comment
Last Updated on Thursday, 17 November 2016 11:47
Read more...
 
User Rating: / 2
PoorBest 
TechTip: IFS Containers Part 2, Automation with IBM i Chroot PDF Print E-mail
Tips & Techniques - Programming
Written by Aaron Bartell   
Friday, 11 November 2016 00:00

Automation wins in the end. IFS Containers have automation as a first class citizen.

aaron bartellWritten by Aaron Bartell

In the first article of this series, I discussed what IFS Containers are and how they use the chroot command to implement the container concept. To create the IFS Container, we had to manually create directories and copy files. That wasn't a big deal for the small example we created, but imagine if you needed to create an IFS Container for an entire PASE application that had requirements for hundreds of directories, commands, and libraries. This is where automation becomes a necessity, and more specifically, the IBM i Chroot open-source project.

Add a comment
Last Updated on Thursday, 10 November 2016 10:50
Read more...
 
User Rating: / 1
PoorBest 
TechTip: CNX Valence for PHP PDF Print E-mail
Tips & Techniques - Scripting
Written by David Shirey   
Thursday, 03 November 2016 23:00

PHP help tools. That’s what we’re looking at. And this month, we are looking at the CNX Valence product.

david shireyWritten by Dave Shirey

Part of getting familiar with PHP is getting familiar with the way in which PHP relates to the IBM i. Over the past year, we have looked at different options for creating PHP scripts that we might use with the i.

Add a comment
Last Updated on Thursday, 03 November 2016 23:00
Read more...
 
TechTip: C# for RPGers - More on Arrays and a Different FOR Loop PDF Print E-mail
Tips & Techniques - Programming
Written by Rafael Victoria-Pereira   
Thursday, 03 November 2016 23:00

Let’s continue to explore C# arrays and introduce a different FOR loop. It’s a very useful tool that has no equivalent in RPG.

rafael victoria preiraWritten by Rafael Victória-Pereira

In the last TechTip in this C# series, I introduced the array data type and showed how it’s defined and used. Now let’s explore some of its properties and methods, with the help of a different FOR loop: ForEach.

Add a comment
Last Updated on Thursday, 03 November 2016 10:29
Read more...
 
TechTip: Take Open-Source ILE Further - Creating from the IFS PDF Print E-mail
Tips & Techniques - Programming
Written by Liam Allan   
Thursday, 27 October 2016 23:00

The future of storing ILE source code is closer than you think.

Written by Liam Allan

In this long-awaited article, I'm going to talk about how to store your RPG and CL code on the IFS and what steps you need to take in order to create objects out of that source.

 

First, you should know that CRTRPGMOD, CRTBNDRPG, and CRTSQLRPGI all have a parameter to specify a stream file for source. Thanks to IBM, this makes compiling RPG programs much easier. But what about CL? There isn’t a stream file parameter on CRTBNDCL, so what options do we have? I’ll come to that in a little while. If you work with other ILE languages, you might be glad to hear that the C, C++, and COBOL “Create” commands also have stream file parameters.

Add a comment
Last Updated on Thursday, 27 October 2016 23:00
Read more...
 
TechTip: DB2 for IBM i Services - The Practical PDF Print E-mail
Tips & Techniques - Database
Written by David Shirey   
Thursday, 27 October 2016 23:00

About six months ago, I talked about the relatively new DB2 for i Service tool and why it was pretty nifty. Now, let’s take a closer look at it and see how you actually use it.

david shireyWritten by David Shirey  

As I said in the previous tip on this topic, the DB2 for i Services developed by Scott Forstie’s team and being enhanced with every new technology refresh is another way to investigate what’s happening on your IBM i. Although we’re accustomed to doing this using a variety of very powerful system commands, the DB2 for i Service package provides a fresh, more flexible, and more sophisticated way of digging out this information.

Add a comment
Last Updated on Thursday, 27 October 2016 16:25
Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 202

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