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 we sometimes use same file name in file and tofile in ovrdbf and sometimes different?

0 Answers  


What process the command SBMRJEJOB does?

1 Answers  


what would be the effect on the field where reverse image, underline and highlight display attributes were active?

1 Answers   IBM,


what is *inzsr used for?

1 Answers   IBM,


How do I release jobs in queue and change a job destination to a different printer. I know wrkjobq but I have not worked with As/400 for a while,so_can someone help me?

2 Answers  






what is a program described file in rpg?

1 Answers   IBM,


What is the difference between regular logical file and join logical file?

1 Answers  


it is possible declare variable values as variable using cl ? any cl command is there to declare values as variable

2 Answers  


What is the purpose of reorganizing the physical file i.e. , RGZPFM?

1 Answers  


Define an Interactive Job?

1 Answers  


How many types of jobs?what is difference between interactive and batch and submited jobs?

3 Answers   IBM,


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

1 Answers   IBM,


Categories