• 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:
  • 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:
  • I RECECEIVED A CPPEA55 ERROR MESSAGE

    MY TAPE DRIVE WENT DEAD PULLED IT OUT. I ISSUED A PWRDWNSYS COMMAND. IT WENT DOWN BUT I DID NOT UNPLUG THE BOX. AS SOON AS I BROUGHT THE BOX BACK UP I RECEIVED A CPPEA55 ERROR MESSAGE.

    RESPUGA25 pointsBadges:
  • Regarding deletion of user profile from AS/400 system

    While changing the owner of the objects of the user profile from the system i encountered an error 'Ownership of 0 document library objects changed to profile XXXXXX; 1 not ...'. I need to know how can i solve this error. Thanks,

    Gadang45 pointsBadges:
  • SRC error 67563200 when booting my AS/400e series

    my system have not come up it is turning on 67563200. pls what can be wrong with my system

    Cicaautos5 pointsBadges:
  • Error code 10: Function sequence error using CPYTOIMPF on AS/400

    I am using the CPYTOIMPF function on an AS400 to copy from one data base file to another. I want to end up with a .CSV file format. It worked once but now I get the following error: Message Id: SQ999999 Error occurred in SQL Call Level Interface. A procedure call encountered an error. The error...

    AS400 - Ask the Expert485 pointsBadges:
  • Running AS/400 Client Access basic operations functions in Citrix

    Have publised client access with CITRIX. Everything works fine. But when users try to view the outputs using the basic operarion's printer output option ,an error message is issued. This happens only when it is to be done through CITRIX.

    AjithW35 pointsBadges:
  • Iseries fails to boot

    I have a v5r4 820 model that failed. Error code in display is 284C3203 which pointed to I/O problem for either system board or Disk controller. I replace both and the only way I can get past this error is by using the new disk card with the new RAID memory. The old RAID memory card seems to have...

    Spadasoe5,130 pointsBadges:
  • OPNQRY

    Hi ALL, I am trying to pass to variable to the query select. ----------------------------------------------------------------------------------------------- OVRDBF FILE(filename) SHARE(*YES) OPNQRYF FILE((library/filename) QRYSLT('DATE + *EQ "&SATDYYMD"') /*the variable contains the date*/...

    Secskc25 pointsBadges:
  • Changing system request

    I wanted to change the system request option 5 from SNDMSG to a command line. So i created a new message file and changed the text in CPX2313 and then i used the command to CHGSYSLIBL to put my lib on top of the libl. But still when i take option 5 on system rqs i get the following error "Command...

    Arigekarthik20 pointsBadges:
  • RPG error RPG9001

    I am received error code QRG9001 error while compliling RPG/400 PROGRAM os version is V3R7M0 on my AS/400 server can anybody help me to resoved this

    Bu60 pointsBadges:
  • License error CWBLM001

    We are running AS/400 client access v5r4 SP SI29771 on Windows XP SP3. Approx every 4 to 5 weeks users will get an Internal License error CWBLM001. Only fix we have is to give admin rights, open the application, remove rights, and the application opens fine for another 4 to 5 weeks and then we...

    AS400 - Ask the Expert485 pointsBadges:
  • executing a url from the as400

    I have created a job in the AS400 job schedule and I need to execute a url from that job after I FTP a file to a server. I want to execute the url from the AS400 directly, not from a PC or a 5250 emulator session on a PC. When I run the job, I get a error message Command STRPCO not allowed in this...

    Breinhart45 pointsBadges:
  • Grouping the records in RPG

    How to I group the records in the database based on one particular field?? When i try using a group by clause in the embedded SQL, it give me a 'SQL precompile failed' error. How do I handle this?? And i have to display the employee records grouped by their locations... how can this be done??

    Shwesmile20 pointsBadges:
  • Copying CSV files to IFS

    Hi! I have a Java application that creates a CSV file in the hard disk (C:), and I need to copy it to an AS400, in its IFS. I created a folder in the IFS, named /myfolder. I use this command to create the file to the IFS: ifs = new IFSFileOutputStream(AS400System, fileName + ".csv"); But I receive...

    MelissaG20 pointsBadges:
  • numeric operation is too small to hold the result (C G D F)

    HOW TO REMOVE THIS ERROR-"The target for a numeric operation is too small to hold the result (C G D F)"?

    0315 pointsBadges:
  • AS/400 unable to IPL

    stop at system reference A6de0255

    bhalraj5 pointsBadges:
  • AS/400 Entended Base Support *ERROR

    I just want to ask if there's another way of resolving the installation failure of 5722SS1 option 1 - Extended Base Support. I already tried the Reclaim Storage(RCLSTG) command and re-install 5722SS1 option 1. And until now, it is in *ERROR status. Thanks

    Aj955 pointsBadges:
  • System value QABNORMSW

    The System value QABNORMSW from my system model 520 is "1 Abnormal". How can I resolve this situation ?, The version is V5R3M0.

    SILVARB440 pointsBadges:
  • error in DB2/400

    Hi, i created a physical file(named 'PHF1') and created a logical file(named 'LF1') in Source file(named 'MYSRC')..i complied those files and inserted data.. i wrote a query by STRSQL,that query is "SELECT * FROM LF1"...But i getting a error as "LF1 in *LIBL type *FILE not found" NOTE: I'm using...

    Nayak5 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.

Thanks! We'll email you when relevant content is added and updated.

Following