Author |
Message |
Topic: How to JOIN 2 different file with out any common column. |
hisabarinath
Replies: 4
Views: 2674
|
Forum: Utilities Posted: Wed Apr 22, 2009 4:12 pm Subject: How to JOIN 2 different file with out any common column. |
Pefect. Thanks again Kolusu. Can you please explain us that how this is working? We can develop, if we are getting anything similar to that. |
Topic: Removes spaces between a text string and a delimiter |
hisabarinath
Replies: 12
Views: 12151
|
Forum: Utilities Posted: Wed Apr 22, 2009 3:10 pm Subject: Removes spaces between a text string and a delimiter |
Kolusu - You always Great... I have to find another vocabulary to prize/proud you. Thank you so much. |
Topic: How to JOIN 2 different file with out any common column. |
hisabarinath
Replies: 4
Views: 2674
|
Forum: Utilities Posted: Wed Apr 22, 2009 3:05 pm Subject: How to JOIN 2 different file with out any common column. |
Thanks Kolusu, I'm getting the following syntax error...
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 16:02 ON WED A
OPTION EQUALS ... |
Topic: Removes spaces between a text string and a delimiter |
hisabarinath
Replies: 12
Views: 12151
|
Forum: Utilities Posted: Wed Apr 22, 2009 2:54 pm Subject: Removes spaces between a text string and a delimiter |
The SYSIN i have used..
//SYSIN DD *
SORT FIELDS=COPY
INREC OVERLAY=(10,70,SQZ=(SHIFT=LEFT)) ... |
Topic: Removes spaces between a text string and a delimiter |
hisabarinath
Replies: 12
Views: 12151
|
Forum: Utilities Posted: Wed Apr 22, 2009 2:53 pm Subject: Removes spaces between a text string and a delimiter |
Yes, i run with OVERLAY=(Start Positioin, Length,SQZ...) But the output record writes only starts from Starting Postion, NOT the entire 80 Byte record length. |
Topic: How to JOIN 2 different file with out any common column. |
hisabarinath
Replies: 4
Views: 2674
|
Forum: Utilities Posted: Wed Apr 22, 2009 1:54 pm Subject: How to JOIN 2 different file with out any common column. |
Can we join the below different Lrecl and record into a single file with out any common column. The thing is File-1 and File-2's counts are same. File-1's first record should map with File-2's first r ... |
Topic: Removes spaces between a text string and a delimiter |
hisabarinath
Replies: 12
Views: 12151
|
Forum: Utilities Posted: Wed Apr 22, 2009 1:39 pm Subject: Removes spaces between a text string and a delimiter |
Thanks Kolusu. This way the output file that we are getting from position 'p' but i need the entire 80 byte record NOT from starting position 'p' |
Topic: Removes spaces between a text string and a delimiter |
hisabarinath
Replies: 12
Views: 12151
|
Forum: Utilities Posted: Wed Apr 22, 2009 1:18 pm Subject: Removes spaces between a text string and a delimiter |
Kolusu - I'm unable to get the solution. By using this logic FINDREP
Going back to your simple logic
INREC BUILD=(1,80,SQZ=(SHIFT=LEFT))
Are there any way that i can skip the first filed by u ... |
Topic: Removes spaces between a text string and a delimiter |
hisabarinath
Replies: 12
Views: 12151
|
Forum: Utilities Posted: Wed Apr 22, 2009 11:36 am Subject: Removes spaces between a text string and a delimiter |
Great Kolusu.. Thanks.
But the problem is, if there is any spaces in between the field1's or Field2's.. String that is also removed from your Code, But we dont want to remove any space between the ... |
Topic: Removes spaces between a text string and a delimiter |
hisabarinath
Replies: 12
Views: 12151
|
Forum: Utilities Posted: Wed Apr 22, 2009 10:45 am Subject: Removes spaces between a text string and a delimiter |
How to remove spaces between a text String and the Pipe ('|') delimiter. I have the input file like below. The Input file is a 80 byte FB record.
Input file
AAA |CCCC |56789 |RRRR|
AAATT |X ... |
Topic: Mainframe Screen Size and screen fit in the window |
hisabarinath
Replies: 2
Views: 6781
|
Forum: TSO and ISPF Posted: Tue Apr 14, 2009 4:05 pm Subject: Mainframe Screen Size and screen fit in the window |
I have 2 basic Questions
1. In Endevor - Compile Batch screen. I want to increse the JOB statement line from 2 to 4. ie., i'm unable to see the rest of the line in the JOB statement. How to reduce ... |
Topic: Merge the records based on the Span-date |
hisabarinath
Replies: 4
Views: 3060
|
Forum: Utilities Posted: Mon Apr 13, 2009 12:52 am Subject: Merge the records based on the Span-date |
Kolusu - You always great... Thank you somuch. |
Topic: Merge the records based on the Span-date |
hisabarinath
Replies: 4
Views: 3060
|
Forum: Utilities Posted: Sat Apr 11, 2009 11:46 pm Subject: Merge the records based on the Span-date |
We have input dataset with 80 byte size and it is sorted based on C1, C2, C3 as ASC and C4 as DESC. C4 is a Span Start date which has multiple Span Start date. And C5 is the span-end date. So, we have ... |
Topic: How to Convert DB2 table data to a 2 Dimensional COBOL Array |
hisabarinath
Replies: 21
Views: 12191
|
Forum: Application Programming Posted: Sat Apr 11, 2009 9:21 pm Subject: How to Convert DB2 table data to a 2 Dimensional COBOL Array |
Perfect. Thank you verymuch haatvedt... |
Topic: How to Convert DB2 table data to a 2 Dimensional COBOL Array |
hisabarinath
Replies: 21
Views: 12191
|
Forum: Application Programming Posted: Fri Apr 10, 2009 5:31 pm Subject: How to Convert DB2 table data to a 2 Dimensional COBOL Array |
OK.Thanks Jsharon1248. I think, Option 2 would suit. Can you explain in-detail. |
|