Author |
Message |
Topic: Need help in formatting output |
shekar123
Replies: 4
Views: 1634
|
Forum: Utilities Posted: Tue May 28, 2024 12:08 am Subject: Need help in formatting output |
Kolusu
Thanks a lot a lot and a lot. Again you have taken a lot of time in explaining each step in so detail. Great of you. This helps a lot. |
Topic: Need help in formatting output |
shekar123
Replies: 4
Views: 1634
|
Forum: Utilities Posted: Mon May 27, 2024 11:11 am Subject: Need help in formatting output |
Kolusu
Thank you so much for your help. I lost DFSORT usage to some extent. I completely agree whatever I coded is just waste of time and resources.But I have completely understand the code syntax ... |
Topic: Need help in formatting output |
shekar123
Replies: 4
Views: 1634
|
Forum: Utilities Posted: Mon May 27, 2024 2:36 am Subject: Need help in formatting output |
I have a dataset with data as below FB 80 bytes 800 BLKSIZE
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
********************************* Top of Data *********** ... |
Topic: Pulling one line of output multiple lines |
shekar123
Replies: 13
Views: 4746
|
Forum: Utilities Posted: Mon Apr 25, 2022 7:06 am Subject: Pulling one line of output multiple lines |
My approach
OPTION COPY
INCLUDE COND=(15,44,CH,EQ,
C'CURRENT DIRECTORY TO DATA RATIO ... |
Topic: Pulling one line of output multiple lines |
shekar123
Replies: 13
Views: 4746
|
Forum: Utilities Posted: Mon Apr 25, 2022 7:04 am Subject: Pulling one line of output multiple lines |
Kolusu
By your help I was able to generate values for report BPNAME,ALLOCATED
I need your help further please. I have to generate report with following fields and further more based on DB2 DIS ... |
Topic: Pulling one line of output multiple lines |
shekar123
Replies: 13
Views: 4746
|
Forum: Utilities Posted: Mon Apr 25, 2022 3:00 am Subject: Pulling one line of output multiple lines |
Kolusu
Superb explanation.I just copied your code not realizing the DB2 sub system character recognization could matter here.I am very clear now. Here is your original code just changing the DB2 CR ... |
Topic: Pulling one line of output multiple lines |
shekar123
Replies: 13
Views: 4746
|
Forum: Utilities Posted: Fri Apr 22, 2022 9:32 pm Subject: Pulling one line of output multiple lines |
Thank you so much Kolusu for your help and detaild explanation. I was able to get my resilts after changing as per your suggestion.I just made adjustments to SQZ for character and SQZ for numbers.
... |
Topic: Pulling one line of output multiple lines |
shekar123
Replies: 13
Views: 4746
|
Forum: Utilities Posted: Fri Apr 22, 2022 4:56 am Subject: Pulling one line of output multiple lines |
Kolusu
Thank you for your help and I understand the concern. I am trying my best to get this done and somehow either I am missing the positions / getting one field and missing another field. I did ... |
Topic: Pulling one line of output multiple lines |
shekar123
Replies: 13
Views: 4746
|
Forum: Utilities Posted: Wed Apr 20, 2022 10:59 am Subject: Pulling one line of output multiple lines |
Kolusu
First of all extremely sorry . This is a new LPAR and new access setup.I did not check what SORT product is being used.I was in assumption that DFSORT is being used . I now see that
SYNC ... |
Topic: Pulling one line of output multiple lines |
shekar123
Replies: 13
Views: 4746
|
Forum: Utilities Posted: Tue Apr 19, 2022 10:57 pm Subject: Pulling one line of output multiple lines |
Kolusu
Thank you so much for your help. I tried my best from my end but could not. Amazing solutions.
The DISPLAY report came perfect
Organization . . . : PS
Record format . . . : FBA ... |
Topic: Pulling one line of output multiple lines |
shekar123
Replies: 13
Views: 4746
|
Forum: Utilities Posted: Tue Apr 19, 2022 1:03 pm Subject: Pulling one line of output multiple lines |
I have a requirement to run a -DISPLAY BUFFERPOOL command in DB2 and capture ALLOCATED value.However the output displays two times ALLOCATED = and I am interested in capturing the first line out ... |
Topic: Convert Julian date to a new format |
shekar123
Replies: 11
Views: 4603
|
Forum: Utilities Posted: Sat Oct 28, 2017 12:21 am Subject: Convert Julian date to a new format |
Thanks Kolusu for helping me further. I was not able to make use of _ in my code while testing for the TESTING1 and TESTING2 , so my output I made them not to use _
With your code I am able to a ... |
Topic: Convert Julian date to a new format |
shekar123
Replies: 11
Views: 4603
|
Forum: Utilities Posted: Thu Oct 26, 2017 6:21 am Subject: Convert Julian date to a new format |
Kolusu,
I tailored code changes as suggested by you and I was able to get the desired results.
Input records
D17246Â T193102 WEEKLYÂ Â Â Â 1Â Â 2Â Â 3Â Â TEST1 ... |
Topic: Convert Julian date to a new format |
shekar123
Replies: 11
Views: 4603
|
Forum: Utilities Posted: Wed Oct 25, 2017 1:38 pm Subject: Convert Julian date to a new format |
Kolusu,
First of all thanks for your help and I really apologize that I was not clear. I was in the assumption that the solution will work with those kind of records. I should have been clear on th ... |
Topic: Convert Julian date to a new format |
shekar123
Replies: 11
Views: 4603
|
Forum: Utilities Posted: Wed Oct 25, 2017 7:30 am Subject: Convert Julian date to a new format |
Kolusu,
Please see my input and the output which I have got when I have multiple records
//**********************************************************************
//STEP010 EXEC PGM=SORT ... |
|