Hi
I'm trying run a netezza select query from a korn shell script, i'm getting the
data in the below format, is there any way to get only the data in a vairable,
i just want the last line which is "2014:08:01 12:51:00"
the command i'm using inside the script is
i need to get the date in a vairable,
Dear all
I want to execute some isql command from unix shell script. Kindly suggest me. isql command mention below.
isql -U -P
use gdb_1
go
select count (*) from table_x
go (3 Replies)
when we are spooling query o/p to certain txt file,in that file how we can get headers in the query.(through unix shell scripting).
for exmple
q1="slect * from XXXXXX;";
sqlplus XXX/XXXX@XXXXX
spool XXXX.txt
$q1
spool off
in the text file i want the headers of the query.....
... (0 Replies)
Hi,
I'm trying to strip all lines between two headers in a file:
### BEGIN ###
Text to remove, contains all kinds of characters
...
Antispyware-Downloadserver.com (Germany)=http://www.antispyware-downloadserver.c
om/updates/
Antispyware-Downloadserver.com #2... (3 Replies)
Hi ,
I need help in creating the shell script for querying using a loop.
I haev written the code as follows . But i am getting an error : Line doesn't required '(' . i have chagned but am getting again
#!/bin/ksh
##checking the Command Line Parameter
if test $1 = ""
then
... (3 Replies)
Hi ,
I have a typical situation. I have 4 files and with different headers (number of headers is varible ).
I need to make such a merged file which will have headers combined from all files (comman coluns should appear once only).
For example -
File 1
H1|H2|H3|H4
11|12|13|14
21|22|23|23... (1 Reply)
Hi
I am new in unix. oracle and unix are installed in my sytem.i need the script
which could connect to the oracle using username ,password and schema and can run the select * from tab query.
Thanks
vijay (8 Replies)
Hi,
I am using sqlplus query to get results in a csv format in unix. I am using ksh, and below is the query.
echo "select r.num|| ',' || p.path ||',"' || r.issue_description ||'",' ||p.timestamp from events r, messagepath p;">> $QUERY_FILE
sqlplus -s $LOGIN @ $QUERY_FILE>>$OUTFILE
... (2 Replies)
hi Guys,
i have a problem with oracle query in my unix script..
I'm getting the following error while executing..
./logtab.sh: sqlplus -s "pmutv/pmutv1" << EOFSQL^Jset head off^Jinsert into... (2 Replies)
Hi
I searched this forum before posting the question, but couldnt find it, the issue
i'm facing is, i'm trying to select a column from a netezza table from a korn
shell script, but the query runs
var=$(nzodbcsql -q "select MAX(millcount) from table1";)
echo $var
it returns the value like... (10 Replies)
Discussion started by: maximus_jack
10 Replies
LEARN ABOUT PHP
virtual
VIRTUAL(3) 1 VIRTUAL(3)virtual - Perform an Apache sub-requestSYNOPSIS
bool virtual (string $filename)
DESCRIPTION virtual(3) is an Apache-specific function which is similar to <!--#include virtual...--> in mod_include. It performs an Apache sub-request.
It is useful for including CGI scripts or .shtml files, or anything else that you would parse through Apache. Note that for a CGI script,
the script must generate valid CGI headers. At the minimum that means it must generate a Content-Type header.
To run the sub-request, all buffers are terminated and flushed to the browser, pending headers are sent too.
This function is supported when PHP is installed as an Apache module or by the NSAPI server module in Netscape/iPlanet/SunONE webservers.
PARAMETERS
o $filename
- The file that the virtual command will be performed on.
RETURN VALUES
Performs the virtual command on success, or returns FALSE on failure.
EXAMPLES
See apache_note(3) for an example.
NOTES
Warning
The query string can be passed to the included file but $_GET is copied from the parent script and only $_SERVER['QUERY_STRING'] is
filled with the passed query string. The query string may only be passed when using Apache 2. The requested file will not be listed
in the Apache access log.
Note
Environment variables set in the requested file are not visible to the calling script.
Note
This function may be used on PHP files. However, it is typically better to use include(3) or require(3) for PHP files.
SEE ALSO apache_note(3).
PHP Documentation Group VIRTUAL(3)