View previous topic :: View next topic
|
Author |
Message |
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
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 |
|
|
vijikesavan
Active User
Joined: 04 Oct 2006 Posts: 118 Location: NJ, USA
|
|
|
|
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 |
|
|
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
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 |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi prodigy,
Would u please tell me where r u giving this query in COBOL-db2 pgm or Spufi/qmf? |
|
Back to top |
|
|
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
This is given in SPUFI. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
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 |
|
|
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
it is already 4092. This column size itself is of VARCHAR(5000). |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi there,
As I told u in my prev . post increase the size of o/p data set. |
|
Back to top |
|
|
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
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 |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi there,
Have u try to increase the length of o/p data set? |
|
Back to top |
|
|
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
Abend 013000 hex occurred processing command 'DSN '.
This is the error message i got. |
|
Back to top |
|
|
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
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 |
|
|
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
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 |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
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 |
|
|
prodigy
New User
Joined: 15 May 2006 Posts: 28
|
|
|
|
eurekaaaaaaaaaaaaaaaaaaaa
Hey thanks a lotttttttt
its perfect.. i changed the field length and it worked. |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Glad I could help |
|
Back to top |
|
|
|