• 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:
  • Send messages from RPG

    Hi everyone! Do you know if there is a way to send text messages from an RPG program to a cell phone, by using a command or something like that? Or, could you tell me how to send an email message from an RPG program, using commands or APIs? Examples would be greatly appreciated. Thanx in advance!...

    FreyaMVG0 pointsBadges:
  • email attachments sent from iseries

    email attachments sent from the as/400 either via SPOOLFLEX or the SNDDST command to a mobile device (a T-Mobile phone) arrive with carats (<>) around the file name. (i.e. <test.txt> instead of test.txt) As a result the mobile device cannot open the attachments..PDF's, txt etc. etc. Is...

    Cgraves5 pointsBadges:
  • Spool Managment

    Hello, My name is Marisa and i would like to know if there is some way no manage the spoolfiles, by that i mean, how can i monitorize the spoolfilesin the instance they are created or deleted. Thanks in advance.

    Cartoonia0 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:
  • Decommision AS400

    We have an older As400 that we are decommisioning. We want to make sure no one can access the data when done. Do you have any recommendations on the easiest way to do this? We are running on V3R7 operating system

    Suzie15 pointsBadges:
  • Error compiling RPG400 program

    Hi I am trying to compile an RPG program which is using an os/400 file that was created by SQL (JDE Table), the problem i am having is that one field within the table is a "Packed Numeric" Field however it has a length of 31 this causes an error, error reads numeric field is greater than 30 digits....

    Hazermark0 pointsBadges:
  • Compiling RPG400 program

    Hi I am trying to compile an RPG400 program which is using an os/400 file that was created by SQL (JDE Table), the problem i am having is that one field within the table is a "Packed Numeric" Field however it has a length of 31 this causes an error, error reads numeric field is greater than 30...

    Hazermark0 pointsBadges:
  • Excel Data Transfer Add In

    I tried transferring data from a physical file (AS400) using the Excel Data Transfer Add In (Client Access) and am getting cells with unreadable syntax. It appears that a space is being populated with a 4040 string etc. Is there a way to get the information transferred without having to modify the...

    Joe9250610 pointsBadges:
  • CA Express download from iSeries to excel

    I really really need help finding a solution to this problem. We have users that download files from the iSeries using Client Access Express into excel. The problem is that when the report comes up in excel the negative numbers have the minus sign to the right of the number instead of the left....

    2839005 pointsBadges:
  • How to unsubscribe

    I am getting ready to Retire from my current employer. I will not be working in this field as I have started a very different and unique business. have looked all around to find out how to unsubscribe but can not easily find out how. If anyone knows how, please let me know.

    CasNowak0 pointsBadges:
  • V5R2 or V5R3 in AS/400 720

    Dear Colleagues, We have an AS/400 720 with V5R1. We need to install an application that requires V5R3. Can you tell me if it is possible to install V5R2 and V5R3 in it? Thank you.

    Gbenitez0 pointsBadges:
  • CPYTOIMPF and DB2 Field Names

    I have created an outfile from a series of iSeries queries and have successfully copied it to a CSV file on a Windows server share. However, the field names don't import with the CSV file. Is there a way to import the field names as column headers in the CSV using the CPYTOIMPF command or another...

    BruceU15 pointsBadges:
  • URGENT!!! file field decoder generated on AS/400

    REALLY URGENT!!!!!!!!!!!!!!!!!!!!! How can i view the contents of a packaged field? I send an example of the chain. I need to visualize the contents of the little squares: 5 1 91010 491997 9801011L 980101 1 1021023 102 103 100 DTO CARULLA DTO CARULLA DTO CARULLA 0 1 0 11 K 1TQ 15% Q TQ NAL T TQ NAL...

    Onasis0 pointsBadges:
  • Dialing out to a paging service

    Has anyone ever written a program that runs in batch and dials a paging service? I would like the program to navigate the service's prompts and and leave a message. The message can simply be a string of a few digits. Please respond if you know how to 1- dial the service or 2- simulate a human...

    JeffcoITDEv0 pointsBadges:
  • Retrive Field Value from Database File in CL

    My first attempt at reading a database file in CL. Have the following: DCLF FILE(*LIBL/DVACKWLV) RCDFMT(SCWACK) OPNID(WRK) DCL VAR(&WRK_SCADTE) TYPE(*DEC) LEN(6) DCL VAR(&FILEDATE) TYPE(*CHAR) LEN(6) RCVF OPNID(WRK) MONMSG CPF0864 EXEC(DO) /* End of file */ CHGVAR &FILEDATE (&WRK_SCDATE) Program...

    Suzuki93800 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:
  • BRMS Media Movement

    Does anyone know how to find out the move status of a tape in BRMS?

    Cstone800 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:

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