• 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:
  • 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:
  • Use Dynamic Create Table Command in Stored procedure

    Does any one know how to pass a library and table name variable to the SQL CREATE TABLE Command? I need to be able to build the tables on the fly and the name needs to be different each time the table is created. I am calling the SQL Command from within a Stored Procedure. Thanks

    FCARPENTER200 pointsBadges:
  • How can i install SAP BW 3.0b

    When i'm trying to install BW 3.0b, installer saying that oracle not installed. I think the oracle installer and patches are in the disk 2. do i have to install oracle separately, if not then how do i proceed with the above? Is there any step by step installation guide available for this?

    Prashsingh0 pointsBadges:
  • Upload to AS400 DB file

    Hi I am not so proficient in programming and i am looking for a way to upload an excel sheet into a database file (with same columns as in m excel) on the as400. I tried to FTP, but i goes in as a flat file. Various other FTP options using FDF etc have failed. Any suggestions ? Thanks Raman

    Dashingraman15 pointsBadges:
  • Parsing parameters for a Command to be run In a CL

    I need to allow a user to enter a command at the command line followed by the &Library/File, or just the &Filename. (if they are going to rely on their library list). EX: SHOWME &LIBRARY/FILE or SHOWME &FILE My CMD is running the true IBM Command under the covers so the user does not need to wade...

    FCARPENTER200 pointsBadges:
  • SDA

    Is there an easy way to find out what source file and library were used to create a menu?

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

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