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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fexp, exports NULL as string of spaces

Status
Not open for further replies.
gunsva

gunsva

Technical User
Aug 23, 2001
6
US
I am fastexporting data from a table. One of the fields in the source table is a varchar(20) and may contain NULL. When I fexp the data, fexp replaces the NULL with 20 spaces.. How do I configure fexp to not alter the NULL ?
Thanks!
 
Sort by date Sort by votes
Can you show us the script?
By default FastExport uses MODE INDICATOR to preserve NULL value information.
And a VarChar is exported as a word indicating the length x followed by x chars.

Dieter
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Preshit
  • Locked
  • Question
Number of working days between two date fields
Replies
1
Views
156
johnherman
johnherman
micjohnson382
  • Locked
  • Question
Teradat 13.10. Need to split the string with a delimiter.
Replies
0
Views
152
micjohnson382
micjohnson382
btrini
  • Locked
  • Question
Error 3544: Partial string matching requires character operands
Replies
0
Views
220
btrini
btrini
btrini
  • Locked
  • Question
Fastload logon shows as invalid but I can log on to Teradata SQL Assistant with the same credentials
Replies
1
Views
122
SamBones
SamBones
ianbrown76
  • Locked
  • Question
Find ASCII code of characters in columns
Replies
0
Views
126
ianbrown76
ianbrown76

Part and Inventory Search

Sponsor

Back
Top