I need to insert a record in a file using STRSQL containing the some field value

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.

Question Posted / sulbha bakshi

0 Answers
2746 Views
CSC, I also Faced
E-Mail Answers

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

Post New Answer

More IBM AS400 AllOther Interview Questions

what is jurnal?what is the use of theis?what is difference between commitment control and jurnaling?

2 Answers

where exactly we can use OPNQRYF ?

3 Answers TCS,

Can anyone answer me when we will go for LF without key fields

4 Answers HCL,

How to know message id (errorid) in msgfile when error is occurred on screen ? WRKMSF will display all error id but i want to know error id based on error msg only?

1 Answers IBM, Ignis Technologies, SSR,

how do you pass parameters in cl?

1 Answers IBM,

how to see the error messages for each command in cl?

2 Answers CGI,

How to add 99 menu (page down) option in menu creation..

0 Answers

define the purpose of the *bcat function?

1 Answers IBM,

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

1 Answers

Any change in service program we write binder language to allow signature change,What is the maximum number of signature change allowed in RPGLE?