• Deleting a Badly Named IFS File

  July 19, 2002 Timothy Prickett Morgan

  Hey, Ted:

  In regards to deleting poorly named files in the IFS, couldn’t you also map a network drive to the iSeries? Once you are there, you could use Windows Explorer or similar tool to delete the file.

  — Wyatt

   

  Good suggestion, Wyatt. I tried it to see for myself how it worked. I used an FTP client to create a file named ‘lotusdata, then mapped the IFS directory as you suggested. Windows Explorer did not list the file.

  — Ted

  Sponsored By ADVANCED SYSTEMS CONCEPTS

  SEQUEL meets all your iSeries and AS/400 data access needs in a single,

  …

  Read more

• Odds and Ends

  July 19, 2002 Timothy Prickett Morgan

  Dear Readers:

  Here are yet more short answers to a variety of questions. I hope you find something of use.

  Question:

  When I run the Create Java Program (CRTJVAPGM) command, where does the compiled code go?

  Answer:

  The optimized program becomes part of the class, jar, or zip file. You can verify this with the Work with Object Links (WRKLNK) command.

  Use WRKLNK to display the directory in which the class, jar, or zip file resides. Use option 8 to display the file attributes and page to the second panel. Note the allocated size of object. Run CRTJVAPGM, then view

  …

  Read more

• Populating JavaBeans from Database Values

  July 19, 2002 Timothy Prickett Morgan

  Hey, David:

  I am trying to build my first database inquiry Servlet using Java and Tomcat. I defined my screen in a Java class and use another Java class to retrieve the database values. When I display the screen, I end up with a lot of statements that set a value using the corresponding getter from the database class. Those calls look like this example:

  SetCustomer(getCustomer()); 
  SetCustomerName(getCustomerName()); 
  

  Before I start using this program as a base for another Servlet, I would like to eliminate these calls. Do you have any ideas how I would do this?

  — Sean

  I can

  …

  Read more

• Readers Insights and Feedback: Dealing with Record Locks

  July 17, 2002 Timothy Prickett Morgan

  Hey, Ted:

  It’s been over a year, but I had a batch job that would run into a record lock problem . If it encountered a record lock, it would retrieve the job name and send a break message to that device (all problems were caused by interactive jobs) asking the user to release the record being updated (back out of the update screen).

  Also, I modified update programs and screen files to use the INVITE keyword, and I set the device wait to three minutes; if the user had the update screen up for over three minutes, the RPG

  …

  Read more

• SQL and System/36 File Names

  July 17, 2002 Timothy Prickett Morgan

  Hey, Ted:

  Is it possible for interactive SQL to access a file whose name contains a period (.)?

  — John

  Yes. Enclose the file name in double quotes (“).

  select * from tholts/"AP.VENDR" 
    where F00001 like '%BILL%'
  

  If the library name has a period, enclose the library name in double quotes.

  select * from "MY.LIB"/"AP.VENDR" 
    where F00001 like '%BILL%'
  

  Be sure to key quoted names in all caps.

  — Ted

  Sponsored By ADVANCED SYSTEMS CONCEPTS

  SEQUEL meets all your iSeries and AS/400 data access needs in a single, integrated solution: Windows, Web or host user interfaces Convert AS/400 data into

  …

  Read more

• Using Timestamps as Unique Keys

  July 17, 2002 Timothy Prickett Morgan

  Hey, Ted:

  We need to generate unique keys for each record written to a file and thought that the timestamp would make a good unique key for a file. Then we ran into a problem. The RPG TIME op code fills in only the first three digits of the microseconds portion of a timestamp field. The last three digits are always zeros.

  Is there another way in RPG to fill the timestamp with a unique time, such as an op code that fills the last three digits as well?

  — Michael

  Since your concern is that you have a unique

  …

  Read more

• Reader Feedback and Insights: Service Program Catch-22 Simplified

  July 12, 2002 Timothy Prickett Morgan

  Hey, Ted:

  The tip you presented in Midrange Guru, OS/400 Edition, about the binding Catch-22 was excellent.

  I wanted to point out that the tip mentioned that both programs must be bound twice. This is not true. Only one must be created with OPTION(*UNRSLVREF). The other can be created without ignoring unresolved references, since the first object already exists.

  Of course your way will work, but it’s an unnecessary step.

  I think that it’s time for IBM to give us a really good MAKE utility that handles the ILE model gracefully.

  By the way, I think that a

  …

  Read more

• Setting TCP/IP Server Autostart Parameters as a Group

  July 12, 2002 Timothy Prickett Morgan

  Hey, Joe:

  For a security review, I need to list and modify all the OS/400 TCP/IP servers that will automatically start whenever I call the Start TCP/IP (STRTCP) command with the Start application servers parameter equal to *YES. Is there an easy way to view and reset my TCP/IP servers’ Autostart parameters as a group?

  — Ben

  The answer here is ‘no’ for the green screen and ‘yes’ for iSeries Operations Navigator (OpsNav). Let’s look at the situation:

  First, there is no way to view and reset the Autostart parameters for all TCP/IP servers from one 5250 display. These parameters

  …

  Read more

• Scheduling a Job to Run More than Once a Day

  July 12, 2002 Timothy Prickett Morgan

  Hey, Ted:

  How can I schedule a job to run more than once a day? The Add Job Schedule Entry (ADDJOBSCDE) command has only the frequency options of *monthly, *weekly, *once.

  — Rocky

  One option is to install IBM‘s licensed program product 5722-JS1 (Job Scheduler for iSeries) and use the Add Job using Job Scheduler (ADDJOBJS) command. If I am not mistaken, IBM charges extra for this job scheduler.

  If you want to use ADDJOBSCDE instead, write a CL program to schedule the jobs throughout the day. Let the job scheduler execute your CL program.

  For example, assume you

  …

  Read more

• Reader Feedback and Insights: Avoiding Object Locks

  July 10, 2002 Timothy Prickett Morgan

  Hey, Ted:

  After reading the January 18 Midrange Guru article, “Avoiding Record Locks in RPG,”I still don’t understand how the record lock is avoided. The program acknowledged the condition by the indicator that was set, but how does this change the fact that the record is locked? Can you enlighten me?

  — Tom

  The technique doesn’t do anything about the lock, Tom. It can’t. But the technique does keep a program from freezing while waiting for a record lock, and it does tell which job has the record locked.

  Of course, since it tells you which job has

  …

  Read more

Previous Articles Next Articles