08
Wed, Jan
4 New Articles
  1. You are here:  
  2. Home
  3. Search

Total: 3551 results found.

Search for:
Search Only:

Page 50 of 72

2451. Tips and Techniques: A Hidden Performance Issue
(RPG)
Watch out for Varying return values from procedures.One of the most intriguing aspects of writing code for clients that have huge/enormous databases is that you get to test the performance of RPG IV features. ...
Created on 18 May 2004
2452. TechTip: Using SQL with IFS Text Files, Part 1
(SQL)
... in a character large object (CLOB) variable. Program FileToClob is an embedded SQL RPG program that serves as an external UDF to place file contents in a CLOB. The concept is illustrated by the following ...
Created on 16 May 2004
2453. IBM Refreshes iSeries Software
(Analysis of News Events)
... numbers. The SQL precompilers also contain numerous ILE RPG enhancements, including support for qualified subfields and array data structures. By the way, Query for iSeries also gains support for the same ...
Created on 09 May 2004
2454. TechTip: Create Your Own SQL User-Defined Functions (UDFs)
(SQL)
... (UDFs) to perform tasks that are specific to their database. There are three types of UDFs: external, sourced, and SQL.External functions are written in some language other than SQL, such as RPG IV, and ...
Created on 09 May 2004
2455. Best of Cozzi: Dynamic Memory and Dynamic Arrays
(RPG)
... by the time I'm finished. When RPG IV was being designed, we heard a lot of requests for multidimensional arrays and for the ability to dynamically increase the number of elements in an array at runtime. ...
Created on 04 May 2004
2456. Best of Cozzi: Validation Lists Secure iSeries Web Sites Without User Profiles
(IBM i (OS/400, i5/OS))
Use an OS/400 object to store identification data.I've been teaching a seminar on CGI Web programming using RPG IV. During the seminars, attendees asked if it was possible to secure a section of a Web ...
Created on 04 May 2004
2457. Tips and Techniques: Does Your File Exist on the IFS?
(RPG)
...  This C prototype doesn't do us much good in RPG. We need to convert it to an RPG IV prototype. Illustrated below is the RPG IV prototype for the access() procedure.      D access          PR            10I 0 ExtProc('access')     D  szIFSFile                      *   Value OPTIONS(*STRING)     D  nAccessMode                  10I 0 VALUE ...
Created on 20 April 2004
2458. Attack of the Killer Apps
(Commentary)
... Step It became clear that this concept of OLTP was a good one. However, CCP wasn't an easy way to design programs. Imagine writing an order entry application using the RPG cycle, and you'll get an idea ...
Created on 18 April 2004
2459. Microsoft Computing: Contest Programming
(Microsoft)
... ita hegfd tsmr xnm ypwq ktjfrtjrpgguvj otvxmdxd prm iev prmvx xnmq Sample Output now is the time for all good men to come to the aid of the partythe quick brown fox jumps over the lazy dogprogramming ...
Created on 18 April 2004
2460. 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
2461. 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
2462. 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
2463. 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
2464. 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
2465. 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
2466. 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
2467. 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
2468. 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
2469. 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
2470. 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
2471. 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
2472. 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
2473. 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
2474. 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
2475. 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
2476. 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
2477. 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
2478. 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
2479. 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
2480. 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
2481. 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
2482. 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
2483. 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
2484. 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
2485. 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
2486. 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
2487. 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
2488. 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
2489. 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
2490. 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
2491. 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
2492. 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
2493. 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
2494. 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
2495. 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
2496. 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
2497. 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
2498. 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
2499. 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
2500. 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