Problem occurs while creating Dynamic Control card

ramfrom84 · New User Joined: 23 Aug 2006 Posts: 93 Location: chennai

Hi All,

In sort Fields , creating Dynamic compare option we have ' in the input fields how it can be taken .
For example
SORT FIELDS=COPY

Field - I taken from one input File

OUTFIL FILES=03,
INCLUDE=(5,10,CH,LT,C'5ML'ANGELO')

Field - II taken from pther input File

OUTFIL FILES=04,
INCLUDE=
(5,10,CH,LT,C'5ML'ANGELO')

While compare both fields in the Using SORT it show error since there is " ' " in the compare fields , Compare option fails .How to solve this problem .Please help.

Note: It should be solved in Dynamic Control card.

murmohk1 · Posted: Mon Feb 12, 2007 6:37 pm

Use two single apostrophe in place of 1 like

INCLUDE=(5,10,CH,LT,C'5ML''ANGELO')

Hope this solves your problem.

ramfrom84 · New User Joined: 23 Aug 2006 Posts: 93 Location: chennai

Thanks for reply ,Since it is Dynamically Creating the Control card , First we identify the Symbol "'". IF we Put Double Quotes then the input Filed Size will increase it ll affect the already existing logic for comparing other records.

Frank Yaeger · Posted: Mon Feb 12, 2007 9:49 pm

ram,

I have no idea what you meant by your last post. You asked how to code an apostrophe in a literal for INCLUDE. murmohk1 correctly told you that you must use two apostrophes for each apostrophe in a literal and showed an example. It's not clear what your references to dynamically creating the control statement, double quotes and the file size have to do with this. You need to explain what you're doing more clearly and what you see as the problem with using two apostrophes for one apostrophe in a literal before anyone can help you further.