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.
最深刻的工作或者项目经历
怎么解决的
你在其中是怎么样的角色
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