• How to mirror two databases (PRD to DEV)?

    HI, I am trying to mirror my DEV box data lib with Production box. Currently i am creating a save file and then i FTP it to DEV box and restore lib. Any other way to do this? FTP takes a lot of time to transfer so, any suggestions on fast transfers would also be helpful. thanks

    Rockleadme385 pointsBadges:
  • QDOC library

    We have a 525 with 4 partitions (2 prod and 2 dev). QDOC library appears 4 times with the following sizes: Partition A: Total size: 7360096256 Partition B: Total size: 3964818944 Partition C: Total size: 4665577984 Partition D: Total size: 4669765632 My question is: I deleted an object from the lib...

    JAC260 pointsBadges:
  • reassign the drives automatically withoput the use of the console

    We have a 525 with 2 tape drives. Our prod backups occur at 1:00 am to savfs and then at 5:00 am the savfs are put to tape Our dev backups occur at 12:00 am to savfs and then when we come in we use the HMC to manually reassign the drives to the 2 dev partitions and the we sav the savfs to tape. My...

    JAC260 pointsBadges:
  • iSeries Access For Web – Run SQL Function

    Hi Has anyone had the problem where iSeries Access For Web does not run some SQL features consistently? I have a customer that is using this to provide reports from the iSeries to his customers. Customers can log onto the iSeries from the web and get to run reports already created. The customer can...

    Riccardo95 pointsBadges:
  • Identifying output files in query definitions

    How can one identify all/only output files in a list of query definitions (the list has over 1000 queries in it)? Executing in batch RUNQRY with parameter PRTDFN(*YES), in a loop for each query, then scanning the collective result, might theoretically do the job but doesn't work for queries in...

    22190165 pointsBadges:
  • Controlling Subsystem Name

    On an All User Data save procedure after all subsystems have been ended and the save is complete, what is the name of the controlling subsystem that needs to start. STRSBS SBSD(controlling-subsystem) Would it be QCTL or QINTER.

    Rjrohwer25 pointsBadges:
  • “Scheduled Tasks” share does NOT show up when browsing servers through UNC

    Hi, When browsing to servers via UNC, the "Scheduled Tasks" share does not show up anymore. It used to show up, but now the window is just blank when browsing to \\<servername>. I am a member of the Local Administrators group, I have administrative privileges on the servers. When connecting...

    Ypetiot5 pointsBadges:
  • Adding remote location

    We have an AS/400 in California and wish to allow a new warehouse in Texas to communicate to our AS/400 and print forms in their warehouse. What is the easiest way to do this? I’m not sure if it is best to set up a T1 line with a modem and controller, or to use some sort of PC connection....

    zbbwoc95 pointsBadges:
  • Convert date to match database field with L data type?

    The field in file is defined with data type L (2008-09-29). My date range in display file is MMDDYY. How do I convert prompt date so I can opnqryf on field in data base file?

    Sue5 pointsBadges:
  • AS/400 unable to IPL

    stop at system reference A6de0255

    bhalraj5 pointsBadges:
  • SAP 4.6c migration from MS SQL 2000 to IBM iOS DB2 database

    Hi I need to investigate the work load required to migrate SAP4.6C HR from a MS SQL2000 database to a Integrated DB2 IBM i OS Database? Is there tools available for this ? any information will be beneficial Thanx from a system i techie that know nothing about SAP!lol

    IEnter5 pointsBadges:
  • Converting Julian date to Gregorian in WrkQry

    I work on an Iseries AS/400 and when I do a wrkqry for reports I need to convert the date ccyyyddd(julian) to mmddyyy(gregorian)

    Lady5515 pointsBadges:
  • AS/400 – OCL procedures

    How to compile an OCL Procedure and debug the same in AS/400

    Horro5 pointsBadges:
  • Migrating SRS reports to new data structure

    I'm migrating to a new database with different tables and fields but want to continue to use the SQL SRS reports that I previously had (there are hundreds of them). Is anyone aware of a tool that will allow me to map the new and old data structure and update the rdl files for SRS?

    Nmenjivar5 pointsBadges:
  • Using SQL CLI APIs to call an sql stored procedure on an AS400

    I would like to know if there any examples of using the SQL CLI APIs in a COBOL/400 program that may help me in using the APIs to call a stored procedure and process the result set(s) . Thanks Mike

    I5DB2DBA5 pointsBadges:
  • Font code for MICR printing

    We are using the forms overlay feature in the AS/400 to generate checks. We use the font command in the print file DDS to specify the MICR font. The bank does not like the MICR font we have selected. Can anyone tell me the MICR font they use which their bank accepts?

    WoodEngineer6,500 pointsBadges:
  • File pointer is being reset to the top in a CLP program

    I am processing the *OUTFILE from a DSPOBJD command. Trying to create a logical file. When the CRTDUPOBJ fails the program loops to the RCVF command but the same record is being read again...WHY??

    RotoMan30 pointsBadges:
  • Validate email address in the GAL for the iSeries?

    Application has a personnel file that stores the data and it would be great to be able to ensure that what is entered is a good address.

    Tpinky4,165 pointsBadges:
  • Parms to Cobol from RPGIV

    Is it possible to pass parms to a called COBOL pgm from a RPGIV pgm?

    Jrb791125 pointsBadges:
  • Pointer In CL

    How we point the particular record in file on the base of key in CL Programming.

    Goyalp420 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