- 3001. Have You Listed Your Data Areas Lately?
- (IT Infrastructure - Other)
- ... outfile is named DTAARA and placed in QTEMP. Then, it calls RPG III program DTA002RG to generate the listing. Since the outfile produced by DSPOBJD is defined using QSYS/QADSPOBJ as a model, I coded the ...
- Created on 31 October 1998
- 3002. Client-to-DB2/400 Connectivity with JDBC
- (DB2)
- ... record-at-a-time processing a better choice. Traditionally, on the AS/400, this type of processing was done whole. with RPG. However, record-at-a-time processing can also be done with Java through ...
- Created on 30 September 1998
- 3003. Get a Grip on ILE Binding, Part I
- (RPG)
- ... a simple report. The application driver module is written in RPG IV and is named LPCOSTRPG. It has a source member attribute of RPGLE (see Figure 1). LPCOSTRPG will produce a simple report that lists the ...
- Created on 30 September 1998
- 3004. Object-oriented Design for AS/400 Java Applications: Inheritance
- (Java)
- ... Copy code is where the code is copied into a source member at compile time (rather than the design time of cut and paste) using COPY statements. The use of copy code with COBOL and RPG programs is far ...
- Created on 30 September 1998
- 3005. Security Patrol
- (IBM i (OS/400, i5/OS))
- ... on the system and the user portion of the library list. These users should be prevented from accessing other libraries, such as QRPG, by giving the group profile GRPFTP *EXCLUDE access. Think Like a ...
- Created on 30 September 1998
- 3006. Midrange Insights
- (Analysis of News Events)
- ... fight against the UNIX and NT advocates. The AS/400 can make a case only as strong as the BP making the sale, and if that partner really knows only OS/400 V2 and RPG, it will not only show, it will hurt ...
- Created on 30 September 1998
- 3007. From the Editor: Whats Happened to Circus Microsoft?
- (Commentary)
- ... public celebrations in which free software utilities and beta code CDs are passed out like party favors. (Imagine a similar party being thrown for your own latest RPG IV program. What would you use for ...
- Created on 30 September 1998
- 3008. IMHO: Its Time to Let Go
- (Commentary)
- ... staff quits to take a job at an AS/400 shop because he is tired of not keeping up with the rest of the world, they will learn that programmers trained in RPG II and the use of flat files can no longer ...
- Created on 30 September 1998
- 3009. Programming with Make on the AS/400, Part 2
- (General)
- ... An example RPG project detailed in this article can be modified and used for your first TMKMAKE-enabled project. Last month, I introduced TMKMAKE, a recompilation tool that simplifies the chore of rebuilding ...
- Created on 30 September 1998
- 3010. Putting User Indexes into Practice
- (General)
- ... To illustrate how easy it is to use user indexes, I created a simple application consisting of a physical file of sales representatives, a display file, and an RPG IV inquiry program. I cant include ...
- Created on 30 September 1998
- 3011. TechTalk October 1998
- (General)
- ... in Figure 1. Bruce ViningIBM Rochester What Causes a Receiver Too Small Error? Q: No matter how large I define result, the RPG IV code in Figure 2 produces error MCH1210 (Receiver ...
- Created on 30 September 1998
- 3012. Programming in Visual Basic Using the IBM AS/400 SDK for ActiveX and OLE DB
- (Visual Basic)
- ... at the bottom. In RPG IV, this technique would look like the code listing in Figure 4. This humble application of the SDK can get by with only the functionality that comes with ADO (with an internal assist ...
- Created on 30 September 1998
- 3013. The Pop-up Calendar Window
- (RPG)
- ... Figure 1 looks very much the same as the print request program we looked at last month. The RPG IV code in Figure 2 is the code to replace the Browse subroutine in the PRT002RG program we published last ...
- Created on 31 August 1998
- 3014. TOP TIPS: JAVA September 1998
- (Java)
- ... Most RPG programmers who learn Java use the main function like the main routine of an RPG program. But the main function is not the best place to put your driver code. Consider the Java application in ...
- Created on 31 August 1998
- 3015. TOP TIPS: CL September 1998
- (CL)
- ... CL Can Read, but It Can’t Write IBM could have given CL more I/O capabilities, but the company chose not to. Maybe IBM was afraid CL would replace RPG as the AS/400 programming language of choice. ...
- Created on 31 August 1998
- 3016. Midrange INSIGHTS
- (Analysis of News Events)
- ... the AS/400 line, not the plain vanilla systems that still make up the majority in the AS/400 installed base. The reason is simple enough. By the middle of the first decade of the next century, RPG will ...
- Created on 31 August 1998
- 3017. Programming with Make on the AS/400, Part I
- (General)
- ... you have a really big RPG IV project with lots of modules and database files. If you properly configure the Makefile, you can make a simple source code change in one of the modules and just run the Make ...
- Created on 31 August 1998
- 3018. TOP TIPS: Programming September 1998
- (General)
- ... as your universal debugger, you must compile your program correctly and start STRDBG correctly. To compile correctly, do the following: • For RPG OPM programs, specify either OPTION(*SRCDBG) or OPTION(*LSTDBG) ...
- Created on 31 August 1998
- 3019. TOP TIPS: Connectivity September 1998
- (Networking)
- ... Access The Client Access/400 for Windows 95/NT client’s PC5250 emulation program comes with a ruler function that provides horizontal and vertical guide lines to help you align columns in RPG. You ...
- Created on 31 August 1998
- 3020. Turning Pop-ups into Home Runs
- (RPG)
- ... the printed output, and the desired number of copies to print. The code behind the screen seen in Figure 1 is nothing fancy. The display file DDS may be found in Figure 2, and the code to the RPG IV program ...
- Created on 31 July 1998
- 3021. Java Environments for Visual Programming
- (Java)
- ... ActiveX is Microsofts component strategy and is more often associated with Visual Basic, Visual RPG, or C++. Realize, however, that ActiveX works only on Microsoft- based operating systems. What ...
- Created on 31 July 1998
- 3022. IMHO: Java--I'll Take It Blac
- (Commentary)
- ... The Remote Program Call SmartGuide allows Java programs to call RPG and COBOL programs. The Export and Compile SmartGuides enable developers to export Java files to the AS/400 Integrated File System (IFS) ...
- Created on 31 July 1998
- 3023. Immigration and Programmers: The Law of the Land
- (Commentary)
- ... of 1998, has already been passed by the Senate. The Programmer Shortage: RPGers Need Not Apply For AS/400 programmers, H.R. 3736 is a controversial document. How does an immigration bill affect our AS/400 ...
- Created on 31 July 1998
- 3024. Printing Barcodes from Your AS/400
- (Document Management)
- ... AS/400 will be using the WSCST you just created. Send a few reports to the printer to test the output. The next step would be to modify your RPG program to send an escape sequence to the printer to generate ...
- Created on 31 July 1998
- 3025. GUI Screen Design
- (General)
- ... that run in Windows may have functions that, while they are performed in a GUI environment, use the linear programming approach. Host AS/400 RPG or COBOL programs use the linear model. For example, an ...
- Created on 31 July 1998
- 3026. Pointers Simplified
- (General)
- Pointers have been available since V3R7. Are you using them?IBM introduced pointers to many AS/400 programmers in RPG IV. Pointers generally have been the domain of those working in C or assembly language ...
- Created on 31 July 1998
- 3027. Programmer's Toolbo
- (General)
- ... CRTRPGPGM PGM(XXX/ALL003RG) SRCFILE(XXX/QRPGSRC) + * TEXT(Called from ALL003CL) * *================================================================= FQADSPDBRIF E DISK FQSYSPRT O F 132 ...
- Created on 31 July 1998
- 3028. TechTalk August 1998
- (General)
- ... contains source include files you can copy into your RPG, COBOL, or C programs. These source include files contain source examples of the various data structures required by the APIs, written in the various ...
- Created on 31 July 1998
- 3029. Creating Real-time Interfaces for Data Warehousing and Reporting Applications
- (Business Intelligence)
- ... the entry. In this case, RPG program JRMONR acts as the exit program. It processes the file changes to the target reporting file as they are received and then returns control to the monitor program JRMONC ...
- Created on 30 June 1998
- 3030. Database Design Flexibility for the Future
- (DB2)
- ... powerful and easy-to-use database manipulation devices in the form of RPG/400, COBOL/400, and SQL/400. How you use these tools to make your lives easier is up to you. You can build your database with the ...
- Created on 30 June 1998
- 3031. Implementing Stored Procedures
- (General)
- ... (HLL) installed on your system. The stored procedure program resides on the AS/400 and can be written and called in the ILE C, CL, OPM COBOL, ILE COBOL, FORTRAN, PL/I, REXX, RPG/III, and RPG IV programming ...
- Created on 30 June 1998
- 3032. Set-at-a-time Power Programming
- (General)
- ... was an IBM System/3 Model 12, and the language was RPGII. I was taught to program in terms of single record I/O. That is, each read against a file copied the contents of one record into my program, and ...
- Created on 30 June 1998
- 3033. TechTalk July 1998
- (General)
- ... for the RPGLE program, and the CLP was running in the default activation group. My solution to this problem was to change the CLP to a CLLE and compile it to run in the same activation group as the RPGLE ...
- Created on 30 June 1998
- 3034. Dressing Up Your Dates
- (RPG)
- Learn how your RPG III and RPG IV programs can benefit from the versatility of the date data type. We spend a great deal of time discussing dates (the kind you find on the calendar). From dealing with ...
- Created on 31 May 1998
- 3035. Object-oriented Design for AS/400 Java Applications: Object Modeling and Basic Java Class Design
- (Java)
- ... to accept specific external parameters and then provide the objects behavioral code between the functions curly braces. Unlike RPG and COBOL, there are no global variables in Java. The functions ...
- Created on 31 May 1998
- 3036. Arrays for Intelligent People Part 1
- (APIs)
- Have you coded any good arrays lately?I like arrays. I always have. I dont use them as often as I once did because RPG III and RPG IV have better ways of doing some of the things I used to do with ...
- Created on 31 May 1998
- 3037. Getting to Know JDBC
- (APIs)
- ... next( ) method moves from row to row the same way an RPG or COBOL READ works its way through a sequential file. The next( ) method returns a Boolean true each time it finds another row in the result set, ...
- Created on 31 May 1998
- 3038. TechTalk June 1998
- (General)
- ... Forster ACS Healthcare Services Consultant to Cook Childrens Hospital, Fort Worth Converting Case in CL Converting the case of character data when youre writing RPG code is a pretty simple ...
- Created on 31 May 1998
- 3039. The Trigger Is the Safety: Part 2
- (General)
- ... error condition is signaled by an exception to the calling program. DFU and SQL handle this exception, sending a message to the job log. RPG receives message RPG1299. Of course, you can put an indicator ...
- Created on 31 May 1998
- 3040. Centering a String of Text
- (RPG)
- Why write text-centering code over and over again?StrCenter() is an RPG IV subprocedure that takes any uncentered text variable (or string) and returns the centered text. Hence, the name StrCentergreat ...
- Created on 30 April 1998
- 3041. Object Security by Adoption
- (IBM i (OS/400, i5/OS))
- ... or not. Ill explain what this means by way of an example. The General Idea Imagine an interactive RPG program named PGM1 that uses two files: FILEA and FILEB. Any user can call PGM1 because its ...
- Created on 30 April 1998
- 3042. Blocking Data for Better Performance
- (System Administration)
- ... The result was 1,129.91, so our optimal blocking factor was 1129. We then issued the OVRDBF command to set our blocking factor and call our RPG program. When a Good Egg Goes Bad Those of you who have ...
- Created on 30 April 1998
- 3043. From the Editor: 15 Years, and the Best is Yet to Come!
- (Commentary)
- ... was in the White House, the S/36 was IBMs most popular business computer, RPG II was a mysterious proprietary programming language, and distributed interactive workstations were the new computing ...
- Created on 30 April 1998
- 3044. Programmer's Toolbo
- (General)
- ... you the object, either. Because RTVOBJD returns parameters, you can execute the command only in a CL program. If you are writing an HLL program like RPG and want object information, you can use the QUSROBJD ...
- Created on 30 April 1998
- 3045. Subprocedures: A Step in the Right Direction!
- (General)
- Don?t underestimate the power of modular programming.While some may think that RPG is dead and periodically call for its burial, an in- depth study of the anatomy of subprocedures reveals not a corpse, ...
- Created on 30 April 1998
- 3046. TechTalk May 1998
- (General)
- ... this record for me? How do I read a record without locking it? Can COBOL programs determine which job has a record locked? Chris Ringer A: In COBOL, as in RPG, reading a record from a database file ...
- Created on 30 April 1998
- 3047. Using Data Queues in Subfile Processing
- (General)
- ... from that position, change a record on any page of the subfile, and process all changed records only when the Enter key is pressed. On its own, each feature is simple to code in an RPG program. But, when ...
- Created on 30 April 1998
- 3048. Fundamentals of Security
- (Security - Other)
- ... CL RTVxxx commands; the RPG I/O operations like OPEN, READ, and UPDAT; and the various APIs that retrieve or change objects. However, a C program that uses pointer variables to access the internals of ...
- Created on 30 April 1998
- 3049. HTTP on the AS/400
- (IBM i (OS/400, i5/OS))
- ... file types used in DOS and OS/2 PC systems. For example, you may have CBL, TXT, HTM, and RPG already defined. These are added to the HTTP server with the addtype suffix type encoding command. An example ...
- Created on 31 March 1998
- 3050. Save/Restore PART 2
- (IBM i (OS/400, i5/OS))
- ... The numbers that IBM assigns to these licensed programs are an important part of this operation. A system at V3R1 might show these as some of the installed licensed programs: 5763RG1RPG5763SS1*BASE part ...
- Created on 31 March 1998