connect to ONDEMAND;
select NAME from archive.arsag where AGID=(select AGID from archive.arsapp where NAME='${APPL}')
select table_name from all_tables where table_name like 'DO_%';
describe do_bijlagen;
select * from do_bijlagen;
set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on;
set lin 1024;
select col1 || ',' || col2 || ',' || col3 from tab1 where col2 = 'XYZ'; 
spool spool.txt;
sqlldr ${USER}/${PASSWORD} control=loader.ctl	#ORACLE
	loader.ctl: load data infile 'spool.txt' into table tab1 fields terminated by "," optionally enclosed by '"' ( col1, col2, col3 ) 
print "SELECT * FROM E harenvironment WHERE E.environmentname = '${HARVEST_PROJECT}'" | hsql.exe 2>&1
-- Commentaar