• Spell check in CL on AS/400?

    How do you do spell check on CL?

    AS400 - Ask the Expert485 pointsBadges:
  • Tuning DB2/400 queries on iSeries

    We are using lot of DB2/400 queries in our iSeries system. Are there any tools available on the market to tune them?

    AS400 - Ask the Expert485 pointsBadges:
  • Clearing a PF record on AS/400

    I'm chaining a field to a unique keyed PF. I'm getting a not found indicator so I'm trying to write the record but I receive a duplicate key error. How this can be I do not understand. A colleague suggested that a field (or fields) within the record might be a key of other LF's over the file and I...

    Floyd02320 pointsBadges:
  • Creating a Java database

    I want to create a database (not table) using java. Is it possible? If Yes then what should I do? Tell me detail procedure if possible.

    AS400 - Ask the Expert485 pointsBadges:
  • Creating a text file from AS/400 for a purchase order

    I would like to create a text file from the AS400, I need to be able to have a header line followed by line details. It's a Purchase Order which I need to email as a text file. What is the best way of doing this?

    AS400 - Ask the Expert485 pointsBadges:
  • How to view online the new data added to a PF?

    Hi, I need to display in a subfile the new data added to a phisical file, in real time. Who knows unix, this is something like the command "tail -f". Thanks a lot!

    Mariodlg2,790 pointsBadges:
  • How to get the row count of a PF with RPG ILE?

    Hello, I'm looking for an example of how to get a row count of a PF from a ILE rpg program. Thanks everybody.

    Mariodlg2,790 pointsBadges:
  • %ERROR function in RPG

    How to use % error built in function in rpgle program any code example please?

    6r1,590 pointsBadges:
  • How to access all records in RPGILE

    hi all, suppose i have a report with input criteria 'machine code' and requirement it that if i input a perticular 'machine code' then it should COME only that , otherwise all records of all 'machine codes' should come , in clp i use %WLDCRD for that. but i need to do it in rpgile , is there any...

    Ambrish 82310 pointsBadges:
  • Running AS/400 Client Access basic operations functions in Citrix

    Have publised client access with CITRIX. Everything works fine. But when users try to view the outputs using the basic operarion's printer output option ,an error message is issued. This happens only when it is to be done through CITRIX.

    AjithW35 pointsBadges:
  • rpg

    I have created a subroutine to update a display file. key CHAINfile 90 *IN90 IFEQ *OFF MOVELfieldvalue screenvalue EXFMTscreen MOVELscreenvalue filevalue UPDATrecfmt of file END ENDSR Is this logic right? 1.the value in the file is not getting displayed when screen is invoked 2.the field appears...

    0 pointsBadges:
  • who is signed on to the as400

    Having been in unix too long don't have the command to display the active users on the as400, like the who command in unix

    Dlopomo5 pointsBadges:
  • CPY an IFS file from one directory to another

    I have a file in a folder on the IFS -we will call the folder MYFILES and the file is FILEA. I want to copy a duplicate of the file to folder YOURFILES with the name FILEA. The command is: CPY OBJ('/MYFILES/FILEA.csv') TOOBJ('YOURFILES/FILEA.csv') REPLACE(*YES) I get the following error: CPFA0A9...

    docorp15 pointsBadges:
  • Differnce between source physical file and physical file on AS/400

    What is AS/400? Difference between source physical file and physical file?

    AS400 - Ask the Expert485 pointsBadges:
  • Need an iSeries SQL that will reduce mutilple entries to one per type

    I need to produce an extract that is a combination of two files. File A has a policy number and a folder type. File B has the document number. File C will be the product of File A and File B. I can join the files on the policy number and folder type to get the document number, however, I need to...

    FCARPENTER200 pointsBadges:
  • calling java function running on websphere from as/400

    How to call a java program running on web sphere application server from System i? We are able to call a java program deployed on System i on IFS directory using RPG ILE.

    Uiiuo50 pointsBadges:
  • AS/400 report takes too long to print

    I have created a invoice on my as400 with a overlay. I send this to a printer and it takes very long to print. The file size is 28kb. Is there something i can do to make it print faster

    Trev25 pointsBadges:
  • AS/400 object location in library

    Hi, I am a very new user to AS/400. I am using a RUMBA client and part of my "ticket" is entered through a free notes section. I can query other items such as customer name, dates, numbers etc etc, but i do not know how to locate where the object is for the "free notes" section to query this for my...

    Markmark10 pointsBadges:
  • RSTLIB and Journaling

    I am doing a SAVLIB of our Production Data Libraries creating SaveFiles on our Production iSeries, then thru FTP, transferring the SaveFiles to our Development iSeries, then doing RSTLIBs. During the RSTLIBs I get a CPF7085 - Journal QSQJRN already exists and CPF3756 - JRN QSQJRN not restored. It...

    wpoulin2,480 pointsBadges:
  • Converting to .txt

    Hello All, I'm trying to convert an AS400 database file to a .txt with pipe delimeter and I want to make the .txt file name a batch number. 0012345.txt Any help is greatly appreciated.

    Breinhart45 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