• How to export data from AS/400 into Microsoft Excel

    Hi, Plse tell me ,what is the problem. I try to export data from As400 into Excle.I wrote a macro in the excle sheet.I run a progrme it gives error massege ['Excel is not recognized as an internal or external command operable programe or batch file. thanks & best regards, Nadeeshani.

    NADEE12320 pointsBadges:
  • AS/400 printing

    How can I have one of my users to hold an as/400 job in one of our network printers, then whenever she wants to, she can released them !!! she doesn't have as/400 authority to access the to the command entry. thanks

    Querys100 pointsBadges:
  • How to backup all the shared folders from NAS storage to tape drive?

    I have one NAS storage in my LAN network. It is UNIX os & it is on the Workgroup not domain. I created for each employee his own folder on the storage to backup his critical files. I have more than 500 employees in my company. Currentlly, I bought one server (Windows 2003 ) with LTO4 tape drive. I...

    Afaneh5 pointsBadges:
  • How to check if email option is enabled on a AS/400 server

    How to check if email option is enabled on a AS400 server

    Askt1140 pointsBadges:
  • journalling a file

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

    ten20081,150 pointsBadges:
  • Send a break message to multiple users

    How to send a break message to multiple users.SNBRKMSG has the option to send it only to worksations.

    Askt1140 pointsBadges:
  • MCH3601 – Pointer not set for referenced location during backup

    I am runing - SAVLIB LIB(*ALLUSR) SAVACT(*SYNCLIB) This is on my DEV LPAR so i was able to run RCLSTG. It did not solve the problem. Any suggestions? I am receiving it on MANY files.

    DoubleL15 pointsBadges:
  • iSeries launchtest command

    The launchtest command will not work for me. It doesn't give me any error messages it just doesn't show the launch menu. My user settings are the same as my coworkers and she does not have this problem. Any thoughts on what it could be?

    Lostrom5 pointsBadges:
  • ADABAS v8; CICS TS31; z/OS 1.9

    Transaction N199 under ADABAS v8; CICSTS31 and z/OS 1.7 it runs successfully. Move it to z/OS 1.9 and it hangs. We do have ALLOWUSERKEYCSA set to YES. Has anyone experienced this and if so what did you do to resolve it? Thank you, CJ

    CJ in CA20 pointsBadges:
  • placement of a page segment graphic

    I'm attempting to replace the graphic in a pre-existing page segment. When using a program such as MS Paint to create the PC-based PSG file, what determines the placement of the graphic within the file? After uploading the PSG file and creating the page segment, I'm finding that the placement of...

    GeneM10 pointsBadges:
  • Problem in CCSID converting

    I have a QM query that forms up a DB file. A physical file. A file that afterwards will be tranferred to the excel worksheet. All the source DB files (as well as all the records inside) that I use in the QM query are having the CCSID=297 (french). But the data itself stored in these DB files...

    Proturborandza25 pointsBadges:
  • Unable to use delete statement in SQLRPG

    Hi I want to use this query delete from abc a where rrn(a) between 1 and 10 in an sqlrpg prog.I was getting error messages saying rrn keyword not allowed.Am not sure how to execute this in an embeddd sql program.

    0 pointsBadges:
  • How do I modify the value returned from current(time)

    I have an AS/400 query that requires me to search records with a timestamp from 20 mins prior to the current system time. If I use the current(time) value in the query, how do I modify it to return a time 20 minutes earlier?

    Morticia00110 pointsBadges:
  • Job Type

    How to find the job type (Interactive/ Batch) using RPGLE Programs

    rajeshece1,215 pointsBadges:
  • jobq entries

    Is there a limit to the number of jobs set to run in a jobq? I have a program that reads a file of LT 1500 rcds and there is the potential that all of those records could be submitted to run in batch. Thinking about the future, I suppose there could be close to 3000 one day.

    Brenger170 pointsBadges:
  • AS400 – RRN of PF

    FILE1 is a PF. I want to read 100th Record directly. I want to perform this operation without using LF, OPNQRY, Native I/O. want to achieve this using RRN value of File. How to code this in RPGLE Program

    rajeshece1,215 pointsBadges:
  • when does a job go to “MSGW” status

    when does a job go to "MSGW" status & how to resolve that?

    svankipu560 pointsBadges:
  • CPYTOIMPF and EXCEL defaults

    I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result. Example of data...

    Sbarnes5 pointsBadges:
  • Will RUNRMTCMD hold the host session until the program execution completes in the remote machine?

    Hi, When executing RUNRMTCMD to run a long runnibg program in a remote iSeries partition, will the session on the host machine be held until the long running program completes in the remote partition? Any chance that a 'fire and forget' kind of effect can be achieved? i.e. I would like to have...

    Chandlerbing81840 pointsBadges:
  • AS/400 restoring across partitions

    I recently got sucked into an AS/400 issue, but know very little about the system so am using manuals to figure things out.(Our sys. admin. left) We've got a server set up with a few partitions. One corresponds to our production partition, another corresponds to our testing partition. They have...

    Dmargolis35 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