Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

unload 1

Status
Not open for further replies.
craig322

craig322

MIS
Apr 19, 2001
108
0
0
US
Is there a way to use a multiple character delimiter with the unload command (for example ^|^)? It seems that informix only recognizes the first character I enter for the delimiter.

Thanks

Craig
 
Sort by date Sort by votes
I believe that the delimiter is limited to one character only. I'd suggest writing a simple search and replace script to achieve the desired results. Use unix pipes if the data is large and speed is an issue.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

yeKciM
  • Locked
  • Question
LOAD&UNLOAD problem
Replies
0
Views
40
yeKciM
yeKciM
ejaggers
  • Locked
  • Question
Unload to fname (concatenating the sql's) 1
Replies
1
Views
47
PHV
PHV
ejaggers
  • Locked
  • Question
unloading a null field with informix 1
Replies
3
Views
24
mberni
mberni
lbzh
  • Locked
  • Question
Unload command
Replies
1
Views
15
vpshriyan
vpshriyan
sroz
  • Locked
  • Question
UNLOAD files problem
Replies
6
Views
19
sroz
sroz

Part and Inventory Search

Sponsor

Back
Top