Interested to Buy Any Domain ? << Click Here >> for more details...
A Table feild is declared as Decimal(7,2). I want to insert
the decimal in to this column thru cobol-db2 program.
How should I declare my local input file variable
or any suggestion?
- 7 Answers
- 18992 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / nitin
Hello Sumanath and Rajesh
No declaring 9(5)V99 / 9(5)v9(2) comp-3 this way was
not working. I tried this also.
For Example: if the input is 123.45 from flat file
and 1. If I declare 01 W-var pic 9(5)V99
then value of W-var will be 123 45 (It assumed space at
place of decimal) and the same value 123 45 it tried to
moved in the db2 table host varible. which in turn throw
SOC7.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What's The Percentage Free Space ?
How can you classify the locks in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the use of reorg in db2?
What is an instance database?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is cursor stability in db2?
What is a system catalog table in db2?
How can you find out the # of rows updated after an update statement?
What are the various data types available in db2?
Is db2 relational database?
Give a brief description of db2 isolation levels?
What is collection in db2 bind?
When do you specify the isolation level?
