To Database Pass, Create Table, Weird Error

brandonbollin — Mon, 09 May 2016 20:12:22 GMT

Hello all. I'm trying to create a table with a To Database pass. According to SAP documentation, if you use a To Database pass and the specified Database table name doesn't exist, IDM will create it. That doesn't appear to be happening here. I'm also dropping the table before that pass runs as I want a fresh table every time. Don't know if that counts for anything or not but, thought I would mention it.

I know the SQL query in my Source tab works because if I use this same query in a To ASCII pass, no problems. Let me know if you know what this error message means and if you can help me understand why IDM won't create this table. Thanks.

Re: To Database Pass, Create Table, Weird Error

brandonbollin — Mon, 09 May 2016 20:46:43 GMT

I figured this out. In my Entry Script, my return line was:

return "";

I cannot return nothing in my Entry Script, I need to return Par.

return Par;

Once I did that, everything started working.

Question Re: To Database Pass, Create Table, Weird Error in Technology Q&A

To Database Pass, Create Table, Weird Error

Re: To Database Pass, Create Table, Weird Error