[unixODBC-support] Solaris Package

Iwashita, Hirofumi Hirofumi.Iwashita at ca.com
Fri Nov 16 05:06:49 GMT 2007


Hi,

Any suggestions?

Hirofumi
-----Original Message-----
From: Iwashita, Hirofumi 
Sent: Saturday, November 10, 2007 7:51 AM
To: Support for the unixODBC project
Subject: RE: [unixODBC-support] Solaris Package

Hi Experts,

Thank you for your good assistance. This problem solved but new problem
occurs.
The isql cannot read the csv file.

bash-2.05# isql -v CSV
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select * from YYY
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------------------------+------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------+
| **ERROR**
| **ERROR**
|
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------------------------+------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------+
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------------------------+------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------+
SQLRowCount returns 0
SQL>

The trace file is as follows.

bash-2.05# cat /tmp/sql.log
[ODBC][23941][__handles.c][444]
                Exit:[SQL_SUCCESS]
                        Environment = 264c0
[ODBC][23941][SQLAllocHandle.c][352]
                Entry:
                        Handle Type = 2
                        Input Handle = 264c0
[ODBC][23941][SQLAllocHandle.c][470]
                Exit:[SQL_SUCCESS]
                        Output Handle = 27668
[ODBC][23941][SQLConnect.c][3579]
                Entry:
                        Connection = 27668
                        Server Name = [CSV][length = 3 (SQL_NTS)]
                        User Name = [NULL]
                        Authentication = [NULL]
                UNICODE Using encoding ASCII 'char' and UNICODE
'UCS-2-INTERNAL'

[ODBC][23941][SQLConnect.c][4153]
                Exit:[SQL_SUCCESS]
[ODBC][23941][SQLAllocHandle.c][517]
                Entry:
                        Handle Type = 3
                        Input Handle = 27668
[ODBC][23941][SQLAllocHandle.c][1052]
                Exit:[SQL_SUCCESS]
                        Output Handle = 336f0
[ODBC][23941][SQLPrepare.c][192]
                Entry:
                        Statement = 336f0
                        SQL = [select * from YYY ][length = 18
(SQL_NTS)] [ODBC][23941][SQLPrepare.c][367]
                Exit:[SQL_SUCCESS]
[ODBC][23941][SQLExecute.c][183]
                Entry:
                        Statement = 336f0
[ODBC][23941][SQLExecute.c][344]
                Exit:[SQL_SUCCESS]
[ODBC][23941][SQLNumResultCols.c][149]
                Entry:
                        Statement = 336f0
                        Column Count = ffbff686
[ODBC][23941][SQLNumResultCols.c][234]
                Exit:[SQL_SUCCESS]
                        Count = ffbff686 -> 2
[ODBC][23941][SQLNumResultCols.c][149]
                Entry:
                        Statement = 336f0
                        Column Count = ffbff37e
[ODBC][23941][SQLNumResultCols.c][234]
                Exit:[SQL_SUCCESS]
                        Count = ffbff37e -> 2
[ODBC][23941][SQLColAttribute.c][277]
                Entry:
                        Statement = 336f0
                        Column Number = 1
                        Field Identifier = SQL_DESC_DISPLAY_SIZE
                        Character Attr = 0
                        Buffer Length = 0
                        String Length = 0
                        Numeric Attribute = ffbff1cc
[ODBC][23941][SQLColAttribute.c][648]
                Exit:[SQL_SUCCESS]
[ODBC][23941][SQLColAttribute.c][277]
                Entry:
                        Statement = 336f0
                        Column Number = 1
                        Field Identifier = SQL_DESC_LABEL
                        Character Attr = ffbff1d0
                        Buffer Length = 301
                        String Length = 0
                        Numeric Attribute = 0
[ODBC][23941][SQLColAttribute.c][648]
                Exit:[SQL_SUCCESS]
[ODBC][23941][SQLColAttribute.c][277]
                Entry:
                        Statement = 336f0
                        Column Number = 1
                        Field Identifier = SQL_DESC_LABEL
                        Character Attr = ffbff380
                        Buffer Length = 301
                        String Length = 0
                        Numeric Attribute = 0
[ODBC][23941][SQLColAttribute.c][648]
                Exit:[SQL_SUCCESS]
[ODBC][23941][SQLColAttribute.c][277]
                Entry:
                        Statement = 336f0
                        Column Number = 2
                        Field Identifier = SQL_DESC_DISPLAY_SIZE
                        Character Attr = 0
                        Buffer Length = 0
                        String Length = 0
                        Numeric Attribute = ffbff1cc
[ODBC][23941][SQLColAttribute.c][648]
                Exit:[SQL_SUCCESS]
[ODBC][23941][SQLColAttribute.c][277]
                Entry:
                        Statement = 336f0
                        Column Number = 2
                        Field Identifier = SQL_DESC_LABEL
                        Character Attr = ffbff1d0
                        Buffer Length = 301
                        String Length = 0
                        Numeric Attribute = 0
[ODBC][23941][SQLColAttribute.c][648]
                Exit:[SQL_SUCCESS]
[ODBC][23941][SQLColAttribute.c][277]
                Entry:
                        Statement = 336f0
                        Column Number = 2
                        Field Identifier = SQL_DESC_LABEL
                        Character Attr = ffbff380
                        Buffer Length = 301
                        String Length = 0
                        Numeric Attribute = 0
[ODBC][23941][SQLColAttribute.c][648]
                Exit:[SQL_SUCCESS]
[ODBC][23941][SQLNumResultCols.c][149]
                Entry:
                        Statement = 336f0
                        Column Count = ffbff37e
[ODBC][23941][SQLNumResultCols.c][234]
                Exit:[SQL_SUCCESS]
                        Count = ffbff37e -> 2
[ODBC][23941][SQLFetch.c][158]
                Entry:
                        Statement = 336f0 [ODBC][23941][SQLFetch.c][340]
                Exit:[SQL_NO_DATA]
[ODBC][23941][SQLRowCount.c][166]
                Entry:
                        Statement = 336f0
                        Row Count = ffbff5ec
[ODBC][23941][SQLRowCount.c][237]
                Exit:[SQL_SUCCESS]
                        Row Count = ffbff5ec -> 0
[ODBC][23941][SQLMoreResults.c][155]
                Entry:
                        Statement = 336f0
[ODBC][23941][SQLMoreResults.c][311]
                Exit:[SQL_ERROR]
                DIAG [-----] SQL_ERROR This function not supported

                DIAG [-----] hStmt = 2abe8

                DIAG [-----] SQL_SUCCESS

                DIAG [-----] hStmt = 2abe8

                DIAG [-----] END: No data.

                DIAG [-----] START: hStmt = 2abe8

                DIAG [-----] END: Success.

                DIAG [-----] START: hStmt = 2abe8

                DIAG [-----] END: Success.

                DIAG [-----] Value = BBB

                DIAG [-----] START: hStmt = 2abe8 nCol = 2 nAttribute =
18 pszValue = ffbff380 pnValueLength = 0

                DIAG [-----] END: Success.

                DIAG [-----] Value = BBB

                DIAG [-----] START: hStmt = 2abe8 nCol = 2 nAttribute =
18 pszValue = ffbff1d0 pnValueLength = 0

                DIAG [-----] END: Success.

                DIAG [-----] Value = 255

                DIAG [-----] START: hStmt = 2abe8 nCol = 2 nAttribute =
6 pszValue = 0 pnValueLength = 0

                DIAG [-----] END: Success.

                DIAG [-----] Value = AAA

                DIAG [-----] START: hStmt = 2abe8 nCol = 1 nAttribute =
18 pszValue = ffbff380 pnValueLength = 0

                DIAG [-----] END: Success.

                DIAG [-----] Value = AAA

                DIAG [-----] START: hStmt = 2abe8 nCol = 1 nAttribute =
18 pszValue = ffbff1d0 pnValueLength = 0

                DIAG [-----] END: Success.

                DIAG [-----] Value = 255

                DIAG [-----] START: hStmt = 2abe8 nCol = 1 nAttribute =
6 pszValue = 0 pnValueLength = 0

                DIAG [-----] END: Success.

                DIAG [-----] START: hStmt = 2abe8

                DIAG [-----] END: Success.

                DIAG [-----] START: hStmt = 2abe8

                DIAG [-----] SQL_SUCCESS

                DIAG [-----] END: Success.

                DIAG [-----] Adopting all columns in interim data set.

                DIAG [-----] Found 0 rows.

                DIAG [-----] END

                DIAG [-----] START: /home/iwahi01/csv/YYY

                DIAG [-----] END:

                DIAG [-----] START: /home/iwahi01/csv/YYY

                DIAG [-----] Reading desired rows into interim data set.

                DIAG [-----] xref-ing SELECT columns into interim column
headers.

                DIAG [-----] END:

                DIAG [-----] BBB

                DIAG [-----] AAA

                DIAG [-----] START: /home/iwahi01/csv/YYY

                DIAG [-----] END:

                DIAG [-----] START:

                DIAG [-----] START: Table = YYY

                DIAG [-----] hStmt = 2abe8

                DIAG [-----] SQL_SUCCESS

                DIAG [-----] hStmt = 2abe8

[ODBC][23941][SQLFreeStmt.c][140]
                Entry:
                        Statement = 336f0
                        Option = 1
[ODBC][23941][SQLFreeHandle.c][365]
                Entry:
                        Handle Type = 3
                        Input Handle = 336f0
[ODBC][23941][SQLFreeHandle.c][462]
                Exit:[SQL_SUCCESS]
bash-2.05#

Please give me your advice again.

Thanks,
Hirofumi
-----Original Message-----
From: unixodbc-support-bounces at easysoft.com
[mailto:unixodbc-support-bounces at easysoft.com] On Behalf Of Stefan
Radman
Sent: Friday, November 09, 2007 6:58 PM
To: Support for the unixODBC project
Subject: RE: [unixODBC-support] Solaris Package

Add-on to Nicks suggestion:

export LDFLAGS="-L/usr/ucblib -R/usr/ucblib -lucb"
./configure
make

That will help finding libucb in its Solaris default place during build
and runtime without having LD_LIBRARY_PATH set.

Stefan

_______________________________________________
unixODBC-support mailing list
unixODBC-support at easysoft.com
http://mail.easysoft.com/mailman/listinfo/unixodbc-support




More information about the unixODBC-support mailing list