Search Results

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...

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...

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....

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...

You'll have to use option 1 to get rid of the spaces (that is what I ment with fixed width columns).

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...

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...

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...

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...

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...

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...

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...

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.

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...

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.

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...

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

Hi,
What does the following command on the storage server reveal?
cellcli -e list alerthistory

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...

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...

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...

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...

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...

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.

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?...