08-18-2008
Description...?!
Well,
This table is used in billing at a telecommunications company, so it contains all subscribers' tel. numbers and bill amounts, bill dates,... supposedly.
if i only select the subno column and redirect to a file i might have to wait for about 5 min for all the contents of the file to be concatenated on screen.
I am using sqlplus in unix, yes..
thank you a lot
for your help!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I am working on a code to extract the table names out of a select statement. Is there anybody who has worked on something similar? May be you could provide me with the regular expression for the same.
Regards.
Silas (2 Replies)
Discussion started by: silas.john
2 Replies
2. Shell Programming and Scripting
Hi,
Can anyone tell me how to print the column name anong with the value from the table in shell script e.g
#!/bin/ksh
var=`sqlplus scott/tiger << -e
set heading off feedback off
select * from emp;
quit;
e`
echo $var
My output should be;
... (5 Replies)
Discussion started by: thana
5 Replies
3. UNIX for Dummies Questions & Answers
Using ksh and sqlplus... does anybody have an idea of how we can possibly extract all table names from server :confused:?
thanks in advance. (6 Replies)
Discussion started by: fmina
6 Replies
4. UNIX for Dummies Questions & Answers
need some advice on the following situation.
I have a DB2 table which has a varchar Column. This varchar column can have special characters like ©, ®, ™ .
When I extract from this table to a sequential file for this varchar column I am only able to get © and ® .
To Get the ™... (1 Reply)
Discussion started by: cosec
1 Replies
5. Shell Programming and Scripting
Hi all,
I am using the following code in order to access the data of a table:
my $sql = qq{ SELECT * FROM cc_test_cases};
$sth = $dbh->prepare( $sql );
$sth->execute( );
while(@row1 = $sth->fetchrow_array()) {
# print "$row1: $row1\n";
print "@row1\n";
#print("THE VALUE... (1 Reply)
Discussion started by: chriss_58
1 Replies
6. Shell Programming and Scripting
Hi,
I have the following requirement.
I have a unix table as below
progname par1 par2 par3 par4
PROG1 abc def 0012 ooo
PROG2 wed xas 0100 xxx
PROG3 kkk ppp 0004 ppp
Different programs(ex:PROG1,PROG2..) accesses this table and update... (5 Replies)
Discussion started by: thanuman
5 Replies
7. Programming
Hi,
I need a sql statement for a table, which simply stores a text. It has a column ID, key1, key2, ..., text, date etc. The text can be entered using a line break (return) in an oracle form.
ID key1 key2 text date
1 K1 ... (16 Replies)
Discussion started by: spidermike
16 Replies
8. UNIX for Dummies Questions & Answers
Hi Guys,
Can any one help me on this,
I want to write unix command to get all .sh unix file name which are refered .sql files in it.
Thanks
Kolipaka (3 Replies)
Discussion started by: lakshmanrk811
3 Replies
9. UNIX and Linux Applications
Hello All,
I'm trying to spool an oracle table data into a csv file on unix server but the complete record is not being extracted. The record is almost 1000 characters but only 100 characters are being extracted and rest of the data getting truncated.
I'm setting below options :
SET... (4 Replies)
Discussion started by: venkat_reddy
4 Replies
10. Shell Programming and Scripting
need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix)
i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable.
isql -v DSN USERNAME PASSWD
... (6 Replies)
Discussion started by: pimmit22043
6 Replies
LEARN ABOUT PHP
pharfileinfo.setmetadata
PHARFILEINFO.SETMETADATA(3) 1 PHARFILEINFO.SETMETADATA(3)
PharFileInfo::setMetadata - Sets file-specific meta-data saved with a file
SYNOPSIS
public void PharFileInfo::setMetadata (mixed $metadata)
DESCRIPTION
PharFileInfo.setMetadata(3) should only be used to store customized data in a file that cannot be represented with existing information
stored with a file. Meta-data can significantly slow down the performance of loading a phar archive if the data is large, or if there are
many files containing meta-data. It is important to note that file permissions are natively supported inside a phar; it is possible to set
them with the PharFileInfo.chmod(3) method. As with all functionality that modifies the contents of a phar, the phar.readonly INI variable
must be off in order to succeed if the file is within a Phar archive. Files within PharData archives do not have this restriction.
Some possible uses for meta-data include passing a user/group that should be set when a file is extracted from the phar to disk. Other
uses could include explicitly specifying a MIME type to return. However, any useful data that describes a file, but should not be contained
inside of it may be stored.
PARAMETERS
o $metadata
- Any PHP variable containing information to store alongside a file
RETURN VALUES
No value is returned.
EXAMPLES
Example #1
A PharFileInfo.setMetadata(3) example
<?php
// make sure it doesn't exist
@unlink('brandnewphar.phar');
try {
$p = new Phar(dirname(__FILE__) . '/brandnewphar.phar', 0, 'brandnewphar.phar');
$p['file.txt'] = 'hello';
$p['file.txt']->setMetadata(array('user' => 'bill', 'mime-type' => 'text/plain'));
var_dump($p['file.txt']->getMetaData());
} catch (Exception $e) {
echo 'Could not create/modify phar: ', $e;
}
?>
The above example will output:
array(2) {
["user"]=>
string(4) "bill"
["mime-type"]=>
string(10) "text/plain"
}
SEE ALSO
PharFileInfo.hasMetadata(3), PharFileInfo.getMetadata(3), PharFileInfo.delMetadata(3), Phar.setMetadata(3), Phar.hasMetadata(3), Phar.get-
Metadata(3).
PHP Documentation Group PHARFILEINFO.SETMETADATA(3)