• Delete data files on the AS400

    I have a client that wants to remove all company data from an old AS400. Is there an easy way to do this, a single command or procedure?

    b.rogers5 pointsBadges:
  • Is it possible to get an alert when database page faults exceeds a certain amount.

    Is it possible to get an alert when database page faults exceeds a certain amount. Iam referring to the page faults which appear when we give the WRKSYSSTS command.  Or write a pgm which could monitor the page faults and sent an alert. 

    JohnsonMumbai1,160 pointsBadges:
  • CPYTOIMPF removed leading zeros from numeric field

    I am having a few problems using the CPYTOIMPF command. I am copying an external defined file on the AS400 to the IFS. It is removing leading zeros from numeric fields which I need the leading zeros in, such as company number. It also is placing trailing blanks in the numeric fields, which I don't...

    Rpgldb30 pointsBadges:
  • Converting date values in AS/400 database

    How do I convert a date value 20/09/1231 for 31st Dec 2009 in the database to be able to use a query of checking this date against current(date)?

    Bonbon7830 pointsBadges:
  • External DB2 Database link/trigger

    In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables.

    r.otto810 pointsBadges:
  • UDS and DS

    I know well Data Strucutre (DS) and its usage, how an UDS (Data Area Data Structure) is different from and ordinary DS, I just find to know by myself but I was unable to find it. Can any one help me in expalainigt this?

    Kar425 pointsBadges:
  • Member Level ID

    Every evening we create Save Files of our Production Libraries on our Production System. The next morning we FTP these Save Files to our Development System and do Restores to our Production Libraries on our Development System. We use TurnOver to handle the changes to our SQL Tables, Indexes, and...

    wpoulin2,480 pointsBadges:
  • Bad data in as/400 database.. cant display record

    We have a user that insists on using cut and paste to enter data into our system. The problem is bad hex/ascii chars are causing errors trying to retrieve the data. If you try to edit the data using STRDFU it gives the message "The retrieved record contains invalid data." To make things worse you...

    ToddN20009,700 pointsBadges:
  • client access 32 bit ODBC drivers

    where can i download 32bit client access ODBC drivers onto my windows(XP) system so that i wanna migrate my access files to AS/400 files.Plz guide

    ten20081,150 pointsBadges:
  • MS-Access data access

    I wanted to access a MS-Access database file on my PC to my AS/400 and want to convert it into a physical file.Can anybody give me the steps in this process and requirements for that? thanks

    ten20081,150 pointsBadges:
  • What is Database Pagefault in AS/400

    What is Database Page fault in AS/400 it is releated to WRKACTJOB plese send the answer if any one knows

    VenkatPemmasani40 pointsBadges:
  • How to export meta-data

    I am charged with archiving data from a legacy AS400 packaged system. I can export the data using attachmate and a few tricks to get it into XML on my LAN. However, the FDF info is not good as metadata, so I need to retrieve the field level that is available thru 'file commands''display file field...

    TP078305 pointsBadges:
  • What causes the last used date to be updated on a file?

    I have a library that has a number of files with very recent last used dates. This library is left over from the original application install and is not used anywhere that I can find. The only mention of the library is on a dsppgmref listing for the base application programs, where the library is...

    CLKelly120 pointsBadges:
  • Rebuilding Logical Files

    What does rebuilding a logical file do? Is rebuilding the same as recompiling? Or, is it a separate process How often should they be rebuilt? If you reorganize a physical file, does that rebuild the logical files as well?

    Dcantwell470 pointsBadges:
  • whats are the contents of a databse fields after the record is written

    I have a field in a file eg. NewQueue. Once I write or update a record in the file that has field NewQueue, are the contents of that field still available for evaluation?

    Macitmich20 pointsBadges:
  • I am not a programmer

    I am a buyer and we are looking for a way to run AS/400 data reports to a PC. The AS/400 is located in Guinea and connects to our network through a server in an office across the street. What are your suggestions to accomplish this? Thanks.

    Gordon245 pointsBadges:
  • Packed Data

    How do I display a packed data field on the iSeries?

    plaporte55 pointsBadges:
  • Maximum number of records that can be stored

    What is the Maximum number of records that can be stored on an as400 data file.

    JohnsonMumbai1,160 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:
  • Native database implementation on AS/400

    Hi, I am searching for a native database implementation for AS400. Either an open source or that can be bought and used or ( a database impl that can be achieved by doing some programming). Can i get some help regarding this. Thanks all, teja.

    Engineerteja5 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