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

how do you use exceptional write in c specs?

1 Answers   IBM,


Hi Friends, I need immediately answer for this: Senario is that,I am selecting records from the display and window subfile on the basis of Reason Code and some more fields but spool file not showing the same records which i have selected by display and window subfile. Q.What could be the causes(resons)to not show records properly (just selected in the display file and Window subfile)according the selection criteria of the records. Q.What would be the solutions to show records properly in the spool file just as selected in in the display file and window subfile according to the selection criteria.

1 Answers   IBM,


What is the difference between externally described file and program described file?

1 Answers  


what is the command used to invoke rlu ?

1 Answers   IBM,


What is the difference between array and a multiple occurrence data structure?

1 Answers  






what is elastic and non elastic subrile?

0 Answers   IBM,


How to position the cursor on a display file at a desired location.

5 Answers   Four soft,


what is the difference between seton lr and retrn?

1 Answers   IBM,


whare we can use IN AND OUT AND UNLCK opcodes?please can any body tell me in real time senario with example

2 Answers  


What is the purpose of RTVMBRD command?

1 Answers  


what opcode could be used to test an alphanumeric field for all numeric values?

1 Answers   IBM,


Hi i have one question In my srvpgm one module ADDM is there now i want to add new module i.e SUBM , please answer me IN STEPS how to write bndlanguage and how it was attach to SRVPGM

2 Answers   IBM, Satyam,


Categories