10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Can you please tell me the Unix shell script for removing footer from the datafile while loading into external table using sqlloader
we will be skipping the header like this while creating the table
organization external
(
type oracle_loader
default directory directoryname... (5 Replies)
Discussion started by: srikanth_sagi
5 Replies
2. Shell Programming and Scripting
Hello:
I am trying to build a ksh shell script which would summarize space occupied by "product" directory under /u*/app/oracle
and summarize and report the total size occupied by it in one server.
Environment is this...
HP UNIX 11i
Korn Shell
some thing like ... (1 Reply)
Discussion started by: Sam1974
1 Replies
3. Shell Programming and Scripting
Hi everyone!!
I need help regarding this.
How can we load data from DB2 Database tables into a Comma Separated File?
I also have another Question? Using Shell scripting, Is it easy to read Data from a table or from a text file?
It is very urgent for me. Please help me out guys.
... (1 Reply)
Discussion started by: ss3944
1 Replies
4. UNIX for Dummies Questions & Answers
hello,
when I load a data from text file all the values become NULL in the table.
Please help me with this problem.
Thanks
sheen (15 Replies)
Discussion started by: sheen
15 Replies
5. Shell Programming and Scripting
i have a unix script that gives me the sysdate from the database EDNAMID.WORLD.What i want my script to do the following
1) Establish a database connection
2) if database connection is successfull then echo the message "Connected"
3) put the o/p of the Sql query in a spool file
4) then... (3 Replies)
Discussion started by: ali560045
3 Replies
6. Shell Programming and Scripting
Hi All,
I am trying to load a data from a files in a particular directory to a database..
cd $SCC
isql metdb >> ${LOGDATA}/LOAD.LOG < !
load from "${LDATA}/${FORM}.ld" insert into $LOADTABLE
!
But it's showing the error "syntax error at line 46 : `<<' unmatched"
Can u plz help me... (5 Replies)
Discussion started by: grajesh_955
5 Replies
7. Shell Programming and Scripting
I have got the solution so just closing this issue. (3 Replies)
Discussion started by: jambesh
3 Replies
8. Shell Programming and Scripting
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (2 Replies)
Discussion started by: alokjyotibal
2 Replies
9. Shell Programming and Scripting
Where to start?
Ok, I need to pick up a Worldpay exchange rates file from a url such as:
https://select.worldpay.com/wcc/info?op=rates&instId=12345&op=rates-today
the http response returns a exchange rates file with content-type "text/plain" content as below:
#Exchange rates for... (2 Replies)
Discussion started by: kshelluser
2 Replies
10. Shell Programming and Scripting
can i make a dump to happen from my script in a databse.and download that dump.
I want to schedule a script i cron so that i will make a dump and download that inot my server. (1 Reply)
Discussion started by: arunkumar_mca
1 Replies