• RECORD LOCK and CDC

    Record locks in USER EXIT program called by CDC. I have been thrown into figuring out why a user exit program cannot delete a record from a file because the record is locked since the employees who worked on it before no long work here. This is happening from a CDC (CHANGE DATA CAPTURE) process...

    UARTJ145 pointsBadges:
  • Synon/Cool:2E – internal/external func performance question

    I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...

    Rituraj0 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 vs COBOL

    Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...

    Rituraj0 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:
  • 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:

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