Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

A particular column of the result is getting Truncated

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Tue Nov 21, 2006 10:36 am    Post subject: A particular column of the result is getting Truncated
Reply with quote

Hi,

when i executed a query, one particular column of the result is getting Truncated. But there are some more columns following this. How to display the entire contents of this column. Even wen i select this column alone , it is getting truncated.

Help me please
Back to top
View user's profile Send private message

vijikesavan

Active User


Joined: 04 Oct 2006
Posts: 118
Location: NJ, USA

PostPosted: Wed Nov 22, 2006 2:34 am    Post subject: Re: Regzrding the truncation of a column
Reply with quote

Hi,
I could help you if you can provide me some more details.
1) what is the datatype of the column?
2) How are you selecting the column? I mean select <column> name or with any substring()..used?

Thanks,
Viji
Back to top
View user's profile Send private message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Wed Nov 22, 2006 11:44 am    Post subject:
Reply with quote

No.

The datatype of the column is VARCHAR(5000) . it is a simple select statement

Select <column_name> from <table_name> where <condition>

Nothing special about the statement. But this column is getting truncated.

Is it not possible to get all the characters in the column displayed??
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 11:52 am    Post subject:
Reply with quote

Hi prodigy,

Would u please tell me where r u giving this query in COBOL-db2 pgm or Spufi/qmf?
Back to top
View user's profile Send private message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Wed Nov 22, 2006 12:04 pm    Post subject:
Reply with quote

This is given in SPUFI.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 12:16 pm    Post subject:
Reply with quote

Hi There,

What is the length of ur O/P file in spufi?Just change it to 5000

Code:
Output data set characteristics: 
 4  RECORD LENGTH ... ===> 5000   
 5  BLOCK SIZE ...... ===> 50000 
 6  RECORD FORMAT ... ===> FB     
 7  DEVICE TYPE ..... ===> SYSDA


Hope it will helpful.
Back to top
View user's profile Send private message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Wed Nov 22, 2006 12:27 pm    Post subject:
Reply with quote

it is already 4092. This column size itself is of VARCHAR(5000).
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 12:29 pm    Post subject:
Reply with quote

Hi there,

As I told u in my prev . post increase the size of o/p data set.
Back to top
View user's profile Send private message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Wed Nov 22, 2006 12:30 pm    Post subject:
Reply with quote

When i execute the same query in QMF it is giving me the entire contents of the column. But the problem is im not able to get the same when i export it out to a dataset (PS).
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 12:35 pm    Post subject:
Reply with quote

Hi there,

Have u try to increase the length of o/p data set?
Back to top
View user's profile Send private message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Wed Nov 22, 2006 12:45 pm    Post subject:
Reply with quote

Abend 013000 hex occurred processing command 'DSN '.


This is the error message i got.
Back to top
View user's profile Send private message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Wed Nov 22, 2006 12:48 pm    Post subject:
Reply with quote

Quote:
Abend 013000 hex occurred processing command 'DSN '.



This is the error message i got when i tried to increase the length[/quote]
Back to top
View user's profile Send private message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Wed Nov 22, 2006 12:48 pm    Post subject:
Reply with quote

Quote:
Abend 013000 hex occurred processing command 'DSN '.



This is the error message i got when i tried to increase the length[/quote]
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 1:04 pm    Post subject:
Reply with quote

Hi there,

Please try this in CURRENT SPUFI DEFAULTS screen.

Code:
Output data set characteristics:
 4  RECORD LENGTH ... ===> 5000 
 5  BLOCK SIZE ...... ===> 5000 
 6  RECORD FORMAT ... ===> FB   
 7  DEVICE TYPE ..... ===> SYSDA
                                 
Output format characteristics:   
 8  MAX NUMERIC FIELD ===> 5000 
 9  MAX CHAR FIELD .. ===> 5000 
10  COLUMN HEADING .. ===> NAMES


Its working for me.
Plz try it & let us know the result.
Back to top
View user's profile Send private message
prodigy

New User


Joined: 15 May 2006
Posts: 28

PostPosted: Wed Nov 22, 2006 1:20 pm    Post subject:
Reply with quote

icon_biggrin.gif

eurekaaaaaaaaaaaaaaaaaaaa


Hey thanks a lotttttttt

its perfect.. i changed the field length and it worked.
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 1:23 pm    Post subject:
Reply with quote

Glad I could help
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 2 Sun Nov 06, 2016 8:11 pm
This topic is locked: you cannot edit posts or make replies. Rexx to create GDG by scanning JJ result krish.deepu CLIST & REXX 5 Tue Oct 25, 2016 5:32 pm
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am
No new posts Truncated error message after VERIFY ... David Sde TSO/ISPF 4 Mon Sep 05, 2016 11:26 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us