Author |
Message |
Topic: Add column with count of rows within distinct |
Crox
Replies: 1
Views: 2832
|
Forum: Database Posted: Fri Sep 22, 2017 12:06 am Subject: Add column with count of rows within distinct |
Hi,
I have a case with two tables to join and three of the columns of the first table should be distinct. I want those three columns and one column of the second table and the count of how many ro ... |
Topic: Wait in COBOL |
Crox
Replies: 15
Views: 35991
|
Forum: Application Programming Posted: Fri Jan 29, 2016 1:59 am Subject: define the parm EXTERNAL in the WORKING-STORAGE to pass |
Most of the sites are using default intallation parms which means that EXTERNA defintions are below the 16M line. By defining your A-mode 24 adressing parm as EXTERNAL, it will go ok. |
Topic: CLOB to be filled with JCL from a member of a PDS using load |
Crox
Replies: 13
Views: 10537
|
Forum: Database Posted: Mon Nov 18, 2013 6:16 am Subject: CLOB to be filled with JCL from a member of a PDS using load |
Thanks for your tips Bauer,
I will look it up.
Regards,
Crox |
Topic: CLOB to be filled with JCL from a member of a PDS using load |
Crox
Replies: 13
Views: 10537
|
Forum: Database Posted: Thu Nov 14, 2013 5:40 pm Subject: CLOB to be filled with JCL from a member of a PDS using load |
the architect is the boss. He decides what is best. So.... it is not about why, it is about how, even when everybody thinks it is not the right way  |
Topic: CLOB to be filled with JCL from a member of a PDS using load |
Crox
Replies: 13
Views: 10537
|
Forum: Database Posted: Thu Nov 14, 2013 4:29 pm Subject: CLOB to be filled with JCL from a member of a PDS using load |
@William:
this option:
You have a bunch of JCL statements you want to stick into DB2 as a bunch of stuff in a CLOB.
Thanks for understanding! |
Topic: CLOB to be filled with JCL from a member of a PDS using load |
Crox
Replies: 13
Views: 10537
|
Forum: Database Posted: Thu Nov 14, 2013 4:28 pm Subject: CLOB to be filled with JCL from a member of a PDS using load |
i didn't explain myself good enough. Not so much time.
1) I will have a CICS transaction running. It has to create a job by writing JCL into the internal reader.
2) to create the right JCL ... |
Topic: CLOB to be filled with JCL from a member of a PDS using load |
Crox
Replies: 13
Views: 10537
|
Forum: Database Posted: Wed Nov 13, 2013 10:57 am Subject: CLOB to be filled with JCL from a member of a PDS using load |
_________
/ /
( JCL (
\________\
|
|
/^\
/ ... |
Topic: CLOB to be filled with JCL from a member of a PDS using load |
Crox
Replies: 13
Views: 10537
|
Forum: Database Posted: Mon Nov 11, 2013 11:38 am Subject: CLOB to be filled with JCL from a member of a PDS using load |
Hi Kolusu,
What my architect wants me to do is to store a JCL member into a CLOB column of a DB2 tabel, using only standard utilities.
He said it would be easy....
I didn't find it yet.
R ... |
Topic: CLOB to be filled with JCL from a member of a PDS using load |
Crox
Replies: 13
Views: 10537
|
Forum: Database Posted: Mon Nov 11, 2013 3:37 am Subject: CLOB to be filled with JCL from a member of a PDS using load |
Hi, can somebody guide me how to store in an easy way JCL in a DB2 -CLOB? The general idea is to use this in a CICS environment where a program is writing this JCL after filling in some parms into the ... |
Topic: changes in Assemler calling COBOL since LE |
Crox
Replies: 2
Views: 2370
|
Forum: Application Programming Posted: Wed Sep 01, 2010 4:24 am Subject: changes in Assemler calling COBOL since LE |
thank you! |
Topic: changes in Assemler calling COBOL since LE |
Crox
Replies: 2
Views: 2370
|
Forum: Application Programming Posted: Tue Aug 31, 2010 11:12 am Subject: changes in Assemler calling COBOL since LE |
Somebody at our company said that since the introduction of the Language Environment there was something changed regarding Assembler calling COBOL. One should pass a field-count after the introduction ... |
Topic: Accessing GDG generations Randomly in COBOL program |
Crox
Replies: 6
Views: 4756
|
Forum: Application Programming Posted: Mon Aug 30, 2010 11:46 am Subject: Accessing GDG generations Randomly in COBOL program |
if you are able to open the files in a dynamic way, you can first read a directory list, finding the right datanames. Then you can choose out of the datanames and open the files using a dynamic alloca ... |
Topic: Loosing leading Zeros in Excel file from mainframe(Cobol) |
Crox
Replies: 12
Views: 13794
|
Forum: Application Programming Posted: Mon Aug 30, 2010 11:40 am Subject: Loosing leading Zeros in Excel file from mainframe(Cobol) |
it is possible to create a totally other kind of type file to download to excel. Did you ever investigate the SYLK format? The normal extension for SYLK is .SLK
You can create a true spreadsheet wi ... |
Topic: Dynamic Paragraph name in Cobol |
Crox
Replies: 6
Views: 3639
|
Forum: Application Programming Posted: Thu Mar 25, 2010 6:21 am Subject: Dynamic Paragraph name in Cobol |
perhaps too late now, but it is possible to use a go to depending on which works very fast. It can help you to simulate the variable labels you need, just by evaluating a binary field with values from ... |
Topic: Problem Statament: Convert PL/I to Cobol |
Crox
Replies: 9
Views: 6843
|
Forum: Application Programming Posted: Wed Dec 16, 2009 5:39 am Subject: Problem Statament: Convert PL/I to Cobol |
lenovo,
try these
http://findarticles.com/p/articles/mi_m0EIN/is_1996_March_6/ai_18058112/?tag=content-inner;col1
http://www.cornerstone.nl/ProductsServices/AnytoanyConversionMigration/tab ... |
|