10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi frndz,
Can anyone provide me some input or pseudo code for my req as mentioned below...
I am loading 2 files through unix script into oracle table...as i am doing some updates also i am getting an error where both files try to update the table simultaneously and my script fails..
so i... (3 Replies)
Discussion started by: gnnsprapa
3 Replies
2. Shell Programming and Scripting
Hello All,
i have a file sort.txt with below entries.
1 12 10
16 6 4
20 8 15
i need to sort these entries and the out put should come in a single line.
1 4 6 8 10 12 15 16 20
Can you please help me sort this out? (2 Replies)
Discussion started by: sureshk_85
2 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I just downloaded this example from the net. I was looking around for a hash table like implementation in unix when I came across this.
ARRAY=( "cow:moo"
"dinosaur:roar"
"bird:chirp"
"bash:rock" )
for animal in ${ARRAY} ; do
KEY=${animal%%:*}
... (8 Replies)
Discussion started by: anindyabecs
8 Replies
4. UNIX for Dummies Questions & Answers
I need to create a simple table of information by grepping several columns from various files and display them all at once with simple headers on top. Can anyone help get me started? I am very new to unix so I really have no idea how to work with this and I appreciate any help I can get! Let me... (11 Replies)
Discussion started by: aj250
11 Replies
5. Shell Programming and Scripting
#!/bin/sh
echo Enter the multiplication number required:
read number
for i in 1 2 3 4 5 6 7 8 9 10
do
echo "$number * $i = expr $number \* $i"
done
I am not getting the output for this multiplication table. (4 Replies)
Discussion started by: vinodpaw
4 Replies
6. Shell Programming and Scripting
Hi,
I am trying to insert a record into a table (say dips_tbl) which resides in Oracle DB through a ksh script. I want to insert records into few of the table columns-not all. I'll give an e.g. for the date column "CREATE_DATE".
For that I first execute
SQL1="SELECT SYSDATE FROM DUAL"
... (1 Reply)
Discussion started by: dips_ag
1 Replies
7. UNIX for Dummies Questions & Answers
I need help to produce output as below
1 2 3 4 5
2 4 6 8 10
3 6 9 12 15
4 8 12 16 20
5 10 15 20 25
my script
#!/bin/bash
for (( i = 1; i <= 5; ++i ));
do
echo -n $i
for (( j = 1; j <=5; ++j ));
do
multiply=$(( $i * $j ))
done
echo $multiply (1 Reply)
Discussion started by: killboy
1 Replies
8. Shell Programming and Scripting
Hi All,
In a given directory, I need to list the files present in it in the below given format as a table.
File name Permission Number of Bytes File Type
Telecom1 --w-r-x 1230 Directory
Telecom2 ---x---x---x 450 Device file
Telecom3 ... (7 Replies)
Discussion started by: mr_manii
7 Replies
9. Shell Programming and Scripting
Hi ,
Can anyone help me regarding loading a unix file data to oracle database table using shell scripts?
I wanted to grep only this data from a spool file
sql_test.txt
99
00:00:00:01
but if I use grep I am getting format
sql_test.txt
99 rows selected.
Elapsed:... (2 Replies)
Discussion started by: ran16
2 Replies
10. Programming
hi ,
How to view the contents of a "c" program symbol table information in unix. (1 Reply)
Discussion started by: saravanan_nitt
1 Replies
DB2_TABLES(3) 1 DB2_TABLES(3)
db2_tables - Returns a result set listing the tables and associated metadata in a database
SYNOPSIS
resource db2_tables (resource $connection, [string $qualifier], [string $schema], [string $table-name], [string $table-type])
DESCRIPTION
Returns a result set listing the tables and associated metadata in a database.
PARAMETERS
o $connection
- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
o $qualifier
- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
o $schema
- The schema which contains the tables. This parameter accepts a search pattern containing _ and % as wildcards.
o $table-name
- The name of the table. This parameter accepts a search pattern containing _ and % as wildcards.
o $table-type
- A list of comma-delimited table type identifiers. To match all table types, pass NULL or an empty string. Valid table type iden-
tifiers include: ALIAS, HIERARCHY TABLE, INOPERATIVE VIEW, NICKNAME, MATERIALIZED QUERY TABLE, SYSTEM TABLE, TABLE, TYPED TABLE,
TYPED VIEW, and VIEW.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the tables that match the specified parameters. The rows are
composed of the following columns:
+------------+---------------------------------------------------+
|Column name | |
| | |
| | Description |
| | |
+------------+---------------------------------------------------+
| TABLE_CAT | |
| | |
| | The catalog that contains the table. The value is |
| | NULL if this table does not have catalogs. |
| | |
|TABLE_SCHEM | |
| | |
| | Name of the schema that contains the table. |
| | |
|TABLE_NAME | |
| | |
| | Name of the table. |
| | |
|TABLE_TYPE | |
| | |
| | Table type identifier for the table. |
| | |
| REMARKS | |
| | |
| | Description of the table. |
| | |
+------------+---------------------------------------------------+
SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_spe-
cial_columns(3), db2_statistics(3), db2_table_privileges(3).
PHP Documentation Group DB2_TABLES(3)
