• 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:
  • Executing and AS400 job in a Batch job

    How can I execute an AS400 job from a batch job running on a network server?

    Roncadet25 pointsBadges:
  • Iseries print position problem

    I am having difficulty positioning output in the same position on a page across different printers using line/column positioning in DDS. If I use the position keyword in the same document across these printers then the output is positioned on the page in exactly the same spot each time. I want to...

    Jannene5 pointsBadges:
  • password features in OS 400

    Can users change passwords on their own, is that linked to any of the security values? Will the system enforce change of password on first login after creating a new user account or resetting a password, what is the related security value

    7766775 pointsBadges:
  • How to bring an IFS CSV file to destop

    How to bring an IFS CSV file to destop other than using iseries navigator

    pwopen12245 pointsBadges:
  • SQL index on dds file

    Will and existing rpg program that is doing a file read/table scan utilize an sql index with changing any of the rpg program?

    Finch25 pointsBadges:
  • RPG Life Cycle

    Can someone suggest simple web-links to know about RPG life cycle programing. How the cycle works with a good example.

    Kar425 pointsBadges:
  • System Center ports/API’s for import of systems management data from legacy platforms

    Are there ports / API's for import of systems management data from the likes of OS/400 and some of the other legacy platforms? This question was asked during the Microsoft System Center live chat on IT Knowledge Exchange in January 2010.

    ITKE440,580 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.