12-11-2008
This is the piece of code causing trouble.. otheus..
db2 "insert into table \
(col,,,,\
) \
select * from tab1 a, tab2 b where\
a.id=b.id \
with ur"
STAGESUM_RC=`echo $?`
if [[ $STAGESUM_RC != "0" ]] ; then
ReturntoParent $STAGESUM_RC "Error in Insert Fact Stage_Sum"
fi
db2 "commit"
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi Guys,
I was just wondering if anybody can help me with this problem.
OK, how we can get a value back from PL/SQL Script (not stored procedure/function)
See the below example: (for example aaa.sh)
#!/bin/ksh
VALUE=`sqlplus -s user/password@test_id <<EOF
@xxx.sq
EOF`
echo $VALUE
... (7 Replies)
Discussion started by: Shaz
7 Replies
2. Shell Programming and Scripting
I have a unix AIX script that ftps some files (mput, mget). How can I check (in the script) to see if the ftp failed? After the ftp I move the files out of the directory but do not want to move files that have not been sent. The script will run as a cron job. (2 Replies)
Discussion started by: rayg50
2 Replies
3. Programming
Hi,
Can any one help me in knowing how can I get the return codes/Error codes when using the system() command to fork a command?
Regards,
MK (1 Reply)
Discussion started by: mradulkaushik
1 Replies
4. Shell Programming and Scripting
hi all
my system is linux red hat
i have a script that runs some object .
the object return some code to the system
i see the code by writing echo $?
i want to ask in the script if $? equals 14
how shell is do that in the script
thanks (3 Replies)
Discussion started by: naamas03
3 Replies
5. Shell Programming and Scripting
I know how to get the returning code of a function but wonder if I can combine the follwoing two lines into one:
e.g.:
#!/bin/shell
...
#line 1
MyFunction arg1 arg 2
#line 2
rec=$? #this will be evaluated later
....
like in c/c++, we'd write one line:
rec=MyFunction(arg1, arg 2)
... (6 Replies)
Discussion started by: bluemoon1
6 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
Can anyone please let me know the syntax / how to pick up the Return Code ( RC) from the mailx command and return it to SAS uisng 'system()' function and '${?}'.
I am in a process to send the mail automatically with an attachment to bulk users. I have used 'Mailx' and 'Unencode'... (0 Replies)
Discussion started by: manas6
0 Replies
7. Shell Programming and Scripting
Hello folks,
I have a question that if i type ls command and type echo $? it always show "0", how i could do this change that when i type ls it will show me 1, actually i want to change the return code of commands from 0 to 1.
Thanks
Bash (5 Replies)
Discussion started by: learnbash
5 Replies
8. Shell Programming and Scripting
I need to try and get the error return code from the tar command when being used as follows:
tar tvf tarfile 2>logfile | tee -f outputfile
ErrorStat="$?"
I would like to save the error return code from the tar command in a variable,
howver, the example above it is saving the 'tee' error... (7 Replies)
Discussion started by: nck
7 Replies
9. Shell Programming and Scripting
Hello,
I am woring on a script where I am getting strange situation.This script actually fetch the source code and tar that code and send to NAS location.This code resides in MKS tool...and we are fetching the source code on checkpoint label basis and script is working fine.First it synch the... (0 Replies)
Discussion started by: anuragpgtgerman
0 Replies
10. UNIX for Beginners Questions & Answers
Hello everyone
Can some help me with understand return code in expect
#!/usr/bin/expect
set timeout 1
set SRV
set user
set pw
spawn ssh $user@$SRV
expect {
"(yes/no)? " { send "yes\r" ; exp_continue }
"assword: " { send "$pw\r" ; exp_continue }
eof
}... (2 Replies)
Discussion started by: vikus
2 Replies
LEARN ABOUT PHP
dba_handlers
DBA_HANDLERS(3) 1 DBA_HANDLERS(3)
dba_handlers - List all the handlers available
SYNOPSIS
array dba_handlers ([bool $full_info = false])
DESCRIPTION
dba_handlers(3) list all the handlers supported by this extension.
PARAMETERS
o $full_info
- Turns on/off full information display in the result.
RETURN VALUES
Returns an array of database handlers. If $full_info is set to TRUE, the array will be associative with the handlers names as keys, and
their version information as value. Otherwise, the result will be an indexed array of handlers names.
Note
When the internal cdb library is used you will see cdb and cdb_make.
EXAMPLES
Example #1
dba_handlers(3) Example
<?php
echo "Available DBA handlers:
";
foreach (dba_handlers(true) as $handler_name => $handler_version) {
// clean the versions
$handler_version = str_replace('$', '', $handler_version);
echo " - $handler_name: $handler_version
";
}
?>
The above example will output something similar to:
Available DBA handlers:
- cdb: 0.75, Revision: 1.3.2.3
- cdb_make: 0.75, Revision: 1.2.2.4
- db2: Sleepycat Software: Berkeley DB 2.7.7: (08/20/99)
- inifile: 1.0, Revision: 1.6.2.3
- flatfile: 1.0, Revision: 1.5.2.4
PHP Documentation Group DBA_HANDLERS(3)