• DB2 data over web browser

    Our solutions resides in System i and its all are internal developed systems. Our applications are Logistics business driven and now we have the need to publish these informations over web for view by customers. HOW do i do that.. and what should i consider..

    bsathia20 pointsBadges:
  • Connecting to more than one AS/400 DB2 Remote Databases using SQLRPGLE

    I have requirement to connect more than one AS400 DB2 remote/distributed database to retrieve the Quantity by using SQLRPGLE Program. Found working with one remote DB, Retrieving the quantity & other Remote DB is getting connected, but while executing the SQL query it says SQL Package not...

    AS400DB2DBA5 pointsBadges:
  • Controlling C D I R options in the workstation message queue.

    Hello All, Could you please tell me how to control the C D I R options via programs. I mean that I do not want R to appear in screen and the functionality is automatically done. Can it be possible? If yes, please tell in detail and if not then what is the reason?

    Bigdumbo25 pointsBadges:
  • How to Add column (field) in ODBC to physical file?

    When I add a new field in ODBC, I can't find it in the physical file in the iSeries.

    afayek675 pointsBadges:
  • How to show table Constraints on AS/400

    Hello masters, I want to show table constraints on as400 database.I asked somebody people and they are said me; "Do not show (constraints - table relations) on AS/400". I don't believe that. And now asked How to show table constraints - relations on AS/400 I'm very curious about the answer to this...

    HBurakKaradag15 pointsBadges:
  • sql not retuning column using DB2 data reader

    Strange one. I have a user that created a database file using WRKQRY. In this file is a user defined result field. Its basically a text label stating the build level 'LVL01'. After all levels are run (11 total) the file is complete. I am trying to access this data using a .NET program and a iDB2...

    ToddN200011,190 pointsBadges:
  • SQL / DB2 Optimization (timing out)

    I put together a simple VB program to run SQL commands on any of our 4 I-series machines to return a simple grid view. I have run across a strange problem and was told it may have to do with optimization. For example if I run the following SQL ( I just want a count of parts (pm) that have not been...

    ToddN200011,190 pointsBadges:
  • 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,215 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:

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