Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: [Solved] Calling a stored procedure

  1. #11
    Member
    Join Date
    Feb 2012
    Posts
    43
    Hi Yvonne Milne,

    1) Thanks for submitting the ticket for .dbo files execution.

    2) I am not asking about parameter passing to stored procedures. My question was to create temp tables or cursors which I can access when my SP finished. Like in MS SQL

    CREATE TABLE #people
    (
    id INT,
    name VARCHAR(32)
    )

    OR

    a temporary table available to a all sessions

    CREATE TABLE ##people
    (
    id INT,
    name VARCHAR(32)
    )


    3/4) I am using Lianja SQL server from the same LAN. How can I tell my network admin to setup IP/hostnames to reduce delay.

    Thanks

  2. #12
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,369
    Hi Naeempk,

    2. The TMPNAM() function will give you a temporary filename in the current temporary directory (default for Lianja Server is C:\lianja\server\tmp and for Lianja App Builder C:\Users\your-user\AppData\Local\Temp\ on Windows). You can use this with create table or select .. into table, e.g.

    mtmp = tmpnam()
    create table &mtmp (...)

    3/4 Try putting the IP/hostname mapping in the C:\Windows\System32\drivers\etc\hosts file on the client.

    Regards,

    Yvonne

  3. #13
    Member
    Join Date
    Feb 2012
    Posts
    43
    Hi,

    Any update regarding ticket submitted for .dbo files execution in latest release ?

  4. #14
    Lianja Team yvonne.milne's Avatar
    Join Date
    Feb 2012
    Location
    Berkshire, UK
    Posts
    1,369
    Hi Naeempk,

    The '.prg' does still need to be present for stored procedures. I will see if this can be scheduled for resolution.

    Regards,

    Yvonne

  5. #15
    Member
    Join Date
    Feb 2012
    Posts
    43
    Hi Yvonne,

    We have many Lianja releases but still we need '.prg' file to execute the stored procedures. Can this be resolved in near future ?

    Regards
    Naeem

Page 2 of 2 FirstFirst 12

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us