Search found 5 matches

by sucharita14
Tue Oct 27, 2015 4:48 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: uncommitted read
Replies: 0
Views: 3768

uncommitted read

what is the purpose of using uncommitted read(with ur;) in db2 query?
What are its advantages and disadvantages
thanks :)
by sucharita14
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...
by sucharita14
Mon Sep 28, 2015 10:33 am
Forum: DFSORT , ICETOOL & Utilities
Topic: sb37 abend
Replies: 3
Views: 4595

The size of the file is 3243. And it is printing records from 3 db2 tables and it should be around 3000+(not really sure how much)
by sucharita14
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....
by sucharita14
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...