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 |
1.what are the builtin funtions in cl pgg?Explain with example 2.what is meant by left outer join?where we can use this?
how to get no of records in file in rpg with out cl cmd
What is the purpose of SFLFOLD and SFLDROP keywords?
what are the three line types in rlu ?
when do you explicitly open files and close files in an rpg program?
How to convert a spool file to PDF file in AS400?
what are the different commands used in rlu ?
Can an indexed file be accessed in arrival seQuence in RPG program ?
define the purpose/use for sflrna?
What is Sub-System?
why do we use readc? What is sflnxtchg?
Define what the operation will do, the purpose of the result field and the purpose of *IN66? HI LO EQ C CALL 'CVTDAT' DTPRM 66