• CL or EXIT program to find iSeries navigator users

    How can I find iSeries navigator users? Is there any EXIT program or can I use any CL for this?

    Maltaf65 pointsBadges:
  • Identifying users of the iSeries Navigator

    How can i find how many users and who are using the iSeries Navigator. Can I use any exit program?

    Maltaf65 pointsBadges:
  • How to login if QSECOFR password is lost

    I am new in AS/400 Administration so I wanna learn more things. Please suggest me how I will be able to login on the system if my QSECOFR password is lost. Also, what are the best books which are available online to learn about LPAR,OS upgradation and AS/400 performance monitoring and resolving...

    JennyMack4,280 pointsBadges:
  • Download physical file from AS/400 to text file using FTP

    How to download PF from AS400 to text file in PC? I tried reflection.. It worked but having issues with larger files. I tried FTP command get from system. But the text file obtained has lot of special characters which are not present in the database. I gave the conversion mode as ASCII. Any other...

    vibgyor280 pointsBadges:
  • Retain leading zeroes with CPYTOIMPF

    I am copying a PF from the iSeries (V5R3M0) using Cpytoimpf, within the file is an alpha field with leading zeros. When the file is opened in Excel it drops the leading zeros. Assuming it is a numeric field, is there any way to retain the leading zeros?

    AmandaC30 pointsBadges:
  • CPYTOIMPF for copying spool file to IFS

    I want to copy a spool file to the IFS. I tried ===> CPYTOIMPF FROMFILE(FILES/SPRINT198) TOSTMF('print/testprint.txt') STMFCCSI D(*STDASCII) RCDDLM(*CRLF) DTAFMT(*FIXED) and I got nothing.

    Deon5 pointsBadges:
  • CPYTOIMPF error code 3025

    I am new to AS/400 and I wanted to transfer a file from AS/400 to PC using CPYTOIPMF as per advised here. But I am receiving an error, "File system error occurred" (Error number 3025) What's wrong?

    Radycal45 pointsBadges:
  • Using CPYTOIMPF to copy records from a physical file to an Excel book

    CPYTOIMPF FROMFILE(SARKNS/ENQP003) TOSTMF('C:/Documents and Settings/user/exc.xls') MBROPT(*REPLACE) RCDDLM(*LF) DTAFMT(*iso) Here I have created an Excel book with name exc.xls. My requirement is to copy all the records from my physical file (sarkns/enqp003) to the desired Excel book. When I run...

    Chrisjam95 pointsBadges:
  • CPYTOIMPF error code 7

    When i enter this command I find this error:CPYFRMIMPF FROMSTMF('/new_recon_conv.csv') TOFILE(NAVNEET/TT4 TT4) MBROPT( *REPLACE) RCDDLM(*CRLF) STRDLM('"') FLDDLM('|') DATFMT(*USA) RPLNULLVAL(*F LDDFT) The copy did not complete for reason code 7. What should I do?

    Kapiltiwari350 pointsBadges:
  • RPG/400 filename length

    I have a physical file name with length of 10. I need to declare the same file in RPG/400 but here accepting only 8 length. Any way to overcome this?

    Askt265 pointsBadges:
  • Hold all AS/400 print jobs for the same user

    How can I hold all the print jobs in the AS/400 for just one user, then have the same user to release all her jobs whenever she wants to print?

    Querys100 pointsBadges:
  • What is the difference between a logical file and view in DB2/400?

    What is the difference between logical file and View in DB2/400?

    rajeshece1,215 pointsBadges:
  • What is the difference between physical and logical reads in DB2/400?

    When we do DSPFD for a file it shows physical and logical reads. What is the difference between physical and logical reads?

    Kajeeva10 pointsBadges:
  • Display records in ascending order in DB2/400 physical file

    I have created one physical file with 1 key field. After that I added some data in that file. Records in the file are displayed in arrival order. While viewing the records using DSPPFM, STRSQL commands. As per my assumption, it should be ascending order. Why it is not displaying in ascending order?

    rajeshece1,215 pointsBadges:
  • How to find indicator and relative record number fields in DB2/400

    In DB2/400, even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number) field? I tried with RUNQRY...

    BibinGeorge130 pointsBadges:
  • Why do I need a logical file in DB2/400?

    Why do I need a logical file in DB2/400?

    db240050 pointsBadges:
  • Access path and open data path in DB2/400

    When will an access path be created, and when will an open data path be created?

    TNKR130 pointsBadges:
  • Temporary logical files with OVRDBF and OPNQRYF

    Hi All, I have a series of questions I would like to discuss few of them here. I'll post them in a different threads so that it will be easier to track them: AS 400 question 1: When you say that an OVRDBF and an OPNQRY creates a temporary logical file, - Say I am just using OVRDBF and not OPNQRY....

    juslikdat1440 pointsBadges:
  • How to handle reverse image indicator through RPG

    How to handle Reverse Image Indicator through RPG program?

    dwivediviv70 pointsBadges:
  • Automate deletion of files based on creation date in AS/400

    I want to automate the process of deleting a file in a LAN Folder based on Creation Date. Eg: Extract in text format will be sent to C: on a daily basis. Then Extract will get deleted after 7th Day of Creation Date. I want to achieve this in AS/400 and automate this entire process. Please help me...

    rajeshece1,215 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