I have q tricky question when joining 3 tables in Teradata DB.In the last line of my query , I am comparing one condition with C an B tables and its creating performance issue in returning the data . Basically I want to eliminate OR clause and try other approach.Is there any logic to satisfy this condition . Thanks in advance
Code:
[SEL * FROM
( SEL ORD_ID,NUM ,DATE
from TABLE1 ) A
ON ORD_ID is NOT NULL
LEFT JOIN
(
SELECT ORD_ID,NUM,DATE ,Contract_ID
FROM TABLE2) B
ON ORD_ID is NOT NULL
LEFT JOIN
( SELECT ORD_ID,NUM,DATE ,Contract_ID
FROM TABLE3 ) C
ON (A.ORD_ID=C.ORD_ID
AND A.NUM=C.NUM)
OR ( C.Contract_ID=B.Contract_ID)
]
Last edited by Scrutinizer; 12-09-2015 at 02:25 PM..
Reason: code tags
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
hi,
pls could you help me with one program in KSH ( i have sunOS).
I need to create an If clause, that prints an error message and filenames, when in a directory are found some files of null size (find . -type f -size 0 ).
thanks (3 Replies)
Hi,
I have an app which user can query the database based on 4 criteria, that is Field1, Field2, Field3 and Field4
Mya I know how to write a dynamic SQL where I can choose to retrieve data based on their selected value.
eg. where Field1=AAA
eg. where Field1=AAA and Field2=BBB
eg.... (1 Reply)
Hi,
When i use the below code snippet in my shell script OFC_10.sh:
if
then
echo "Success"
exit 2
elif
then
echo "Failure"
exit 6
I get the error message:
./OFC_10.sh: line 41: '
./OFC_10.sh: line 45: '
Line 41 is the line where If loop starts and line 45 is... (2 Replies)
Hi,
I am trying to create a text file from data retrieved from a query.The data retrieved is having this character '^L' at regular intervals of the data.
How can i eliminate this, Please find below the sample data.
I tried sed -e "s/\^L//g" to convert it, but with no luck
^LCODE*SERIAL... (11 Replies)
Hi all,
I want to use a variable inside my sql query and below is my script:
#!/bin/ksh
export b="abcd"
a=`sqlplus -s abc/def@ghi <<++
set heading off;
set feedback off;
select xxx from mytable where clmn_nm='$b';
exit;
++`
echo $a
But the output i get is below:
$>... (4 Replies)
HI friends ,
I am very new to perl .please dont mind if i ask silly questions.
I seee below code in one sript
if ( exists $ENV{FMTWRP_TMP_DIR} and $ENV{FMTWRP_TMP_DIR} ) {
$tdir = $ENV{FMTWRP_TMP_DIR};
}
whats does this mean .
I am very confused about the if clauses in... (1 Reply)
Hi
can anyone please explain what the below code does?
i mean $fide_stopfile = ?
when $FIDE_SCR = '/fs/dir1/dir2/common/scr'
and also little confused with if clause too.
what it check?
$fide_stopfile = "$ENV{FIDE_SCR}/../tmp/STOP";
if ( -e $fide_stopfile > 0 ) {
... (3 Replies)
Hello All,
I want to do a conditional search for a directory, i.e
pathname=/abc/def
foldername=xyz
if ( $pathname/$foldername/aaa )
then
..................
fi
Here i am searching for aaa directory inside the path and if it exist then it should go inside the loop.
Can... (1 Reply)
Hi,
i need to add a condition in my IF clause where i need to check if the file exists in a folder and return true out of it. but in my directory i have multiple files with same name but datestamp append on it for e.g.
export f1 = filename
export f2=filename1
if ]
then
echo "No... (9 Replies)
Discussion started by: rohit_shinez
9 Replies
LEARN ABOUT DEBIAN
sary
SARY(1) Sary SARY(1)NAME
sary - manual page for sary 1.0.2
SYNOPSIS
sary [OPTION]... PATTERN FILE
DESCRIPTION -c, --count
only print a count of occurrences
-i, --ignore-case
ignore case distinctions
-l, --lexicographical
sort in lexicographical order
-A, --after-context=NUM
print NUM lines of trailing context
-B, --before-context=NUM
print NUM lines of leading context
-C, --context=[NUM],
print NUM (default 2) lines of output context
-s, --start=TAG,
print tagged region. set start tag to TAG
-e, --end=TAG,
print tagged region. set end tag to TAG
-h, --help
display this help and exit
COPYRIGHT
Copyright (C) 2000 Satoru Takabayashi All rights reserved.
This is free software; you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by
the Free Software Foundation; either version 2.1, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MER-
CHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more details.
sary 1.0.2 December 2000 SARY(1)