SQL Numeric value out of range error msg 1

[PeterG5]

Hi,
I'm new to all this SQL stuff, so any help is appreciated...
I get the following message when running the TEST5 fex.
It looks like some value is being exceeded somewhere.
There are 87 fields on the incoming FAT_BSE_SALES_ORDER
file, which is being read from DB2/NT via the ODBC client.

EX TEST5
(FOC1400) SQLCODE IS 31073 (HEX: 00007961)
: [22003] [IBM][CLI Driver] CLI0111E Numeric value out of range. SQLSTATE
: =22003 [22003] [IBM][CLI Driver] CLI0111E Numeric value out of range. S
: QLSTATE=22003
(FOC1407) SQL FETCH CURSOR ERROR. : ********

Test5 looke like this:

SQL ODBC
SELECT *
FROM FAT_BSE_SALES_ORDER
WHERE SO_ORDER_TYPE_ID LIKE 'SO%';

TABLE
ON TABLE HOLD AS PETER2
END
-RUN

 

[FOCMAN]

See this for error messages :

http://www-3.ibm.com/software/data/datajoiner/booksv2/djxp4m27.htm

I would not do a SELECT * but try each individual file
until you find the offending field i.e.

SELECT FIELD1,FIELD2 FROM .......

Maybe an ODBC issue.

Why not create a WebFOCUS synonym for your TABLE and report from it using WebFOCUS. It would not require WebFOCUS knowledge.

 

[PeterG5]

Hi FocMan,

Thanks for pointing me in the right direction!
The problem was the contents of 2 BIGINT fields on the table. I thought that I had TOO MANY incoming fields.
Yes, you can generate a Focus master file to map the DB2
table but BIGINT fields are not catered for (not in version 4.3.1) and are ignored; You can get around this by altering the master file and making them P15 fields but I was going the SQL route to avoid having to do this and also because if the underlying DB2 tables change, you must re-generate the master file. In view of the above, though, I may have to re-consider my strategy. Many Thanks again. Peter.