When 01:02 = '02'?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting When 01:02 = '02'?
# 1  
Old 10-10-2014
When 01:02 = '02'?

Hi All,

i am working on a Production issue and i have found a code inside of a .CTL file
which is as following:

Code:
WHEN 01:02 = '02'

someone please make me understand what does it denotes.
# 2  
Old 10-10-2014
That does not look like shell script or something similar. What application is using/reading that .CTL file? If you find this out, you might be able to search in the documentation for it.
# 3  
Old 10-10-2014
The shell searches for a WHEN command.
Maybe WHEN is a program or a shell function that is called with the three arguments 01:02 = 02
# 4  
Old 10-10-2014
this control file(.ctl) is being called by .csh script.
# 5  
Old 10-10-2014
With the minimal information you give us it is impossible to give a definitive answer, but anyway:
.ctl is the default file-extension for Oracles SQL*Loader. For this product the WHEN clause specifies wheter a record is loaded or not (in this case the first 2 characters match 02).
This link points to the Oracle documentation. The WHEN clause is described there and it may help you to verify if the examined file is a control file for SQL*Loader.
Login or Register to Ask a Question

Previous Thread | Next Thread
Login or Register to Ask a Question