I am using below code to connect terdata and getting the query result in a file.Now i want to use same code for different tables,plz tell me how to pass table name as parameter.i tried using as below code but not working.
Code:
bteq < /download/viv/dev/ops/Scripts/ter.sh FLTORGTKR_ORG_etc..
.bteq
.LOGMECH ldap
.LOGON idwaa.card.XXyyzz.com/r525355,#Aadha2;
.Set Echoreq off
.Set Titledashes off
.Set Separator '|'
.Set Format off
.Set Null ''
.EXPORT REPORT FILE =/download/icdwaa/dev5/ops/Scripts/viv.dat
select count(*) FROM $1;
.EXPORT RESET
.LOGOFF
.QUIT
Moderator's Comments:
edit by bakunin: set the CODE-tag to the right place.
Last edited by vbe; 04-04-2014 at 10:54 AM..
Reason: anonymized...
Hi,
Can i pass a parameter(not a file name) as a parameter to a awk program?
eg;
$awk -f test 1 2 3
here test is the filename...and 1,2,3 are the i/p parameters?
thank you:-) (2 Replies)
i am calling a pl/sql procedure through a shell script, there is one IN and 2 OUT parameter required to pass to the procedure to execute..
My procedure is XX_CITIDIRECT_EXP_PKG.main_proc and In parameter is p_period which I wanto to pass 'MAY-06'.
Can anyone figure out, whats is wrong here
... (4 Replies)
I have something like
cp -p <dir>filename1.dat <dir2>filename1.dat
there are many other operations in it
I mean that filename1.dat will keep on changing
I need to write a subroutine so that i can pass filename1 or 2 or 3 .dat as parameter
Thanking you in advance
Any help wuld be appreciated (2 Replies)
Hello
I have a simple code like this one:
#!/bin/ksh
VER=$1
cat /usr/text | while read line
do
echo $line
done
Let's say $1=1.0.0 and the contents of text is:
abcd.cfg
asdf
I would like the output to be like this
abcd1.0.0.cfg
asdf1.0.0
I am thinking of passing the... (5 Replies)
Hi,
I am new in Ubuntu, I will be glud to know:
1. How to pass a parameter from the terminal to a file that I write in shell script. What is the command line I need to write in the terminal?
2. How to get the parameter in the file? What do I need to write in the file?
3. What kind of file is... (1 Reply)
Hi,
How to pass parameter to run folloing script?
#parameters are div, dept, style
U run_convert_pdm.ksh Mens 44 7542
U run_convert_pdm.ksh "Mens Knit" 44 7541
The first command works fine but the second needs to have two words together , it does not work even if
I have used double... (15 Replies)
My script(ksh) works fine for
---------------------------------------------------
sed -n '28,31p' ${l_name} >> ${LOG_DIR}/Email.txt
---------------------------------------------------
But I wand to pass parrmeter to this syntax
I did the following things ... (14 Replies)
Hi,
I have following for loop , please let me know how to get ${TXP_EXT_TABLE_${i}_SQL} parameter with 1DAY and 7DAY values.
for i in 1DAY 7DAY
do
${NZSQL_DIR}/nzsql -h ${HOST} -time -v ON_ERROR_STOP=1 -f ${SQL_DIR}/${TXP_EXT_TABLE_${i}_SQL} > ${TMP_LOG_FILE} 2>&1
done
... (4 Replies)
Discussion started by: sandy162
4 Replies
LEARN ABOUT PHP
db2_tables
DB2_TABLES(3) 1 DB2_TABLES(3)db2_tables - Returns a result set listing the tables and associated metadata in a databaseSYNOPSIS
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)