• SAP HANA Video Tutorials

SAP HANA - CTL Method


Advertisements

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 delimited by '\n'
fields delimited 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

Useful Video Courses


Video

SAPUI5 Online Training

25 Lectures 6 hours

Sanjo Thomas

Video

SAP Webi Online Training

26 Lectures 2 hours

Neha Gupta

Video

SAP Basis Online Training

30 Lectures 2.5 hours

Sumit Agarwal

Video

SAP C4C Online Training

30 Lectures 4 hours

Sumit Agarwal

Video

SAP MM Online Training

Most Popular

14 Lectures 1.5 hours

Neha Malik

Video

SAP WM Online Training

13 Lectures 1.5 hours

Neha Malik

Advertisements