Search found 12 matches

by subasu
Sun Apr 26, 2009 10:26 am
Forum: DFSORT , ICETOOL & Utilities
Topic: File Split using DFSORT
Replies: 8
Views: 14551

Hi Frank, Let me try and explain in more detail. There are 2 blocks in the input file, one is a block of resource and another is a block of data, which are separated by the four tags as described above, a tag depicting the first 3 chars in the record... X'D3....' are hex values of the first record o...
by subasu
Fri Apr 24, 2009 11:23 am
Forum: DFSORT , ICETOOL & Utilities
Topic: File Split using DFSORT
Replies: 8
Views: 14551

Split an input file into an O/P file depending on tags

Hi, My input file is of the following format ( VBM,LRECL-32000) X'D3A8C6' ---- resource ---- resource ---- resource X'D3A9C6' X'D3A8A8' ---- data ---- data ---- data X'D3A9A8' I need my O/P file( VBM,LRECL-32000) to contain only X'D3A8A8' ---- data ---- data ---- data X'D3A9A8'. There are no specifi...
by subasu
Tue Apr 14, 2009 3:54 pm
Forum: JCL
Topic: Sending an Email from JCL with attachment
Replies: 36
Views: 90179

Natarajan, The following one worked. =============================================== HELO SYSA MAIL FROM:<XXXX@XXXX.COM> RCPT TO:<XXXXX@XXXXX.COM> DATA FROM: <XXXXXXX@XXXX.COM> TO: <XXXXXXX@XXXX.COM> SUBJECT: Test Mail for attachment and body MIME-Version: 1.0 Content-Type: MULTIPART/MIXED; boundary...
by subasu
Tue Apr 14, 2009 9:19 am
Forum: JCL
Topic: Sending an Email from JCL with attachment
Replies: 36
Views: 90179

Natarajan, I am still facing the same issue, the mail is delivered, but there is no attachment, instead i get the following in the mail. *********************************************************** Hi Nitin, This is the test for body of the email Thanks, Subhadeep Basu --SIMPLE BOUNDARY Content-Type:...
by subasu
Mon Apr 13, 2009 1:11 pm
Forum: JCL
Topic: Sending an Email from JCL with attachment
Replies: 36
Views: 90179

Email with attachmet

Natarajan, You JCL worked for an attachment. However, when I try to put in a body in the email like some written message, the attachment stops working. I am trying to put in the text/message between the SUBJECT and MINE-Version: 1.0. Please let me know if I am doing something wrong or suggest the co...
by subasu
Thu Mar 26, 2009 11:54 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Variable length field from a file using SORT
Replies: 15
Views: 22693

Thanks Frank... it worked.
by subasu
Wed Mar 25, 2009 11:43 am
Forum: DFSORT , ICETOOL & Utilities
Topic: Variable length field from a file using SORT
Replies: 15
Views: 22693

Thanks for your promt replies.... probably I should have stated my requirements more clearly for everyone's understnading... One file of FB/133 has the line which details the record count.... this count has to be picked up and replaced in another file FB/80. Input FIle: FB-133 ....... ......... Load...
by subasu
Tue Mar 24, 2009 3:39 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Variable length field from a file using SORT
Replies: 15
Views: 22693

I need this numeric value and replace this value in another file.
by subasu
Tue Mar 24, 2009 3:21 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Variable length field from a file using SORT
Replies: 15
Views: 22693

There is only 1 line in the dataset where the word "Loaded " is present begining from the 1st position... the one which I require. This is neither the first or last record. There will be only 1 such record in the file.
by subasu
Tue Mar 24, 2009 2:34 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Variable length field from a file using SORT
Replies: 15
Views: 22693

The specific line only has the below details:

"Loaded 47 rows into the database" ... this value 47 could be of variable length... it can be 7 or 47 or 847 or 9847 and so on....
by subasu
Tue Mar 24, 2009 2:29 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Variable length field from a file using SORT
Replies: 15
Views: 22693

It is a dataset... which has a number of records... one of its lines contains information on the number of rows loaded to a system.... I need this count... its a numeric field and has variable length.
by subasu
Tue Mar 24, 2009 1:21 pm
Forum: DFSORT , ICETOOL & Utilities
Topic: Variable length field from a file using SORT
Replies: 15
Views: 22693

Variable length field from a file using SORT

I have a requirement where I need to pick up a numeric value from a variable length field from a file. Is this possible using DFSORT? Like the in screenshot, the value 29 could be 329 or 2329 or 899033. There is no limit to the number.

"Loaded 29 rows into the database"