Issue with redirecting a ISQL output to a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Issue with redirecting a ISQL output to a file
# 1  
Old 09-23-2011
Issue with redirecting a ISQL output to a file

Hi all,

I have wrote a script to redirect the output of Sybase query to a file.
Its a single XML message i am fetching with sybase query.

The problem i faced here is the XML message line crosses the normal line limit in unix.

Could some please help me how to get complete xml message into a file.

Thanks
Ravin
# 2  
Old 09-23-2011
I wasn't aware such a thing as a "normal line limit" existed in Unix. Perhaps it's a restriction in "ISQL"?

Maybe your query should write some newlines?

Without seeing any code, or an actual error message - not to mention what an "XML message" is - it's hard to say exactly what your problem might be.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Redirecting output to file

Hi, I have created script which redirect the output to file.I am able to get the output in file but not in the format. Output :Content of the log which have 10 -15 lines. Actal :Line1 ..Line 2Line3 Line4 Line 5 Expected:Line1 Line 2 Line3 Please... (7 Replies)
Discussion started by: karthik771
7 Replies

2. Shell Programming and Scripting

Redirecting output to file through cron

Hi Does anyone have any suggestions for capturing the output into a file when i run it through cron? I have file called "quick.1" which contains two simple commands to be executed on the target host. And i have second file called "quick.2" which contains the wrapper script to ssh to the target... (1 Reply)
Discussion started by: chandika_diran
1 Replies

3. Shell Programming and Scripting

Issue with redirecting output from crontab

Hello All, I've scheduled one simple command to be run from crontab, but the command is failing to append the output to a file. Any issue in my syntax ? This rah cmd is working fine from command center. 19 09 * * * rah "df -m" | awk '{if (NF > 1) if ($5 ~ /NODE/) {print $0;}}' >> db.out 2>&1... (1 Reply)
Discussion started by: NARESH1302
1 Replies

4. UNIX for Dummies Questions & Answers

redirecting the script output to more than 1 file

Hi, I want to redirect my script output to more than one file without printing the result to the screen. How to do that? ex: echo "hi" >> a.txt b.txt cat a.txt hi b.txt :confused: (2 Replies)
Discussion started by: boopathyvasagam
2 Replies

5. Shell Programming and Scripting

Redirecting output to file

Hi, Below is the whole string which is to be redirected to the new file. su - oracle -c "exp $user/$pass file=/oracle/oradata/backup/exp_trn_tables_`date +%d_%b_20%y_%H_%M_%S`.dmp log=/oracle/oradata/backup/exp_trn_tables_`date +%d_%b_20%y_%H_%M_%S`.log tables=table1,table2 statistics=none" ... (3 Replies)
Discussion started by: milink
3 Replies

6. Shell Programming and Scripting

isql output file not created while running it through cron

#!/bin/ksh file="/pkgs/roots/scripts/ISQL_op.txt" isql -H 11.11.11.111:1111 -U myUser -P myPwd -o $file << eof go select * from Table1 go eof my cron entry 00 08 03 11 * /pkgs/roots/scripts/testc.ksh file permission of the script is correct, i have used absolute path everywhere. ... (2 Replies)
Discussion started by: vikram3.r
2 Replies

7. Shell Programming and Scripting

Redirecting output of a command to a file

Hi We are having a requirement where one shell script, say a.sh (which uses Java and connects to Oracle database using JDBC) keeps on running everytime. I created a wrapper (to check whether a.sh is running and if not then to start it) and scheduled it in the crontab. Now all the output from... (3 Replies)
Discussion started by: ankitgoel
3 Replies

8. AIX

Redirecting Both to a file and std output

Hello Friends, Can some one help me how to redirect output of a file to both a file and std output? All the help would be greatly appreciated. Regards Sridhar (1 Reply)
Discussion started by: send2sridhar
1 Replies

9. UNIX for Dummies Questions & Answers

Redirecting output file to a different server.

Hi, I hope this is problem makes sense and that someone can offer some advice. Basically i have a perl script which accesses a database and outputs the information to a file. Is it possible to use a 'system' command to embeb some Unix command which moves that file to another directory... (3 Replies)
Discussion started by: Stormrider
3 Replies

10. UNIX for Advanced & Expert Users

redirecting output to file in network

Hi Experts, Is it possible to redirect the output of an unix command to file. when i "telnet" to a remote system and execute the redirection operation, such that the result should outputted to my system. $ telnet IPaddr2 username : zzzzz password : ******** IPaddr2>ls > file <- i... (1 Reply)
Discussion started by: anent
1 Replies
Login or Register to Ask a Question