How to eliminate OR clause when joining tables? Post: 302962273

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Converting tables of row data into columns of tables

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:...

2. UNIX for Dummies Questions & Answers

if clause

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. Shell Programming and Scripting

Dynamic SQL for where clause

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....

4. Shell Programming and Scripting

multiple conditions in 'if clause'

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...

5. Shell Programming and Scripting

How to eliminate ^L

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...

6. Shell Programming and Scripting

Use a shell variable in where clause

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: $>...

7. Shell Programming and Scripting

If clause in perl

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...

8. Shell Programming and Scripting

../ in perl and if clause

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 ) { ...

9. Shell Programming and Scripting

How to search for a directory with if clause?

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...

10. Shell Programming and Scripting

If clause query

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...

LEARN ABOUT DEBIAN

fribidi_get_joining_type

fribidi_get_joining_type(3)					Programmer's Manual				       fribidi_get_joining_type(3)

NAME

       fribidi_get_joining_type - get character joining type

SYNOPSIS

       #include <fribidi.h>

       FriBidiJoiningType fribidi_get_joining_type(FriBidiChar ch);

PARAMETERS

       FriBidiChar ch
	      Input character.

DESCRIPTION

       This function returns the joining type of a character as defined in Table 8-2 Primary Arabic Joining Classes of the Unicode standard avail-
       able at http://www.unicode.org/versions/Unicode4.0.0/ch08.pdf#G7462, using data provided in file ArabicShaping.txt and  UnicodeData.txt	of
       the  Unicode  Character	Database  available  at  http://www.unicode.org/Public/UNIDATA/ArabicShaping.txt  and  http://www.unicode.org/Pub-
       lic/UNIDATA/UnicodeData.txt.

       There are a few macros defined in fribidi-joining-types.h for querying a joining type.

RETURNS

       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.

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_types(3),  fribidi_get_joining_type_name(3),
       fribidi_get_mirror_char(3), fribidi_shape_mirroring(3), fribidi_shape(3)

GNU FriBidi 0.19.2						  30 January 2006				       fribidi_get_joining_type(3)