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

    NicyChn130 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:
  • 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...

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

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

    JohnsonMumbai1,320 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,320 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:
  • Changing the color of a word in RTF document using MATLAB

    Is it possible to change the color of a certain word in rich text format document using MATLAB?

    jojototo5 pointsBadges:
  • How to create a startup program for WAS61. The program to start the subsystem (QWAS6/QWAS6). 2 JOBS under qwas6 (wmp and wmpappsvr) after every IPL.

    I was assigned to create a CL program to call a startup program to start subsystem automatically after every IPL. the program WAS61 located here: /QIBM/ProdData/WebSphere/AppServer/V61/ND/bin. I do not know where to start and how. Please help anyone. I have tried the steps mentioned here...

    ejaaje140 pointsBadges:
  • Create flat file in AS/400

    Is there a sample code in RPG to create a flat file?

    Niteshradven5 pointsBadges:
  • Can I see inside of a SAVF?

    Can I see what's in a SAVF without restoring the entire SAVF?

    GBambenek15 pointsBadges:
  • Window display file AS/400

    I am having a Displayfile which contains the account details, the screen is not sufficient to display complete details, so we need to display a window display file when cursor is places and f8 is pressed. Now I'm able to do it, but in the window screen there is f9 for toggle, now the f9 is pressed...

    ravula725 pointsBadges:
  • Update and write sample RPGLE program

    Hi all, I have two physical files pf1 and pf2 with three field student_id,name,marks. I want to Move the records from PF1 to PF2. If the Student_ID already exists in PF2 just update the record else write a new record in PF2.where student_id is key field in both physical file. Could anyone provide a...

    nabamita75 pointsBadges:
  • Replace Eth Card with FC Card

    Hi Everyone, Good day! Hope you are all doing well today! I have a p550 server with 2 partitions but only 1 partition is running. I want to replace the eth card with FC card. But when I replaced the card, it is still the eth card that being recognized by the system and not the FC card. Any idea on...

    excellentrandy1,330 pointsBadges:
  • Duplicate record deletion using SQL/400

    Hi, How do I delete duplicate records using SQL/400 with SQL query please? Thanks!

    6r1,850 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