Search found 940 matches

by dbzTHEdinosauer
Thu Dec 18, 2014 8:02 pm
Forum: TSO, CLIST & REXX
Topic: Leading zero values in clist
Replies: 1
Views: 3203

1. learn REXX,forget CLIST

2. numerics are always zero suppressed. If you want more than 1 zero for the value zero, make it alpha with format instruction. (don't remember if fomat is a clist instr..)
by dbzTHEdinosauer
Mon Dec 15, 2014 8:43 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: DB2 query with performance improvements
Replies: 1
Views: 3225

have you tried:

Code: Select all

and (  (t3.dateid1 in t9.dateid1) or (t3.dateid1 in t2.dateid1) )
or

Code: Select all

and (  (t3.dateid1 in t2.dateid1) or (t3.dateid1 in t9.dateid1) )
by dbzTHEdinosauer
Mon Dec 08, 2014 6:34 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Problem with CURRENT DATE in SQL - DB2
Replies: 1
Views: 3452

thread closed. multiple forums visited.

the problem, for others than the poster, is that the 2 months needs to be subtracted from the db2 current date register, then cast (via substring and concatenation) either the date from the table to be the same format as current date, or the opposite.
by dbzTHEdinosauer
Mon Dec 08, 2014 6:30 pm
Forum: COBOL
Topic: How to check if a field contains thai char
Replies: 2
Views: 4437

i imagine in your mainframes codeset, there are thai characters. they will have their own, unique hex value. determine the hex values for thai characters in your codeset and either use sort to do-what-ever or code a routine in your favorite programming language (this includes rexx, unless you have l...
by dbzTHEdinosauer
Mon Dec 01, 2014 7:15 pm
Forum: JCL
Topic: Creation of test data file through JCL
Replies: 1
Views: 2986

by dbzTHEdinosauer
Mon Nov 17, 2014 7:45 pm
Forum: JCL
Topic: GDG Versions created on same day
Replies: 3
Views: 7551

Swapnil781,
do you really mean versions or generations?
by dbzTHEdinosauer
Mon Nov 17, 2014 7:42 pm
Forum: JCL
Topic: access dataset on other sysplex
Replies: 2
Views: 3868

Re: access dataset on other sysplex

Hi gurus, Any DD-parameter, which tells, on what sysplex a dataset is located ? I believe discs that are assigned to a sysplex can be referenced from another, but I don't remember how they need to be defined. but, I think the real problem here is that you don't understand sysplex. are jobs not 'run...
by dbzTHEdinosauer
Mon Nov 17, 2014 7:32 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Query on Multi row fetch CPU time performance improvements
Replies: 2
Views: 4479

maybe because the multirow fetch only has affect on the result table, which (by looking at the sql) is the resouce user and not the fetch. i think that you will also find that the documentation concerning multirow fetch does little discussion of complex queries (in the sense of JOIN, UNION, subselec...
by dbzTHEdinosauer
Mon Nov 03, 2014 7:48 pm
Forum: TSO, CLIST & REXX
Topic: Filename Edit from 3.4 console
Replies: 1
Views: 3403

this has been answered in the other forum where you posted the same question.
i am locking this topic.
by dbzTHEdinosauer
Mon Oct 27, 2014 7:39 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Receiving SQLCODE -911 for CICS-DB2 module
Replies: 1
Views: 3578

are you also performing a syncpoint after the updates? the inserts will not give you a deadlock, but the updates in one task could cause a dealock for the updates in a second. have you considered running only one task? have you considered running this process in batch. what you are describing is 'ba...
by dbzTHEdinosauer
Mon Oct 13, 2014 6:49 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Need to update only the year in DATE format
Replies: 2
Views: 4516

you can always determine the difference between the year in the date column and your target year,
then algebraically add the difference to the date field.
by dbzTHEdinosauer
Mon Oct 13, 2014 6:43 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Check on low values in table
Replies: 3
Views: 5576

probably resource intensive but I imagine you will not be running this regularly (because the input program should be corrected),
the CONTAINS Function will provide you with what you need.

there are examples at the bottom of the page in the manual.
by dbzTHEdinosauer
Thu Oct 09, 2014 7:31 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Check on low values in table
Replies: 3
Views: 5576

what do you mean by 'filter'?

there are lots of things that can be done.
show us an example, with an explanation of your expectations,
and I am sure, answers will come.

as it is, your question is too vague for anyone to waste time answering.
by dbzTHEdinosauer
Mon Sep 15, 2014 7:06 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Not able to do a Numeric check using sort.
Replies: 5
Views: 7357

this is a syncsort problem. wer messages are syncsort.
by dbzTHEdinosauer
Thu Aug 07, 2014 3:48 pm
Forum: EASYTRIEVE
Topic: variable as an argument in the sum function
Replies: 3
Views: 7639

well, now that we know what language is invoking db2, we will post this question in the easytrieve forum