Is there a function used to convert VSAM dates (CCYYMMDD) to SQL date format within DataMigrator, or will it convert automatically? Thank you!

VSAM is not a format of it's own, it should be either an A8YYMD or an I8YYMD or just YYMD (in the FOCUS master). It should convert as such on it's own.

Mike, although there isn't a function specific to converting VSAM dates to SQL dates, there are LOTS of date functions so I'm sure there is something that will fit your needs. First off, how are the VSAM and SQL dates defined in their corresponding synonyms?

Thanks for the reply.

VSAM is PIC X(8) format CCYYMMDD
Default format is dd/mm/yyyy for SQL Server.

I'm sorry Mike. I guess I wasn't specific enough. How is each field defined in its associated Data Migrator synonym?

A PIC X(8) in COBOL is an A8 in FOCUS. Has a FOCUS/WEBFOCUS master ever been created for this file?

A co worker has gotten a solution from IBI for DB2, they are switching from DB2 to SQL, but the SQL tables are not yet created, this works for DB2.
HDATE( HINPUT(8, EDIT(BYB_BH, '$99999999'), 8, 'HYYMD'), 'YYMD')