• How to get number of modified rows in subfile(SFL)?

    If READC function reads only modified records of a Subfile(SFL), I would like to know if there is any system function or it is any way to know the amount of modified records on a subfile(SFL) using an RPG file.EjemploREADC SUBFILE1; DOW %EOF = *OFF; IF VAR_FIELD_1 = 'A'; SUM = SUM + 1; ENDIF;...

    DaniPertuz5 pointsBadges:
  • Brief content of Backup Tape to be printed out after Backup for comparison between source & target..

    Is there a command to get a brief description of the content of the backup to be printed out after doing the duptap in BRMS environment as we don't want to print-out the whole dump report of the backup. The command used was 'DUPMEDBRM VOL(ABC001) FROMDEV(TAPMLB25) TODEV(TAPMLB25) MEDPCY(PXC2SD07A1)...

    athimr35 pointsBadges:
  • Weekly backup error with message ID CPF37A0

    Hello All, The flowing is the error with message ID CPF37A0. Backup is failing every week. Please suggest. Message . . . . : Save operation could not continue. Cause . . . . . : Object 'QATAMID QATAMID' type QDDS in library *N was being saved at a volume boundary. End of volume processing requires...

    venkatktata310 pointsBadges:
  • AS/400 CLLE: Scan and replace with other character in CL program

    How to scan for a position and replace that with some other character in CL program? eg : Name = 'Vivek' i should replace 'e' with 'o'. How can I do that in CLLE?

    vivekntt21450 pointsBadges:
  • BPCS Inventory items dissapearing

    Good day to everyone. I would have a question in regards to BPCS itself and the way the interface functions. At the current time, I have added a custom interface with german and english language support. However, for some reason, items will randomly dissapear from my interface itself. I am most...

    M11Bob15 pointsBadges:
  • What are the advantages of using RPG over C/C++ at IBM i?

    What specifically RPGLE is good at doing, that'd be cumbersome/difficult with ILE C/C++? Also, how RPG differs from modern high-level languages? About me: I've studied C and C++ during high-school, and now working as an entry-level RPG/CL developer.

    rajat01190 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:
  • Update sql400

    What is wrong in this statement

    Msatbh190 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:
  • 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,655 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:
  • RPG stored procedures

    Remote client calls RPG stored procedure which invokes RPG program. I am then calling another program from initial program but when I make this call it does not return result set. Can I call one program from the called program?

    junekotey50 pointsBadges:
  • AS400 libraries used by DAS

    How do I find the libraries used by DAS to fetch data from the underlying AS400?

    Jailakshmi70 pointsBadges:
  • SFLRCDNBR – type of data?

    Hello. 20 years in 390 and I've just arrived in 400. I've an issue with a screen, giving a status 22 (dup key) writing the subfile. I see we have more than 10.000 lines to show, but the field in the SFLRCDNBR (CURSOR) only allow 4S definition. So when I add 1 after 9999, it becomes 0 again. I can...

    GonzaloGY5 pointsBadges:
  • Trying to get AFPRSC keyword to work

    Has anyone gotten the printer keyword AFPRSC to work to print a .jpeg file? I have not been able to get it to work.  I am just testing with a simple .jpg picture and a test print file with the one AFPRSC command on a record format. It seems to ignore the command and do nothing. I am on V7R1.

    aburkes15 pointsBadges:
  • Infor XA Modules list

    Hi, I would like to know about INFOR XA in almost all the below areas, your help in any of it is very much appreciated. Infor XA data dictionary Basic architecture Modules list Database mapping Any user guide

    as400dev655 pointsBadges:
  • Execute SQL Server Procedure from the iSeries

    I have an internal web address for a SQL Server application, where they want to run an iSeries stored procedure to connect to the SQL Server, call a SQL Server Stored Procedure, and receive resulting values back to the iSeries. Is this possible?

    sonorato15 pointsBadges:
  • Limit Query PF File Size

    When creating a PF thru AS/400 Query, would like to limit file size?

    Yuehan6835 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