what is the purpose of using uncommitted read(with ur;) in db2 query?
What are its advantages and disadvantages
thanks
Search found 5 matches
- Tue Oct 27, 2015 4:48 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: uncommitted read
- Replies: 0
- Views: 3768
- Thu Oct 08, 2015 11:45 am
- Forum: EASYTRIEVE
- Topic: working with dates
- Replies: 0
- Views: 6860
working with dates
hello, I have an issue. I embedded db2 query in an easytrieve program. The program is running currectly but when I am trying to check whether enddate is greater than current date in the where clause, it is throwing an -401 sqlcode error. The format of date in my table is dd.mm.yyyy and the query whi...
- Mon Sep 28, 2015 10:33 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: sb37 abend
- Replies: 3
- Views: 4595
- Fri Sep 25, 2015 5:34 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: sb37 abend
- Replies: 3
- Views: 4595
sb37 abend
hello guys, While executing a jcl for an easytrieve program I am getting space abend reason code 4. I tried to solve this problem by increasing the primary and secondary cylinders in space parameter. I even gave volume parameter by volume=(,,,6). but I am still getting space abend. guys please help....
- Tue Sep 08, 2015 8:42 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: sorting a dataset according to dates.
- Replies: 0
- Views: 2031
sorting a dataset according to dates.
I am trying to sort a dataset based on date column in ascendeing order. example: if there are three dates namely 31.1.1998, 2.12.1997,3.6.2014 Then it should come as 2.12.1997,31.1.1998,3.6.2014 I wrote the sort card as sort field =(72,10,uff,a) the fields are not getting sorted properly. Can u guys...