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 Data replication from multiple Db2 ta... kishpra DB2 1 Mon Mar 27, 2017 9:58 pm
No new posts Check Binary Values for symbols gandikk CA Products 3 Tue Mar 21, 2017 5:11 am
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Replacing same string with different ... vickey_dw DFSORT/ICETOOL 6 Wed Feb 22, 2017 10:44 pm


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