| Network Poll |
 |
|
|
|
 System iNetwork January Sponsor
|
|
 |
System iNetwork January Sponsor
Home
» Tuesday Tips Video Podcasts
Tuesday Tips
- February 12, 2008 - Convert between Hex and Character - With so much Web, XML, CGI, and SOA stuff going on, the need to convert between hexadecimal and regular characters is increasing. Bob Cozzi's Tuesday Tip shows you exactly what hexadecimal is and how to convert between character data and hexadecimal -- simply, easily, and quickly - using good old RPG IV with a bit of prototyped MI statements added in for fun.
- February 5, 2008 - Packed, Zoned, and Integer Oh My! - There are so many different numeric data types to use today that choosing the right type is often left to habit instead of performance reasons. Bob Cozzi's Tuesday Tip is a numeric data-type primer that every RPG IV programmer needs to know before writing another line of code. For example, did you know that the "B" data type is replaced by the "I" data type? And that Packed(7,0) fields are faster than Zoned(7,0)? You will after watching this week's episode.
- January 29, 2008 – RPG IV at i5/OS V6 – Bob Cozzi has preempted his regular broadcast to bring you this special report: RPG IV at i5/OS Version 6. IBM introduced today a set of enhancements to the RPG IV language and the System i development environment. These new features include local files in subprocedures, full multi-threaded support, and much, much larger variable lengths. In addition, IBM is launching RDi, a new edit/compile/debug platform for RPG and System i. This new package provides everything that the SEU/PDM/SDA combination does from green screen, but provides it in a Graphical IDE.
- January 22, 2008 – Calculate the Day of the Week Revisited – A number of viewers wanted more, so Bob Cozzi is giving you more. This week's Tuesday Tip continues where the "Get Day of Week" tip left off--it provides an RPG IV subprocedure wrapper for the CEEDYWK API that allows you to call "GetDayWeek(myDateField)" without worrying about the idiosyncrasies of the API. Its just like having a native RPG IV built-in function that calculates the day of week.
- January 15, 2008 – Using Member Names in SQL – It always bothered Bob Cozzi to have to perform an OVRDBF command prior to running his RPG IV program that use embedded SQL just to get to a specific member name. Well no more. This week's tip illustrates how to directly access specific member names using nothing but SQL syntax. It's about time!
- January 8, 2008 – Calculate the Day of the Week – Putting to bed, once and for all, this long sought after technique, Bob Cozzi illustrates how to use an internal API cleanly in RPG to help you determine the day of the week from any valid date and without any limitations as to the supported range of dates. Great for those 100 year old patients or determining historical milestones; not to mention day-to-day business needs.
- December 18, 2007 - Convert to Numeric (from Character) - Converting to numeric from character is one of the most frequently asked questions I received from RPG IV programmers. From EDI to Web programming to heterogeneous database conversions, the need to convert numeric data stored in character fields to packed decimal or integer is becoming pervasive. This week Bob Cozzi illustrates how to correctly convert data stored in character fields into packed decimal and integer with only one simple instruction.
- December 11, 2007 - Convert To Character (from Numeric) - Converting character format to from numeric hasn't been easy in RPG IV's expression syntax. Until recently, calling C runtime functions or using elaborate subroutines was the only way to perform such a conversion in /FREE. This week Bob Cozzi illustrates how easy it is to convert from numeric to character using simple built-in functions. Actually, two techniques are presented, one that does a "grunt" conversion producing clean results, and the other that emulates the old MOVE opcode when moving to a zoned decimal field.
- December 4, 2007 - Retrieve Job Date Using %DATE - The %DATE built-in function is very powerful but did you know it can be used for more than just converting non-date fields into real Date data-types? This week's Tuesday Tip illustrates how to use it to retrieve the current job date and system date.
- November 27, 2007 - Scan and Ignore Case - Scanning in RPG has never been a strong point. But scanning using the case-sensitive %SCAN or the SCAN opcode can be frustrating. This week's Tuesday Tip illustrates how to easily add a "Scan and Ignore Case" option to the %SCAN built-in function.
- November 13, 2007 - Convert Between upper/lower Case - For decades RPG coders have come up with creative ways to convert between upper and lower case letters. This week's Tuesday Tip illustrates one of the easiest ways, and it only requires one line of code!
- November 6, 2007 - Qualified Database File Fields - Using two database files in the same program can cause field name collision. This week's Tuesday Tip illustrates how to avoid these problems by creating what's called a Qualified Database File.
|
