-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqlloader.ctrl
41 lines (36 loc) · 992 Bytes
/
sqlloader.ctrl
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
-----------------------------------------------------------------------------------------------------
--Author Date Version
--Lokesh Gurram 21-Aug-2022 1.0
--Description:
--------------
--This script is used to set the environmental variables .
-----------------------------------------------------------------------------------------------------
-------------------------------------------------------------------
--Copyright Amazon.com, Inc. or its affiliates. All Rights Reserved.
--SPDX-License-Identifier: MIT-0
-------------------------------------------------------------------
OPTIONS (DIRECT=TRUE, ERRORS=50, rows=100000)
load data into table t_object_sanity
append
fields terminated by "`^!"
TRAILING NULLCOLS
(
f_owner,
f_object_name,
f_sub_obj_owner,
f_sub_object_name,
f_attribute_name,
f_attribute_type,
f_position_id,
f_count,
f_min_value,
f_max_value,
f_increment_by,
f_cycle_flag,
f_cache_size,
f_last_number,
f_status,
f_catagory_type,
f_run_server,
f_text
)