AS/400 Tag Directory

Featured AS/400 Questions

  • Is it possible to use ADDRDBDIRE to connect to Oracle database?

    Is it possible to connect to Oracle database from IBM i? How to do that (I have IP address user ID, password and SID)? Thank you.

    VadimR5 pointsBadges:
  • How do AS/400 stored procedures get output?

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata25 pointsBadges:
  • How to make new QINTER subsystem?

    can anyone tell how make new subsystem Qinter

    Kiong135 pointsBadges:
  • How to see output for an AS/400 stored procedure

    I have created a CL which calls an RPG program. Now I have to create a stored procedure which calls the CL! As RPG normally sends back the output to CL! How should I send back the output to SP? Will SP normally pick it or is there any command to send back the output to stored procedure (SP). I have...

    bharathtata25 pointsBadges:
  • Spool files are not reaching Xerox printer using AS/400

    My spool files not reaching the Xerox 9302 using AS/400. What is the cause?

    JNodawar5 pointsBadges:
  • Creating shortcut commands in AS/400

    Hi, I want to create a shortcut command for wrkmbrpdm command in my AS/400 platform. i have done like this: 1. wrkmbrpdm libraryname/member name 2. Shift F4 3. Created a user - defined function (as w1 for wrkmbrpdm) But an error throws w1 not found in *libl . Please somebody can help me out on...

    Sangay635 pointsBadges:
  • AS/400: How to remove and validate default password and limit capability parameter

    How do I remove / change and validate default password, limit capability parameter?

    yaminirosy5 pointsBadges:
  • How does VLDCMDKEY work in AS/400

    I have display file with load all subfile and using function key 'F3= Exit' ,'F5=Refresh' and 'F9=Print'. I want to preventing lock of screen if user press any invalid function key(anything except F3,F5,F9).Could any one suggest me any solution? I have used VLDCMDKEY at display file but in RPG...

    nabamita90 pointsBadges:
  • Monitor SubSystem

    Dear all, Usually, I used command WRKACTJOB to track The jobs, and Press F5=Refresh and F10=Restart statistics to monitor subsystems and check as: CPU %, Status, Current User and fitter/sort follow CPU, Status I wanted to writer Script/Macro Code to monitor subsystem. Please can you let me know...

    Hvphong031160 pointsBadges:
  • AS/400 subfile error message

    I have defined a field in the Subfile control record and defined the error message ERRMSG and conditioned it with indicator. Now when the indicator is on error messsage is not displayed on subfile. Below is the DDS code. A            SVEND     R     Y  B  4...

    NK250155 pointsBadges:
  • Change Operational Assistant menu in AS/400

    Hi, I wanted to replace the Operational Assistant menu in AS/400 (which appears when we press ESC Button) with a subfile which will contain all the spool files of that user profile. And the subfile with menu options like option 5 to display the spool file and option 2 to send the spool files to a...

    Sureyz2,735 pointsBadges:
  • How can I read OUTQ spool files and remove based on dates?

    Does anyone know How I can read OUTQ spool files and remove based on dates?

    BeckySCallahan5 pointsBadges:
  • Change AS/400 Subsystem from QINTER to QCTL

    I would like to change my subsystem from QINTER to QCTL. How can I change it? Whenever I open an AS/400 system, it automatically opens with QINTER. Why not anything else? Please advise how we get QINTER on login screen? Thank you.

    sivaknagula40 pointsBadges:
  • How to find the fullpath/absolute path of a file at AS400?

    One program file (MYFILE) exist at one Library (MYLIBRARY), but how to know the fullpath/absolute path of this program file ? Can not find the file at /MYLIBRARY/MYFILE, where is the file located ?

    As400fullpath15 pointsBadges:
  • Printing separator pages with job number, user name etc

    Our print spool files print with separator pages. They seem to print based on user profiles. I cannot find it in the user profile descriptions or in the output queue descriptions. Is it possible to define them some where else?

    Gundu5 pointsBadges:
  • AS400 Sign on

    When you take "Run the same" to open a new session you have to retpe the user id twice on in a window and then on the green screen. Does anyone know of a way to bypass one of the signons? Thanks

    JAC260 pointsBadges:
  • Deleting selected AS/400 spool files by date range

    Is there a way to delete all spool files from an OUTQ for a specific date range or leaving all files after a specified date?

    EGibson15 pointsBadges:
  • Subfile processing – Incorrect record number in subfile SFLRCDNBR or SFLSIZ field.

    I am getting the above error - This the dds specs: A A R SUBDTB SFL A SUBPART 35A B 6 18 A R SUBCTLB SFLCTL(SUBDTB) A*%%TS SD 20031114 134548 KAUSC REL-V5R2M0 5722-WDS A SFLSIZ(0020) A SFLPAG(0010) A ROLLUP A ROLLDOWN A 60 SFLDSPCTL A N61 OVERLAY A 61 SFLCLR A 62 SFLDSP A 70 SFLEND(*MORE) A LSTRRNB...

    Manyquestions65 pointsBadges:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • AS/400: Keyboard shortcut, send print screen to spool

    I've used a keyboard shortcut in the past to print screen to spool instead of local printer. Can't remember what the shortcut was or where I saw it. Anyone know what it is or how to find it?

    jlbeach795 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