• File open RPG

    Is there a way in an rpg program to open a file using a character field for the filename? for example: if my file name is TESTFILE I can use the line: (in rpg free)   OPEN TESTFILE; but is there a way to have character field in place of the filename:   D filename          ...

    Srikant5 pointsBadges:
  • DB2

    i have display file which inputs a varibale say Var1.... This is updated in a PF. My problem is program is not updating this varibale in this file. it updates all other varibales...i checked the library list and evrythng is in place... in PF, the field name is Var1. i use the same name for DSPF -...

    Nutangujar895 pointsBadges:
  • Stored procedure

    how to capture the messages sent by Stored procedure.. the one which i'm using is programmed to returned '0001110' if certaine condition do not match...how will i capture this or where i'll see these messages... Thanks, NG

    Nutangujar895 pointsBadges:
  • Number of lines of code in a program

    hi, I've 50 programs to find the number of lines of code in it... is there any smart way? Thanks, N.

    Nutangujar895 pointsBadges:
  • RPG Logic Cycle ?

    HI,     How to know that a RPG program using RPG Logic Cycle or Not?     Jayanta

    2106198125 pointsBadges:
  • Get user id in CGI RPG program

    Please, kindly advise on this issue I am having. Program is coded in RPG and is a CGI module. I tried to get user-id from program data structure, but this "UserID 254 263", but it shows QTMHHTTP, because this pgr runs on HTTP server. How else can I obtain real user-id of the user who is envoking...

    Lenny2113115 pointsBadges:
  • RPG ILE Day of Week

    Are there alternate ways to determine the day of the week. I have the following formula - DayOfWeek = %Subst(('Sunday ' 'Monday ' 'Tuesday ' 'Wednesday' 'Thursday ' 'Friday ' 'Saturday ' ):(((%Rem(%Diff(%Date():%Date('1941-12-07'):*D):7)+1)*9))-8:9);

    Satsho1,245 pointsBadges:
  • Date Formatting in RPG

    I have a date in a DATE type field in *ISO format (ccyy-mm-dd) However, I want to extract the YY portion. Using %SUBDT(field: *Y) returns CCYY. Is there a nice way of doing this without using a data structure?

    Ricca100 pointsBadges:
  • Empty Date Type Variable

      What does a *ISO Date type variable contain if it is not populated? It is not *Zero or *Null???  

    Ricca100 pointsBadges:
  • PGM described update file

    Hi, I'm trying to update a program described file. I have tried setting the F specs up to allow processing by key by placing the following information in the noted locations: 07-14: file name 15: "U" 16: "F" 19: "F" 26-27: File length (32) 30: The length of the key (8) 31: "A" 32: "I" 38: The...

    Floyd02320 pointsBadges:
  • RPG IV Date Formatting

    What is the best and cleanest way to convert a character date dd / mm / yy to *ISO format?

    Ricca100 pointsBadges:
  • Remove hard coding AS/400 RPG

    Hi, I have a program that will be used in different countries. Each country have different selection criteria. How do I design my program such that I do not hard code the selection criteria? Note: Selection criteria could be more than 1 fields or from more than 1 file.

    JoBi85 pointsBadges:
  • How to determine the RPG version

    Hi, Can you tell me how to know the RPG version (III or IV) in our AS400? Also, if it's ILE? Thank you.

    Sanchezedwin215 pointsBadges:
  • RPG ILE ending program properly on an error

    Hello, Could someone please help me with this? 1. I have an ever running job that calls a particular ILE program (PGM A) to do some XML parsing and composing. 2. PGM A calles another program PGM B (which in turn has modules MOD B, MOD C and a NOMAIN module MOD D binded to it). 3. PGM A parses the...

    Compengr200355 pointsBadges:
  • RPG/400 – Reduce Manual Intervention

    Currently when we run EOD we have to wait for the other system's file. If the file did not arrive after some time, I will prompt message for operator to reply the message when the file is ready. How do I split my job so that we can use control M to submit the job and reduce operator intervention....

    JoBi85 pointsBadges:
  • Query Xref to file

    The other day I added a field to the DDS of a file. I recompiled all of the RPG programs and display files that use the physical file. But I got burned when I found that I neglected to include all of the queries that used the file. Is there a way to query all of the query definitions to find if my...

    Abbey120 pointsBadges:
  • iSeries performance question

    Hello everybody, I'm trying to figure out the best way to count the number of records matching specified criteria in large PF. (The file has over 50 million records currently and with some purging we hope to bring it down to around 20 mil.) Anyway, I created the (SQL) view: create view largePF99 (...

    Dushan0 pointsBadges:
  • How many internal steps within compilation of RPGILE source

    Hi, I want to know howmany internal steps happen when we compile a RPGILE Program example Bindind etc in sequence plese anyone tell me

    Mohan K695 pointsBadges:
  • Settin on LR indicator not closing files

    I have a service program that ends with *INLR but it does not close the files after its procedure is called. It is compiled with ACTGRP(*CALLER) the program that uses it is also compiled with ACTGRP(*CALLER). However, if I use the CLOSE op code, the file closes. Is this natural or should this be...

    bogeybetsy560 pointsBadges:
  • LOOKUP

    when lookup is unsuccessful what is the value of array index?

    ten20081,150 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