Originally posted by: SystemAdmin

I am using WTX 8.1 (Build 114) to select rows from a view in an Oracle 8.1.7.4.0 database. I used the Database Interface Designer to generate the type tree, with Dates as text items. Later in the process, I want to use the date columns as parameters for a call to another procedure (as text so there's no transformation).

But, WTX doesn't appear to be reading the DATE columns correctly. The log indicates that all the other columns get a "buffer" that is slightly larger than the column length, but the two DATE cols are different. From the log:

Database adapter: Oracle9i Version 8.1(114)
Starting a database unload...
Query : SELECT *
FROM maximo.v_wofis_WTX
Context: Input Card, Transaction scope: Map
On Failure: Rollback, On Success: Keep
AUDIT command specified, file: audit.dbl
TRACE command specified, file: E:\SRPApps\PGMS\Poller\TIDWOFIS_MAXIMO_LOAD.dbl
Statement execution succeeded.
The columns are of the following types:
Column 1 (WONUM) type is VARCHAR(10).
Column 2 (STATUS) type is VARCHAR(8).
Column 3 (ACTSTART) type is DATE.
Column 4 (WOEQ1) type is VARCHAR(5).
Column 5 (WOPM2) type is VARCHAR(3).
Column 6 (DESCRIPTION) type is VARCHAR(50).
Column 7 (WOEQ14) type is VARCHAR(13).
Column 8 (STATUSDATE) type is DATE.
Column 9 (WO10) type is VARCHAR(8).
Number of buffers in fetch array = 461
Column 1 (WONUM): buf=0x284cf8 size=11 colLen=10
Column 2 (STATUS): buf=0x2860d8 size=9 colLen=8
Column 3 (ACTSTART): buf=0x287120 size=19 colLen=19
Column 4 (WOEQ1): buf=0x289368 size=6 colLen=5
Column 5 (WOPM2): buf=0x289e48 size=4 colLen=3
Column 6 (DESCRIPTION): buf=0x28a590 size=51 colLen=50
Column 7 (WOEQ14): buf=0x290178 size=14 colLen=13
Column 8 (STATUSDATE): buf=0x291ac0 size=19 colLen=19
Column 9 (WO10): buf=0x293d08 size=9 colLen=8
Writing results to a buffer.
Retrieved 9 records (591 bytes).
Returned status: (0) Success

When I kick the results of the read out to a file, instead of calling the database ... the dates are coming out as bizarre collections of data: 'xl' or 'xl 7'

Anyone seen this and fixed it? Know what we can do to get the DATEs from Oracle correctly?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

You might want to try explicitly casting the date to character using to_char() or similar in your SQL statement, since it seems to want to bring it back as binary.

Jesse
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: SystemAdmin

Thanks, Jesse. That's exactly what we've done. The source data (a view) has been changed to convert the dates into VARCHAR format since we go on in the processing to treat it as text data anyway.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender