
SELECT ssn, title, char(first_name,10) as FIRSTNAME, char(last_name,10) as LASTNAME FROM ITSO.CUSTOMER;

SELECT * FROM ITSO.ACCOUNT_CUSTOMER;

SELECT * FROM ITSO.ACCOUNT;

SELECT char(id,14) as ID, char(trans_type,8) as TYPE, trans_time as TIME, account_id, amount FROM ITSO.TRANSACT;
