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 rpg ?

1 Answers   IBM,


which are control break logic indicators?

0 Answers   IBM,


define the purpose of the iter operation?

1 Answers   IBM,


can a indexed file be accessed in arrival sequence in rpg program?

1 Answers   IBM,


why we use binding directory and service pgm

4 Answers   TCS,


all i need to know about cmpseqdat parameter in cmppfm, how it works and can we retrieve line sequence and date from the output?

0 Answers  


how will you add a field to physical file already containing data?

1 Answers   IBM,


how a varible can be passed to a subfile...accnt1 contain data in a data area..ie Daccnt1 uds,Daccnt2 3 overlay(accnt1:1), DNo 4 overlay(accnt1:4)..we want to transfer this dataarea value from acnt0001 to a subfile..that means to enter each record we have to incriment account no,, i normal window we can do move accnt1 account_no eval account_no=accnt1 eval no=no+1 exfmt usr_account how it possible with Subfile????????.Please do answer? (Thank you for all your answers dear friends!!)

1 Answers   CTS,


can u plz tell me is there any difference between SHELL SCRIPT & SFTP SCRIPT? I want to run LS & GET(automatically) command from CL program....which script can be used?

1 Answers  


maximum number of subfiles that can defined in a rpg program for one display file is?

1 Answers   IBM,


Can anybody know difference between SNDUSRMSG AND SNDPGMMSG IN CL PROGRAMMING? IF DON'T KNOW MAIL ME @ gkarthik.as400@gmail.com

3 Answers  


What would be the output of the variable result? D RESULT S 5S O INZ(00011) C EVAL RESULT = %TRIM(RESULT) Please give me the correct answer for this A.0001 b.compile time error c.11 d.Runtime error

5 Answers  


Categories