• How a work file created during runtime can be read in SQLRPGLE program to check the record count

    Workfile created using clle with no keys during run time in qtemp. Read a permanent file with its first key, using setll *loval and read in Dow loop. Check if the first key value is found in work file present in qtemp. The corresponding field in workfile is it's 4th field. How to check this or what...

    NicyChn125 pointsBadges:
  • Internal chat client suggestions other than OCS

    What type of internal chat client can we deploy on our intranet for employees to use when they are connected to our network? I'd love suggestions. All I know of is OCS.

    MelanieYarbrough6,345 pointsBadges:
  • Send CPF1816/1817 by Program without a UPS attached

    We have many AS/400/iSeries/i5s (call it how you want) around the world. In many cases we have big issues to connect the machines via serial cables to the ups (no time for a maintenance :-( ). Now we want to test "Online USVs". They are connected to the network and send messages via a socket...

    PBiFive5 pointsBadges:
  • AS/400 Administration Training

    Can I download AS/400 to learn it? Is there a specific training I could use?

    JuliusWWalker5 pointsBadges:
  • AS/400 create table reserved column name

    We have an SQL "reserved" word in 90% of our tables. When we were on V5R4, and would run the create table, (strqm, option 3, then to copy the PF to a collection via create table), that reserved word would automatically be double-quoted, so that the create table would work no problem. now, we are on...

    dpa160 pointsBadges:
  • OPNQRYF and CPYFRMQRYF

    I am writing a CL program in which I do OPNQRY file based on status field in the file. After this data selection, an RPG program is called which processes the data and changes the status to next status. After the execution of this I call another CL program. In this CL program, I want to copy query...

    abhinavpassi15 pointsBadges:
  • VIP DocManager Archive Spool File Error ARC0001

    Using command ARCSPLFSPY to archive a report but monitor message ARC0001 (Report Initialization Processing Error) occurs. What does this actually mean and what can be done to prevent the error? The VIP DocManager manual does not provide any additional information.

    BarbaraH5 pointsBadges:
  • Access to iSeries IFS using SCP

    An external system on Linux is trying to connect to iSeries to access one of the files on IFS using SCP. Their public key was generated on AWS and the public key was added to authorized files on iSeries. The external system is unable to connect using private public key authentication and is being...

    A1b2c3335 pointsBadges:
  • Logging for caching proxy servers

    If an administrator has implemented two caching proxy servers on a network, what is the best way to aggregate logs for these? Would syslog be better than logging to a network share?

    crawfordkevin475 pointsBadges:
  • Create RPGLE program from text

    I have been looking for a way to delete audit journal receivers by date. I found a program online by Carsten Flensburg. I've downloaded the files for this but they are in text form. I am not a developer, maybe a novice CL programmer :) . There are 4 files he has created: Member Name     Source...

    BigT211240 pointsBadges:
  • Refresh data from one AS/400 to another

    We have a production AS400 for our users and a test AS400 for our developers and we would like the data to match. Is there a way to refresh the data from the production box to the test box?

    Jean43370 pointsBadges:
  • Spoolfile entry object/owner

    Is there a way to change the owner of a spoolfile entry? One user created the report and now a 2nd user needs to see it via Spool Explorer. neither has a full command line since we tightened security. Many years ago I would convert the spooler entry to a physical file and later convert it back to a...

    aceofdelts2,330 pointsBadges:
  • DSPJOBLOG message for a individual session

    Just to be curious, any number of commands which we executed in the command line are shown if we took dspjoblog. Actually from where the dspjoblog command retrieves those information and shows to us. I tried with wrkmsgq (my workstation and also my user profile). I found nothing but the information...

    harish1990115 pointsBadges:
  • QDBRTVFD API in AS/400

    We are using QDBRTVFD API to get file record length. Now as per the requirement I have to use same API to get file size. Could anyone please let me know how can I get file size with the same API? Thanks in advance.

    iSeriesAnalyst5 pointsBadges:
  • Data downloaded using DTF, can we find entries in journal receivers?

    Data downloaded using DTF, can we find entries in journal receivers.

    JohnsonMumbai1,315 pointsBadges:
  • Input or Output request failed: How to detect error through batch job?

    Below error is displayed in joblog of Interactive job. Session stopped by a request from device QPADEV006W. Input or Output request failed. See message CPF5140. The job continues to run. Is there anyway to detect this error through a batch job. Once this error occurs we have to manually kill the...

    JohnsonMumbai1,315 pointsBadges:
  • IFS limitation (CFP9898)

    I am developing a process to send out emails with attachments from IFS thought sendemail command. I am expecting to send out more than 1000 emails to clients but the highest email sent out were 640 emails. When the number of emails sent out reached between 600 and 640 the program issued escape CPF...

    quielkn15 pointsBadges:
  • Logical File record deletion

    Can we delete a record through logical file and will it reflect in the physical file?

    Gopinath00775 pointsBadges:
  • FTP426 error when using FTP command in a batch file and running the batch file from AS/400

    Getting FTP426 error when using FTP command in a batch file and running the batch file from AS/400. The same batch file run in Command prompt it works fine. Here is the code.   FTP.CMD file to IFS Folder   open AS400 User AS400USER password quote pasv quote site namefmt 1  bin lcd A:\ cd...

    condadas5 pointsBadges:
  • Slow connection to Oracle from AS/400 (OJDBC)

    I'm trying to connect to Oracle from AS/400 via OJDBC, but the connection is taking 30 seconds. The same is for connection to SQL Server. To connect MySQL is okay, it is simultaneously.

    migallego5 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.

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

Following