• H Spec

    Dear All !! Q1. Can we define the compile option - debugging view (DBGVIEW) = *all in H spec ??? If yes, please let me know the syntax. Q2. How do we retrieve system date in RPG or RPG IV ? [Note : *date or Udate retrieves the job date] Thanks and regards, Kalpesh

    Uppikal5 pointsBadges:
  • Data mapping errors when reading records with time fields…

    I'm trying to access records from a file that has eight fields defined with the time attibute. When I examine the data held in these fields they are mostly set to *LOVAL i.e. 00.00.00 in *ISO format which according to the RPGLE reference manual is an allowable value. However, when my program...

    JonathanG0 pointsBadges:
  • Extracting details from timestamps…

    I have a timestamp field from which I need to extract the date portion into a packed(7,0) field in *cymd format and the time portion into a packed(6,0) field in *hms format. We're running V5R3. What is the neatest way to achieve this?

    JonathanG0 pointsBadges:
  • 400 to 400 printing

    I need to have a spoolfile on AS400#1 that is directed to an outq on AS400#2 as it is created and/or move it manually from outq on #1 to outq on #2. A remote outq exist on #2 but I seem to be missing something on how to access it from #1. The remote outq on #2 will print on printer created on #1. I...

    Bigmac461,000 pointsBadges:
  • System Setting For Created Libraries

    Hi Everyone. An odd question, when we create new libraries on the 400 they are automatically flagged in the SETUPBCKUP screens for Daily/Weekly and Monthly backup. Where can I change this attribute for new libraries created on the system? Thanks, Rayden.

    RaydenR0 pointsBadges:
  • Open List of Spooled Files (QGYOLSPL) API Filter Information Format OSPF0200

    Our company has more than 85,000 spoolfiles to be filterd in different ways. I use List API QGYOLSPL with Filter Information Format OSPF0100 which was very qick. But to aply for a date range you have to use Format OSPF0200 where I got errors. Can anybody give a code example to flter usernames...

    Ranjithj0 pointsBadges:
  • cursors left open in embedded SQL

    I have a problem with SQL cursors being left open, even after the "close cursor" instruction has been executed successfully (SQLSTT = '00000') from within an RPGIV program. There are 2 cursors within the program: 1 cursor is used for fetching the count of selected records, the other is a dynamic...

    Chance105 pointsBadges:
  • Retreive program atrributes and save information in a file

    I need to create a program that will check the activation group for all our ILE programs. I know that using DSPPGM command I can see the activation group for a specific object. Is there a way that I can have similar results but have the information stored in a file? Then I can read the file and...

    MayraPR5 pointsBadges:
  • Retrieve Job Lock (QWCRJBLK) thread ID

    Does anyone know how I would get the thread ID of another job in order to retrieve the job lock info? This is the fifth parameter of QWCRJBLK. I will be using the QUSLOBJ API to retrieve all jobs on the system and then want to determine certain locks on those jobs. QUSLOBJ does not appear to...

    Lpar2dev030 pointsBadges:
  • How to find number of bytes read/written in RPGLE?

    Dear AS/400 Lovers! In a program, I need to find the number of bytes read from a file(FILE1) & written to another file(FILE2) in RPGLE. I need to maintain this in an Audit-file for Audit purposes. Has anybody done this earlier? any help would be of great value. Thanks in Advance, Svanky

    svankipu620 pointsBadges:
  • AS400 call from dot net component

    I have dot net system which calls RPGLE program interactively. the AS400 program processes stuff perfectly when called from AS400. however when called from dot net following happenes- 1. dot net componet doesn't return any error. end code is - 0. it runs successfully. - this means there is no...

    Nutan70 pointsBadges:
  • OPNQRYF and iSeries V6R1 issue

    I had responded on a previous issue and it is suggested I create a new one for mine. Doing that and I am adding some of the info below my question.  I hope this is not too confusing.  I apologize in advance if so.  I starting having an issue with a RPGLE program after it was recompiled due to a...

    VGP300 pointsBadges:
  • Embedded SQL in RPGLE

    I am trying to get some counts and totals from one file and put them in another. My SQL statement works fine with STRSQL, not in the RPGLE. Do I have to declare/set a cursor, exec sql and close the cursor just to put the total in another file? C/EXEC SQL C+ INSERT INTO outputfile C+ SELECT...

    Nickhutcheson165 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:
  • When will AS/400 record lock?

    Hi Guru's , I am new to RPG . I would like to know when record will be locked ? Example-1 : PGMA, using a PF1(Physical file) in input mode , PGMB using a logical file based on PF1, in input mode. In this case record will be locked or not (using read or chain or setll operation codes) ? If I will...

    SARKNS30 pointsBadges:
  • SQL RPGLE – How to override data set data structure at run time

    I currently have an SQL RPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 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:
  • CLLE program

    I am new to AS400.I just learnt CLLE and i am facing the problem with the parameter that send from a RPGLE pgm to a CLLE pgm. The first pgm is to prompt the user to key in the date which is a numeic field. The coding for the first pgm is : FWKCFFM CF E WORKSTN * Parameter List Definition C...

    Cev105 pointsBadges:
  • What is the best way for me to handle clearing work files?

    Program in RPGLE. I have 2 work files in my program. They hold possible matching data for a name, birth, etc. I have rules where I search the file and determine how many parameters match. I have to delete records if I don't have a minimum of fields matching.  I make several runs through the file...

    Pt0505145 pointsBadges:
  • MQ depth through CLLE Or RPGLE programs

    am trying to search is there a way to know the MQ depth in RPGLE or CLLE programs using some set of MQ API's or MQ command.

    Manojdeshmukh5 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