• SQLRPGLE – Result Set

    I have an SQLRPGLE program [PGMA] containing the following: D ResultSet       DS                                 D                                     Qualified     ...

    Riccam30 pointsBadges:
  • What is the difference between using RPGLE and SQLRPGLE when updating a file?

    What is the difference in updating a file using RPGLE or SQLRPGLE?

    mcasantoshrai55 pointsBadges:
  • RPGLE Embedded SQL Not null

    RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view. This is pointing to null values encountered.  /free                                                   exec...

    NickHutcheson11,380 pointsBadges:
  • Job Schedule Entries Migration

    Hi All, We are migrating from an 820 to a new 550 i5 this weekend. Does anyone know how we can migrate the current Job Schedule Entries on the 820 to the 550? Is there an API to the database that holds the Job Schedule Entry details that we can use to extract the info and then push it into the...

    RaydenR0 pointsBadges:
  • Using API: unlink()

    Hello All, Is anyone aware of "authorities" issues related to this API? I am creating .PDF files in the IFS area of our iSeries box and some users are unable to recreate a .PDF if they did not create it. In an attempt to avoid this I would like to use this API to "unlink" or "delete" this IFS...

    Mrs9693nj0 pointsBadges:
  • Reading a output queue of spool files in RPGLE program

    I want to read a output queue which contains spool files so how could I read it through a RPGLE program. Actually I want to read a output queue and get the list of distinct spool files and also want the count of spool files with the same name.

    munduuu435 pointsBadges:
  • Reading flat file defined as DBCS

    Hi Experts, I have copied an xml file with chinese characters like this one <COMPANY_NAME>上海百维生物科技有限公司</COMPANY_NAME> into a flat file with structure below A          R $PDER                  A            $PDEF      ...

    Dodiaz10 pointsBadges:
  • How to use XML in RPG

    Hi All, I want to know if its possible to FTP a file from RPG to any other systems using XML. More precisely, can we use XML to pull the data from RPG and feed it to other systems. If yes, appreciate if you can give some inputs or notes where I can find the complete process or code. Thanks.

    RPGPGM40 pointsBadges:
  • Logic help required RPGLE

    I have a screen now in the screen I have few options eg.. Sel1, Sel2...etc. If I go in Sel1 I get another screen as subfile which provide me to select Sel11, Sel12, Sel13...etc. Not after making selections from Sel11, Sel21....Selnn, I come back to the first screen. Now I have to Save this...

    abhisheka1400 pointsBadges:
  • How to write flat file data into pf?

    Hi,,  M25 is one of my flat file which is 34 char length. I want to write data from flat file to normal pf. Pf contains 3 char field which is equally devide. Now generaly to read file we have to requre key field but flat file doesn't have any key field then how i will write this pf?     

    Sms121185 pointsBadges:
  • Declare variables in RPGLE program

    How will we declare variables in an RPGLE program which have the same field names of a file that is declared in the PF?

    vasanthisrini10 pointsBadges:
  • Operation sequence for member AAA is not valid

    I have a following scenario: Operation1: Chain operation on file A1 with lock operation Operation2: Chain operation on file A2 with lock operation Operation3: I updated record in A2 file with some updates Operation4: Now I committed the changes using COMMIT operation Until now I don't have any...

    sivakesava285 pointsBadges:
  • *DTAARA DEFINE LDA in RPGLE

    What is the meaning of this statement "*DTAARA DEFINE LDA" in RPGLE?

    Sidd30 pointsBadges:
  • AS400 – RPGLE, convert character to numeric.

    Hi all...!         Here i give you the code. DNum_tmp           c              '18745678' I declared Num_tmp like this and i did some operations then i got  Res_tmp = '18745678' . Now the question is i want to convert this char value to decimal that is addtionable. is...

    Sureyz2,475 pointsBadges:
  • API to send email messages from RPGLE

    I need to send an email message to a couple of mail ids with CC mail ID also. Is there any API (which is not in Java) which will enable me to send the mail?

    Koolsani085 pointsBadges:
  • RPG Move command

    DDEC1 S 15p 5 INZ(23.345) DDEC2 S 15p 5 * MAIN ROUTINE C MOVE 46.2 DEC2 Result :- DEC1 = 0000000023.34500 DEC2 = 0000000000.00462 When INZ used to move data it moves the data with correct base and decimal positions the same when done with MOVE OPCODE moves all data in decimal places (right...

    yvaditya20 pointsBadges:
  • Any AS/400 RPGLE Program To automatically convert PRTF file to PDF?

    I want the RPGLE code to convert this PRFT to PDF. Is there any functionality?

    Sms121185 pointsBadges:
  • Best way to do the DASD history capture…(Disk usage)

    Dear team, I need to enhance our current system that captures the disk space usage. I need to maintain the history over it. Currently we do it by using DSPOBJD and DSPFD commands and write the details of all objects and files used in the whole system to the outfile. Hardly it takes more than 4...

    Ezhilkumaran0 pointsBadges:
  • In RPGLE, how to fetch the particular record in 1 lakh record without a key

    Hi, I have some 1 lakh record. I need to fetch from 250th record with no key in it. What is the possible optimed way we can achieve it.

    KirManoj15 pointsBadges:
  • In RPG program

    Hi, In RPG program I declared files. One for reading and another for Updating. Both the files are in different Library lists. How do i achieve this? Thanks in Advance Rama krishna

    AnonymousUser13,030 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