• RPG/400: Maximum and minimum values

    Please advice how to find out maximum and minimum values in particular filed using rpg/400.

    Askt1140 pointsBadges:
  • How to get a Lastname from a field that contains the Full Name? (RPG-ILE)

    Hi Guys, I need your suggestions.... I have to extract data from our AS400 box and convert it into text file. For a client's name we have 3 particular fields. 1. FirstName, 2. LastName and 3. FullName. The problem is there are records where First Name and LastName fields are empty. Thats why I have...

    Niel5 pointsBadges:
  • I want data from AS400 PF to my windows system in form of XL sheet.

    I want to create a pgm in any of the high level language supported by AS400. I want that when this program is run, an XL sheet is created and all the data in a specified PF should come in this XL sheet. If I am right, then every XL sheet has a limit on the number of rows it can accomodate. If...

    AbhishekRam5 pointsBadges:
  • Validity Checking Program Message

    My VCP returns when an error in encountered but does not return the message. I have coded as per the documentation with the exception that I 'compose the message' instead of using a message file. (see below) CHGVAR VAR(&MSG) VALUE('ELEMENT ' *CAT &CURTXT *TCAT + ' - Member ' *CAT &RMBR *TCAT ' is...

    ECLAY25 pointsBadges:
  • What is mounting a partition

    What does it mean to say that some directories can serve as mount points for other paritions? I know what a partition is; Windows trained trying to get Linux+ cert but some things I can't relate to like the question.

    Rtrahan5 pointsBadges:
  • I have an OVRDBF command that quit working.

    I added 3 fields to each of the files referenced in the OVRDBF command and then recompiled all 5 CLP's that have the same OVRDBF command in them. Here is a copy of the CLP.... CHGVAR VAR(&TITLE) VALUE('SETLMAST' *CAT &YEARC) CPYF FROMFILE(*LIBL/&TITLE) TOFILE(SM1099) + MBROPT(*REPLACE) FMTOPT(*MAP...

    BobAnnBri5 pointsBadges:
  • Can embedded SQL in a SQLRPGLE program be used as a stored procedure?

    I am successfully using (external) stored procedures with many RPGLE programs. (Some of these are SQLRPGLE programs because they return a result set.) All of this works fine. But if I try to replace some of the RPG I/O in a RPGLE program with embedded SQL, creating a SQLRPGLE program, and run it as...

    Warykat20 pointsBadges:
  • AS400 Profile Change Query

    Hey guys, can anyone provide me with information to query and produce a report that shows the date and time when a user profile was changed.

    Johnb2015 pointsBadges:
  • Job Scheduling in AS/400

    How do I schedule a job in AS400?

    Leandelf5 pointsBadges:
  • AS400 Query

    Hello, How can you add a WEEK e,g, . *Monday thru Friday in the DEFINE RESULT FIELDS ?

    Querys100 pointsBadges:
  • ASP getting increasing

    Hi All, One of the our production server its V5R4.3 months back only we bought this server.Perviously its working fine.But Nowadays ASP is getting increasing some times its went 55% also.we deleted some JRNRCVRs which are in SAVED status.but still its getting increasing.Any one know why its...

    MQ admin110 pointsBadges:
  • COPY data between to files with SQL in iSeries

    hi, i need help with this: i have two files in Iseries one of them is new and other have old records and i pretend with sql copy some records. But file 1(new) and file 2(old) they don't have same collums file1 file2 fielda fielda fieldb fieldb fieldc filedd fieldd how can i make the correspond...

    BUG68225 pointsBadges:
  • WEB / iSeries

    Where do you foresee browser-based iSeries access applications going, with regard to development portals, user interface methodologies, etc. ?

    Tsmith7155315 pointsBadges:
  • I RECECEIVED A CPPEA55 ERROR MESSAGE

    MY TAPE DRIVE WENT DEAD PULLED IT OUT. I ISSUED A PWRDWNSYS COMMAND. IT WENT DOWN BUT I DID NOT UNPLUG THE BOX. AS SOON AS I BROUGHT THE BOX BACK UP I RECEIVED A CPPEA55 ERROR MESSAGE.

    RESPUGA25 pointsBadges:
  • How can I transfer an ASCII file with negative numbers to my iSeries

    I need to transfer an ASCII file that has a field that may contain negative numbers to my iSeries. I'm getting nowhere with this. Can someone tell me how I might do this?

    Rscoville15 pointsBadges:
  • RPG edit code for signed value

    Hi I have moved a numeric value to a ds. I have used this EVAL F1 = %EDITC(ABC:'3')-here F1 is part of flat file DS and there are decimals required in the output file.I am getting the decimals but my problem is that ABC field from i/p file could be negative but am not sure how to get the sign to...

    0 pointsBadges:
  • Full description of all the TCP/IP servers

    Hi folks, does anyone know where I can find a full description of what each of the TCP servers does? We recently had a problem and I was unable to find out which servers should/shouldn't be running. Many thanks

    Gross140 pointsBadges:
  • Lotus Notes Categories Disappear

    Suddenly today the display by Categories in my personal journal database has disappeared. Where did it go and how do I get it back? I have checked the documents. Each of them still retains the category, I just can't get the database to display by category any longer.

    SeekAnswers5 pointsBadges:
  • Iseries Queries.

    Hello, I have a query schedule that runs Daily and looks for events for the previous day and, it's access in access database, but on Mondays I don't get anything because is set for previous day and Sat and Sunday overwrite the query so I get ZERO results. I've set for YESTERDAYX. How can I change...

    Querys100 pointsBadges:
  • Data Area Lock issue in RPG ILE

    Hi, I am using a data area in a RPG ILE program which will lock the data area and updates value. If the data area is locked, the program has to unlock the data area which is locked by the same user in any of his other session. Is it possible? If yes, please let me know steps have to be followed for...

    frmdeva365 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