Sponsored Content
Top Forums Shell Programming and Scripting Problem in passing IFS array to SQL Query Post 303025326 by yuvi on Tuesday 30th of October 2018 05:13:12 PM
Old 10-30-2018
Awesome! It is resolved. I was really trying from 2 days to find out.... Thank you so much for the link.
These 2 Users Gave Thanks to yuvi For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

problem with IFS

hi, :) I set IFS=":" But when i try to echo $IFS,i am not getting any thing on the screen escept a blank line. any help pls. cheers RRK (11 Replies)
Discussion started by: ravi raj kumar
11 Replies

2. Shell Programming and Scripting

Problem while storing sql query value in a variable

Hi, When i execute the below statement , the value is not getting stored in the variable. AnneeExercice=`sqlplus $LOGSQL/$PASSWORDSQL << FIN >> $GEMOLOG/gemo_reprev_reel_data_ventil_$filiale.trc SELECT bi09exercice FROM bi09_scenario WHERE bi09idfiliale=UPPER('de') AND ... (1 Reply)
Discussion started by: krishna_gnv
1 Replies

3. Shell Programming and Scripting

Problem in Passing sql query for a script

Unix prompt ========= echo "Enter the query" read q ========== User has entered : SELECT * FROM employee ===================== Now the problem starts.. echo $q Output: SELECT "all files names in the PWD" FROM employee ================================================ ... (5 Replies)
Discussion started by: Niroj
5 Replies

4. Shell Programming and Scripting

sql query problem

Hi, I am passing an argument for the script and that argument values should exist in database. bill_period_input="'""$1""'" bill_period=`sqlplus uname/pwd@dbname <<eof! set verify off set heading off set feedback off select bill_period from bill_period_ref where... (4 Replies)
Discussion started by: ss_ss
4 Replies

5. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies

6. UNIX for Advanced & Expert Users

Passing Hash variable in to sql query in perl

Hi Everyone, Can anyone help me how do i call hash variable in to sql query in perl. Please see the script below i have defined two Hash %lc and %tab as below $lc{'REFF'}='V_RES_CLASS'; $lc{'CALE'}='V_CAP_CLASS'; $lc{'XRPD'}='V_XFMR_CLASS'; $tab{'V_RES_CLASS'}='V_MFR_SERS';... (6 Replies)
Discussion started by: jam_prasanna
6 Replies

7. Shell Programming and Scripting

problem in SQL query

I used the following code code select * from tablename where columnname Instead of printing the expected output it prints all the files in the present directory since there is a "*" in the code. Is there any way to overcome the problem? Thanks Ananth (2 Replies)
Discussion started by: Ananthdoss
2 Replies

8. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

Hi Guys.. Need your help to format the output of my shell script. I am using spool command to take out put in csv file. below is my code. (for example) col USERNAME for a15 col EMAIL for a30 col FULL_NAME for a20 col LAST_LOGIN for a40 col DATE_CREATED for a40 SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies

9. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies

10. Shell Programming and Scripting

Taking information from a postgres sql query and putting it into a shell script array

I have a postgres sql statement that is the following: select age from students; which gives me the entries: Age --- 10 15 13 12 9 14 10 which is about 7 rows of data. Now what I would like to do with this is use a shell script to create an array age. As a results... (3 Replies)
Discussion started by: JSNY
3 Replies
symlink(2)							System Calls Manual							symlink(2)

NAME
symlink - Makes a symbolic link to a file SYNOPSIS
#include <unistd.h> int symlink ( const char *path1, const char *path2 ); STANDARDS
Interfaces documented on this reference page conform to industry standards as follows: symlink(): XSH5.0 Refer to the standards(5) reference page for more information about industry standards and associated tags. PARAMETERS
Specifies the contents of the symbolic link to create. Names the symbolic link to be created. DESCRIPTION
The symlink() function creates a symbolic link with the name specified by the path2 parameter which refers to the file named by the path1 parameter. Like a hard link (described in the link() function), a symbolic link allows a file to have multiple names. The presence of a hard link guarantees the existence of a file, even after the original name has been removed. A symbolic link provides no such assurance; in fact, the file named by the path1 parameter need not exist when the link is created. Unlike hard links, a symbolic link can cross file system boundaries. When a component of a pathname refers to a symbolic link rather than a directory, the pathname contained in the symbolic link is resolved. If the pathname in the symbolic link starts with a / (slash), the symbolic link pathname is resolved relative to the process root direc- tory. If the pathname in the symbolic link does not start with a / (slash), the symbolic link pathname is resolved relative to the direc- tory that contains the symbolic link. If the symbolic link is the last component of the original pathname, remaining components of the original pathname are appended to the con- tents of the link and pathname resolution continues. The symbolic link pathname may or may not be traversed, depending on which function is being performed. Most functions traverse the link. The functions which refer only to the symbolic link itself, rather than to the object to which the link refers, are: An error is returned if a symbolic link is named by the path2 parameter. If the file specified is a symbolic link, the status of the link itself is returned. An error is returned if a symbolic link is named as the path parameter. This call applies only to symbolic links. A symbolic link can be removed by invoking the remove() function. If the file to be renamed is a symbolic link, the symbolic link is renamed. If the new name refers to an existing symbolic link, the symbolic link is destroyed. An error is returned if a symbolic link is named as the path parame- ter. An error is returned if the symbolic link named by the path2 parameter already exists. A symbolic link can be created that refers to another symbolic link; that is, the path1 parameter can refer to a symbolic link. A symbolic link can be removed by invoking unlink(). Search access to the symbolic link is required to traverse the pathname contained therein. Normal permission checks are made on each com- ponent of the symbolic link pathname during its resolution. A Context Dependent Symbolic Link (CDSL) is a symbolic link that has a variable in the path name. The variable is resolved differently for each member system in a cluster. If the system is not a member of a cluster, the variable is resolved as if it were member0 of a cluster. See hier(5) for more information about CDSLs and the cdslinvchk(8) refernce page for information about checking the CDSL file inventory RETURN VALUES
Upon successful completion, the symlink() function returns a value of 0 (zero). If the symlink() function fails, a value of -1 is returned and errno is set to indicate the error. ERRORS
If the symlink() function fails, errno may be set to one of the following values: The requested operation requires writing in a directory with a mode that denies write permission, or search permission is denied on a component of path2. The directory in which the entry for the symbolic link is being placed cannot be extended because the user's quota of disk blocks on the file system containing the directory has been exhausted. The path specified by the path2 parameter already exists. Too many symbolic links are found in translating path2. The length of the path1 parameter or path2 parameter exceeds PATH_MAX, or a pathname component of path2 is longer than NAME_MAX while {_POSIX_NO_TRUNC} is in effect. The path2 parameter points to a null pathname, or a component of path2 does not exist. The directory in which the entry for the symbolic link is being placed cannot be extended because there is no space left on the file system containing the directory. The new symbolic link cannot be created because there is no space left on the file system which would contain the link. There are no free inodes on the file system on which the file is being created. The operation is not applicable for this file sys- tem type. A component of path2 is not a directory. The requested operation requires writing in a directory on a read-only file system. [Tru64 UNIX] For NFS file access, if the symlink() function fails, errno may also be set to one of the following values: Indicates either that the system file table is full, or that there are too many files currently open in the system. Indicates a stale NFS file handle. An opened file was deleted by the server or another client; a client cannot open a file because the server has unmounted or unexported the remote directory; or the directory that contains an opened file was either unmounted or unexported by the server. RELATED INFORMATION
Functions: link(2), readlink(2), unlink(2) Commands: ln(1), cdslinvchk(1) Files: hier(5) Standards: standards(5) delim off symlink(2)
All times are GMT -4. The time now is 06:36 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy