How resolve the sql code -104

janardhana Reddy · New User Joined: 20 Oct 2004 Posts: 17 Location: Bangalore

Hi all

I am facing the problem in resolving the problem in resolving the sl code -104. It will say that illegal characters found in the query.

nothing wrong with the query.

Can any one provide the solution for this.

Thanks
Janardhan

janardhana Reddy · New User Joined: 20 Oct 2004 Posts: 17 Location: Bangalore

ConnoisseuR · New User Joined: 06 Aug 2004 Posts: 8 Location: india

can yu plz provide the query........

santosh

ConnoisseuR · New User Joined: 06 Aug 2004 Posts: 8 Location: india

can yu plz provide the query........

santosh

janardhana Reddy · New User Joined: 20 Oct 2004 Posts: 17 Location: Bangalore

Hi all,

Plz find Query

Select se_number_cd, doing_business_as from Se_number
where p_servicing_business_center = 90;

the query giving the result when running through QMF. For one run we are running the same query using jcl. In the production giving SQL code as
-104.

premaravi · New User Joined: 24 Nov 2004 Posts: 3

hi reddy,

in ur query the error is the column length is more than 18 characters.

premaravi

premaravi · New User Joined: 24 Nov 2004 Posts: 3

premaravi · New User Joined: 24 Nov 2004 Posts: 3

sivatechdrive · Posted: Wed Dec 08, 2004 9:33 am

the subsystems used in production region may be different from test region

the new version of db2 supports 30 length for column but the older versions doesn't

******************************
Thanks
Siva