• 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:
  • Module/Sub Procedure Call by RPG3/RPG III

    Is it possible to call a module/sub procedure from RPG 3/ RPG III code program?

    csuoaananth105 pointsBadges:
  • Display File Field Value When Function Key Pressed

    I have a simple display file that shows a window with a single field for user to enter a value for a number. If the user enters a number and presses enter the program uses the value to send number to other programs. My problem however is if a user places a value in the field and presses F9 the...

    filuphaze475 pointsBadges:
  • Replace leading blanks with zeros in RPG

    I have a 3A field on my display file, when user enters ' 50' I want to chain the file with '050' since record in stored in file like that. How can I replace the leading blanks with zeros in this case?

    RamvishakRamesh2,505 pointsBadges:
  • RPG SQL embedded

    Hi guys, I have this problem, look at this RPG code: dcl-s hostvar packed(8 : 0); dcl-s outvar zoned(8 : 0); ... EXEC SQL SELECT FIELDA INTO :HostVar FROM LIB1/FILE1 ; outvar = hostvar; EXEC SQL INSERT into LIB2/FILE2 (FIELDB) VALUES (HostVar); I get into Hostvar FIELDA that is packed(8 : 0)...

    Damiano25 pointsBadges:
  • DDS in TPG logical file definition

    In spool severity 20 -keyword specified at incorrect level severity 30 number of join specifications not valid joining 2 files.

    pedlat5 pointsBadges:
  • MKS implementer is not able to compile RPG program

    Before compile the RPG program need to create the temp file using CRTDUPOBJ. I created the Object and try to compile the PGM but the spool file showing error. Temp files not found. The program compiled in WRKMBRPDM but the same is not able to compile in MKS Implementer. Please help to sort out the...

    Progrmmer45 pointsBadges:
  • CPYFRMIMPF Error Code 2

    Hello, Can someone help me here? I'm trying to import data into a physical file using cpyfrmimpf and I keep getting error code 2 - The field A in the Field Definition File is not a field in the TOFILE. I've created the FDF from the physical file so the fields should be exactly the same. I'm trying...

    bp0144220 pointsBadges:
  • RPG9032 file &5 contains a record not in sequence

    We get the message: RPG9032 file &5 contains a record not in sequence. What do we do?

    HansVerloop5 pointsBadges:
  • RPG/400 Error RNQ1255

    I have a RPGILE (XOP560) program. I am able to compile sucessfully this program. once i call this program i am getting below error. please advice me. Additional Message Information Message ID . . . . . . : RNQ1255 Severity . . . . . . . : 99 Message type . . . . . : Inquiry Date sent . . . . . . :...

    Askt265 pointsBadges:
  • AS/400 CL Unit of Work Question

    Assuming I am not using any commit control statements and I have a simple CL that executes 2 RPG programs (one after the other); I'll call them step 1 and step 2. Is there a single unit of work that covers both steps or is each step the beginning and ending of a unit of work? That is to say, in...

    boneshark5 pointsBadges:
  • 24 digit number: Arithmetic operations?

    Hi, I need to work with numbers which are digits long. Why? Because this is the way to create a German IBAN code from Bank Code and Bank account: Concatenate Bank Code (8 digits) plus Account nbr (10 digits, leading zeroes) plus "131400" to a 24 digit number. Compute Modulo 97 of this number. (or...

    gast95185 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 get The Cursor position on particular field?

    My display File Contains three Fields as like name= ........  Roll =........  Marks=.......  But In that Case when Program Call, First Cursor Pos On name When Name Will Enter Roll No will Automaticalyy Disply. But I have To Modify Marks Field,,, So When I will Enter Name After That I want To...

    Sms121185 pointsBadges:
  • How do AS/400 stored procedures get output?

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata30 pointsBadges:
  • Avoid “black screen” between two processes in CL program

    Hi guys, I have my CL proc, inside it I call my PGM1 and PGM2, ..... CALL       PGM(MYLIB/PGM1) CALL       PGM(MYLIB/PGM2) ... PGM1 excpt a screen and I fill it then press F8. with F8 seton LR, end PGM1 and start PGM2 that process file data with parameters passed from PGM1 and give me print...

    Damiano25 pointsBadges:
  • RPG vendors compatibility

    Is it possible to manipulate a RPG program of one vendor to make it compatible with another RPG vendor?

    VijayMehta5 pointsBadges:
  • RPGLE multi-file processing with no match fields

    I believe I have found a bug in the way that RPGLE handles primary and secondary files with no match fields. My program will not process the primary file if there are no records in the secondary file; but it will process the secondary file, if there are no records in the primary file. RPG bug?

    Modiyooch760 pointsBadges:
  • Selecting particular record from SRC-PF

    Hi, How do I get/select particular record from a src-pf to update as for requirement?

    raj12345 pointsBadges:
  • See consolidation of program

    How can I see the consolidation of my program? Do I use RPG, RPG ILE or CL to do so?

    monivaz30 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