12-10-2015
I don't know Teradata syntax, but maybe you could split up that query into two parts: (1) join "a" and "c" and (2) join "b" and "c". Then combine the results.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: justthisguy
7 Replies
2. UNIX for Dummies Questions & Answers
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)
Discussion started by: palmer18
3 Replies
3. Shell Programming and Scripting
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)
Discussion started by: TeSP
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: shrutihardas
2 Replies
5. Shell Programming and Scripting
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)
Discussion started by: ramkiran77
11 Replies
6. Shell Programming and Scripting
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)
Discussion started by: Jayaraman
4 Replies
7. Shell Programming and Scripting
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)
Discussion started by: ptappeta
1 Replies
8. Shell Programming and Scripting
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)
Discussion started by: ptappeta
3 Replies
9. Shell Programming and Scripting
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)
Discussion started by: Pramod_009
1 Replies
10. Shell Programming and Scripting
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 CENTOS
fribidi_get_joining_types
fribidi_get_joining_types(3) Programmer's Manual fribidi_get_joining_types(3)
NAME
fribidi_get_joining_types - get joining types for an string of characters
SYNOPSIS
#include <fribidi.h>
void fribidi_get_joining_types
(
const FriBidiChar *str,
const FriBidiStrIndex len,
FriBidiJoiningType *jtypes
);
PARAMETERS
const FriBidiChar *str
Input string.
const FriBidiStrIndex len
Input string length.
FriBidiJoiningType *jtypes
Output joining types.
Possible values for a FriBidiJoiningType are as follows:
FRIBIDI_JOINING_TYPE_U NUn-joining, e.g. Full Stop.
FRIBIDI_JOINING_TYPE_R Right-joining, e.g. Arabic Letter Dal.
FRIBIDI_JOINING_TYPE_D Dual-joining, e.g. Arabic Letter Ain.
FRIBIDI_JOINING_TYPE_C Join-Causing, e.g. Tatweel, ZWJ.
FRIBIDI_JOINING_TYPE_T Transparent, e.g. Arabic Fatha.
FRIBIDI_JOINING_TYPE_L Left-joining, i.e. Fictional.
FRIBIDI_JOINING_TYPE_G IGnored, e.g. LRE, RLE, ZWNBSP.
DESCRIPTION
This function finds the joining types of an string of characters. See fribidi_get_joining_type for more information about the joining
types returned by this function.
SEE ALSO
fribidi_charset_to_unicode(3), fribidi_unicode_to_charset(3), fribidi_parse_charset(3), fribidi_shape_arabic(3), fribidi_get_par_direc-
tion(3), fribidi_get_par_embedding_levels(3), fribidi_reorder_line(3), fribidi_get_bidi_type(3), fribidi_get_bidi_types(3),
fribidi_get_bidi_type_name(3), fribidi_debug_status(3), fribidi_mirroring_status(3), fribidi_set_mirroring(3), fribidi_reorder_nsm_sta-
tus(3), fribidi_set_reorder_nsm(3), fribidi_log2vis_get_embedding_levels(3), fribidi_get_type(3), fribidi_get_type_internal(3),
fribidi_remove_bidi_marks(3), fribidi_log2vis(3), fribidi_join_arabic(3), fribidi_get_joining_type(3), fribidi_get_joining_type_name(3),
fribidi_get_mirror_char(3), fribidi_shape_mirroring(3), fribidi_shape(3)
GNU FriBidi 0.19.3 25 August 2012 fribidi_get_joining_types(3)