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 22 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: SORT & SPLIT File based on dynamic key value
viswanathan

Replies: 2
Views: 7210

PostForum: Job Control Language(JCL)   Posted: Thu Sep 24, 2015 10:43 am   Subject: SORT & SPLIT File based on dynamic key value
Hi Kolusu,

Thank you so much for the complete JCL. It worked well!

I didn't know that with just one keybegin we could split a file into three ways. A learning for me.

Thanks again!
  Topic: SORT & SPLIT File based on dynamic key value
viswanathan

Replies: 2
Views: 7210

PostForum: Job Control Language(JCL)   Posted: Thu Sep 24, 2015 9:46 am   Subject: SORT & SPLIT File based on dynamic key value
Hi Friends,

Need your help in solving JCL Sort & Split requirement.

--> I have an input file of LRECL = 750.

--> Key field is from position 1 to 8 (Packed decimal)

--> Maximu ...
  Topic: To find the free space in the DB2 Tablespace
viswanathan

Replies: 2
Views: 5169

PostForum: Database   Posted: Wed Jun 20, 2012 3:57 pm   Subject: To find the free space in the DB2 Tablespace
Thanks for your reply Dick. I will contact the DBA for this.


Regards,
Viswa
  Topic: To find the free space in the DB2 Tablespace
viswanathan

Replies: 2
Views: 5169

PostForum: Database   Posted: Tue Jun 19, 2012 4:15 pm   Subject: To find the free space in the DB2 Tablespace
Hi Friends,

I need to find the free space available in the tablespace using the SYSIBM Catalague tables as I am not the DBA Admin in my shop.

Could you please help me in this..


Regards,
Vi ...
  Topic: Load - LOB Datatype
viswanathan

Replies: 3
Views: 2868

PostForum: Database   Posted: Wed Jun 08, 2011 6:26 am   Subject: Load - LOB Datatype
Hi Kolusu,

Thanks for the doc.

My understanding from the doc, I should be able to load the LOB datatype with CHAR field. As the process followed for my current shop does not allow me to write a ...
  Topic: Load - LOB Datatype
viswanathan

Replies: 3
Views: 2868

PostForum: Database   Posted: Tue Jun 07, 2011 4:07 am   Subject: Load - LOB Datatype
Hi All,

I have to load a DB2 Table with LOB datatypes. We have to populate values for all the columns in the DB2 Table and have to load the file using DSNUTIL utility. Could someone help me on how ...
  Topic: To override CURRENT DATE
viswanathan

Replies: 2
Views: 2773

PostForum: Database   Posted: Mon Feb 28, 2011 9:13 am   Subject: To override CURRENT DATE
I need to override the current date with the future value (no hard coding) for testing purpose of a Cobol DB2 program.


SELECT A.1, A.2 FROM space.table A
WHERE CURRENT DATE - 180 DAYS > D ...
  Topic: SQLCODE -911 in DB2 Stored Procedure
viswanathan

Replies: 1
Views: 2832

PostForum: Database   Posted: Mon Nov 29, 2010 8:26 am   Subject: SQLCODE -911 in DB2 Stored Procedure
Hi,

I am calling a CICS Program 'PROG1' from a DB2 Stored procedure 'SP1'. This CICS Program in turn calls another sub program 'PROG2'. 'PROG1' and 'PROG2' accesses the same DB2 Table however 'PROG ...
  Topic: XMIT IBM VNET - email not received
viswanathan

Replies: 1
Views: 2152

PostForum: Application Programming   Posted: Wed Aug 11, 2010 5:56 am   Subject: XMIT IBM VNET - email not received
I am using IBM VNET to email the report from MVS to User.
I am able to see the proc XMIT step went fine, however I didnt receive the mail.

Please note this is not the case all the time. Most of th ...
  Topic: SOC4 - protection exception in CICS
viswanathan

Replies: 27
Views: 21769

PostForum: Application Programming   Posted: Wed Jun 09, 2010 9:14 am   Subject: SOC4 - protection exception in CICS
Hi Kolusu,

Thanks for the info. However, we are not able to locate the actual problem we are encountering in the link you have mentioned.

Can you please help us out?
  Topic: SOC4 - protection exception in CICS
viswanathan

Replies: 27
Views: 21769

PostForum: Application Programming   Posted: Fri Jun 04, 2010 11:04 am   Subject: SOC4 - protection exception in CICS
Hi All,

We are encountering the following SOC4 abend in our CICS code:

CEE3204S The system detected a protection exception (System Completion Code=0C4)
From compile unit APA6D100 at en ...
  Topic: What is the limit of XML PARSER in COBOL?
viswanathan

Replies: 3
Views: 3252

PostForum: Application Programming   Posted: Fri Jun 04, 2010 10:43 am   Subject: What is the limit of XML PARSER in COBOL?
Language element :
XML PARSE statement, maximum size of identifier


Compiler limit : 134,180,862 bytes (67,090,431 national character positions)

Thanks for the info papad ...
  Topic: Issue when input is more than 32K bytes
viswanathan

Replies: 2
Views: 2369

PostForum: Application Programming   Posted: Fri Jun 04, 2010 10:41 am   Subject: Issue when input is more than 32K bytes
Thanks for the info Kolusu!
  Topic: What is the limit of XML PARSER in COBOL?
viswanathan

Replies: 3
Views: 3252

PostForum: Application Programming   Posted: Wed May 05, 2010 12:11 pm   Subject: What is the limit of XML PARSER in COBOL?
We are using XML PARSE in our COBOL Stored Procedure Code, where we receive the input in XML format of size ~5mb (Input parm is defined as CLOB Datatype).

We are encountering error (SOC 4) if the s ...
  Topic: Issue when input is more than 32K bytes
viswanathan

Replies: 2
Views: 2369

PostForum: Application Programming   Posted: Tue Apr 27, 2010 2:44 am   Subject: Issue when input is more than 32K bytes
In our program the input is declared as CLOB of size 128000. We are getting XML file from front end(DOTNET) as input and we parse this XML and use the data. We are doing insert and updates in various ...
 
Page 1 of 2 Goto page 1, 2  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group