Search Results

Search: Posts Made By: cero
10,299
Posted By cero
Hi, the SQL*Loader-tool is designed to do that,...
Hi,
the SQL*Loader-tool is designed to do that, no script needed. You do not say what database version you use, so I'll point you to the 10g documentation for loading XML-files into tables:
29...
Forum: What is on Your Mind? 08-28-2018
9,321
Posted By cero
One place I hang around as often as I do here is...
One place I hang around as often as I do here is TEK-TIPS.com (https://www.tek-tips.com). I was most active there in the database parts there but it became very quite lately.
My reason to register...
1,833
Posted By cero
The AND operator && in the form of command1 &&...
The AND operator && in the form of command1 && command2 says that command2 is executed only if command1 returns an exit status of zero. (( counter++ )) will not return zero so continue is not hit....
5,878
Posted By cero
There is a utility called cut and I would not use...
There is a utility called cut and I would not use this as the delimiter of a here document.
Does the closing line of the here document hold only the word cut, without any whitespaces or other...
15,205
Posted By cero
You'll have to use option 1 to get rid of the...
You'll have to use option 1 to get rid of the spaces (that is what I ment with fixed width columns).
15,205
Posted By cero
Hi, I see 2 problems with your query: 1) When...
Hi,
I see 2 problems with your query:
1) When you define an alias for a column either use double quotes to make it case sensitive or do not use quotes at all.
2) You try to concatenate 2 columns...
2,173
Posted By cero
You can't see the processes because they finished...
You can't see the processes because they finished when you issued ps:
[3] Exit 1 test
My c knowledge is maybe a bit rusted, but you keep using the cpu all the time with your...
9,917
Posted By cero
Hi Don, thanks for pointing out that my post...
Hi Don,
thanks for pointing out that my post was not that clear - I did not suggest to copy the Linux magic file to AIX (and am nearly sure that it would not work), but my post can be interpreted...
9,917
Posted By cero
Hi, the file command uses a file called...
Hi,

the file command uses a file called magic to identify the file type. According to the POSIX man page the -m flag can be used to specify an own magic file and I think the AIX file command...
1,492
Posted By cero
Another important information is how the scripts...
Another important information is how the scripts are started.
Would it be possible to have a wrapper script to start those 3 scripts in background and use the wait command to wait for all of them to...
2,148
Posted By cero
Your requirement is a bit confusing for me....
Your requirement is a bit confusing for me. That's why I'd like to take one step back to evaluate possible solutions.
You say you need the results of sqlscript1 in sqlscript2.
In order to offer...
1,988
Posted By cero
For a task like that the file descriptors...
For a task like that the file descriptors shouldn't be a problem.
I do not see why a heredoc is needed, sqlplus can process a sql-commandfile if told so:
$ a=$(sqlplus -s /nolog @a.sql)
$ echo...
1,303
Posted By cero
Hi, test -s checks if the file exists and...
Hi,

test -s checks if the file exists and its size is greater than zero.
So if the file exists but is empty it will be removed.
3,826
Posted By cero
Hi, by piping the output of find/awk/grep to...
Hi,

by piping the output of find/awk/grep to the loop a subshell is created, thats why the variable in the parent shell is unchanged.
Avoid piping to the loop, bash for example offers process...
4,307
Posted By cero
You could use the sort command on the spool file,...
You could use the sort command on the spool file, but there will be problems for example with headings.
The order by clause is the cleanest and easiest way and was designed to do what you ask for.
1,781
Posted By cero
The pipe feeding the loop does nothing useful...
The pipe feeding the loop does nothing useful because the filenames are picked by matching the pattern you give after in with the content of your current directory.
Arguments for commands and...
6,944
Posted By cero
The closing tag of the here document is missing: ...
The closing tag of the here document is missing:
/u01/app/oracle/product/12.1.0.2/dbhome_1/bin/sqlplus -s darwin_ext@SRCDBCA/Da3w1n\#E5t << EOF
@proc.sql
EOF
Forum: Red Hat 08-04-2017
6,144
Posted By cero
Hi, What does the following command on the...
Hi,
What does the following command on the storage server reveal?
cellcli -e list alerthistory
Forum: UNIX and Linux Applications 07-20-2017
5,957
Posted By cero
Your goal is to loop through all tables in schema...
Your goal is to loop through all tables in schema HR, count the records and display the results? The reason your procedure shows the error is because tab_var and not the content of the variable with...
13,152
Posted By cero
The <FF><FE> at the start is a BOM (Byte Order...
The <FF><FE> at the start is a BOM (Byte Order Mark), saying that the file is an UTF16-Little-Endian text file.
To "keep the file binary", which I read as "keep the encoding as it is", simply pipe...
1,490
Posted By cero
I think the script is not working because the...
I think the script is not working because the opening doublequotes are missing when you assign the command to the variable.
#!/bin/ksh

#Batchdate=20170616
#retn=$2
freq='W'
instance=DPHK0...
Forum: Red Hat 04-19-2017
13,058
Posted By cero
Hi, the construct $(command) is called...
Hi,

the construct $(command) is called command substitution and evaluates to the output of command and you use it correctly for the assignment of the variables DAY, MONTH and YEAR. You do not want...
1,504
Posted By cero
Basically there is no need to prefix the script...
Basically there is no need to prefix the script with a shell - if you leave it out, your current shell will be used. But different shells use different syntax. So naming which shell to use ensures...
1,504
Posted By cero
You prefix sh when you want a specific shell to...
You prefix sh when you want a specific shell to be used to interpret the script and not the current shell of the current user, no matter if interactive or as crontab entry.
Forum: HP-UX 01-20-2017
7,912
Posted By cero
So now you're in the situation Robin (rbatte1)...
So now you're in the situation Robin (rbatte1) warned you about.
What have you tried so far to find the cause? Did you see any diagnostic message when you ran the script? What was the return code?...
Showing results 1 to 25 of 454

 
All times are GMT -4. The time now is 07:35 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy