Question { Cap Gemini, 12959 }

In a file(PS), we dont know how many records are there.
requirement is divide half n half the records n insert into
2 another files(PS).

Answer

OUTFIL FNAMES(OUT1,OUT2) SPLIT

Question { iNautix, 14028 }

sample code for read a 2nd record from last in flatfile how
can do?

Answer

Suppose file has 100 Record

1,2,3.........................100

a) Read the file and Count the number of records into a variable
Suppose CNT_VAR = 100

b) Suppose you want to read 2nd record from Last

So Set N = 2

c) Now to find the search variable compute the below

SRC_VAR = CNT_VAR - N i.e (100 - 2)

SRC_VAR = 98

d) Now Read the file to pick 98th record from top