I’m working on a IBM iseries v6r1m0 system.
I’m trying to execute a very simple query :
select * from XG.ART where DOS = 998 and (DES like 'ALB%' or DESABR like 'ALB%')
The columns are:
DOS -> numeric (3,0)
DES -> Graphic(80) CCSID 1200
DESABR -> Garphic(25) CCSID 1200
I get :
SQL State : 58004
SQL Code : -901
Message : [SQL0901] SQL System error.
Cause . . . . . : An SQL system error has occurred. The current SQL statement cannot be completed successfully. The error will not prevent other SQL statements from being processed. Previous messages may indicate that there is a problem with the SQL statement and SQL did not correctly diagnose the error. The previous message identifier was CPF4204. Internal error type 3107 has occurred. If precompiling, processing will not continue beyond this statement.
Recovery . . . : See the previous messages to determine if there is a problem with the SQL statement. To view the messages, use the DSPJOBLOG command if running interactively, or the WRKJOB command to view the output of a precompile. An application program receiving this return code may attempt further SQL statements. Correct any errors and try the request again.
If I change DES into REF (graphic(25)), it works…
EDIT :
I run some tests this afternoon, and it is very strange :
Just after the creation of the table/indexes, I have no errors.
- If I insert some datas : error
- If I clear the table : error
- If I remove an index (see below) : it works (with or without datas)
!!
The index is :
create index XG.GTFAT_ART_B on XG.ART(
DOS,
DESABR,
ART_ID
)
Edit 2 :
Here is the job log (sorry, it is in French…)
It sais :
Function error X'1720' in machine instruction. Internal snapshot ID 01010054
Foo file created in library QTEMP.
*** stuff with the printer
DBOP *** FAILED open. Exception from call to SLIC$
Internal error in the query processor file
Sql system error
The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.
When you use Ole DB Provider for DB2 (DB2OLEDB) or ODBC Driver for DB2 on an IBM iSeries V5R2 system, the INSERT statement, the UPDATE statement, and the DELETE statement may not succeed, and you may receive the following error:
SQLSTATE: 58004, SQLCODE: -901
Symptoms
This behavior occurs because a problem in the Distributed Relational Database Architecture (DRDA) handling of the V5R2 OS/400 operating system was causing the error to be returned from the host system. This problem was corrected in OS/400 PTF SI08923.
For more information about this fix, contact IBM.
Cause
For information about how to contact the third-party companies mentioned in this article, visit the following Microsoft Web site:
http://support.microsoft.com/gp/vendors
More Information
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
I’m working on a IBM iseries v6r1m0 system.
I’m trying to execute a very simple query :
select * from XG.ART where DOS = 998 and (DES like 'ALB%' or DESABR like 'ALB%')
The columns are:
DOS -> numeric (3,0)
DES -> Graphic(80) CCSID 1200
DESABR -> Garphic(25) CCSID 1200
I get :
SQL State : 58004
SQL Code : -901
Message : [SQL0901] SQL System error.
Cause . . . . . : An SQL system error has occurred. The current SQL statement cannot be completed successfully. The error will not prevent other SQL statements from being processed. Previous messages may indicate that there is a problem with the SQL statement and SQL did not correctly diagnose the error. The previous message identifier was CPF4204. Internal error type 3107 has occurred. If precompiling, processing will not continue beyond this statement.
Recovery . . . : See the previous messages to determine if there is a problem with the SQL statement. To view the messages, use the DSPJOBLOG command if running interactively, or the WRKJOB command to view the output of a precompile. An application program receiving this return code may attempt further SQL statements. Correct any errors and try the request again.
If I change DES into REF (graphic(25)), it works…
EDIT :
I run some tests this afternoon, and it is very strange :
Just after the creation of the table/indexes, I have no errors.
- If I insert some datas : error
- If I clear the table : error
- If I remove an index (see below) : it works (with or without datas)
!!
The index is :
create index XG.GTFAT_ART_B on XG.ART(
DOS,
DESABR,
ART_ID
)
Edit 2 :
Here is the job log (sorry, it is in French…)
It sais :
Function error X'1720' in machine instruction. Internal snapshot ID 01010054
Foo file created in library QTEMP.
*** stuff with the printer
DBOP *** FAILED open. Exception from call to SLIC$
Internal error in the query processor file
Sql system error
|
|||
ВосточныйПарень
18.07.06 — 12:08 |
Подключаюсь из 1С к базе интербейс через ИБ-провайдера (фри), там есть представление, запрашиваю у него все поля и задаю условие даты. Пока обкатывал на своем компе (Интербейсовая база стояла у меня) все было нормалек, прописал пути на сервер — вылезла ошибка: |
||
Вильям
1 — 18.07.06 — 12:16 |
Ниче в этом не понимаю, но Яндекс вроде рулит: |
||
Кецалькоатль 2 — 18.07.06 — 12:22 |
>> feature is not supported |
TurboConf — расширение возможностей Конфигуратора 1С