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 37 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: How to JOIN 2 different file with out any common column.
hisabarinath

Replies: 4
Views: 2674

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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.
 
Page 1 of 3 Goto page 1, 2, 3  Next
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group