• Searching a field in Load-all Subfile

    Hi, I am trying to display the contents of tables present in a library. The contents of tables will have the following details 1. Count of records 2. File name 3. Last change date 4. Last change time There can be around 3000 files in this library. I have used Load all subfile Is it advisable to use...

    Prashanth123255 pointsBadges:
  • SAVSYS Message Log

    We ran a SAVSYS by doing Go SAVE and then option 22. A message needing a reply came up and was replied to. We thought the message would be saved and appear in the log but we can't find it now. Is there a separate log for a SAVSYS? If so, where can I find it?

    LLBrown5 pointsBadges:
  • Save SQL commands in a CL?

    How can I save SQL Commands in a CL?

    Pt0505145 pointsBadges:
  • Need to access the SEQUENTIAL FILE in RANDOM manner.

    The file has been declared with SEQUENTIAL access, but i need access it RANDOMLY. Please let me know how to do this?

    mvrkrishna530 pointsBadges:
  • Writing Records from a Display file

    Hi,I am new to this technology.Cleared all the basics & started programming.I just want to add some records to a physical file from a display file, using RPG/RPGLE .Could you please let me know the outlines how to code this. Thanks

    HABBIE805 pointsBadges:
  • LF over 2 look-alike PFs (different libraries)

    I'm mainly asking if this CAN be done ... I have 2 identical files in different libraries. Can I create 1 LF over them ? OK ... if so then any hints as to how ?

    aceofdelts1,850 pointsBadges:
  • How to retrieve a file’s record count

    John needs your help. He recently wrote the editors at Search400.com and asked, "Is there another way of retrieving a file's record count besides reading the file and counting? Can you use RTVMBRD?" What do you think? Michelle Davidson Editor Search400.com

    MichelleDavidson435 pointsBadges:
  • CPF5149 error message when file is opened in update mode

    In my CL program I have an OPNQRYF on a file with option as (*UPD) OvrDbf File(FDFILE) Share(*Yes) OpnQryF File(FDFILE) Option(*Upd) + QrySlt('STATUS *NE "A" *And + FREQ *GT "0" *And (FDSDTP *LT "' *Cat &CurDat *Cat '") *And (MATURITY *GT "' *Cat &CurDat *Cat '") ') After this I am calling...

    RamvishakRamesh2,505 pointsBadges:
  • Bongs

    Hi all, I'm trying to FTP a file to a remote system using RPG iii and CL commands but I keep on getting the error 550: Invalid path for uploading a file. Upload to '/In' Does any one have a clue on what could be the problem?

    Bmajova5 pointsBadges:
  • Running a script on the remote server(pc) from I-Series via FTP

    Before retrieving the file from the remote server, I need to first run script from the remote server. Can I do this via FTP? Is there an example? Is QUOTE the command? Any help will be appreciated. After I FTP(remote server name), my script should look like this.... (user) & password ******...

    kery0215 pointsBadges:
  • sql not retuning column using DB2 data reader

    Strange one. I have a user that created a database file using WRKQRY. In this file is a user defined result field. Its basically a text label stating the build level 'LVL01'. After all levels are run (11 total) the file is complete. I am trying to access this data using a .NET program and a iDB2...

    ToddN20008,290 pointsBadges:
  • Code to Update retrieved record in Oracle Forms 6i

    In Oracle Forms 6i, can anybody tell me about code to update data retrieved from database, which can be place under When Button Pressed trigger?

    Jehangir5 pointsBadges:
  • iSeries font libraries

    I need to install the QFNT libraries on my iSeries but I'm not sure where they are located.

    msteinbugl5 pointsBadges:
  • Issue with printing legal portrait report from AS400

    I am creating a spool file using RPG and a printer file. I use this command to set the parameters on the printer file. ===> CHGPRTF FILE(PYTT4LS2) DEVTYPE(*AFPDS) PAGESIZE(112 84 *ROWCOL) LPI(8) CPI 12) OVRFLW(112) FRONTMGN(0 .5) DRAWER(00003) The problem is that when I send the spool file to...

    cwestcott25 pointsBadges:
  • Convert AFPDS to PDF

    Hi ! we were using printer file type as SCS earlier. Now we are changing printer files to AFPDS in order to print in different font and with lines and boxes. But the problem is the AFPDS can not be printable in all kind of printers. It does not support most of our printer model. So we want to...

    Sureyz2,375 pointsBadges:
  • How to pull a list of userprofiles and group profiles in an iSeries

    Need a list that differentiates usrprf and grpprf.

    harisudhan211,005 pointsBadges:
  • Export Arabic data from AS/400 to Excel

    How can I export Arabic data from AS/400 to Excel?

    YEMEN40 pointsBadges:
  • AS/400 Query – do not print report with ‘no records found’

    I am running a query interactively but I don't know how to do it with CL and SQL.

    bnobles125 pointsBadges:
  • What are your favorite cloud security blogs?

    You told us what your favorite IT blogs are, now we want to get a little more specific. Do you have any security blogs or cloud security blogs that you go to for the latest threats and solutions?

    MelanieYarbrough6,345 pointsBadges:
  • How to access the wrkactjob physical file

    I want to access the records in WRKACTJOB option but i dont know how to find the pf of wrkactjob and how to access that so kindly help me

    dinesh270075 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