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

Thread: [Solved] Calling a stored procedure

  1. #11
    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,712
    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
    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,712
    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
    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

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