Solved

ISQL Help

Posted on 1998-12-02
8
2,264 Views
Last Modified: 2012-06-27
I am using ISQL with Sybase IQ.  When I dump the output to a text file using the -o <filename> option, the output is coming out word wrapped.  Anyone know how to make it output as tab delimited?
0
Comment
Question by:PFunk
8 Comments
 

Expert Comment

by:kavitag
ID: 1098462
use -s[colseparator] option in isql
0
 

Author Comment

by:PFunk
ID: 1098463
That puts a [colseperator] after every column including the last column in each record so there is no way for me to know when I have reached end of record because all the columns have the seperator between them.  The record wraps about 6 lines so there is no easy way to tell end of record.  
0
 

Expert Comment

by:kavitag
ID: 1098464
If your client is running on different machine than the SQL server use options [-J client_charset] and [-a display_charset].

Did you try doing that?

0
 

Author Comment

by:PFunk
ID: 1098465
I tried them.  I also tried using sqladv.exe instead of isql.exe.  I get the results I want for small recordsets, but large recordsets take up so much memory.  I have increased my NT Workstation swapfile size to 1GB and still running out of space.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 3

Expert Comment

by:knel1234
ID: 1098466
PFunk,

Can you show us the table?  Do you need to full length of each field?  Can you throw in a copy of your current sql?

knel1234
0
 
LVL 9

Accepted Solution

by:
david_levine earned 200 total points
ID: 1098467
Use the BCP program to create a tab delimted file of your table. The synatx would be:

bcp dbname.owner.table_name out x:\filename.tab -Uxxx -Pyyy -c

If the SQL you were previously using was more then just a full select, you will need to run a sql script first which creates and populates a temporary table which is then bcp'ed out followed by dropping the temporary table.

Let me know if you have any questions regarding the process or run into any trouble.

David
0
 
LVL 2

Expert Comment

by:ajith_29
ID: 1098468
Try using the option -c with bcp and it gives the tab separtor format
0
 

Expert Comment

by:tato
ID: 1098469
u need download a result of ISQL?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SYBASE Query combine date spans 7 658
SQL Time Syntax 4 291
SyBaseSQL Select column if it exists 3 1,388
Exposing an EAV database model as a mart for visualisation 9 114
When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now