PM87323: UI PASTING BAD SYNTAX FOR ODBC READ OF POSTGRESQL DATABASE.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • You are trying to read a table from a PostgreSQL database and
    are  encountering an error after pasting the GET DATA syntax
    from the Statistics UI.  See the Syntax and error below:
    
    GET DATA
      /TYPE=ODBC
      /CONNECT='DSN=ASSET
    database;DATABASE=asset;SERVER=rcpch-asset-test.fry-it.com;PORT=
    5432;UID='+
        'odbc;PWD=6x>B3i0v-#!)#,$I
    
    '0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettin
    gs=;Fetch=100;Socket='+
    
    '4096;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;
    Debug=0;CommLog=0;Optimizer='+
    
    '0;Ksqo=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVa
    rchar=0;BoolsAsChar=1;Parse='+
    
    '0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;U
    pdatableCursors='+
    
    '1;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=
    0;UseServerSidePrepare='+
        '0;LowerCaseIdentifier=0;XaOpt=1'
      /SQL='SELECT "id", "name" FROM .app."start_subspeciality"'
      /ASSUMEDSTRWIDTH=255.
    
    Warning.  Command name: GET DATA
    SQLExecDirect failed :ERROR: syntax error at or near "."; Error
    while executing the query
    

Local fix

  • In this case  The problem appears to be the extra period (.)
    before the table name in the FROM clause.  Removing this extra
    period allows the syntax to work properly.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of SPSS Statistics and the PostGRE SQL database.       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * SPSS Statistics UI PASTING BAD SYNTAX FOR ODBC READ OF       *
    * POSTGRESQL DATABASE.                                         *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to SPSS Statistics 21.0 Fixpack 2 (21.0.0.2)          *
    ****************************************************************
    

Problem conclusion

  • Update to SPSS Statistics 21.0 Fixpack 2 (21.0.0.2)
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM87323

  • Reported component name

    SPSS STATISTICS

  • Reported component ID

    5725A54ST

  • Reported release

    L00

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-04-18

  • Closed date

    2013-11-27

  • Last modified date

    2013-11-27

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    SPSS STATISTICS

  • Fixed component ID

    5725A54ST

Applicable component levels

  • RL00 PSN

       UP

  • RL00 PSY

       UP

  • RM00 PSN

       UP

  • RM00 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

SPSS Statistics
Statistics Desktop

Software version:

21.0

Reference #:

PM87323

Modified date:

2013-11-27

Translate my page

Machine Translation

Content navigation