• 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:
  • 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:
  • 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:
  • 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:
  • Program Described File in RPGIV

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

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

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