Total Answers and Comments: 4
Last Update: January 19, 2007 Asked by: mla
No best answer available. Please pick the good answer available or submit your answer.
August 31, 2006 06:47:20 #1
bhanu
RE: Whats the best way in a AI GRAPH to read the heade... we can use run compononent in the parameters tab for commandline give unix AWK command for skipping the specified record num
awk '{if(NR!=1 && NR!=2) print $0}' this we can use for first record
or else we can use onemore component read seperated value in the parameters tab u can specify skipheader as true
This is upto my knowledge
Thanks
Bhanu
Is this answer useful? Yes | No
September 22, 2006 17:22:28 #2
dontbuckme
Member Since: September 2006 Contribution: 8
RE: Whats the best way in a AI GRAPH to read the heade... If the input dml has record type, simply do FBE will do.
If the input dml has no record type, but with "n" as End of Record, do a wc -l up front and pass the result back to the graph will do the trick.
Otherwise, you need to assign a sequence number (next_in_sequence) using Reformat, also capture the log port for the record count. Then:
Header: sequence number=1
Do a join with the source data (say in0) and from the record count capture from the previous Reformat log port (say, in1).
Trailer: in0.sequencenumber=in1.reccount
Is this answer useful? Yes | No
December 22, 2006 02:06:53 #3
mukund
RE: Whats the best way in a AI GRAPH to read the heade... guys,
to read header ,detail,trailer from input file separately ,do validatins for these,
use conditional dml,where we can separate detail from header and trailer
for validations u have to use reformat with count :3(out0:header,Out1:detail,Out2:trailer.)
if any doubts further let me know
cheers
mukund
Is this answer useful? Yes | No
Go To Top