[Solved] Calling a stored procedure

[naeempk]

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

[yvonne.milne]

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

[naeempk]

Hi,

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

[yvonne.milne]

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

[naeempk]

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