The following SQL is an example of how to convert a date such as 17041967 to 170467

create table myfile as 
( 
SELECT ACCOUNTNR, datedmcy 
INTEGER((substr(digits(datedmcy), 1, 2) CONCAT 
substr(digits(datedmcy), 3, 2) CONCAT 
substr(digits(datedmcy), 7, 2))) as datedmy
FROM account
) 
with data