as you mention in thread The specified item was not found.
you want reverse engineer data store for file technology and format is FIXED
What reverse engineer do... it automatically creates column with data Type and length for u; same u can do by creating columns thru code;
I did same, as I don't found API for reverse engg data store when file format is fixed
my code snippet is
OdiColumn odiColumn = new OdiColumn(DataStore, colName);
This code is working for me
@Deepali : when u reverse engg ur delimited file, were you able to see the data ..for eg when u create interface or something.....setting all the parameters for reverse engg including column name, format etc is ok but you should mainly see the data when u use the datastore in an interface...
so did u try that? did u use the data store in the interface using studio?
Thanks for your quick reply
Also can u specify what does your filedescriptor contain?
My text file is like this
but on reverse engg i cant see any data in the data store
Also, how to specify physical length and not logical length while reverse engg?
When I reverse engg my delimited or fixed file, I am able to see the data of datastore; I used same datastore in interface
Yes , I used the data store in interface using code(sdk)
I am not doing anything manually in studio; everything is done through java code (using sdk)...but I have checked data of datastore by right clicking on it, its giving proper data
filedescriptor contains start position and num of bytes
your text file is looks like FIXED format,
my Delimited format text file:
and FIXED format text file:
10 Georges Hamilton 15/01/2001 00:00:00 11 Andrew Andersen 22/02/1999 00:00:00 12 John Galagers 20/04/2000 00:00:00 13 Jeffrey Jeferson 10/06/1988 00:00:00 20 Jennie Daumesnil 28/02/1988 00:00:00 21 Steve Barrot 24/09/1992 00:00:00 22 Mary Carlin 14/03/1995 00:00:00 30 Paul Moore 11/03/1999 00:00:00 31 Paul Edwood 18/03/2003 00:00:00 32 Megan Keegan 29/05/2001 00:00:00 40 Rodolph Bauman 29/05/2000 00:00:00 41 Stanley Fischer 12/08/2001 00:00:00 42 Brian Schmidt 25/08/1992 00:00:00 50 Anish Ishimoto 30/01/1992 00:00:00 51 Cynthia Nagata 28/02/1994 00:00:00 52 William Kudo 28/03/1993 00:00:00
if file format is Delimited we need not to worry about physical length or logical length, bcoz we are able to do reverse engg for that; which automatically set all fields
odiColumn.setLength(length); method sets both physical and logical length