illegal character in sql statement (#202) in kind of using SAP 
Author Message
 illegal character in sql statement (#202) in kind of using SAP

Hi,

i'm using informix dynamic server in release 7.30 UC5 and i wish to make a
complete copy from a R/3-Database (4.0b).
In this case i  have 2 problems.:

1.)
When (e.g.) i will use the following statements to build an index on the new
system.:

Quote:
>> create unique index "sapr3".apqi~1 on "sapr3".apqi (qid); <<

The tilde ("~") in the index name produce the sql error 202 (An illegal
character has been found in the statement.)
How can i 'tell the database' to create a such index with the special
character "~"?

2.)
There are problems to create any views (e.g.).:

Quote:
>> create view "sapr3".otr_jo01 (objctyp, ..., "text") as select x1.objctyp

,... where ( x1.guid = x0.guid );
The string ("text") are interpreted as a reserved string for informix. There
comes the error message 201
(A syntax error has occurred.)

How can i solve this problems?
Can anybody help?
/Thanks from Peter



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Error -202: An illegal character has been found...

2. Using non-ascii characters in querys (sql-error 202)

3. illegal character error with INSERT statement and &BIND

4. Question on SQL error Message 202, unable to open table

5. SQL illegal character question

6. SQL illegal character question

7. OCI8: illegal characters in SQL

8. Illegal Characters in SQL

9. Using special characters in SQL statement

10. Using non-ascii characters in sql statement via OCI

11. Event ID 202 on Win2K AS

12. Error 202


 
Powered by phpBB® Forum Software