MVSFORUMS.com

Nancy · Beginner Joined: 23 May 2003 Posts: 77 Topics: 26

Any idea, why I am getting this JCL error while moving the program to Endevor ....

DSNH104I DSNHPARS ILLEGAL SYMBOL ",". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: + -

Guess it is something with the Profile option, but not very sure Sad

Regards
Nancy

kolusu · Posted: Tue May 16, 2006 6:54 am Post subject:

Nancy · Beginner Joined: 23 May 2003 Posts: 77 Topics: 26

Yes Kolusu, Its thrown at the below SQL but I could not find anything wrong with that.

kolusu · Posted: Tue May 16, 2006 7:18 am Post subject:

Nancy,

The compiler is complaining about a "," so it must be one of the columns in your select statement. So make sure that you spelled all the columns correctly matching your table layout.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Nancy · Beginner Joined: 23 May 2003 Posts: 77 Topics: 26

Yes, all the column names are correctly typed.
Actually I copied this SQL from a document and it is giving problem for the junk characters. But when I re-typed it manually on mainframe, it worked fine and moved to Endevor.
No idea what the reason is, again feel that something related to profile options. Earlier I used to do PACK OFF to get rid of these special chars but that is also not working now.

Regards

Nancy · Beginner Joined: 23 May 2003 Posts: 77 Topics: 26

Kolusu,

It worked for one of the program but now the same problem is coming to another two. Can you suggest something ? We have verified the SQL against Table and the column names look good.

Thanks

Cogito-Ergo-Sum · Posted: Wed May 17, 2006 12:15 pm Post subject:

Maybe, if you retyped manually for the other two programs.... ?
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.

semigeezer · Posted: Wed May 17, 2006 12:32 pm Post subject:

in ISPF, try typing F P'.' and see if there are invalid characters in the file that are not shown in the editor. If there are, use the command C P'.' ' ' ALL to convert them to spaces. Some emulators add bad characters if you 'paste' data into them. Also, if you edited the file on a PC and uploaded the file, you may have TAB characters that the PC knows about but that the host does not understand. Those may show up as X'05' characters at the host (use HEX ON to see).

Nancy · Beginner Joined: 23 May 2003 Posts: 77 Topics: 26

Thanks for your help.
Couldnt really identify the reason but programs are working now.

Cheers
Nancy