Datastage tutorial | How to use Schema files in a Sequential file stage

In this Datastage tutorial, we discuss how to use schema file in a Sequential file stage.

Sample Schema file
record {final_delim=end, delim=',', quote=none}
(
name:string [max = 255];
address:nullable string [max = 255];
value1:int32;
value2:int32;
date:date)

Schema file datatypes

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at

[renukamatham]

How can we make use of schema files if we want to load different files with different metadata..and we have 10 attributes in the schema files only we have to load 5 attributes..is that possible with schema files..pls ans both the questions

[KritarthMalviya]

This video is very helpful. Often asked in the interviews also.

[swetajha]

Informative video . These details are extremely important .

[mahendravarma]

How we apply transformation on data if needed in this flow?

[Ashimiim]

When I use view data in odbc connector, I am getting null argument:pdatasetdef error, but the sql query working fine in azure compiler fine. What could be the problem?

[poornababu]

Does schema file will support decimal datatype for last field in a columns list?

[Valdore]

Hello there, thanks for the video, I am looking for a definition of schema file partial schema only but with selection of specific columns where each row and value can have different length. There was nothing relevant to that in DS help. Thanks!

[kumaritanguturi]

Thanks for sharing info about schemafile

[optimastic]

are you going to complete datastage series or this was the last video in datastage tutorial?

[rajanidonga]

Can anyone please tell me the schema example for char datatype

[dheenadhayalan]

1. why date column didn't have ; is that not needed ?
2. Is there only these much format element available or available more ?
3. To read data we set schema file property in source is ok, why need to set the same in output ?

[abhishekreddy]

Please share more videos on DataStage tutorials madam

[stefanogreco]

why you load the schema file twice!? dont get it