Trivial(Essential) Question

[Gokul]

Hi

Following are the queries related to the Sequential Stage which popped up
during the debugging of a code

1.During debugging a code,we realised that the number specified in the Display column was large then the number specified in the length column of the data grid of the Sequential Stage.
Due to this the Load of file to the Database failed giving Large value error.

What is the difference between the Length column and the Display column of the Data grid and if there is a mismatch which value the datastage will take.



2. Difference in the SQL type and the Data element column of the Data grid?
- Does SQL Type and Data element have inter-dependence
- Do there setting affect the way data is written to the file.

Thanks for the help i always receive on this site,
Gokul

[ArndW]

When data is written to a sequential file with fixed width the Display width value will override the length attribute; if you are writing to a table then the length is used. The Display affects only the presentation layer (and for historical reasons the fixed width of a sequential file is considered that!).

The data element is not used outside of the datastage engine - all data types come from the SQL type.