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 6 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Parse in DFSORT
gordonstaylor

Replies: 10
Views: 13460

PostForum: Utilities   Posted: Fri Jul 06, 2007 9:19 am   Subject: Parse in DFSORT
dbzTHEdinosauer,

Not quite, consider the following

00,20070706
01,-123.45,Text with no punctuation,789,"Text with ""lots"", of stuff"
01,-77.90,Text with nowt,1, ...
  Topic: Parse in DFSORT
gordonstaylor

Replies: 10
Views: 13460

PostForum: Utilities   Posted: Fri Jul 06, 2007 5:43 am   Subject: Parse in DFSORT
Thanks for feedback guys, I appreciate your effort.

Maybe a little bit more background is appropriate here. If the opening gambit of mine was quite big as it was!! So....

The problem is I have ...
  Topic: Parse in DFSORT
gordonstaylor

Replies: 10
Views: 13460

PostForum: Utilities   Posted: Thu Jul 05, 2007 8:39 am   Subject: Parse in DFSORT
dbzTHEdinosauer,

The value "ADDED" is not a separate field.

The field value is
WITH EXTRA DATA"ADDED"

So in a csv file, in case it has commas in the value, quotes in the ...
  Topic: Parse in DFSORT
gordonstaylor

Replies: 10
Views: 13460

PostForum: Utilities   Posted: Thu Jul 05, 2007 8:14 am   Subject: Parse in DFSORT
Kolusu,

Pairs of quotes removed (", as opposed to apostrophe ') , to be replaced by one.

A double quote represents one quote of real data when they are delimited by a pair of quotes. Delim ...
  Topic: Parse in DFSORT
gordonstaylor

Replies: 10
Views: 13460

PostForum: Utilities   Posted: Thu Jul 05, 2007 7:07 am   Subject: Parse in DFSORT
I have a number of requirements for parsing comma separated value(CSV) files sourced from other platforms on the mainframe, and vice versa.

The Smart DFSORT Tricks documents Deconstruct and reconst ...
  Topic: Initiate JOBTRAC schedule via MQ
gordonstaylor

Replies: 0
Views: 963

PostForum: Utilities   Posted: Mon Jun 04, 2007 4:41 am   Subject: Initiate JOBTRAC schedule via MQ
I have a query relating to CA JOBTRAC.

The problem is
1. Have a message on MQ that will have an ID in it.
2. An IMS transaction or DB2 Stored Procedure will run on the m/f as a result of the MQ ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group