| Author |
Message |
Topic: SORT & SPLIT File based on dynamic key value |
viswanathan
Replies: 2
Views: 7210
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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 ... |
| |