• 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?

    svankipu610 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:
  • DB2/400 count physical file record

    how to count the physical file records using RPGLE program....

    pdsathishkumar3,790 pointsBadges:
  • DB2/400 delete record

    how to delete record using UPDDTA command...

    pdsathishkumar3,790 pointsBadges:
  • DYNSLT (Dynamic Select Concept)

    Hello All, This question is regarding the dynamic selection concept in DB2/400. As we know we can create a LF with our without the DYNSLT keyword. The question is what is the difference in using LF with and without DYNSLT? What should I prefer if my PF handles millions of records? Thanks in advance

    BibinG20 pointsBadges:
  • Convert as400 file to Excel and Pdf

    I would like to transfer a PF data into Excel , my add ins not working. Can u provide me any other ways to do that.

    As400programm10 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