08-10-2016
Hi Don ,
I am using redhat 6.4 x86_64 os.and using mysql.Query will be like " hive -e "use db; set mapred.job.queue.name=dd;select max(date_ship) from db.table;" .I am using hql.I want the result of this hql will print on 3rd cell of table.The out put of query will be like "2016-08-08".
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
:)
Suppose,I have one table A. Table A have one column. Table A have 10 rows. I want this 10 rows store into shell script variable.
like
#!/bin/ksh
v_shell_var=Hi
here in call oracle , through loop How can I store table A's 10 rows into v_shell_var (Shell Script Array).
Regards,
Div (4 Replies)
Discussion started by: div_Neev
4 Replies
2. Shell Programming and Scripting
Hello,
Can someone please advise me how to put the db2 query reult into an array?
For example, the query reults are:
string A
string B
string C
Then how do I put them into array=string A
array=string B
... (2 Replies)
Discussion started by: hanul
2 Replies
3. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
4. Shell Programming and Scripting
Hi,
I need a shell script, which would search the result values from another files.
1)execute " select column1 from table_name" query on the table.
2)Based on the result, need to be grep from .wft files.
could please explain about this.Below is the way i am using.
#!/bin/sh... (4 Replies)
Discussion started by: Rami Reddy
4 Replies
5. Programming
Hi,
I wrote the below script to get the query result from a Syabase DB.
isql -s -U **** -P **** SYBASE SERVERNAME
USE ***(Database name in Sybase)
@command.sql
But im not getting the output. Can anyone help me on this (2 Replies)
Discussion started by: rohan G
2 Replies
6. Shell Programming and Scripting
I have a postgres sql statement that is the following:
select age from students;
which gives me the entries:
Age
---
10
15
13
12
9
14
10
which is about 7 rows of data.
Now what I would like to do with this is use a shell script to create an array age. As a results... (3 Replies)
Discussion started by: JSNY
3 Replies
7. Shell Programming and Scripting
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies
8. UNIX and Linux Applications
Hello,
I am newbie on mysql and trying to edit my database from terminal under linux.
What I need to do is to change the information written in a cell in table.
Let me explain what I tried:
$ mysql -u mysqluser -p
$ show databases;
$ USE catalogue;
$ show tables ;
$ select * from... (2 Replies)
Discussion started by: baris35
2 Replies
9. Shell Programming and Scripting
I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by
modifying the script and show me how to execute it.
First Requirement:
I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies
LEARN ABOUT PHP
ifx_htmltbl_result
IFX_HTMLTBL_RESULT(3) 1 IFX_HTMLTBL_RESULT(3)
ifx_htmltbl_result - Formats all rows of a query into a HTML table
SYNOPSIS
int ifx_htmltbl_result (resource $result_id, [string $html_table_options])
DESCRIPTION
Formats and prints all rows of the $result_id query into a HTML table.
PARAMETERS
o $result_id
-$result_id is a valid resultid returned by ifx_query(3) or ifx_prepare(3) (select type queries only!).
o $html_table_options
- This optional argument is a string of <table> tag options.
RETURN VALUES
Returns the number of fetched rows, or FALSE on errors.
EXAMPLES
Example #1
Informix results as HTML table
<?php
$rid = ifx_prepare ("select * from emp where name like " . $name,
$connid, IFX_SCROLL);
if (! $rid) {
/* ... error ... */
}
$rowcount = ifx_affected_rows ($rid);
if ($rowcount > 1000) {
printf ("Too many rows in result set (%d)
<br />", $rowcount);
die ("Please restrict your query<br />
");
}
if (! ifx_do($rid)) {
/* ... error ... */
}
ifx_htmltbl_result ($rid, "border="2"");
ifx_free_result($rid);
?>
PHP Documentation Group IFX_HTMLTBL_RESULT(3)