English 中文(简体)
SAP HANA Tutorial

SAP HANA Introduction

SAP HANA Modeling

SAP HANA Reporting

SAP HANA Security

SAP HANA Data Replication

SAP HANA Monitoring

SAP HANA SQL

SAP HANA Useful Resources

Selected Reading

SAP HANA - CTL Method
  • 时间:2024-06-22

SAP HANA - CTL Method


Previous Page Next Page  

Open SAP HANA Studio → Create Schema under Catalog tab. <Start here>

Prepare the data and save it to csv format. Now create file with “ctl” extension with following syntax −

---------------------------------------
import data into table Schema."Table name"
from  file.csv 
records depmited by  
 
fields depmited by  , 
Optionally enclosed by  " 
error log  table.err 
-----------------------------------------

Transfer this “ctl” file to the FTP and execute this file to import the data −

import from ‘table.ctl’

Check data in table by going to HANA Studio → Catalog → Schema → Tables → View Content

Advertisements