Statement returning error only launching the sh script via crontab
hi all,
I created a sh script to import some tables from mysql to hive.
No problem launching it manually, but if I schedule via crontab it returns me an error in the following part:
Hi folks!
my client uses an winapplication which is launching shell-scripts remotely on a HP-Unix Machine via Rexec.
The application-configuration is launching the script (which is in the home directory of connecting user) like:
rexec host user pass shell.sh
So far so good, everything... (3 Replies)
hi there,
i need some help, i am trying to run a script to launch a C program and a Java program but before running both I want to get a user input and then invoke both programs with input received. In the programs the inputs are not command line arguments.
This is the code,
after the java... (4 Replies)
I'm working on a function in a shell script I'm writing that will eventually take in and print out a list of vendor names and aliases (for my work) Here's the function in question:
addvendorandalias ()
{
echo
echo -n 'Would you like to create a new vendor list (y or n)? '
read answer... (3 Replies)
Hi everybody,
I have compiled my code based on the ALPS libraries () and CMake build system with IBM compiler xlC 11.1 on AIX 6.1 at the latest patch level running on an IBM SP Power 6 machine for high-performance computing.
When I run the executable I receive this error message:
-bash-3.2$... (2 Replies)
Hi,
I have a shell script which is residing on AIX which is triggered by Mainframe through Connect Direct. The shell script creates several files and sends those files to mainframe using Connect Direct. The shell script is working fine, still it is returning exit code 2 to mainframe.
What... (0 Replies)
Hi,
I am writing a script in which I am using an IF-Else statement.
Code sample:
# Check for the product.
If (test "$3" = "Pet") Then
Product_Code="PI"
elif (test "$3" = "Breakdown") Then
Product_Code="RI"
elif (test "$3" = "Travel") Then
Product_Code="TI"
... (2 Replies)
Hi,
I have initailized a varaible EBID as typeset Long EBID=0
i am calculating value of EBID using certian formula as below:
(( CURR_EBID= ($BANDINDEX << 27) | ($CURR_FREQ << 16) | ($CURR_CELLID << 4) | $CURR_SECTOR_VALUE ))
return $CURR_EBID
The output is as below:
+ (( CURR_EBID=... (6 Replies)
Hi all,
i have the following script
#!/bin/sh
for i in `ps -leaf --cols 1024 | grep LogUser | grep -v grep | awk '{print $4}'`;
do
echo $i
kill -15 $i;
done;
but it seems that the crontab its sciping this script,i configured corntab as following
*/30 * * * root... (2 Replies)
The code at the bottom is a simplified example of what we have.
If I use the following:
&& echo "echo failed"
$? returns 1
When I use
if ; then echo "echo failed" ; fi
$? returns 0
Does anyone know what's wrong with this?
Using AIX 6.1 and KSH
for NUM in 1 2 3
do
... (5 Replies)
I'm using the Links2 console web browser in graphical mode (the "-g" argument), and launching a shell script
that invokes MPlayer from within it. MPlayer works fine. No problem there. The problem, is that I have no
control over the MPlayer process. I would like to be able to exit MPlayer whenever... (16 Replies)
Discussion started by: ignatius
16 Replies
LEARN ABOUT CENTOS
do
DO(7) PostgreSQL 9.2.7 Documentation DO(7)NAME
DO - execute an anonymous code block
SYNOPSIS
DO [ LANGUAGE lang_name ] code
DESCRIPTION
DO executes an anonymous code block, or in other words a transient anonymous function in a procedural language.
The code block is treated as though it were the body of a function with no parameters, returning void. It is parsed and executed a single
time.
The optional LANGUAGE clause can be written either before or after the code block.
PARAMETERS
code
The procedural language code to be executed. This must be specified as a string literal, just as in CREATE FUNCTION. Use of a
dollar-quoted literal is recommended.
lang_name
The name of the procedural language the code is written in. If omitted, the default is plpgsql.
NOTES
The procedural language to be used must already have been installed into the current database by means of CREATE LANGUAGE. plpgsql is
installed by default, but other languages are not.
The user must have USAGE privilege for the procedural language, or must be a superuser if the language is untrusted. This is the same
privilege requirement as for creating a function in the language.
EXAMPLES
Grant all privileges on all views in schema public to role webuser:
DO $$DECLARE r record;
BEGIN
FOR r IN SELECT table_schema, table_name FROM information_schema.tables
WHERE table_type = 'VIEW' AND table_schema = 'public'
LOOP
EXECUTE 'GRANT ALL ON ' || quote_ident(r.table_schema) || '.' || quote_ident(r.table_name) || ' TO webuser';
END LOOP;
END$$;
COMPATIBILITY
There is no DO statement in the SQL standard.
SEE ALSO
CREATE LANGUAGE (CREATE_LANGUAGE(7))
PostgreSQL 9.2.7 2014-02-17 DO(7)