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

What are the different types of messages in CL?

1 Answers  


what is OUTFILE?what is the uses and disadvantage? where we can use this?

2 Answers  


How to see all members of a file?

1 Answers  


Specify different indicators used in RPG?

1 Answers  


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

3 Answers   CTS,


what is difference between accespath and datapath? what is the difference between accespath and open datapath?

2 Answers  


What command must be executed before executing OPNQRYF command?

1 Answers  


Difference Between Interactive & Batch Job?

0 Answers   IBM,


What is purpose of declarative statement DEFN?

1 Answers  


how do you read changed records backward in subfile?

0 Answers   IBM,


What are the record format field mapping options in cpyf?

0 Answers  


what is the difference between sflclr and sflinz?

1 Answers   IBM,


Categories