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 SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts Overlaying one set of charater values... Kevin Lindsley SYNCSORT 7 Sat Nov 05, 2016 3:21 am
No new posts Low values Results from VARCHAR FORMAT balaji81_k DB2 10 Thu Oct 20, 2016 1:18 am
No new posts How can we create a flat file in JAVA... rakesh.v18 Java & MQSeries 7 Fri Sep 23, 2016 10:46 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm


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