I need to insert a record in a file using STRSQL containing the some field values same as an already existing record in that file.I know to smple insert mentioning those values one by one.But is there any another query can be prepared for the same .Please share the query if known to you.

Thanks in advance.


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

Post New Answer

More IBM AS400 AllOther Interview Questions

Why do you use Keep and Assume Keywords.

2 Answers   Four soft,


what are the uses of factor1, factor2 and result field for the rpg operation code parm?

0 Answers   IBM,


WHAT is STORED PROCEDURE CONCEPT IN AS400 WITH EXAMPLE?

0 Answers  


which cl command can be used at program execution to redirect the file named in an rpg program?

0 Answers   IBM,


can you have multiple key lists for a single file ?

1 Answers   IBM,






is their a difference in cobol400 for the release 5.2 and 6.1 at the as400.

0 Answers  


how to run other job when one job is active?

0 Answers   IBM,


what is the version of os/400 that we have?

1 Answers   IBM,


what does vldcmdkey means?

0 Answers   IBM,


How a field is renamed in rpg IV?..give answer with example?

3 Answers   CTS,


When will you use OPEN and CLOSE opcodes in RPG program?

1 Answers  


can a join logical file be updated?

0 Answers   IBM,


Categories