DataType Conversion program

[rumu]

Hi All,

In our project we have received a high level requirement that we might need a conversion program to change data type of source file(which is coming from DB2 platform) to sqlserver campatible format.
So far ,they have a conversion program writtten in SAS in host platform now they are asking something similiar in IS if it available.

I am giving you the flow in host system:

DB2------->DB2 unload------->Flat file + Metadata File------------->conversion prorgram----->Sqlserver compatible flat file + metadata file

Could any one suggest on this topic?

Regards,

rumu

[Raghumreddy]

Hi Rumu,
No Conversion program to move the data from DB2 to SQL server. In datastage you will load both DB2 metadata and Sqlserver metadata. You may need to code some fields like date conversions.

HTH
Raghu Mule

[chulett]

Can you elaborate on what is the added value this 'conversion program' brings to the table? What kind of 'conversions' is it doing, any idea? Spelling that out will get you better (more focused) answers.

[rumu]

Hi,

We are having a meeting with host platform maintenance guys in today evening ,most likely we will get a clear picture on this requirement.After that I will surely post the that in detail.

Thanks for your support.

Rumu

[rumu]

Hi Chulett,

We got little bit of clarifications now and I am stating it here:

From DB2 source table(Business delivers data) they unload data with DB2 unload and SYSIBM tables in to MVS flat file format then from this file they convert the file to EBCDIC format using data conversion program written in SAS,for example the this conversion program convert DB2 Timestamp datatype into character format and ultimately to Sql Server compatible data type format.

Regards,

rumu