function that returns the datatype

[shyam_etl]

Is there a function in datastage that returns the datype (sqltype) of a field value as interpreted by the source during extraction?

Cheers,
Shyam

[vmcburney]

At this point in time you need to define your column names and data types when you develop the job. If your source is a database table then the expectation is the metadata on the table does not change, if it does change the DataStage job needs to be changed.

If your source is a text file or your database field is free text you can use functions and routines to examine the contents of each column to see if they match the anticipated data type. You can reject or default rows that have invalid text.

[ray.wurlod]

Is there a function in datastage that returns the datype (sqltype) of a field value as interpreted by the source during extraction?

Cheers,
Shyam

No.

DataStage is driven by the metadata. Therefore metadata need to be constant at run time.

The information could be "hacked" from the design information in the Repository at run time, but this approach is fraught with danger, as it uses undocumented structures.

There are no supplied interfaces for extracting this information.