Questions tagged [ctl]
83 questions
0
votes
1 answer
Use parameters with CTL
I am using a CTL file to load data stored in a file to a specific table in my Oracle database.
Currently, I launch the loader file using the following command line:
sqlldr user/pwd@db data=my_data_file control=my_loader.ctl
I would like to know if…
Hal
- 591
- 4
- 10
- 28
0
votes
1 answer
How to skip empty columns in csv file while loading into sql using .ctl file
My CSV file look like this
111,,Allen,2000,,30
222,,John,3000,,40
333,,Miller,4000,,50
333,,King,5000,,50
Some times empty columns may come in different positions,
Can we suggest anything to ctl files ,such that it can skip only empty columns with…
Srinivas
- 147
- 1
- 14
0
votes
1 answer
NuSMV Realtime CTL
I'm using NuSMV and i'm trying to write a Real Time CTL property.
I would like to know if there is a way to set the steps from a state, like:
((s.state = on) ABG (0..5 s.state = off))
Is read as: if (s.state=on) is true, from this state and for…
Desmond
- 9
- 1
- 5
0
votes
2 answers
How to use the OR condition in when clause of SQL Loader control file
I am trying to use the OR condition in when clause in control file, This this my code in control file :
load data
INFILE 'router.txt'
INTO TABLE ROUTER_ATTLAS_TABLENAME
APPEND
**WHEN ((1) = 'J' or (1) = 'D2' or (1) = 'vJ' or (1) = 'VJ'…
chaya
- 423
- 3
- 11
- 19
0
votes
0 answers
IIS central certificate store. How to bind CTL?
Does anyone know if you can bind a CTL to a website if it is using the central certificate store?
Normally I'd use the netsh http command to bind a CTL, but it doesn't seem to accept the sslctlidentifier switch
user6438601
0
votes
1 answer
Getting Compile time error on this code, help me out
I am getting compile time error for this code.
Not getting what it is about, please help.
This is some practice question on codechef.
Tried to find on web but unable to find similar answers.
The code is-
import java.util.*;
class missp
{
public…
karan_13
- 23
- 5
0
votes
1 answer
sqlldr : ORA-00911: invalid character
i want to import csv file. my script is :
@echo off
set numid=2015092510524361378197540100
sqlldr USER@db/PSW data=csv\2015092510524361378197540100.csv control=ctl\control.ctl log=log\2015092510524361378197540100.log bad=bad\id.bad
pause
my table…
flyingbird013
- 446
- 2
- 12
- 28
0
votes
1 answer
No data stored after Import CSV to oracle database
i want to import csv file to oracle Database.
my csv look like this :
Table A : sometimes containing 2 lines or 3 lines or empty. i want to import start Table B. so my control.ctl is :
echo OPTIONS (SKIP=5, errors=12000)
LOAD DATA
…
flyingbird013
- 446
- 2
- 12
- 28
0
votes
1 answer
Check equivalent CTL formulas
I'm doing an CTL exercise, I'm trying to check if the following formulas are equivalent or not. But I'm not sure if I'm doing right.
EF (p or q) = EF(p) or EF(q) ?
AF(p or q) = AF(p) or AF(q) ?
A(p U ( A(q U r) )) = A(A(p U q) U r) ?
Firt…
macco
- 21
- 1
- 11
0
votes
1 answer
How to end the load infile process in oracle
I am trying load the data using in ctl file , But syntax error I am getting ,that is :SQL*Loader-350: Syntax error at line 15.
Expecting "," or ")", found keyword by.
COS "TRUNC(:COS/32)",TERMINATED BY WHITESPACE
following code is my try.
load…
Chaya
- 95
- 3
- 12
0
votes
3 answers
Manipulating Data and Loading via SQLLDR
Can someone please help me.
I need to load data from a .dat file into a Table.
.DAT file has Col1, Col2, Col3
Table have Col1, Col4
What I want is
Table.Col4 = DAT File Col2*Col3
How can I achieve this via SQLLDR and CTL file.
Note Columns in…
ShobhitSaxena
- 73
- 5
- 12
0
votes
1 answer
import from oracle to mysql by using CTL
how can i import data from an oracle database to a mysql database by using CTL file (generate with Toad for oracle)?
Thank in advance
Andrea
Andrea
0
votes
1 answer
Why did SQL*Loader load 808594481 when using the INTEGER data-type?
I was loading data using SQL*Loader and when making the control file I used the table definition and accidentally left the INTEGER data type on the "version" line.
And in the "version" field (data type integer) it inserted the value 808594481.
I'm…
Robert Clayton
- 3
- 3
0
votes
1 answer
Set a specific cell value to a column (CTL)
I have created a CTL file that will read the data inside a CSV file. It loads the data from the CSV to the table in the database. I just want to ask if it is possible to set a table column to a specific cell on CSV file when loading data using…
user3462803
- 170
- 1
- 2
- 10
0
votes
1 answer
How can I request a client certificate only from a particular CA
Is it possible to request client certificates issued only by a particular CA (Certificate Authority)?
The site is using IIS 7.5, and we have client certificates assigned to users following this article -…
rgeorg
- 71
- 9