• RPGLE date conversion

    Hey again, I have on my RPGLE display screen a date field (Numeric 8,0) which format is DDMMYYYY. But when I want to store it in the physical file. I want it to be in the format (*ISO YYYY-MM-DD). How can I convert from the DDMMYYYY format know the appropriate century? Can anyone help me in this...

    Sureyz2,760 pointsBadges:
  • RPGLE substring and break word with different fields

    Hi, I have encounter issues about sub string with from input and store in destination fields with different field length. I have four 35A input fields condition with if character at position 35A of input line 1 is not a space and first character of input line 2 is not space, then will move last...

    Yuexuan5 pointsBadges:
  • Error with SQL

    I am trying to use a SQL statement in an RPGLE program to select a group of records. I have verified that all of the files used in my SQL statement is in the file. I keep getting the errorsSQLCOD=-000000206 SQLSTATE = 42703. Here is my statement:C/EXEC SQL + DECLARE C1 CURSOR FOR C + SELECT WOCSCD,...

    lrgronewold25 pointsBadges:
  • AS/400 (language – RPGLE)

    I want to fetch combination of some records from PF file, so how should I do that?

    Shrikant3155 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:
  • 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:
  • PASE for i already running in this job

    We have an RPGLE PGM that executes the following to establish a connection to another servers database and it works fine. DBcomm = JDBC_Connect(%TRIM(DriverName):%TRIM(ConnectionString):%TRIM(userid):%TRIM(Password) ); This statement starts running PASE. When the same user in the same job that just...

    Gman7325 pointsBadges:
  • Data validity vs. CL program with OVRDBF command submitted 10 times simultaneously

    Would I be able to process the file correctly if I would have a CL program submitted 10 x simultaneously that contains OVRDBF. Behavior is similar to multi threading and this would really help process a very large file with less time. OVRDBF is necessary to point to the correct file member prior to...

    Andy01atSM10 pointsBadges:
  • CCSID 935 to CCSID 13488

    I have a file that is ccsid 935 containing some records with Chinese characters. I need to convert that file to its upgraded version that is ccsid 13488. (These are vendor files, therefore I have no control over their definitions.)  It is possible to simply copy the older file into the upgraded...

    Ckelly0120 pointsBadges:
  • Invoking web service using XML in RPGLE PGM

    I'm receiving error 415 - unexpected content type error - I have double checked the SOAP and all appears correct - is there a statement I need to add for content type to the XML? How can I tell what is causing this error? SOAP XML from PGM. SOAP = '' + 'http://www.w3.org/2003/05/soap-envelope" '+...

    angelafrye30 pointsBadges:
  • CPF4326

    Hi all, I am reading data from a file PF1 using LF1 sequentially, and writing to other file PF2 using using LF2 using RPG Program R1. When I run it using CALL R1, it's working absolutely fine. But when use SBMJOB to submit it as batch job, it is going to MSGW. the error is: " CPF4326 occurred for...

    Sai4AS4001,420 pointsBadges:
  • Copying data from a file created in QTEMP

    How to write a code to copy the data from a file which is created in QTEMP to the file which is created in a permanent library.

    ShanuPriya199425 pointsBadges:
  • Date field in RPGLE

    If have a statement in RPGLE which runs fine online but errors out in batch. D DateField       S               d   datfmt(*mdy) D S1Dte           S              6  0 Datefield = %date( s1Dte   : *MDY ); Error: "Date, Time or Timestamp variable which...

    Msatbh185 pointsBadges:
  • AS/400 Group Jobs being held after the first empty job is run

    I am using STRGRPJS JOB to submit a group job but after the first job is run which is a empty job the remaining jobs are being held. Can anyone tell what should i do so that they don't go in held state? Thanks.

    aceamar25 pointsBadges:
  • CPF5032 member already locked to this job

    I have a program written in RPGLE which calls numerous other programs. These programs all share similar files. In my main program, when trying to read a particular file, I get error CPF5032 even though I unlock the file right before I do the setll reade. As a result, I figured the lock must be...

    GHENDER215 pointsBadges:
  • Reading members of a physical file

    Hi, Can somebody please help by providing the program code for reading all the members of a file using RPG or RPGLE program? Suppose a file has 3 members then how to read the records of all the 3 members in a file? Thanks!

    6r1,850 pointsBadges:
  • Unicode on AS/400 RPGLE

    We are upgrading to 9.0 JD Edwards where the unicode tables have CCSID = 13488; I still need them to work with legacy files, CCSID = 37. How can I get these 2 types of tables to interact within RPGLE (V6R1M0).

    Normap2275 pointsBadges:
  • Update causing reade to read the same record in RPGLE

    Hi Team, I have a critical issue. In RPGLE program, I have read a file then based on some condition I am updating the file if condition is not satisfied I am not updating that file. I am doing it in a do while loop. The issue I am facing is the record that has been updated is being read again....

    soundariya20 pointsBadges:
  • How does equal to operator work in RPGLE free format when v compare file field with constant value.

    I have a file field which has values 'X' or 'Y' and it is of 10 length. Chain f1:f2:f3 filename if %found filename if f4 = 'X' In free format RPGLE when I tried to compare it fails even though value of f4 is ' X' . Note: f4 is of 10length. Work around is trimming F4 before equating but I would...

    NicyChn135 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