• Excel report from RPG or SQL

    How do I produce an excel report via RPG or SQL inside an RPG program?

    Taborly0820 pointsBadges:
  • Online test or exam for AS400

    Is there any online test(exam) website in AS400.... i searched in Google, but i can't get it..... 

    pdsathishkumar3,805 pointsBadges:
  • FTP/400 With Blank characters on the end field

    Hi Friends, Happy New Year to all. How can I send a file by FTP/400 with blank position on the end field ? Att; PutzGrilla

    PutzGrilla810 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,880 pointsBadges:
  • USB printing and the iSeries

    We have some remote wrkstns using client access for the emulation and printing. The printer is attached as a USB printer. When client sends spooled files to this printer, it puts the splf on hold, once released it does print. If this same spooled file is sent to a printer on the LAN, the spooled...

    Jackees5 pointsBadges:
  • AS/400 BPCS Query Training Manual

    I am looking for a complete (digital) training manual to make queries in BPCS. Can someone provide me with this? Thank you very much! Rgds, D    

    David4045 pointsBadges:
  • 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:
  • 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,880 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...

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

    Jpjawili315 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,670 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:

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