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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
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
All Courses

From novice to tech pro — start learning today.