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 for Me (Login required).

Search for additional results

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