1. Lucas Sdrolias
  2. PowerBuilder
  3. Tuesday, 1 May 2018 18:48 PM UTC

Hello,

I need to formulate a query with temporary tables and pass it to a DW to replace the original source. I am using the SNC client (Provider='SQLNCLI11')

For example

SELECT im_item
INTO #temp 
FROM im
WHERE im_type='07' 
 

SELECT a.im_item,im_title 
FROM im, #temp a
WHERE im.im_item = a.im_item

I use Autocommit=True but I get a weird behavior with StaticBind parameter. When I set it to 0 PB17 crashes, while when I set it to 1 the DW does not return any results.

The above works perfectly with the SYC client. We need to migrate all our applications from ASE to SQL Server.

Any help would be much appreciated.

Regards,

Lucas

Alfredo Aldama Accepted Answer Pending Moderation
  1. Friday, 1 June 2018 02:23 AM UTC
  2. PowerBuilder
  3. # 1

Hi,

another option is to use the database configuration, option -> ddl

sp_dboption [dbname, optname, optvalue [, dockpt]]

 

Regards !

 

 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.