9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi
I searched this forum before posting the question, but couldnt find it, the issue
i'm facing is, i'm trying to select a column from a netezza table from a korn
shell script, but the query runs
var=$(nzodbcsql -q "select MAX(millcount) from table1";)
echo $var
it returns the value like... (10 Replies)
Discussion started by: maximus_jack
10 Replies
2. Shell Programming and Scripting
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
Discussion started by: nkm0brm
5 Replies
3. Shell Programming and Scripting
can any one suggest me on how to write a update query in perl script for Oracle database and also tell me abt how we can write a code for sending mails with report as attachment to appropriate persons? (1 Reply)
Discussion started by: Ramesh V Kumar
1 Replies
4. Shell Programming and Scripting
Hi all,
i'm a newbie here, I'm just wondering how can i call my second script if it's contain successfull.
script1.sh
how can i call my 2nd script if he contain SUCCESSFULL
script2.sh
SUCCESSFULL
please advise,
Thanks, (10 Replies)
Discussion started by: nikki1200
10 Replies
5. Shell Programming and Scripting
Hi
I am trying to run the below unix script in informatica comamnd task
the script is in placed in the path (this script checks if the files are present in other server )
------------------------------------------------------------------... (1 Reply)
Discussion started by: laxmi131
1 Replies
6. Shell Programming and Scripting
Hi All,
I am stuch in a script where a for loop is running to execute some commands for some values.
Now my problem is i have to have an if condition that if the first iteration is successful then it has to exit the for loop otherwise it has to continue normally.
my code is this:
for... (5 Replies)
Discussion started by: usha rao
5 Replies
7. Shell Programming and Scripting
I am coding shell script.
I need to connect to different databases like DB2, Oracle and Sybase.
I would then need to query tables where it has all the groups, users for that database.
I would also need who has what kind of permissions.
EG: I know for DB2 some TABAUTH table needs to be... (0 Replies)
Discussion started by: pinnacle
0 Replies
8. Shell Programming and Scripting
Hi,
I have a script to FTP the files to other unit.
Manually this script is running fine & files are getting transferred.
But running the same script using crontab does not transfer files, although the cron log shows that the file was executed.
PLz suggest (2 Replies)
Discussion started by: sandeep_kmehra
2 Replies
9. Shell Programming and Scripting
Hi,
I have a scenario where in i have to extarct max of one column and pass it to a variable.
i have tried to export the result as .dat file and read from that file.But my database is mainframe and it is not permitting me to export in .dat file.I have tried using .ixf file but reading from... (2 Replies)
Discussion started by: ammu
2 Replies