Sponsored Content
Top Forums UNIX for Dummies Questions & Answers SQL statement is not work on unix script Post 302610105 by happyv on Wednesday 21st of March 2012 12:19:30 AM
Old 03-21-2012
SQL statement is not work on unix script

Hi,

I have the following basic script. However, the statement (line 5) is not work. The output data is not able to set my request format a30. Any advise? Smilie

echo " Column filename format a30"|sqlplus4

echo Input file list to check:
read filelist
for file in `cat $filelist.txt`
do
echo " Column filename format a30"|sqlplus4
echo "select FILENAME from FILE_TABLE where filename like '${file}'%;" >> output_file.txt
done
echo Completed Check!!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Executing a Oracle SQL statement in a UNIX script

Hi All, I need to select one column from a table based upon the passed in parameter. I tried this: sqlplus -silent $MISP_USER << EOF set feedback off; set verify off; set sqlprompt "" SELECT mail_flag FROM dailyjobs WHERE job_name = '$1'; exit 0 EOF exit... (1 Reply)
Discussion started by: ganga.dharan
1 Replies

2. Shell Programming and Scripting

using SELECT sql statement in shell script

Hi there I have a database on a remote box and i have been using shell script to insert data into it for example, i could have a script that did this SN=123456 n=server1 m=x4140 sql="UPDATE main SET hostname='$n',model='$m' WHERE serial='$SN';" echo $sql |/usr/sfw/bin/mysql -h... (4 Replies)
Discussion started by: hcclnoodles
4 Replies

3. Shell Programming and Scripting

How to call an sql script inside a while statement in KSH

Hi all, I'm trying to run an sql inside a loop which looks like this #!bin/ksh while IFS=, read var1 var2 do sqlplus -s ${USERNAME}/${PASSWORD}@${ORACLE_SID} << EOF insert into ${TABLE} ( appt_date ) values ( '${var1 }' ); ... (6 Replies)
Discussion started by: ryukishin_17
6 Replies

4. Shell Programming and Scripting

Unix shell command output to a sql statement

Can i do this Say one command sed 's/:*/ /g' $summf is returning C1234 C2345 C3434 some no of rows, now this ouput i have to insert it into a DB table how do i do this?? (2 Replies)
Discussion started by: depakjan
2 Replies

5. Shell Programming and Scripting

Read SQL statement in Script

Hi Guys.. need some urgent help... I am stuck in something badly I need to write a script which would read a sql statement (which might be a join/inner join/select/sub select etc. ) I need to read that sql statement ... and in the output I want all the table names and columns (doesn't... (4 Replies)
Discussion started by: freakygs
4 Replies

6. UNIX for Dummies Questions & Answers

unix script with SQL statement problem

Hello, I have a script to get the information from database, however, it's look like the loop is not work, can someone help? :confused: echo Input file list to check: read filelist for file in 'cat $filelist.txt' do echo "select FILENAME from FILE_TABLE where filename like '${file}'%;" >>... (9 Replies)
Discussion started by: happyv
9 Replies

7. Shell Programming and Scripting

UNIX variable to SQL statement

The following is my script : #!/bin/bash echo "please give app_instance_id" read app_instance_id echo "id is $app_instance_id" export app_id=app_instance_id sqlplus -s nnviewer/lookup@//nasolora008.enterprisenet.org:1521/LOAD3 @test.sql<<EOF SPOOL /home/tibco/MCH/Data/qa/raak/name.xls... (4 Replies)
Discussion started by: raakeshr
4 Replies

8. Shell Programming and Scripting

Korn shell script - SQL statement challenges

Hi scripting experts. I have some coding challenges that I'm hoping you can help me out. I have one file#1 that contains the following sql statement that spans over multiple lines: sql Select /*+ use_has(a,b) */ * from customer a, customer_address b where a.id = b.id... (1 Reply)
Discussion started by: pchang
1 Replies

9. Shell Programming and Scripting

How to create SQL statement out of data using shell script?

Table TAB1 contains following example data (its a tree sitting in table data format & its driven based CHILD & PARENT column pick the RULE condition to generate the below SQL: CHILD PARENT SS MID MNM VNM RULE FLG 1 ? S1 ? ? V1 rule004 I 2 1 S1 ? ? V1 0 Z 3 1 S1 ? ? V1 1 Z ... (6 Replies)
Discussion started by: gksenthilkumar
6 Replies

10. Shell Programming and Scripting

UNIX Sqlplus - Capture the sql statement about to run and execution status

Greetings Experts, I am on AIX using ksh. Created a unix script which generates the CREATE OR REPLACE VIEW ... and GRANT .. statements, which are placed in a single .txt file. Now I need to execute the contents in the file (there are around 300 view creation and grant statements) in Oracle and... (4 Replies)
Discussion started by: chill3chee
4 Replies
LOCALE_GET_DISPLAY_LANGUAGE(3)						 1					    LOCALE_GET_DISPLAY_LANGUAGE(3)

Locale::getDisplayLanguage - Returns an appropriately localized display name for language of the inputlocale

	Object oriented style

SYNOPSIS
publicstatic string Locale::getDisplayLanguage (string $locale, [string $in_locale]) DESCRIPTION
Procedural style string locale_get_display_language (string $locale, [string $in_locale]) Returns an appropriately localized display name for language of the input locale. If is NULL then the default locale is used. PARAMETERS
o $locale - The locale to return a display language for o $in_locale - Optional format locale to use to display the language name RETURN VALUES
display name of the language for the $locale in the format appropriate for $in_locale. EXAMPLES
Example #1 locale_get_display_language(3) example <?php echo locale_get_display_language('sl-Latn-IT-nedis', 'en'); echo "; "; echo locale_get_display_language('sl-Latn-IT-nedis', 'fr'); echo "; "; echo locale_get_display_language('sl-Latn-IT-nedis', 'de'); ?> Example #2 OO example <?php echo Locale::getDisplayLanguage('sl-Latn-IT-nedis', 'en'); echo "; "; echo Locale::getDisplayLanguage('sl-Latn-IT-nedis', 'fr'); echo "; "; echo Locale::getDisplayLanguage('sl-Latn-IT-nedis', 'de'); ?> The above example will output: Slovenian; slovxc3xa8ne; Slowenisch SEE ALSO
locale_get_display_name(3), locale_get_display_script(3), locale_get_display_region(3), locale_get_display_variant(3). PHP Documentation Group LOCALE_GET_DISPLAY_LANGUAGE(3)
All times are GMT -4. The time now is 11:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy