Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: Invoking few queries when a session is invoked

    Hi,

    When I invoke a session in Sybase, I would to create few temp tables. I have got the queries in a file. Is there any way to invoke these queries (Creating Temp tables) whenever I invoke a session.

    Any suggestion/guidence would be greatefully received.

    Regards,
    SAM

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    Can you pls. provide the exact scenario, like if you are using unix shell scripting to do isql or GUI tool, etc. Accordingly someone will respnond to your question.

  3. #3
    Join Date
    Mar 2004
    Posts
    205
    Hi,

    Let me be more specific. I have to maintain few records in a temporary table which is specific to a user and that session. So when ever user invokes a session, he has to execute the create statement to create the temporary tables and then perform DML queries. Instead is there any way out to automatically execute create statements whenever user invokes a session. For instance in Oracle the queries present in login.sql will be executed whenever user connects Oracle through SQL Plus.

    Regards,
    SAM

  4. #4
    Join Date
    Nov 2002
    Posts
    207

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •