ISQL Help

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?
PFunkAsked:
Who is Participating?
 
david_levineConnect With a Mentor Commented:
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
 
kavitagCommented:
use -s[colseparator] option in isql
0
 
PFunkAuthor Commented:
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
kavitagCommented:
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
 
PFunkAuthor Commented:
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
 
knel1234Commented:
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
 
ajith_29Commented:
Try using the option -c with bcp and it gives the tab separtor format
0
 
tatoCommented:
u need download a result of ISQL?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.