• CPYTOIMPF data corruption

    CPYTOIMPF on V5R4 with latest PTF's adds invalid data to the created CSV file for some blank fields in the PF. Is this a Bug?

    JMShmc5 pointsBadges:
  • DB2 connection in VBscript

    I need to delete some records from a DB2 database on an AS400 using VBscript.

    Larksys5 pointsBadges:
  • Delete OLD files from Table not having date or timestamp

    Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...

    RJES45 pointsBadges:
  • Certification sites for Synon?

    Hello, Please can anyone suggest some good certification sites or courses for Synon or DB2 400. Except the ones from IBM. Synon is more broadly needed!!

    Jammypune5 pointsBadges:
  • Launching AS/400-iSeries with DB2 and RPG

    I am new in AS400/ iSerices. Actually I am a software developer C#.Net in my office we have database on AS400/iSerices DB2. I usually use Sql. I want to install or launch AS400/iSerices on my home PC. Can anybody help me how launch AS400/ iSerices on my personal PC. Thanks in advance. Mr.SEA...

    Mr. SEA130 pointsBadges:
  • File attribute DFU

    I have come across an object whose type is *File and attribute is DFU? What does this mean?

    Niklethaldan10 pointsBadges:
  • Accessing AS/400 DB2 physical files with Java

    Hello All, We have one JDE Word Writer program, which export the order master data in the DB2/400 Physical files. We want to access this data from our java program (reside on windows platform). I am wondering how we can do that. I got one hint that can be accessed by ODBC connection. But I am...

    GeethaNatarjan15 pointsBadges:
  • DB2/400 field to match an Oracle VARCHAR?

    We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

    Michaelwpeak5 pointsBadges:
  • Compare a field from a file to a column from DB2

    Need to compare a field from a VSAM file to a column from a DB2 table and run through the whole file/table to find differences.

    BobBill10 pointsBadges:
  • Flat file to PF conversion

    Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

    ten20081,150 pointsBadges:
  • DB2/400 – Source Physical File Deletion?

    I have a question related to DB2/400. Let’s say, your source physical file name is “QDDSSRC” and inside this source physical file when you try to create a physical file with name same as that of source physical file “QDDSSRC”, if I am not wrong the source physical file will get deleted....

    BibinGeorge130 pointsBadges:
  • DB2 logical files

    HI, i wanted to know if i can add a new field to a PF via a logical file. If yes give me an example. thanks....ram

    ten20081,150 pointsBadges:
  • AS/400 data mapping with CPYFRMIMPF

    We have an application in which we need to expand the size of several fields within the record, ie the Amount field need to be larger. In the past I would create DDS for the new expanded file, create the file, then write an RPG or Cobol program to copy the data from the old file to the new expanded...

    GarySouders10 pointsBadges:
  • DB2/400 stored procedures

    Can you please tell me how to create stored procedures in AS/400 and when they are to be used?

    ten20081,150 pointsBadges:
  • Journaling and commitment control

    Is it mandatory to journal a file to open it under commitment control? thanks

    ten20081,150 pointsBadges:
  • How to check DB2 version in AS/400 green screen command line?

    How to check db2 version in as400 green screen command line?

    Hiraju115 pointsBadges:
  • Process of swapping the kernels

    HI i am working on a sap application where the OS is OS400 and the Data Base is DB2/400, now i want to know the process of swapping the kernels Can any one explain it or refer some meteral for teh same . thanks in advance kiran

    Chebrolu20 pointsBadges:
  • How to Determine Database Access on AS/400

    I have a client running JDEdwards on an AS/400. How can I determine which of the users have direct access to modify the DB2 database (access to DB without going through the JDE application)? Is there a particular security profile they must have? Thanks in advance.

    DaCurryman5 pointsBadges:
  • join logical files

    Hi, Can i join one physical file's 2nd member to another physical file's 5th member? Is it possible? If so how? can anybody help me out?...thanks

    ten20081,150 pointsBadges:
  • journalling a file

    Is journalling a must for commitment control of a file on AS/400

    ten20081,150 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