• 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:
  • AS400 PRINTER FONTS

    I have been asked to produce new printed output in the Helvetica style. I have looked high and low for the font codes to plug into the CRTPRTF cmd with no sucess. Where can I find a listing of these 2, 3 & 4 byte codes (ie 18, 82) We don't have printed documentation on site, and I seem to be...

    MONDOU0 pointsBadges:
  • Question on Workfile

    Hi, Please could any one help me getting answers to these Questions.... What is the diff. between Workfile and PF? How do u create a WorkFile in RPG or CL. What are the advantages of WorkFile over PF? Thanks Rama

    0 pointsBadges:
  • Trying to publish a Webfacing Project

    Using WebSphere Development Studio I've created a WebFacing project converted an existing application on our iSeries to a WebFaced application, but i can only access the WebFaced application from my PC. How publish the application to a web server so that other users can access it. I tried exporting...

    Slaliberte5 pointsBadges:
  • Font IDs

    I have created a printfile with a devtype = *AFPDS. One of the reasons I have done this is to take advantage of the different font sizes. Does anyone have a list of all the fonts and their corresponding print types? For instance, if I wanted to print in gothic or italics, what font size would I...

    GHENDER190 pointsBadges:
  • Object Conversion

    We are running an RPG program on the AS400 which was written years ago. Unfortunately at some point, the source code was deleted and we now need to make changes to the program. Is there any utility which would take the object and convert it to source code?

    GHENDER190 pointsBadges:
  • How can I find on which files a program has been attached as an external trigger?

    I have a "generic" rpgle program that can be attached to any physical file as a trigger. And so it has been, many times.. Is there a utility that I can use to find exactly what files have this program attached as a trigger? Or some table where I can look? Thanks! Kevin

    Beercheck0 pointsBadges:
  • Reg Data extraction from one environment to another

    Hi Consider i have testing library and development library in my library list. Say for eg, given a shipment ID i need to copy all the relevant data from testing enviroment to development environment. Since the file objects reside in testing and dev environment how will i be able to fetch data from...

    Rafiqm0 pointsBadges:
  • Printing a barcode from the O specs of an RPG program

    Specifically, I need information on how to print a barcode from the O specs of an RPG program. I found an example to print a barcode by passing hex in the O specs, but I didn't understand the how to part. I realize this is an older way of printing a barcode as I am aware of how to use the DDS and...

    Wooting0 pointsBadges:
  • Getting job log info into RPGLE program

    I'm looking for an easy way to get "error" information from the job log into my RPGLE Program. I'm "monitoring" a CHAIN to a file for an "unable to allocate" error, and would like to pop-up a window to display who is locking the record. How do I go about doing this? Thanks

    MMAGuy85 pointsBadges:
  • Using an array in embedded SQL in RPGLE

    Is there a way to specify a host array element in a where clause in embedded SQL? This is what I am trying to do: C+ Where TkPart01 = :odPart(01) C+ and TkQty01 = :odQty(01) C+ and TkPart02 = :odPart(02) C+ and TkQty02 = :odQty(02) There's more to it than that but that should give you the general...

    Vatchy1,410 pointsBadges:
  • MS SQL Server 2000

    Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

    Sudh2k0 pointsBadges:
  • CPYTOIMPF Nightmare

    I am using this to transfer data from the S400 to the IFS. The data has to be tab delimited. I am the sending the data to a UNIX box. the problem is I am a getting a carriage return at the end of fields - and it appears to be random. Here is my command CPYTOIMPF FROMFILE(*LIBL/IOBEXT) +...

    Raddy590 pointsBadges:
  • OPNQRYF’s MAPFLD

    I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined this way...

    JohndeCoville0 pointsBadges:
  • Display Footers in Subfiles

    Hi, I have a dual display subfile. I am able to do display the screens allright but it's the footer record i am unable to display at all. I have made sure that the second subfile record doesn't overlap my footer area (by footer, i mean the area where i want to display my Function keys). I have used...

    Me2learn0 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