10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Team
I have files in different directories . How can i take the count of latest file and insert into Db2 table .
I am using
awk 'END{print NR+1-ARGC}' (File name)
to get the counts.
How can i take
1.The count of latest file
2.Insert into Db2 table( File Name and Counts) .
cd... (4 Replies)
Discussion started by: Perlbaby
4 Replies
2. UNIX and Linux Applications
Hi all,
I have a requirement to connect DB2 database and do some operations and generate a report through shell script.
Can anyone please tell me how can i connect DB2 from unix shell script?
Thanks in ADV. (2 Replies)
Discussion started by: gani_85
2 Replies
3. Shell Programming and Scripting
Hi ,
I Have following requirement:
DB2 Sql query to pass from a parameter file
for example, I would create a parameter file with (SELECT column 1, column 2 FROM Table name) then job would read it and create a file with the contents named table.txt
How to write/modify below ksh script to... (10 Replies)
Discussion started by: developer.dwh9
10 Replies
4. Shell Programming and Scripting
Guys,
I am trying to write a shell script that connect to wcsprod database and read the query
#!/bin/ksh
sqlplus -s < connect to wcsprod user wcsadm using pwd >
select * from catentry fetch first 1 row only with ur;
databse: wcsprod
user: wcsadm
pwd: pwd
thanks (1 Reply)
Discussion started by: skatpally
1 Replies
5. Shell Programming and Scripting
Hi
I am trying to connect to db2 database from Unix shell script (k shell)
I need to catch the status of connect whether it is succesful or not.
----------------------------------------------------------
# Read login credentials for db2
tput clear
echo "Please enter your Userid:\c"... (3 Replies)
Discussion started by: mKarri
3 Replies
6. Shell Programming and Scripting
I want to connect to DB2 database which is mainframes using a unix script and run query and get the result set into the unix box.
Is this acheivable using db2 connect? pls help me with a sample script which can perform the same. (1 Reply)
Discussion started by: midhun19
1 Replies
7. Shell Programming and Scripting
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Discussion started by: aemunathan
2 Replies
8. Shell Programming and Scripting
Can anyone please help me with an unix shell script to connect a DB2 database. My requirement is just to display the no of records present in a table of a DB2 database through Unix Shell script. Thx - Ram (1 Reply)
Discussion started by: onlyraja
1 Replies
9. Linux
Hello friends,
Assume that, I am trying to execute a "db2 connect" command from Linux shell prompt via a shell script called "sample"
sample
db2 connect to bas39
$sample
If the database is not present its should display a custom error message by catching the error message given by db2.... (1 Reply)
Discussion started by: frozensmilz
1 Replies
10. Shell Programming and Scripting
I am trying to connect to database db2 through shell script.
The process I am trying is
> db2
It gives me error Access Denied.
While checking for access I have the rights.
Is there ant other way round..?
Please help. (3 Replies)
Discussion started by: ankitgupta
3 Replies
YYFIX(1) BSD General Commands Manual YYFIX(1)
NAME
yyfix -- extract tables from y.tab.c
SYNOPSIS
yyfix file [tables]
DESCRIPTION
Programs have historically used a script (often named ``:yyfix'') to extract tables from the yacc(1) generated file y.tab.c. As the names of
the tables generated by the current version of yacc(1) are different from those of historical versions of yacc(1), the shell script yyfix is
provided to simplify the transition.
The first (and required) argument to yyfix is the name of the file where the extracted tables should be stored.
If further command line arguments are specified, they are taken as the list of tables to be extracted. Otherwise, yyfix attempts to deter-
mine if the y.tab.c file is from an old or new yacc(1), and extracts the appropriate tables.
The tables ``yyexca'', ``yyact'', ``yypact'', ``yypgo'', ``yyr1'', ``yyr2'', ``yychk'', and ``yydef'' are extracted from historical versions
of yacc(1).
The tables ``yylhs'', ``yylen'', ``yydefred'', ``yydgoto'', ``yysindex'', ``yyrindex'', ``yygindex'', ``yytable'', ``yyname'', ``yyrule'',
and ``yycheck'', are extracted from the current version of yacc(1).
FILES
y.tab.c File from which tables are extracted.
SEE ALSO
yacc(1)
HISTORY
The yyfix command first appeared in 4.4BSD.
BSD
March 23, 1993 BSD