• how many programmes are using any perticular database file in as400

    hi all, i m working on rpgile,if i have a logical file & i want to know list of programmes that r using that logical file ,what should i do? is there any command ??? thanks

    Ambrish 82310 pointsBadges:
  • Two subfiles in same screen

    I am working with 2 subfiles in the same screen, both have some options that call others programs. There is a function key F12 - cancel that should be return to the last screen after run these programs. The program is using command UPDATE LSTSFL (subfile name). It is working well for the first...

    BTF5 pointsBadges:
  • Command to track how many spool files users have

    I have certain users who never clean out their spool files. Is there any command I can run which will tell me how many spool files a user has out there? I am currently on version V5R4 of the operating system

    GHENDER200 pointsBadges:
  • Reorganization of V5R4 while active

    We are currently on operating system V5R4. We are a 24/7 shop and as a result, I have not had the opportunity to do a lot of reorgs. I just discovered there is a reorg while active command. Can someone tell me how to use this? Does this come with the operating system or is it a separate module we...

    GHENDER200 pointsBadges:
  • How to tell if a specific record comes before or after another specific record?

    In RPG ILE, I have an externally described file. I am chaining out to the logical file with a key & find the first record. Now, I want to know if the second record I'm looking for is before or after the first record in the file.

    Stckrb5 pointsBadges:
  • Embedded SQL in RPGILE

    For a SELECT Query in RPG program if we get -811 SQL error, it means we have got multiple selections in our query. Is it possible to know how many records are selected from the SELECT statement from any field of SQLCA or in some other way?

    TNKR130 pointsBadges:
  • get an i-Series *LIBL in a .NET program

    I have a .NET programmer asking how he can get the i-Series *LIBL. Based on how the connection is established we can run under 6 different environments. A production and a test for 3 different locations. These are all running on the same i-Series machine. Any ideas or pointers? I have just started...

    ToddN200015,605 pointsBadges:
  • Runtime Session resolution change

    I want to change seesion resolution from 24X80 to 27X132 in runtime through RPG ILE. Please help me on this regard, by giving sample code.

    Bubaimess5 pointsBadges:
  • Difference between converting rpg/400 pgm to rpgile

    i have some 30 pgms in rpg/400 and a service program which i want to change this to rpgile and i have access of service program also. then what is the difference between this pgm now

    chakramdhar65 pointsBadges:
  • Writing one line of code in RPG: greater than ‘A’ and less than ‘Z’

    How can I write one line of code in RPG Free something like if x >= 'A' and x <= 'Z' instead of x = 'A' or x = 'B', etc.

    SKF75 pointsBadges:
  • Find Protypes in Programs

    How can I find all programs that a Prototype is defined in regardless of source file or source library?

    wmfsr20 pointsBadges:
  • RPG/400

    Hi,  What is the use of QCMDEXC?who will handle this.what purpose we use?can we call it is a command?  what is the usd of *INZSR?what is the relation with RETURN?  What are the input opcodes and output opcodes and I/O(combined) opcodes available in RPG/400?can any body list please Thanks...

    Repaire45 pointsBadges:
  • Advanced Trigger question for *insert *before to allow update of field value

    I need to update a field in a record being written prior to it being written. I want to do it with a trigger because many programs write and update this file. I have tried several things and the closest I have gotten is to do a *before *insert where I can see the values of the fields in the after...

    Dcdc5 pointsBadges:
  • About Program Described input files

    hi all, Can anyone explain me what is meant by Program described input files and what is the use of this files compared to Externally Described files and please give one complete example program of using Program described files with I SPECS and explain me about Record identification codes

    Mohan K695 pointsBadges:
  • Link for download subfile programming in RPG ILE

    HI , i am working on ile rpg , & i just started to work on subfile programming . i want to lean subfile programming because i didn't work on it yet. i dont have any source like any document . i have downloded a pdf file for subfile programming its good but it is only For RPG not for ile. does it...

    Ambrish 82310 pointsBadges:
  • OS/400 version vs ILE RPG objects

    We are planninig to upgrade our os/400 version V5R4M0 to V6R1M0. Is there any impact on the ILE RPG objects and do we need to recomile all the ILE RPG programs in V6.

    JKW5 pointsBadges:
  • Position Cursor Issue in subfile

    I have a subfile with 'Position to' option in control format. so to keep the cursor in subfile recod, i have used DSPATR(PC) for option field and Reverse Image as well. But indicators are different, when I am trying to show error, i m setting the both indicators (PC,RI since i have used different...

    frmdeva365 pointsBadges:
  • how to delete joblog created by a program RPG/ILE

    hi , i am running a program in batch that stores thousands of reports in a run .I want to delete joblog  that is created by the program simultaniously .Please help me out  

    munduuu435 pointsBadges:
  • like query not running in pg

    hi i am running a query to select records which contains abc_ so i am running : var1= 'abc_' + '%'; so i am running in rpg as select name from table where name like :var1; query is running but not selecting any records ..please help me out

    munduuu435 pointsBadges:
  • iSeries SQL function in a SQL procedure – error: Function Name “in *LIBL type *N not found.”

    A while back, Seeker1 posted this question.  Unfortuantely, he didn't provide enough information for Tom to help.  Well - I have the same problem so hopefully, this will be enough. This Select statement generates the error: SELECT UNUNIT, ITRVEHLOC(UNUNIT  , 'CITY ')  FROM Units Here are the...

    Craig Hatmaker1,775 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