• Using CPYFRMIMPF to copy data from a TXT file to DB file

    I am using the CPYFRMIMPF to copy data from a TXT file into a DB file.  The delimiter is a ']' character.  The command runs but no records are copied.  The error says "0 records copied from member TXT.  Copy command ended because of error".   Upon further review I found "The copy did not...

    SteveLane70 pointsBadges:
  • Transferring data from one iSeries to another

    We have 2 iSeries Servers, 1 for Production, 1 for Development. I have been asked to refresh our production data libraries on our Development System on a regular basis. My thought is to create a Save File of the data libraries on our Production System then FTP the Save File to our Development...

    wpoulin2,480 pointsBadges:
  • DB2 to Text File Conversion and Transfer

    I have created a Text File from my AS/400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this?

    gvdsswami20 pointsBadges:
  • iSeries database update via CL

    Hi! I have an iSeries database table that has a column name JOBQ. I want to update all records with JOBQ value QBATCH into 2 different jobq names for alternate records. I'm a CL programmer and looking for an example of updating a column via SQL that I can call from my CL in a loop.

    SundarNVS5 pointsBadges:
  • What is the best why to get started in DBA

    I have some experiance in SQL and Access and all the other MS software too. I deal alot with spreadsheets, and database in my job. I work alot with the AS400 and do alot of queries throught MS Access. What is the fasted and tghe most inexpensive way to get to the piont of being self sufficient as...

    CompEng1,240 pointsBadges:
  • I-series Navigator Database access

    I have Client access loaded on my Laptop and have recently loaded the Database facility into Navigator. It loaded okay with no errors, Client Access is V5R4M0 and the I-series is V5R4M5. My Problem is that when I go into Navigator and connect to the I-series and try to expand the database tree it...

    RobertHart225 pointsBadges:
  • iSeries Exit Point for ALL file member changes

    I'm looking for an exit point that lets me capture changes to files (not the data in the files).  I want to know when the following occur, regardless of the source of the change (ODBC / FTP / Cmd /CL / SEU / PDM / Navigator / SQL / ...) member added / renamed / deleted / changed file itself is...

    KenScholle5 pointsBadges:
  • job QZDASOINIT

    My web application is using ODBC connection to access DB2.Connections are closed properly on each page.But job QZDASOINIT is not ending and remain in TIMW status.This is creating large number of jobs on server.How can i close this job when connection is closed?

    Wasifzaheer35 pointsBadges:
  • Special character in a PF

    Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any of these in iseries

    Rockleadme385 pointsBadges:
  • How can I list users who accese DB2/400 via ODBC or data transfer of iSeriesAccess

    We have many users who access DB2/400 database via ODBC or data transfer of iSeriesAccess. Are there any way to list those users from the accounting journal or audit journal?

    ISHII5 pointsBadges:
  • Ending ODBC Connections

    I have several active ODBC connections throughout the day and I'm finding they sometimes lock objects during my Dayend so I want to cancel them just before the Dayend starts. Can someone tell me the cleanest method to end ODBC connections? I was going to try just ending the Qusrwrk sub-system but...

    Alison88380 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:
  • 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:
  • Packed Data

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

    plaporte55 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:
  • transferring data from iSeries to Excel 2007

    Using the Excel 2007 add-in for the iSeries data transfer, is there a way to transfer into the spreadsheet more then 65,000 rows?

    Popers40 pointsBadges:
  • SQL script output to a file

    I am running ad hoc SQL scripts in iSeries Navigator (V5R4) and need to direct the output to a text file. Is there a way to do this? TIA... Steve B

    SBatSI415 pointsBadges:
  • Giving Permission

    Hi, I am studing databases in a iSeries. All my objects are in librarie called DB1_T2. I need to give access to the professor so he can read all my data and execute my functions. How can I do that via the command line. Thanks a lot.

    Lv2eof5 pointsBadges:
  • SAVF listing

    Does anyone know of a way to get a file with savf files only in it? I am trying to get a file so I can query it to see if I have any old save files on my iSeries

    lost in Kansas20 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