• AS/400 to Excel

    Hi Someone, I am using FTP to send a data file fromthe iseries to the server as a .txt file usint put statement. Can anyone suggest how I would sent the file direct to an Excel spreadsheet, preferable to a pre-formatted sheet. Thanks.

    tjgm88995 pointsBadges:
  • ODBC in AS/400, OS/400, System i, i5/OS

    Where can I find an ODBC Driver for AS/400? I asked this because I would like to setup an ODBC in AS/400 to connect Lotus Notes (in AS/400) to MySQL (in Windows).

    Yinphin15 pointsBadges:
  • how to schedule operation in I5 HMC to move physical adaptor

    Need to schedule HMC to move physical adaptor between two AS400 partitions so they can be backed up with no manual intervention

    Rcm4bsc5 pointsBadges:
  • Who can help me. I want to know about DST & SST

    How can I get the knowledge about SST & DST?

    Harish.kuolkhere190 pointsBadges:
  • Printer File

    How do I view the printer file or what command do I use in the Os/400? How is a print writer related to printer file?

    Xtreme200975 pointsBadges:
  • Password automatic replication

    I would like to know how to set up an automatic password replication in 26 AS400 partitions so as when I change my password in one of them, it replicates to the others. Any idea?

    Brunocl230 pointsBadges:
  • Tivoli Monitoring Setup on i5/OS400

    Folks, I'm a new employee working on i5/OS400 systems and I need to setup Tivoli monitoring tool on it. I have checked many websites but couldn't find how I do it. Can someone please help me?

    Brunocl230 pointsBadges:
  • Windows Server 2008 compatability with Client Access Express V5R0

    Is Windows Server 2008 compatable with Client Access Express V5R0 for iSeries OS/400 V5R1?

    Ppurvis5 pointsBadges:
  • to run a batch file in i5/OS

    how to run a batch file or a script file in i5/OS. How to create file with extension .sql and run the same in i5/OS

    Jacky160 pointsBadges:
  • WRKJOBSCDE

    Hi friends, I have a CL and this CL executes the command SNDDST, when this CL is executed like a Scheduled JOB this send doesnt works, but when I call in interative or batch mode, this send works. I PUT BELOW THE DISPLAY JOB Display Job Schedule Entry Details System: DEVELOPER Job: RECV83_TMS Entry...

    SILVARB440 pointsBadges:
  • AS/400 WRITE Op code writes then deletes

    I have a program where the WRITE op code is not working. After the program runs, there should be records in a file, but instead the deleted records are increased. I have debugged the program and as soon as the WRITE statement is executed the number of deleted records is increased. I've never seen...

    Gulger9920 pointsBadges:
  • Is there a changed objects calculation on the AS400

    How do you get a total size of how many objects have been changed in a day?

    Bmorebad5 pointsBadges:
  • Calling API

    Hi all, Does anyone knows how to call API program in interactive mode? How are the rules to call API? Let say I want to put CALL QEZSNDMG in WRKJOBSCDE, what do I have to put in the command, cause when I try CALL QEZSNDMG parm(''N' 'Y' ' ' 'Testing' 'User1'') its not working. It says that error...

    TG50 pointsBadges:
  • OS/400 Sensitive Commands

    1) How can a user be given the capability to execute the following OS/400 sensitive commands? ADDAUTLE - Add Authorization List Entry CHGDTA - Change Database File (using DFU) CHGUSRPRF - Change User Profile CRTAUTL - Create Authorization List CRTUSRPRF - Create User Profile EDTAUTL - Edit...

    Rex110 pointsBadges:
  • how to get particular record

    Hi all, we display records on display screens with field names number,name.we tak opt(option) variable to perform delete(opt1),update(opt2) before field names. format is, opt number name. 00001 KUMAR 00002 RAO HOW TO SELECT PARTICULAR RECORD HERE 0001 OR 0002 BY GIVING 1 OR 2 UNDER OPT. 1 IS FOR...

    Anji0 pointsBadges:
  • Need help restoring spooled file in BRMS

    A Search400.com member needs your help. He has an i825 iSeries and is trying to restore a spooled file saved in BRMS. The problem is the tape backup was on an old 620 machine. Does anyone have any advice? Michelle Davidson Editor Search400.com mdavidson@techtarget.com

    MichelleDavidson435 pointsBadges:
  • Way to filter files in IFS?

    Michael recently wrote Search400.com with this question: "Every day we have hundreds of very small 1K to 100K files written to a directory (JDEB7333) on our IFS. All the files have the same extension of .log. Is there a native command or a utility (free or subscription) that you are aware of that...

    MichelleDavidson435 pointsBadges:
  • V5R3 Upgrade – RJE – BSC

    After Upgrading from V5R2 to V5R3 an old style BSC RPG program no longer functions. Does anyone know if a Licensed Program is missing or a PTF is required. Have not been able to find much info. Thanx in advance

    INSATIABLE0 pointsBadges:
  • timestamp value

    Hi, I am receiving TIMESTAMP value from the iSeries system as an unsigned 64 bit integer value. Is it possible to convert this timestamp into a readable format in windows machine? The iSeries timestamp value is an unsigned 64 bit integer value. All the time management routines which I can use on a...

    Pprasad1230 pointsBadges:
  • small doubt

    Hi, I have a small doubt in AS400 programming. This is regarding receiving journal entries. I am using ILE C to write the exit program. I am using RJNE0200 format on the RCVJRNE command. I am getting the entries in the exit program. But I have a few questions: - in the RJNE0200 format, there are...

    Pprasad1230 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