• Access path and open data path in DB2/400

    When will an access path be created, and when will an open data path be created?

    TNKR130 pointsBadges:
  • Add a field in existing file in DB2/400

    I need add a field in existing Physical file without impacting any other file? I know the CHGPF command but I'm not sure about which parameter needs to be update. Please advice.

    Askt265 pointsBadges:
  • Transfer data from DB2 file to SQL Server file

    I want to transfer a data from a DB2 file to a SQL Server file. I do not want to buy a software that do it. I want to do it by myself (perhaps using ODBC) Thanks all for help. Abdou

    HABDOU5 pointsBadges:
  • Uploading records in a text file

    Hi.. I have PF with this format Ex: PF1 R REC FLD1 FLD2 For the above PF1 file I have records in a text file. For that I need to upload the records without using iSeries navigator and FTP also. Can anyone guide me? Regards, Ajmal khan.

    shyedajmal285 pointsBadges:
  • AS/400 – Logical file without key fields

    I am creating logical file without any key fields. Here both logical file and physical file do not have any key fields. How will be the access path built here?

    rajeshece1,230 pointsBadges:
  • AS/400 query for logical file

    I have one join file and one logical file. It is possible to create logical file on join logical file?

    anupsshelke420 pointsBadges:
  • Do we need to compile LF when its PF changes

    Hi, I have one small query. I have changed one PF, do I need to recompile it's dependent LF(s) ? For e.g I have earlier a PF say PF1 having 4 fields A,B,C,D (with keys A,B) now I have added a new field E. Do I need to recompile its dependent LFs say LF1,LF2.. Appreciate your quick response !

    pankaj2r100 pointsBadges:
  • update replace

    I'm trying to update a particular text string in a long trxt eg 505400005004GBP23800280000 trying to replace the 10th char 0 with a 1 how can I do this please, thanks

    Randybc25 pointsBadges:
  • physical files……

    hello sir,             I have found one problem while update data in source file. I creats one source file after 14 it shows this message "The compile of member JPF1 was submitted to Batch.                          + Job 476274/NITINB/JPF1 submitted to job queue...

    anupsshelke420 pointsBadges:
  • AS400 and BOXIR3.1 connectivity

    Hi guys, Can anybody tell if Business object can be connected to AS400? Thanks Pranav Sharma

    PranavSharma35 pointsBadges:
  • DB2/400 basics

    How will I find out total number of records in a DB file without causing any I/O operation?  Also How will I detect the existence of a record in a DB file without causing any I/O operation?  I think I can use INFDS and the field *RECORD but not sure how this works. Thanks, Nutan

    Nutangujar895 pointsBadges:
  • How to acheive FULL OUTER JOIN on three files in IN SQLRPGLE program.

    Hi, I have 3 seperate files called Duty, Freight and Brokerage and i need to process all the records from all the three files into one output file based on key values matching across all the files, if i dont find the match in anyother two files then i need to populate coresponding fields with...

    Mohan K695 pointsBadges:
  • How to retreive stored procedure from DB2/400

    How to retrieve the stored procedure body from db2/as400. for example : I created a Stored Procedure as create procedure botest/spload ... ...

    Sivu105 pointsBadges:
  • enter SRTSQL Satements AS400

    Hi, I have done an index by "create index......" and when I am trying to do aquery with STRSQL on that index I receive the following error: BKPPDAI1 in BKTEST not table, view, or physical file. This is my Statement: select *from bktest/BKPPDAI1 I am trying to fix the syntaxis but I can not make it...

    JEMC5 pointsBadges:
  • Logical file Error.

    i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A          R RDEPTMST                A            DEPTNAME      15        A            DID            5        A            LNAME      ...

    Nikrajpapa250 pointsBadges:
  • pass array to clle

    i created RPGLE,within that i defined compiled time array now i want to pass that array (at a time only one insex) to cllle but while i run this rpgle its give me run time error ..that  Error occurred while calling program or procedure *LIBL/practcl8 Message ID . . . . . . :   RNQ0211      ...

    Nikrajpapa250 pointsBadges:
  • What are the steps needs to be followed while removing Key Fields from PF.

    Hi, i have got a requirement to remove the Key Fields from the PF. Can anybody please suggest what are all the sequence of steps i shd follow to incorporate this changes to avoid any issues in Production after change. As per my knowledge below are the steps i am planning to follow, please confirm....

    Mohan K695 pointsBadges:
  • Moving file from Linux to AS/400

    how can i get a file from linux to my as400 use to do it with Client Assist but being told that does not exist in linux !

    WILBE5 pointsBadges:
  • Not able to create procedures using STRSQL on V6R1

    While creating a procedure in V6R1, [strong]Not authorized to CREATE PROCEDURE error (Message ID is SQL0552)[/strong] appears. In Additional Message Information cause of the error being -- [strong]CREATE PROCEDURE or CREATE FUNCTION requires the *OBJOPR and *ADD authority to the catalog table...

    Haaiderali215 pointsBadges:
  • Switch between two screens using CICS maps

    how we can switch between two screens using maps in cics what will be the logic implemented in cobol programme?

    Asstenggtrainee5 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.

Thanks! We'll email you when relevant content is added and updated.

Following