 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 12 matches |
| Author | Message |
|---|---|
 Topic: How to insert Hex value into Binary(Bit) in a DB2 program |
|
| suggala_r Replies: 16 Views: 17981 |
 Forum: Database Posted: Wed May 30, 2007 2:51 pm Subject: How to insert Hex value into Binary(Bit) in a DB2 program |
| Thanks for the query.
from the query, the value in Column Foreignkey is 'B'. |
|
| Topic: How to insert Hex value into Binary(Bit) in a DB2 program |
|
| suggala_r Replies: 16 Views: 17981 |
Forum: Database Posted: Wed May 30, 2007 2:27 pm Subject: How to insert Hex value into Binary(Bit) in a DB2 program |
| Kolusu,
I am trying to present my issue here and get the answer. Not to point to any one. This just a discussion forum. There is no rule that every idea/thought is correct idea/thou ... |
|
| Topic: How to insert Hex value into Binary(Bit) in a DB2 program |
|
| suggala_r Replies: 16 Views: 17981 |
Forum: Database Posted: Wed May 30, 2007 1:39 pm Subject: How to insert Hex value into Binary(Bit) in a DB2 program |
|
Cmd Column Name ColNo Datatyp Length Label PKNo Null Dflt Bit FldPrc ----v----1----v----2----v----3----v----4----v----5----v----6----v----7----v---- XXXXX-col-name 1 VARCHAR ... |
|
| Topic: How to insert Hex value into Binary(Bit) in a DB2 program |
|
| suggala_r Replies: 16 Views: 17981 |
Forum: Database Posted: Wed May 30, 2007 12:33 pm Subject: How to insert Hex value into Binary(Bit) in a DB2 program |
| NIC,
Hex value will not be the same as original field length. We need to tell DB2 that we are passing Hex value (for ex: X'FFFFFF'). If I Move FFFFF to working storage variable ws-he ... |
|
| Topic: How to insert Hex value into Binary(Bit) in a DB2 program |
|
| suggala_r Replies: 16 Views: 17981 |
Forum: Database Posted: Wed May 30, 2007 11:32 am Subject: How to insert Hex value into Binary(Bit) in a DB2 program |
| Hi Kolusu,
You can google on the Datatype : Varchar for Bit in DB2 for more info. let me get back to the my initial question : What is the syntax for in Programming perspective ... |
|
| Topic: How to insert Hex value into Binary(Bit) in a DB2 program |
|
| suggala_r Replies: 16 Views: 17981 |
Forum: Database Posted: Tue May 29, 2007 4:33 pm Subject: How to insert Hex value into Binary(Bit) in a DB2 program |
| Ok.
My requirement is as below We have a table which needs to be inserted/populated online/runtime. Technology : Front end : Java/J2EE. Backend : mainframe. Stored procedure is the inte ... |
|
| Topic: How to insert Hex value into Binary(Bit) in a DB2 program |
|
| suggala_r Replies: 16 Views: 17981 |
Forum: Database Posted: Tue May 29, 2007 3:15 pm Subject: How to insert Hex value into Binary(Bit) in a DB2 program |
| Nic,
The underlying Column is Bit datatype. The value I am getting is Hex format. If I can not add X' in my SQL , how the DB2 knows i am supplying Hex format. sorry If I have no ... |
|
| Topic: How to insert Hex value into Binary(Bit) in a DB2 program |
|
| suggala_r Replies: 16 Views: 17981 |
Forum: Database Posted: Tue May 29, 2007 2:05 pm Subject: How to insert Hex value into Binary(Bit) in a DB2 program |
| We all may be knwoing the syntax for inserting hex into table
is below insert into Table_name values ( X'hex value'). How we can use the same syntax in a program. How ... |
|
| Topic: Handling DB2 Varchar Bit type data to Char type format |
|
| suggala_r Replies: 4 Views: 3532 |
Forum: Database Posted: Fri Nov 12, 2004 12:11 pm Subject: Handling DB2 Varchar Bit type data to Char type format |
| Hi Kolusu,
I did not understand your reply. May be description of my question is not proper. We used Cobol-Db2 stored procedures for inserting the descriptions to the tables. But all alon ... |
|
| Topic: Table Lock -913 |
|
| suggala_r Replies: 5 Views: 2281 |
Forum: Database Posted: Tue Nov 09, 2004 12:48 am Subject: Table Lock -913 |
| Nagapa,
As sureshkumar mentioned..You may need to consider all the factors what he mentioned..Added to that if it is online program..Handle -913 condition and retry the same paragraph 5-10 time ... |
|
| Topic: Handling DB2 Varchar Bit type data to Char type format |
|
| suggala_r Replies: 4 Views: 3532 |
Forum: Database Posted: Sun Nov 07, 2004 2:08 am Subject: Handling DB2 Varchar Bit type data to Char type format |
| Added information to my question is Our DB2 version is 7. | |
| Topic: Handling DB2 Varchar Bit type data to Char type format |
|
| suggala_r Replies: 4 Views: 3532 |
Forum: Database Posted: Sun Nov 07, 2004 1:37 am Subject: Handling DB2 Varchar Bit type data to Char type format |
| Hi,
We use Varchar Bit type data for storing Unicode descriptions(multi lingual). So far we are able to manage everything(inserts,updates etc) through Cobol stored proc via ASP/java front end.We ar ... |
|
All times are GMT - 5 Hours |