Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to load the low values into DB2 table

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

New User


Joined: 16 Aug 2007
Posts: 27
Location: Hyderabad

PostPosted: Fri Sep 19, 2008 11:17 pm    Post subject: How to load the low values into DB2 table
Reply with quote

Hi,

How to load the low values into DB2 table?
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Fri Sep 19, 2008 11:26 pm    Post subject:
Reply with quote

Hi,

Check the link..

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.admin/db2z_howloadtables.htm

If you are looking for something specific, please explain little more about your query.
Back to top
View user's profile Send private message
vvgoud

New User


Joined: 16 Aug 2007
Posts: 27
Location: Hyderabad

PostPosted: Sat Sep 20, 2008 4:16 am    Post subject: Reply to: How to load the low values into DB2 table
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sat Sep 20, 2008 5:39 am    Post subject:
Reply with quote

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
View user's profile Send private message
vvgoud

New User


Joined: 16 Aug 2007
Posts: 27
Location: Hyderabad

PostPosted: Mon Sep 22, 2008 10:12 pm    Post subject: Reply to: How to load the low values into DB2 table
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 22, 2008 11:38 pm    Post subject:
Reply with quote

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
View user's profile Send private message
vvgoud

New User


Joined: 16 Aug 2007
Posts: 27
Location: Hyderabad

PostPosted: Tue Sep 23, 2008 1:10 am    Post subject: Reply to: How to load the low values into DB2 table
Reply with quote

Thanks Dick for your quick response,
I will try with this and let you know if still doesn't work.

Thanks.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Sep 23, 2008 1:51 am    Post subject: Reply to: How to load the low values into DB2 table
Reply with quote

Hello,

You're welcome.

Quote:
I will try with this and let you know if still doesn't work.
Or if it does, please icon_smile.gif

d
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 Sorting of hex values Saurabh_mi DFSORT/ICETOOL 11 Thu May 25, 2017 3:49 pm
No new posts Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Copy load modules and alias vasanthz IBM Tools 5 Thu Apr 20, 2017 6:31 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us