2536085 - How to perform a 'select into' command in SQLScript DB - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2536085 - How to perform a 'select into' command in SQLScript DB - SAP ASE

Symptom

  • Even though a table is created by a 'select into' command successfully, you can't find the object in SQLScript DB.
    1> use db_sqlscript
    2> go
    1> select * from dbo.titles
    2> go
    Msg 208, Level 16, State 1:
    Server 'ase1603', Line 1:
    dbo.titles not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
  • But you can find the row for the object in sysobjects table.
    1> select * from sysobjects where name ='titles'
    2> go
    name                                                                                                                                                                                                                                                            id          uid         type userstat sysstat indexdel schemacnt sysstat2    crdate                          expdate                         deltrig     instrig     updtrig     seltrig     ckfirst     cache  audflags    objspare versionts                  loginame                       identburnmax                              spacestate erlchgts           sysstat3 lobcomp_lvl sysstat4 sysstat5   schemaid
    --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ---- -------- ------- -------- --------- ----------- ------------------------------- ------------------------------- ----------- ----------- ----------- ----------- ----------- ------ ----------- -------- -------------------------- ------------------------------ ----------------------------------------- ---------- ------------------ -------- ----------- -------- ---------- -----------
    titles                                                                                                                                                                                                                                                            880003135           1 U           0      67        0         0   134316032             Aug 29 2017  3:14PM             Aug 29 2017  3:14PM           0           0           0           0           0      0           0        0 NULL                       NULL                                                                NULL          1 0x0000000000000000        0           0        0          0           0

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03
  • SQLScript feature

Product

SAP Adaptive Server Enterprise 16.0

Keywords

  • 30006 , user-defined error exception, INTERNAL ERROR(17461)
, KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.