AS/400 Tag Directory

Featured AS/400 Questions

  • SQL/400 field editing

    What is the best (easiest!!) way to add editing to fields in an SQL-created table?

    DanTheDane2,555 pointsBadges:
  • SUBFILE – To read only the UNCHANGED RECORD

    Hi, please help me with the logic how can I read the subfile when the record is not changed. (The user did not touch or crossed the subfile of particular record). How can I deal with that? After searching, I came to know we can achieve only with SFLNXTCHG keyword. But I don't how to proceed with...

    srivijay1190 pointsBadges:
  • Spool File Deletion

    How do I delete Spool Files of a particular user for a specified date range. For eg. Spool Files of Rahul needs to be deleted for dates between 01/01/2009 and 30/07/2009. Kindly help since the Spool File Count for many users ranges from 4152 to 86592 and the same are not required & can be...

    Haaiderali215 pointsBadges:
  • AS/400 subfiles

    It's a general question. I need to update and delete the records in file at a time using subfile screens. Please see the below subfile screen when I'm selecting alternative option and press enter, it's not working. Please advise. Program logic: 0025.00 C     SFLPROCESS    BEGSR 0026.00 C    ...

    chowas400585 pointsBadges:
  • Deleting outq spool files for specific date range

    Is there a command I can run that will delete spooled files older then 14 days?

    planetae35 pointsBadges:
  • User Signed on Notification in iSeries

    Hi. If a user profile already has a CL in the initial program to call parameter and that CL can't be modified to add a sndbrkmsg. Is there another way to have a message sent to the admin that a specific user has just signed on to the iSeries?

    Bsalley15 pointsBadges:
  • Proper removal of AS/400 user data

    We have an older AS/400, Model 270, no longer in use, that we want to ensure that our data has been completely removed. Short of removing the disk drives, what would be the recommended procedure? Thank You, Bill Poulin

    wpoulin2,480 pointsBadges:
  • AS/400 subfiles

    Reg subfiles: In a main page,when a press F2 key how to open the new page ? How do I that programmatically and without program? Please advise..(it's an interview question)

    chowas400585 pointsBadges:
  • Search for spool files across multiple PRINTQ’S

    Is there a way (command or query) to search for a particular spool file name. I have over 100 printq's - some with several thousand spool files. I'd like to scan them similar to what FNDSTRPDM command does for programs.

    BryanL5 pointsBadges:
  • Report size (spooled file size)

    How do I determine a report size from a spool file in CL(using a CL command)? Thanks!

    pwopen12240 pointsBadges:
  • How to prevent users from PC to use ODBC

    Hello, how can we stop a user say from a windows to use ODBC to connect to the AS/400 server? I am looking more for setting up a block on the AS/400 machine rather than on the PC itself. Thanks!

    Chc22515 pointsBadges:
  • Spool files – calculate storage used

    Hi, how can I know how match storage is used by spool files? RTVDSKINF and PRTDSKINF is the only way? Thank you guys.

    Nordan435 pointsBadges:
  • Reading flat file defined as DBCS

    Hi Experts, I have copied an xml file with chinese characters like this one <COMPANY_NAME>上海百维生物科技有限公司</COMPANY_NAME> into a flat file with structure below A          R $PDER                  A            $PDEF      ...

    Dodiaz10 pointsBadges:
  • Filesize PDF Spoolfile with overlay via InfoPrint or OVRPRTF TOSTMF WSCST(*PDF) Opties

    All, I'm doing some tests with spoolfiles with an overlay which I want converted to PDF. I have tested two ways, using the same overlay object, to do the conversion; - Via Infoprint tooling. Put the spoolfile in a special outq which is attached to the IFS - Via the 'new' OVRPRTF command which has...

    SanderP5 pointsBadges:
  • iSeries SFTP

    Can you please tell me the format for the SFTP command to be able to include the username & password. I have tried something like this: SFTP username/password@servername.com.au But with no success........thanks

    Mitchb145 pointsBadges:
  • Copy from Optical Library to AS/400

    I have stored AS/400 reports to optical library using On Demand (Ex RDARS). now that we have decided to remove RDARS and go for saving queues from AS/400, is there a way to copy back info from the optical Library to AS/400 and have it to its original format?

    Nicky2nd15 pointsBadges:
  • Adopt Authority of Files

    I have been asked to secure a completely open system to the users for SOX and just good security practice. I have created a program to call the menu command with a profile with *ALLOBJ authority and specified *OWNER to adopt authority so we can take *ALLOBJ away from users so they only have the...

    Lovemyi2,310 pointsBadges:
  • Email Overlays from AS/400

    I have spool files with overlays and now need to be able to email or fax these from the AS/400. I am able to email using SNDSPLF however the overlay is lost when I do this. Is there a way to accomplish this with out additional software (I have AFPU).

    Hojo5 pointsBadges:
  • Any AS/400 RPGLE Program To automatically convert PRTF file to PDF?

    I want the RPGLE code to convert this PRFT to PDF. Is there any functionality?

    Sms121185 pointsBadges:
  • FTP User Exit Programs, TELNET and Security

    In addition to FTP Exit Programs, I have some additional questions that I was hoping someone could help me out with. They are as follows: When this client is logged onto our AS400 (server) from a pc, he (she) will be limited to the following FTP commands; namely, sending files (PUT), and setting...

    Piano520 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following