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 9 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Doubts in COBOL and DB2 Stored Procedure.
vsr100481

Replies: 4
Views: 5166

PostForum: Database   Posted: Mon Feb 11, 2008 6:35 am   Subject: Doubts in COBOL and DB2 Stored Procedure
Hi,

It would be very much greatful if you could provide link or some good material which has program prepartion steps for COBOL and DB2 Stored Procedure and run jcl for the executing the SP'S.

A ...
  Topic: Doubts in COBOL and DB2 Stored Procedure.
vsr100481

Replies: 4
Views: 5166

PostForum: Database   Posted: Sun Feb 10, 2008 11:23 pm   Subject: Doubts in COBOL and DB2 Stored Procedure.
Hi

I have few doubts regarding stored procedures (both External Stored Procedure and DB2 Stored Procedure). Kindly advise.

1. I assume there is no difference between SQL Stored procedure and DB2 ...
  Topic: SQLCODE -420 - Please help!!!
vsr100481

Replies: 1
Views: 2897

PostForum: Database   Posted: Mon Nov 20, 2006 1:02 pm   Subject: SQLCODE -420 - Please help!!!
Hi Every one,

Can any one help me to fine out how to compare a character field which has integer value with an Comp-2 field in SQL:

I tried with CAST function its giving me -420 as sqlerror. So ...
  Topic: Maximum number of Duplicates in an Alternate index (key)
vsr100481

Replies: 1
Views: 1889

PostForum: Application Programming   Posted: Mon Nov 13, 2006 2:30 am   Subject: Maximum number of Duplicates in an Alternate index (key)
Hi All,

Can any one let me know how many occurance of duplicates can be allowed thru ALternate Key ( in VSAM)?

For example say we have name as duplicate key, and we have a duplicate record as su ...
  Topic: Run JCL for COBOL Stored Procedure & DB2 Stored Proced.
vsr100481

Replies: 7
Views: 9586

PostForum: Database   Posted: Tue May 16, 2006 7:44 am   Subject: Run JCL for COBOL Stored Procedure & DB2 Stored Proced.
Suresh,

First f all thanks for your kind reply.

i am a developer working under Mainframe Platform. Sorry, i am quite confused with your explantion.

here we were testing the DB2 SPs thru St ...
  Topic: Run JCL for COBOL Stored Procedure & DB2 Stored Proced.
vsr100481

Replies: 7
Views: 9586

PostForum: Database   Posted: Tue May 16, 2006 1:15 am   Subject: Run JCL for COBOL Stored Procedure & DB2 Stored Proced.
Manas,

Yes, Basically Stored Procedures are being called from Front end (Java program, etc..) or a Batch Program, or CICS.

But here if i want to test a COBOL/DB2 SP directly thru a JCL (run). i ...
  Topic: Run JCL for COBOL Stored Procedure & DB2 Stored Proced.
vsr100481

Replies: 7
Views: 9586

PostForum: Database   Posted: Mon May 15, 2006 2:24 am   Subject: Run JCL for COBOL Stored Procedure & DB2 Stored Proced.
Hi,

Can any one help me by sending/finding Run JCL for both COBOL Stored Procedures and DB2 Stored Procedures?

Help Required.

WIth Regards
Sundar
  Topic: How do we identify COMP, COMP1, COMP2, COMP3 records n file?
vsr100481

Replies: 2
Views: 1927

PostForum: Application Programming   Posted: Wed May 03, 2006 8:04 am   Subject: How do we identify COMP, COMP1, COMP2, COMP3 records n file?
Hi Kolusu,

Thanks for your kind reply.

Cheers Sundar
  Topic: How do we identify COMP, COMP1, COMP2, COMP3 records n file?
vsr100481

Replies: 2
Views: 1927

PostForum: Application Programming   Posted: Tue May 02, 2006 12:59 am   Subject: How do we identify COMP, COMP1, COMP2, COMP3 records n file?
Hi Every body,

I have a doubt. Consider we have a file which contains COMP, COMP1, COMP2, COMP3 data. Is there any way to find and say(by direclty looking the data from the file) this value belong ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group