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 |
how do you detect unused spool storage?
I want to run ls *.csv (sftp command) from CL Program... Can u plz tell me when SFTP command will start running? i.e.which command should I use in CL Program to run ls command?
Can anyone answer me when we will go for LF without key fields
What is class of service ?
difference between sflrcdnbr and sflnxtchg?
How to know the number of records in a pf through clp program?
What is left outer join?
how a varible can be passed to a subfile...accnt1 contain data in a data area..ie Daccnt1 uds,Daccnt2 3 overlay(accnt1:1), DNo 4 overlay(accnt1:4)..we want to transfer this dataarea value from acnt0001 to a subfile..that means to enter each record we have to incriment account no,, i normal window we can do move accnt1 account_no eval account_no=accnt1 eval no=no+1 exfmt usr_account how it possible with Subfile????????.Please do answer? (Thank you for all your answers dear friends!!)
What is the purpose of FRCDTA (Force Data) keyword?
What is the difference between physical file and logical file?
what does check opcode is used?
write a pgm to read p.f using cl pgm?