× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Take a look at the following:

% cat /QOpenSys/QIBM/ProdData/Node/os400/db2i/lib/db2.js

Aaron Bartell
litmis.com - Services for open source on IBM i


On Wed, Apr 6, 2016 at 3:41 PM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

From the docs:

1.3.23. fieldType

*Description:*

Returns the data type of the indicated column in a result set.

*Syntax:*

fieldType(int *Index*)

*Parameters **Index*:

*Index *is the column number in a result set, ordered sequentially left to
right, starting at 0.

*Return Object:*

It returns an *integer *value indicating the data type of the specified
column in the result set.

*DB2CLI API:*

SQLColAttribute

*Valid Scope:*

When the result set is available.

*Example:*

Refer to the *Basic Query* example.


This is great, but does anyone know where I can find a table that shows
what the values of the field types are? And if that list is one of
constants.. what their integer representation is?
--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.