Search found 940 matches

by dbzTHEdinosauer
Thu Aug 07, 2014 3:45 pm
Forum: TSO, CLIST & REXX
Topic: Need Help on Rexx Queries
Replies: 7
Views: 6944

well, ignoring the fact that files have records and not rows - which db2 has.....

i am assuming that you want to edit each member of the pds
and add the member name to the first line. --- that is what you have shown.

what do you want to do?
by dbzTHEdinosauer
Thu Aug 07, 2014 3:30 pm
Forum: TSO, CLIST & REXX
Topic: Need Help on Rexx Queries
Replies: 7
Views: 6944

moved to rexx forum
by dbzTHEdinosauer
Thu Jul 31, 2014 10:42 pm
Forum: EASYTRIEVE
Topic: variable as an argument in the sum function
Replies: 3
Views: 4506

well, let us see your sql. is this dynamic sql??

ws-col-nm has LIV_PCT as it's value. <<<<<that comment makes no sense.

show us the working storage definition of ws-col-nm as well as your sql........
by dbzTHEdinosauer
Tue Jun 17, 2014 11:01 pm
Forum: COBOL
Topic: Date calculation Cobol
Replies: 2
Views: 2539

look in the Language Environment manual for ceedays, etc.
you convert the two days (two calls) then subtract the two values and
call LE again to convert the time to days..
by dbzTHEdinosauer
Thu Jun 05, 2014 4:24 pm
Forum: COBOL
Topic: I have 10 Program which are being Statically
Replies: 6
Views: 6053

i assume this is not db2.
i assume that you mean statically called and linked.
if so,
just relink 6 after you have recompiled and relinked 7.
by dbzTHEdinosauer
Thu Jun 05, 2014 4:20 pm
Forum: TSO, CLIST & REXX
Topic: Fetch Creation date of flat file using REXX
Replies: 4
Views: 3753

sorry NicC,
i did not notice when i posted my reply,
topic moved....
by dbzTHEdinosauer
Wed Jun 04, 2014 3:38 pm
Forum: TSO, CLIST & REXX
Topic: Fetch Creation date of flat file using REXX
Replies: 4
Views: 3753

look at the SYSCREATE variable set by LISTDSI.
by dbzTHEdinosauer
Mon May 26, 2014 7:54 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Elimination of Special Char. Using SORT.
Replies: 7
Views: 4968

depending upon the code set on your computer,
you are better off using NicC's second suggestion.
easiest would be to use the REXX XRANGE function and then write the output to a file and then view it.
by dbzTHEdinosauer
Wed May 21, 2014 9:55 pm
Forum: VSAM - File system
Topic: Maximum Number of Records on VSAM file?
Replies: 4
Views: 5381

no command. vsam, unlike db2, does not have 'triggers', thus the best you can do is only have one module that is CALLed (in batch: dynamic would be best, but you can link it as static .. in CICS you don't have that problem, as every thing should be dynamically linked, but IMUO it would be best in CI...
by dbzTHEdinosauer
Tue May 20, 2014 7:11 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: CICS DB2 Cursor
Replies: 3
Views: 3272

replacing vsam logic with db2 is actually rather easy. 1. using a multi-row fetch, you reduce the CALLs necessary for i/o. e.g. if you have 15 rows on your screen, in vsam you need a start and 15 read nexts in db2 you have an open cursor and 1 (ONE) fetch. 2. always keep the keys for the top row and...
by dbzTHEdinosauer
Wed May 07, 2014 9:36 pm
Forum: JCL
Topic: Dataset allocation problem
Replies: 26
Views: 15421

the output record definition in the FD is a simple Level 01, len 1200.

what does the write statement look like?

and if the write statement uses a FROM clause, what is the layout?
by dbzTHEdinosauer
Tue May 06, 2014 7:39 pm
Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
Topic: Copying elements list from ENDEVOR to PS
Replies: 5
Views: 5906

I don't remember on which panel but endevor has a report generating sub-system, which will generate the JCL for a batch job to generate the report. After the first time, I copied the generated JCL from SDSF, and created a JOB in one of my PDS's and thereafter coded the control cards necessary (in a ...
by dbzTHEdinosauer
Mon Jul 01, 2013 5:57 pm
Forum: General Discussion
Topic: future of desktop computers
Replies: 6
Views: 5955

dd,
i have used the EDIT button to edit each of his posts and have unchecked the signature,
which removed his BS links.

dbz
by dbzTHEdinosauer
Mon Jul 01, 2013 5:41 pm
Forum: VSAM - File system
Topic: How to empty VSAM KSDS file which is defined as REUSE = No
Replies: 2
Views: 3048

delete/define is the easiest way
by dbzTHEdinosauer
Mon Jul 01, 2013 5:34 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Regarding File extracting 2 fields and using in SQL
Replies: 3
Views: 2955

i have accomplished this type of task by:

read the input file and use the field values as literals in a composed sql statement, that will be the output of the COBOL program or REXX script.

this output file will be used as input to something like dsnutil which would then process the 'file'.