Search |
University of Florida | Department of Physics
--> Overview

--> Common Questions

--> Adobe Acrobat

--> Cisco

--> SGI Scanner

--> Packet Video Conf

--> Small Video Conf

--> New Users

--> Lic. Software

--> Public Domain

--> X-term & CDE

* AS400

--> Digital Unix

--> Solaris

--> RedHat Linux(Alpha)

--> Silicon Graphics

--> Next

--> Misc Procedures

--> Windows 95, NT

--> Dialup

--> Linux

AS400 Setup, database creation, web server, etc.

Note, these notes have not been edited yet, please don't expect them to make sense!
  • Creating a Database
    strpdm
    work with jcampus
    3 qddsrc<F4>(copy to library chandra)
    2 to edit
    • I == insert
    • D == delete
    • C == copy
    compile the database after working with it (command is 14). Then view the spool (command is SP) and hit 5 to get details (put a B in control to get to the bottom)
    To use the database with net.data it must be journaled. The commands are CRTJRNCV and CRTJRN.
    • CRTJRCV
    • CRTJRN
      use the RCV name and lib from the previous command
    • STRJRNPF
      use journal from previous, lib etc

      STRSQL
      insert<F4>
      Into File ... phone
      Lib ... chandra
    select * from libname/filename
    WRKHTTPCFG
    • pass == dir where macro files will live
    • map /db2web/* QSYS.LIB ... chandra/*
    ENDTCPSVR *HTTP
    STRTCPSVR<F4>
    default
    savlib<F4>
    LIBNAME .... chandra
    Device .... TAP01
    DSPMSG QSYSOPR
    WRKACTJOB
    RSTLIB<F10>
    F10 gets you a space to put a new libname so you do not overwrite an existing lib
    SAV<F4>
    Device ... /QSYS.LIB/TAP01.DEVD
    Object .... '/chandra/*'
  • Importing to a database from a comma delimited file
    • CPYFRMIMPF
      Database already created
      • fields have to match
    • CPYTOIMPF
    • STRHOSTSVR *ALL
  • Compiling C Code
    • generally just type 14 and it will compile.
    • If you need to link modeules use CRTCMOD<F4><F10> and CRTPGM<F4>
  • Editing startup files
    • find old startup files
    • the startup files are compiled, so you cant just copy one and edit the file to add/delete a service.
      • go to an existing startup. To find this type WRKSYSVAL and find QSTRUPPGM
      • find the CL file
      • 3 extracts source
      • cut and paste and then edit the changes to add a service. To cut a chunk from the file go to the lines you want and put a "CC" on each line, then an "A" on the line before where you want to paste and hit enter.
      • go to QSYS LIB
        • in position to .... QSTR
        • in position to type .... *PGM
        • copy the original QSTRUP to a backup file (3)
        • delete QSTRUP
        • go to the working area where you have the new startup file edited and compiled (14 to compile) and copy it to QSYS/QSTRUP
      • to ftp a savf (like a tgz file) to the as400 :
        • ftp
        • bin
        • quote site namefmt 1
        • put filename.savf /qsys.lib/libraryname.lib/filename.savf
        Then to unpack it type
        • rstlib<F4>
          Saved Library .... libraryname
          Device .... *SAVF
          SaveFile .... filename
          Library .... new library name