• Moving File to a Directory in AS/400

    I would like to move a physical file on an AS400 to a directory on the same AS400. Is there a command to do this?

    Det15 pointsBadges:
  • IFS – records in file are not in original sequence

    I am not a AS400 developer. I work on an RS6000 (Unix) but we use IFS (NFS) to exchange interface files. Has anyone on V5R4 experienced having the records, in a large file, be out of order when a file from a libray is copied to an IFS directory? I am experiencing this and have been told that IBM...

    Daves5 pointsBadges:
  • AS400 V5R2 RLU AFPDS Printer Files transfer to Excel

    How can I take a printer file created in AS400 V5R2 RLU AFPDS Printer Files transfer to it to an Excel spread sheet?

    Black Jack15 pointsBadges:
  • sending save files to PC

    HI, i have created a savefile on my AS/400 which i want to send to my local PC. Please tell me how to do this?Tell me both FTP and form the AS/400 screen as well. I am confused..plz help..regards

    ten20081,150 pointsBadges:
  • SAVSYS runs for half and an hour

    Recently, We executed SAVSYS in restricted state. I know that SAVSYS usually runs for about 10 minutes. But, at that time , SAVSYS had run half and an hour. I don't know why SAVSYS runs much time. I know that SAVSYS save LIC, SAVSECDTA,SAVCFG. But I have know idea about what is bad. I don't know...

    Kagacchi35 pointsBadges:
  • Retrieve Job Attributes of a Local Port on iSeries.

    Hi. I am able to view certain Ports running in NETSTAT *CNN Screen and I would like to end some of them which are not required using a CL Program.  Thanks, Haaider Ali  

    Haaiderali215 pointsBadges:
  • AS400 SSL with Vista

    Hello, When trying to download the certificate SSL in operation navigator to a PC using Vista it keeps on telling me the password is incorrect. This only happens in Vista PCs. Does any one know what I am missing?

    Magda5 pointsBadges:
  • Moving data between 2 iSeries Servers

    We have a Production iSeries and a Development iSeries. We want to be able to select data from our Production System and Transfer it to a programmers library on our Development System. When we were on a single system we used SQL/Cobol. We have been successful getting to the database on each system...

    wpoulin2,480 pointsBadges:
  • AFP AS400 iSeries – Print Portrait and Landscape in same printer file

    Does anyone have a working example of the above? In my case the record format level keyword, PAGRTT(90) is not performed. Please HELP!!!

    JohnnyMooch35 pointsBadges:
  • How to use PL/I command LIKE with DB2

    I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable "xxxxxxxx" is incorrectly declared. SQLSTATE=00000 IBM7043I S 9.1 SQL0117N The number of values assigned is not the same as the number of specified or implied columns....

    Sccsofti5 pointsBadges:
  • AS400 Upgrade of OS version

    hi everyone I own an as400 820 but dont have maintenance i have version v5.1 and would like to upgrade to v5.3 will i have to get passwords from ibm for the software i have on the machine ? thanks

    Dmonselise150 pointsBadges:
  • AS400 menu opton security

    Hello I need to be able to set up security at the menu and menu option level so that I can limit users to specific menus and menu options based upon their user id. I would like to be able to do this thru a custom program written in CLLE or RPGILE. This program would be interfaced when the user...

    Piano520 pointsBadges:
  • Cannot end RGZPFM on V5R4 (Journaled file)

    Batch job RGZPFM on V5R4 not complete after 3 days. I issued an ENDJOB, and job is not completely ended 1.5 days later. The file is journaled and is very large. SBMJOB CMD(RGZPFM FILE(MYLIB/MYFILE) KEYFILE(*NONE) ALWCANCEL(*YES) LOCK(*SHRUPD)) How can I end this job? If MYFILE is damaged, I can...

    AS400DBA15 pointsBadges:
  • Increasingly lengthy SAVSYS times

    Our time required for SAVSYS is growing, and we have not had much success with IBM on getting answers on why and how to fix. We orginally thought the bulk of the time was with the SAVSECDTA, and then discovered user profiles owning large numbers of objects - most being scanned images. However, the...

    Drhankins15 pointsBadges:
  • How to FTP from AS400 to PC network Drive

    Need examples to automate FTP to PC network drive. This needs to take place whenever the file changes. Your support is greatly appreciated. Thank you.

    ibBusy4sure50 pointsBadges:
  • changing qpquprfil in query

    how do i change the qpquprfil in as/400 query. i have doone it before and i know it is doabe but ican't rember how. i mean thesystem one not the one at the user level??

    Zonar5 pointsBadges:
  • Logical file

    I created a logical file that used a select and values criteria. The file had duplicate records. When I created the same file with a higher security level, the file created without the duplicates. Does anyone know why I would have the duplicate records? The file was deleted ok so it didn't just...

    Bubbles120 pointsBadges:
  • AS400 RLU AFPDS Printer File Transfer to Excel

    We operate on a V5R2 release. IBM 9406 820 model. I want to transfer a RLU Printer File with AFPDS char to an excel spread sheet.

    Black Jack15 pointsBadges:
  • iseries stored procedure : read character string containing single apostrophe …. ex: Let’s

    I am working on a stored procedure that requires a literal string to be input into a VARCHAR(1024) variable. My stored procedure has no problem reading the word........... Let''s However, if I try to read the word............Let's, I get a code violation. Do I need to read the string as a datatype...

    Dsthornton5 pointsBadges:
  • primary files

    Can anyone explain the concept of primary files in RPG , as i am a fresher in AS/400, i just want to know why do we use the Primary , secondary files concept ?

    Shivaas4005 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