what is flatfile?what is the use of this file?where we can
use usualy?what is the advantage of this?
Answers were Sorted based on User's Feedback
Answer / prasanth
Flat file is used to send data from one system to another.
I.e You can read the data from flat file and map the flat
file date to database files. Mainly used in EDI references.
And also you can use SUBSTR to extract specific length of
string usig SQL from flat file.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / syam
Flat File = Fixied Length Record File. More than One record
format with different field length. Using in s/36 and s/38
machine on RPG II and COBOL. Diadvsntage you can't use SQL
statement on this file.
| Is This Answer Correct ? | 4 Yes | 4 No |
why we sometimes use same file name in FILE and TOFILE in OVRDBF and sometimes different??please tell
How can you check the existence of object in a system?
what is multijoin logical file? what are the keywords available in joinlogical file? what are the mandatary keywords for joinlogical file? explai the keywords?
i have two pfs it contains "Status" fields in the same name "status in both the pf's...But i used the same name in display file...when i enter a status thru disp file it willbe added to pf1...so i want to rename "Staus " field in pf2 through program...............wat will do..give coding?
what does dfu program you to do on a record?
What is data structure in as400? What is the use of data structure?
what are the types of errors available in rpg IV or 400.Like decimal data error,sessional error or device error etc...means important error occurings,ie to find out suddenly???pls give answ if u know?
How can we change the uppercase to Lowercase in RPG?
What is primary file? How many primary file can be declared in a RPG program?
List and explain the different type of data structures?
how would you design the process for a nightly, high volume check producing process that needs to select only records that are flagged to be processed?
Define an Interactive Job?