03-31-2012
IF statement file exist or not?
How can I check and see if the first parameter is a file existing in the current path or it is a real file and user input some random name in an IF statement?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a shell script that runs all the time looking for a certain type of file and then it processes the file through a series of other scripts. The script is watching a directory that has files uploaded to it via SFTP. It already checks the size of the file to make sure that it is not still... (3 Replies)
Discussion started by: heprox
3 Replies
2. Shell Programming and Scripting
i want a script to check whether the file name exits or not if not it has to create a new one (3 Replies)
Discussion started by: din_annauniv
3 Replies
3. Shell Programming and Scripting
Can someone please shed light on why this may not be working, file does exist, but I get an error
if ]
then
echo "No ${source_path}/${file_mask} found - ">> ${logfile}
result=1
check_result ${result} "Failed to find file... (4 Replies)
Discussion started by: Pokermad
4 Replies
4. Shell Programming and Scripting
Hi
Does anybody know how I can check if a file exists
i.e. see bellow, this doesn't work by the way and if tried countless variations on this
file1=$one/file111.txt
if
then
echo "Present"
else
echo "Not present"
fi
result :
Not present
(file is already present, eventhough its... (3 Replies)
Discussion started by: gksenthilkumar
3 Replies
5. Shell Programming and Scripting
Hi All,
I have txt file which has list of files. I have to check whether these files exist or not.
Thanks
supriya (6 Replies)
Discussion started by: supriyabv
6 Replies
6. Shell Programming and Scripting
Hi,
I am trying to create a bash script which will check if file exist then remove that file else do nothing. I have to do same process for three files in same script. I have written code for one file and trying to run it.
if
then
rm -r /user1/abc/File1
fi
When I run this code it... (1 Reply)
Discussion started by: palak08
1 Replies
7. Shell Programming and Scripting
Hi,
I created following script to check if file exist:
#!/bin/bash
SrcDir=$1
SrcFileName=$2
SrcTimePeriod=$3
if ;then
echo 1
else
echo 0
fi
I ran it like: /apps/Scripts/FileExist.sh /apps/Inbox file1 2nd_period_2010
Even file exist at that location, my above command is... (4 Replies)
Discussion started by: palak08
4 Replies
8. Shell Programming and Scripting
I have a list of fields that I want to check a file for, returning that field if it not found at all in the file. Is there a way to do a grep -lc and return the passed variable too rather then just the count?
I am doing some crappy work-around now but I was not sure how to regrep this for :0 so... (3 Replies)
Discussion started by: personalt
3 Replies
9. Shell Programming and Scripting
Hi guys,
I am new to shell script, i want to write shell script, the script details has mentioned below
Two files are to be check in one particular directory, if the file exist in particular folder then the file is existed and also if the file exist more than three hours then send... (2 Replies)
Discussion started by: madhavi_bodi
2 Replies
10. Shell Programming and Scripting
friends can do this from unix AIX
I need to ask for a file that does not exist
then if file.txt
*
**** echo "execute procedure"
else
*** echo "File does not exist"
if
You can sucedere that the file does not exist (2 Replies)
Discussion started by: tricampeon81
2 Replies
LEARN ABOUT PHP
db2_prepare
DB2_PREPARE(3) 1 DB2_PREPARE(3)
db2_prepare - Prepares an SQL statement to be executed
SYNOPSIS
resource db2_prepare (resource $connection, string $statement, [array $options])
DESCRIPTION
db2_prepare(3) creates a prepared SQL statement which can include 0 or more parameter markers ( ? characters) representing parameters for
input, output, or input/output. You can pass parameters to the prepared statement using db2_bind_param(3), or for input values only, as an
array passed to db2_execute(3).
There are three main advantages to using prepared statements in your application:
o Performance: when you prepare a statement, the database server creates an optimized access plan for retrieving data with that
statement. Subsequently issuing the prepared statement with db2_execute(3) enables the statements to reuse that access plan and
avoids the overhead of dynamically creating a new access plan for every statement you issue.
o Security: when you prepare a statement, you can include parameter markers for input values. When you execute a prepared statement
with input values for placeholders, the database server checks each input value to ensure that the type matches the column defini-
tion or parameter definition.
o Advanced functionality: Parameter markers not only enable you to pass input values to prepared SQL statements, they also enable
you to retrieve OUT and INOUT parameters from stored procedures using db2_bind_param(3).
PARAMETERS
o $connection
- A valid database connection resource variable as returned from db2_connect(3) or db2_pconnect(3).
o $statement
- An SQL statement, optionally containing one or more parameter markers..
o $options
- An associative array containing statement options. You can use this parameter to request a scrollable cursor on database servers
that support this functionality. For a description of valid statement options, see db2_set_option(3).
RETURN VALUES
Returns a statement resource if the SQL statement was successfully parsed and prepared by the database server. Returns FALSE if the data-
base server returned an error. You can determine which error was returned by calling db2_stmt_error(3) or db2_stmt_errormsg(3).
EXAMPLES
Example #1
Preparing and executing an SQL statement with parameter markers
The following example prepares an INSERT statement that accepts four parameter markers, then iterates over an array of arrays con-
taining the input values to be passed to db2_execute(3).
<?php
$animals = array(
array(0, 'cat', 'Pook', 3.2),
array(1, 'dog', 'Peaches', 12.3),
array(2, 'horse', 'Smarty', 350.0),
);
$insert = 'INSERT INTO animals (id, breed, name, weight)
VALUES (?, ?, ?, ?)';
$stmt = db2_prepare($conn, $insert);
if ($stmt) {
foreach ($animals as $animal) {
$result = db2_execute($stmt, $animal);
}
}
?>
SEE ALSO
db2_bind_param(3), db2_execute(3), db2_stmt_error(3), db2_stmt_errormsg(3).
PHP Documentation Group DB2_PREPARE(3)