I would go for something like this:
And btw, this looks strange:
If you want to execute a command, don't write it like a variable, ie. leave out the $ and the {}. This is what works:
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)
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)
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)
hi
i have a file, i am reading line by line and checking a line contains a string ,
`grep "Change state" $LINE`
if
then
echo "The line contains---"
else
echo "The line does not contains---"
i need to check the return code , but i am getting an error
... (4 Replies)
Hi Guys,,
I am having a unix script which is running the DB2 Insert command.
For the insert command, there were no records to be updated.
SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a
query is an empty table. SQLSTATE=02000
+ + echo 1
STAGE_RC=1
+ ]
... (6 Replies)
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)
Hi Everyone,
I am facing a problem regarding the select from sybase, the return with the incorrect size.
For example, field is NAME(20).
After i selected from sybase, the result is nicky.
after i assign it to another declaration variable, it will be in actual name "nicky" , what i need... (10 Replies)
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)
I have this code that sometimes return a false value and the code inside the if statement gets executed and error out. Any idea why? thanks.
So I set a debug and see what the value for $ScriptElapsedTime
Here is the value I got ScriptElapsedTime='03:20'. Base on this value the if... (10 Replies)
How do we retrieve case statement return value at point indicated in the attached snippet
case "$FUN" in
1\ *) do_change_pass ;;
2\ *) do_network_menu ;;
3\ *) do_boot_menu ;;
4\ *) do_internationalisation_menu ;;
5\ *) do_ssh... (6 Replies)
Discussion started by: annacreek
6 Replies
LEARN ABOUT PHP
db2_stmt_error
DB2_STMT_ERROR(3) 1 DB2_STMT_ERROR(3)db2_stmt_error - Returns a string containing the SQLSTATE returned by an SQL statementSYNOPSIS
string db2_stmt_error ([resource $stmt])
DESCRIPTION
Returns a string containing the SQLSTATE value returned by an SQL statement.
If you do not pass a statement resource as an argument to db2_stmt_error(3), the driver returns the SQLSTATE value associated with the
last attempt to return a statement resource, for example, from db2_prepare(3) or db2_exec(3).
To learn what the SQLSTATE value means, you can issue the following command at a DB2 Command Line Processor prompt: db2 '? $sqlstate-
value'. You can also call db2_stmt_errormsg(3) to retrieve an explicit error message and the associated SQLCODE value.
PARAMETERS
o $stmt
- A valid statement resource.
RETURN VALUES
Returns a string containing an SQLSTATE value.
SEE ALSO db2_conn_error(3), db2_conn_errormsg(3), db2_stmt_errormsg(3).
PHP Documentation Group DB2_STMT_ERROR(3)