Unload utility with loop method


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Unload utility with loop method
# 1  
Old 07-02-2007
Unload utility with loop method

Hi,

I just wonder why the unload tools from INFORMIX doesn't unload all required file to every output of mOutFile at the accumulative way OR my script has an error ? In fact it just unload to one single record at the latest.

Code:
for mFile in x???
do
  echo "Now working with file "$mFile" at "`date`
  mOutFile=$mFile".unl"
  while read mLine
  do
    _customer_t=$(echo $mLine | cut -d "|" -f 1)
    echo "unload to $mOutFile select cust_num from customer where customer_t=$_customer_t;" | dbaccess demo
  done < $mFile
done

Please advise.. Cheers

Regards,
# 2  
Old 07-02-2007
cedrichiu

I think you are overlaying $mOutFile.

Code:
    echo "unload to tmpfile select cust_num from customer where customer_t=$_customer_t;" | dbaccess demo
    
    cat tmpfile >>$mOutFile 
    


Last edited by kahuna; 07-02-2007 at 09:59 AM.. Reason: Oops, I had some extra quotes
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Top utility in bash for loop

Dear All, is it possible to use top utility in for loop? I am trying to get top swap space consuming processes in my for loop. I got multiple way (using /proc FS) however have anybody used top command in for loop? Using /proc FS giving solutionbut itrs more complex. Please suggest if... (4 Replies)
Discussion started by: mail2vivek1
4 Replies

2. Shell Programming and Scripting

Read parameter file in a shell script to unload a DB2 Table???

Hi , I Have following requirement: DB2 Sql query to pass from a parameter file for example, I would create a parameter file with (SELECT column 1, column 2 FROM Table name) then job would read it and create a file with the contents named table.txt How to write/modify below ksh script to... (10 Replies)
Discussion started by: developer.dwh9
10 Replies

3. Shell Programming and Scripting

How do I number my for loop outputs with this method?

Currently I am outputting users and I want to number them starting with 1... grep name list.txt | awk -F"=" '{ print $2 }' | while read user; do echo -e "1\t|$user" Currently I have: 1 | john 1 | amy 1 | max I want it to look like 1 | john 2 | amy 3 | max (2 Replies)
Discussion started by: etranman1
2 Replies

4. Shell Programming and Scripting

data unload using shell

hi, I work on oracel 10g unix system. I need to unload data from few tables to a unl file using shell script. I've a file which contains the list of tables. The shell has to refer to this list and create a unl for each table. Table_list.txt table1| table2| table3| has to... (1 Reply)
Discussion started by: dvah
1 Replies

5. UNIX and Linux Applications

data unload in oracle 11g unix

:)hi, i work with ids and i've got a task now to load some data from oracle table to ids table. I'm trying to unload data from oracel tables. I use UNLOAD TO <filename> SELECT * FROM <table1>; sql in IDS to unload data to a unl. Is there a equivalent sql in oracle? Or is there any... (0 Replies)
Discussion started by: divak
0 Replies

6. Programming

infinite loop, synchronizing gossip-based method

the following code runs, but it hangs somewhere, i don't know why, #include<iostream> #include<vector> #include<cstdlib> #include<ctime> #include<list> #include<pthread.h> #include<cstring> using namespace std; pthread_mutex_t listlock = PTHREAD_MUTEX_INITIALIZER;... (3 Replies)
Discussion started by: saman_glorious
3 Replies

7. Shell Programming and Scripting

linux ISQL and MSSQL unload results to file

Hello, I am using suse 10.1 and isql from unixodbc to connect to a MS SQL server. I got everything to work fine. What do I need to unload the results from the sql to a file? I attempted to put unload to in my sql statement but got a error. I don't see in the isql help where it has a option to... (0 Replies)
Discussion started by: benefactr
0 Replies

8. Shell Programming and Scripting

Method to exit a for loop

Hi All, Can someone let me know how i can exit a for loop without exiting the script itself .... will the break statement work .... please help .... -Regards (2 Replies)
Discussion started by: Rohini Vijay
2 Replies

9. Linux

Is there any way to unload *.so by force?

In linux, dlclose can unload the dynamic linked library when the reference count decreases to zero. My questions is: Is there any way to unload the *.so without caring the reference count? (0 Replies)
Discussion started by: princelinux
0 Replies
Login or Register to Ask a Question