View previous topic :: View next topic
|
Author |
Message |
sravz chinnu
New User
Joined: 07 Dec 2011 Posts: 26 Location: India
|
|
|
|
Code: |
0000000000000000 KL 2012-02-24 2013-01-14 00.00.00 23.59.59
[color=red]7081263604086679 KL 2011-09-19 [/color]2012-09-26 ? ?
0000000000000000 KL 2012-01-20 2012-07-15 00.00.00 23.59.59 |
Hi all,
Please let me know why i am getting spaces while unloading data from db2 table. all these fileds are char and date fields. i want fixed width file but some spaces are getting for some fields. Please help me out in this.
Thanks,
sravani. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
gee, maybe if we knew anything about your unload sql,
we may have an idea.
you say these are date fields. db2 date data/type or char data/type?
db2 date datatype are not char fields.
and since they are char / i must assume that they are/
could they possibly contain spaces???????
by the way, markup language does not work within code tags. |
|
Back to top |
|
|
sravz chinnu
New User
Joined: 07 Dec 2011 Posts: 26 Location: India
|
|
|
|
Code: |
ONL_PRO_CD POSITION( 25 )
CHAR( 8) ,
" " POSITION( 33 )
CHAR( 16)
NULLIF( 49)='?',
" " POSITION( 50 )
CHAR( 2)
NULLIF( 52)='?', |
Hi Dick,
Has this because of this....? i am unable to understand that why spaces are inserted in file. this is the syspunch card which is generated by system.
thanks,
Sravani. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
I would suggest you look at the cards in syspunch and see if there is any correlation between them and the mystery spaces in the unload file. |
|
Back to top |
|
|
sravz chinnu
New User
Joined: 07 Dec 2011 Posts: 26 Location: India
|
|
Back to top |
|
|
|