• AS/400 – (IBM i) FTP to port 990 (Secure FTP)

    Greetings,This is about FTPing from an AS/400 (aka iBMi, iSeries, Power6, etc.) to Port(990) - aka - SFTP - Secure FTP.Receiving an error when switching to a new target FTP site that requires using port 990. "-23 Certificate is not signed by a trusted certificate authority." Need to know how to get...

    Klipster5 pointsBadges:
  • Embedded SQL Pre-Compiler issue

    Why would the SQL Pre-Compile check fail to recognize an invalid/non-existent file name in a SQL Statement?

    Jmfuchs15 pointsBadges:
  • Update sql400

    What is wrong in this statement

    Msatbh190 pointsBadges:
  • Status of a submitted AS/400 job

    This is the scenario, I want my job B to start after finishing Job A and Job C to start after finishing Job B. Can I use a RTVJOBA to check whether job A has finished sussesfully so that I can submit Job B? If I can use this, which paramter will tell me the job status like successfully completed or...

    RamvishakRamesh2,505 pointsBadges:
  • RESTful webservices on IBM i

    Hi !I need to provide a web service, which has to respond for a GET request. The input parameters will be as a JSON file structure. For ex {"name":"Sureyz", "role":"AS/400"}. A RESTful web service on IBM i should get this and result a JSON file as {"Result":"Found"} , The question is how to...

    Sureyz2,850 pointsBadges:
  • SNDNETF command not working

    No error message but --> The file via sndnetf says sent to 1 user but the receiving AS/400 does not get it via the wrknetf command??? SNDNETF FILE(QGPL/TESTCAT) TOUSRID((TEST CORP))

    ITGut30 pointsBadges:
  • PF Trigger

    Hi !I have a Physical File. When adding a record in that PF,after the write operation some of the fields has to be added on another PF after 1 hour. can anyone suggest how can we achieve this?Surey

    Sureyz2,850 pointsBadges:
  • How to setup a new raid set with Hot spare on current configuration on AS/400 V5R4M0

    Currently we have V5R4 system with two raid sets(RAID5 active) hot spare is not enabled. We added an expansion unit with extra disks. I want to create another two raid sets with hot spare enabled. Could you please provide the details how it could be done from DST. I don't have navigator setup for...

    venkatktata300 pointsBadges:
  • Who is using an AS/400 file

    I want to clear a file in RPG, but find that it is in use. How can I determine, programatically, what user(s) is locking the file?

    Jck5 pointsBadges:
  • iSeries sending emails to a group

    We would like to emails sent from the iSeries to a group when a job that runs at midnight unattended has an error message. How do we set this up?

    bwb1011115 pointsBadges:
  • Arabic characters not displayed during SQL using IBM Navigator for i

    I have a table on the IBM i DB2/400 database, table CCSID is 420 = Arabic. My user profile is configured to CCSID 420 also. My 5250 green screen session is also configured to use CCSID 420 and my keyboard is configured to be able to enter Arabic characters. I enter Arabic characters on one of the...

    Jpjawili290 pointsBadges:
  • IBM AS/400 Report

    How do I run a report in IBM AS400 software using payment type?

    pullikkal5 pointsBadges:
  • QADBXREF file attributes

    This is a challenging question: System Cross Reference file QADBXREF field name DBXATR = 'CL'. What is "CL" file attribute type for a file (not a program)? I know the standards PF, LF, AR etc but I have one file on the system that I cannot find on the system and it is the only one that is file...

    Modiyooch850 pointsBadges:
  • Error in compiling embedded SQLRPGLE in full free format

    Hi everyone - here's a question from a user in regards to SQLRPGLE: I have written some simple embedded SQL PGMS in COBOL in AS/400, compiled and run successfully. But I am not able to do so in full free format RPGLE. Here is the RPGLE code that doesn't compile. dcl-s sql_RCONAME char(20) ; exec...

    Michael Tidmarsh65,580 pointsBadges:
  • Multi threading program in AS400

    A multi threading program(3 threads) generate 3 output file (spool file) of the same kind. I want to copy this file. I need only one file in the stream folder. How can I get single file which contains data of all 3 file? (Spool file structure is same) ?

    MaheshMR5 pointsBadges:
  • Creating a Logical File

    I have a class in ILE RPG. My current task is to create a logical file(or an SQL index) sorted by a specific field(SNAME). The file provided is a *file.pf-dta and it has a member inside of which holds data. How would I go across creating a logical file and keying it by SNAME? This is the only file...

    vexumy20 pointsBadges:
  • Get Spoolfile Information

    How do I retrieve spoolfile information? I want to use the spoolfile information to dsplay in DSPF.

    adil9525 pointsBadges:
  • SETLL & READ

    Hello, I am a beginner with AS/400, I am developing a program to SCAN IN records, this record can be scanned multiple times (Duplicated records). But I need a code that search if the record exist, if exist a record then sum the quantity field of that record with the quantity entered if is greater...

    k3v1N24105 pointsBadges:
  • How to extract from tar with QSHELL

    I saved a program to a tar file with QSHELL on one system but how do you extract it on another system with QSHELL tar -cf /home/user/newobj.tar /QSYS.LIB/NEWOBJ.LIB/XYZPGM.SRVPGM

    hafwhit1,180 pointsBadges:
  • QSYSOPR does not have authority to perform upgrade

    we were trying to perform the Prepare for Install from GO LICPGM and loaded the CD'S as QSYSOPR and we were NOT AUTHORIZED, is OS upgrade on iSeries not a part of QSYSOPR profile?

    harisudhan211,005 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