INTRODUCING AS400 AND DB2 400 BASIC PART

 As/400 is a special kind of system which was implemented by IBM, Which was incorporated(merging)    with software and hardware.

 The As/400 system was designed especially for developing Bussiness application as well as run that applications.

  As/400 system has it own OS called OS/400 .Database named  as DB2/400 and other programming languages such as rpg3,rpg4,cl/400 etc.

  As/400 is Objecct based technology(or) object based system.

OBJECT

An object is a base unit (or) element and which exists as well as occupies some memory in As/400 server/system on which the Os/400 commands are performed.

àThe examples of objects are….

1)      Library(*lib)

2)      Program(*PGM)

3)      Module(*MODULE)

4)      File(*FILE)

5)      Data Area(*DTAARA)

6)      DataQ(*DTAQ)

7)      Jobq(*JOBQ)

8)      Outq(*OUTQ)

9)      Userprofile(*USRPRF)

10)  Command(*CMD)

11)  Jod description(*JOBD)

12)  Sub system(*SUBSYSYS)

àEvery object in an As/400 system has a unique name as well as object type.

àEvery object is identified by its name and run’s a specific command based on it’s type.

àTo convert RPG3 to RPG4 the command is CVTRPGLE.

COMMANDS ON LIBRARY:

        I.            CRTLIB: creating library

     II.            DLTLIB:deleting library

   III.            WRKLIB:work with library.

  IV.            WRKLIBPDM:work with library using pdm

     V.            EDTLIB:edit library

  VI.            CHGLIBL:change library list.

VII.            DSPLIBL:display library list

VIII.            ADDLIBL:add library list entry.

  IX.            RMVLIBLE-removelibrary list entry.

     X.            CHGCURLIB:change current library.

 DB2/400

àDB2/400 is a traditional database use in an As/400 System .

àDb2/400 is nothing but a collection of database objects such as source files,physical files,logical files,triggers,stored proccessors.

àIn an As/400 system  there are plenty of files which are all working with the data.which are as follows…

1)      Database files.

2)      Display files

3)      Printer files

4)      Data description management files.

5)      Save files

6)      Interactive  communication system files

7)      Message files.

Database files:

     Types of database files.

        i.            Source physical file

      ii.            Physical file

    iii.            Logical file

    iv.            Field reference file

                                            i.            source physical file:

                  A source physical file is an object of type *file.And it’s source type /attribute is PF-SRC

Which  is use to store the data which is not actually the business data which is a source of all other program files etc.

àSource physival file has a specific record stracture by default when it is created by the command

CRTSRCPF.

àthis record stracture is called record format of a file which has three fields namely

a)Source sequence(SRCSEQ):

                  which is a length of 6 joined decimal type with no decimal positions.

b)Source Date(SRCDAT):

                              which is a length of 6 joined decimal type with 2 decimal posions.

c)Source data(SRCDTA):

                              which is a length of 80 characters type. the length of the record of Source physical file is 92 which is equal to the sum of all fields in that record format, But the recommended length is 112 which can be reliable in ILE programs.

                  The data which is restored in source physical file record by record in a particular member with a proper record stricture which follows the record format of source physical file.

                  When source physical file is created no member will be associated with it by default, because one of the parameter of the command CRTSRCPF is member of desired has a value “*none” so no member will be created in.

Record format:

      Record format is nothing but a record stracture in a file through which all records follow this record stracture,record format can be defined by a set fields (or) group of fields it has a control our fields and it also maintains the order of the fields while retrives the data as well as sending the data from file.

Note:for every file in an as/400 system there is at least on erecord format is defined and the record format has an unique name in the file.

Member:

      Member is a sub set of data in database fileit is a memory of file where the data is actually stored,the data records which contain the member follows a specific record stracture which defined either record format of a file.

                  In an As/400 system every database file must contain at least one member it can be a maximum of 32,767 except a source physicalfile which design contain any member at file creation .if member is not associated with any database file that file is not allowed to input/output operations.

ii) Physical file:

            physical file is an object of type *file and it’s source type/attribute is PF-DTA which is used to stored the actual Bussiness data.

Ø  Physical file has only one format if does not support for multiple record formats.

Ø  Inorder to create physicalfile either a command CRTPF or F6 or source member option 14 can be used.

Ø  Inorder to execute  CRTPF no definitions required .

Ø  To create PF object with a proper  stpes.

THE FOLLOWING FECILITIES ARE REQUIRED..

v  Data types

v  Level entries

v  PDM tool(program development manager)

v  DDS(data description specification)

àData types

Ther e are 9 types of data types in database.

àlevel entries

   ---file level                :entries :fifo,fcfo,lifo,ref,unique.

   ---Record format      :Text ,Format

  ---field level              : Alias, check, comp/cmp, colhog, dft, dat sep, ref fld,Text,       Range.Timfmt,timsep,values,allnull

 ---key field level         :Absualute,signed,unsigned,descend.

c)Pdm tool:

                        In an AS/400 System thire is a tool set ADTS(application development tools set) which is IBM supplied tool which hasa lot of tools to define an application among all tools ADTS,PDm is one of them ,PDM has a lot of features and options which helps us to make our life easier in developing and working the application.PDM is started by the start command “STRPDM”

            The tool which used/started by pdm tool as follows.

s.no                              name                            Expanssion                              startcommand

1                                  DFU                             datafileutility                           STRDFU

2                                  SEU                             Sourceentryutility                    STRSEU

3                                  SQl                              stracturequarylanguage                        STRSQL

4                                  QRY/400                     query/400                                STRQRY/WRKQRY

5                                  SDA                             Screendesignaid                       STRSDA

6                                  RLU                             Report layout utility                 STRRLU                     

7                                  ISDB                            interactivesourcedebuger         STRISDB

8                                  FCMU                          file complier &merge utility     STRFCMU.

CREATING PF:

Diagrams………………………

àIn order to do the input /output  operatins we have the following operations.

a.       UPDDTA

b.      DFU

c.       SQL

d.      QRY/400

e.       RPG3/RPG4

f.       CL/400

LOGICAL FILE:

                        A LOGICAL FILE  is an object of type *file  and it’s  source type/attribute LF.

-àLogical file does not contain any data it’s just a view on physical file

àA logical file can contain a single record format and more than one record format where as physical file supports only one.

Advantages of logical file:

                        A logical file can be define on a particular physical file to work with the data either in fully or partially.

àA logical file can be define with key fields even though the physical file does not have any keyfields.

àA logical file can be define on obe physical file  or morethan one physical file .

Ø  As/400 is a special kind of system which was implemented by IBM, Which was incorporated(merging) with software and hardware.

Ø  The As/400 system was designed especially for developing Bussiness application as well as run that applications.

Ø  As/400 system has it own OS called OS/400 .Database named  as DB2/400 and other programming languages such as rpg3,rpg4,cl/400 etc.

Ø  As/400 is Objecct based technology(or) object based system.

OBJECT

            An object is a base unit (or) element and which exists as well as occupies some memory in As/400 server/system on which the Os/400 commands are performed.

àThe examples of objects are….

1)      Library(*lib)

2)      Program(*PGM)

3)      Module(*MODULE)

4)      File(*FILE)

5)      Data Area(*DTAARA)

6)      DataQ(*DTAQ)

7)      Jobq(*JOBQ)

8)      Outq(*OUTQ)

9)      Userprofile(*USRPRF)

10)  Command(*CMD)

11)  Jod description(*JOBD)

12)  Sub system(*SUBSYSYS)

àEvery object in an As/400 system has a unique name as well as object type.

àEvery object is identified by its name and run’s a specific command based on it’s type.

àTo convert RPG3 to RPG4 the command is CVTRPGLE.

COMMANDS ON LIBRARY:

        I.            CRTLIB: creating library

     II.            DLTLIB:deleting library

   III.            WRKLIB:work with library.

  IV.            WRKLIBPDM:work with library using pdm

     V.            EDTLIB:edit library

  VI.            CHGLIBL:change library list.

VII.            DSPLIBL:display library list

VIII.            ADDLIBL:add library list entry.

  IX.            RMVLIBLE-removelibrary list entry.

     X.            CHGCURLIB:change current library.

                                                DB2/400

àDB2/400 is a traditional database use in an As/400 System .

àDb2/400 is nothing but a collection of database objects such as source files,physical files,logical files,triggers,stored proccessors.

àIn an As/400 system  there are plenty of files which are all working with the data.which are as follows…

1)      Database files.

2)      Display files

3)      Printer files

4)      Data description management files.

5)      Save files

6)      Interactive  communication system files

7)      Message files.

Database files:

     Types of database files.

        i.            Source physical file

      ii.            Physical file

    iii.            Logical file

    iv.            Field reference file

                                            i.            source physical file:

                  A source physical file is an object of type *file.And it’s source type /attribute is PF-SRC

Which  is use to store the data which is not actually the business data which is a source of all other program files etc.

àSource physival file has a specific record stracture by default when it is created by the command

CRTSRCPF.

àthis record stracture is called record format of a file which has three fields namely

a)Source sequence(SRCSEQ):

                  which is a length of 6 joined decimal type with no decimal positions.

b)Source Date(SRCDAT):

                              which is a length of 6 joined decimal type with 2 decimal posions.

c)Source data(SRCDTA):

                              which is a length of 80 characters type. the length of the record of Source physical file is 92 which is equal to the sum of all fields in that record format, But the recommended length is 112 which can be reliable in ILE programs.

                  The data which is restored in source physical file record by record in a particular member with a proper record stricture which follows the record format of source physical file.

                  When source physical file is created no member will be associated with it by default, because one of the parameter of the command CRTSRCPF is member of desired has a value “*none” so no member will be created in.

Record format:

      Record format is nothing but a record stracture in a file through which all records follow this record stracture,record format can be defined by a set fields (or) group of fields it has a control our fields and it also maintains the order of the fields while retrives the data as well as sending the data from file.

Note:for every file in an as/400 system there is at least on erecord format is defined and the record format has an unique name in the file.

Member:

      Member is a sub set of data in database fileit is a memory of file where the data is actually stored,the data records which contain the member follows a specific record stracture which defined either record format of a file.

                  In an As/400 system every database file must contain at least one member it can be a maximum of 32,767 except a source physicalfile which design contain any member at file creation .if member is not associated with any database file that file is not allowed to input/output operations.

ii) Physical file:

            physical file is an object of type *file and it’s source type/attribute is PF-DTA which is used to stored the actual Bussiness data.

Ø  Physical file has only one format if does not support for multiple record formats.

Ø  Inorder to create physicalfile either a command CRTPF or F6 or source member option 14 can be used.

Ø  Inorder to execute  CRTPF no definitions required .

Ø  To create PF object with a proper  stpes.

THE FOLLOWING FECILITIES ARE REQUIRED..

v  Data types

v  Level entries

v  PDM tool(program development manager)

v  DDS(data description specification)

àData types

Ther e are 9 types of data types in database.

àlevel entries

   ---file level                :entries :fifo,fcfo,lifo,ref,unique.

   ---Record format      :Text ,Format

  ---field level              : Alias, check, comp/cmp, colhog, dft, dat sep, ref fld,Text,       Range.Timfmt,timsep,values,allnull

 ---key field level         :Absualute,signed,unsigned,descend.

c)Pdm tool:

                        In an AS/400 System thire is a tool set ADTS(application development tools set) which is IBM supplied tool which hasa lot of tools to define an application among all tools ADTS,PDm is one of them ,PDM has a lot of features and options which helps us to make our life easier in developing and working the application.PDM is started by the start command “STRPDM”

            The tool which used/started by pdm tool as follows.

s.no                              name                            Expanssion                              startcommand

1                                  DFU                             datafileutility                           STRDFU

2                                  SEU                             Sourceentryutility                    STRSEU

3                                  SQl                              stracturequarylanguage                        STRSQL

4                                  QRY/400                     query/400                                STRQRY/WRKQRY

5                                  SDA                             Screendesignaid                       STRSDA

6                                  RLU                             Report layout utility                 STRRLU                     

7                                  ISDB                            interactivesourcedebuger         STRISDB

8                                  FCMU                          file complier &merge utility     STRFCMU.

CREATING PF:

Diagrams………………………

àIn order to do the input /output  operatins we have the following operations.

a.       UPDDTA

b.      DFU

c.       SQL

d.      QRY/400

e.       RPG3/RPG4

f.       CL/400

LOGICAL FILE:

                        A LOGICAL FILE  is an object of type *file  and it’s  source type/attribute LF.

-àLogical file does not contain any data it’s just a view on physical file

àA logical file can contain a single record format and more than one record format where as physical file supports only one.

Advantages of logical file:

                        A logical file can be define on a particular physical file to work with the data either in fully or partially.

àA logical file can be define with key fields even though the physical file does not have any keyfields.

àA logical file can be define on obe physical file  or morethan one physical file .

 Ø  As/400 is a special kind of system which was implemented by IBM, Which was incorporated(merging) with software and hardware.

Ø  The As/400 system was designed especially for developing Bussiness application as well as run that applications.

Ø  As/400 system has it own OS called OS/400 .Database named  as DB2/400 and other programming languages such as rpg3,rpg4,cl/400 etc.

Ø  As/400 is Objecct based technology(or) object based system.

OBJECT

            An object is a base unit (or) element and which exists as well as occupies some memory in As/400 server/system on which the Os/400 commands are performed.

àThe examples of objects are….

1)      Library(*lib)

2)      Program(*PGM)

3)      Module(*MODULE)

4)      File(*FILE)

5)      Data Area(*DTAARA)

6)      DataQ(*DTAQ)

7)      Jobq(*JOBQ)

8)      Outq(*OUTQ)

9)      Userprofile(*USRPRF)

10)  Command(*CMD)

11)  Jod description(*JOBD)

12)  Sub system(*SUBSYSYS)

àEvery object in an As/400 system has a unique name as well as object type.

àEvery object is identified by its name and run’s a specific command based on it’s type.

àTo convert RPG3 to RPG4 the command is CVTRPGLE.

COMMANDS ON LIBRARY:

        I.            CRTLIB: creating library

     II.            DLTLIB:deleting library

   III.            WRKLIB:work with library.

  IV.            WRKLIBPDM:work with library using pdm

     V.            EDTLIB:edit library

  VI.            CHGLIBL:change library list.

VII.            DSPLIBL:display library list

VIII.            ADDLIBL:add library list entry.

  IX.            RMVLIBLE-removelibrary list entry.

     X.            CHGCURLIB:change current library.

                                                DB2/400

àDB2/400 is a traditional database use in an As/400 System .

àDb2/400 is nothing but a collection of database objects such as source files,physical files,logical files,triggers,stored proccessors.

àIn an As/400 system  there are plenty of files which are all working with the data.which are as follows…

1)      Database files.

2)      Display files

3)      Printer files

4)      Data description management files.

5)      Save files

6)      Interactive  communication system files

7)      Message files.

Database files:

     Types of database files.

        i.            Source physical file

      ii.            Physical file

    iii.            Logical file

    iv.            Field reference file

                                            i.            source physical file:

                  A source physical file is an object of type *file.And it’s source type /attribute is PF-SRC

Which  is use to store the data which is not actually the business data which is a source of all other program files etc.

àSource physival file has a specific record stracture by default when it is created by the command

CRTSRCPF.

àthis record stracture is called record format of a file which has three fields namely

a)Source sequence(SRCSEQ):

                  which is a length of 6 joined decimal type with no decimal positions.

b)Source Date(SRCDAT):

                              which is a length of 6 joined decimal type with 2 decimal posions.

c)Source data(SRCDTA):

                              which is a length of 80 characters type. the length of the record of Source physical file is 92 which is equal to the sum of all fields in that record format, But the recommended length is 112 which can be reliable in ILE programs.

                  The data which is restored in source physical file record by record in a particular member with a proper record stricture which follows the record format of source physical file.

                  When source physical file is created no member will be associated with it by default, because one of the parameter of the command CRTSRCPF is member of desired has a value “*none” so no member will be created in.

Record format:

      Record format is nothing but a record stracture in a file through which all records follow this record stracture,record format can be defined by a set fields (or) group of fields it has a control our fields and it also maintains the order of the fields while retrives the data as well as sending the data from file.

Note:for every file in an as/400 system there is at least on erecord format is defined and the record format has an unique name in the file.

Member:

      Member is a sub set of data in database fileit is a memory of file where the data is actually stored,the data records which contain the member follows a specific record stracture which defined either record format of a file.

                  In an As/400 system every database file must contain at least one member it can be a maximum of 32,767 except a source physicalfile which design contain any member at file creation .if member is not associated with any database file that file is not allowed to input/output operations.

ii) Physical file:

            physical file is an object of type *file and it’s source type/attribute is PF-DTA which is used to stored the actual Bussiness data.

Ø  Physical file has only one format if does not support for multiple record formats.

Ø  Inorder to create physicalfile either a command CRTPF or F6 or source member option 14 can be used.

Ø  Inorder to execute  CRTPF no definitions required .

Ø  To create PF object with a proper  stpes.

THE FOLLOWING FECILITIES ARE REQUIRED..

v  Data types

v  Level entries

v  PDM tool(program development manager)

v  DDS(data description specification)

àData types

Ther e are 9 types of data types in database.

àlevel entries

   ---file level                :entries :fifo,fcfo,lifo,ref,unique.

   ---Record format      :Text ,Format

  ---field level              : Alias, check, comp/cmp, colhog, dft, dat sep, ref fld,Text,       Range.Timfmt,timsep,values,allnull

 ---key field level         :Absualute,signed,unsigned,descend.

c)Pdm tool:

                        In an AS/400 System thire is a tool set ADTS(application development tools set) which is IBM supplied tool which hasa lot of tools to define an application among all tools ADTS,PDm is one of them ,PDM has a lot of features and options which helps us to make our life easier in developing and working the application.PDM is started by the start command “STRPDM”

            The tool which used/started by pdm tool as follows.

s.no                              name                            Expanssion                              startcommand

1                                  DFU                             datafileutility                           STRDFU

2                                  SEU                             Sourceentryutility                    STRSEU

3                                  SQl                              stracturequarylanguage                        STRSQL

4                                  QRY/400                     query/400                                STRQRY/WRKQRY

5                                  SDA                             Screendesignaid                       STRSDA

6                                  RLU                             Report layout utility                 STRRLU                     

7                                  ISDB                            interactivesourcedebuger         STRISDB

8                                  FCMU                          file complier &merge utility     STRFCMU.

CREATING PF:

Diagrams………………………

àIn order to do the input /output  operatins we have the following operations.

a.       UPDDTA

b.      DFU

c.       SQL

d.      QRY/400

e.       RPG3/RPG4

f.       CL/400

LOGICAL FILE:

                        A LOGICAL FILE  is an object of type *file  and it’s  source type/attribute LF.

-àLogical file does not contain any data it’s just a view on physical file

àA logical file can contain a single record format and more than one record format where as physical file supports only one.

Advantages of logical file:

                        A logical file can be define on a particular physical file to work with the data either in fully or partially.

àA logical file can be define with key fields even though the physical file does not have any keyfields.

àA logical file can be define on obe physical file  or morethan one physical file .

 Ø  As/400 is a special kind of system which was implemented by IBM, Which was incorporated(merging) with software and hardware.

Ø  The As/400 system was designed especially for developing Bussiness application as well as run that applications.

Ø  As/400 system has it own OS called OS/400 .Database named  as DB2/400 and other programming languages such as rpg3,rpg4,cl/400 etc.

Ø  As/400 is Objecct based technology(or) object based system.

OBJECT

            An object is a base unit (or) element and which exists as well as occupies some memory in As/400 server/system on which the Os/400 commands are performed.

àThe examples of objects are….

1)      Library(*lib)

2)      Program(*PGM)

3)      Module(*MODULE)

4)      File(*FILE)

5)      Data Area(*DTAARA)

6)      DataQ(*DTAQ)

7)      Jobq(*JOBQ)

8)      Outq(*OUTQ)

9)      Userprofile(*USRPRF)

10)  Command(*CMD)

11)  Jod description(*JOBD)

12)  Sub system(*SUBSYSYS)

àEvery object in an As/400 system has a unique name as well as object type.

àEvery object is identified by its name and run’s a specific command based on it’s type.

àTo convert RPG3 to RPG4 the command is CVTRPGLE.

COMMANDS ON LIBRARY:

        I.            CRTLIB: creating library

     II.            DLTLIB:deleting library

   III.            WRKLIB:work with library.

  IV.            WRKLIBPDM:work with library using pdm

     V.            EDTLIB:edit library

  VI.            CHGLIBL:change library list.

VII.            DSPLIBL:display library list

VIII.            ADDLIBL:add library list entry.

  IX.            RMVLIBLE-removelibrary list entry.

     X.            CHGCURLIB:change current library.

                                                DB2/400

àDB2/400 is a traditional database use in an As/400 System .

àDb2/400 is nothing but a collection of database objects such as source files,physical files,logical files,triggers,stored proccessors.

àIn an As/400 system  there are plenty of files which are all working with the data.which are as follows…

1)      Database files.

2)      Display files

3)      Printer files

4)      Data description management files.

5)      Save files

6)      Interactive  communication system files

7)      Message files.

Database files:

     Types of database files.

        i.            Source physical file

      ii.            Physical file

    iii.            Logical file

    iv.            Field reference file

                                            i.            source physical file:

                  A source physical file is an object of type *file.And it’s source type /attribute is PF-SRC

Which  is use to store the data which is not actually the business data which is a source of all other program files etc.

àSource physival file has a specific record stracture by default when it is created by the command

CRTSRCPF.

àthis record stracture is called record format of a file which has three fields namely

a)Source sequence(SRCSEQ):

                  which is a length of 6 joined decimal type with no decimal positions.

b)Source Date(SRCDAT):

                              which is a length of 6 joined decimal type with 2 decimal posions.

c)Source data(SRCDTA):

                              which is a length of 80 characters type. the length of the record of Source physical file is 92 which is equal to the sum of all fields in that record format, But the recommended length is 112 which can be reliable in ILE programs.

                  The data which is restored in source physical file record by record in a particular member with a proper record stricture which follows the record format of source physical file.

                  When source physical file is created no member will be associated with it by default, because one of the parameter of the command CRTSRCPF is member of desired has a value “*none” so no member will be created in.

Record format:

      Record format is nothing but a record stracture in a file through which all records follow this record stracture,record format can be defined by a set fields (or) group of fields it has a control our fields and it also maintains the order of the fields while retrives the data as well as sending the data from file.

Note:for every file in an as/400 system there is at least on erecord format is defined and the record format has an unique name in the file.

Member:

      Member is a sub set of data in database fileit is a memory of file where the data is actually stored,the data records which contain the member follows a specific record stracture which defined either record format of a file.

                  In an As/400 system every database file must contain at least one member it can be a maximum of 32,767 except a source physicalfile which design contain any member at file creation .if member is not associated with any database file that file is not allowed to input/output operations.

ii) Physical file:

            physical file is an object of type *file and it’s source type/attribute is PF-DTA which is used to stored the actual Bussiness data.

Ø  Physical file has only one format if does not support for multiple record formats.

Ø  Inorder to create physicalfile either a command CRTPF or F6 or source member option 14 can be used.

Ø  Inorder to execute  CRTPF no definitions required .

Ø  To create PF object with a proper  stpes.

THE FOLLOWING FECILITIES ARE REQUIRED..

v  Data types

v  Level entries

v  PDM tool(program development manager)

v  DDS(data description specification)

àData types

Ther e are 9 types of data types in database.

àlevel entries

   ---file level                :entries :fifo,fcfo,lifo,ref,unique.

   ---Record format      :Text ,Format

  ---field level              : Alias, check, comp/cmp, colhog, dft, dat sep, ref fld,Text,       Range.Timfmt,timsep,values,allnull

 ---key field level         :Absualute,signed,unsigned,descend.

c)Pdm tool:

                        In an AS/400 System thire is a tool set ADTS(application development tools set) which is IBM supplied tool which hasa lot of tools to define an application among all tools ADTS,PDm is one of them ,PDM has a lot of features and options which helps us to make our life easier in developing and working the application.PDM is started by the start command “STRPDM”

            The tool which used/started by pdm tool as follows.

s.no                              name                            Expanssion                              startcommand

1                                  DFU                             datafileutility                           STRDFU

2                                  SEU                             Sourceentryutility                    STRSEU

3                                  SQl                              stracturequarylanguage                        STRSQL

4                                  QRY/400                     query/400                                STRQRY/WRKQRY

5                                  SDA                             Screendesignaid                       STRSDA

6                                  RLU                             Report layout utility                 STRRLU                     

7                                  ISDB                            interactivesourcedebuger         STRISDB

8                                  FCMU                          file complier &merge utility     STRFCMU.

CREATING PF:

Diagrams………………………

àIn order to do the input /output  operatins we have the following operations.

a.       UPDDTA

b.      DFU

c.       SQL

d.      QRY/400

e.       RPG3/RPG4

f.       CL/400

LOGICAL FILE:

                        A LOGICAL FILE  is an object of type *file  and it’s  source type/attribute LF.

-àLogical file does not contain any data it’s just a view on physical file

àA logical file can contain a single record format and more than one record format where as physical file supports only one.

Advantages of logical file:

                        A logical file can be define on a particular physical file to work with the data either in fully or partially.

àA logical file can be define with key fields even though the physical file does not have any keyfields.

àA logical file can be define on obe physical file  or morethan one physical file .

AS400 INTERVIEW QUESTIONS

How do you pass parameters in CL?
Ans:Using PARM keyword.

What are the valid user defined data area types?
Ans:CHAR, NUMERIC and LOGICAL

What is Multi-format logical file?
Ans:Logical which uses fields from two or more physical files.

What is the Select and Omit criteria in logical file?
Ans:This is used to specify rules for the Selection/Omission of records from a Physical File.

Can fields be concatenated INa logical file level?
Ans:Yes. by using CONCAT keyword

When would the ALL keyword be used?
Ans:Use with Select or Omit, to select/omit records.

What are the different types of keywords in display files?
Ans:File level, Record format level, Field level

What is difference between CAT, TCAT, BCAT?
Ans:
CAT - Concatenate two variables or constants into one continuous string.
BCAT - Truncates all trailing blanks in the first character string, one blank is inserted, then the two character strings
are concatenated.
TCAT - Truncates all trailing blanks in the first character string, the two character strings
are concatenated.

What are the different types of messages in CL?
Ans:Immediate message, Break message, Program message, User message

How to trap errors in CL?
Ans:By using Monitor Message Command (MONMSG)

What is the maximum length of a variable name in CL?
Ans:Maximum 11 characters (including '&')

What are the limitations of CL (compare to RPG) ?
Ans:You can not use CL program to ADD or UPDATE records in database files.
Use Printer or ICF files.
Use Program described files.
Use the concept of subfile (to display more than one record), but a single output message subfile is a special type of
subfile that is supported well in CL.
Use subroutines.
You cannot declare more than one object (file) in a CL programme.

What is the use of Header Specification in RPG/400?
Ans:It identifies by H in column 6, provides informaion about generating and running programs.

When will DUMP and DEBUG opcodes be ignored?
Ans:If blank is specified in position 15 of H specs.

Specify different indicators used in RPG?
Ans:Overflow indicators
Record Identifying Indicators
Field Indicators
Resulting Indicators
Control Level Indicators

What are Control level indicators?
Ans:L1 to L9 used to identify certain fields on control fields and then used to condition which operations are to be processed at detail or total calculation or output time.

What is the use of E specification in RPG?
Ans:Extension Specs describes all record address files, arrays and tables.

What is the use of L specs in RPG?
Ans:Line counter specification can be used to describe printer file to indicate the length of the form and number of lines per page.

In which specification the report layout can be defined?
Ans:O Specification.

How many files can be defined in F specs?
Ans:50

How many printer files can be defined in F specs ?
Ans:8 

What is Alternate Table?
Ans:RPG tables stores information in 1 column. To store information in multiple columns, it uses the concept of Alternate Table.

What is an Array?
Ans:Array is a collection of data, the data elements must be of same Length and same type.

The Qualified name for an object ORDPF residing in a library TRAINING is?
Ans:TRAINING/ORDPF

The function key to start SEU session through program development manager is?
Ans:F6

The Member type for an RPG & CL program which SEU supports is?
Ans:RPG & CLP

Printed output items placed in an output queue are known as?
Ans:Spool Files.

When a spooled file is created, it is placed into an?
Ans:OUTQUEUE

The command to display a list of spooled files?
Ans:WRKSPLF

Change in the externally described file does not require recompilation of the program?
Ans:False

Command to display current library is?
Ans:DSPCURLIB

A PF can have how many record formats?
Ans:Only one

Which one of the following has the highest priority Library on top of the library list, Library QGPL, Library on the bottom of the library list & Current library?
Ans:Current library

While designing the screen user wants to add file level keywords then which function key is pressed?
Ans:F14

While designing the report using RLU user wants to add record level keywords which function key is pressed?
Ans:F18

If user wants to add one field on the report then which function key is pressed?
Ans:F11

If user wants to center the company name on his report then which command will be used?
Ans:CF (Center Field)

SEU shows prompt/syntax checking according to?
Ans:Member Type

It is possible to run Query using RUNQRY command?
Ans:YES

Using Query it is possible to create level break report?
Ans:YES

Using DFU user can do which operation?
Ans:Add, Update & Select fields

What is the difference between UPDDTA to PF & updating using DFU?
Ans:Both are same, only difference is DFU program allows you to add & update selected
fields.

Which function key should be pressed to define hidden field while you are working with SDA?
Ans:F4

Which function key should be pressed to watch all string defined on SDA screen?
Ans:F20

While designing the screen using SDA, which function key should be pressed to get the field from the FRF?
Ans:F10.

From WRKMBRPDM screen you have to modify existing member-using SDA which option do you select?
Ans:17.

Write system defined function used to place system name on the screen?
Ans:*SYSNAME

While designing screen F3 function key is kept common for all record formats on which level should it be defined?
Ans:File level

Write down mandatory keywords used when defining a subfile?
Ans:SFL, SFLDSP, SFLSIZ, SFLCTL & SFLPAG

If user wants to change the length of the numeric field defined in the report then which combination of the keys will be used?
Ans:F23 & F10

What is the difference between SKIPB (2) & SPACEB (2)?
Ans:SKIPB (2) skips 1 page & on the next page after skipping 2 lines space print next while SPACEB
(2) skips 2 lines space before printing.

RLU: If user wants to define new numeric field on record format then which line command will be used?
Ans:VF

Maximum report length is 132, if user is designing a report using RLU?
Ans:FALSE (Maximum is 378)

What is full form for DDS?
Ans:Data Description Specification

What are members?
Ans: Members are separate entities within a database file & they are components of As/400 object.

What if RPG, when & who invented it?
Ans:Report Program Generator is IBM introduced a High Level Language in 1960.

For, which purpose is H Specs used?
Ans:Writing header information, date separator, currency symbol etc.

What is the size of the filename in RPG?
Ans:8 Characters (Max.)

Which are the different File Types in RPG?
Ans:I (Input), O (Output), U (Update) & C (Combine).

What are the different File Designation Types in RPG?
Ans:P (Primary) & F (Fully Procedural)

What’s the use of File Designation in RPG?
Ans:It refers to the way program will access or retrieve the data from the file.

What are the different File Format Types in RPG?
Ans:F (Fixed Length) & E (Externally Described)

What is the use of File Format in RPG?
Ans:It tells to the program that the records are within the program (F) or outside the program (E).

What is L Specs for?
Ans:To tell length of page & number of lines to be printed on a page.

What is I Specs for?
Ans:To describe the records within Program described file, fields, constants, divide fields into sub fields & to form a group of
fields.

How many maximum spaces could be given in O Specs?
Ans:3

Which are Control Break Logic indicators?
Ans:L1 – L9.

What are Data Structures?
Ans:Data Structures define an a storage & layout of fields within the defined structure. 

Which are the four keywords supported by Program Status Data Structure?
Ans:*STATUS, *PARM, *ROUTINE & *PROGRAM

Which are the String Manipulation Opcodes?
Ans:TESTN, SCAN, CHECK, CHECKR, SUBST & CAT

DB2 is a type of Database?
Ans:It is an Integrated RDBMS.

An access path may be in which sequence?
Ans:It can be in Arrival & Keyed sequence

To change constant field defined on RLU screen which field level keyword should be used?
Ans:DFT (Default)

Space & Skip are which level keywords?
Ans:Field & Record

A Join Logical File has how many Record formats?
Ans:1

A Multiple format Logical File is also known as?
Ans:Union File

How does Union file maintains Record formats?
Ans:1 Record format for each PF

Records can be Read/Update/Deleted with which file?
Ans:Simple Logical File & Physical File.

Which type of object is used in DB2/400?
Ans:*FILE

What is SQL?
Ans:SQL is an interface for programming language.

File level entry for a PF can be?
Ans:UNIQUE & FIFO

What is the command to create FRF?
Ans:CRTPF

Join Logical File displays data from how many files?
2 or more PF’s

A Query can be displayed without saving it?
Ans:True

Which are the Query selection criteria, which can be given in a Query?
Ans:LIST

To add a file to the ‘File Selection’ option of a Query, the function key to be pressed is?
Ans:F9

A query can be run in which mode?
Ans:Batch & Interactive

What is the values SQLCOD when there is an error in fetching the records specified in the select statement?
Ans:-ve value

A file cannot have more than 1 unique key?
Ans:False

DLCOBJ command is mandatory for removing lock on any object?
Ans:False

What is a Journal?
Ans:A Journal is an object used primarily to record changes to data in a PF.

Which are the DB2 tools to protect Integrity of the database?
Ans:Journaling & Commitment Control, Referential Integrity Embedded SQL & Object/Record Locks. - 

AS400 Web Based Training

"ARRIVED AT THE RIGHT PLACE AND RIGHT TIME FOR THE RIGHT  IBM AS 400  TRAINING BY THE RIGHT PEOPLE."

 PLEASE CONTACT :  MESSAGEAS400@GMAIL.COM.

AS400 Online Training AS400 Training From India AS/400 Training

Here We are providing AS 400 Training in online classes

 Please contact : messageas400@gmail.com

                       +91   9505 102186