I have the code below. I want to said
If TrackErrors > 0 or count == 0
then
MailErrors
else
MailSuccess
fi.
if
then
MailErrors ${count}
else
MailSuccess ${count}
fi
Any helps greatly appreciated. (2 Replies)
Hi all,
I got some problems on executing the following scripts.
Scripts:
if ]; then
echo "M${str}O 0 1" >> ${tempFile}
elif ]; then
echo "M${str}O 1 0" >> ${tempFile}
else
echo "M${str}O 0 0" >> ${tempFile}
fi
Error:
"`;' is not expected."
what's the problem? (2 Replies)
Hi
I am extracting a column value(DESCRIPTION) from one table and passing it to another db2 statement in a shell code to fetch some value(ID) but the value when passed in where condition is taking as newline+value.
Please find the out put when executed:
+ echo description is ::::... (1 Reply)
Hi all,
I have a file which I want to split into several files based on a condition. This files has several records. I want one record per file. Each record ends with a //. So, I want to separate files based on this condition. I want split files to be named with the name across the field ID (for... (2 Replies)
i have a script where i have to find the age of a file,
if
then
echo "dnb file is present for the monthly load" >> $RUNLOG
dnb="1"
else
echo "dnb file has not arrived yet" > $ERRLOG
dnb="0"
fi
i know the file is available so... (3 Replies)
i have this code
for i in `cat sql_output.txt`
do
-- some script commands
done
sql_output.txt has 1 column with employee_ids
If the sql_output.txt is null then the do loop should not execute.
How can i implement this.
for i in `cat sql_output.txt`
If i is null or empty
then ... (5 Replies)
Hi
I am trying to do a "IF" Condition in UNIX where we compare EACH file size in a directory with a SIZE (Parameter passed)
If Each File size EXCEEDS parameter passed SIZE then we manipulate the file.
Somehow the IF condition do not work ?? (is this Variable decalration issue ??)
... (9 Replies)
Hi All,
I have already code to create folder for one country let say US , now we want to create folder/directory for JP country also using shell script , application server.
$COUNTRY='US'
if ]
then
if mkdir -m 777 -p /opt/TEST/$COUNTRY/$INVOICE >/dev/null 2>&1 | tee -a ... (5 Replies)
Hi everybody,
I must get trought a shell script 3 arguments.
1st argument = $1 (can take values REP1..4)
2nd argument = $2 (can take values A..Z)
3rd arguement = $3 (also can take values A...Z)
I've written this code :
#!/bin/bash
if
then
liste=/data/folder1
echo... (6 Replies)
Discussion started by: shellX
6 Replies
LEARN ABOUT PHP
pg_meta_data
PG_META_DATA(3)PG_META_DATA(3)pg_meta_data - Get meta data for tableSYNOPSIS
array pg_meta_data (resource $connection, string $table_name, [bool $extended])
DESCRIPTION pg_meta_data(3) returns table definition for table_name as an array.
PARAMETERS
o $connection
- PostgreSQL database connection resource.
o $table_name
- The name of the table.
o $extended
- Flag for returning extended meta data. Default to FALSE.
RETURN VALUES
An array of the table definition, or FALSE on error.
EXAMPLES
Example #1
Getting table metadata
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
$meta = pg_meta_data($dbconn, 'authors');
if (is_array($meta)) {
echo '<pre>';
var_dump($meta);
echo '</pre>';
}
?>
The above example will output:
array(3) {
["author"]=>
array(5) {
["num"]=>
int(1)
["type"]=>
string(7) "varchar"
["len"]=>
int(-1)
["not null"]=>
bool(false)
["has default"]=>
bool(false)
}
["year"]=>
array(5) {
["num"]=>
int(2)
["type"]=>
string(4) "int2"
["len"]=>
int(2)
["not null"]=>
bool(false)
["has default"]=>
bool(false)
}
["title"]=>
array(5) {
["num"]=>
int(3)
["type"]=>
string(7) "varchar"
["len"]=>
int(-1)
["not null"]=>
bool(false)
["has default"]=>
bool(false)
}
}
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 5.6.0 | |
| | |
| | No longer experimental. Added "is enum" as |
| | default attribute. $extended flag is added. |
| | |
+--------+---------------------------------------------------+
SEE ALSO pg_convert(3).
PHP Documentation Group PG_META_DATA(3)