How to insert more than one record to a pf at a time?(Bulk
insert to a pf)

Answer Posted / subba reddy

more than one record to a pf at a time

1. Using SQL we can runa query
insert into table1 values('a','b','c'),('x','y','z')

2. Using DBU (Database utility )also we can insert records

But using STRDFU we can insert one record at a time

correct me if i am wrong.....

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to index LF by relative record no (RRN)

3016


What is the interactive job? What is the batch job? How to change the batch job to interactive job?

786


When we create a pf and did not fill up maint parameter, then by default which access path will the system take & why?

760


What is the difference between access path and open data path?

793


How to change the batch job to interactive job?

720






What is the batch job?

745


How to read a pf in reverse(from last record to first) using cl?

781


Suppose I have a pf,it contains 5 members,how to access particular member data from logical file ?and what is the use of member in pf?

806


How to retrieve a physical file after deleting that?

741


What is the primary file?

777


How to find the list of source physical files in a library?

803


Suppose I have a pf, it contains 5 members, how to access particular member data from logical file? What is the use of member in pf?

785


What is open data path?

733


What is the interactive job?

755


What is the purpose of the chain and setll and setgt?

779