05-10-2013
Add a "\n" to the end of the printf statement, and use double quotes around each variable.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
This is for an Oracle journal import. I was using a pl/sql package and oracle API's. Oracle added invoker rights to their API's and now my package won't run. I didn't want to use their API's anyway. The only reason i was using pl/sql and the API's (just a package) was to utilize a cursor. How... (2 Replies)
Discussion started by: lmu
2 Replies
2. Shell Programming and Scripting
Hi , I have below command to that outputs from variables..
command:
echo $INSTANCE $DATAB $status $TSLastBackup| awk '{printf("%-8s %-8s \t \n",$1,$2,$3,$4)}' | tee $LOGF
the ouput is now:
INSTANCE DATABSE BACKUP_STATUS BACKUPTIMESTAMP
------- -------- -------- ... (1 Reply)
Discussion started by: db2_usd
1 Replies
3. Shell Programming and Scripting
Hi
I need to assign the ouput of a awk statement to two variables; below is a example of the txt file i have which I use awk against
sample file
testval,USA,loc2,testing02
testval1,GB,loc4,testing01
awk statement
awk -F , '{print $2,$3}'
USA loc2
GB loc4
I need a method where... (6 Replies)
Discussion started by: duckeggs01
6 Replies
4. Shell Programming and Scripting
Hi,
I have 3 files with one column value as shown
File: a.txt
------------
Data_a1
Data_a2
File2: b.txt
------------
Data_b1
Data_b2
Data_b3
Data_b4
File3: c.txt
------------
Data_c1
Data_c2
Data_c3
Data_c4
Data_c5 (6 Replies)
Discussion started by: vfrg
6 Replies
5. Shell Programming and Scripting
Hello Experts,
Below is the record i have:
sample data attached
I want this record of each row to be in single line and there are multiple rowise unixtime mentioned e.g 11996327 , This needs to be converted to Human readdable data and time from multiple rows
Can you help me , it will be... (10 Replies)
Discussion started by: manishK
10 Replies
6. Shell Programming and Scripting
Hi,
I need to display output in below format
Customer : Apr 24 16:31 Customer_Name_111121.txt
|---Space---|Apr 24 16:32 Customer_Name _111121. txt
|---Space---|Apr 24 16:34 Customer_Name_111112. txt
|---Space---|Apr 24 16:35 Customer_Name _222223. txt
|---Space---|Apr 24 16:37... (8 Replies)
Discussion started by: ketanraut
8 Replies
7. Shell Programming and Scripting
Hello,
I would like to ask for help with csh script.
An example of an input in .txt file is below, the number of lines varies from file to file and I have 2 or 3 columns with values. I would like to read all the values (probably one by one) and set them to independent unique variables that... (7 Replies)
Discussion started by: FMMOLA
7 Replies
8. Shell Programming and Scripting
Input file:
011100020100 0.00 1 20000 30000 20000
011110000025 0.00 1 000 240000 10000
011100020100 0.00 1 200000 2324000 403500
032200030025 0.00 1 2077500 3077500 250000
032200030025 0.00 1 2565000 25536400 320000
022220000005 0.00 1 10000 300000 300000
022220000005 0.00 1 200050... (7 Replies)
Discussion started by: vinus
7 Replies
9. Shell Programming and Scripting
I would like to join two files when two columns in each file matches with each other and then produce an output when taking multiple columns.
Like I have file A
1234,ABCD,23,JOHN,NJ,USA
2345,ABCD,24,SAM,NY,USA
5678,GHIJ,24,TOM,NY,USA
5678,WXYZ,27,MAT,NJ,USA
and file B
... (2 Replies)
Discussion started by: mady135
2 Replies
10. UNIX for Dummies Questions & Answers
I have several problems with my problems: I hope you can help me.
1) the If else statement I am getting an error message. My syntax must be incorrect because the entire statement is throwing an error.
For example in filew.log if these items don't exist Memsize, SASFoundation and also if... (0 Replies)
Discussion started by: dellanicholson
0 Replies
LEARN ABOUT PHP
odbc_execute
ODBC_EXECUTE(3) 1 ODBC_EXECUTE(3)
odbc_execute - Execute a prepared statement
SYNOPSIS
bool odbc_execute (resource $result_id, [array $parameters_array])
DESCRIPTION
Executes a statement prepared with odbc_prepare(3).
PARAMETERS
o $result_id
- The result id resource, from odbc_prepare(3).
o $parameters_array
- Parameters in $parameter_array will be substituted for placeholders in the prepared statement in order. Elements of this array
will be converted to strings by calling this function. Any parameters in $parameter_array which start and end with single quotes
will be taken as the name of a file to read and send to the database server as the data for the appropriate placeholder. If you
wish to store a string which actually begins and ends with single quotes, you must add a space or other non-single-quote character
to the beginning or end of the parameter, which will prevent the parameter from being taken as a file name. If this is not an
option, then you must use another mechanism to store the string, such as executing the query directly with odbc_exec(3)).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
odbc_execute(3) and odbc_prepare(3) example
In the following code, $success will only be TRUE if all three parameters to myproc are IN parameters:
<?php
$a = 1;
$b = 2;
$c = 3;
$stmt = odbc_prepare($conn, 'CALL myproc(?,?,?)');
$success = odbc_execute($stmt, array($a, $b, $c));
?>
If you need to call a stored procedure using INOUT or OUT parameters, the recommended workaround is to use a native extension for your
database (for example, mssql for MS SQL Server, or oci8 for Oracle).
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 4.2.0 | |
| | |
| | File reading is now subject to safe mode and |
| | open-basedir restrictions in $parameters_array. |
| | |
+--------+---------------------------------------------------+
SEE ALSO
odbc_prepare(3).
PHP Documentation Group ODBC_EXECUTE(3)