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 46 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Deleting TSQ's from CICS region
Novice

Replies: 2
Views: 5082

PostForum: CICS and Middleware   Posted: Thu May 12, 2011 7:30 am   Subject: Deleting TSQ's from CICS region
We have a problem in CICS.

Our Development team developed a new application which is creating TSQ names using random numbers and these TSQ
  Topic: Splice - Not getting correct result
Novice

Replies: 2
Views: 1787

PostForum: Utilities   Posted: Wed May 26, 2010 9:00 am   Subject: Splice - Not getting correct result
Thanks Kolusu
  Topic: Splice - Not getting correct result
Novice

Replies: 2
Views: 1787

PostForum: Utilities   Posted: Wed May 26, 2010 6:02 am   Subject: Splice - Not getting correct result
Appreciate help.

I am doing a Splice operation
I am trying to Splice the following data of a file

00001
00002
00003

with another file which has the following data

00001 XXXXXXXXXXXXX ...
  Topic: Add DAte, year and Month Columns of Db2
Novice

Replies: 1
Views: 1590

PostForum: Database   Posted: Thu Apr 16, 2009 11:58 pm   Subject: Add DAte, year and Month Columns of Db2
Hi,

Is it possible to write a Query to add few columns of a DB2 table where in First column is a date, second is years and third is Months?

Here is the data from table:

EXT_DATE ...
  Topic: Numeric Check using SORT
Novice

Replies: 14
Views: 18073

PostForum: Utilities   Posted: Thu Feb 21, 2008 1:57 am   Subject: Numeric Check using SORT
Thanks Kolusu. It worked.

Novice
  Topic: Numeric Check using SORT
Novice

Replies: 14
Views: 18073

PostForum: Utilities   Posted: Mon Feb 18, 2008 12:11 am   Subject: Numeric Check using SORT
Kolusu,

I tried the JCL which you have provided and here is


Command ===>
****** ****************
=COLS> ----+----1----+-
000001 XXXXXXXXXXXX009
000002 YYYYYYYYYYYY1 ...
  Topic: Numeric Check using SORT
Novice

Replies: 14
Views: 18073

PostForum: Utilities   Posted: Sun Feb 17, 2008 11:15 pm   Subject: Numeric Check using SORT
Thanks Kolusu.

Novice
  Topic: Numeric Check using SORT
Novice

Replies: 14
Views: 18073

PostForum: Utilities   Posted: Fri Feb 15, 2008 12:26 am   Subject: Numeric Check using SORT
I have a FB file where in Positions 13 to 15 is a 3 bytes field which can carry either a numeric number or alphanumric values.

Here is a sample data

=COLS> ----+----1----+-
'''''' XXXXXXXX ...
  Topic: Convert PD to left justified number and pad sapces to right
Novice

Replies: 9
Views: 5163

PostForum: Utilities   Posted: Fri Jan 19, 2007 12:08 pm   Subject: Convert PD to left justified number and pad sapces to right
Thanks Kolusu and Frank. Sorry for responding late, as I was on a vacation.

The solution worked and thanks once again for your help

Novice
  Topic: Convert PD to left justified number and pad sapces to right
Novice

Replies: 9
Views: 5163

PostForum: Utilities   Posted: Wed Jan 10, 2007 3:02 pm   Subject: Convert PD to left justified number and pad sapces to right
It worked and here is the SYSOUT display



1ICE143I 0 BLOCKSET COPY TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPE ...
  Topic: Convert PD to left justified number and pad sapces to right
Novice

Replies: 9
Views: 5163

PostForum: Utilities   Posted: Tue Jan 09, 2007 9:26 pm   Subject: Convert PD to left justified number and pad sapces to right
Hi Frank,

I checked up with our system folks and they confirmed that the PTF is not applied and will be done after few months as right now we have a 'Freeze Period' in place on production movement ...
  Topic: Convert PD to left justified number and pad sapces to right
Novice

Replies: 9
Views: 5163

PostForum: Utilities   Posted: Mon Jan 08, 2007 5:44 pm   Subject: Convert PD to left justified number and pad sapces to right
Thanks Frank. I will run this and will let you know whether we have the required PTF's

Thanks
Nag
  Topic: Convert PD to left justified number and pad sapces to right
Novice

Replies: 9
Views: 5163

PostForum: Utilities   Posted: Mon Jan 08, 2007 4:53 pm   Subject: Convert PD to left justified number and pad sapces to right
As a part of a requirement we are trying to Build a KSDS VSAM file from a Flat file. The Key of the VSAM which we are going to build is a combination of the following fields on flat file.

1) Accou ...
  Topic: Db2 Query Question
Novice

Replies: 3
Views: 2277

PostForum: Database   Posted: Thu Nov 09, 2006 2:35 pm   Subject: Db2 Query Question
Kolusu,

Thanks for your reply and time.

This query is a part of a process, where in I will get specific owners and I need to find the associated Joint account existence.

As per my current ...
  Topic: Db2 Query Question
Novice

Replies: 3
Views: 2277

PostForum: Database   Posted: Thu Nov 09, 2006 1:16 pm   Subject: Db2 Query Question
I have a following table where owners and accounts are stored. Owner ID and A/C no is the Primary Key.



Owner_ID Account_No
O1 A1
O1 A2
O1 A3
O2 A11
O ...
 
Page 1 of 4 Goto page 1, 2, 3, 4  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group