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

A phisical file has two fields like 1) Account No(10,0) 2)Phone No(15,0)Unique on both fields?Please give me the answer for this?

3 Answers  


how you get the relative record in a subfile in which cursor is located?

0 Answers   IBM,


What is the purpose of the following FORDHDR1 CF E WORKSTN $2SFN SFILE FMT2

1 Answers  


what does vldcmdkey means?

0 Answers   IBM,


What are the mandatory keywords of sub file?

0 Answers   IBM,


what do we can do with the embedded sql statements?

0 Answers   IBM,


can we creat a member logical file

3 Answers  


How many libraries can be there in library list ?

1 Answers  


how to write code for singlepage in sqlrpgle with update ?

0 Answers  


Pgm A is invoked through HTTP. It is in Activtion group QILE. Pgm A calls Pgm B and Pgm C. Pgm B is in activation group TEMPACTGRP. Pgm A ends in error. Pgm A is called again. But it gives an error that TEMPACTGRP still exists and files are present in QTEMP. What is the cause and how will u fix?

1 Answers  


how to define to define a hidden filed in dspf ?

0 Answers   IBM,


Write the subfile logic program for the given concept. Load the data to the subfile depends upon the designation where designation is not a key field?

2 Answers  


Categories