• Records fetched using cursor in AS/400

    How many maximum records we can fetch using cursor in AS/400?

    SatishKumar00715 pointsBadges:
  • RPGLE program is not picking up record

    I have SQL Table and Index. I am processing it in my RPGLE Program when Status = *blanks. In another session, I am updating record with Status = Blanks. My RPGLE Program is not picking this record. But my RPGLE picks newly inserted records. Please let me know the reason and how to read updated...

    rajeshece1,230 pointsBadges:
  • SYNON access paths

    Function uses an Access Path, and it's been determined that sometimes, the user doesn't have all the information needed to do a lookup. Boss wants to use a new/different access path. How do I do this? it won't have the same control fields in the subfile, so it won't compile. I'm stuck.

    Ssboy20 pointsBadges:
  • Error occurred when doing SNDDST

    Doing SNDDST makes the job QMSF to stop with: CPF9A8C Escape 30 07/23/00 12:50:26 QOKSCHD QSYS 12A6 QZMFSNPA QSYS 0140 Message . . . . : Error occurred with QOKSCHD API. Reason code 11. Cause . . . . . : A problem occurred calling Search System Directory (QOKSCHD) API. The search function did not...

    Pino1005 pointsBadges:
  • Calculator on DSPF screen on AS/400

    Screen- 0 to 9 buttons , and +,-,= button. If I click 0 to 9, it will be display on screen and click = then show the result on the screen. Please give me the screen shot.

    Satyamohanty65 pointsBadges:
  • Display message ID MH00090

    How do I display message ID MH00090?

    eudybarb5 pointsBadges:
  • How to export data from AS/400 in Excel

    Hi everyone, I would like to know how to in a step by step process export date from AS/400 iSeries into an Excel workbook. The purpose is to gather the data from AS/400, export it to Excel, then filter the data for specific info, then import that to another Excel workbook. A basic inventory report...

    Itriconewbie5 pointsBadges:
  • RPGLE DATE CALCULATIONS

    I need to subtract 1 day from the system date and output it into a file in the format mmddyyyy. No separators. I cannot figure out how to use date functions like subdur w/o the field containing separaters on output. And I can't figure out how to use a DS to redefine it so I can exclude the...

    KatanaBeach115 pointsBadges:
  • ILE RPG RegEx API

    Hi All, Has anyone had any luck implementing the Regex C APIs within ILE RPG? I'm aware of the matter of converting the pattern input to match CCSID 37, and I thought I had catered for the gotchas. But I cannot get the API to work for anything but the most basic of match conditions. For example if...

    andyhumphreys465 pointsBadges:
  • QSOSRV1 service program hangs on recv() procedure

    My program hangs on IBM's service program QSOSRV1 when it runs the 'recv' procedure. It's hung at statement 9. This only happens occasionally. Most of the time the 'recv' procedure works fine. I'm new to sockets programming and would appreciate any help or suggestions. The 'recv' statement...

    fhartman15 pointsBadges:
  • RPQSQL / SQLRPG

    Any body please help Wanted to know the advantage and disadvantage using RPGSQL / SQLRPG I've heard that this is the new one its not only RPG but become one with SQL. Thanks in advance

    TG50 pointsBadges:
  • AS/400 distribution list

    How many names in one list, and how do I see the entire list?

    c021340j5 pointsBadges:
  • How to remove comma for individual fields before inserting into comma seperated csv file in RPGLE

    I'm trying to convert flat file to CSV file using RPGLE. As it is a comma separated file for certain fields like description as and when comma is encountered data is written to next column. I need to place each field value in respective columns even if comma is present in a field value. Can some...

    ganeshpavi75 pointsBadges:
  • CPYTOIMPF error when copying PF to stream file on iSeries

    I'm encountering an error while copying a PF to a stream file on iSeries if the stream file reside on a IFS link with 'NFS' as root directory. Below is the scenario where I'm getting this error. Used the below command: CpytoImpf Fromfile(Qtemp/CsvHeading) Tostmf(&CsvFile) Mbropt(*Replace)...

    HemanthD5 pointsBadges:
  • Cannot view spool file in System i Navigator

    In system i navigator, user cannot view their spool file. What should I do?

    ravisub15 pointsBadges:
  • How to decrypt a SHA1 hash value?

    SHA= 2fd4e1c6 7a2d28fc ed849ee1 bb76e739 1b93eb12. How can I decrypt (to ASCII) the string using RPG/400? What is its coding scheme?

    rajat0175 pointsBadges:
  • How to create a AS400 Qshell script (.sh) file

    Hi, I want to run a command STRQSH CMD ('/REPORTGENERATOR/move2current.sh') Where move2current would be a .sh file with commands as below: rm /HPA_CURRENT/_YOUR_AS400_NAME*.CSV cp /REPORTGENERATOR/*$(date '+%Y%m%d')* /HPA_CURRENT #set new owner chown hpa_transf /HPA_CURRENT/*.CSV My question is how...

    DeepikaR115 pointsBadges:
  • Program not logged in queue in remote AS/400

    Hi, I have a program that put an XML msg to a remote AS/400. The issue is when calling the program directly nothing logged in the queue but when calling it from submit job it works fine. This is for the same user

    majdhrb5 pointsBadges:
  • Program Described File in RPGIV

    Can any one send me an Example, How a Program Described File is used in RPGIV?

    Cganeshh0 pointsBadges:
  • How to use OVRDBF on STDIN to read multiple files in REXX/400

    I can issue "OVRDBF" for STDIN to a file and then read the file with PARSE PULL commands. At EOF, I issue "DLTOVR STDIN" and then a new "OVRDBF" to read the another file. However, the first PARSE PULL for second file returns EOF. How can I get past this?

    mgphl5215 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