Search Results

Search: Posts Made By: cero
7,664
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
4,929
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,341
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....
4,079
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...
12,659
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).
12,659
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...
1,262
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...
8,464
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...
8,464
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,065
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...
1,626
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,323
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...
694
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,467
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...
2,566
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,160
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...
5,706
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
4,307
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
3,101
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...
10,493
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,049
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
7,426
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,105
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,105
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
6,203
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 10:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy