MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 45 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Add column with count of rows within distinct
Crox

Replies: 1
Views: 2832

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 Confused
  Topic: CLOB to be filled with JCL from a member of a PDS using load
Crox

Replies: 13
Views: 10537

PostForum: 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

PostForum: 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. Sad

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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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 ...
 
Page 1 of 3 Goto page 1, 2, 3  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group