Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Display Clause in DB2.

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

New User


Joined: 08 Jun 2005
Posts: 27

PostPosted: Tue Dec 11, 2007 11:03 am    Post subject: Display Clause in DB2.
Reply with quote

Hi All,

Please clarify this.

1)I have one field having datatype as 9(20) and this filed should be moved to one of the DB2 filed which may be int or decimal.
I think any Db2 datatype is not equivalent to 9(Usage is Display).

What needs to be done for this case?

Are both value as well as datatype considered for the internal movement in DB2?
Back to top
View user's profile Send private message

stodolas

Active Member


Joined: 13 Jun 2007
Posts: 632
Location: Wisconsin

PostPosted: Tue Dec 11, 2007 6:40 pm    Post subject:
Reply with quote

9(20) isn't a valid datatype. What is the actual datatype, CHAR, VARCHAR, decimal, int? 9(20) isn't valid for the definition of a decimal either. That would mean the number is 9 digits long with 20 decimal places. You can't have more decimals than you have digits.
Back to top
View user's profile Send private message
sonasheetal

New User


Joined: 08 Jun 2005
Posts: 27

PostPosted: Thu Dec 13, 2007 10:12 am    Post subject:
Reply with quote

stodolas wrote:
9(20) isn't a valid datatype.


Sorry it's not 9(20) it's 9(8)only. Please reply .
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 display the sign only if the value is... useit DFSORT/ICETOOL 3 Wed Oct 04, 2017 5:53 pm
No new posts Binary to display characters Roy Ware SYNCSORT 3 Tue Sep 19, 2017 8:46 pm
No new posts DB2 NULL Values display V S Amarendra Reddy DB2 3 Thu Sep 07, 2017 6:59 pm
No new posts Suppress value reported by BREAK in D... Learncoholic DFSORT/ICETOOL 3 Wed Aug 16, 2017 6:03 pm
No new posts Display upon console bipinpeter COBOL Programming 1 Thu Jun 22, 2017 12:35 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us