09-26-2008
need help with UNIX, awk and DB2
Hi i am working on a script which takes a parameter file as input . this parameter file is having SQL statements. I am fetching column names from the output of SQL file using following code:
while read Record1
do
SQLQuery=`echo $Record1 | awk '{printf $0 }'`
ColumnNamesSPcomma=`echo $Record1 | awk '{printf $4 }'`
echo $ColumnNamesSPcomma >>$3_$m_dt.csv
---
this is working fine
Now i need to add a statement in the SQL parameter file that i need to echo in the same output file $3_$m_dt.csv and i am using
-v "records rejected from ZGCTCD" in the SQL parameter file
But because of above code my script is only echoing word
"from" from the above statement...
can anybody help me with this ...
How to echo whole line by adding any it in SQL parameter file only rather than adding it into script..
Thanks in Advance
Last edited by manmeet; 09-26-2008 at 03:59 PM..
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to connect to DB2 through Unix and check whether the database is up or not. We are planning to use Neon shadow direct to connect to the same. I would like to know how to pass parameters to neon shadow direct. Any guidance/help in this regard would be helpful.
My unix box is AIX 1.
... (3 Replies)
Discussion started by: ranj@tcs
3 Replies
2. Shell Programming and Scripting
Guys Quick help...
----------------------------
#!/usr/bin/ksh
db2 -x "select count(*) from ${SCHEMA}.EMP"> $HOME/count.dat
COUNT=`cat $HOME/count.dat`
echo Table Count: $COUNT
if ( $COUNT -eq 0 ); then
echo Record Count in Table is 0
exit 1
fi
echo Records Exist... (2 Replies)
Discussion started by: freakygs
2 Replies
3. UNIX for Dummies Questions & Answers
Hi,
When i try to connect to the db2 database from unix solaris 5.8 version by typing "db2" from the .../sqllib/bin/ folder, i am not getting the db2 command prompt. Could anyone help me resolve this? Here the db2 is executable only. But still iam not getting the db2 prompt.
The error i get is... (4 Replies)
Discussion started by: ragavhere
4 Replies
4. Shell Programming and Scripting
Hi All,
Please help me out in executing the following db2 querry in unix
db2 "select AP_RQ_ACQ_INST_ID || ',' || txn_classifier || ',' || AP_RS_RESP_CD || ',' || (count(*) AS COUNT1) || ',' || (SUM(AP_RQ_TXN_AMT) AS TOTAL_AMT) from TXN_RECORD where
CREATE_TS > '2010-11-22 11:00:00.008645' ... (1 Reply)
Discussion started by: dudd9
1 Replies
5. Shell Programming and Scripting
Hi
I am extracting a column value(DESCRIPTION) from one table and passing it to another db2 statement in a shell code to fetch some value(ID) but the value when passed in where condition is taking as newline+value.
Please find the out put when executed:
+ echo description is ::::... (1 Reply)
Discussion started by: msp2244
1 Replies
6. Shell Programming and Scripting
I am currently trying to load data from e.txt into tablea. I am getting error.
db2 connect to qw01p user wcs using abc
db2 "LOAD CLIENT FROM /dswork/ECONT/output/interface/e.txt OF DEL MODIFIED BY coldel| SAVECOUNT 0 ROWCOUNT 0 WARNINGCOUNT 0 MESSAGES XTMPRTI1.txt
REPLACE into WCSADM.TABLEA... (1 Reply)
Discussion started by: skatpally
1 Replies
7. UNIX for Dummies Questions & Answers
I am new to Putty, Unix and DB2 and this is what I am working on right now.
I installed Putty
I got access to username / pwd
I got Unix usrname/Pwd.also got the home directory
once I login into putty I get the screen and it shows $ sign
From here how do I connect to DB2 database?
I have... (2 Replies)
Discussion started by: JayDoshi
2 Replies
8. Shell Programming and Scripting
Guys,
My Motive is, There are some View names in the file with the format of SCHEMA.VIEWNAMe,
I want to read the data from file and parse it to SCHEMA and VIEWNAME and execute DB2 command to get the base Table name.
I can parse easily through AWK but i could not execute db2 commands in... (1 Reply)
Discussion started by: Nandy
1 Replies
9. Shell Programming and Scripting
Hi ,
I am trying to use the below in awk but failed, any one assist please,
awk '{ print $0;
if ( $0 ~ /LOADTMP1/ )
{
print $4;
Table_name=system($( db2 -x "SELECT TRIM(TD.BSCHEMA) || '.' || TRIM(TD.BNAME) AS TABLE_NAME FROM SYSCAT.TABDEP TD WHERE
TD.BTYPE='T' AND... (2 Replies)
Discussion started by: Nandy
2 Replies
10. Shell Programming and Scripting
Hi,
I want to retrieve the base table name for a table and replace the table with the view name in the file.
I was trying to retrieve the base with the below db2 command but i am getting "1" as return value.
Could you anyone please assist ?
Table_name=system("db2 -x... (4 Replies)
Discussion started by: Nandy
4 Replies
LEARN ABOUT DEBIAN
sql::translator::producer::oracle
SQL::Translator::Producer::Oracle(3pm) User Contributed Perl Documentation SQL::Translator::Producer::Oracle(3pm)
NAME
SQL::Translator::Producer::Oracle - Oracle SQL producer
SYNOPSIS
use SQL::Translator;
my $t = SQL::Translator->new( parser => '...', producer => 'Oracle' );
print $translator->translate( $file );
DESCRIPTION
Creates an SQL DDL suitable for Oracle.
producer_args
delay_constraints
This option remove the primary key and other key constraints from the CREATE TABLE statement and adds ALTER TABLEs at the end with it.
quote_field_names
Controls whether quotes are being used around column names in generated DDL.
quote_table_names
Controls whether quotes are being used around table, sequence and trigger names in generated DDL.
NOTES
Autoincremental primary keys
This producer uses sequences and triggers to autoincrement primary key columns, if necessary. SQLPlus and DBI expect a slightly different
syntax of CREATE TRIGGER statement. You might have noticed that this producer returns a scalar containing all statements concatenated by
newlines or an array of single statements depending on the context (scalar, array) it has been called in.
SQLPlus expects following trigger syntax:
CREATE OR REPLACE TRIGGER ai_person_id
BEFORE INSERT ON person
FOR EACH ROW WHEN (
new.id IS NULL OR new.id = 0
)
BEGIN
SELECT sq_person_id.nextval
INTO :new.id
FROM dual;
END;
/
Whereas if you want to create the same trigger using "do" in DBI, you need to omit the last slash:
my $dbh = DBI->connect('dbi:Oracle:mysid', 'scott', 'tiger');
$dbh->do("
CREATE OR REPLACE TRIGGER ai_person_id
BEFORE INSERT ON person
FOR EACH ROW WHEN (
new.id IS NULL OR new.id = 0
)
BEGIN
SELECT sq_person_id.nextval
INTO :new.id
FROM dual;
END;
");
If you call this producer in array context, we expect you want to process the returned array of statements using DBI like "deploy" in
DBIx::Class::Schema does.
To get this working we removed the slash in those statements in version 0.09002 of SQL::Translator when called in array context. In scalar
context the slash will be still there to ensure compatibility with SQLPlus.
CREDITS
Mad props to Tim Bunce for much of the logic stolen from his "mysql2ora" script.
AUTHORS
Ken Youens-Clark <kclark@cpan.org>, Alexander Hartmaier <abraxxa@cpan.org>, Fabien Wernli <faxmodem@cpan.org>.
SEE ALSO
SQL::Translator, DDL::Oracle, mysql2ora.
perl v5.14.2 2012-01-18 SQL::Translator::Producer::Oracle(3pm)