bods: issue in sql transform in bods

former_member186160 — Wed, 27 Dec 2017 09:56:52 GMT

hi all,

we are trying to use the sql server db concept of hash tables in bods sql transform.

below is a test script, it works fine when used in a script object in a bods DF, but when i use the hash tables concept inside a sql transform in bods, it gives out an error saying

"no columns found" [attached error message]

can anyone please suggest a solution to make this work?

here is a test script: [not the actual concept we are trying to implement but this is just a sample:

SET nocount ON

DECLARE @FirstTable TABLE (RandomInteger INT)

DECLARE @ii INT

BEGIN TRANSACTION

SET @ii = 0

WHILE @ii < 10

BEGIN

INSERT INTO @FirstTable VALUES (RAND() )

SET @ii = @ii + 1

END

SELECT COUNT(*) FROM @FirstTable first

Re: bods: issue in sql transform in bods

former_member186160 — Tue, 05 Feb 2019 17:07:11 GMT

looks like hash tables of sql not supported in bods sql transform.

so i am closing this question.

Re: bods: issue in sql transform in bods

jagadishdj1205 — Fri, 04 Aug 2023 07:15:33 GMT

Thank you for the infomation

Question Re: bods: issue in sql transform in bods in Technology Q&A

bods: issue in sql transform in bods

Re: bods: issue in sql transform in bods

Re: bods: issue in sql transform in bods