1. UNIX Desktop Questions & Answers

hi all i am writing the korn shell script. i have a SQL script which gives me the folowing output DSA.WLG.20050713211544.20051025.20050713211544 28991 1130198400 DSA.WLG.20050713211544.20051025.20050713211544 25881 1130198400 DSA.WLG.20050711210100.20051025.20050711210100 25881 ... (3 Replies)

2. AIX

I have this Korn shell script that runs via a cron entry. It runs in a loop "watching" a specific file system for files with a certain name. The file system that it is watching is an upload file system for an FTP server. When files that are the correct name come in, it takes the extension of the... (1 Reply)

3. Shell Programming and Scripting

Hi All- First time using iSql. I have 4 query files - some have more than 1 line of sql statements After a bit of research it appears I can just use the -i command and specify the input file. Questions: Does it matter that there are multiple queries in each file? Do I need to have... (3 Replies)

4. Shell Programming and Scripting

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)

5. UNIX for Dummies Questions & Answers

Hi, Can you please help? I am trying to use variables within a clearcase command, however i am having a major problems - the variables don't appear to be accessible. Using the following as an example: cat=1 2 3 dog=4 5 6 cleartool mkattr -replace Four_Legs '"$cat $dog"' lbtype:Animal ... (3 Replies)

6. Shell Programming and Scripting

I am coding a korn shell script to automate certain things. Creating a baseline is one of them where I got stuck. I google'd and found the available options of using mkbl command. Inside my script this is what I am doing: cleartool mkbl -all <myBaselineNumber in XXX.XXX.XXX.XXX format> ... (1 Reply)

7. Shell Programming and Scripting

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)

8. Shell Programming and Scripting

I've been sent the following script to finish. It's supposed to connect to an oracle database, query it, and send an email if the query result value is one or more. Currently it isn't connecting properly, just giving the following error: ERROR: ORA-01017: invalid username/password; logon denied... (2 Replies)

9. Shell Programming and Scripting

how to write shell script to get the checkin information between two composite baselines in clearcase ucm . (0 Replies)

10. Shell Programming and Scripting

I am running all clearcase commands in shell script and every command is redirecting output to file data.txt cleartool diffbl -act -ver label1 label2 >& data.txt cleartool diffbl -baselines label1 label2 >& data.txt cleartool diffbl -elements label1 label2 >& data.txt Issues was all commands... (6 Replies)