• RPG with Dynamic SQL Problem – SQLCOD 501/312

    I'm trying to do simple dynamic SQL in a program to select records for a subfile but it doesn't seem to be working. sSql = 'SELECT orderno FROM ordhdr ' 'WHERE custno = :scSrchCust '; following this I have: exec SQL CLOSE @Orders; exec SQL Prepare Stmt from :sSQL; exec SQL Declare @Orders SCROLL...

    MMAGuy85 pointsBadges:
  • Writing an MQ message

    I have to write a program that sends some data from MQ. I will read a data file process it, and then instead of populating a file and FTP'ing the file to a server. I need to send the data via MQ. How do I write the message to MQ, how do I set up the message length etc.

    Andy Mansell55 pointsBadges:
  • Multiple Sorts Without Using Multiple Function Keys

    When doing WRKACTJOB, you can put the cursor over the column you wish to sort and then press F16. I have a subfile program with multiple sorts and presently the user has to press different function keys to sort. Can anyone give me an example of the code to use so my program will act like that in...

    GHENDER175 pointsBadges:
  • SFL Application Help

    I have a SFL that has drop/fold capability and application help through out. The problem is when the SFL is in drop mode and additional fields are being displayed, how do I associate help to those fields? I cannot use the HLPID keyword as it's not allowed on the SFL record nor can I use *FLD in the...

    Floyd02320 pointsBadges:
  • Data Max M class 2 setup & RPG code sample

    Looking for someone who has set up the new Data Max M class 2 ethernet printer on an as/400 that can provide the device/out queue description and a sample RPG output spec. We have old twinax Data Max printers and the code does not print.

    Npjb5 pointsBadges:
  • Header Specification

    When I compile any RPG program that time I could also see all comment lines from the program in Spool File. If I dont want to see those comment lines in the Spool File then what option do I need to specify in H Spec?

    Vids295 pointsBadges:
  • iSeries PDM CRTBNDRPG Parameters

    Hello The question is a bit long but the answer should be short so here it is. In order to run some pre/post-compile processing of RPG program I'm looking for a way of replacing QRN4CPP (CPP of CRTBNDRPG) with a CL program of my own that wil run Pre-Compile, Invoke the original QRN4CPP and then run...

    Gad75 pointsBadges:
  • How do I write a RPG automatic refresh screen like WRKSYSACT?

    I would like a RPG applicate to automatically refresh the page without the user's return. I have tried the write and read to the subfile with the CRTDSPF WAIT field but with no success. Any suggestions

    Supertaz10 pointsBadges:
  • serch for reference of PF/LF

    Is there any command to find out any perticular PF OR LF used in which RPG program across all libraries and SOURCE PHYSICAL FILES ????

    BU115 pointsBadges:
  • %replace BIF

    Anyone have an example how to use this bif?

    Kstinman5 pointsBadges:
  • How do you auto refresh a display in a RPG program?

    We would like a never ending RPG display program to refresh every five minutes. Any suggestions?

    Supertaz10 pointsBadges:
  • rename a file in a loop procedure

    I am writing a pgm that reads a file and outputs a PDF to the IFS. the problem is I need to rename the file for eace splf conversion to pdf; how would I write that in CLLE? or would ir take a RPG pgm to do this? Thank you, Robert

    Rrock15 pointsBadges:
  • Message file

    I am using RPG II on an AS400 opererating in a system 36 enviroment. I've created a message file for our Order Entry program by making a copy of an exsiting source and adding an additional message and MIC. It was tasted using: // member user1-ntrymsg and // * 1251. The message I added was...

    Ruxx665 pointsBadges:
  • COBOL I-O-FEEDBACK area

    I'm trying to find the breakdown of the I-O-FEEDBACK structure used in COBOL/400, what information is at what offset. One might think that should be an easy piece of info to obtain, but I've just spent 2 hours at IBM sites and in IBM manuals on the web, and every manual that mentions the structure...

    Unknowingone195 pointsBadges:
  • Cursor using update and order

    I'd like to declare a cursor to traverse a file in keyed order, updating some records It looks like I can do one or the other, but not both, that is I can set up the cursor with the order phrase or the update phrase buy not both. Is there a reason for this limitation? ec/exec sql c+ declare...

    Unknowingone195 pointsBadges:
  • SQL update question

    I'm new to SQl and cannot figure out how to do an update without listing every field in the record, sorry, row. The file I'm updating has about 50 fields, any of which might be changed. They are in an external ds that maps the record format, so it would be nice to say update set record = :myds but...

    Unknowingone195 pointsBadges:
  • AS400

    hi, i want to know about the answers of these questions.. 1.) If any data has been deleted from the PF then how can we recover that and what are the limitiations for that. 2.) If in run time user want to choose the Access Path of a PF then how can it be possible.

    AS400person0 pointsBadges:
  • Source Modified User

    Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy

    NarasimhaReddy225 pointsBadges:
  • Question on RPG

    1. How to process records of specific MEMEBER of file

    Mdshadabalam85 pointsBadges:
  • Physical File

    I have a Physical File which is used in a RPG program as A. I added one field to the Physical File and provide LVLCHK prarameter as *NO in CRTPF command and did not comple the RPG Program A. Now what will happen if I tried to update or add record in this file from the Program A? Will it give me any...

    Vids295 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