GCStruct_Vermittler.iqd 448 B

123456789101112131415161718192021
  1. COGNOS QUERY
  2. STRUCTURE,1,1
  3. DATABASE,GCStruct_Vermittler
  4. DATASOURCENAME,D:\Gaps\Portal\System\IQD\NW\GCStruct_Vermittler.imr
  5. TITLE,GCStruct_Vermittler.imr
  6. BEGIN SQL
  7. select T1."KONTO_NR" as c1,
  8. T1."EBENE1" as c2,
  9. T1."EBENE2" as c3,
  10. T1."EBENE1" as c4,
  11. T1."EBENE2" as c5
  12. from "Vermittler.csv" T1
  13. where (T1."EBENE1" <> 'nicht benötigt')
  14. END SQL
  15. COLUMN,0,Konto Nr
  16. COLUMN,1,Ebene1
  17. COLUMN,2,Ebene2
  18. COLUMN,3,Birth Place
  19. COLUMN,4,Bank Name