View previous topic :: View next topic
|
Author |
Message |
vvgoud
New User
Joined: 16 Aug 2007 Posts: 27 Location: Hyderabad
|
|
|
|
Hi,
How to load the low values into DB2 table? |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
Back to top |
|
|
vvgoud
New User
Joined: 16 Aug 2007 Posts: 27 Location: Hyderabad
|
|
|
|
My program is checking the first row of 2 fields are low values are in the DB2 table see below DB2 data, while testing i have to load the same data to test so how to load the below dotted low values(.....).
Code: |
DLRNO ORDERNO RDTE
CHAR(5) CHAR(7) DATE
------- -------- ---------- --------
..... ....... 01/01/0001
02010 0617797 07/28/2005 |
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Are loading your test data via a program doing INSERTs or do you have a qsam file to load from?
If you are using a program with INSERTs, move low-values to the dlrno and orderno ws variables before the INSERT.
If you have a qsam file, edit the file, use HEX ON and enter the hex zeros (which are low-values) for those 2 fields.
I tried to align your data post and have hopefully not changed it. I also deleted some replies that had gotten away from your question. |
|
Back to top |
|
|
vvgoud
New User
Joined: 16 Aug 2007 Posts: 27 Location: Hyderabad
|
|
|
|
Hi Dick,
Thanks so much for your response.
We have to insert the Low values to DB2 table through insert statement to test database, not using any program and not using any Qsam file.
Thanks in advance |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
We have to insert the Low values to DB2 table through insert statement to test database, not using any program and not using any Qsam file. |
Whoever made that requirement should not be providing requirements or technical direction. . . If you need to add some rows, you need to add some rows with whatever tools you have/are told about. . . Had you been permitted to use what you learned, you would have had test data 2/3 days ago. . .
Anyway, you can probably do what you want using a hex-constant (x'0000000000') etc. You could probably edit your query in hex and put in the value that way as well. |
|
Back to top |
|
|
vvgoud
New User
Joined: 16 Aug 2007 Posts: 27 Location: Hyderabad
|
|
|
|
Thanks Dick for your quick response,
I will try with this and let you know if still doesn't work.
Thanks. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You're welcome.
Quote: |
I will try with this and let you know if still doesn't work.
|
Or if it does, please
d |
|
Back to top |
|
|
|