sp_iqhelp on an object with special characters

[Former Member]

Hi All,

As you know SAP tables names have special characters like below.

/BIC/ABC.

when i run sp_iqhelp on the object name like below it doesnt work,

sp_iqhelp '<SCHEMA NAME>'.'/BIC/ABC'

Syntax error near '/' on line 1

  SQLCODE=-131, ODBC 3 State="42000"

How should i run on the tables with special characters. Any help please would be appreciated.

[saroj_bagai · Accepted solution]

dbisql -c 'dsn=vicky_iqdemo11' -nogui
(DBA)> create table [/bic/test] ( a char)Execution time: 0.213 seconds
(DBA)> sp_iqhelp [/bic/test]

exists_obj = 1f1                                                                                                                                                                                                                                                               f2                                                                                                                                                                                                                                                               f3                                                                                                                                                                                                                                                               f4                                                                                                                                                                                                                                                               f5                                                                                                                                                                                                                                                               f6                                                                                                                                                                                                                                                               f7                                                                                                                                                                                                                                                               f8                                                                                                                                                                                                                                                               f9                                                                                                                                                                                                                                                               f10                                                                                                                                                                                                                                                              f11                                                                                                                                                                                                                                                              f12                                                                                                                                                                                                                  ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------                                                                                                                                                                                                                                                                                                                                                                                                                             Table_name                                                                                                                                                                                                                                                       Table_owner                                                                                                                                                                                                                                                      Server_type                                                                                                                                                                                                                                                      Location                                                                                                                                                                                                                                                         dbspace_id                                                                                                                                                                                                                                                       isPartitioned                                                                                                                                                                                                                                                    Remarks                                                                                                                                                                                                                                                          table_constraints                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        ==========                                                                                                                                                                                                                                                       ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              /bic/test                                                                                                                                                                                                                                                        DBA                                                                                                                                                                                                                                                              IQ                                                                                                                                                                                                                                                               Main                                                                                                                                                                                                                                                             16387                                                                                                                                                                                                                                                            N                                                                                                                                                                                                                                                                (NULL)                                                                                                                                                                                                                                                           (NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   column_name                                                                                                                                                                                                                                                      domain_name                                                                                                                                                                                                                                                      width                                                                                                                                                                                                                                                            scale                                                                                                                                                                                                                                                            nulls                                                                                                                                                                                                                                                            [default]                                                                                                                                                                                                                                                        cardinality                                                                                                                                                                                                                                                      isPartitioned                                                                                                                                                                                                                                                    remarks                                                                                                                                                                                                                                                          [check]                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                ==========                                                                                                                                                                                                                                                       ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                                                                                                                                                                                                                                           a                                                                                                                                                                                                                                                                char                                                                                                                                                                                                                                                             1                                                                                                                                                                                                                                                                0                                                                                                                                                                                                                                                                Y                                                                                                                                                                                                                                                                (NULL)                                                                                                                                                                                                                                                           0                                                                                                                                                                                                                                                                N                                                                                                                                                                                                                                                                (NULL)                                                                                                                                                                                                                                                           (NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 index_name                                                                                                                                                                                                                                                       column_name                                                                                                                                                                                                                                                      index_type                                                                                                                                                                                                                                                       unique_index                                                                                                                                                                                                                                                     location                                                                                                                                                                                                                                                         remarks                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ==========                                                                                                                                                                                                                                                       ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                      ===========                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                ASIQ_IDX_T812_C1_FP                                                                                                                                                                                                                                              a                                                                                                                                                                                                                                                                FP                                                                                                                                                                                                                                                               N                                                                                                                                                                                                                                                                Main                                                                                                                                                                                                                                                             (NULL)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
(12 rows)
Execution time: 0.292 seconds
(DBA)>

[Former Member · Accepted solution]

Hi Saroj,

Thank you so much for the help.