Author |
Message |
Topic: Parse in DFSORT |
gordonstaylor
Replies: 10
Views: 13460
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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 ... |
|