• AS/400 RPGLE Program – Verifying a user profile

    I have a client that wishes to use a valid program in an entry application.  How can I verify a user profile within an RPGLE program? 

    Farmboy6920 pointsBadges:
  • How to break text under EMAIL body received from Iseries Infoprint PDF mapping program

    Hi Friends, We have info print installed on our iseries box. When we are generating PDF files under email using info print server, we can customize the following two messages under email:- 1. Subject line 2. Message/Body text (MSGTEXT) under the mail. My query is that I need to break the lines...

    Abhiasfriend5 pointsBadges:
  • 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

    svankipu560 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:
  • How to sort Alternate Array?

    Arr1       s        10 A Dim(4)   Perrcd(2)  Fromfile(abc) Arr2       s         2  0  Dim(4) Alt(arr1) Now , I have load records From file to that array then i want to show these record in reverse Order How i can do this?

    Sms121185 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

    GHENDER175 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:
  • Communicate with a RS232 device in my RPG program

    I need to retrieve the weight from a scale hooked to my PC with via RS232. I need to send the device a character(P) and which will trigger the scale to send back the weight. Thanks.

    10155 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:

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