SQL Loader in Oracle Applications…
Step1:create a Sqlloader file.(the ctl file)
Step2:Create a executable with Execution method type as SQLLOADER
Step3:move .ctl file to executable application top bin folder
For example for GL it is GL_TOP/bin
Step4.Create a program for the executable with paramertes like file name..
Step6:Attach the concurrent program to a request group and the run the program..
The one point that comes in mind how to acess the concurrent program parameters in sqlloader..it is using %1
LOAD DATA
INFILE '%1'
BADFILE '%1.bad'
DISCARDFILE '%1.dis'
TRUNCATE
INTO TABLE GL_DOW_TRANS
(
VOTE POSITION(01:16) INTEGER EXTERNAL,
AMOUNT POSITION(18:30) INTEGER EXTERNAL,
PERIOD POSITION(35:38) INTEGER EXTERNAL
)
Thursday, January 22, 2009
Subscribe to:
Post Comments (Atom)
1 comments:
Hi Murthy,
If we have to pass more than one parameter then we would have to concatenate it and then pass it. Instead of that we can call a concurrent program of host executable which would then call the sql loader script.
Post a Comment