• Converting from RPGLE to DB2/400 SQL

    My shop just announced that it intends to convert from RPGLE on the ISeries 400 platform, to SQL, such that the procedures will be portable to other hardware platforms. What documentation to I need to acquire to train on writing SQL procedures; initially within DB2/400?

    SeaRancher5 pointsBadges:
  • Converting Data in Excel to PF on DB2/400

    Hi All, I have data in the excel where each column equal to the field of a physical file. I want load this data into the PF on AS/400. Could any one let me know the process on how to do it. Thanks in advance

    rajsubhyd105 pointsBadges:
  • DB2/400 to Oracle 10g

    I like to migrate a database which is in IBM DB2 /400 V5R3MO supported by windows platform (Source)using iseries navigator to Oracle 10g.In the source database there are few stored procedures and few triggers which I like to migrate from source to oracle too. So I like to know is Oracle migration...

    792755 pointsBadges:
  • Multiple SQL statements through OLE DB on DB2/400

    We have a third party application built on SharePoint, and we want to use DB2/400 on our System i for the application's backend database. The app uses ADO and OLE DB to query whatever database it links to, and the vendor has it working on a number of different databases, including DB2 on Windows...

    AndyFarrar15 pointsBadges:
  • ASP.NET (web application) using AS/400 database

    Is it advisable to use ASP.NET (web application) using AS/400 database? How does it affect the AS/400 performance?

    imkhikoh5 pointsBadges:
  • Logical files – V5R4

    HI we all know DSPDBR command on a PF will fetch all the dependent logical files. Can anybody tell me with a logical file's name only known is it possible to fetch the Physical files's name on whom it is dependent?   happy new year n best wishes to all Ram

    ten20081,150 pointsBadges:
  • Looking to add a column to DB2/400 table

    I'm a beginner with AS/400 and I'm wondering if there's an SQL command on AS/400 to add a column to a table in a specific ordinal position (or moving an existing column to a different position)? Pointing me in the right direction would be great. Thanks!

    ITKE350,400 pointsBadges:
  • We’re looking to add a field description in a DB2/400 file

    My partner and I have a set of files on an AS/400 system but we don't have DDS for (the files were created in SQL). We would like to add field descriptions but we're struggling to find how to do this in AS/400.Could someone tell me how we can add a field description? Is directly updating...

    ITKE350,400 pointsBadges:
  • Sort process in COBOL/400

    Hi Group,I am trying to understand the significance of sorting in COBOL/400.Sorting is used for arranging records into a specific sequence so that sequential processing can be performed. But, for arranging records in a particular order I can as well create a logical file and process it; Why should...

    mvrkrishna555 pointsBadges:
  • LDA in COBOL/400.

    Hi Group,How to access LDA in COBOL/400 program?Regards,MVRK

    mvrkrishna555 pointsBadges:
  • Entering -ve values in PF using STRDFU.

    Hi Group,I created a PF and I need to enter -ve values in one of the field by using STRDFU.the field is defined in the following manner: SALES 5P 0 ALIAS(EP_SALES)Thanks & Regards,Rama Krishna

    mvrkrishna555 pointsBadges:
  • AS/400 – DB2/400 PF and LF have different identifiers for Synon

    Hi, AS/400 -DB2/400--> PF and LF have different identifiers for files generated in Synon. But for the Manually created files PF and LF have same file level identifiers. Please let me know why it goes like this. Any idea? Looking answer for this. Thanks P.Amutha

    As400pgmmer305 pointsBadges:
  • AS/400, RPG, ILE, DB2/400

    Hi Group, Please let me know.... How to analyze the DUMP of RPG in AS/400? What are the steps involved? Thanks & Regards, M

    mvrkrishna555 pointsBadges:
  • Copy a file of 20 million records to another file.

    Hi Group,I need a copy data from a file having 20 million records to another file. What could be best way to achieve this? One way is creating a duplicate object. Is there any other method?Regards,M

    mvrkrishna555 pointsBadges:
  • Query

    Hi Team, I have scenario with me. For that I need to create a query. The scenario is as follows: When My Location And Department is equal in the file I want to Multiply Quantity Column with Cost Column and Add it. Loc Dept Quantity Cost 1 10 10 2 1 10 10 3 1 10 11 5 2 10 10 7 For above example in...

    ankit2002770 pointsBadges:
  • How to connect to an AS/400 database from a remote PHP script

    Hello. I have a requirement to use a PHP script running under Windows to access a remote DB2/400 on an iSeries. Can anyone please assist in what PHP coding would be needed, thank you! Regards Paul

    PaulTaylor15 pointsBadges:
  • What is the difference between a logical file and view in DB2/400?

    What is the difference between logical file and View in DB2/400?

    rajeshece1,215 pointsBadges:
  • What is the difference between physical and logical reads in DB2/400?

    When we do DSPFD for a file it shows physical and logical reads. What is the difference between physical and logical reads?

    Kajeeva10 pointsBadges:
  • Display records in ascending order in DB2/400 physical file

    I have created one physical file with 1 key field. After that I added some data in that file. Records in the file are displayed in arrival order. While viewing the records using DSPPFM, STRSQL commands. As per my assumption, it should be ascending order. Why it is not displaying in ascending order?

    rajeshece1,215 pointsBadges:
  • What is the difference between DB2 and DB2/400?

    What is the difference between DB2 and DB2/400?

    Allampriya5 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