• What is the difference between DB2 and DB2/400?

    What is the difference between DB2 and DB2/400?

    Allampriya5 pointsBadges:
  • How to find indicator and relative record number fields in DB2/400

    In DB2/400, even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value "Y" or "N". How to see this indicator field? How to see the DB2/400 RRN (Relative record number) field? I tried with RUNQRY...

    BibinGeorge130 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:
  • Migrate application from UNISYS to AS/400

    How can we migrate an application currently running on the UNISYS platform to AS/400 platform. A major portion of the source application is in COBOL and uses the DMS-II database. This has been migrated to COBOL and RPG on AS/400 using the DB2/400 database.

    126170 pointsBadges:
  • Current date in DB2/400

    IN DB2/400, is there a field level keyword for showing the current date?

    JIJUKALLIATH5 pointsBadges:
  • How to download data from DB2/400 table

    Can someone tell me how does the unload utility work in DB2/400? I need to download data from a DB2 table to a text file.

    smlegacy15 pointsBadges:
  • Alternative name of Physical file

    How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.

    anuppdas105 pointsBadges:
  • How to reduce the time taken to select the records from huge keyed physical file having 180 Million records

    Hi All, I have a report program which uses the OPNQRYF to select the records to generate a report based on user selection in display screen, but it is taking lot of time (20 to 30 minuates) to select the records and write write into output file. I am accessing keyed logical file based on physical...

    Mohan K695 pointsBadges:
  • Looking for a db2/400 class in canada

    Hi, I am looking for a db2/400 training class in canada. i am not able to find any training class on the web. i am an oracle dba ane my boss wants me to get trained for db2/400 because we bought a company that is using it. Thanks.

    surname45 pointsBadges:
  • Read the data from PF between dates

    I want to read the all the record from the pf which are between some dates Eg: A PF has one year data let say 2011 year data, I want to read all the records from that pf which are from 01/03/2011 to 05/06/2011 dates. the PF fields are DATE,NAME,ADDRESS,P_no. Can anyone help me how to do this in...

    vzvzxvcx160 pointsBadges:
  • Title changing

    Hi Group, As per the new assignment i need to change the title from "MQM Application Business" to "ABC". I have identified the list of Programs and files where I need to change. The list includes RPG, CLP, CBL, CBLLE, CLLE, RPGLE, PRTF, DSPF & DDS files. I have question: 1. What are the factors...

    mvrkrishna555 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 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:
  • Journaling if I drop a table

    Hi Tom, New to iSeries. If I drop and recreate a table with two additional fields, will the journalling be cleared out too? Also will the jounalling be enabled when I recreate the table? I have this brief........   We need to have the old journal entries (relating to the current layout before the...

    WendyB95 pointsBadges:
  • how to copy column-headings from a PF

    how to get column-heading names copied along with data from a PF to a flat-file? - OR - how to copy column-headings from a PF to another PF?

    svankipu620 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:
  • Using Dropbox and Radio button with DB2400

    IS THAT POSSIBLE OF USING DROPBOX AND RADIO BUTTON IN DB2400?

    Rajasekhar151,395 pointsBadges:
  • override database and logical file

    what the main difference between OVRDBF override database in CL and logical file... which one have most advantage...

    pdsathishkumar3,790 pointsBadges:
  • Problem converting numeric to date data type

    I have a zoned decimal field as s 6 and i am trying to convert it to date format as mmddyy in sql...It giving error ..please help me out ..I tried using date and cast function but its not working !!

    munduuu435 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