• Viewing stored procedure statements in AS/400

    Hi, I created many stored procedures using STRSQL. And I called those procedures using SQLRPGLE program. It worked but I need to view those statements. I don't know how to view stored procedure statements which was created using STRSQL. Can anybody help me?

    LakNar270 pointsBadges:
  • Reset Password of a UserProfile

    Hi Group, How do we reset the password of a UserProfile in AS/400? Regards, M

    mvrkrishna530 pointsBadges:
  • iSeries query: Compare two fields in one file

    Try to do a multiple select statement and then compare the results of that statement. See below: SELECT "T16.APAR".P._PARCEL_NR FROM QS36F."T16.APAR" WHERE "T16.APAR".P_PARCEL_NR NE "T16.APAR".P_PARCEL_NR (SELECT "T16.APAR".P_PARCEL_NR FROM QS36F."T16.APAR" AS "T16.APAR" WHERE "T16.APAR".P_YEAR =...

    lorit365 pointsBadges:
  • Problem with the READ from PF in RPGLE

    Hi ! Im trying to read a physical file from my RPGLE program. That physical file having many fileds. AGCDE is the one of the filed there. The AGCDE data is from 001 to 700. But i just added it randomly. Now im having a problem with READ in RPGLE.. When i call the program its reading the Physical...

    Sureyz2,375 pointsBadges:
  • Determine if a submitted job has completed

    Hello ALL --- I have a CL program that executes a command which calls a CL utility program. The utility program submits a job that involves the building of a save file. The original CL program will then restore the contents of the save file into a library and obviously must wait until the submitted...

    mikechance81275 pointsBadges:
  • Deleting IFS files

    Would anyone be able to help me with the following code? I modified it to delete entries in a folder older that 35 days from today's date when the program is run. Thanks in advance for any assistance you can offer. PGM DCL &TODAY *CHAR 6 DCL &TODAY2 *CHAR 6 DCL &MBRDATE *CHAR 10...

    northwoods180 pointsBadges:
  • Job log spool file of a running job

    Can I create a spool file of the job log of a currently running job on the system?

    northwoods180 pointsBadges:
  • How to implement MOUBTN using RPG III/RPG400

    We are converting some code in a legacy application and, in its simplest form, want to know that a mouse has been used/clicked rather than ENTER pressed. We are not that familiar with the MOUBTN keyword, which we assume will tell us what we want, and are having trouble getting this to work. Though...

    Zack250 pointsBadges:
  • Expression to insert value to a table column in SQL

    My CL program has RUNSQLSTM. The SQL source has some SQL statements(source is of type SQL) which inserts value to a file. I need to change the SQL to have a column(FLD1) value like this (A*B*C)/10**D. A,B,C, and D are file fields. The attributes are like this A- (15,2) B- 13 C - (13,5) D - 1 I have...

    RamvishakRamesh2,505 pointsBadges:
  • SQLRPGLE- Query Not fetching records in program

    Hi I have below query in my program , when i executed it interactively thro strsql , its fetching records but the same query is not fetching records when i execute it in my program. Please provide your valuable answers as soon as possible.. as i need it very urgently... As si mentioned it has...

    Hamsu95 pointsBadges:
  • UserProfiles in AS/400

    Hi Group, I am unable to access my UserProfile, I checked the status its in "ENABLED" state. What could be done to access it. What are the reasons for the UserProfile in AS/400 being disabled. Regards, MVRK

    mvrkrishna530 pointsBadges:
  • moving file from ifs into qgpl

    How is this accomplished ? thx.

    BBIIlizard20 pointsBadges:
  • Can’t print correct library list out with Java

    We have several customers running on our hardware. For these customers we set up job descriptions to keep library list information since they all have their own database files. I have a Java program that runs as a batch program at a set time to update a database file for each customer. I create...

    DraeByllek45 pointsBadges:
  • Is there a way to recover the source code from a program?

    Hi, I lost the source code of a program with a couple of modules, but I have the *PGM and *MODULE which were compiled with *ALL in debug option. is there a way to dump the source code in a source physical file or in some place? Thanks.

    GraceP415 pointsBadges:
  • AS/400-Grant User access to use the ID that is used to submit the Scheduled Job

    Our AS/400 operating system is OS/400 V7R1. User need access to the USER profile which is the profile under which the Scheduled job is submitted. How do I grant access to allow this user access to this profile? Example: Bob is requesting access to be able to use the user ID, SAMBATCH. This ID,...

    harpsk95 pointsBadges:
  • How to change display file text after compilation

    I created one display file after compilation when I am trying to edit some text in that display file using option 2.when I type the new text, it displays only capital letters only. I am unable to type lower case letters. Please tell me how to type small case letters in that display file.

    gsivakkp86220 pointsBadges:
  • How to change fields from one type to another type in display file

    I created one display file and declare numeric field as output i.e +6(10).please tell me how to change that field from output to input&output i.e +9(10).

    gsivakkp86220 pointsBadges:
  • Web servers

    Having created a website, how does one load it onto an open source web server?

    moneybag10 pointsBadges:
  • Deleting IFS records after so many days

    Can anyone provide CL code that would delete records within a date range? I would like to delete entries, say-that are 35 days old from the IFS.

    Rrbond07135 pointsBadges:
  • Data area in RPGLE

    I want to create an id that is auto incrementing in RPGLE using data area.

    rpgledataarea12345678910 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