AS400 大厂面试

AS400 大厂面试

1. 大厂面试简单的英文自我介绍：

I am XXXX

I have about three companies working experience,

all projects were the bank projects on as400 .

XXXXX   year working for XXX projects. and 1 year XXX project

so i am familer with as400 XXX and

core banking bussiness logic(like XXXXX   and so on)

At begin XXXXX years i was in XXXXX  team.

which was responsed the coding, devloped and deployedment project

XXXX, I am go to XXXX, working for XXXX and my role as the TL

so my duty not only to do the project requirement

analysis and communicate with customers . but also train the new teammates and solve the Tenical issue

At first. our team don’t know about XXX  Busniesss and all teammate don’t contains working experince except me.  the XXXX was hard and the time urgently.  but at last we succesfully deliver the projects with highly quilities and hit the timeline. so we XXXXX

About two year later .  the XXXXX   was  replace the XXXXX  . so we was the first team to learning the XXXXX  knowledage. and to doing the XXXXX  projects like XXXXX   create and customer search.

At part time. I also would like to learning new thing. such  as XXXX  and PMP.

2. 简单的英文描述：

• 最深刻的工作或者项目经历

• 怎么解决的

• 你在其中是怎么样的角色

3） 转回中文问题

• 你为什么离开上家公司

• 如果你遇到资源问题你怎么解决

• 你遇到的技术问题，怎么解决的

• 你认为你的岗位有什么价值

• 如果说遇到沟通问题，是别人的问题但你解决不了你怎么解决

• 技术问题 AS400 相关

  怎么让copy file 速率更快

  MOVEL ， MOVE ， MOVEL（P）的区别

  如果前台job出错了， 你会怎么做

*INLR 有啥用

如果处理lock 问题  ？

附录AS400 问题

Q1: Which library gets loaded first when we login to IBM i?

当我们登陆400 时，最先调用的是哪个lib ?

答：是QSYSlib , 系统lib

Q2: How to see all the objects in the library and their size?

怎么看到一个lib 下面所有的object 和他们的size信息

答：DSPLIB ，这个命令，如果你有时候对object 没有权限的时候，可以dsplib 看到*no authority .

Q3: How to check all members of a file?

怎么看一个file下面所有的member

答：用 DSPFD TYPE(*MBRLIST)

Q4: How to see all the record format in a file?

怎么看file下面所有的record format

答： 用DSPFD command TYPE(*RCDFMT)

Q5: How to change the record size of a PF?

答：

CHGPF SIZE()

Q6: Why do we use the USROPN keyword in RPGLE?

答：可以实时去开一个文件，或者关闭，这样是为了防止文件被锁，在多个online job下面如果长期不关文件的话

Q8: What is the purpose of using VARYING?

DVAR1             S             10A   VARYING

/Free

VAR1 = ‘HELLO’;

/End-Free

答：动态的设置变量的长度

Q10: Difference between CRTDUPOBJ and CPYF command?

答：一个是克隆的意思，就是可以复制你的关系，比如trigger和对应的属性

一个是拷贝文件，只是针对数据保持一致。

CRTDUPOBJ will create the exact replica of an object such as LF would be LF.

CPYF is used to copy data and it makes LF a PF.

Q11: What are mandatory keywords for a Subfile?

答:

SFL (Subfile format keyword)

SFLCTL (Subfile control format keyword)

SFLDSP (Subfile Display keyword)

SFLPAG (Subfile Page keyword)

SFLSIZ (Subfile Size keyword)

SFECTL

SFLSIZ(999)

OVERLAY

16 SFLDSP

SFLDSPCTL

17 SFLDLT

18 SFLCLR

19 SFLEND(*More)

写SFL 的时候，开始要做初始化

关   set off SFLDSP的灯 *IN16

关   set off SFLEND的灯 *IN19 因为没有值

开  clear SFL 的灯  *IN17

关   off SFL 的灯 *IN17

写SFL subfile的时候，

do loop the file

写  subfile and RRN +1

enddo

点亮

set on SFLDSP *IN16/SFLEND *IN19

Q12: What is the difference between PLIST ad KLIST?

答:

PLIST is list of parameters. 是入口参数的列表

KLIST is list of key fields. Key 字段的列表

Q13: What is the difference between *INLR = *ON and RETURN?

答:

RETURN will return the program to the caller.

结束程序

*INLR = *ON would free the memory and the program gets end.

结束程序并清掉缓存，会帮忙把对应的值都清空

Q14: What are the effective use and side effects of *INLR? How to overcome the side effects? Example use case scenarios?

答:

Effective Use:

If *INLR = *OFF, return from called program, next call faster, program variable do not get reinitialized and program defined files do not get closed.

没有点亮*INLR 不会清缓存，但是可以让你的程序跑的更快。

但是会导致你的文件一致没有关，和一些变量的值没有初始化会被累加。

Q15: What operations we can perform on Indicators?

答:

SETON

SETOFF

Q16: How to check if a record is locked in RPGLE?

答: 在file后面定义 *INFDS

如果出现code 01218 就说明 file 对应的record被锁了

也可以用indicate 去判断

*STATUS INFDS, Code 01218

Q17: How we can execute a CL command from within RPG program without calling a CL program?

怎么在RPGLE 里面执行 CL 命令

答:

call  QCMDEXC API

QCAPCMD API

SYSTEM API (C API)

Q18: Can we use a file with the same file name and same record format name in RPGLE?

当有重复的file名字在rpgle 怎么办

答:

No, but if we RENAME the record format name in F specs in RPG then Yes.

我们可以重命名，用rename关键字

Q20: How to retrieve the RRN value of the file record in RPGLE?

怎么拿到RRN 在RPGLE 里面:

答：用INFDS（RRN）

Using INFDS (file information data structure)

Q22: How can we display data from a flat-file?

答:

RUNQRY

DSPPFM

Q23: Difference between READC and SFLNXTCHG?

答:

READC for reading a changed record only once.

SFLNXTCHG was used with READC to read changed records multiple times.

Q24: Difference between ITER and DO?

答:

ITER is a branching statement and control jump to ENDDO.

DO is a looping statement

Q25: Difference between RENAME and PREFIX?

答::

RENAME is used to rename the record format in the RPG program.

PREFIX is used to rename file fields in the RPG program.

Q26: How to debug a job that is in MSGW state?

怎么debug 一些online job ？

答::

STRSRVJOB 这个job 然后 STRDBG你的程序

Q27: How do you pass parameters in CL program?

答::

PARM keyword

Q28: What is a spool file?

什么事输出池文件

答::

用来做打印的，放在outq里面的数据，你可以用cpysplf 把对应的数据copy出来

Printed output placed at OUTQ.

Q29: What does EXFMT do?

EXFMT 是干嘛的

答:

先写到file里面然后去读取

就是先把数据写到dsp 里面然后读取你输入的数据

WRITE then READ.

Q32: What is the difference between PACKED and ZONED decimal?

P 类型和Z 类型的区别

答:

默认是P类型，在rpgle里面。

Packed - 1 digit - 1 byte

Zoned - 1 digit - 2 byte

Q34: How do you read a DSPF and Database file in CL program?

在CL pgm 里面怎么读数据

答:

用RCVF command， 这个可以用CL 来写DSP file包括一个简单的DSP

Q35: How do you declare more than one file in CL program?

在CL pgm 里面怎么定义文件

答:

用Using DCLF and OPNID (open identifier)

Q37: Why do we use %SST in CL program?

答:

去截取数据给到一个string

Q38: What is the difference between SFLPAG and SFLSIZ?

SFLPAG 和SFLSIZ的区别

答:

SFLPAG is the number of records displayed on a Subfile screen at a time.

代表一页显示多少行

SFLSIZ is the total number of records that can be loaded in a Subfile.

代表整个subfile 可以load 多少行，最多好像是9999