IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

A particular column of the result is getting Truncated


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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
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
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: 1208
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 11:52 am
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
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: 1208
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 12:16 pm
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
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: 1208
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 12:29 pm
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
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: 1208
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 12:35 pm
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
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
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
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: 1208
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 1:04 pm
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
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: 1208
Location: Bangalore,India

PostPosted: Wed Nov 22, 2006 1:23 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Uploading from desktop, a CSV file, s... DB2 2
No new posts Add column to existing records using ... JCL & VSAM 2
No new posts Column names in SYSIBM tables DB2 5
No new posts Can we Insert duplicates in Primary U... DB2 2
No new posts COnvert a column with mix of hex ,cha... DB2 5
Search our Forums:

Back to Top