• SQLCOD = -7008 when doing an insert into file using SQLRPGLE

    Hi, I'm trying to insert selective records from one file into the same file in another library. I have to do this for many file. Am building the query dynamically using SQLRPGLE. Am using a PREPARE statement and an EXECUTE statement to run the query. While the PREPARE statement ends fine, am...

    SasiKumar0 pointsBadges:
  • How to reset the password??

    Hi, How to reset the password through a CL program. The user has forgotten his password, even ADMIN doesn't know the password. Thanks, Rama krishna

    0 pointsBadges:
  • Unexpected results in data

    I work with a TP software product that allows me to pass data back and forth from within that software using my custom program (RPGLE).  I have my custom RPGLE program that reads files in a main software I work with.  My RPGLE program sort of works like an API but it does not set on LR.  I am...

    Pt0505145 pointsBadges:
  • OVRPRTF not chaning OUTQ

    I have a program where the OVRPRTF command does not seem to be taking affect.  The output is going to the job's default outq and not the overridden outq.  The following are consecutive lines from the job log:

    ElTerrifico620 pointsBadges:
  • Data Q

    I need to check whether there are any data found in a data Q. Is there any way to do that? Appreciate if you can provide sample executable codes for me to test it on. Thanks...

    JennyChin0 pointsBadges:
  • On the as/400 i series can one use SQL querys to update file

    Cobol uses some kind od IKJ module user exit to allow DB2 SQL calls. I want to make a keyed read update one field and go on to the next record and do the same until end of file. Can do the same using RPG and if so could give me an idea what the code would like. How would the updated file be...

    nitzinger385 pointsBadges:
  • RPGLE external stored procedure when called with OUT parameter having issues when called from C#

    We have created some stored external procedure with paramter type OUT but these were giving memory protection at C# side.However when we call it from operation navigator ,it is running succesfully.I created some SQL stored procedure with OUT paramteres and these were working correctly when invoked...

    Arush5 pointsBadges:
  • Impact analysis

    Hi, The user requested me to change the field length from 25 to 30 char. I want to do impact analysis on this. How do i proceed?? Thanks, Rama Krishna

    0 pointsBadges:
  • Calling RPG program without Parameters

    1) I have an RPG PGM 'A' which call's another RPG PGM 'B'. PGM 'B' accepts 3 parameters. But i need to call PGM 'B' without passing parameters. How to achieve this??? 2) I have an RPG PGM 'A' which call's another RPG PGM 'B'. PGM 'B' doesnot accept parameters. But i need to call PGM 'B' with...

    0 pointsBadges:
  • Accessing the other users object.

    Hi, I donot have authority to access another users object. I donot know the userid or password of that user. How to get access to it?? Thanks, rama krishna

    0 pointsBadges:
  • Copying Spoolfiles

    Hi, I would like to know, How to copy spoolfiles from one AS400 machine to another AS400 machine? Thanks in Advance Rama Krishna

    0 pointsBadges:
  • Problems eliminating HEX 41 character.

    I have a number of files on my DB2/400 database that have spaces with a Hex code of 41 instead of 40. This causes a problem when FTP'ing to a PC for integration with a barcode labeling application. Does anyone know how I can change this character to ANYTHING other than Space HEX 41 !! Potentially...

    Selectsoft65 pointsBadges:
  • AS400 disk initialize info

    Hi All, I am trying to find printable results or logs for a disk that has been initialized successfully by using SST or DST. The procedure normally completes with a single line of "COMLETED SUCCESSFULLY" I need more infomation like model, serial no, sectors or some proof that this particular disk...

    Jf79210 pointsBadges:
  • Help in Decimal Data Error

    hi , we have tow RPG code, where in 1 RPG say PGM A calls the other RPG PGMB. while calling PGM A passes a parameter to PGM B. the attributes of the parameters is supposed to be 2,0(Zoned), when we called the PGM B we faced a DECIMAL DATA ERROR. now the issue we found out is that in PGM A, the...

    0 pointsBadges:
  • Using indicators

    Hi All, I have two problems. Please help 1) If in a RPGLE program. We have already used all the general purpose indicators. Then what are the ways so that we can maintain other extra indicators in the program. 2)How can we retreive the RRN number of a PF in a RPGLE program.Is there any keyword.

    navinnegi45 pointsBadges:
  • Reading/Updating a PF on the basis of RRN

    Hi All, Please tell me how can we read or update a PF on the basis of RRN. Thanks.

    navinnegi45 pointsBadges:
  • SENDING A BREAK MESSAGE

    I HAVE WRITTEN A CL PROGRAM WHICH USES QEZSNDMG TO SEND A BREAK MESSAGE TO SPECIFIC USERS. IT WORKS PERFECTLY EXCEPT IF THE USER ISN'T SIGNED ON, HE DOES NOT GET THE MESSAGE UNLESS HE DOES A DSPMSG. IS THERE A WAY TO MAKE THE MESSAGE AUTOMATICALLY POP UP AFTER THE USER SIGNS ON?

    GHENDER200 pointsBadges:
  • Comparing 2 files .CSV and getting the missing data using AS400.

    I have 2 files of .CSV format. I need to compare them and capture the missing data into Excel sheet. How do i do this using AS400???

    0 pointsBadges:
  • OPNQRY Question

    Answer Updated

    ABAPER0915 pointsBadges:
  • Pointer or parameter error

    New Discussion Post

    Abhiindia15 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