DSXchange

Thanks a lot Anbu

I have an input column and its datatype is integer. the source data is in the format of '20100823'.It means 2010(Year),08(month),23(Date).

My question is if the input column is in the last four months then it is X and if not then it is Y. Here we need to consider the year also.

HariK wrote:What do you mean by Excel Data in MS Access ?

The data in MS Access wont be in table format...It will be in Excel format only.
So, i need to lad that data into a DB2 database. How ?

i want to read the excel data in MS Acess database using DS and load in to a table in DB2 using datastage v8.0.1

to delete the datafile and descriptor file belongs to a dataset which is in a unix server Orchadmin is a command line utility provided by datastage to research on data sets. search for the Orchadmin commadns to delete the dataset. other wise you can delete the dataset from dstaset management utilit...

to delete the datafile and descriptor file belongs to a dataset which is in a unix server