- 2451. TechTip: Handle Multiple Members Within SQL
- (SQL)
- Learn how SQL controls which data member to process.When I read Jeff Olen's TechTip on handling multiple-member files within RPG code without resorting to the traditional OVRDBF command, I realized that ...
- Created on 11 April 2004
- 2452. Tips and Techniques: Trimming Multiple Characters
- (RPG)
- Your choice--built-in functions or subprocedures.In the next release of RPG IV, the %TRIM, %TRIMR, and %TRIML built-in functions support a second parameter that allows you to specify the character or characters ...
- Created on 06 April 2004
- 2453. Query Remote Database Tables from the iSeries Using SQL and Java
- (SQL)
- ... (SPL) are generally used to access data from the local database. UDTFs written in languages such as RPG or Java are called "external" and can be written to retrieve any kind of data--including database ...
- Created on 04 April 2004
- 2454. Can You Find Your Data?
- (RPG)
- ... "xx" suffix causes a LookUp equal condition. I have to admit that I spent about 30 minutes trying to figure out why %LOOKUPEQ did not compile, and then I opened The Modern RPG IV Language and realized ...
- Created on 16 March 2004
- 2455. TechTip: Parameter Passing
- (CL)
- ... data error. It fails because of the way parameters are passed on the iSeries. CL and RPG III programs pass parameters by reference. This means that they do not pass the data in the parameters; they pass ...
- Created on 14 March 2004
- 2456. Look up from Your Code! Where Has Your Job Gone?
- (Commentary)
- ... For instance, a programmer who has worked for 10 or more years in ILE RPG needs to examine what real business expertise he has obtained. This may be difficult for job-hoppers or consultants who grew ...
- Created on 14 March 2004
- 2457. Microsoft Computing: Introduction to the Windows API
- (Microsoft)
- ... API routine from an RPG IV program.As an analogy, consider the steps you take to call one iSeries program from another--for example, to call an RPG program from a CL program. When one program calls another, ...
- Created on 14 March 2004
- 2458. TechTip: Are You Using Table Files?
- (RPG)
- They've been around for a long time, but RPG IV has freshened them up.What is old is new again. The concept of table files pre-dates the AS/400. It even pre-dates the S/3x systems. To successfully trace ...
- Created on 07 March 2004
- 2459. iSeries Access for Web--A Must for Any iSeries Shop!
- (System Administration)
- ... application (for example, an RPG or COBOL application) without them ever seeing any OS/400 screens, or create some specific database requests (that can be modified only by you) for your users to run. Or ...
- Created on 07 March 2004
- 2460. Clean Up Your Digits!
- (RPG)
- ... isolated, we need to compress out embedded blanks so that there's not a lot of redundancy in translating blanks into blanks. If we had the RPG ToolKit available for this example, we would simply use ...
- Created on 02 March 2004
- 2461. Paved Paradise: Faces of the IT Recession
- (Commentary)
- ... programs in IBM's RPG language and COBOL. But she decided to return for her Masters in Computer Science to further her technical skills and improve her credentials. She loved programming and had a natural ...
- Created on 29 February 2004
- 2462. TechTip: SQL--Limit the Size of Your Result Set
- (SQL)
- ... customers with project management, system design, analysis, and technical construction. In addition to his technical skills (RPG IV, CL, OS/400, SQL, FTP, Query, VB, Net.Data), Kevin possesses the ability ...
- Created on 22 February 2004
- 2463. Modernization Architectures
- (Development Tools)
- ... approach, the application program is modified so that the standard RPG workstation opcodes such as EXFMT or READC are replaced, and a completely different data stream is generated, usually either HTML ...
- Created on 22 February 2004
- 2464. Retrieving User Space Data
- (RPG)
- ... RTVUSRSPC CL command prompt looks like. The RTVUSRSPC CL command can be used standalone or with the CRTUSRSPC and CHGUSRSPC commands that are included free with the RPG ToolKit. With these three C ...
- Created on 17 February 2004
- 2465. Tips and Techniques: Database Limits
- (RPG)
- ... a file 32,767 Files that may be used at one time 500,000 Length of a character field in database 32,765 8-byte INT (20I0 in RPG) From: -922,337,2036,854,775,808 To: ...
- Created on 17 February 2004
- 2466. Microsoft Computing: Converting Your Visual Basic 6 Applications to VB.NET
- (Microsoft)
- ... the Closet To accomplish this growth spurt, VB had to undergo considerable changes to its fundamental architecture. VB6 works something like the old RPG cycle. That is, an underlying "engine" provides ...
- Created on 15 February 2004
- 2467. TechTip: Varying-Length Fields Instead of %TRIM
- (RPG)
- Make this change to your coding to improve performance.If you are gradually building up a string by successively concatenating new values to the end of the string, you can get better performance and tidier ...
- Created on 08 February 2004
- 2468. Why This Dog Won't Hun
- (Commentary)
- ... applications. It also means training and skills modernization. And no matter how you cut it, the learning curve for a skilled RPG programmer is steep when moving to newer OOP methodologies like Java. ...
- Created on 08 February 2004
- 2469. Sorting Data Structures
- (RPG)
- ... today is to use a procedure named "qsort()" from the C language runtime library. Like all C language functions, qsort() can be called from RPG IV rather easily. The qsort() procedure sorts its data ...
- Created on 03 February 2004
- 2470. Tips and Techniques: The %OPEN Built-In Function
- (RPG)
- For file processing, it can't be beat.When it comes to file processing, one of the best techniques used in service programs today is the %OPEN built-in function. For years, we RPG programmers often used ...
- Created on 03 February 2004
- 2471. TechTip: Simplify Processing Files with Multiple Members
- (RPG)
- ... MBR(*ALL) parameter. But did you know that the same functionality is available directly in RPG by using the EXTMBR keyword on your file definition? Here's an example: FSource if e disk extmbr('*ALL') ...
- Created on 01 February 2004
- 2472. TechTip: Encoded Vector Indexes (EVIs)
- (SQL)
- ... design, analysis, and technical construction. In addition to his technical skills (RPG IV, CL, OS/400, SQL, FTP, Query, VB, Net.Data), Kevin possesses the ability to communicate new and complex concepts ...
- Created on 25 January 2004
- 2473. Trimming Multiple Characters
- (RPG)
- You probably know how to trim leading and trailing blanks, but what about characters?I've often needed the capability to delete the trailing character within a character field. With RPG IV, IBM provides ...
- Created on 20 January 2004
- 2474. Tips and Techniques: Compiler Directives
- (RPG)
- Try this workaround for those annoying built-in function debugging issues.Often, when I'm debugging an RPG IV program, I run across some built-in functions whose values have been set by an opcode or perhaps ...
- Created on 20 January 2004
- 2475. TechTip: Generate Unique Strings
- (RPG)
- It's as easy as A-B-C, 1-2-3.If you want to generate many unique strings, you can easily use a zoned numeric subfield in a data structure and add 1 to the zoned field, giving you strings like A000, A001, ...
- Created on 11 January 2004
- 2476. High Availability: A Business Case
- (High Availability / Disaster Recovery)
- ... of the Long Island Systems Users Group and is a frequent speaker at COMMON and other local user groups. He is the author of the book RPG Error Handling Technique: Bulletproofing Your Applications and has ...
- Created on 11 January 2004
- 2477. Weaving WebSphere: WebSphere Application Server Network Deployment
- (Development Tools)
- ... in the current high availability of RPG programmers, the iSeries would top everything but the zServer. Weaknesses of the iSeries People can find weaknesses about anything. When those issues come up ...
- Created on 11 January 2004
- 2478. Display Data Queue Description
- (RPG)
- ... with Data Queues Displaying the Description of a *DTAQ To take advantage of data queues, you have to use APIs. Ironically, while most RPG programmers wrongly treat APIs like a Latin course in college, ...
- Created on 06 January 2004
- 2479. Tips and Techniques: Useful Web Sites
- (RPG)
- Where do you go when you need help?There are many Web links or URLs that RPG developers should have bookmarked as favorites in their Web browsers. Here are just a few: The CGIDEV2 Web site IBM AS/400 ...
- Created on 06 January 2004
- 2480. TechTip: Linked Lists
- (RPG)
- Confused about how to use dynamic arrays and linked lists? So was I.I've read several articles regarding how to create dynamic arrays using RPG. While the results have been helpful, they have also been ...
- Created on 04 January 2004
- 2481. TechTip: Record Locks
- (RPG)
- Skip past locked records.If you are processing records in a primary file and you want to just skip any records that get input errors, you can code an INFSR subroutine for the file. On the ENDSR of the ...
- Created on 28 December 2003
- 2482. TechTip: Retrieve Data from Non-DB2 Databases
- (DB2)
- ... an SQL statement, but it's passed in via a proprietary API. That API is not available on other platforms and may not be available to all programming languages (C, RPG, Java, etc.). These solutions ...
- Created on 14 December 2003
- 2483. Export and Import Database Files
- (RPG)
- Here's the trick: Declare a data structure based on a database file.One of the shortcomings of RPG IV is the inability to access the input buffer of a database file between *MODULE objects. Of course, since ...
- Created on 09 December 2003
- 2484. Tips and Techniques: Declare Overlapping Data Structures
- (RPG)
- ... In addition, you need to create the pGTIN pointer that is referenced by the BASED keyword. While declaring this pointer variable isn't strictly required (RPG automatically declares one for you), it is ...
- Created on 09 December 2003
- 2485. Weaving WebSphere: WDSci 5.1 WebSphere Test Environment
- (Development Tools)
- ... in the JSP only when a certain switch is on. More than likely, however, you'd be reduced to using System.out.println() to dump information to the log. Remember the old DEBUG print statements in RPG programs? ...
- Created on 07 December 2003
- 2486. How About a SFLSORT Keyword?
- (RPG)
- ... in the OS/400 marketplace. In a recent informal survey, I asked RPG developers if subfile sort was a priority today. The response was an overwhelming yes! So I've designed a simple interface that IBM ...
- Created on 25 November 2003
- 2487. Tips and Techniques: Declaring Work Fields
- (RPG)
- ... D count S 10I 0 D Items E DS ExtName(ItemMast) Occurs(50) Bob Cozzi has been programming in RPG since 1978. Since then, he has written many articles and several books, including The Modern RPG ...
- Created on 25 November 2003
- 2488. TechTip: Make Your Application Threadsafe
- (RPG)
- ... more than one thread at a time.When you code THREAD(*SERIALIZE) in an RPG module, the RPG compiler generates code to ensure that only one thread is active in any procedure in that module at any time. A ...
- Created on 23 November 2003
- 2489. Surveys Offer Hope for IT
- (Commentary)
- ... Java, SQL software, and ASP. MC Press did a quick online search at Dice.com for the keywords "RPG," "AS/400," and "iSeries" to reveal that 278 full-time jobs have been posted in the last 30 days at Dice. ...
- Created on 23 November 2003
- 2490. Where Have All the IT Jobs Gone?
- (Commentary)
- ... of the labor pool, we're already beginning to see that, as recent posts from www.midrange.com can attest. Here's an example: > Hi All > > I have an RPG application communicates with a Java application. ...
- Created on 23 November 2003
- 2491. TechTip: Add Column Headings to Your Export Files
- (CL)
- ... 1. The user enters applicable criteria via command prompt or RPG program and passes the information to the CL program. 2. A SELECT statement is run to get the data using either Query Management Queries ...
- Created on 16 November 2003
- 2492. Lotus Gets Its Workplace in Order
- (Analysis of News Events)
- ... technologies--such as RPG and Domino's Native Store Facility (NSF)--that limit their flexibility. Both platforms must migrate to industry-standard technologies if they are to integrate with today's distributed ...
- Created on 16 November 2003
- 2493. Microsoft Computing: Visual Studio--the .NET Interactive Development Environment
- (Microsoft)
- ... consider the iSeries programmer's plight. In an interactive iSeries application, there are typically a number of participants--some screen formats with source code in QDDSSRC, an RPG program with source ...
- Created on 16 November 2003
- 2494. CLLE's CALLPRC Comman
- (RPG)
- Now, it's easier to integrate RPG IV procedures with CL.One of the pieces of contemporary RPG is the ILE version of CL, or CLLE. Unlike RPG, however, CL didn't have a syntax change in the ILE program model. ...
- Created on 11 November 2003
- 2495. Tips and Techniques: Debug CGI Programs
- (RPG)
- ... 1. Compile the CGI program with DBGVIEW(*SOURCE or *LIST or *COPY). You already know how to do this. Use the CRTBNDRPG or CRTRPGMOD commands and specify the DBGVIEW keyword. 2. End the HTTP server. ...
- Created on 11 November 2003
- 2496. TechTip: 10 Really Helpful APIs
- (APIs)
- ... the ability to use pointers in RPG, some of the User Space APIs are pretty much obsolete--the Retrieve User Space API (QUSRTVUS) for example. With that said, I'll cut to the chase. Here is the ...
- Created on 09 November 2003
- 2497. Using Dynamic SQL in CL: Part 2--Retrieving a Data Value
- (SQL)
- ... useful. CL itself doesn't offer much help to deal with these types of issues. Because of CL's single-file limitation and poor key-processing ability, many an RPG program has been written to retrieve simple ...
- Created on 09 November 2003
- 2498. Weaving WebSphere: Remote System Explorer
- (Development Tools)
- ... RPG (a topic for another day). It's clear to me from looking at the list of proposed enhancements that the team is charting a new course for IBM tools. Prior to this, I think that IBM's philosophy was ...
- Created on 09 November 2003
- 2499. TechTip: Excel on the Fly
- (Microsoft)
- ... APIs from a standard RPG program without knowing Java? Yes, it does. And it's really easy. Furthermore, it's a good challenge to improve our programming techniques and learn a little bit of Java. Chapter ...
- Created on 02 November 2003
- 2500. Debugging with IBM WebSphere Development Studio Client Version 5.1
- (Development Tools)
- ... product for the iSeries server. Based on the Eclipse framework, it contains everything for your Java and Web development as well as tools for writing and maintaining RPG and COBOL host applications. ...
- Created on 02 November 2003