• Make SHA hash value in SQL on AS/400

    How can I make a SHA hash value in SQL on AS/400?

    nadineha5 pointsBadges:
  • SNDPGMMSG

    When the below command is executed, where does the message go? How should I check the message after that? WRKMSGQ (MSGQ) ? Will the MSGQ be QSYSOPR or the user profile or the workstation id?SNDPGMMSG MSGID( ) MSGF() + TOPGMQ(*EXT) MSGTYPE(*STATUS)

    sri8707465 pointsBadges:
  • Device prt01 not available on as400

    Once in a while my as400 series can't print and it's showing Device prt01 not available. Most of the times i turn off and on my as400 a couple times then the printer is ok but this time i restarted 5 times already but the message "Device prt01 not available" is still there

    math317630 pointsBadges:
  • Upgrading and integration

    We have the IBM AS/400 software have not had an update in a couple years need to see what we can do t get our systems current and more accessible. Looking and mainframe integration with Acess or similar programming.

    newdealfurniture5 pointsBadges:
  • UPDSRVPGM not updates Main PGMs

    As per my assumption UPDSRVPGM doesn't require UPDPGM once you made any changes to any particular module attached to service program(having Binder language). But it seems i am wrong. Everytime i make any changes to child module(containing PI of the procedure), along with UPDSRVPGM, i also need to...

    Thunderbolt15 pointsBadges:
  • 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.

    rajat01195 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,700 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?

    junekotey120 pointsBadges:
  • AS400 libraries used by DAS

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

    Jailakshmi70 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