Author |
Message |
Topic: Deleting TSQ's from CICS region |
Novice
Replies: 2
Views: 5082
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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 ... |
|