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

db2cmd option for increasing column width

Status
Not open for further replies.
mjlong999

mjlong999

Programmer
Feb 12, 2002
9
US
Db2 version 6.1

I have a job which is using the db2cmd utility to import data from a flat file into a db2 table. One of the columns, a varchar(1500), is being truncated at 35 characters when it is imported.

Additionally, I noticed that our db2 software package defaults to a max column width of 35 bytes for it's result sets.

Does anyone know the option (hopefully there is one) to change the db2cmd utility, so that it does not truncate the data when it imports?

Thanks in advance,
mjlong
 
Status
Not open for further replies.

Similar threads

C
  • Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
254
chuckw0325
C
SE2097
  • Locked
  • Question
IBM DB2 On Cloud - How is table column name formatted?
Replies
0
Views
134
SE2097
SE2097
Thomas B
  • Locked
  • Question
"BMC AMI Ops Monitor for Db2" (mvmon) trace for prepared statements (from Java)
Replies
0
Views
162
Thomas B
Thomas B
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
375
ANGELDANY
ANGELDANY
Prince26
  • Locked
  • Question
I have created an event monitor for
Replies
0
Views
132
Prince26
Prince26

Part and Inventory Search

Sponsor

Back
Top