IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
Back to discussions
Expand all | Collapse all

Select Querry limits for WTX on Zos

  • 1.  Select Querry limits for WTX on Zos

    Posted 05/13/09 06:56 AM

    Originally posted by: Greenspan


    Hi,

    We are using a select on a large table for a map that is intended to run on zOS. In the MDQ file the following querry works fine.The table has nearly 400 columns.

    SELECT * from FROM #SUBSYSTEM#.REPORT_DETAILS
    WHERE RPT_ID = '#RPTID#' AND
    RPT_NO ='#RPTNO#' AND
    STATUS='SENT'
    WITH UR

    however whenever we use the following the job abends.

    SELECT RPT_ID,
    RPT_NO,
    ....
    ....
    300 columns
    ...
    ...
    ...
    STATUS
    FROM #SUBSYSTEM#.REPORT_DETAILS
    WHERE RPT_ID = '#RPTID#' AND
    RPT_NO ='#RPTNO#' AND
    STATUS='SENT'
    WITH UR

    The abend is also quite peculiar . here is the abend code display

    CEE0374C CONDITION=CEE3202S TOKEN=00030C82 59C3C5C5 00000000
    WHILE RUNNING PROGRAM UNKNOWN
    AT THE TIME OF INTERRUPT
    PSW 078D0400 95C9E3DE
    GPR 0-3 00000000 28817424 290BD3A8 00000400
    GPR 4-7 29200B40 2907F500 28C131D8 15C9E3D4
    GPR 8-B C46DC2D9 D5C3C86D D3D6C3F3 6B15C4D6
    GPR C-F 2881CA10 00000000 2D99B7D8 292017F0

    I looked for the condition CEE3202S but did not get too far. The abend points to something related to memory . It works fine when We run the map via ODBC connection to DB2.

    Anybody faced the same problems ?

    Thanks and regards

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


Related Content