connect ebank90;

; Wichtig: alle ' in den Texten mssen nachtrglich in '' verwandelt werden oder entfernt werden;

; Wichtig: Bei Kursen alle Kurse ohne Eurostatus rauslschen;


select blz || ',''' || name1 || ''',''' || plz || ''',''' || ort || ''',''' || name2 || ''',''' || suche1 || ''','''
|| suche2 || ''',''' || suche3 || ''',''' || PRUEFPARAM1 || ''',''' || PRUEFPARAM2 || ''','''
|| PRUEFPARAM3 || ''',''' || PRUEFPARAM4 || ''',''' || PRUEFPARAM5 || ''',sysdate,''SYSADM''' from eb_blz order by blz;

select whg_id || ',''' || whg_code || ''',''' || whg_bez || ''',''' || whg_datum || ''',''' || historisch || ''',''N'',''N'',''N'',sysdate,''SYSADM''' from eb_whg order by whg_id;

select whg_id || ',''' || whg_code || ''',''' || whg_bez || ''',TO_DATE(''' || whg_datum || ''',''YYYY-MM-DD''),''' || historisch || ''',''N'',''N'',''N'',sysdate,''SYSADM''' from eb_whg order by whg_id;

select whg_id || ',''' || whg_code || ''',''' || whg_bez || ''',CONVERT( DATETIME, ''' || whg_datum || ''',20 ),''' || historisch || ''',''N'',''N'',''N'',sysdate,''SYSADM''' from eb_whg order by whg_id;


select land_id || ',''' || laender_code || ''',''' || laender_bez || ''',''' || historisch || ''',sysdate,''SYSADM''' from eb_land order by land_id;

select land_id || ',' || whg_id from eb_land_whg order by land_id;

select whg_id || ',' || eurostatus || ',' || abhol_id || ',sysdate,''' || WHG_ART || ''',''' || ATS100ANK || ''','''
|| ANKAUF || ''',''' || STUECKELUNG || ''',''' || KURSENTWICKLUNG || ''',''' || KURS_DATUM || ''','''
 || VERKAUF || ''',''' || ATS100VRK || ''''  from eb_whg_notierung order by whg_id;


select whg_id || ',' || eurostatus || ',' || abhol_id || ',sysdate,''' || WHG_ART || ''',''' || ATS100ANK || ''','''
|| ANKAUF || ''',''' || STUECKELUNG || ''',''' || KURSENTWICKLUNG || ''',TO_DATE(''' || KURS_DATUM || ''',''YYYY-MM-DD''),'''
 || VERKAUF || ''',''' || ATS100VRK || ''''  from eb_whg_notierung order by whg_id;

select whg_id || ',' || eurostatus || ',' || abhol_id || ',sysdate,''' || WHG_ART || ''',''' || ATS100ANK || ''','''
|| ANKAUF || ''',''' || STUECKELUNG || ''',''' || KURSENTWICKLUNG || ''',CONVERT( DATETIME,''' || KURS_DATUM || ''',20 ),'''
 || VERKAUF || ''',''' || ATS100VRK || ''''  from eb_whg_notierung order by whg_id;



;Test

;
select blz || ',#' || name1 || '#,#' || plz || '#,#' || ort || '#,#' || name2 || '#,#' || suche1 || '#,#'
|| suche2 || '#,#' || suche3 || '#,#' || PRUEFPARAM1 || '#,#' || PRUEFPARAM2 || '#,#'
|| PRUEFPARAM3 || '#,#' || PRUEFPARAM4 || '#,#' || PRUEFPARAM5 || '#,SYSDATE,#SYSADM#' from eb_blz order by blz;
;

select whg_id || ',#' || whg_code || '#,#' || whg_bez || '#,#' || whg_datum || '#,#' || historisch || '#,#N#,#N#,#N#,SYSDATE,#SYSADM#' from eb_whg order by whg_id;

select land_id || ',#' || laender_code || '#,#' || laender_bez || '#,#' || historisch || '#,SYSDATE,#SYSADM#' from eb_land order by land_id;


