Stack Overflow
Stack Overflow

Questions tagged [ctl]

83 questions
0
votes
0 answers

Decrypting a .gpg file with python

I try to decrypt a gpg file using this command : gpg --batch --passphrase=*** --output file.csv --decrypt file.gpg but it doesn't work, i can't read the content. And would anyone know how to convert a CTL file to csv or text? can someone help me ?
LilyAZ
  • 133
  • 3
  • 10
0
votes
1 answer

error when importing with a ctl file sqlldr oracle

I was trying to import data from an oracle database table using a ctl file. Unfortunately, it doesn't work due to a syntax error and, for my efforts, I can't understand why. SQL code: sqlldr USERID=user/password, CONTROL=C:\wkt_building001.ctl,…
speranza493
  • 21
  • 4
0
votes
1 answer

SQLLDR and .ctl files

I have a ddl script to create some tables but the data is in .ctl files and I never use it before. I did some researches but I didn't quite understand how to use SQLLDR. How it works? Can I use some other way to execute the .ctl file? I'm just using…
Reinaldo Peres
  • 303
  • 2
  • 5
  • 14
0
votes
1 answer

Desaturating Colours in CTL

Looking to create a CTL with a colour transform that is de-saturates a pair of opposing colours. My example below works: but not as expected: __DEVICE__ float3 squeeze_GM(float percentage, float R, float G, float B) { float rOut = R -…
hdcdigi
  • 75
  • 7
0
votes
1 answer

Replace $ char with zero for data field using SQLLoader

A text file contains data like below. 041522$$$$$$$$$NAPTTALIE REVERE @1621500025 OLD ST FUNNRHILL MA1530 273 …
Parthee
  • 5
  • 3
0
votes
0 answers

Unable to verifiy TCTL properties?

i built this template in UPPAAL 4.1 version. We can see in fig1, there exist a single path where agent can perform ReflexProcessing, but when i write given property E<> not (MonitorAgent.ReflexProcessing) Verifier satisfied it . it shoud not be…
waqas
  • 1
0
votes
3 answers

IS Oracle 7 DB Files are compatible with later version ? Oracle 9 or 10G?

I have got dbf and ctl file of Oracle 7 and does not have installation media of Oracle 7. Is it possible to restore these dbf and ctl file to later versions [Oracle 9i or 10G] ? Thank You Hardik
Hardik Shah
  • 21
  • 2
0
votes
1 answer

Is "true U Φ" a valid Computation Tree Logic formula?

I'm taking a course on computer-aided verification, and we are just starting to cover Computational Tree Logic after covering Linear Temporal Logic. My lecture has said that ◇Φ ≡ "true U Φ" is valid CTL, whereas □Φ is not valid CTL. I agree with the…
Joe Tebbett
  • 3
  • 1
  • 2
0
votes
1 answer

How do I use SQL Loader to load data containing line breaks to a table?

I have a data file, a csv. One record from the data file looks like this: 195268,"Organization",Active,,"This is a long description. This is a long description. This is a long description. This is a long description. This is a long description. This…
KinsDotNet
  • 1,500
  • 5
  • 25
  • 53
0
votes
0 answers

SQL Loader - no terminator found after TERMINATED and ENCLOSED field - dirty data

I am getting a "no terminator found after TERMINATED and ENCLOSED field" error in the Oracle SQL Loader utility in this case there are quotes also into a field here my CTL OPTIONS (SKIP=1) LOAD DATA TRUNCATE INTO TABLE TABLE_NAME FIELDS TERMINATED…
Gio Italy
  • 91
  • 1
  • 6
0
votes
1 answer

Is the following formula in CTL welformed?

The formula is the following: AF A[(p U q) --> (r U q)] The answer is no, but why? Said, not a valid formula. The subformula starting with the innermost A does not conform to the type A (x U y). Is not the path quantifier 'A' for the entire…
ProfomStat
  • 7
  • 3
0
votes
1 answer

How to delete null line in file using sqlldr, ctl

Let me know how to delete the null line using sqlldr, ctl. And I wanna know how to remove the last two line of files. There are null lines in tail, that is the last 1~2 line. Plus I cannot know the last line number. wait to reply
Jewel
  • 1
  • 1
0
votes
1 answer

Oracle SQLLDR - Load Record with Invalid Date, Replace Invalid Date with Null

There are records in my source text file with invalid date values. The invalid date values are inconsistent in format due to manual entry. I still want to load all of these records, but I want to replace the invalid date value with a null. Please…
Beemer12
  • 1
  • 2
0
votes
0 answers

Teradata 15: how to FAST LOAD xlsx?

I'm trying to load data to Teradata directly from xlsx with FAST LOAD. Receiving the empty table and following error in CTL log: **** 16:09:28 Number of recs/msg: 10 **** 16:09:28 Starting to send to RDBMS with record 1 **** 16:09:28 Error on piom…
Grigory P
  • 191
  • 1
  • 8
  • 24
0
votes
0 answers

sql loader load into multiple tables from single CSV file

The contents of the CSV file is as shown: LOAD DATE,30-Nov-15 STORE,MANAGER NAME,PHONE Number 519900,STEVEN FRENCH,905-271-3644 520300,IAN MCGAUGHEY,519-672-9986 512400,,416-665-4657 512900,RAKESH PRASAD,905-672-6301 I want to add…
Delwin Noronha
  • 1
  • 1
1 2 3
4
5 6