Please check where am i going wrong.
full_refresh.txt: input file
here i tried using split command to read 4 lines at once.
Well, quite possibly a lot. Is this for POSIX sh? If you have bash, you could use arrays instead of eval.
You should quote every "$variable".
You can test a command, rather than assign "$?" to a variable and test the variable... if takes a command ...
You should read your fields into separate values using read instead of `echo "$line" | awk '...'` ...
You write a "list.txt" but read a "list"
Taking all this into account, plus I don't think we need "split", I rewrite it as so:
Code:
#!/bin/sh
file='full_refresh.txt'
schema=schema
table=table
nickname=nickname
# i don't have this function...test
db2() {
echo "db2: $@"
#pretend like it takes some time
sleep 10
}
full() {
echo "You entered full $1,$2,$3"
if db2 "call util.DATA_REFRESH('LOAD','$1','$2','$3','$2','R','?',?)"; then
echo "$1.$2" >>Success_list.txt
else
echo "$1.$2" >>failure_list.txt
fi
}
while IFS='|' read schema table nickname _; do
count=$((count+1))
full "$schema" "$table" "$nickname" &
if [ "$count" -ge 4 ]; then
wait
count=0
fi
done < "$file"
All,
I have a sh script of the following tune:
function a () { #functionality.. }
function b () { #functionnlity.. }
function check () { # this function checks for env and if all fine call build }
function usage () { #sh usage details }
function build () { #calls either a or b or... (5 Replies)
i have script say some_script.ksh that takes an argument
I need to run some_script.ksh in background parallely at the sametime with different arguments.
Once all the background jobs complete, i need to run this script again in parallel with another 5 set of arguments.
Would really... (1 Reply)
Hi I have 2 files a.c and a.bak where I changed long to int using awk script.
I want to get the list of functions whose parameters got modified
for eg: fun ( long a, long b ) might be changed to fun ( int a, int b ) (1 Reply)
Hi,
Please help me with the below situation where I have to handle the parameters passed to a function in a unique way.
Below is the code, which I am trying to execute. I basically want to pass the parameter to a function, where I am trying to get user input into array(s). I want to name... (7 Replies)
Hi, for example I have this function:
function get_param ()
{
test=echo "some string"
test2=echo "someother string"
}
I want to call this function and get test or test2 result, how do I do that ?
Thank you (2 Replies)
Hello,
I have multiple functions within a shell script. eg. function_database_backup, unix_tar_creation, etc.
I would like to run these functions in parallel, as each is independent of the other.
If these were simple commands, I could have probably run each of the commands in background.
... (1 Reply)
I have 7 functions those need to be executed as command line inputs, I tried with below code it’s not executing function. If I run the ./script 2 then fun2 should execute , how to initiate that function I tried case and if else also, how to initiate function from command line
if
then... (8 Replies)
I have a script (ksh) which tries to run a function in parallel for performance gains. I am also trying to limit the number of parallel child processes to avoid overloading the system by using a variable to count triggered processes and waiting for completion e.g.
do_something ()
{
...
}
... (9 Replies)
Hi,
I am a beginner in python programming. In my python script have a main function which calls several other functions. The main function gets its input by reading lines from a input text file. I call the main function for every line in input text file through a loop.
def main(line):
var1... (6 Replies)
Hi Experts,
how to pass subject,mailbody and filename as parameters to function.
mode=$1
file=/db/files/uniq.txt
mail_send() {
export MAILPART=$(uuidgen)
export MAILPART_BODY=$(uuidgen)
{
echo "TO:nalu.d@hes.com"
echo "Subject:$subject"
echo "MIME-Version: 1.0"
... (0 Replies)
Discussion started by: nalu
0 Replies
LEARN ABOUT PHP
db2_primary_keys
DB2_PRIMARY_KEYS(3) 1 DB2_PRIMARY_KEYS(3)db2_primary_keys - Returns a result set listing primary keys for a tableSYNOPSIS
resource db2_primary_keys (resource $connection, string $qualifier, string $schema, string $table-name)
DESCRIPTION
Returns a result set listing the primary keys for a table.
PARAMETERS
o $connection
- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
o $qualifier
- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
o $schema
- The schema which contains the tables. If $schema is NULL, db2_primary_keys(3) matches the schema for the current connection.
o $table-name
- The name of the table.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the primary keys for the specified table. The result set is com-
posed of the following columns:
+------------+---------------------------------------------------+
|Column name | |
| | |
| | Description |
| | |
+------------+---------------------------------------------------+
| TABLE_CAT | |
| | |
| | Name of the catalog for the table containing the |
| | primary key. The value is NULL if this table does |
| | not have catalogs. |
| | |
|TABLE_SCHEM | |
| | |
| | Name of the schema for the table containing the |
| | primary key. |
| | |
|TABLE_NAME | |
| | |
| | Name of the table containing the primary key. |
| | |
|COLUMN_NAME | |
| | |
| | Name of the column containing the primary key. |
| | |
| KEY_SEQ | |
| | |
| | 1-indexed position of the column in the key. |
| | |
| PK_NAME | |
| | |
| | The name of the primary key. |
| | |
+------------+---------------------------------------------------+
SEE ALSO db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_special_columns(3),
db2_statistics(3), db2_table_privileges(3), db2_tables(3).
PHP Documentation Group DB2_PRIMARY_KEYS(3)