• as400 db2 to sql server 2005

    how can we take a db2 backup tape and dump to a sql server 2005 database?

    Mingo5 pointsBadges:
  • DB2 HADR configuration

    Hi, wanted to check if anyone of you have experience in DB2 HADR configuration with 'reads on standby' enabled. We are looking for auto fail over between the nodes and balance the reads between the nodes. Does anyone has any prior experience with this configuration on the AIX environment? Thanks.

    kbsantosh15 pointsBadges:
  • Why do I need a logical file in DB2/400?

    Why do I need a logical file in DB2/400?

    db240050 pointsBadges:
  • 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:

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