writing an sql statement from selecting records from two files using single statement and nested select statement.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More IBM AS400 AllOther Interview Questions

what is qcmdexc?

1 Answers   IBM,


Please give me the code for A=A+1 in cl program?

2 Answers  


What is journaling & Commitment Control?

1 Answers  


Determine the value of the result field a. Cost = $110. 00 b. Tax = 20% c. MarkUp= 05% d. Sale = 10%

1 Answers  


Explain this error: "all record formats for externally-described file abcd ignored or dropped due to error; file ignored."?

0 Answers  






How to change file attributes such as size, file wait time, record wait time etc., permanently?

1 Answers  


what is primarykey?what is difference between primary key and forign key?

1 Answers  


PGM QSH CMD('/QOpenSys/bin/sftp -b/home/test/myfile.txt serverUserID@server') ENDPGM In above example,what is content of myfile.txt ...Thanx

2 Answers  


what is the maximum number of subfiles that can specified in a display file ?

1 Answers   IBM,


In Which Specs Arrays, Tables & Constants Are Defined?

0 Answers   IBM,


We have seen no of parameter list but If we mention like this 'CALL PROGNAME PLIST ' how to know No of parameter name of program ?

2 Answers   IBM,


How do I remove a flag or check no. or name when a user opens too many sessions?

0 Answers  


Categories