12-18-2014
Thank you to all of you for share your solutions. The issue is the data is stored in arrays as I showed in first post. I showed strings to represent what is the content of the array. Because of that I was using combination of loops and if statements.
Thanks again.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I have a file which has the below information
tm.orbit72
tm.orbit12
tm.orbit78
tm.orbitye
I want to print the last two letters in the above file. Please let me know how can i do that. (6 Replies)
Discussion started by: Krrishv
6 Replies
2. Shell Programming and Scripting
hi Im trying to make the 'response' return the answer in the form of a dash (-) rather than the actuall letters of a given word typed in, this is what i have tried, but im not getting the dashes come through just a blank screen, any ideas guys?
function enterWord () {
echo "select to be... (2 Replies)
Discussion started by: ferrycorsten73
2 Replies
3. Shell Programming and Scripting
Hi Guys,
I have an array which has numbers including blanks as follows:
1
26
66
4.77
-0.58
88
99
11
12
333
I want to print a group of three elements as a different column in a file as follows:(including blanks where there is missing elements) for.e.g. array element #7... (4 Replies)
Discussion started by: npatwardhan
4 Replies
4. UNIX for Dummies Questions & Answers
hey
i m kinda new to this so i will appreciate any help
, i have this list of values:
pwwn = 0x50012482009cd7a7 nwwn=0x50012482009cd7a6 port_id = 0x280200
pwwn = 0x5001248201bcd7a7 nwwn=0x5001248201bcd7a6 port_id = 0x280300
pwwn = 0x50012482009c51ad nwwn=0x50012482009c51ac port_id =... (4 Replies)
Discussion started by: boaz733
4 Replies
5. Shell Programming and Scripting
Hey guys,
I'm new to shell scripting and I'm trying to write a script that takes user input and copies the specified columns from a data file to a new one. In order to account for the possibility of a variable number of columns to copy I wrote a loop that encodes the user's choices in an array... (16 Replies)
Discussion started by: shaner
16 Replies
6. UNIX for Dummies Questions & Answers
Hello,
In a shell script, I want to declare an array and subsequently print the elements with tab delimits.
My array has the following structure and arbitrary elements:
myArray=('fgh' 'ijk' 'xyz' 'abc');
Next, I would like to print it with a '\n' at the end.
Thanks for your input!
... (2 Replies)
Discussion started by: Gussifinknottle
2 Replies
7. Shell Programming and Scripting
Hello experts,
I wish to print the contents of odd-even numbered indices of an array.
The problem statement is as follows :
1. The first line contains an integer, (the number of test cases).
2. Each line of the subsequent lines containing a string.
Example:
2
Haider
Bash
... (4 Replies)
Discussion started by: H squared
4 Replies
8. UNIX for Beginners Questions & Answers
Example of problem:
computerhand=(6H 2C JC QS 9D 3H 8H 4D)
topcard=6D
How do you search ${computerhand} for all elements containing either a "6" or a "D" then
save the output to a file?
This is a part of a Terminal game of Crazy 8's that I'm attempting to write in Bash.
Any... (2 Replies)
Discussion started by: cogiz
2 Replies
9. UNIX for Beginners Questions & Answers
example of problem:
#!/bin/bash
P=(2 4 7)
How would you randomly choose one of these 3 numbers in this array?
either 2 or 4 or 7 is needed...but only one of them.
Thanks in advance
Cogiz
Please use CODE tags as required by forum rules! (3 Replies)
Discussion started by: cogiz
3 Replies
10. UNIX for Beginners Questions & Answers
username=cogiz
#!/bin/bash
shuffle() #@ USAGE: shuffle
{ #@ TODO: add options for multiple or partial decks
Deck=$(
printf "%s\n" {2,3,4,5,6,7,8,9,T,J,Q,K,A}{H,S,D,C} |
awk '## Seed the random number generator
BEGIN { srand() }
## Put a random number in front... (4 Replies)
Discussion started by: cogiz
4 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)