• how to add a number of blank-spaces in free-format RPG

    My requirement is: I need to concatenate different fields having different values into the flat-string(blank initially), separated by a number of blanks(spaces), which may vary from field to field. for e.g. MyStr = 'FIRST_NAME LAST_NAME 20060101 STREET1 CITY11 STATE111 ... ' and so on where MyStr =...

    svankipu620 pointsBadges:
  • XML-INTO – No data retrieved

    Hi, I am trying to read the contents of an XML file that resides on the IFS in folder XMLTEST. My program runs without error but does not retrieve any data. If I remove the AllowExtra and AllowMissing keywords I get error RNQ0353 XML document does not match RPG variable, reason code 5. Any ideas...

    MD99910 pointsBadges:
  • AS400 CL, RPG TUTORIALS

    Hi Can anyone sugguest a good website that provides free turtorials on CL & RPG. Mabey with PDF downloads. Thanks  

    Jkbritvic65 pointsBadges:
  • Printing a Number as a Character

    How do you print a numeric field as characters? For example on check print, how do you print Nine Hundred Ninety-Nine instead of 999?

    Sec8715 pointsBadges:
  • how to access QTEMP files in batch programs.

    Hi All, I have developed one tool in AS400 which consists of one CL program and one RPGLE program. I have created 2 temporary files in QTEMP in CL program. RPG program is called by CL. these two files will be used in RPG program in update and output mode. after that i want to run that RPGILE...

    Mohan K695 pointsBadges:
  • Cannot end RGZPFM on V5R4 (Journaled file)

    Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can...

    AS400DBA15 pointsBadges:
  • primary files

    Can anyone explain the concept of primary files in RPG , as i am a fresher in AS/400, i just want to know why do we use the Primary , secondary files concept ?

    Shivaas4005 pointsBadges:
  • Sorting an array by two elements

    I want to sort and array by data and then by ship via, both elements of an Order Array. Does anyone know a way that I can sort at two levels in the Arraay?

    APierce215 pointsBadges:
  • Links for Subfile programming and RLU

    can I get some links for basic subfile programing and RLU.

    0 pointsBadges:
  • Data area *LIBL/INSRLIST is not allocated for output.

    The following is a snippet of the code. I get an error on the OUT op code as in the title.  * Next List Number                                   D                 DS                                  D...

    MurrayInfoSys940 pointsBadges:
  • Merging of files in AS400

    What is the use of merging files in AS400? How do you do this?

    0 pointsBadges:
  • Incorrect relative record number or field selection error

    I get the above error when trying to run a program when it trys to write a display format. The program had been working and suddenly started giving this error. There doesn't seem to be any relative record numbers involved. I would be happy if someone could give me a clue as to what I should be...

    Socrates0 pointsBadges:
  • Why can’t create a physical file has more than one record format ?

    After I coded 'A' spec for multiple record format physical file like this R REC1 MBRID 9A REV 41A R REC2 MBRNM1 50A The joblog (after compiled) said ID Severity Number * CPD7914 30 1 Message . . . . : File contains more than one record format Could you please investigate and let's me know how to...

    Kik0 pointsBadges:
  • CCSID Problem Creating XML Documents with RPG and CGIDEV2

    Hello, I am creating XML documents with the CGIDEV2 library of procedures. My XML templates are in CCSID 1252. I have a field defined as CCSID 37 that I am trying to insert into the XML as variable text. This field contains a cent sign. CGIDEV2 creates the new XML document as CCSID 819 withut...

    ISeriesCanDo5 pointsBadges:
  • Different results for embedded SQL

    I have embedded SQL in my RPG code and some of the results are different to what I get when I check using STRSQL

    Macitmich20 pointsBadges:
  • EMP

    How would you achieve this requirement with out using RPG/RPGLE pgm,but by using only CL?Read a database file and display file contents on the screen when enter key pressed the next record should be displayed on screen.When the last record is reached or when F3 key is pressed the program should...

    0 pointsBadges:
  • SQLCOD = -7008 when doing an insert into file using SQLRPGLE

    Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...

    SasiKumar0 pointsBadges:
  • How to reset the password??

    Hi, How to reset the password through a CL program. The user has forgotten his password, even ADMIN doesn't know the password. Thanks, Rama krishna

    0 pointsBadges:
  • Allocate more then 16 MB to RPG Variable

    Is there a way to allocate more then 16MB space to variable or pointer in RPG ? I heard about Heap /User Space creation but when I tried to use it, it's limit is again 16 MB.

    VParashar10 pointsBadges:
  • Vietnamese Characters in RPG

    I would like to write a program in RPG to print out Vietnamese characters with accents, for example ắ, ấ, ỏ, ọ, ... But I don't know the way JD Edward can support. Appriciate your help here.

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following