When I open a flat file from a S/36, the grid on Delphi
only shows me all data in just one field. Is there some
way to allow Delphi to access all the fields?

1) Delphi/400 supports data management functions for S/36 files
(on AS/400).

2) A S/36 sequential file is composed of one field and a S/36
keyed file is composed with two fields (one for key and one for data).
This is why the customer sees only one field in the grid when browsing
the m S/36 flat file.

3) OS/400 allows the redefinition of S/36 file description of a so
programs such as RPG or Delphi/400 can manipulate data in several fields.

4) To redefine the description of a S/36 file :

4.1) Type the AS/400 command GO IDDU,
4.2) Select option 2 to create a Data Dictionnary (this is a library in
which all redefinitions are saved). If the dictionary already exists, this
option is not necessary,
4.3) Select option 1 :
4.3.1) : Define all fields,
4.3.2) : Define one format : Select the created fields for the format,
4.3.3) : Define one IDDU file : Select the created format,
4.4) Select option 70 (associated commands) :
4.4.1) Selection option 5 LNKDTADFN :

>   S36LIB

Now the S/36 file has an external description. The Delphi/400 program
will be able to show the separate fields in the grid.

5) SQL/400 does will not work with the redefinition.

---

Per maggiori informazioni rivolgetevi a Consist (199.445.900 - 045/565.168).

---

Componenti e utility Delphi       Home page      Una visita a CONSIST

---