writing an sql statement from selecting records from two files using single stat

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

Question Posted / kamlesh kumar

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

More IBM AS400 AllOther Interview Questions

can you specify a display file to be used in the following modes input,output, or combined modes ?

Which command we can use to update a physical file using c.l pgm?

What is the difference between iter and do? We know both are used to execute set of statements repeatedly, but what is the main difference?

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

when would you prefer logical file than opnqryf?

how to validate input values in display file ?

1.What is the difference between regular join logical file and non join logical file? 2.what are the nessasary keywords for non join logical file

what is the maximum number of files allowed in rpg?

What is the difference between a Physical File & a Logical?

what is the use of sflend keyword?

How can u create a temporary file in CLP @ how to access that temporary file in RPG program?

Is qgpl a user library or system library?

For more IBM AS400 AllOther Interview Questions Click Here