09-11-2009
I think i got it right now. I was helped by the user "sanjay.login"
Thanks everybody.
10 More Discussions You Might Find Interesting
1. AIX
When I issue a "df" command the columns of the output are not aligned.
QMN012:.../oracle> df -k
Filesystem 1024-blocks Free %Used Iused %Iused Mounted on
/dev/hd4 524288 439592 17% 5423 6% /
/dev/M121A_HOME 3080192 2343764 24% 7263 2%... (1 Reply)
Discussion started by: marcogilbert
1 Replies
2. Solaris
Hi,
The following error message occured when I was trying to reboot my SUN machine:
Memory address not aligned
Its a Sun 280 R , Ultra SPARC III
What should I do.
Varma (3 Replies)
Discussion started by: gunnervarma
3 Replies
3. Shell Programming and Scripting
Hi
Need ur help for the below question.
I have two files File-1 & File-2.
File-1(This is a fixed file i.e. the content of this file is not going to change over a period of time)
------
a
b
c
d
e
File-2 (This is a file which changes daily but the record count remains the same)... (1 Reply)
Discussion started by: 46019
1 Replies
4. Shell Programming and Scripting
Hi All
I'm running a shell script and the output is something like:
Col1 Col2 Col3
aaaa aaaaaaa aaaaa
bbbbb bbbbb bbbbbb
ccc cccccc ccccccc
But I require the output to printed as given below:
Col1 Col2 Col3
aaaa ... (4 Replies)
Discussion started by: nkamalkishore
4 Replies
5. Shell Programming and Scripting
Hi,
Im writing a script to run a bit of sql(via sqlplus) that pulls back some data and spools it to a file, I want the spool file to only display the data, with no sql command at the top and no reports at the bottom ie(# of records recieved).
I am currently doing it via a grep command but... (1 Reply)
Discussion started by: Magezy
1 Replies
6. Shell Programming and Scripting
I do have a big file in the following format
>A1
ATGCGG
>A2
TCATGC
>A3
-TGCTG
The number of characters will be same under each subheader and only possible characters are A,T,G,C and -
I want to count the number of A's, T's,G's, C's & -'s vertically for all the positions so that I... (5 Replies)
Discussion started by: Lucky Ali
5 Replies
7. Shell Programming and Scripting
Hi All,
I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file.
Can you anyone pls let me know how do I do it and execute the awk script? Thanks. (4 Replies)
Discussion started by: adept
4 Replies
8. Shell Programming and Scripting
Heyas
I havent found a thread to introduce, so i combine it with the issue i have.
EDIT /* Removed Problem because solved */
My first contact with Linux was back in 1995 with slackware, beeing a gamer back then, i (sadly) didnt bother to dig deeper.
I finaly joined the Linux community in... (0 Replies)
Discussion started by: sea
0 Replies
9. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
10. Shell Programming and Scripting
Hi,
Anyone can help on how to re-aligned the data into one raw;
Input Text File:
TESTA Carbon A China 06/28/2016 Active Vol. 8210, No. 2048,
New Era 02/25/2010
... (1 Reply)
Discussion started by: fspalero
1 Replies
LEARN ABOUT PHP
mssql_query
MSSQL_QUERY(3) MSSQL_QUERY(3)
mssql_query - Send MS SQL query
SYNOPSIS
mixed mssql_query (string $query, [resource $link_identifier], [int $batch_size])
DESCRIPTION
mssql_query(3) sends a query to the currently active database on the server that's associated with the specified link identifier.
PARAMETERS
o $query
- An SQL query.
o $link_identifier
- A MS SQL link identifier, returned by mssql_connect(3) or mssql_pconnect(3). If the link identifier isn't specified, the last
opened link is assumed. If no link is open, the function tries to establish a link as if mssql_connect(3) was called, and use it.
o $batch_size
- The number of records to batch in the buffer.
RETURN VALUES
Returns a MS SQL result resource on success, TRUE if no rows were returned, or FALSE on error.
EXAMPLES
Example #1
mssql_query(3) example
<?php
// Connect to MSSQL
$link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
if (!$link || !mssql_select_db('php', $link)) {
die('Unable to connect or select database!');
}
// Do a simple query, select the version of
// MSSQL and print it.
$version = mssql_query('SELECT @@VERSION');
$row = mssql_fetch_array($version);
echo $row[0];
// Clean up
mssql_free_result($version);
?>
NOTES
Note
If the query returns multiple results then it is necessary to fetch all results by mssql_next_result(3) or free the results by
mssql_free_result(3) before executing next query.
SEE ALSO
mssql_select_db(3), mssql_connect(3).
PHP Documentation Group MSSQL_QUERY(3)