Reg RLGTH,DLGTH parameters

mahi_naidu · New User Joined: 29 Aug 2005 Posts: 5

Hi All,
My onsite manager had sent PS file which is having details about the Schema's and Records.In that i had seen RLGTH,DLGTH parameters.
RLGTH= 824
DLGTH= 764
KLGTH= 60
DSTRT= 60

Actually we are extracting data from IDMS to flat file.can any one clarify me regarding what length i have to give for Flat file(new) and i need ADSO material for same requirement. Please help me ASAP.

Thanks,
Naidu

Pjoe · New User Joined: 22 Jul 2005 Posts: 10

Hi,

RLGTH
-------
Schema record length,
in bytes, including
the record prefix.

DLGTH
--------
Length, in bytes, of
the data portion of
the schema record.
For variable-length
records and for
fixed-length
compressed records,
the value in this
field includes the
four-byte prefix that
indicates the stored
length of the record.

KLGTH
------
Length, in bytes, of
the prefix portion of
the schema record.

DSTRT
--------
Offset, relative to
0, of the data
portion of the schema
record from the start
of the record
(including the
prefix).

The above are the definitions from manuals.
Please let me know how you are going to access idms . As far as i know you have to call idms routines (or write idms DML statements which will be translated by idms precompiler) to fetch idms data.Also, ask your onsite manager to give the schema reports from IDMSRPTS.From this you can get the length and picture clause of each record.

Thanks,
JP