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 |
Pgm A is invoked through HTTP. It is in Activtion group QILE. Pgm A calls Pgm B and Pgm C. Pgm B is in activation group TEMPACTGRP. Pgm A ends in error. Pgm A is called again. But it gives an error that TEMPACTGRP still exists and files are present in QTEMP. What is the cause and how will u fix?
what are the important factors in error message subfile ?
How are the objects stored on AS/400?
In there is 100 no. of recordsin PF, if i delete all the records. Then what is the Size of the PF?
Hi, can you plz tell me ...syntax for GET command in FTP & SFTP is same or different???
1) Suppose we call a pgm from CL, how come AS400 system knows whether the called pgm is to be interactive one or batch one? 2)How many members can exist in a PF?
how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concept?
Why do you use Keep and Assume Keywords.
What are the valid user defined data area types?
What is a Join Logical File, Can it be used for Update ?
What would be the output of the variable result? D RESULT S 5S O INZ(00011) C EVAL RESULT = %TRIM(RESULT) Please give me the correct answer for this A.0001 b.compile time error c.11 d.Runtime error
how can u check no of records in a file?