• SQL and CL

    I would like to learn more about putting SQL in CL and RPGLE. What is a good way to learn about this?

    Popers40 pointsBadges:
  • How can I tell what fields from what files are being used in a rpgle program?

    I need to know which fields from which files are being used in the program. The compilation listing helps but doesn't tell me which file.

    Waggom5 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:
  • Multiple record locks in a single file.

    How can I attain multiple and simultaneous record locks in a single file without using commitment control? (...in RPGLE...)

    bogeybetsy560 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:
  • Updating a file on the basis of rrn

    Hi All, The question is: Can we update a non keyed file on the basis of RRN retreived by the INFDS. FABC UF E DISK INFDS(DS1) D DS1 DS D RRNF 397 400I 0 If yes than how. If no than why. Thanks in advance

    navinnegi45 pointsBadges:
  • DDS Screen scraping

    Hi. I don't know if this is possible but I want to read an interactive DDS display while it's running and then input data from an external file into the display like a screen scraper does?is there any kind of overlay on a active DDS panel I can use in my program? any help anyone?

    Jlvbros0 pointsBadges:
  • Deleted files

    WE have a PF file that got deleted, we don't do job logs unlwss there is a problem...is there anyway to tell who deleted it? Also for in the future, what is the best way to be able to track deletions? We have 9 people that have all obj authority. Also is it possible that the file could get deleted...

    ATitus85 pointsBadges:
  • INZSR and primary file

    Hi All, If we have a primary file and INZSR then where the control will go when the program will be called. What will be the exact processing. Advantages of primary file and INZSR subroutine. Thanks, Navin Negi

    navinnegi45 pointsBadges:
  • Connecting AS/400 to HP printer

    How to connect AS/400(Client Express which is ruuning in Windows Xp) with HP printer?

    Johnfranklin0 pointsBadges:
  • How do you convince Corporate Mindset that RPG is not a dinosaur

    Given that the conservative nature of Corporate thinking does not allow you to try the new features of RPGLE (XML, internet enabling APIs, etc.) How do you convince them that RPGLE is not a legacy system dinosaur that can't compete with JAVA (or .NET, etc.)

    BigKat8,460 pointsBadges:
  • Batch or Interactive

    Is there an easy way in RPGLE to determine if the program is running in batch or interactive, like you can in CL? Thanks...

    Rickyboy0 pointsBadges:
  • Tracking Changes to Files

    Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. 2. If Any changes...

    AyeYes4000 pointsBadges:
  • Detect is someone created, changed or deleted a document in the spool.

    Hello, I want to know what methodology I should use to detect if someone has created, changed or deleted a document from the spool so that I can perform an action. Thank you

    TozesRamas0 pointsBadges:
  • using function key in a subfile field

    I'm trying to figure out how to use the F4 on any of the subfile fields to pop up a window and then: select "info" and bring it back to the subfile and populate the subfile field in the correct "order." Is there an easy way to do this?

    MMAGuy85 pointsBadges:
  • Find if a spool file exists

    Using RPG, how to find if a spool file exists. I would like to pass spool file name and job details as parameters to RPG program.

    RajKamal0 pointsBadges:
  • Help in CL and RPG

    Hi, I can execute a CL command in an RPG pgm by calling 'QCMDEXC'. But there are certain CL commands that i cannot execute using 'QCMDEXE', what are they? Thanks in Advance Rama krishna

    0 pointsBadges:
  • Error in a Group of Called Programs

    Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC.......so on...10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this???...

    0 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