set organization;

table ti IN 'iODBC'
  'Driver={Microsoft ODBC for Oracle};' &
  'CONNECTSTRING=prod;UID=MyName;PWD=MyPassword;'
  'SELECT organization_name' 
  'FROM apps.org_organization_definitions;':
  organization<-[ORGANIZATION_NAME];

printf{o in organization} "Organization %s\n", o;