Skip to Content

bods: issue in sql transform in bods

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

go

capture.jpg (31.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 05 at 05:07 PM

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

    so i am closing this question.

    Add comment
    10|10000 characters needed characters exceeded