Skip to Main Content

sql loader passing dynamic values issue

User_IAP38Dec 1 2022

hello, Team
I created control scripts in which the first two values(COUNTRY AND SUB_DIV) came from dynamic passing at run time and the next two values came from a dat file. I have run the control file i face issue .
Please assist me with this issue by first showing me how to pass and load data into a table.

scripts :

LOAD DATA
REPLACE
INTO TEAM_ADD_DETAILS
TRAILING NULLCOLS
(
COUNTRY POSTION(0:0) "&&1",
SUB_DIV POSTION(0:0) "&&2",
S_NUMBER POSTION(1:10) INTEGER EXTERNAL(10),
S_VALUES POSTION(11:14) INTEGER EXTERNAL(4)
)

This post has been answered by Solomon Yakobson on Dec 2 2022
Jump to Answer
Comments
Post Details
Added on Dec 1 2022
4 comments
72 views